Dynamics Blogger

This article is a continuation of another article Integration Manager crashes published in July. I observed that the Integration Manager is hanging specially in GP2010 even in normal GP client. The behavior is such that after running an integration, the Dynamics GP screen fails to open up and dynamics.exe continue to be seen as active under processes in Windows Task Manager. Killing this process serves no good. Possible Resolutions 1. I cannot be specific on the resolution as I have not personally experienced the error so far. 2. When we upgrade GP2010, GP2010 is installed as a separate instance and GP10 instance continue to exist and so is the case with Integration Manager for GP10. 3. In some cases, this IM instance is left installed and the same instance will be used to run the integrations on GP2010. This can lead to errors. Always ensure latest IM is installed with the required service packs. 4. It is recommended to uninstall GP10 and old IM instances from the computer ...

Quite recently I installed Encumbrance Management module through Add/Remove Programs menu in Dynamics GP 2010 R2 DVD. The installation was simple and fine. I ran utilities and logged into to Dynamics GP using sa. It logs me in successfully however parallel to the login process, the error below is surfaced. Microsoft.Dynamics.GP.Online services.dll: The type initializer for Microsoft.Dexterity.Applications.root threw an exception.InnerException: parameter name ProductID. Resolution I did a Repair on Dynamics GP 2010 R2. I logged back. The error didn’t' surface again. The cause of the error is unknown though I know it is due to Dynamics GP online services.

When Checkbook ID is selected in Manual Payment entry, the document number appear blank and the payables edit list displays an error that the duplicate check numbers are not allowed. S ometimes you tend to get confused at times when you see a weird system behavior. You go and look back at your fundamentals if it’s the case really. This happened to me recently while providing support to a client. This is related to an issue surfaced in manual payment entry screen of Payables Management module of Dynamics GP 10. We all know very well that the document number (check number) in manual payment entry defaults to the available next check number field in Check book maintenance screen when the checkbook ID is selected. In this case, when the check book ID is selected, it just appears blank and doesn’t default to the said field in checkbook maintenance. For a while, I got confused if this is by design and has to go back to my local install to check if this is really the case. Fortunatel...

While upgrading from Dynamics GP 10 SP1 to SP4, one of my clients have encountered the error below. “The stored procedure Synchronize TableData() of form duSQLAccountsynch : 27Pass Through SQL returned the following results: DBMS: 102, Microsoft Dynamics GP: 0.” This error was surfacing while running utilities and upgrading DYNAMICS database. I’ve not seen this error before. Taking cue from the error message, I thought initially it might be due to non-synchronization of account framework so tried resetting dex.ini file to Synchronize=TRUE, but it didn’t work at all. To understand the probable cause of this issue, I had to rely on dexsql.log file.  The log showed that there is a possible permission issue, so we tried running the GRANT.SQL and DYNSA DB owner scripts on the databases as these were databases restored from Live instance. The same issue continued. The dexsql.log showed that the database upgrade of DYNAMICS is getting interrupted with this error when it is reachin...

Recently, I saw this question on Dynamics GP Partner Forum. Background of this issue is that the client is having latest Excel Report Builder with Dynamics GP  service pack 4. Whenever they try to publish the Excel Report. Luckily, I could find the Blog post published by David Musgrave little while ago when the SP4 was released and pointed the client to that post. However, the resolution to this issue is a temporary workaround and it is still listed as a Hot Topic currently which is why it wasn’t posted into KB Articles yet, I guess. To resolve this issue, I’d point you too to David Post on this. Here you go Wrong number of arguments to 'Replace_Text' Error after v10.0 SP4

During an e-connect integration, we might come across a situation where the currency ID remains blank in the transaction entry despite having a functional currency set up correctly. The issue can be resolved by making sure there is a checkbook ID in the company that has a currency ID associated to it or an item associated to a currency ID. Another place to check is to ensure that the functional currency Index value in company database (MC40000) matches the currency index value in Dynamics Database (MC40200). Source: Dynamics GP Forum Help Thread

