it is possible to generate query todays those invoice having overdue

[Former Member]

Dear sir ,

yesterday u r sending following query but we want link 'ORCT' ( incoming payment ) table how can we link this table with 'OINV'

The following query will list the invoices that are overdue as at today's date:

select

DocNum, CardCode, CardName, DocDate, DocDueDate

from

OINV

where

datediff(dd, DocDueDate, getdate()) >= 0

and CANCELED = 'N'

and PaidToDate < DocTotal

regards ,

vishal

[Former Member · Accepted solution]

select

...

from

OINV t0

left join RCT2 t1 on t1.DocEntry = t0.DocEntry and t1.InvType = 13

left join ORCT t2 on t1.DocNum = t2.DocNum

left join ORCT t2 on t1.DocNum = t2.DocNum - looks incorrect, but it's true