Consolidated Multiple Accounts Payable Databases

Issue


A Fortune 500 client maintained five separate Accounts Payable modules within its ERP system (JD Edwards). Prompt payment discounts were managed ineffectively due to duplicate and inconsistent data between the various databases for the same vendors. In some cases, the client was either paying invoices too early or not taking advantage of early payment discounts when available.


Solution


Our consultant built a custom application to consolidate the five JDE A/P databases into one database. Each vendor was reconciled for accuracy.


Result


Our custom application allowed for easy and quick access to a consolidated vendor list. More simplified and accurate reporting provided the client abilities to take advantage of early payment discounts not previously acknowledged and also manage cash flow more effectively by identifying areas where vendors were paid too soon. The project was so successful that one line item discount, previously not realized in the old systems, paid for the entire project.

Request PDF