Forum Discussion

SusieP's avatar
SusieP
Experienced Cover User
4 years ago
Solved

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

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 ...
  • Steven_M's avatar
    Steven_M
    4 years ago

    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.

Steven_M's avatar
Steven_M
Former Staff

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.

SusieP's avatar
SusieP
Experienced Cover User
4 years ago

Thank you Steven, but undoing all the recs is just not a feasible answer or I would have done it. We do weekly bank recs and have 250+ transactions each week so its not practical to spend the time going back to July of last year and redoing it all.

It doesn't seem to me that the system accepts payments of three decimal places - so I don't understand how the system is even showing this - and doubly confusing when the payments screen shows a zero balance due and the invoice screen has the three decimal places.