Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Informe detalle de pagos

Estimados:

Necesito un informe que refleje el dettale de las facturas pagados con un cheque, alguien sabe como sacarlo?

Saludos,

Viviana Medina.

Former Member
replied

Hi,

You can write a customized query to get the details about the Invoices which are paid with a check :

Following is the sample of the query for AR Invoices :

SELECT T1.[CardCode], T1.[CardName], T0.[DocNum] as 'AR Invoice Number', T1.[DocDate] as 'Payment Date', T2.[DocNum] as 'Incoming Payment Number ', T2.[DueDate] as 'Check Due Date' , T2.[CheckNum] as 'Check Number', T2.[CheckSum]as 'Amount'

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

You check enter more fields as per your requirement and similarly can create for the AP Invoices.

Hope it helps.

Regards,

Jitin Chawla

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question