Announcements
I am getting this message when attempting to apply an AP credit memo to an invoice.
"This invoice is partially applied to this credit document. You cannot apply to this document until the other apply amount is posted"
Checking this credit memo and the invoice neither is applied to each other.
Checking PM10201 and PM20100 reveals thousands of record in each. This credit memo does have a record in the PM10201 table. Running check links had no effect.
What should I do to be able to apply this credit memo?
In this case they were simply trying to move this credit memo to history. It had been applied to 38 invoices. Removing these 38 records from RM20100 and running check links moved it to history.
After deleting 38 records that were applied to this credit memo from the PM20100 and running check links this credit memo moved to history.
Hi Richard,
Here's the script Brandon was planning to upload for you:
Also, here's a link to a good blog that talks about the PM20100 table and what the records there are for, along with some different scenarios where users may choose to remove them:
I agree with Brandon, be sure to test any changes first in a test company. Hope this helps, and good luck!
Hey Richard,
I dont have access to my pc to get the script but can upload it tomorrow.
The PM20100 records are remittance records. Removing them will only stop them from printing on the remittance. These do get deleted once they print on the remittance so no harm should come.
I would try it in test or have a restorable backup in case it doesn't solve the issue.
One other thing that can cause this.is a duplicate between work and open.
Hope this helps!
Thank you!
In the PM10200 table are 38 records to which this credit memo is applied. In the PM20100 table are the same 38 records. Should I remove the 38 records from the PM20100 table?
Brandon, I am embarrassed to admit I cannot find my copy of the All Payables script. I know I used it recently. Can you please provide link to this script?
Hey Richard,
The problem is likely a PM20100 record. The PM10201 is the Reprint Checks Table and would not cause this error.
If you have our All Payables Script on hand, I would run this for the Credit and the Invoice you are attempting to apply. If there is a PM20100 record on either, Test deleting it and see if you can then apply.
I hope this helps!
Thank you!
Brandon Jarrett | Microsoft Support Engineer
André Arnaud de Cal... 291,359 Super User 2024 Season 2
Martin Dráb 230,370 Most Valuable Professional
nmaenpaa 101,156