Negative Amounts in “Applied to Date” After Deleting Payments, System Design Issue?

Question

We recently encountered a couple of cases where we needed to delete both customer payments and supplier payments.

In both scenarios, the payments had already been approved and applied to their respective invoices and bills. After deleting these payment transactions, we expected all related payment information to be fully removed. However, the system instead automatically generated negative amounts in the “Applied to Date” field, which increased the outstanding balance.

We have reviewed all related journals and ledgers but cannot find any transactions or entries that explain or trace back to these negative “Applied to Date” amounts.

We have also tried to delete both transactions, but failed as system popped out warnings saying"cannot delete transactions that previously applied payment".

Has anyone experienced this before? What could be causing this behaviour, and how can we correct or remove these negative applied amounts?

Any guidance or recommended steps would be greatly appreciated.

princess_r · Answer

Hi FlyingFish007,&nbsp;Thanks for laying everything out so clearly and for the screenshots. Don’t worry, you’re definitely not the only one who runs into this. Sometimes things just don’t go as planned and you need to delete a transaction. Please note that if a payment’s already been applied to an invoice or bill, you won’t be able to delete it straight away. You’ll need to undo the payment first before you can reverse or delete the sale/purchase. It’s also important to update your security preferences before trying to reverse or delete any transactions.&nbsp;Those negative amounts in the “Applied to date” field on your invoices usually mean a payment was reversed or deleted incorrectly, which can leave a leftover negative value. There are a few places you’ll need to review, especially by recapping the transaction to see exactly how it was recorded. From there, you’ll be able to pinpoint what’s causing the negative amounts. I’ll drop some helpful links below for you to check out. If you’d like more hands-on help, the best next step would be to get in touch with our team by phone or via live chat through our virtual assistant, MOCA.&nbsp;Deleting a customer paymentDeleting a bill paymentReversing a transactionDeleting a transaction&nbsp;Cheers,Princess&nbsp;

Forum Discussion

Negative Amounts in “Applied to Date” After Deleting Payments, System Design Issue?

1 Reply

Looking for something else?

Related content

Prepare Electronic Payments holds negative values

Negative payroll value in prepare Electronic payments

Negative Payroll

Negative inventory account balances

Online Payments

Super Payments

Applying Credit Note

Discount wont apply for partial payment