How to calculate Net Accounted Column from Source Data?

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.