Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

Document is Fully Applied

Posted on by Microsoft Employee

We’re having an issue allocating payment made from this supplier to their various invoices in GP. The invoices are showing as open on the system which means that no payment have been applied to them. However, when we go to apply the payment to them, the system is saying that all those invoices are fully applied.

*This post is locked for comments

  • Bill Campbell Profile Picture
    Bill Campbell 22,647 on at
    RE: Document is Fully Applied

    Doing a quick read of what Leslie posted 2 years ago, I would believe it still applies.  This is very much core of the Payables module and I don't believe that the tables have changed.

    Make a backup of your company data before you try any of the steps outlined above.  While good in practice, it can cause great deal of pain if you make a mistake.  Better to have a backup first.

  • Fahad Humayun Profile Picture
    Fahad Humayun 1,340 on at
    RE: Document is Fully Applied

    Hi,

    I am having the same issue, but when I inquire about the document. I can see the document in OPEN transactions.

    Will it be the same solution for me what you mentioned Ms Leslie Veil?

    Thanks for your support.

  • Suggested answer
    L Vail Profile Picture
    L Vail 65,271 on at
    RE: Document is Fully Applied

    Hi again,

    Your company's database name is found in the Company ID field on the company setup window. To open that window, go to: Administration | Setup | Company | Company

    The field is identified below.

    Kind regards,

    Leslie

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Document is Fully Applied

    Hi thanks for helping me out i was away

    Leslie - i found very difficult to identified My db as am very little working with GP db. i will try my best to fix this i will give update.

  • L Vail Profile Picture
    L Vail 65,271 on at
    RE: Document is Fully Applied

    Hi Alfred,

    Did you have a chance to look at the tables I mentioned?

    Leslie

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Document is Fully Applied

    Yes, both invoices and payment are still open

  • L Vail Profile Picture
    L Vail 65,271 on at
    RE: Document is Fully Applied

    Alfred,

    First I'm going to presume that when you do an inquiry, you do not see your document number in both the Open and History tables.

    Do you have access to the SQL tables? I've seen this come up when the Current Transaction Amount is wrong.

    Here's what I'd check.

    1   First, get the voucher number of the problem document

    2   Open the PM20000 table, find your voucher number in the VCHRNMBR field.

    3   Compare the DOCAMNT value to the number in the CURTRXAM field. If they match, the system thinks the document is fully applied.

    4.   Next, open the PM10200 table to see if there are any records actually applied to that document.

    5.   Look for your voucher number in the APTVCHNM ( applied to voucher number) field. If you find it, go to the APFRDCNM (applied from document number) field and record the number.

    6.   Finally, look at the VCHRNMBR (voucher number) field. This will be the voucher number of the document that the system thinks was applied to that document. Go look for that voucher number in the PM20000 table.

    In the event that the applied to document is in the history file and the document itself is in the open file, look here:

    7.   Open the PM30300 table and look for the same information that you did in the PM10200 table.

    That's all I've got. I have successfully changed the current transaction amount if that's the only thing I could find messed up and all worked out. There are more tables than just the ones I mentioned, so i wouldn't try this at home unless you are very familiar with the data model.

    Kind regards,

    Leslie

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Document is Fully Applied

    As usual Leslie is spot on. The trick is to see if you see any payments applied to these invoices. If you do you can investigate. If not, rebuilding the Payables Key Master file may help. If that does not work then it may be best to open a support case with Microsoft because some back-end data manipulation will be in order. It may be that at one time a batch was entered with payments for these invoices but was then deleted and some of the data was not completely removed. Running check links will fix this. Make sure you run a backup before running check links.

  • L Vail Profile Picture
    L Vail 65,271 on at
    RE: Document is Fully Applied

    These are just language differences. We call them Vendors (US), England, Canada, Australia and others call them Creditors. It's the same thing.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Document is Fully Applied

    you mean Enquiry->Purchasing-> There is no Transactions By Vendor only Transaction by Creditior, Transaction by Document and Payables summary...

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templates⚡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,056 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans