Blog

SAP Business One – Incoming Payments with Payments On Account

By Ryan Howe

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

Ryan Howe

Partner, Clients First Business Solutions New Jersey

Ryan Howe is a Certified Public Accountant turned SAP Business One consultant. Leading the SAP Business One practice at Clients First, Ryan has over 23 years’ experience in the financial management and ERP industry, specializing in business analysis, relationship building, and business process optimization. When he’s not helping customers leverage SAP Business One to meet their short and long-term needs, you can find him at any Michigan State sporting event with his family – go Spartans!