Balance Due Field on Invoice

In SAP Business One, the A/P Invoice or A/R Invoice document contains a Balance Due Field which informs you how much the remaining bill has not been paid.

So, if you are currently making a custom report for the remaining accounts payable and receivable but confused about how to get the balance due value in the database?

To get Balance Due Value, you can use the following Query:

SELECT (DocTotal - PaidToDate) as 'Balance Due' FROM OINV  -- A/R Invoice Document

SELECT (DocTotal - PaidToDate) as 'Balance Due' FROM OPCH  -- A/P Invoice Document

Remarks:

• DocTotal is the total invoice value on the document.
• PaidToDate is the bill value that has been paid on the document.
• Balance due is the remaining bill that has not been paid.
• The Balance Due Value = DocTotal – PaidToDate.

Hopefully, this article can help you create a custom report for the remaining accounts payable and receivable.

Also read:

• Copy total in Balance Due field to Total field in Payment Means using shortcut Ctrl+B (SAP Business One)
• Utilize a System Queries on SAP
• What’s New in SAP Business One Version 10 – Part 1
• SAP Business One Form Types
• Item Cost Calculation Method in The Perpetual Inventory System SAP Business One