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."

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, MCT, MCBMSP, MCTS, MCBMSS
CTO
+962 - 79 - 999 65 85
Dynamics Innovations
daoudm@dynamicsinnovations.com
http://www.dynamicsinnovations.com

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, MCT, MCBMSP, MCTS, MCBMSS
CTO
+962 - 79 - 999 65 85
Dynamics Innovations
daoudm@dynamicsinnovations.com
http://www.dynamicsinnovations.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:

Regards,
--
Mohammad R. Daoud
MVP, MCP, MCT, MCBMSP, MCTS, MCBMSS
CTO
+962 - 79 - 999 65 85
Dynamics Innovations
daoudm@dynamicsinnovations.com
http://www.dynamicsinnovations.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.

Microsoft Dyanmics GP Payroll System Customized for Middle East

Regards,
--
Mohammad R. Daoud
MVP, MCP, MCT, MCBMSP, MCTS, MCBMSS
CTO
+962 - 79 - 999 65 85
Dynamics Innovations
daoudm@dynamicsinnovations.com
http://www.dynamicsinnovations.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, MCT, MCBMSP, MCTS, MCBMSS
CTO
+962 - 79 - 999 65 85
Dynamics Innovations
daoudm@dynamicsinnovations.com
http://www.dynamicsinnovations.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":

Go to Tools >> Sections Options:

Place your texts here -->

 

Regards,
--
Mohammad R. Daoud
MVP, MCP, MCT, MCBMSP, MCTS, MCBMSS
CTO
+962 - 79 - 999 65 85
Dynamics Innovations
daoudm@dynamicsinnovations.com
http://www.dynamicsinnovations.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, MCT, MCBMSP, MCTS, MCBMSS
CTO
+962 - 79 - 999 65 85
Dynamics Innovations
daoudm@dynamicsinnovations.com
http://www.dynamicsinnovations.com

Macros Scheduling

Mark posted a method to record and auto-play macro file using windows tasks scheduler, checkout his post below:

http://msdynamicsgp.blogspot.com/2005/11/weekly-feature-schedule-your-macros.html

Regards,
--
Mohammad R. Daoud
MVP, MCP, MCT, MCBMSP, MCTS, MCBMSS
CTO
+962 - 79 - 999 65 85
Dynamics Innovations
daoudm@dynamicsinnovations.com
http://www.dynamicsinnovations.com

Experience Price

Guys,

I really liked the story at Martin blog, click on the following link to read it!!

http://eonesolutions.blogspot.com/2009/09/charge-for-your-time-what-you-know-is.html

And read this to apply the story on our GP word!!

http://eonesolutions.blogspot.com/2009/09/for-those-that-were-unable-to-apply.html

Regards,
--
Mohammad R. Daoud
MVP, MCP, MCT, MCBMSP, MCTS, MCBMSS
CTO
+962 - 79 - 999 65 85
Dynamics Innovations
daoudm@dynamicsinnovations.com
http://www.dynamicsinnovations.com

eConnect SP4 Bug on PO Integration

Guys,

Checkout Vaidy post below about this subject:

http://www.vaidy-dyngp.com/2009/09/econnect-100-sp4-bug-in-tapoline-schema.html

Regards,
--
Mohammad R. Daoud
MVP, MCP, MCT, MCBMSP, MCTS, MCBMSS
CTO
+962 - 79 - 999 65 85
Dynamics Innovations
daoudm@dynamicsinnovations.com
http://www.dynamicsinnovations.com

MSDynamicsWire.com

Guys,

Checkout this portal created by Janakiram:

http://msdynamicswire.com/

It has all the blogs feeds consolidated in one place, really worth to take a look.

Regards,
--
Mohammad R. Daoud
MVP, MCP, MCT, MCBMSP, MCTS, MCBMSS
CTO
+962 - 79 - 999 65 85
Dynamics Innovations
daoudm@dynamicsinnovations.com
http://www.dynamicsinnovations.com

A look into the future, GP 2010 Demo!!!

Guys,

Microsoft Insight released three interesting files, a power point show that presents the roadmap for GP 11, 12 and 14! and two demo's represents the Microsoft Office Integration Enhancement and Dashboard Drill Down samples.

Find the complete post and the download link HERE.

Regards,
--
Mohammad R. Daoud
MVP, MCP, MCT, MCBMSP, MCTS, MCBMSS
CTO
+962 - 79 - 999 65 85
Dynamics Innovations
daoudm@dynamicsinnovations.com
http://www.dynamicsinnovations.com

Integration Manager Customizations!

Guys,

Did you know that you can keep Microsoft Dynamics GP visible when running Integration created by Integration Manager and watch the transactions pushed inside GP windows a record after record?

This could be fact by turning "ShowDynamics=True" in Integration Manager INI file.

Find the complete list of parameters and explanations @ Mariano blog post below:

http://dynamicsgpblogster.blogspot.com/2009/09/integration-manager-10-ini-settings.html

