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

Can you create 1 to Many rule with tolerance on non balancing attribute?

edited Sep 27, 2024 8:41PM in Account Reconciliation 3 comments

Summary:

We are trying to create a 1 to Many match rule with a tolerance on the balancing attribute, and another attribute, but the tolerance on the non-balancing attribute does not seem to match correctly.

Example:

Source System Data Record

Contract Number = 145XP

Document Number = FNAO5458976X2

Contract Amount = 500,000.00 » Balancing Attribute

Draft Invoice Amount = 2,000.00

Subsystem Data Record 1

Payee Account = 145XP

Subaccount = FNAO5458976X2

Authorized Amount = 250,000.00 » Balancing Attribute

Funds Available = 30,000.00

Subsystem Data Record 2

Payee Account = 145XP

Subaccount = FNAO5458976X2

Authorized Amount = 250,000.00 » Balancing Attribute

Funds Available = 0.00

The 1 to Many match rule is comparing the following:

Contract Number = Payee Account

Document Number = Subaccount

Contract Amount = Authorized Amount

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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