"Applied to date" amount has 3 decimal places but payment didn't - leaves balance that can't be paid

SusieP

Hi

We are trying to clean up our file and have noticed a strange thing we can't seem to close out.

Customer invoice was paid in two parts - both of which add to the invoice total - but the Applied to Date amount displaying on the invoice has 3 decimal places of cents leaving .003c outstanding on the invoice and hence it appearing open. We can't delete the invoice or payment and redo as have been reconciled.

 

I have tried just taking a small payment, and also adding an extra item to the invoice to take the payment - but I can't pay to 3 decimal places so I can't clear it.

 

Image 1 shows the invoice - with the 0.003 Balance Due.

Image 2 shows the Payments Applied window - with 0 Balance Due.

 

Steven_M

Hi @SusieP 

 

Based on the screenshots you have provided our initial recommendation would be to delete the payments and redoing them. The reason for that is you have an unusual value listed in the Applied to Date field, deleting those payments and redoing them should remove that unusual value giving you 2 decimal places as intended thus removing that remaining balance.

 

I understand that you couldn't delete that due to reconciled, while it is not advisable in normal behaviour, you can delete a reconciled transaction. This is like deleting any other transaction (open the transaction and select Edit>>Delete transaction). Once that transaction has been re-entered you just want to include that in your next reconciliation OR undo those reconciliations back to that one and re-reconcile those transactions.