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


Phone: 888.239.2818 | Fax: 312.621.9200

 Copyright © 2012 Clients First Business Solutions (North America) LLC. All rights reserved

CFBS Locations: New Jersey (Head Office)Alabama | California | FloridaIllinois | Minnesota | TennesseeTexas