Regards,
--
Mohammad R. Daoud
MVP, MCP, MCT, MCBMSP, MCTS, MCBMSS
CTO
+962 - 79 - 999 65 85
Dynamics Innovations
daoudm@dynamicsinnovations.com
http://www.dynamicsinnovations.com

Print Saved AR Transactions

Guys,

Check this button out --->>

Well, currently this button does not exist at you current AR Batch Entry form, you will have to perform few steps back to get this button on, check it @ Geoffrey Wayong blog below:

http://amllp.blogspot.com/2009/09/ar-transactions-printing-by-batch.html

Regards,
--
Mohammad R. Daoud
MVP, MCP, MCT, MCBMSP, MCTS, MCBMSS
CTO
+962 - 79 - 999 65 85
Dynamics Innovations
daoudm@dynamicsinnovations.com
http://www.dynamicsinnovations.com

Purchase Order Entry "Inventory and Non-inventory Items"

Guys,

Frank found an interesting solution with MBS guys for the part of mistyping the item number in the purchase order entry window instead of checking "Add Item" option each time, a fix that defaults this option to be checked instead of not.

http://gp2themax.blogspot.com/2009/09/gptip42day-add-item.html

Regards,
--
Mohammad R. Daoud
MVP, MCP, MCT, MCBMSP, MCTS, MCBMSS
CTO
+962 - 79 - 999 65 85
Dynamics Innovations
daoudm@dynamicsinnovations.com
http://www.dynamicsinnovations.com

Currency Negative Sign, Before or After The Amount??

While having nothing to do this weekend, I tried to investigate and find the "actual" difference if exist between displaying the negative sign before or after the number, and I found!

While working on analytical accounting, and passing by inquiry forms I got this message:

Even if your negative sign was "()" instead of "-" and this box was disabled, it still active!! So if you are interested to implement Analytical Accounting and wanted to use the Multilevel Query Wizard or Distribution Query Wizard, make sure that the "After Amount" is not selected.

Regards,
--
Mohammad R. Daoud
MVP, MCP, MCT, MCBMSP, MCTS, MCBMSS
CTO
+962 - 79 - 999 65 85
Dynamics Innovations
daoudm@dynamicsinnovations.com
http://www.dynamicsinnovations.com

How to use the Dynamics GP VPC Image??

The answer is here: http://blogs.msdn.com/dynamicsgp/archive/2009/09/10/partnercast-demo-training-for-dynamics-gp-sp3-vpc.aspx

Regards,
--
Mohammad R. Daoud
MVP, MCP, MCT, MCBMSP, MCTS, MCBMSS
CTO
+962 - 79 - 999 65 85
Dynamics Innovations
daoudm@dynamicsinnovations.com
http://www.dynamicsinnovations.com

Alternating shading for lines in Crystal Reports

If you would like to create report as the one shown below using crystal reports, checkout Victoria blog post HERE:

Regards,
--
Mohammad R. Daoud
MVP, MCP, MCT, MCBMSP, MCTS, MCBMSS
CTO
+962 - 79 - 999 65 85
Dynamics Innovations
daoudm@dynamicsinnovations.com
http://www.dynamicsinnovations.com

Mariano & David sessions in Microsoft Dynamics GP Technical Conference 2009

If you were around Fargo, North Dakota from November 9 through November 11, do NOT miss the following two sessions for the GP technical elders:

Session Title: Customizing the Microsoft Dynamics GP Client with Visual Studio Tools, Dexterity and Modifier with VBA
Presenters: David Musgrave, Mariano Gomez
Session Description: Get an in-depth analysis of the various client-side customization tools for Microsoft Dynamics GP, including Modifier with Visual Basic for Applications, Dexterity, and Visual Studio Tools for Microsoft Dynamics GP. This session will help you understand how each of the tools can be used to create user-interface customizations as well as help you develop the ability to make sound decisions on the best tool for a particular purpose.

Session Title: Troubleshooting Your Developed Solution
Presenters: David Musgrave, Mariano Gomez
Session Description: Do you know the vital development considerations necessary for effectively troubleshooting a packaged solution? Learn them and much more! We will highlight best practices, illustrate real-world examples, and provide and discuss requirements for the Certified for Microsoft Dynamics program. Plus, we will show how the Support Debugging Tool for Microsoft Dynamics GP can be used to help with both development and system administration.

Yes this is true, I got the tip from Mariano blog post below: http://dynamicsgpblogster.blogspot.com/2009/09/microsoft-dynamics-gp-technical.html

Regards,
--
Mohammad R. Daoud
MVP, MCP, MCT, MCBMSP, MCTS, MCBMSS
CTO
+962 - 79 - 999 65 85
Dynamics Innovations
daoudm@dynamicsinnovations.com
http://www.dynamicsinnovations.com

Integrating CRM 4.0 To GP

Geoffrey Wayong has an interesting article about the CRM integration with GP, check it out below: http://amllp.blogspot.com/2009/09/crm-40-adapter.html

