Auto match between different columns with Account Analysis
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.
Tagged:
0