Skip to main content
Solved

Show Outstanding Balance On Invoices


Forum|alt.badge.img

Currently, when we print, email or export our Sales Invoices, they only show the original Total. How can we have our Sales Invoices show the Outstanding Balance? 

Best answer by Laura02

Hello @scottaisd00 ,

The printed forms can be modified in Acumatica Report Designer, to replace the Original Document Amount with the current Balance.

This example is the Sales Order Invoice:

On Fields tab, expand ARInvoice table, find DocBal or CuryDocBal (experiment first in your test environment to make sure you have the correct field and desired results).

 

View original
Did this topic help you find an answer to your question?

Laura02
Captain II
Forum|alt.badge.img+19
  • Captain II
  • August 16, 2022

Hello @scottaisd00 ,

The printed forms can be modified in Acumatica Report Designer, to replace the Original Document Amount with the current Balance.

This example is the Sales Order Invoice:

On Fields tab, expand ARInvoice table, find DocBal or CuryDocBal (experiment first in your test environment to make sure you have the correct field and desired results).

 


Forum|alt.badge.img

Thank you, Laura for the fast reply. I will try this in Sandbox.  How do I access Report Designer?


Laura02
Captain II
Forum|alt.badge.img+19
  • Captain II
  • August 16, 2022

Hello, The report designer can be downloaded from Acumatica.com. I’m not sure about the exact link - I’m a partner and I may have different options than you.  Here is a recent question that Acumatica answered related to the report designer training.  HTH.

https://community.acumatica.com/reports-and-generic-inquires-115/s150-training-where-is-the-sweetlife-fruits-jams-u100-data-10732

 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings