SAP Business One – Incoming Payments with Payments On Account

SELECT
T0.DocNum AS ‘Inc Pay Numb’,
T0.DocDate AS ‘Post Date’,
T0.CardCode AS ‘Cust Numb’,
T0.CardName AS ‘Customer Name’,
T0.DocTotal AS ‘Total Check Recd’,
T0.NoDocSum AS ‘Overpayment’

FROM ORCT T0

WHERE T0.[NoDocSum] < > 0
AND T0.DocTotal < > T0.NoDocSum
AND T0.DocDate >= ‘[%0]’
AND T0.DocDate
ORDER BY

T0.CardName,
T0.DocDate

FOR BROWSE
We hope you find these SAP Business One tips helpful.  Remember, if you feel you need remote or onsite support and assistance with SAP Business One, feel free to call us at 866-677-6290 or email us at info@clientsfirst-us.com

2019-01-16T11:22:41+00:00 September 28th, 2015|SAP Business One|Comments Off on SAP Business One – Incoming Payments with Payments On Account