AR integration issue
SummaryARCS AR integration is not pulling in the correct balances from ERP seeded report
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.