Informe detalle de pagos

[Former Member]

Estimados:

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

Saludos,

Viviana Medina.

[jitin_chawla · Accepted solution]

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