Showing posts from December, 2009

2010 US Payroll Tax Updates Round 1 now available

Microsoft has released the 2,010 Payroll Tax Updates - Round 1 , available for download un CustomerSource and PartnerSource and has communicated that Round 2 will be out the week of January 18th to include changes to Rhode Island and EIC. As many of you have been sending comments and emails about Payroll Tax Updates and Year-End procedures, here is a compiled list of resources for both US and Canada. Featured on this site Payroll Year-End Close and W-2 Forms Supportability US Payroll Tax Update Rounds * 2009 Payroll Tax Update for Microsoft Dynamics GP 8.0 * The following is the complete list of Payroll Tax Update rounds for 2009. External resources Version 9 CustomerSource/PartnerSource 2010 U.S. Payroll Tax Update for Microsoft Dynamics GP 9.0 (Round 1) CustomerSource/PartnerSource 2009 U.S. Payroll Year End Update for Microsoft Dynamics GP 9.0 CustomerSource/PartnerSource 2009 Canadian Payroll Year End Update for Microsoft Dynamics GP 9.0 Version 10 CustomerSourc

The Dynamics GP Blogster's best articles of 2009

Another years is gone by and as it's customary around the last days of the year the media always seems to have some list with "The best this" or "The best that" of the outgoing year. I figured I won't stay behind and, while by no stretch of the imagination I am some media conglomerate, I would join in with the best articles or series of articles published on this site during the 2009 year. Hope you enjoy the selection and chime in with the ones you believe were the best. So let's get the ball rolling! 1. Sending emails with Collaboration Data Objects (CDO) and Dexterity (Jan 19). This article became a hit with the Dynamics GP development community and formed the base for the SMTP email capabilities built into the Support Debugging Tool . 2. Displaying Hijri dates in Microsoft Dynamics GP (Feb 19). What was once thought impossible -- displaying Hijri dates -- was accomplished with a couple lines of code. Now the Dynamics GP community in the Middle Eas

Happy Holidays!

Merry Christmas! Happy Hanukkah! Happy Kwanzaa! Happy Al-Hijira! Best wishes throughout the Holiday season in company of your friends and family from The Dynamics GP Blogster. Once again, thanks for all your support and comments throughout the year and for confirming what I always knew: the more information you have, the better you can perform your job. That's the objective of this blog and the reason I strive to deliver a variety of information and topics always revolving around Dynamics GP. 2010 will sure bring exciting stuff! We have the long awaited GP "11" release coming out, the new Microsoft Office 2010 , incredible features being delivered in Microsoft SharePoint 2010 , the new and spectacular, feature-rich Microsoft Visual Studio 2010, the promising Power Pivot, and last but not lease, the new Microsoft SQL Server 2010. To accompany this array of applications and tools, we have spectacular events like Convergence, right in my backyard here in Atlanta. In add

New article on MSDynamicsWorld: "Putting to Rest Four Myths About Microsoft Dynamics GP Integration Manager"

Folks, this time I take a hard swing at four common myths around the *beloved* Integration Manager . I know there are a lot of mixed feelings out there when it comes to poor IM, but this tool has saved my *ss in more than one occasion and in this article I make a case for its use in serious mission critical application integrations. So head over to MSDynamicsWorld and read up ! After reading the article, I would like to get your comments and experiences with IM. Until next post! MG.- Mariano Gomez, MVP Maximum Global Business, LLC

MSDynamicsWorld releases Top 10 Microsoft Dynamics Stories of 2009

Fresh out of the oven is MSDynamicsWorld's Top 10 Microsoft Dynamics Stories of 2009 . I am honored to have one of the most read stories of this year with my article Four Microsoft Dynamics GP Project Team Blunders and How I Become a Hero . I have received numerous inquiries on the subject since the article was published and it's safe to say the Microsoft Dynamics ecosystem is always looking to maximize its implementation dollars, while making sure projects will be delivered on time. Once again, thank you for your support and readership, and please drop me a comment letting me know what stories you would like me to cover in 2010. Until next post! MG.- Mariano Gomez, MVP Maximum Global Business, LLC

Hybrid - SOP Batch Splitting

Two weeks ago, I began working on a Microsoft CRM to Microsoft Dynamics GP integration project. Sales orders initiated in CRM and are transferred to GP once they are submitted in CRM. Once the orders got to GP they must be placed on automatic hold for document verification. However, once the hold was removed, the client wanted to be able to transfer all verified orders in bulk... so far good! The problem though was, when orders were transferred to invoices, the invoices remained mixed with the orders that did not get transferred in the same batch. This presented a control issue for the client as the staff performing the documentation is not the same staff transferring the orders. Last year I posted the article Moving SOP Transactions from One Batch to Another . This article demonstrated a SQL script that would allow a database administrator to move SOP documents from one batch to another. The script in that article forms the basis for this customization. However, to make it more user

My interview with DynamicsWorld

The good folks over at DynamicsWorld in UK has a post up interview with ... me! Please take some time to read up as I trace back to the roots of my career and a few comments about the Microsoft Dynamics ecosystem. Until next post! MG.- Mariano Gomez, MVP Maximum Global Business, LLC

Payroll Year-End Close and W-2 Forms Supportability

