Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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

Matching Different Attributes on Single Data Source Match Process

in Account Reconciliation 6 comments

Summary:

We have a requirement to match transactions within one data source based on amount and a match between two different data source attributes. The transactions will net to zero for the amount, but we also need to evaluate and match data in two different data sources attributes (Description and Doc Number)

Example of what should be a confirmed match:

Transaction A: Amount $50, Doc Number: X14

Transaction B: Amount $-50, Description: X14

Currently, it seems that the only functionality available for matching in a Match Process with 1 data source is on amount and between single other data source attributes. For example, we can match Doc Number to Doc Number, or Description to Description, but not Doc Number to Description on two different transactions.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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