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

[Former Member]

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.

[former_member188586 · Accepted solution]

hi

check bellow thread

Thanks&regards

Andakondaramudu

[Former Member · Accepted solution]

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 · Accepted solution]

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]

[former_member188586]

hi

  this thread it may help you for mode payment

[Former Member]

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]

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.