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.