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