Yep, it's that time of the year again! And no, I am not referring to Christmas, Hannukah, Kwanzaa, or 1st of Muharram, though I respect all these celebrations. I am referring to the not-so-celebrated Payroll year-end close and submissions of W-2s -- at least here in the United States. So here are a few things to keep in mind for a successful Payroll year-end close and printing of W-2 forms: 1. Apply the 2009 US Payroll Year-End Update Just don't do it by yourself! If you use Microsoft Dynamics GP v10.0 Extender, do not install the 2009 U.S Payroll Year End Update. If you use U.S. Payroll in addition to Extender and need the country code changes or the 1099-R Distribution code changes, please contact Microsoft Technical Support to assist you in installing the update. This should be a free support case. If you use Web Services for Microsoft Dynamics GP v10.0, the latest hotfix for Web Services must be installed prior to installing the 2009 U.S Payroll Year End Update abov

Why my PO Number seems to skip randomly?

The opening goes something like this: I upgraded from version X.XX [typically 7.x, 8.x] to Microsoft Dynamics GP 10.0 and now we are having a problem where the next PO number will sometimes jump back in sequence, often many numbers. What's happening to our PO Numbers? In my previous article, Why does my next document number change randomly? I gave some insight into why Microsoft Dynamics GP 10.0 seems to randomly skip document numbers, sometimes backwards. Here is more information on PO Numbers and another method of preventing this behavior. In Microsoft Dynamics GP 10.0 Purchase Order Processing module, it is possible that a user may have a purchase order number that is completely different from the next number found in the Purchase Order Processing Setup window. Although the next number for purchase orders is set up in the Purchase Order Processing Setup window, Microsoft Dynamics GP will look for unused PO numbers that precede that number. The system will be able to re-use

The Technology Corner: Finding your way around Dynamics GP with Mentor

If you are an end user you probably already know that one of the most frustrating aspects of working with GP has to be navigating through the menu structure. Granted, improvements to the navigation bar introduced since version 9 have made things a lot easier. Nonetheless, remembering where to find an option that will take you to a specific window can be very challenging at times for both experienced and novice users. Also, what if the window you are trying to access is not a main window? What if you don't even have security to the window you are trying to access? What if all you know of the window is a portion of the name? I have to say, I rarely get into blogging about specific ISV solutions, but I had a chance to play around with Mentor by Rockton Software . Mentor answers the questions above and some more about any window, whether in the Dynamics dictionary or any integrating or third party product and is able to provide the exact menu path to follow to access said window. The

VST - Working with the Action Button in SOP

Last year in May, I worked on a number of VBA SOP customization upgrades from v9 to v10. As a result of the experiences I blogged about the one issue that I ran into in my article Upgrading SOP Entry VBA Customizations from Dynamics GP 9.0 to Dynamics GP 10.0 . The main issue was the sudden switch from the individual push button controls to the new Action Button , which is a Dexterity Button Drop List control. Of course, this made the SOP Entry window interface a lot cleaner for v10, but brought its own challenges for developers. SOP Entry window, GP 9.0 SOP Entry window, GP 10.0 While it is relatively feasible to work with the Action Button from VST, a few things need to be taken into account: 1) Unlike push button controls, button drop list controls do not expose Click Before Original and Click After Original events in Visual Studio. This is because the button drop list control has the menu items selection action to deal with. 2) As a result of the above, the button drop lis

Meet Mohammad R. Daoud, Dynamics MVP from Amman, Jordan

Folks, it's real cool to be a part of the Microsoft Dynamics GP MVP family, but even more rewarding when you can follow the accomplishments of your colleagues who wear the same badge you do. Microsoft Feed recently featured MVP Mohammad Daoud from Amman, Jordan in an interview examining his personal and professional accomplishments and life as a Microsoft MVP. Mohammad has been very involved in the Microsoft Dynamics GP community in the Middle East and can now be considered a veteran in the field. In reference to my opening statement for this article, Mohammad is the proud father of a baby boy , one of few born in what could be considered a Microsoft Dynamics GP Community Baby Boom 2009 . Until next post! MG.- Mariano Gomez, MVP Maximum Global Business, LLC

New Article on MVP Mark Polino alerts everyone on GP Alerts

"This disk will self destruct in 5 seconds" As with the movies, MVP Mark Polino makes a theatrical appearance on MSDynamicsWorld showing Microsoft Dynamics GP alert mechanisms . He takes a quick run down through Reminders, SmartList Reminders, Business Alerts and SQL Server alerts. It's very easy to forget that Microsoft Dynamics GP offers a range of mechanisms to work proactively, instead of spending tons of hours at crunch time trying to figure out why AR does not tie with GL. Until next post! MG.- Mariano Gomez, MVP Maximum Global Business, LLC

Inventory BOM vs Manufacturing BOM

I salvaged this post from the Microsoft Dynamics GP Partner Forum comparing the features in Inventory BOM versus those in Manufacturing BOM. The props go out to Microsoft's Jim Shauer for the detailed explanation. The core Bill of Materials module works closely with the Inventory subledger. You can define bills and assemble the bills in this module. This module works best for companies with a very simple assembly/production process where the finished good production is normally recorded after the fact. The Manufacturing BOM module stores the definition of the BOMs. It does require the use of the Inventory subledger and you must use this module together with Manufacturing Order Processing. This Order Processing module is used to record the production of the finished goods. The Manufacturing BOM (together with Manufacturing Order Processing) provides more functionality related to the definition of the BOMs and the methods in which those finished goods can be produced. These modul