Bill wise Collection Query

[Former Member]

Hi ,

Need to create a bill wise collection statement in this format .

AR Invoice Doc Num	Customer  Name	Posting Date	DocTotal	Received Amount	Received Date	Difference Between Received Date  &    Posting Date

[kothandaraman_nagarajan]

Hi,

Try:

SELECT T0.[DocNum], T0.[DocDate], T0.[CardCode], T0.[CardName], T0.[DocTotal], T0.[PaidToDate], T1.[DocDate], datediff(d, T0.[DocDate], T1.[DocDate]) as Days FROM OINV T0 left join ORCT T1 on T0.ReceiptNum  = t1.docnum

Thanks & Regards,

Nagarajan

[Rafaee_Mustafa]

Hi Nabil,

Please check this thread