Home » Listing Details
Top Websites
  1. Dynamics GP Help
    Over 6400 resources listed.
  2. Mark Polino's DynamicAccounting.net
    Over 5100 resources listed.
  3. Rose Business Solutions Blog New
    Over 2200 resources listed.
  4. Developing for Dynamics GP - By David Musgrave and the MS GP Dev Support Team
    Over 1100 resources listed.
  5. Mariano Gomez at The Dynamics GP Blogster
    Over 1000 resources listed.
  6. Microsoft Dynamics Partner Community Blog
    Over 900 resources listed.
  7. Christina Phillips, Steve Endow & Lorren Zemke at Dynamics GP Land
    Over 700 resources listed.
  8. Mohammad Daoud's Dynamics GP Blog
    Over 600 resources listed.
  9. Vaidy Mohan at Dynamics GP - Learn & Discuss
    Over 500 resources listed.
  10. Inside Microsoft Dynamics GP Official Blog
    Over 500 resources listed.
  11. eOne Business Solutions Blog
    Over 400 resources listed.
  12. About Dynamics, Development and Life
    Over 300 resources listed.
  13. Frank Hamelly at GP2theMax
    Over 300 resources listed.
  14. Dynamics CPM
    Over 300 resources listed.
  15. BKD Dynamics GP Insights Blog
    Over 200 resources listed.
  16. Leslie Vail at Dynamics Confessor Blogspot
    Over 200 resources listed.
  17. Victoria Yudin's Dynamics GP Website
    Over 200 resources listed.
    Victoria Yudin
  18. Janakiram M.P. at DynamicsBlogger
    Over 100 resources listed.
  19. VS Tools Forum
    Over 100 resources listed.
    Your Resource for Visual Studio Tools for Dynamics GP
  20. Inside Microsoft Dynamics GP Official Blog
    Over 100 resources listed.
  21. US Dynamics GP Field Team Blog
    Over 100 resources listed.
  22. Catherine Eibner MBS Developer Evangelist
    Over 100 resources listed.
  23. Sivakumar Venkataraman at Interesting Findings & Knowledge Sharing
    Over 100 resources listed.
  24. Dynamics Small Business
    Over 100 resources listed.
  25. Belinda, The GP CSI
    Over 100 resources listed.

ID:9452
Title:Microsoft Dynamics GP 10.0: You can't choose this document because it is part of a recovered batch or is still in the process of posting.
URL:http://mohdaoud.blogspot.com/2009/09/microsoft-dynamics-gp-100-you-can.html
Description:

One of my customers reported an issue this morning, they cannot apply a payment to its vendor invoice, the got the message shown below:

"You can't choose this document because it is part of a recovered batch or is still in the process of posting."image

Well, my fast "stupid!" answer to this was "Go to batch recovery and recover your batch from there", but when I thought about it, it couldn't be un-posted if it was here to be applied!

My next advise -following the book!- was to check-links and reconcile the vendor transactions, but again non of them resolved the issue, so I did further investigations and went through the database, the transactions that couldn't be applied posted by one user, and exists in both PM10000 and PM20000 which made me confused, as the posted transactions should only be in PM20000 and should not exist in PM10000.

It seems the issue with that user is sudden corruption for GP Dictionaries or lose in the connectivity between the client and the server, or it could be a spam that generates huge amount of requests that affects the pockets sent to the server or bla bla bla, it could be thousands.

The transactions will not be applied while it exists in the both tables, so it has to be deleted from the open transactions table "PM10000", with the following SQL Query:

DELETE FROM PM10000 WHERE VCHNUMWK = '07000000000003964'

Replace the text in RED with the voucher number you have, you could modify the query to delete all the transactions that exist in the PM20000 and PM10000, but it's for sure not safe.

If you been in this issue, you need to make sure that you following the following rules to get your system fixed:

1. Fix current transactions by running the above Query on all transaction that has the issue.

2. Do not post any transactions from the infected PC until fixing its problem.

3. Reinstall GP on that PC.

4. Validate that his PC is not infected with any spam's or viruses.

5. Make sure that the PC is properly connected to the network with no timeout returns in-between.

6. After finalizing all steps above, perform check-links on the database and reconcile your vendors to correct other affects for the changes you did.

Regards,
--
Mohammad R. Daoud
MVP, MCP, MCBMSP, MCTS, MCBMSS
Software Development Manager
+962 - 79 - 999 65 85
Great Package For Business Solutions
daoudm@greatpbs.com
http://www.greatpbs.com

Category:GP USER INFO: Posting
Link Owner:
Date Added:June 17, 2010 05:06:19 AM
Number Hits:140
RatingsAverage rating: (0 votes)
Reviews

No Reviews Yet.