Dynamics GP Requisition Management Integration With MOSS 2007

Recently I responded to a thread on Dynamics GP Community forum pertaining to the subject in the title of this post. I thought I place the Q&A in this post since it might be helpful for others when they come across the same questions.

Q. Do we need to have Business Portal installed to integrate Requisition Management with MOSS 2007?

A. Requisition Management is part of Business Portal and not exactly part of MOSS 2007 or no integration for that matter. Business Portal itself requires either MOSS or WSS.

Q. Does Business Portal must be installed for us to use the Requisition Management module?

A. Yes. Because Requisition Management is a module that is part of Business Portal and not a stand alone product by itself

Q. When BP is installed, I assume it asks for the URL/ Server where our MOSS environment lives, does it then create a site within our MOSS site collection, so it appears seamless to the end user?

A. Basically If you have MOSS installed, First you need to install Web services for Dynamics GP before installing BP. If you are installing BP on WSS, Web services are not required. For BP, In MOSS, you'd first need to create a Web Application and choose Collaboration Team template. Then, When you start installing BP, First you'd need to provide the URL for your web services and then it asks for URL where BP is supposed to be installed. So,It doesn’t create a web application in MOSS by itself first you have to create it in MOSS, then when you come back to BP installation, You'd see the web application you created in the drop down to choose from.

For the complete discussion on this thread, Click here.

Reprint General Posting Journals

Back to basics. This is something most of the GP newbies ask us. While we have Posting Journals reprint functionality available for all other modules, How do we reprint the General Ledger Posting Journal?

In General Ledger for Dynamics GP, We do have a Posting Journal reprint functionality but we term the same Cross Reference Report. This report is available under Financial | Reports | Cross – Reference.

We can print this report based on Journal Entry restriction, Source Document or Audit Trial Code.


Auto Tweet from your Feedburner Feed with Socialize feature

Earlier, We’re using Twitter Feed to Auto Tweet our Blog posts. Now We don’t need to rely on Twitter Feed at all to do it. We now have another cool feature on Feedburner to do it directly from our feed itself. Check out how on my other blog



Invoice Management System for Dynamics GP simplified with IDS


I get requests from most of our clients, especially from clients in Distribution sector for simplifying their invoice Management process in Sales Order Processing for Dynamics GP. The other common request I get is to simplify the process of Customer Statements delivery as well as ability to provide them with flexible formats. On my look out for a solution that addresses these challenges in the most efficient manner and at ease, Microsoft Solution Finder did help me to identify a right solution for this, IDS for Dynamics GP. I thought I’d share about this product with my readers as well that would rightly help us meet our client requirements. Some of the key features as I could see from the solution when I downloaded and tried the demo

  1. Electronic Delivery of Invoices and Statements
  2. Have flexibility to send Invoices and Customer statements through several combinations like printing, e-mailing, faxing.
  3. Invoices and Statements Archiving that helps us save the paper a lot.
  4. Another good feature is ability to consolidate multiple invoices for delivery into a single transmission with a single file.
  5. Customer Contact Management simplified
  6. Ability to have multiple templates for invoices and statements
  7. Tracking user activity as to how many invoices or statements generated by each user.


More Screenshots are available here.

Among all, one great feature that I like the most is the flexibility to have our own custom invoices and statement templates defined which is most common stuff for us here.Especially Invoices Delivery Management is great to have to simplify the invoice management process. Moreover, The solution is a Microsoft Certified Solution. I tried the product downloading a Demo copy from the website and I should say it’s awesome. I can very much meet my client additional requirements in SOP using this add-in without taking time to customize myself. Just plug-in the application and We’re good to go.

More information can be found on this Add-in for Dynamics GP here.


Dynamics GP Blogs Analytics 2009


So, We are almost coming close to our Dynamics GP Year-End Process (In other words, Dynamics GP Blogs Year-end). Very recently, Bing has released 2009 Top Searches followed by Yahoo and Google. Following their path, Here are certain numbers for Dynamics GP as well. Just kidding!  I just thought to analyze how much contribution from our prime time bloggers on Dynamics GP is going into the community as a whole. One major objective of doing this exercise is to help Dynamics GP customers in specific realize as to how many resources they do have surrounding Dynamics GP community, specially how much they can extract from Dynamics GP Blogs in specific. I didn’t want to go beyond 2009 as it would cost me more time and so restricted to 2009 numbers. Secondly, Certain Blogs do not have Archives with numbers tagged so I have to skip them. So, Let’s go straight to the numbers.

I considered 15 blogs in total and have to skip around 5+ blogs. I’d say there are about 20 blogs which are most active on Dynamics GP out of which I’m presenting here for 5 blogs. There are almost 1842 posts covered through these 15 blogs on the chart for the year 2009. Out of which, Majority chunk coming from Mark Polino Blog which accounts for 657 posts. Mark has been so kind to refer other community members posts regularly apart from posting his own tips and weekly posts which are primarily attributable to these numbers. Then comes to Developing for Dynamics GP with 217, followed by Dynamics GP Blogster and so on. So, Guys, You have about 1842 posts to gain knowledge from. Out of these blogs, I’d say the highest number of posts with videos come from Rose Business Solutions which is a good resource to refer to for quick tuitorials.

Apart from the Blogs, Dynamics GP Newsgroup has about 13750 messages posted in 2009 while it is 1752 messages in Dynamics GP Google Group. (Source: Google Groups) Dynamics GP partner Forum has about 2143 threads with 12063 messages to read from though this is not available to customers. I didn’t consider the posts in Dynamics GP Developer newsgroup though.


Dynamics Community growing Strong with 30000 members base

It’s a great sense of happiness for each and every Dynamics Professional to see their community growing at an exceptional rate.

Refer to this article below for my views on this growth which is published on my prime Technology News Channel DynamicsBlogger

Microsoft Dynamics Community Hits 30000 Members Mark


Windows 7 Market share on the rise

Probably this is not a surprise to most of us who are on Windows 7 already. For those who haven’t, Wake up. Windows 7 is fast to capture the global market share within a very short period of time and continuing to improve further. For more information, Refer to this blog post



MSDynamicsWire Network integrated with Facebook Connect

