Case Studies

SERVICE

• Client Accounts Receivable detail did not tie out to SAP General Ledger Balance

Issue
The client manages their accounts receiveble detail in an Access database that is fed from SQL Server from the SAP accounting package. The AR detail is off by tens of millions of dollars when compared to the SAP GL Balance. Clients needs to identify the process error/issues and fix the system so that a reconciliation of AR detail to AR SAP GL balance is quickly reconciled and tied out on a daily basis.
Solution 
> Review SAP to SQL Server7 to Access Customer Accounts Receivable reporting system to determine underlying issues causing data differences.
> Redesigned coordination for data warehouse updates and rewrote underlying Access queries to correct data processing issues.
> Trained staff to build queries to enhance customized reporting application.
> Reconciled customized Access accounts receivable reports to SAP generated reports.

Benefits 
> Identified $20 million in unreconciled accounts receivable.
> Identified process error and wrote code to remedy it.
> AR detail reconciliation to GL SAP AR balance can be performed quickly on daily basis.

Return To Case Studies