We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
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

Remove duplicate rows for AR BIP report to improve performance

Accepted answer
10
Views
2
Comments
edited Jun 24, 2021 2:12PM in Receivables & Collections 2 comments

Content

I've created a query that pulls all AR transactions for a parameterized transaction date and matches our IBAN record in the customer with any IBAN found in the bank line description of the reconciled Cash Management line. We use this for AML transaction monitoring in our main process.

The query runs fine and gives the desired result (feel free to use it ), but I have an issue with the query returning a LOT of rows for each record. I 'fixed' this by adding a DISTINCT to the SELECT clause. However, this is very bad for the performance of the query. It takes a few minutes to return ~200 records.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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