SAP HR Implementation/ Interface development and Support for a leading distributor of home- and office-delivered newspapers in the U.S

hed-profile-icon-1

Sector

  • Retail
hed-profile-icon-1

Technology

  • Web Application
website-icons

Website

  • https://aiwo.com/
services-icons

Services

Case_studies banner_retail_v1

Engagement Summary

The Major retailers are required to pay usage taxes on items they buy but don't intend to sell. Large retailers frequently have trouble effectively matching their financial transactions to specific line items in an ERP-type system.

If a store is unable to demonstrate to the State, County, and local taxing authorities that taxes were legally accrued and paid then usage-tax penalties will apply.

Case_study_solution

Challenges

  • Reporting and data loading delays.
  • Reporting in SAP Business warehouse (Tax Data Warehouse) is slow and difficult.
  • Data must be kept in Business warehouse or near line storage systems for ten years, and interfaces must be created between ECC, near line storage, and BW (Business warehouse) for data reconciliation in order to comply.
  • Data must be kept in Business warehouse or near line storage systems for ten years, and interfaces must be created between ECC, near line storage, and BW (Business warehouse) for data reconciliation in order to comply.
  • It will take days to get a single file from the BW system for usage of internal and submission to tax authorities. Client has to generate 30+ flat files having huge data sets out of the BW system.
  • Custom ECC programmes for TDW extraction run for days and on end it was frequently failing and necessitating rerunning of the scripts.

Solution Proposed

  • Prior to creating a full TDW solution utilising SAP HANA, Transcend Digital created a Solution for Use Tax Reconciliation.
  • Transcend Digital extensively investigated the client's environment and made a solid HANA-based solution recommendation for tax reporting. HANA data models have been updated to handle larger data sets and speed up processing (Big Data) created flat file interfaces that extract data from HANA in less time than an hour instead of days for each file.
  • Data reconciliation between the source system and HANA can be automated and HANA analytical views were made by combining datasets from several business functions.
  • Transcend Digital also added interactive reports made using SAP Business Objects tools to HANA data models, giving users more flexibility in reporting.
case_study_challenge
casestudies_results_sap

Client Benefits

  • 8000 Stores
  • Operates in 15+ countries
  • 9 Different retail formats
  • Met with the Internal compliance
  • Match up invoice line items with use-tax accruals
  • Much better adherence to tax laws
  • acquired the capacity for quick decision-making
  • large potential for cost savings and reduction of manual tax reconciling efforts

Ryan Botwinick
Fyxt CEO

Transcend Digital was exactly what we needed for our early stage company and continues go above and beyond for the product and consistently impress me with their thought process and ability to remain lean.

Related Success Stories

Blog Post

SAP HR Implementation for a leading IT Software Provider

Read More >>
Blog Post

SAP HR Implementation/ Interface development and Support for a leading distributor of home- and office-delivered newspapers in the U.S

Read More >>
Services
Digital Consulting
Company
logo-white-Dec-08-2021-05-42-28-69-AM
We’re a full service technology & digital consulting firm with data deep within our DNA. Our deep understanding of technology, data and customer experience allows us to craft solutions that maximize ROI and drive value for our clients.

17875 Von Karman Ave
Suite 150
Irvine, CA 92614
United States

+1 (310) 954-1392

© 2023 Transcend Digital. All rights reserved. Privacy Policy