MSDynamicsWire network, An exclusive network for Microsoft Dynamics professionals and companies to collaborate on Microsoft Dynamics opportunities has now got another exciting feature to its members. A month ago, the network is integrated with Twitter to enable the members sign in using their Twitter accounts. Now, The sign up process is made much flexible giving the opportunity to sign up using your facebook account as well. Facebook connect is now integrated to MSDynamicsWire network using the Facebook API framework.


MSDynamicsWire network is a steadily growing its membership base. The current membership base is 190+. As the membership continues to grow, We’d continue to bring loads of new features to the network for the members to gain from. For more information, Visit MSDynamicsWire Network.


FRx Transaction Detail codes for Dynamics GP

Following are the list of FRx Transaction Detail codes that work with Dynamics GP

• TSDESC (Transaction Description) ---will pull the Dynamics transaction description field (Don’t use this code if a description should appear in the DESC column)
• TJDESC (Journal – or batch header – Description) --- will pull the Dynamics batch name for unposted transactions or the originating source for posted transactions
• TAPL (Transaction Apply Date) --- will pull the Dynamics transaction date field
• TDOC (Source Document – Doc #) --- will pull the Dynamics source document field
• TSDOC (Original Source Doc – ex. Invoice) --- will pull the Dynamics originating document number field
• TREF (Reference Code) --- will pull the Dynamics transaction reference field
• TTYP (Transaction Type) --- will pull the Great Plains transaction type (standard or reversing)
• TSID (Source ID – Module, Journal Code, etc) --- will pull the Great Plains transaction source code field
• TBAT (Batch Code) --- will pull the Great Plains general ledger batch number field
• TCUR (Currency Code) --- will pull the Great Plains currency ID field
• TCURX (Currency Exchange Rate) --- will pull the Great Plains currency exchange rate field

Source: Dynamics GP Partner forum Thread, Credit to Cory Severson

Excel Report Builder: “Wrong number of arguments to replace text”

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

Should We choose WSS or MOSS 2007

This is the most common question I get to hear from many customers as well as various forums discussing on Dynamics GP. I thought I’d put some information here for those who are uncertain about which way they should go, whether WSS or MOSS 2007.

1. If you want to install Business Portal, You can choose either Windows SharePoint services (WSS) or Microsoft Office SharePoint (MOSS) 2007. It works with both these services. However, It depends on other factors also as given in below lines.

2. Within Business Portal, If you are looking to have the Search site functionality, then you would need MOSS 2007

3. If you want the Workflows for Dynamics GP besides Business Portal, you’d need MOSS 2007. Remember that Business Portal is not a pre-requisite to installing Workflows as both of them work independent to each other.

4. If you require Field Services suite within Business Portal, then you should be looking at MOSS 2007

5. If you choose MOSS 2007, then the prerequisite to Business Portal would be to install Web services for Dynamics GP. Web services work with Business Data catalog (BDC) functionality to create dashboards that do not exist in BP on WSS 3.0

6. There is a difference in terms of navigation in BP by choosing between WSS 3.0 and MOSS 2007. When installed using MOSS 2007, Business Portal chooses Collaboration portal site template which includes Report center and Search Sites.

7. If you are just looking to have Requisition Management in Business Portal, then you’d just need WSS 3.0 with BP installed. This is another question I get most times with people getting confused with assuming Requisition Management Approvals require Workflows. Requisition Management Approval hierarchy is part of the standard BP functionality and not part of Dynamics GP Workflows functionality.

To know about the distinction between WSS and MOSS, Visit this link.

Currency ID blank during e-connect Integration

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


Shout out for MSDynamicsWire: From Top Bloggers on MSDynamics

image It is 2 months MSDynamicsWire was launched and I’m happy at the level of recognition it is receiving from our Microsoft Dynamics Community, one of the largest growing communities around the globe. It was a small idea combined with my huge passion towards Microsoft Dynamics in specific that led to the inception of MSDynamicsWire. Strengthening the community is strengthening the product base which in turn helps us grow along with the product we do serve.

Some of the best blogs that talk about MSDynamicsWire: Why don’t we just visit them straight?

1. Jim Glass, A well-known personality and a big help resource for Microsoft Dynamics CRM professionals. He is currently serving as Microsoft Dynamics CRM UX Site Manager. He spent few minutes of his precious time space to talk about MSDynamicsWire on his famous blog A CRM Riff.

2. Mark Polino, Another great personality and a Microsoft MVP.He is currently working as a Senior Consultant for I.B.I.S and he writes on Dynamics GP on his well noted blog DynamicsAccounting.net. He has this much to say about MSDynamicsWire.

3. Vaidyanathan Mohan, An active blogger on Dynamics GP and a free-lancer professional presently having his base in his newly found home, Dubai. Here is what he has to say about MSDynamicsWire.

4. Mohammad Daoud, Another Microsoft MVP and a big time resource helping Dynamics GP community through Newsgroups and his blog has this much to say about MSDynamicsWire.

After all, end of the day It is these little words from the community that matters to me more than anything else.


Another Workflows Error

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

“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..”

A very small and quick resolution to this issue. Just run the following commands

NET STOP “windows sharepoint services timer”

NET STOP “windows sharepoint services timer”

For a complete library of workflows related subject published on this blog, Follow this link.


Fixed Assets Integration fails

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 manually out there. Save the Asset record that you just created. Now, Come back to your integration that contains about 10000 assets (just kidding) to integrate. Run the integration. Voila! It integrated your 9999 assets in just a matter of couple of minutes time (Granted that you don’t have any other genuine errors in your integration)


Work, Open and History

I thought I’d just summarize the meaning of these statuses we would see in Receivables and Payables modules as I had recently encountered this question in newsgroup.

Work Status

In both Receivables and Payables modules, a document is assigned ‘work’ status when the said document is saved in a batch.

Open Status

In both Receivables and Payables modules, a document is assigned ‘open’ status when the said document is posted

History Status

In Receivables module, a document is moved to ‘history’  status when the said document is fully applied and then the Paid Transaction Removal (PTR) routine is processed.

In Payables module, a document is moved to ‘history’ status when the said document is fully applied.

History status would also be assigned when the said document is voided as well in both receivables and payables modules.


Time to look beyond Twitter

msdw_tumblr We are able to send updates to our followers by way of tweets on a regular basis helping us maintain a good networking with our community. Be it DynamicsBlogger, MSDynamicsWire, Mark Polino, Mariano Gomez or David Musgrave, they are all bringing you their blog posts and other personal updates through their Twitter accounts. We have several companies operating in MS Dynamics space using Twitter as a broadcasting medium to reach their Customers bringing them the latest news updates.

In my earlier articles, I covered about the best ways of using Twitter to expand your reach. Surprisingly,Twitter is not the only candidate in Micro Blogging platform and we have several other candidates to look at. Tumblr is one of those deserving candidates to definitely look at for efficient micro blogging. Tumblr is an eye-catching scrapbook that helps you post short text blogs, post links, post chats, video or Audio, re blog your favorite blogs. More important is the fact that it also has several features like posting from Phone, E-mail. All the posts in your Tumblr account can be tweeted automatically to Twitter as well as the same can be sent to your Facebook accounts. You can follow your favorite blogs on Tumblr just like how you do with twitter.

If you’d like an example on this, You can very much look at my own blog just started on tumblr that would shortly be the official blog of MSDynamicsWire.com. Here is the link to have a look at how Tumblr can make a real difference of Micro blogging


(In future the blog can be reachable at http://blog.msdyanamicswire.com.)

This can be the best deserving candidate to be your company’s official blog. People wouldn’t like to read big stories yet they would really prefer to hear short stories which can be achieved in its best form through Tumblr. So, What for you are waiting? Open an account with Tumblr and explore the benefits it can offer to us for no cost.


Workflows Error

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. 



Current User LogOnName:


Input parameters:

Exception type:


Exception message:


Stack Trace:

at Microsoft.Dynamics.Workflow.Common.ArgumentHelper.
(String userName, String argumentName, String classMethodName)

at Microsoft.Dynamics.Workflow.WorkflowSecurityManager.
CheckAccess(String logOnName, WorkflowAssociationKey
workflowAssociationKey, WorkflowSecurityGroup
[] workflowSecurityGroups)

at Microsoft.Dynamics.Workflow.Schedule.
(Object sender, ConditionalEventArgs e)

at System.Workflow.Activities.CodeCondition.
Evaluate(Activity ownerActivity, IServiceProvider provider)

at System.Workflow.Activities.IfElseActivity.
Execute(ActivityExecutionContext executionContext)

at System.Workflow.ComponentModel.ActivityExecutor`1.
Execute(T activity, ActivityExecutionContext executionContext)

at System.Workflow.ComponentModel.CompositeActivityExecutor`
1.Execute(T activity, ActivityExecutionContext executionContext)

at System.Workflow.ComponentModel.ActivityExecutor`
1.Execute(Activity activity, ActivityExecutionContext executionContext)

at System.Workflow.ComponentModel.ActivityExecutionFilter.Execute
(Activity activity, ActivityExecutionContext executionContext)

at System.Workflow.ComponentModel.FaultAndCancellationHandlingFilter.
Execute(Activity activity, ActivityExecutionContext executionContext)

at System.Workflow.ComponentModel.ActivityExecutorOperation.
Run(IWorkflowCoreRuntime workflowCoreRuntime)

at System.Workflow.Runtime.Scheduler.Run()

After a series of diagnosis on the error, I could finally resolve the same. The issue was with Service Accounts for MOSS as well as not importing the user profiles for Shared Services Provider (SSP). While configuring the MOSS, I used same account which is a farm administrator also for all service accounts. Certain Service accounts provide read-only access to the SharePoint databases. So, the account with which I’m trying to approve is being denied access due to the fact that the system is not able to identify this user as an administrator despite the fact that the said account is a workflows administrator in the web services security console as well. Adding to this, there is one step in MOSS configuration where we have to import all Active directory users into the shared services provider. I skipped this step too initially. After correcting these issues, the workflows started working absolutely perfect. So, We have to be 100% sure that we configure web services for Dynamics GP, MOSS correctly in order to ensure the workflows run successfully. Any small misconfiguration would lead to a failure of workflows.


Reset Workflows in Dynamics GP

Recently while I was testing the workflows for Dynamics GP, I have had to uninstall the Workflows. Prior to uninstalling the workflows, it is always recommended to deactivate the active workflows. I forgot I was having GL Entry batch approval workflow active while doing this uninstall operation. The result was whenever I login to GP and try to open the General entry or GL batch entry window, I get a message saying Dynamics GP encountered an error and needs to close. Then it crashes immediately. I observed the GL batch entry window continue to show Workflow layer on top of it. In order to overcome this issue, I followed this troubleshooting method as below

1. Tried deactivating the workflows by going to Microsoft Dynamics GP | Tools | Setup | Workflow Setup. I could not unmark the Activate Workflow option there.

2. I went to SQL Server Management Studio (SSMS) and ran a statement on my company database SY00500 table to see the active batches for which workflow shows to be activated. I ran the following statement to update the active workflow batches to remove the reference of workflows from those batches


3. Then went to DYNAMICS database, Ran the following statement


Now Try logged in Dynamics GP and checked if the same error as reported originally above is recurring. It is perfect this time.


Dynamics GP Workflows Uninstall Fails with a Fatal Error

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 again to uninstall the same, in a frustration, I uninstalled Web Services, MOSS and even Business Portal just to make sure I wanted to have a clean install.

The same fatal error prevailed even after uninstalling the whole thing and reinstalling the same pre-requisites. What to do? I have to make a choice here again. Then comes the most hard decision. To go through an unsupported method. (Please be advised that this is an unsupported method and readers are requested to exercise caution)

1. Uninstalled the Workflows using Windows Installer Clean up utiliy. Remember that Windows installer clean up doesn’t delete the actual program.

2. Backed up the Registry.

3. Went to Registry Editor (regedit.exe) and identified the Keys for Workflows  as below



4. Deleted the above keys. We can identify the keys by seeing the display name of the same.

5. Rebooted the server.

6. Tried installing the Workflows again. For a minute, I thought It went past the earlier error. It did before it failed again returning the following errors



C:\ Program Files \ Microsoft Dynamics\ Workflow \Microsoft.Dynamics.Workflow.Install.RegisterSchedule.exe returned '-532459699'


7. To overcome the above errors, I opened the stsadm.exe command prompt and ran the following commands.

•    stsadm -o deactivatefeature -name DynamicsApproval -url <DynamicsGPWorkflow URL> -force
•    stsadm -o deactivatefeature -name DynamicsWorkflowForms -url <DynamicsGPWorkflow URL> -force
•    stsadm -o deactivatefeature -name DynamicsWorkflow -url <DynamicsGPWorkflow URL> -force
•    stsadm -o uninstallfeature -name DynamicsApproval -force
•    stsadm -o uninstallfeature -name DynamicsWorkflowForms -force
•    stsadm -o uninstallfeature -name DynamicsWorkflow -force

Note: DynamicsGPWorkflow URL should be replaced by actual workflow URL

8. Tried installing it again. voila! It worked.


GP Webinars from I.B.I.S

We love anything that is tagged with the word “free”. Isn’t it? How about getting a good quality stuff at no cost? Sounds good. I.B.I.S is kicking off series of Dynamics GP webinars as part of their Dynamicscare services. Six webinars are being kicked off this quarter and many more to come. Personally, I like this initiative from I.B.I.S trying to empower the Dynamics GP community with loads of knowledge through these webinars. I strongly feel we have to make sure we support every initiative from our community of anything like this. So, No wait. Just go and register for the webinars and let us make the events a great success.You can find complete details of Webinars following this link here.

Is ANYTHING free these days?
Date: 11/3/2009 11:00-12:00 EST
Speaker: Christina Belding, I.B.I.S. Managing Consultant

A quick review exploring Customer Source, un-publicized Microsoft resources, and some of the best tips & blogs out there that will enable you to research like a power user (even if you aren’t one)!
Support Debugging Tool
Date: 11/10/2009 11:00-12:00 EST
Speaker: Mark Polino, I.B.I.S. Senior Consultant and Microsoft MVP

Learn about this great FREE tool from Microsoft that provides multiple logging and debugging functions as well as look and feel options within GP.

Dynamics GP and the “Lean” Office
Date: 11/17/2009 11:00-12:00 EST
Speaker: Amy Walsh, I.B.I.S. Senior Consultant
Tips on how to incorporate Dynamics GP functionality into the “Lean” methodology of business processes.

Business Intelligence
Date: 12/1/2009 11:00-12:00 EST
Speaker: Dwight Specht, I.B.I.S. Chief Operating Officer
What is BI? Which BI tools and products would benefit my business? What kind of investment in money and time will we have to make? Join us as Dwight shares his Business Intelligence expertise.

SQL Server Tips  
Date: 12/8/2009 11:00-12:00 EST
Speaker: Mark Polino, I.B.I.S. Senior Consultant and Microsoft MVP
Tips on how to run SQL queries from both the Support Debugging Tool and Admin Console; run through some common queries, and learn how to copy and paste headers from Management Studio.

ISV Spotlight – Tectura ReqLogic
Date: 12/15/2009 11:00-12:00 EST
Speaker: Rich Fowler, Tectura Expert
Learn about the leading .NET browser based application for procurement, requisitioning, vendor invoicing, expense processing and workflow, that integrates seamlessly with Microsoft Dynamics GP.

MSDynamicsWire Network is integrated with Twitter Sign-on

In order to provide the MSDynamicsWire readers a collaborative platform to exchange ideas, there is a Network that is started a week ago. Since MSDynamicsWire caters to all Dynamics products, the network is open for all people whose interest is Microsoft Dynamics. Since its inception, It is receiving good response from our Dynamics community, members base increasing from 0 to 120 within 5 days and lot of members coming forward with great ideas. My passion towards MS Dynamics keep me engaged in coming up with new ideas all the time and I continue to explore in that direction in future as well, thanks to the sustained support from our Dynamics community.

Keeping in view of the growing membership, I decided to give a charge to this new network in the form of bringing new features to it. Some of those new features introduced this week are as follows

  1. Video and Text Chat:. This will help members to communicate easily whenever they get to see other members online.
  2. New Theme: Network has a new theme now bringing new look and feel
  3. Twitter Connect: Now, this is the most powerful feature for the network to sign in using your Twitter ID itself. This means it is now more easy to sign up for MSDynamicsWire network. One can either sign up using the regular sign up form or using your Twitter account on our welcome page 
  4. Visitor Radar: Now, You can keep track of members visiting your profile in Visitor Radar available on your profile. This will help you to communicate with interested members.
  5. We have also made the News and Magazine tabs to public view to help the members writing good content on our network blog get more additional exposure.
  6. In future the network would be accessible on http://network.msdynamicswire.com.
    Currently, this is being tested on our end and We'll confirm the same once it is tested successfully.
  7. Profile Designer: Now, You can customize your profile using Profile designer
  8. Apart from above, there are several other features in pipeline like Facebook Connect. We'd publish the new developments as and when they happen on the network.
  9. One can invite their contacts by importing contacts from various web mails using Invite your contacts feature

More features like Facebook Connect and several others are planned for the upcoming weeks and these features would continue to be added in conjunction with growing membership and activity around the members.

For those who would like to know more about the network, they all are welcome to join the network as long as they are either directly or indirectly related to Microsoft Dynamics.

Link to MSDynamicsWire Network is http://msdynamicswire.socialgo.com. Please note that I’d be moving this to my principal domain after which the access to network address would be http://network.msdynamicswire.com.

Link to our main website is http://msdynamicswire.com

How to change the Business Portal Logo

I was actually looking for a solution on this and I’m glad that Allan Cahill from Dynamics GP technical support has provided a great solution recently in response to a question raised by another fellow member on Dynamics GP Forums. You can find the link to this thread by clicking here.

Put the new gif (example of type) file in the same folder as the logo.gif (By default, it is C:\Program Files\Microsoft Dynamics\Business Portal\Portal\Images)
2. On the Business Portal Home Page, go to Site Actions > Site Settings > Title, Description, and Icon (under Look and Feel)
3. Change the Logo.gif to be your image file and click OK. Be sure the URL uses the following path: /Business Portal/Portal/Images/
4. Click the browser’s Refresh button to display the new company logo.
If your company’s logo does not appear, you may need to delete your temporary Internet files. To do so, choose Tools > Internet Options from your browser’s menu bar. The Internet Options window appears. Click Delete Files. Click OK, then click the browser’s Refresh button again.
Logo recommendations:-
File format: The logo file must be a .gif, .bmp, .jpg, or .png file.

Size: The height of your company’s logo must not be more than 50 pixels. The width can vary, but be sure that the logo doesn’t overlap with the company name that appears in the top-right corner of Business Portal.

Transparency: Recommended to configure the logo so that its background color is transparent.

This is a great information that helps everyone.


Michael: Avoid GP modifications with VS Tools

Michael has come out with an interesting post on VS Tools for Dynamics GP explaining with a small and crispy example. A must read article for GP developers


As Mariano rightly points out in the comments column of that article, It looks like an extension to what Mariano has originally started with his VS Tools series.


Facebook: Is it Reliable anymore

Facebook, World’s largest social networking site and the most popular brand best known to everyone of us. Then, Why is the question in the title whether it’s reliable anymore? May be or may not be. Recent developments happening with Facebook can scare anyone.  Have you ever ran into issues with your account held with any of the popular services like Yahoo, Google, Hotmail for more than 7 days and don’t know whether your account would ever be restored? Definitely Not. However, It is happening with Facebook, A social networking site with more than 300 million users. No one knows how many are affected yet. However, Many feel the numbers are quite heavy. I’m one among those unfortunate set of people whose accounts are hanging in uncertainty for more than 7 days. Initially We get to see a normal “Site maintenance error”. Later after the so called site maintenance started attracting media attention, we started seeing a little detailed message which goes like this


One can imagine the plight of those affected users when they get to see these messages being posted on Getsatisfaction.com. One of the messages goes on to say like this

I have no idea what is going on in my friends’/family’s life without being able to read Facebook Status updates. I did not realize this that this was my main means of “keeping in touch” with my loved ones. Through their status updates, I learned of job promotions, engagements, births and moves across the country.”

One can also have a look at this news article posted on Cnet News on the downed Facebook.

My account with Facebook is currently held at the fate of Facebook itself including the MSDynamicsWire group that I started a month ago. To get away from this Facebook frenzy, I now have created a network with SocialGo that can be reached at http://msdynamicswire.socialgo.com in order to keep myself and MSDynamicsWire.com  within the reach of Dynamics community. I’m happy with the features given by SocialGo and would expect the new network to rock in the future days, thanks to the support of my fellow community members. I thought this is the best way to get rid of the Facebook.


Nigel Frank Annual Salary Survey for MS Dynamics Professionals

Nigel Frank International, one of the biggest Microsoft Dynamics recruiters in Europe is conducting an annual salary survey of Microsoft Dynamics, an exercise of which is to be an annual occurrence. The survey will only take a couple of minutes to complete and your response and any personal details will be kept strictly confidential. The survey is available in the following languages for your convenience; English, German, French, Dutch, Danish, Spanish, Italian, Norwegian, and Finnish.

I feel this is a very good initiative and would definitely help MS Dynamics professionals in the form of knowing the latest salary trends by product as well as help fill any gaps in the average pay scales for a MS Dynamics Professional by Title and years of experience.

Why can’t we just spare 2 minutes of our valuable time in marking couple of questions on the survey? For those who would want to fill this survey and support the initiative, here is the link for survey



Downtime of MSDynamicsWire.com

Since yesterday evening we experienced serious issues with my portal www.msdynamicswire.com . The servers are hosted at www.hostnexus.com on a shared hosting plan. Unfortunately the service was a disaster. I have to literally communicate with them the whole day that resulted in no use. What I heard from them finally is that my site is taking away the bandwidth of their entire server after a 24 hours wait almost. Lot of my friends wrote to me asking for the reasons why the site was down. These are certain issues we experience when we go with a shared hosting provider. Then, I decided to call it a day with Hostnexus and immediately turned on to www.alurium.com that I heard from the people to be completely compatible with Coldfusion and much faster. We’re now in the process of migrating to the new host and we hope to be finally up and running by this evening or tomorrow early morning if things go well. I must thank my readers for their patience on this change.

UPDATE: Now the servers are up and running. (Added 09/25/2009)


Tweet to expand your Reach

twitterlogo In my earlier article, Now follow Dynamics GP Blogs on Twitter, I’ve provided the ways of following DynamicsBlogger. Since its inception, the Twitter account is attracting so many followers. Today what we can call a Twitter Age. We get to see most of Dynamics Players, be it Partners, professionals on Twitter. Doesn’t it sound good that Twitter presents a great networking opportunity for all of us? Definitely Yes. So, How can we go about finding ways to expand our reach in Twitter. I’m listing certain common tips for expanding our reach through Twitter.

1. Ensure You are tweeting on a regular basis with useful tips or articles about MS Dynamics

2. If you have any RSS Feed of your blog, You can automate the posting of it using certain Applications like Twitter feed.

3. Ensure you frequently check for other guys out there on twitter whose interest is MS Dynamics too. You can search them using Twitter search Find People.

4. Ensure you mark them to Follow and be followed by them as well

5. Now the most important tip comes. How can we ensure your tweets appear in the results when someone searches for MS Dynamics? We have certain common keywords being used on MS Dynamics to ensure it get indexed that way and returns results when someone searches the same. Here are the common keywords you must be using to ensure your tweets can be found easily.

1. Ensure all your tweets are prefixed or suffixed with #Dynamics. This will ensure whenever someone searches for Dynamics or MS Dynamics, your tweets would appear in those results.

2. Inc case you’re posting a Dynamics CRM related tweet, Use #Dynamics CRM. This will ensure your tweets appear in the results when someone searches for Dynamics CRM.

3. In case of Dynamics GP, the most common keyword being used is #DynGP. So, Use the same in your tweets on Dynamics GP.

4. For Dynamics AX, the keyword to be used is #Dynamics AX.

5. For Microsoft, We can use #Microsoft.

We’re not seeing much activity on other Dynamics products unlike the above that are quite active in Twitter or may be I’m not aware of the activity.

Enjoy Tweeting!


Exchange Rate Entry Maximum Decimals

I’m quite busy working on my new portal MSDynamicsWire.com in the past week that led to being slow in my blog writing and I hope my blog readers would excuse me for that. In this article I’d talk about a call that I received during this morning from one of my clients seeking a clarification on the maximum decimals allowed for exchange rate entry.


Their query is what are the maximum decimals allowed in Dynamics GP while entering an exchange rate during transaction entry. Maximum decimals are critical especially for currency exchange houses or banking institutions where the foreign currency activity would be higher. A one decimal change would lead a huge variation in revaluation or realized gain/loss. The answer for the maximum decimals allowed for an exchange rate  in Dynamics GP  is 7. Users have to be cautious in entering the decimals since any entry beyond 7 decimals would lead to a complete mess up of the exchange rate as you could see in the example above that a rate of 1.1234567 for JPY currency. If a decimal, say 8 is added to the rate, the rate would become 11.2345678. Assume the difference it makes?? Huge, Isn’t it?


Announcing the launch of MSDynamicsWire.com

It’s finally live! Today MSDynamicsWire.com Beta version is launched after months long effort. The portal is dedicated exclusively to aggregate content happening in and around Microsoft Dynamics. Since it is launched as a Beta version, more development is due in the future months before we would see more enhanced versions. This portal makes use of ColdFusion as the base technology helping the aggregation much faster.
Events section needs to be still added to each of the categories in the portal so as to have a one place to view the updated events information.
The Portal web address is www.msdynamicswire.com
Press Release regarding the launch of the Portal can be viewed at this link http://www.prlog.org/10340248-announcing-the-launch-of-msdynamicswirecom.html

PDF Version of the press release can be viewed here in this link http://www.prlog.org/10340248-announcing-the-launch-of-msdynamicswirecom.pdf


CBM: Post Through PM

Of late, I’ve been working on Cashbook Bank Management module for a client. As part of the setup, I marked Post through Payables management and post through General Ledger as you can see in the below screenshot.


If you observe, the GL Posting date is set to pick up by Transaction. So, While testing the transaction flow of payments in CBM, everything was going fine until the posting of payment. After posting, when I got to see the Manual Payment Journal, I observed there is a work message that says below.

“Batch Information is invalid. This Transaction contains errors. It won't be posted” 

Then I went to see what’s the status in Payables Batch. The CBM batch that I just posted is again lying as a batch in Payables Batch. I tried posting the same and it posts fine without any errors. Now, its turn with GL Batch. Went to see if the GL posting has done at least. No, This is again standing as a batch in GL. Posting the same completed without any errors. This flow is the same for all transactions. Finally, went to Microsoft support inquiring on the status of this message. I just came to know that this is a known bug scheduled to be addressed in Compliance 2009 release expected in November 2009. The only workaround for this issue is to use the GL posting Date Batch option instead. For those who would want to know the specific bug details, Here is the information.

54193 --The "Post Through Payables Management" option at the checkbook level in the Bank Management Options window is ignored if you are using "GL Posting Date From Transaction" in CBM.


AA Posting Journal prints for every transaction posting

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.

Posting setupNext time, you post a transaction, it’d not appear.

FRx6.7 Service pack issue

Couple of days back, I was trying to apply service pack 9( 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

image 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 cannot see the errors in specific. Then, Greg has actually provided me with another batch file that actually goes and register each DLL and tell us anywhere if a specific DLL fails to register. I ran the batch file keeping the same in my FRx program folder, then I got to see each DLL getting registered while it was struck with this error in specific

“LoadLibrary (windows/system32/msxml4.dll) failed - A DLL initialization routine failed."

Then, I searched for msxml4.dll file in system32 folder, registered that file manually. Then went to see if I’m seeing the error again. No. It worked this time. Sometimes, when a particular DLL fails to register properly, We cannot easily identify which DLL is causing issue for us. However, possessing this batch file actually help us resolve the issue much faster. It’s quite handy. Anyone would want to get the file, Please e-mail me at my contact address. I’d be happy to share the same with you guys.


Dynamics GP Blog Carnival – I

In the first week of August, I made a new initiative of announcing the Blog Carnival that will be published on September 3rd 2009. As I stated in that post, the idea is to effectively bring various interesting articles from bloggers blogging on MS Dynamics GP in Blog carnivals format. Unfortunately, I didn’t receive a single submission from anyone in the Dynamics GP Blog Network except few submissions that are irrelevant to Dynamics GP subject. Probably, not everyone understood it right or the original post making the announcement for submissions lost enough visibility. In order to keep this idea alive, I’m going ahead publishing this carnival choosing the articles from Dynamics GP Blogs network myself. Here is the Dynamics GP Blog Carnival – I dedicated to all of my blog readers.

I’m starting this Blog Carnival–I by picking up the article from Developing for DynamicsGP authored by David Musgrave. David provides us a brief but interesting information about the Smartlist Alternate lookup windows versus Dynamics GP original lookup windows. Here is his article Why do my Lookup windows look different.

The Dynamics GP Blogster, Blog authored by MVP Mariano Gomez. Mariano presents a valuable tip for Dynamics GP Developers in his post. He talks about how Dexterity can be enhanced to allow long physical names. Do not want to wait further reading this interesting tip? Here you go, Mariano Gomez’s Dex – Enabling Long physical table names.

Dynamicscare Blog maintained by I.B.I.S. In this blog, Gerhard Venter talks about the Microsoft SQL Server Reporting Services text boxes issue and how to get past the issue. Interesting piece of information for Dynamics GP readers working on SSRS specifically. Here is the feast for you guys. Gerhard Venter’s What to do when Microsoft SQL Server Reporting Services text boxes refuse to get into line.

Next comes the Rose Business Solutions Blog, multiple authors writing interesting stuff on Dynamics GP. For this Carnival, I’m picking up a latest article written by Doug Pitcher on the effective need to back up the databases prior to processing payroll. His article made me think about how PEOs’ and HROs’ who use Dynamics GP Payroll to process several thousands of Pay checks and quite huge number of pay runs every day. It becomes a heavy task for them if backing up database for every pay run is necessary.Here is Doug’s article Should you backup your database before processing payroll?

About Dynamics, Development and Life, authored by Jivtesh. Jivtesh is not quite active on his blog, yet, he comes with a great post describing the FRx – Rebuild GL Index Option – The why and how article published recently.

MVP Frank Hamelly who writes heavily on Dynamics GP in his gp2themax blog, comes again with a Daily Tips series. I’m publishing his first daily tip changing currency decimals on inventory Items. Guys, continue to check his blog for other daily tips.

Janakiram M.P. (It’s me!) blogs on DynamicsBlogger exclusively on Dynamics GP stuff. I have written SCM Metrics II – ABC Analysis worth reading for you. Don’t forget to check other articles out there only for you.

MVP Victoria Yudin blogs on her victoriayudin blog. She is well known for her SQL scripts tips and reports tips. In this carnival, I’m picking up her latest SQL view for all posted GL Transactions in Dynamics GP article that will helps us all.

Do you want to reset your system password in Dynamics GP? Here is an interesting tip coming from Steve who blogs on VSTools Forum blog. Check out his tip yourselves in this article Need to reset the System password in Dynamics GP.
Vaidyanathan who blogs on Dynamics GP in his Dynamics GP – Learn & Discuss Blog, written an article on the importance of a source code control program. Check out his article at Importance of a source code control program.

Gloria Braunschweig who blogs on Dynamics GP on her Computeration Dynamics blog presents us with the GL Journal Types article that explains various Journal types. Interesting piece here comes for you Use Journal Types to your advantage.

Have you ever got to see Dynamics GP Security console error while adding users to Dynamics GP web services security console? If yes, you might want to check DynamicsGeek blog authored by John Limey Bastow in his Dynamics GP Security Console Error - “Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))”.

Christina Philips and Steve Endow together blogs on Dynamics GP Land blog bringing outstanding articles on Dynamics GP. In a latest post, Christina talks about simplifying Sales Tax in her article Sales Tax Simplified.

Have you been getting Invalid Object Names errors of late in Business Portal? Here comes the answers from Ian Stewart’s DynamicsGP.ie blog post Business Portal – Invalid Object Name errors.

Dwight Specht and Curtis Beebe blog on managing a Microsoft Consultancy in their The Death of Reason Blog.In their latest series of articles, Dwight talks about evaluating consulting staff in his article Evaluation of Consulting Staff.

MVP Mohammad Daoud blogging on his blog brings a helpful article on Analytical Accounting error: Cannot insert duplicate key in object ‘dbo.AAGXXXXX’.

Steve from Meritsolutions blogs on Dynamics GP in his meritsolutons blog. In a latest series of articles, Steve talks about Costing in Dynamics GP10: Standard Vs.Actual Costing.

Inside Microsoft Dynamics GP Blog brings us Do you know series every week. In this week, AndyW has come out with Week 11: Do you Know? Series of the Week article about new report functionality introduced in Dynamics GP10. Also check out all past weeks articles filed under this link.

DynamicAccounting.net maintained by Mark Polino brings a tip about speeding up Receivables Aging process in his weekly Dynamics series. Here comes the tip in his article Weekly Dynamic: Speed Up the Receivables Aging Process.

Eric Greathouse is writing a series of articles on Multicurrency setup in Dynamics GP on Dynamics Solution Edge Blog. Go check out his nice piece of information in his latest article Multicurrency Setup in Microsoft Dynamics GP - continued -

Are you looking for replace SAGE MAS90/200 with Dynamics GP? Kimberly Kohlhepp from SBS group writes about Top 5 reasons to migrate to Dynamics GP in erpsoftwareblog. Check out his article Replace SAGE MAS90/200 with Dynamics GP.

If your position in IT department requires you to find and maintain Dynamics GP vendor, consultant or business partner, Here is a great piece of information from CenturyFive.Net blog written Andrew Karasev coming in for you in this article. DynamicsGpTechnicalSupport:LocalVersusRemoteGreatPlains.

We now came to the end of Dynamics GP Blog Carnival-I. Hope you enjoyed reading all the articles in this carnival. I’m scheduling the next Dynamics Blog Carnival-II for October 2nd 2009. Taking this opportunity, I’d like to bring your attention that Dynamics GP Blogs articles are available on Twitter at DynamicsBlogger.


Discontinuance of Microsoft Dynamics Mobile

Microsoft announced that it will discontinue the Microsoft  Dynamics Mobile – Server components and Microsoft Dynamics Mobile – Device components will be removed from Partnersource and the Microsoft Dynamics Mobile CAL will no longer be available for ordering effective August 31, 2010. The announcement can be accessed by partners following the link here. This strategic decision to discontinue the current development of Microsoft Dynamics Mobile is made in line with broad availability of partner-developed mobile solutions built on these or similar technologies.

What it means for the customers and partners? Customers need to choose from Microsoft Dynamics Mobile solutions developed by other certified partners.


Updated Smartlist Dictionary released for bugs in SP4

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.


SCM Metrics II – ABC Analysis

In my earlier post SCM Metrics I – back orders, I covered on how we can track back orders in Dynamics GP for efficient SCM. In this post, I’ll cover yet another powerful Analysis functionality, ABC Analysis available in Dynamics GP. ABC Analysis in Dynamics GP is easier to implement with several options available for us to choose from. Common categorization is A – 80%; B – 15%; C – 5%.


ABC Analysis is in its simple form, a way to categorize or group the products. Most common method is to categorize items based on Annual Quantity usage. Dynamics GP ABC Analysis functionality not only provides to categorize items based on Annual Quantity Usage, it also gives other other methods to choose from.


  • Usage quantity (the number of units consumed over a period of time)
  • Usage value (usage quantity times unit cost)
  • On-hand inventory value (on-hand quantity in the Items Quantity Maintenance window times unit cost)
  • Unit cost (the current cost or standard cost depending on the valuation method of each item)

For Usage Quantity as well as Usage value, It also offers the Analysis options below

  • Historical usage
  • Projected Usage
  • Weighted Average

imageWithout having to do this task manually, Dynamics GP does it for us and do the analysis of the items based on our parameters as can be seen above. However, Remember that there are also other considerations, such as "critical items" that may have low usage,  but need special monitoring because you can't run out of stock due to a customer agreement. So your definition of A items may need to be  customized.

For those who are not aware of ABC Analysis in Dynamics GP, It is available in this path. Inventory | Routines | Item ABC Analysis.

In my upcoming posts, I’d cover another SMC Metric.


Dynamics GP Forums: Got two answers in 20minutes

This morning I was looking at my Twitter followers list and marked some followers on my following list who share common interest, Dynamics GP. Among the Followers that I  follow include Mark Polino, Mohammed Daoud, Rose Business Solutions, Avende,erpsoftwareblog, dynamicsworld.

Good news is the followers list for DynamicsBlogger is ever expanding. While looking at some of the tweets from my followers list, I have this blog article from dynamicsworld that caught my attention. The Author Stephen Cantor shares his latest experience with Dynamics GP forums. He talks about how he posted a question in one of the several Dynamics GP Forums and how he got perfect answers within 20 minutes of his posting. Isn’t it amazing? This is something that everyone agrees with him. Dynamics GP Forums have always been helpful and continue to be so. Several of the community members dedicate their precious time in answering questions. Dynamics GP has several communities to help people. Most of them are Microsoft hosted and some forums are hosted on non-Microsoft sites. I’d list the Microsoft hosted ones here.

1. Dynamics GP partner Forums – This is exclusively for partners. Here is one forum that helps partners save their support calls and get their questions answered. Requires a Microsoft Partner Login for access. Moderated by Microsoft Dynamics GP Support Team.

2. Dynamics GP Community – This is for Partners and End users, in other words, for everyone with interest in Dynamics GP. Not moderated.

3. Dynamics GP Newsgroups – This is again for everyone with interest in Dynamics GP. This Newsgroup is also available on Google Groups. This Newsgroup sometimes get SPAM content. Not moderated.

4. Dynamics GP Newsgroups(developer) – This is for everyone with interest in Dynamics GP however most suited for Developer queries. Not moderated.

Apart from these, there are several other forums out thereto help answer Dynamics GP Questions. Most of the community members do ask to have one common platform for end-users to post questions. I’m also one among them strongly supporting to have a platform like Dynamics GP partner forums. Newsgroups are serving the Users for quite long time now and not catching up with the increasing needs and needs a change in the near future. Having one community for end users and continuing with the current Dynamics GP partner forums will definitely be a good idea because you have one place to search for your answers instead of searching it in multiple forums. While being a contributor to Dynamics GP community, One thing that I find it discouraging is some posters do care to post their questions and do not take their time to mark the questions as answered or helpful. It is the least you can do as a courtesy after having your questions answered. This doesn’t add up to any benefits for the answerer yet it helps the other community members find it helpful when they search for those. To conclude, participate actively in communities, give and take the knowledge in return.

Share your experiences or suggestions on Dynamics GP Forums if you have any here in comments.


All Call stacks are in Use. Cannot Start script

"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 image
 2. I went to Languages Tab in the same Regional Settings, and then Click Details to open the following window. Here again I made sure I select the default input text language as English(United States) and then made sure I have the Arabic language installed.
3. Then came the most important step of this whole issue. Languages for non-Unicode programs. This is very critical for the error coming in the General Entry. This setting is again in Regional settings, Advanced Tab. Here the earlier setting was English(United States) in Select languages drop down. I changed in to Arabic(bahrain) and made sure I marked everything for code page conversion tables.
It asks for a restart of the client computer after these changes and Yes, we have to do it. Now, come back to Dynamics GP and open the General Entry, voila, It works perfect!

Couple of known issues in Dynamics GP10 SP4

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


Fixes in Dynamics GP10 SP4

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.

You cannot change the PURCH account at the summary level

You cannot change the PURCH account at the summary level.Change the Inventory A/c for the line item instead


Effective Dynamics GP V10 SP2, we get to see this message frequently. We are just used with the old versions that we tend to forget this new control added effective V10 SP2. For those who aren’t aware of this message, this message appears whenever we try to modify the inventory account with PURCH distribution type in either receivings Transaction entry or Purchasing Invoice entry distribution windows.

Ok. What is the background of this message? The reason why the end user cannot change the PURCH type distribution account at the summary level is because Inventory is updated with the detail (the account per line Item) and General Ledger is updated with summary (the account at the summary level for the receipt). If the end user could change the account at the summary level, General Ledger would be updated with the account that was changed at the summary level and Inventory would be updated with account still assigned at the line Item level; therefore, you could NOT reconcile Inventory with the General Ledger. In order for Inventory to reconcile with the General Ledger, the PURCH type distribution account needs to be changed at the line Item level so both Inventory and General Ledger are being updated with the same account."

The workaround solution is to change the inventory account in Item Detail Entry window for each line item. Worst is that the same is the case for non-inventory items. There is no escape for an item being a non-inventory. This new control is hurting the clients rather than helping them. At least, this is what the feedback that I received from some of my select clients. Why this control curbs the ability to enter the distributions for non-inventory items which has no relevance to update the inventory and matching the same with GL, which is what I wonder about and the same is what my clients do argue with me.

My contention is simple. When we have the process to allow non-inventory items as well where you just don’t create them as items in Item master and just add non-IV on the fly, this is no way related to Inventory area. So, At least if an option does exist for Non-IV items to ignore this control or for the Inventory also, those clients who want this control will keep it and those who don’t they will not exercise this. Specially in any Global system, we should be controlling these types of things at the setup options level and not just make processes mandatory because each client uses the system in different ways according to their own processes.

I’m hoping a solution for this in the near future. Anyone are welcome to share their ideas on this issue.


Dynamics GP 10 SP4 relased

Hello Guys. Dynamics GP V10 SP4 released just now. You can download the same following this link below
Download Dynamics GP 10 SP4

Update: KB 971808 should be published within a week to list most of the critical bugs included in this Service Pack. (Added 08/25/2009)

For more information on this service pack, do have a look at victoria yudin's post Service pack 4 for Dynamics GP10. (Added 08/25/2009)

Other Blogs blogging on Service Pack4: (Added 08/25/2009)

1. DynamicsGPBlogster Blog : http://dynamicsgpblogster.blogspot.com/2009/08/microsoft-dynamics-gp-v10-service-pack.html

2. Inside Microsoft Dynamics GP Blog: http://blogs.msdn.com/gp/archive/2009/08/24/microsoft-dynamics-gp-service-pack-4-now-available.aspx

3. Developing for Dynamics GP Blog: http://blogs.msdn.com/developingfordynamicsgp/archive/2009/08/25/microsoft-dynamics-gp-10-0-service-pack-4.aspx

4. Vaidy-DynGP Blog: http://www.vaidy-dyngp.com/2009/08/gp-100-sp4-available-now.html

5. DynamicsAccounting.Net Blog: http://msdynamicsgp.blogspot.com/2009/08/dynamics-gp-10-service-pack-4-is-out.html

6. Mohammed Daoud Blog : http://mohdaoud.blogspot.com/2009/08/microsoft-dynamics-gp-sp4-just-released.html