why do I have an open balance in a Sales Order when the Invoice is Paid in full

  • 1
  • Problem
  • Updated 3 years ago
  • In Progress
Photo of Hailz78


  • 82 Points 75 badge 2x thumb

Posted 5 years ago

  • 1
Photo of Alex Tan

Alex Tan, Alum

  • 2,166 Points 2k badge 2x thumb
Hi Hailz78,

I am unsure as to how you can have an open balance in a sales order when the invoice is paid in full, would you be able to re-iterate with some more detail regarding the situation?

I did however, attempt to replicate your scenario but did not get the same result. If you want to try this here are the default steps:
  • Create a Sales Order
  • Turn it into an Invoice 
  • Receive Payment for the invoice
Doing these 3 steps in this particular order will ensure that
  1. The Sales Order has a stamp on it saying "Invoiced in Full"
  2. The Invoice should have a balance due of $0
  3. The customer inside the Customer centre will not have any outstanding amounts
Please check this and get back to me if you have any further enquiries.

Kind regards,
Photo of Carrie


  • 1,066 Points 1k badge 2x thumb
Hi,  I have just found that if a sales order is invoiced, but you then amend the prices on the invoice, the result is a sales order that is "Invoiced in Full" but it has an open balance of the difference between the sales order and the related invoice.  The same result occurs if a sales order is partially invoiced and then manually closed.  The only way I can find to get rid of the open balance is to go back to the sales order, change the figures to match the invoice and then save it.  Surely there must be a reason why it works this way - can anyone explain?
Photo of khalid


  • 60 Points
In sales order don't tick under closed (clsd ), go directly to invoice.
if you want to correct what happened, just do the following: read no. 7 first
1- open the sales order that you have open balance.
2- untick opposit all items. 
3- invoice with the same invoice number and date. 
4- check in sales order list the open sales order will not show it is open. 
5- now you have two invoices with the same no. and date. 
6- how to distinguish between the new invoice and the old , to delete one of them. 
7- from beginning you have to open the original invoice and write any thing for future compare, then you can delete it after creating new one.
This is what i did and it works.