Match Rule to deny items if common dollar amounts
Summary:
Match Rule to deny items if common dollar amounts
Content (please ensure you mask any confidential information):
We have a use case where we don't want to match on zero digit common dollar amounts.
In our previous reconciliation application, we used this function that removes the 2 zeros in the amount field and uses the new amount when matching.
Len(removeChar("0",extractnum((toString($a_amt))))) < 2
This allows only non-zero digit amounts to match and excludes the common dollar items from matching so users can manually research and match correct items together.
For instance, there are many items with $100 or $500 and no other unique identifier to match on so to match correct items together, they need to be
Tagged:
0