PT Sterling Tulus Cemerlang
www.sterling-team.com

Phone
+62-877-8655-5055
+62 (21) 580-6055

Email
sales-enquiry@sterling-team.com

Address
Sampoerna Strategic Square
South Tower 18th
Jl Jend. Sudirman kav 45-46
Jakarta 12930 - Indonesia

400+ FREE Tips for you from Sterling Tulus Cemerlang (STEM) - SAP Indonesia Gold Partner, and Become SAP B1 Super User

Balance Due Field on Invoice

SAP Business One Tips Balance Due on Invoice
SHARE ON

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

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  -- 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.

Run Your Business With The Piece of Mind Using SAP Business One

This article was written by PT. Sterling Tulus Cemerlang, SAP Business One GOLD Partner in Indonesia.
More details about SAP Business One,
email to: sales-enquiry@sterling-team.com or call +6221-5806336 or wa +6287786555055

, , , , , , , , ,