We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
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

Auto match between different columns with Account Analysis

Question
15
Views
0
Comments
edited Apr 6, 2020 6:16PM in Account Reconciliation

Summary

Is there a way to set up auto match rules to look at two different columns for an account analysis reconciliation?

Content

Hi All,

Our client has a need to set up auto match rules to match between two different columns in their data load files. Below is an example of what their data would look like in this situation:

Account Number Description ID Amount
123-123-12 V84311 54686 100
123-123-12 Travel V84311 -100

They would like the ability to match the "V84311" description with the "V84311" ID. However, I have not been able to find a way to match between two different columns/attributes for an Account Analysis reconciliation.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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