Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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

Bug with date tolerance matching rule for "Account Analysis with Transaction matching"

edited May 25, 2020 2:22PM in Account Reconciliation 6 comments

Summary

Many - Many Transaction does not match if we provide date tolerance.

Content

Trying to match Many-Many transaction for AccountAnalysis with TM format. Below are conditions provided but still the transaction are not matching. I am able to match the transaction manually. Kindly refer the attachment with screenshot i.e. DateTolerance_Bug.docx

Condition:

  • Rule Type - Many-Many - Confirmed
  • EMP - Exact Match
  • Amount - Exact Match
  • GL Date - Match with tolerance - ( -1 to +1)

Reconciliation Id,GL Date,Entity,Journal Details,Amount,EMP
1000-9980,4-Dec-2019,NSW,PayCycle1,1000,1001
1000-9980,4-Dec-2019,NSW,PayCycle1,500,1001
1000-9980,4-Dec-2019,NSW,PayCycle1,-1200,1001

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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