Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Unanswered

Cannot apply AP credit memo

(0) ShareShare
ReportReport
Posted on by 75,730

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?

Categories:
  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Cannot apply AP 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.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Cannot apply AP credit memo

    After deleting 38 records that were applied to this credit memo from the PM20100 and running check links this credit memo moved to history.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Cannot apply AP credit memo
    it is not possible to download this script. I am blocked and receive this message.
    Access denied
    Error 15
    community.dynamics.com
    2022-03-08 09:45:27 UTC
    What happened?
    This request was blocked by the security rules
    Your IP: 67.248.163.199
    Proxy IP: 45.60.31.181 (ID 101164-100)
    Incident ID: 1164000670141550957-250892967098454220
  • Andrea Melroe Profile Picture
    Andrea Melroe 3,437 on at
    RE: Cannot apply AP credit memo

    Hi Richard,

    Here's the script Brandon was planning to upload for you:

    AllPayables.sql

    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:

    https://community.dynamics.com/gp/b/dynamicsgp/archive/2014/09/02/faq-open-apply-table-pm20100-in-payables-management.aspx

    I agree with Brandon, be sure to test any changes first in a test company. Hope this helps, and good luck!

  • Hokuminaria Profile Picture
    Hokuminaria 2,950 on at
    RE: Cannot apply AP credit memo

    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!

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Cannot apply AP credit memo

    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?

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Cannot apply AP credit memo

    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?

  • Hokuminaria Profile Picture
    Hokuminaria 2,950 on at
    RE: Cannot apply AP credit memo

    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

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

News and Announcements

Announcing Category Subscriptions!

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,359 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,370 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans