[vc_section full_width=”stretch_row” css=”.vc_custom_1532085157436{margin-top: 0px !important;margin-bottom: 0px !important;padding-top: 0px !important;padding-bottom: 0px !important;background-color: #ffffff !important;}”][vc_row full_width=”stretch_row” css=”.vc_custom_1764825137098{margin-top: 0px !important;margin-bottom: 0px !important;padding-top: 40px !important;padding-bottom: 0px !important;}”][vc_column css=”.vc_custom_1764825118867{margin-top: 10px !important;padding-top: 0px !important;padding-bottom: 0px !important;}”][vc_column_text css=”.vc_custom_1764824000576{margin-top: 0px !important;margin-bottom: 35px !important;}” el_class=”text-block”]
Analytics on eBusiness Tax Brought Stability to P2P Invoice Processing Process
[/vc_column_text][vc_column_text css=”.vc_custom_1764824036417{margin-top: 0px !important;margin-bottom: 35px !important;}” el_class=”text-block”]Established in 1997, the client is a world leader in developing and commercializing first-or-best-in-class therapies for rare genetic diseases. Headquartered in California, US, the client has operations spread across 20+ countries and has 2500+ employees worldwide.[/vc_column_text][vc_column_text css=”.vc_custom_1764824226743{margin-top: 0px !important;margin-bottom: 35px !important;}” el_class=”text-block”]
Background
[/vc_column_text][vc_column_text css=”.vc_custom_1764824238185{margin-top: 0px !important;margin-bottom: 20px !important;}” el_class=”text-block”]The customer’s Finance team was using complex SQL packages and Excel macros and pivots for reporting on eBusiness Tax (tax on buying/selling of goods/services). However, it was facing multiple issues related to file transfer, file size, file location, frequent corruption of macros, etc. with the existing reporting tool. Further, the tool was not supported by the client’s IT department. Hence the client wanted to build this functionality in a reporting tool.
[/vc_column_text][vc_column_text css=”.vc_custom_1764824370408{margin-top: 0px !important;margin-bottom: 35px !important;}” el_class=”text-block”]
DiLytics’ Solution
[/vc_column_text][vc_column_text css=”.vc_custom_1764824441102{margin-top: 0px !important;margin-bottom: 10px !important;}” el_class=”text-block”]
DiLytics extended the current reporting solution in Oracle Analytics by:
[/vc_column_text][rt_list_style list_style=”seven” list_content=”
- List Item Text One
- List Item Text Two
- List Item Text Three
” list_css=”.vc_custom_1764824579734{margin-top: -5px !important;margin-bottom: 20px !important;padding-left: 35px !important;}” list_extra_class=”text-block”]
- Creating new tables and adding columns to existing tables in Enterprise Data Warehouse (EDW)
- Developing extract, transform and load (ETL) code using Informatica to extract data required for eBusiness Tax reporting from EBS into EDW staging tables
- Developing ETL code using Informatica to load data required for eBusiness Tax reporting from the EDW staging tables into Facts and dimensions
- Modeling the extended EDW tables in Oracle Analytics to create metrics and attributes
[/rt_list_style][vc_column_text css=”.vc_custom_1764824721055{margin-top: 0px !important;margin-bottom: 10px !important;}” el_class=”text-block”]
It has also provided reports on the following
[/vc_column_text][rt_list_style list_style=”seven” list_content=”
- List Item Text One
- List Item Text Two
- List Item Text Three
” list_css=”.vc_custom_1764824698384{margin-top: -5px !important;margin-bottom: 35px !important;padding-left: 35px !important;}” list_extra_class=”text-block”]
- Invoice Register Check
- Expected vs Effective
- Account Reconciliation
- CSUT NSA Detail & CSUT Self Assessed Detail
- Rec – VAT Detail
- IE VAT Summary
[/rt_list_style][vc_column_text css=”.vc_custom_1764824799286{margin-top: 0px !important;margin-bottom: 20px !important;}” el_class=”text-block”]
Business Benefits
[/vc_column_text][vc_column_text css=”.vc_custom_1764824930350{margin-top: 0px !important;margin-bottom: 10px !important;}” el_class=”text-block”]Key business benefits to the client included:[/vc_column_text][rt_list_style list_style=”seven” list_content=”
- List Item Text One
- List Item Text Two
- List Item Text Three
” list_css=”.vc_custom_1764824984415{margin-top: 0px !important;margin-bottom: 35px !important;border-top-width: 0px !important;padding-top: 0px !important;padding-left: 35px !important;}” list_extra_class=”text-block”]
- Enabled P2P process to run smoothly by ‘automatically’ calculating the tax (whether US Sales tax or EU VAT) that should be applied to the invoices
- Provided an opportunity for the Finance team to efficiently report transactions
[/rt_list_style][vc_column_text css=”.vc_custom_1764825027300{margin-top: 0px !important;margin-bottom: 35px !important;}” el_class=”text-block”]
Technical Stack
[/vc_column_text][vc_column_text css=”.vc_custom_1764825086709{margin-top: 0px !important;margin-bottom: 0px !important;}” el_class=”text-block”]
[/vc_column_text][/vc_column][/vc_row][/vc_section][vc_row full_width=”stretch_row” equal_height=”yes” content_placement=”middle” css=”.vc_custom_1764825181787{margin-top: 0px !important;margin-bottom: 0px !important;padding-top: 35px !important;padding-bottom: 75px !important;background-color: #ffffff !important;background-position: center !important;background-repeat: no-repeat !important;background-size: cover !important;}”][vc_column width=”1/3″ css=”.vc_custom_1531997568277{margin-top: 0px !important;margin-bottom: 10px !important;padding-top: 0px !important;padding-bottom: 0px !important;}”][/vc_column][vc_column width=”1/3″][vc_column_text css=”.vc_custom_1764825170292{margin-top: 0px !important;margin-bottom: 35px !important;}” el_class=”text-block”]
DiLytics Delivers
[/vc_column_text][/vc_column][vc_column width=”1/3″][vc_custom_heading text=”View all Success Stories →” font_container=”tag:h6|font_size:16px|text_align:right|color:%23dd3333|line_height:26px” use_theme_fonts=”yes” css=”.vc_custom_1660717315754{margin-top: 0px !important;margin-bottom: 10px !important;}” el_class=”font-weight-medium” link=”url:https%3A%2F%2Fdilytics.com%2Fsuccess-stories%2F|title:Success%20Stories”][/vc_column][vc_column css=”.vc_custom_1661424713241{margin-bottom: 25px !important;}”][rt_case_study_style case_study_style_variation=”seven” case_study_display_filter=”no” case_study_enable_title=”yes” case_study_enable_excerpt=”yes” case_study_spacing=”30″ case_study_looping_sort=”ASC” no_of_case_studies=”3″][/vc_column][/vc_row]