cancel
Showing results for 
Search instead for 
Did you mean: 

How can I Find out how my Customer usually pays me?

Former Member
0 Kudos
63

Hi Experts,

I need to find out How my Customer Usually Pays me? that is what is his mode of payment for the invoices billed to him.

I need to generate a report for this. kindly help.

for eg:

I have created 5 Invoices in the system and taken Payments also then the report should show me what are the payment means for all that 5 invoices.

Let me know how I can create this report. either by simple query or Qpld or Crystal report ?

thanks,

Amit.

Accepted Solutions (1)

Accepted Solutions (1)

former_member188586
Active Contributor
0 Kudos

hi

check bellow thread

Thanks&regards

Andakondaramudu

Former Member
0 Kudos

Hi,

This is not showing me by which means the customer has paid, weather it is a cheque or cash or transfer..

I need to find it out. kindly help.

thanks,

amit.

former_member188586
Active Contributor
0 Kudos

hi

try this one

SELECT T1.CardCode, T1.CardName, T0.DocDate as 'Posting Date', T0.DocNum as 'AR Invoice Number',

T0.DocTotal as 'AR Invoice Total', T0.DocTotalFC as 'AR Invoice Total FC', T1.DocDate as 'Payment Date',

T1.CashSum, T1.TrsfrSum, T2.DocNum as 'Incoming Payment Number ', T2.DueDate as 'Check Due Date' ,

T2.CheckNum as 'Check Number', T2.CheckSum as 'Amount', T3.SlpName

FROM OINV T0 INNER JOIN ORCT T1 ON T0.ReceiptNum = T1.DocEntry LEFT JOIN RCT1 T2 ON T1.DocNum = T2.DocNum

Left Join OSLP T3 ON T3.SlpCode= T0.SlpCode

where T0.DocDate >=[%0] and T0.DocDate <=[%1]

Answers (2)

Answers (2)

former_member188586
Active Contributor
0 Kudos

hi

  this thread it may help you for mode payment

Former Member
0 Kudos

Hi Amit,

According to your requirement you can try using the below query.

SELECT T0.[DocNum], T0.[DocDate] 'Payment Date', T0.[CardName],T0.[CashSum], T0.[CreditSum], T0.[TrsfrSum],T0.[DocTotal],  T2.[DocNum], T2.[DocDate] 'Document date',  T3.[LineStatus] FROM ORCT T0  INNER JOIN RCT2 T1 ON T0.DocNum = T1.DocNum left join OINV T2 on t1.docentry = t2.docentry INNER JOIN INV1 T3 ON T2.DocEntry = T3.DocEntry WHERE T0.[DocDate] between [%0] and [%1]  GROUP BY T0.[DocNum], T0.[DocDate], T0.[CardName],T0.[CashSum], T0.[CreditSum], T0.[TrsfrSum],T0.[DocTotal],  T2.[DocNum], T2.[DocDate],  T3.[LineStatus]

thanks,

Nikunj

Former Member
0 Kudos

Hi Nikunj,

this is helpful but I need to get what was the payment means for that transaction. Let me know how can I do it.

thanks,

Amit.