on 12-30-2014 6:01 AM
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 |
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
108 | |
12 | |
11 | |
6 | |
5 | |
4 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.