Skip to Content
0
Former Member
Apr 21, 2007 at 05:45 AM

Re: it is possible to generate query todays those invoice having overdue

25 Views

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