Regards,
--
Mohammad R. Daoud
MVP, MCP, MCT, MCBMSP, MCTS, MCBMSS
CTO
+962 - 79 - 999 65 85
Dynamics Innovations
daoudm@dynamicsinnovations.com
http://www.dynamicsinnovations.com

How to setup all modules to be 100% reconciled to GL?

I am sure that most of our GP clients asks this question, when you do not have "Post Through GL" checked, the system will create your GL voucher in GL Transaction Entry window upon posting any kind of transactions in the module windows, and if this voucher got deleted for any reason, you will have variances between the module and the GL, normally this will require allot of work to find out those variances by the end of the period.

However, in GP 10.0, Microsoft added a new functionality called "Reconcile to GL" that matches your transactions to its corresponding transactions in GL and generate variances report but Frank has an interesting article about preventing direct account entry for modules accounts, I recommend reading the blog post below that might change the way you implement GP: http://gp2themax.blogspot.com/2009/09/gptip42day-allow-account-entry.html

Regards,
--
Mohammad R. Daoud
MVP, MCP, MCT, MCBMSP, MCTS, MCBMSS
CTO
+962 - 79 - 999 65 85
Dynamics Innovations
daoudm@dynamicsinnovations.com
http://www.dynamicsinnovations.com

Integration Manager & Analytical Accounting

Guys,

Check below David's options about AA and IM:

http://blogs.msdn.com/developingfordynamicsgp/archive/2009/09/09/using-integration-manager-with-analytical-accounting.aspx

Regards,
--
Mohammad R. Daoud
MVP, MCP, MCT, MCBMSP, MCTS, MCBMSS
CTO
+962 - 79 - 999 65 85
Dynamics Innovations
daoudm@dynamicsinnovations.com
http://www.dynamicsinnovations.com

GP will no longer hold the name "V11"!! Microsoft Dynamics GP 2010.

Yes indeed, Mariano posted an article about this subject, the new name will be: Microsoft Dynamics GP 2010!!

Checkout his post below:

http://dynamicsgpblogster.blogspot.com/2009/09/code-named-version-11-now-formally.html

Regards,
--
Mohammad R. Daoud
MVP, MCP, MCBMSP, MCTS, MCBMSS
Software Development Manager
+962 - 79 - 999 65 85
Dynamics Innovations
daoudm@dynamicsinnovations.com
http://www.dynamicsinnovations.com/

How to deploy 200 Excel reports with direct data connection to Dynamics GP 10.0

Would you like to have new 200 Excel Reports to your GP reports library?!? Checkout Clinton L. Weldon in his blog post below:

http://www.dynamicscare.com/blog/index.php/how-to-deploy-200-excel-reports-with-direct-data-connection-to-dynamics-gp-100/

Regards,
--
Mohammad R. Daoud
MVP, MCP, MCT, MCBMSP, MCTS, MCBMSS
CTO
+962 - 79 - 999 65 85
Dynamics Innovations
daoudm@dynamicsinnovations.com
http://www.dynamicsinnovations.com

Dynamics GP 10.0 SP4 Issues

Guys,

While personally I didn't test GP after upgrading my test database to SP4, but based on the recommendations I can see in Doug Pitcher blog post below, I would recommend postponing the SP4 upgrade for another few weeks until finalizing all the needed fixes, check the post below:

http://www.rosebizinc.com/gpblog/2009/09/service-pack-4-for-dynamics-gp-100.html

Regards,
--
Mohammad R. Daoud
MVP, MCP, MCT, MCBMSP, MCTS, MCBMSS
CTO
+962 - 79 - 999 65 85
Dynamics Innovations
daoudm@dynamicsinnovations.com
http://www.dynamicsinnovations.com

Macros in GP

Amy Walsh detailed the complete steps for creating Macros with Mail Merge functionality, checkout his blog post below:

http://www.dynamicscare.com/blog/index.php/macros-in-dynamics-gp/

Regards,
--
Mohammad R. Daoud
MVP, MCP, MCT, MCBMSP, MCTS, MCBMSS
CTO
+962 - 79 - 999 65 85
Dynamics Innovations
daoudm@dynamicsinnovations.com
http://www.dynamicsinnovations.com

Software Vs. Softwares

Dwight Specht wrote a very interesting comment about the "Software" world checkout his comment HERE.

Regards,
--
Mohammad R. Daoud
MVP, MCP, MCBMSP, MCTS, MCBMSS
Software Development Manager
+962 - 79 - 999 65 85
Dynamics Innovations
daoudm@dynamicsinnovations.com
http://www.dynamicsinnovations.com/

How to Blow your ERP Budget in 6 Easy Steps?!?!

Rick Feterick has an interesting post about issues need in software implementation, checkout his post HERE.

Regards,
--
Mohammad R. Daoud
MVP, MCP, MCT, MCBMSP, MCTS, MCBMSS
CTO
+962 - 79 - 999 65 85
Dynamics Innovations
daoudm@dynamicsinnovations.com
http://www.dynamicsinnovations.com