Posts

Showing posts from 2009

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 instal

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 http://dynamicsblogger.com/2009/12/auto-tweet-from-your-feedburner-feed-with-socialize-feature/

Invoice Management System for Dynamics GP simplified with IDS

Image
  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 Electronic Delivery of Invoices and Statements Have flexibility to send Invoices and Customer statements through several combinations like printing, e-mailing, faxing. Invoices and Statements Archiving that helps us s

Dynamics GP Blogs Analytics 2009

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

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

GP Webinars from I.B.I.S

Image
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

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 Video and Text Chat :. This will help members to communicate easily whenever they get to see other members online.

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 appe

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 http://mbsguru.blogspot.com/2009/09/avoid-some-gp-form-modifications-with.html 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

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

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 http://www.surveymonkey.com/s.

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

Tweet to expand your Reach

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

Dexterity and other Tools for Dynamics GP SP4 available for download

Follow this link in Developing for Dynamics GP Blog having the latest download information for Dexterity and other tools  compatible with Dynamics GP 10 SP4. http://blogs.msdn.com/developingfordynamicsgp/archive/2009/09/16/dexterity-and-other-tools-for-v10-00-sp4-now-available.aspx

Exchange Rate Entry Maximum Decimals

Image
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.123

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

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

AA Posting Journal prints for every transaction posting

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

FRx6.7 Service pack issue

Image
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

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 Alternat

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

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

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 the

All Call stacks are in Use. Cannot Start script

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

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

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

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