Skip to main content
Answer

Open AR Invoices with $0.00 Balance

  • January 23, 2025
  • 2 replies
  • 119 views

We are using Version 23.211.0017 22R2.  This upgrade changed the way retention was released.  When we upgraded, we had some open invoices that did not have retention released.  We released retention in this new version.  Once that retention was eventually paid for those existing invoices, the original invoice (not the retention invoice) never closed.  The whole project has a Zero AR Balance but it is still showing Open Invoices.  Any ideas?  It won’t let me write it off because there are no open line items and that is required for the write-off.  

Best answer by meganfriesen37

We had something similar happen at another client with 23R2.  The “Fix” from Acumatica was the following

1. Unlock Periods going back to the original period that the invoice originates

2. Run Recalculate Customer Balances from that period for the affected customer(s)

3. Lock Periods opened in 1.

 

Megan

2 replies

meganfriesen37
Captain II
Forum|alt.badge.img+12
  • Captain II
  • Answer
  • January 23, 2025

We had something similar happen at another client with 23R2.  The “Fix” from Acumatica was the following

1. Unlock Periods going back to the original period that the invoice originates

2. Run Recalculate Customer Balances from that period for the affected customer(s)

3. Lock Periods opened in 1.

 

Megan


  • Author
  • Freshman I
  • January 24, 2025

Thank you Megan.  I just tested that on one client and that worked to close the document.  Thank you so much!