What's new in Customer Journeys?

Connect and learn more!
1:M bank statement line to GL journal — Cloud Customer Connect
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

1:M bank statement line to GL journal

Received Response
3
Views
1
Comments

Summary: successfully configured 1:M autoreconciliation with:

1. parsing rule to populate statement line reconciliation (Statement.Reconciliation reference)

2. custom feed of GL journal with reconciliation reference (Transaction.Reconciliation reference)

3. advanced Matching Criteria are built to match statement line to multiple GL journal lines


it worked well for staged data with single bank statement line and few journal lines.

but when bank statement has 2 lines and corresponding GL journal lines were, for example 10, 4 to match line 1 and 6 to match line 2, then reconciliation rule didn't work

Content (please ensure you mask any confidential information):

Have few questions to better understand one-to-many for GL journal lines:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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