Skip to main content
Solved

Show Outstanding Balance On Invoices

  • August 16, 2022
  • 3 replies
  • 322 views
  • Translate All

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 Laura03

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

3 replies

Laura03
Captain II
Forum|alt.badge.img+20
  • Captain II
  • Answer
  • 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).

 

Translate

Forum|alt.badge.img
  • Author
  • Freshman I
  • August 16, 2022

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

Translate

Laura03
Captain II
Forum|alt.badge.img+20
  • 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.

 

Translate