355
Hello everybody, I have a credit memo for with an original amount of $9,781.32 and I have a remaining amount of $7,184.66. When I try to use the balance against some open invoices in PM
I get this message ' ‘This invoice is partially applied to this credit document. You cannot apply to this document until the other apply amount is posted’
There is nothing outstanding that needs to be posted. So why is it stopping me? How can I post and open credit memo??
*This post is locked for comments
I've been fixing corrupted GP data for 10 years now, but I had never gotten this error msg until last week. My client had applied a posted check to 2 invoices, but was unable to apply the remaining amount to a 3rd invoice. I got "This invoice is partially applied...etc..." error when I tried applying it to any other invoice or even unapplying to the 2 previously applied invoices.
I basically ran a sql trace when generating the error so I could view the sql tables involved in the process and the PM20100 table was the only one involved.
I also ran some additional sql scripts to find the check and invoices involved in various AP tables I determined that I needed to run deletion scripts in two GP tables.
1) Delete 1 record from the PM10201 which had my check. It shouldn't be here since my check was posted and this is a PM work (unposted transactions) table.
****Delete from PM10201 where docnumber = 'XXXX'
2) Delete the 2 records appying the check to the 2 invoices from the PM20100 table. This is a temp table and thus should NOT retain data permanently.
****Delete from PM20100 where vendorid = 'XXXX' and APFRDCNM = 'XXXX'.
I searched GP Knowledgebase, but they had no information on the error. I believe that because the fix requires deleting data directly in the db MS is not going to provide such a solution on its site for fear that it will be improperly executed and create an even bigger data problem.
Michael, on both this and the old forum, questions are answered by VOLUNTEERS. We are not paid to be here waiting for your question. Now, we try to get here as often as possible but when you ask for FREE support, you will get it on our schedule. We will do our best to meet your needs but you must be patient. Otherwise, call your partner or log a call with MS Dynamics.
Do not blame the guys for not being able to check the forum frequently, we are in the year end days!
Looks like your last transaction was not fully posted and still exist in both OPEN and WORK tables, checkout the below article by David Musgrave and make sure that your transaction exists only in one:
the old forum was better..now we don't get any answers. Whose idea was it to change...it was working fine before.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (