A payment was applied to an invoice then voided, but it remained applied to the invoice.
Is there any way to unapply a voided payment?
PSTL would pop an error saying "voided transactions cannot be unapplied".
*This post is locked for comments
I'm sorry for the delayed response. Yes this solved the problem.
Thanks Mahmoud
Hello Angel
In such cases, I have always went for the SQL to handle such issues. Technically speaking, you will have to delete the apply records, and adjust the current transaction amount for both the payment and associated invoice/ invoices (to which this payment is applied)
To provide further in-depth clarification, here is the scripts to consider:
You might need to reconsider the value set to the current transaction amount in the first update statement depending on your case.
-- In order to ensure to adjust the applied and current transaction amount for the invoice
UPDATE RM20101
SET CURTRXAM = 0
WHERE DOCNUMBR = 'invoice number'
-- In order to ensure that the void status is set correctly along with the date
UPDATE dbo.RM20101
SET CURTRXAM = 0,
VOIDSTTS = 1,
VOIDDATE = DOCDATE
WHERE DOCNUMBR = 'voided payment number'
-- In order to delete the apply record
DELETE FROM dbo.RM20201
WHERE APFRDCNM = 'voided payment number'
Once all the updates above are applied, check the apply details from the inquiry screen for further assurance.
Your feedback is highly appreciated,
#1
André Arnaud de Cal...
293,280
Super User 2025 Season 1
#2
Martin Dráb
232,046
Most Valuable Professional
#3
nmaenpaa
101,156
Moderator
Share
Report
All responses (
Answers (
