Collections Query

[Former Member]

I am trying to build a query that lists all INCOMING payments, then show the due date from the invoice, comparing that to the date the payment was received to represent how many days late it was, then BP#, and BP name, etc...

Does anyone happen to have something similar I can build off of? I have been trying to gather the tables and link them, but it just does not come out to anything I can use.

Thanks!

[Former Member · Accepted solution]

Hi,

Check this:

Thanks,

Gordon

[Former Member · Accepted solution]

Gordon.... You are just amazing!!!!

One question though.... When I have an incoming payment with two invoices on it, how can I show it different rather than the DOCTOTAL on each invoice? I am worried the manager will assume it is double the payment, noit the same info just being displayed twice.

Thanks

[Former Member · Accepted solution]

Applied total and incoming payment total are two columns to check. It is easy to explain. Double check the result.

[Former Member]

Hi......

Check RCT2 Table where you get all the details related to your requirement...........

Regards,

Rahul