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) / System shut down while...
Microsoft Dynamics GP (Archived)

System shut down while entering a transaction in payables and now we can't find it

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Hi,

We use GP 2010 for our accounting and processing payables. A transaction was being entered into payables and GP shut down. We can not find the transaction anywhere. I have checked Batch Recoveries and there's nothing, I have checked all payables transactions and it's not there. What was weird is that when it was being entered, the amount was wrong, so it showed that 0.06 was unapplied. I had my admin apply the 0.06, but I still cannot find the remaining amount. I have no idea where else to look and I have been surfing through the posts hoping to see if someone may have encountered the same issue. Does GP have a cloud of some sort where it stores this stuff? This transaction was never posted to the financial side either.

 

Thank you for your help!

 

Shannon

*This post is locked for comments

  • L Vail Profile Picture
    L Vail 65,271 on at
    RE: System shut down while entering a transaction in payables and now we can't find it

    Shannon,

    Not a dumb question at all. You'll need someone who has access to the SQL server. You cannot see the tables from within the user interface. GP does not have a backup cloud. If you didn't save the transaction, it could very well have disappeared. My concern is that there are left over bits of it. One more table I forgot is the Distribution table that keeps track of the debits and credits. That is table PM10100.

    Kind regards,

    Leslie

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: System shut down while entering a transaction in payables and now we can't find it

    Hi Leslie,

    This may be a dumb question, but how do I find these tables? I can't seem to locate them.

    Thanks!

    Shannon

  • Suggested answer
    L Vail Profile Picture
    L Vail 65,271 on at
    RE: System shut down while entering a transaction in payables and now we can't find it

    Hi,

    Payables transactions live in 3 tables. If it has not been posted, it's in PM10000. If it's not paid (fully applied), it's in PM20000. If it is fully paid, it's in PM30200. The 'apply' information is either in PM10200 or PM30300. It's possible that your transaction had not been saved to the tables if the power went out while it was being entered.

    Check those tables; if it's not in any of them, you may want to re-enter it.

    Kind regards,

    Leslie

  • Suggested answer
    babubaskaran@outlook.com Profile Picture
    babubaskaran@outloo... 6 on at
    RE: System shut down while entering a transaction in payables and now we can't find it

    Hi Shannon,

    Have you tried the following KB to release the transaction in stuck batch.

    support.microsoft.com/.../850289

    Please take a backup before running this.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: System shut down while entering a transaction in payables and now we can't find it

    Hi Angel,

    Thank you for the information! I tried it and still nothing. I can't imagine that the transaction just vanished. It has to be somewhere.

    Thanks!

  • Suggested answer
    Angel Nuñez Profile Picture
    Angel Nuñez on at
    RE: System shut down while entering a transaction in payables and now we can't find it

    Sankarlo, I think running a Check Links on the Payables Transaction Logical file should release the transaction from limbo. Please make sure you backup your database first.

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,494 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,309 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans