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

Link between Bank Statement line and Transactions for Group of Manual Reconciliation.

Received Response
2
Views
1
Comments
edited Apr 8, 2024 6:48PM in Reporting and Analytics for ERP 1 comment

We are working on the BI report to Pull AP and External Transactions. I need to join the CE_STATEMENT_LINES and CE_RECON_HISTORY_ITEMS to AP_CHECKS_ALL. When I tried to retrieve a group of multiple statement lines against a group of manual reconciled multiple system transactions, there is a duplication of rows for each statement when recon_history_id is same for multiple transactions for multiple statement lines. Any guidance on how to avoid the duplication of rows when linked with group of multiple transactions. Any source or unique reference would be greatly appreciated.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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