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

How to calculate Net Accounted Column from Source Data?

Received Response
61
Views
2
Comments

Summary:

Hello All,

We are working on AP to GL reconciliation. We have integrated the AP Invoices and AP Payments data successfully. While Integrating GL Data, Source Data contains two columns ACCOUNTED_DR and ACCOUNTED_CR. We would like to net the values in these columns and calculate a NET_ACCOUNTED column. (ACCOUNTED_CR minus ACCOUNTED_DR). Is there a way to calculate the NET_ACCOUNTED column and store it in Target System (ARCS)?


Source Data is "Account Analysis Report" in ERP which does not have NET_ACCOUNTED column. Hence we are required to calculate the Net value and input in ARCS.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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