Posts

Showing posts from November, 2009

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 http://dynamicsblogger.com/2009/11/windows-7-marketshare-on-the-rise/

MSDynamicsWire Network integrated with Facebook Connect

Image
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 (Bat

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 Po

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

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

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

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

Image
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 sever

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.  Action: SubmitTaskAction Current User LogOnName: Domain\Admin Input parameters: Exception type: System.ArgumentException Exception message: logOnName Stack

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.

Dynamics GP Workflows Uninstall Fails with a Fatal Error

Image
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