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

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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