Need query for A/R invoice linked with Incoming Payment

[Former Member]

Hi experts

i need a query which reports the linking between A/R invoice and Incoming Payment

the need fields are given below

Customer Name    Invoice No:    Invoice Posting Date     Invoice Total Amount      Incoming Pay Doc No  Incoming Pay Posting Date  Incoming Paid Amount  Balance Amount

Regards

[Former Member · Accepted solution]

Hi,

Please try this query.

SELECT T0.[CardName], T0.[DocNum], T0.[DocDate], T0.[DocTotal], T2.[DocNum] 'Incoming Pay No.', T2.[DocDate] 'Incoming Pay Date', T0.[PaidToDate] 'Total Paid', T0.DocTotal-T0.[PaidToDate] 'Balance Amt' FROM OINV T0 INNER JOIN RCT2 T1 ON T0.DocEntry=T1.baseabs INNER JOIN ORCT T2 ON T1.[DocNum] = T2.[DocEntry]

You can use Date range as parameter also.

Hope this helps you.

Regards,

Rahul

[kothandaraman_nagarajan]

Hi,

Please refer this thread:

Thanks & Regards,

Nagarajan

[Former Member]

Hi rajan

u r thread was help full,

Thanks