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.

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

Advertisements

Send all Microsoft Dynamics GP Reports to Screen

Frank & Mariano worked on methods on how to send report writer reports directly to screen, find out the guys posts below:

Frank: http://gp2themax.blogspot.com/2009/09/gptip42day-sending-all-reports-to.html

Mariano: http://dynamicsgpblogster.blogspot.com/2008/11/how-to-automatically-send-all-posting.html

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

Import Transactions Distributions Using Integration Manager

Another interesting question on the newsgroup, about importing transactions distributions using Integration Manager, I been in such issue where the distributions were not imported at all during the integration, after further investigations I found that the default value for Distribution Options integration was set to “Use Default” instead of “Use Source Recordset” as shown in the image below:

image

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

Middle East Payroll System

Well, I am quite busy those days in developing a payroll system customized for middle east and Microsoft Dynamics GP, I have created new development methods and processes to get application which is being developed on .Net similar to GP platform, below video represents few forms of the current developed forms.

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

Macro Programming – Commands and Syntax

Guys,

Mark has posted a document that explains the Macro commands that helps you understand and write your own macros, checkout his post below:

http://msdynamicsgp.blogspot.com/2009/09/dynamics-gp-macro-commands.html

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

Report Writer Report Footer

I found a question in the newsgroup about how to make the last page of the report different of the other pages, the answer could be by following steps below:

On report options, uncheck “Use RF For Last PF”:

image

Go to Tools >> Sections Options:

image

Place your texts here –>

image 

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

SP4 New Issues

Another issue shown up when running eOne extender, checkout David post below:

http://blogs.msdn.com/developingfordynamicsgp/archive/2009/09/25/issues-with-upgrades-and-creating-companies-caused-by-extender-after-v10-0-sp4.aspx

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