I covered about one error in workflows earlier. It is time for another troubleshoot. At this time, let us have a look at another error reproduced below Error “Event Type: Error Event Source: Windows SharePoint Services 3 Event Category: General Event ID: 27745Date: 30/09/2008Time: 3:23:52 Amuser: N/A Computer: AUYXUAP310WBC32Description:The description for Event ID ( 27745 ) in Source ( Windows SharePoint Services 3 ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: #50071: Unable to connect to the database SharePoint_Config on SharePointSQLServer_Dev. Check the database connection information and make sure that the database server is running..” Resolution A very small and quick resolution to this issue. Just run the fol...

Consider this scenario. You are implementing Dynamics GP Fixed Assets in your company. None of the Fixed Assets have been imported yet. You have ensured you did all your setups just perfect. Now, It’s turn to import your assets into Asset General window using Integration Manager. It can be handled using Integration Manager eConnect destination adapter for Fixed Assets.  You have made sure you set your source files, relationships as well as mappings are all proper. Now, It’s time to run your integration so you hit your Run Integration button. For no mistake of yours, the integration fails returning this error below. Microsoft.Dynamics.GP.eConnect: Number = 6625 Stored procedure taCreateAssetID : Description = unable to obtain the next FAINDEX. What’s wrong with the integration? There is nothing wrong that you did during this  process except resorting to this workaround for getting away with this error. Go to your Fixed Assets General window. Enter one Asset...

Here is another article that talks about an error identified from the stack trace in Event Viewer. I have published a series of articles on Dynamics GP Workflows in recent times. After having installed Web Services, MOSS 2007 and Workflows successfully, I thought everything is perfect. I tried testing a dummy workflow for GL batch approval creating a one approver scenario. I was able to submit the batch for approval successfully. However, When i tried approving the said batch, it takes no action. To identify what’s happening in the back end, I opened Event Viewer. Remember that there would be a separate events series called Dynamics that would be available once you have workflows installed on the Web server running workflows. Under the Dynamics events, it was registering the following error every time I hit the Approval button.  Action: SubmitTaskAction Current User LogOnName: Domain\Admin Input parameters: Exception type: System.ArgumentException Exception message: logOnName St...

In one of my earlier articles, I covered a common issue that we encounter during installation of workflows. In this article, I’d cover another issue that we encounter during uninstallation and reinstallation of workflows. Background of this issue goes on like this before I present the troubleshooting route that I took to overcome the same. In one of my implementations, I have installed all the pre-requisites required for Workflows and configured them successfully. Same is the case with Workflows for which the installation went peacefully. Problems started only when I identified the workflows are not working properly with the Approvals during the initial testing. After several unsuccessful attempts, I decided to take the hard way to get out of this issue. I decided to uninstall the Workflows completely and reinstall the same. Even repairing workflows wasn’t working. To add to my already existing problems, the uninstallation also failed returning a fatal error. After several attempts ...

Say you have Analytical Accounting installed in your system and assume you have multiple companies within the Dynamics GP Application. Now, You have activated Analytical Accounting in one or some of the companies and not all the companies. However, You’d see that Analytical Accounting Posting Journal prints every time you post a transaction in companies for which Analytical Accounting is not activated though installed. This is not an issue or a bug and it is by design. In order to avoid this coming up every time we post the transaction, we can go to Posting setup and unmark the AA Posting Journal in each series we’d want to avoid the same. Next time, you post a transaction, it’d not appear.

Couple of days back, I was trying to apply service pack 9(6.7.0.9111) to my current FRx installation which was at SP5. I have Analytical Accounting Add-in installed as well. I downloaded the SP9 from customer source that has AA Add-in. Ran the setup and it looked to be going smoothly until the below error surfaced in the end. “ The form is not of a legal path” . When I click further it goes on to say below If I then go to Report Designer and try to open the same, I get Run-time error91. I have tried everything I could but it still remains the same. Then, came a great support from my favorite Dynamics GP partner forums, Greg Byer has ensured all he could do to help me get past the error. Initially, it was diagnosed that the error might be due to some DLL files not registering properly. So, I was guided to download a batch file from partnersource that is intended to tell us of any DLLs failing to register(KB 848210). However, this batch file looks to be more automated that we canno...

Earlier, I reported in my post Couple of Known issues in Dynamics GP10 SP4 , some bugs that were discovered post SP4 release by Microsoft. Now, an updated smartlist dictionary must fix these issues, according to a blog post published on Developing for Dynamics GP. For more details on this Fix, Please follow the link here .

"All Call stacks are in Use. Cannot Start script" I've covered the basic resolution for this issue in my earlier post GP Troubleshooting-I . Recently, In a client place, I got to see this error back again in General Entry. I followed whatever troubleshooting steps required to rectify this that turned out to be futile. Finally, I figured out. It is the same issue as to Regional Settings. We must agree on a common ground that this error surfaces mostly due to SQL collation settings conflicting with Windows regional settings on Clients or ODBC settings for Dynamics GP. In my case, The collation being followed on SQL was ARABIC_CI_AS. It works fine on Server and some other clients. However, For some machines that are brand new, it gives the call stacks error whenever I open the General Entry screen. The resolution I adopted was the following 1. In the Regional Settings, I changed it to United States in the first place from Arabic(Bahrain) as you cans ee in the following ima...

In my earlier post on Fixes in Dynamics GP10 SP4 , I’ve covered couple of fixes that I found during the testing. Now, In this post,I’m covering couple of issues that are already identified by Microsoft Dynamics GP Technical support and being looked into that might be resolved at the earliest. 1.  You cannot export package files (xml) for Smartlists. 2.  You cannot edit a calculated field in a Smartlist.  Existing calculated fields seem to work, but if you edit one or create a new one, you will get the same error that you get when you try to export a package file. Remember that these issues have already been logged into and will be addressed soon by the Development Team, per an update posted in Dynamics GP partner Forum . Update : For a Fix on these issues, Please click here . ( Added on 09/01/2009 ) 

Two issues that I’ve seen in Dynamics GP V10 SP3 appear to have been fixed in Dynamics GP V10 SP4. 1.This is something I’ve posted in my earlier post. “Error : Posting to table POP30310. Restore from a backup if possible” message that appears while posting a shipment for Serial tracked item. Link for this post is here . This appears to be resolved in Dynamics GP10 SP4 as I can see during my testing. 2. Stored Procedure error while trying to post the Cash Book Bank Management entry in Payables Management. This appears in Dynamics GP10 SP3 "Cannot insert the value NULL into column 'TRXDATE' , table GL20000, column does not allow nulls. UPDATE fails and then The stored procedure Update_BM_PM_Date returned the following results DBMS: 515 and Dynamics: 0” This bug also seem to be resolved with Dynamics GP V10 SP4 as I can see it again during my testing. I’ll update any other findings subsequently as and when I find the same.

We get to see this message when Dynamics GP is installed and launched for the first time on a machine. “ To us the Smartlist capability in this product, the Smartlist table must be built. This is a one-time initialization process and may take a few minutes. Do you want to proceed with the initialization now? ”   Mostly during upgrades from previous versions, sometimes this initialization would result into errors that result in display of empty data in smartlists while returning different types of errors pertaining to smartlist tables. Not necessarily during upgrades, sometimes for various other reasons as well, we get to see the following errors. “A get/change first operation on table ‘ASI_MSTR_Explorer_Favorites_OrderBy” cannot find table” “A get/change first operation on table ‘ASI_Explorer_Export_Favorites’ cannot find the table”   Whenever I get to see these types of errors either during the upgrades where the initialization doesn’t happen properly...

When a Shipment is posted in Receivings Transaction entry screen, we get to see an error in the Posting journal that get printed after posting. Error: Posting to table POP30310. Restore from a backup if possible This happens if the line items on the Shipment include items with serial numbers. This issue can be recreated as follows. 1. Create two new items. One that is serialized and the other that is not. 2. Create a PO with both line items (Transactions | Purchasing | Purchase Order Entry) 3. Create a Shipment/Invoice for the PO using both items(Click Actions on Purchase Order Entry window | click receive and invoice the PO) i. Enter any value for the serial number when prompted ii. Post document 4. Look up receipt (Inquiry | Purchasing | Purchase Order Documents) a. Once you find the document on the list, click the drill back for the document to be taken to the Inquiry Zoom window EXPECTED RESULTS You should see the line item fo...

I. FRx reports headers are not coming over when trying to export it to MS-Excel? Make sure you’re using Formatted Excel while trying to export the report Headers are set up correctly Possible that a column layout is damaged. To test it out, create as many columns to rule out any building block being corrupted. If most columns are set to NP , in Excel they would remain hidden in which case, we have to un hide the same in excel. II.  We have lost the FRx password. How can we recover the same?     1. If you’re not using FRx security, then the GP login can be reset    2. If you’re using FRx security, then the Administrator can reset the password for them     3. If the Administrator password is lost, then a support incident need to be opened with Microsoft Support. A password would be provided by the support III. While installing FRx AA Add-in, Setup was unable to find FRx 6.7 for Great...

I. While trying to post a batch, the user receives an error saying the batch is being posted even though no other user is posting the same? Make sure you have a valid backup of dynamics GP data. Run the following script to verify the status in your company database (Login to SQL Server Management Studio). While being posted, the batch status would be set to 5 and now it has to be changed back to 0. UPDATE SY00500 SET BCHSTTUS =0 where BACHNUMB = ‘XXX’ ---Replace XXX with your batch number II. Sometimes a user by mistake prints a SOP transaction and then try to delete it, he doesn’t find an option to delete the same and instead, it has to be voided? For control purposes, it is always advisable to void the document and not delete the same. However, If it specifically has to be deleted, we can use the following script UPDATE SOP10100 SET TIMESPRT = 0 WHERE SOPNUMBE = ‘XXX’ ---Replace XXX with your Sop Number III. While doing a Dynamics GP Upgrade, Utili...