Skip to Content
1
Former Member
Nov 19, 2012 at 03:19 PM

Help with SQL Query for Collections Department

496 Views

Hello Experts...

I am new to SQL and am trying to get a report for my Collections Department. How do I find out how many days an open AR Invoice is past due for Open Invoices?

I would like to have the remaining amount to be paid on each Invoice showing and be able to drill down to the Customer and the AR Invoice itself. The AR Invoice should be at least 30 days past their due date before they show on the report. Here is what I have so far:

SELECT

T0.[CardCode],

T0.[CardName],

T0.[DocNum],

T0.[DocStatus],

T0.[DocDate],

T0.[DocDueDate],

T0.[DocTotal]

FROM OINV T0

WHERE

T0.[DocStatus] = 'O'

Thanks in advance,

Tim