Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Load difference of two columns as amount in Transaction Matching — Cloud Customer Connect
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

Load difference of two columns as amount in Transaction Matching

Accepted answer
23
Views
11
Comments
edited Nov 17, 2020 3:02PM in Account Reconciliation 11 comments

Summary

Load difference of two columns as amount in Transaction Matching

Content

We have a trial balance report from which we want to load the data into Transaction Matching. The data is available as Total debits and Total credits in two separate columns and we want to load the difference of these two columns as the amount into transaction matching.

For example in the attached image, column AG has the Total Debits and column AH has the Total Credits and we want to load the difference of these two columns as the amount for each transaction.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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