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

What are the ARCS standards for loading amounts for transaction matching?.

Received Response
34
Views
2
Comments
edited Oct 20, 2023 3:08AM in Account Reconciliation 2 comments

Summary: We are moving Account Reconciliation process from T-Recs to ARCS Oracle EPM. T-Recs handles all amounts as positive and have a field to determine if amount has a debit/credit balance. The ARCS application documentation shows examples of the matching engine with positive values for Source and Subsystem.

The GL file we are currently receiving is designed to be consumed by T-Recs with a field for the amount and another indicating debit or credit. Due to time constraints, we are taking the same file and making changes for ARCS file consumption.

The Bank data integration was loaded using BAI format in ARCS, amounts were loaded as positive or negative following the transaction type. I am not sure if we need to do some data transformation in data management pulling the data to Account Reconciliation.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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