I Have A New Microsoft Dynamics GP Certification

Microsoft Certified Technology SpecialistGood news to end the week on. I’ve just returned home from the Prometric test centre with a brand new Microsoft Dynamics GP certification to add to my existing two.

The new one is MB3-862 Microsoft Dynamics GP 2010 Inventory & Order Processing.

How To Remove The CEIP Reminder

Microsoft Dynamics GPWhen you install Microsoft Dynamics GP it automatically creates a recurring reminder for the Microsoft Customer Experience Improvement Program. In most cases this reminder is not wanted but removing it through the system for every user can be a bit time consuming;

For each user, log into Microsoft Dynamics GP and open the Reminders window (Microsoft Dynamics GP menu » Reminders) and open the CEIP task. In the window click Name and select an option. Flag the task as Completed and move onto the next user and repeat.

However, help is at hand in with two short SQL scripts. Continue reading “How To Remove The CEIP Reminder”

Feature Explained: Combine Budgets

Microsoft Dynamics GPI like how Microsoft Dynamics GP handles budgets and the ease with which they can be exported to, amended and then imported from Excel. However, one of the issues constantly raised by customers in the past was that you could only have one budget and had to include all codes within it. This is problematical when you have several budget holders within your organisation who will have a budget figure to divide up between their account codes.

Well, in Microsoft Dynamics GP 2010, a new feature has been added; you now have the ability to combine several budgets into one. Continue reading “Feature Explained: Combine Budgets”

Feature Explained: Account Rollup Enquiry

Microsoft Dynamics GPThis is not a new feature in Microsoft Dynamics GP 2010, or even in GP 10, but is a feature that almost no-one I have spoken to uses. This has always left me slightly puzzled as, to me, the Account Rollup Enquiry seems quite a useful tool, which is quite simple to use even for non-technical users, for getting segment-based enquiries for open or historical years.
Continue reading “Feature Explained: Account Rollup Enquiry”

Dynamics GP “12”: Web Client

Microsoft Dynamics GPThe below quote is from Errol Schoenfish, the director of product management for Dynamics GP and gives an indication of the path Microsoft are intending to take.

A large portion of that release will be dedicated to getting us to the cloud. It’s pretty astounding what our development team has been able to do. This was a massive task and ISVs are over the moon about it.”

Continue reading “Dynamics GP “12”: Web Client”

Feature Explained: How To Configure The Document Email Functionality

Microsoft Dynamics GPA recent customer who upgraded to Microsoft Dynamics GP 2010 wanted to enable the email functionality to allow them to email creditor remittances out rather than having to print them out and sending a hard copy.

As our support account did not have an associated Exchange email account on their system I was getting errors when loading the forms used in this new functionality. So rather than risk problems due to these errors, I put together a quick document for their IT department to enable it themselves. I thought it might also be useful to create an internet version to refer other customers to if they want documentation. Continue reading “Feature Explained: How To Configure The Document Email Functionality”

Journals Submitted To eConnect Vanishing

Microsoft Dynamics GPWe use eConnect to post journals from external systems into Microsoft Dynamics GP. After working fine for over a year, a customer site recently had transactions posted via eConnect vanishing.

There were no entries in the Journal messages under eConnect_Incoming Private message queue in Computer Management or in the eConnect section of the Windows Event Viewer. Once the message had left the client machine no trace could be found.

Continue reading “Journals Submitted To eConnect Vanishing”

Check Remittance Vendor Address VBA Workaround

Microsoft Dynamics GPFollowing on from yesterdays post about the Undefined Symbol error, where I discovered that Microsoft have removed the link from the check remittance tables to PM Creditor Master, I thought it might be useful to post the VBA workaround used to get the creditor address.

The first step was to create five Calculated Fields on the Check Remittance report; for simplicity I named them CreditorAddress1 through CreditorAddress5. No separate field for Post (Zip) Code was created as addresses can be of all different lengths and I like to output tidy addresses where I can.

Once the fields were created and added to the report, in the Remittance Header section, they were selected and made available to Visual Basic. Continue reading “Check Remittance Vendor Address VBA Workaround”