You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

AR integration issue

edited Jun 30, 2021 6:04PM in Account Reconciliation 3 comments

Summary

ARCS AR integration is not pulling in the correct balances from ERP seeded report

Content

I'm integrating AR, AP, and FA balances into ARCS by connecting to ERP seeded reports. The AP integration loads balances from the Payables Trial Balance Report. The FA Integrations load balances from the Asset Cost Detail and Reserve Detail Reports, and the AR integration loads balances from the Receivables Aging by General Ledger Account Report. 

The AP and FA balances loaded into ARCS tie to the balances in the source reports.

However, the AR balances do not tie to the balances in the Receivables Aging by General Ledger Report. ARCS does not pick up on all the records in the report column "Amt_Due_Remaining". Some are loaded in, but others are not. I tried changing the parameters/arguments, rebuilding the integration, changing the amount column but it is not working. This is an issue on more than one project/ ARCS applications. 

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!