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

Notifications

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) / Payment applied on inv...
Microsoft Dynamics GP (Archived)

Payment applied on invoices while GP crashed out

(0) ShareShare
ReportReport
Posted on by babubaskaran@outloo... 12

Dear All,

GP crashed out while applying payment and after login the payment is not available anywhere but the invoices is showing payment already applied and no balance.  Due to this the sub ledger is less than the general ledger since its posted on payable side not on GL side.  I have ran checklink on payable and reconcile few time with no luck.  I can find the applied invoices records on PM10200 table but the batch can not be found anywhere.  What is the best course of action on this matter.

Thanks

*This post is locked for comments

I have the same question (0)
  • Rosemary Profile Picture
    Rosemary 10 on at

    Hi,

    if you were to try the option to void historical transaction, are you able to view relevant information?

    Rosemary 

  • babubaskaran@outlook.com Profile Picture
    babubaskaran@outloo... 12 on at

    Hi Rose,

    No I am not able to see that at all, that's the problem.

  • Rosemary Profile Picture
    Rosemary 10 on at

    Hi,

    What about the PM10000 table?

    Rosemary

  • babubaskaran@outlook.com Profile Picture
    babubaskaran@outloo... 12 on at

    Hi Rose,

    Table PM10000 doesn't have this on it.

  • babubaskaran@outlook.com Profile Picture
    babubaskaran@outloo... 12 on at

    Bump can any GP expertise help me on this matter.

  • Suggested answer
    agaber Profile Picture
    agaber on at

    Hi Babu-

    You likely have a missing/corrupt record in the PM tables that will need to be addressed which is why Checklinks/Reconcile is not correcting the issue.   With interruptions like this, it is best to open a support case so an engineer can review all of the data in SQL for the payment to determine how to best correct the issue.  

  • Verified answer
    Rosemary Profile Picture
    Rosemary 10 on at

    Hi Babu,

    Do you have a test system where you can install the last back up to deal with this issue?  If you were to view tables related to this type of transaction you might be able to determine what is missing/corrupted.

    That is the applying of  a payment.

    Rosemary

  • Verified answer
    L Vail Profile Picture
    L Vail 65,271 on at

    Hi Babu,

    I believe this requires what I call 'file surgery'. I think you are comfortable with SQL, if I'm right, here's what I would do. You may need to simply delete the errant apply record from the Apply table (PM10200) and change the amount remaining and the date invoice paid off from the PM2000 if it's still there.

    First I would create a test company with a copy of my production table.

    Then I would download the FREE search tool from APEX and search for both the invoice number and the payment number to find what tables those documents exist in. Then I would evaluate each table to determine if it ought to be there. If the apply record does exist in some inappropriate table I would delete it. My goal would be to be able to go back and apply the payment correctly. Keep track of what you did if you fix it and then try it again on a refreshed copy of your test company before applying it to production. Be sure to run checklinks and the reconcile utility in your test to make sure nothing reappears.

    If you are not comfortable with SQL or are not knowledgeable with the data model, I would follow the recommendation above to open a support case.

    Kind regards,

    Leslie

  • babubaskaran@outlook.com Profile Picture
    babubaskaran@outloo... 12 on at

    Thanks for your kind reply Adam.

  • babubaskaran@outlook.com Profile Picture
    babubaskaran@outloo... 12 on at

    Thanks for your good suggestions Rose

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Community Member Profile Picture

Community Member 2

#2
mtabor Profile Picture

mtabor 1

#2
Victoria Yudin Profile Picture

Victoria Yudin 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans