Skip to Content
avatar image
Former Member

Bill wise Collection Query

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
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Dec 30, 2014 at 07:38 AM

    Hi Nabil,

    Please check this thread

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 30, 2014 at 07:57 AM

    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

    Add comment
    10|10000 characters needed characters exceeded