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. SAP Business One Tips – Balance Due Field on Invoice 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 This content is restricted to site members. If you are an existing user, please log in. New users may register below.
Register now for unlimited access to sap-business-one-tips.com
