web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / PM credit memo problem
Microsoft Dynamics GP (Archived)

PM credit memo problem

(0) ShareShare
ReportReport
Posted on by Michael O'Donnell 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 have the same question (0)
  • Michael O'Donnell Profile Picture
    Michael O'Donnell 355 on at

    the old forum was better..now we don't get any answers. Whose idea was it to change...it was working fine before.

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    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:

    blogs.msdn.com/.../identifying-duplicate-transactions.aspx

  • Community Member Profile Picture
    Community Member on at

    Do not blame the guys for not being able to check the forum frequently, we are in the year end days!

  • Suggested answer
    Richard Whaley Profile Picture
    Richard Whaley 25,195 on at

    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.

  • Suggested answer
    Tee Lopez Profile Picture
    Tee Lopez 25 on at

    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.  

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
talty09 Profile Picture

talty09 2

#1
Anthony Beatty Profile Picture

Anthony Beatty 2

#3
CP04-islander Profile Picture

CP04-islander 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans