Posts

Showing posts from December, 2010

The Dynamics GP Blogster's best articles of 2010

Image
Wow! 2010 is on its way out and this mark the second year I have the opportunity to publish a list of the best articles I wrote this year. The Best of 2009 was a hit, so let's give this year's a chance:

1. Using Business Alerts with Extender Tables (Jan 12) - This one came straight out of the newsgroups with Microsoft's Dawn Langlie providing a neat solution.

2. Autogenerating Customer IDs (Feb 28). Many of you seemed to have found this one very useful for whaterver projects you were working on. Up to today I still receive offline notes of thank you! for this script.

3. Microsoft Dynamics GP Architectural Foundations featuring Tim Brookins (Mar series). Many of you who had been in the channel for a while, enjoyed reading this forgotten and hard to find whitepaper, which is still today one of the best produced on the topic, even though the Dynamics GP architecture has evolved over the years. Unfortunately, Tim Brookins was not available for the closing remarks on the series…

Season Greetings to all the Microsoft Dynamics GP community!

Image
As many of you prepare to celebrate these festivities in company of family and friends, I would like to take this opportunity to wish you the best throughout these Holidays on behalf of my wife Marina and children.

Thanks for all the great comments posted throughout the year and the support you have shown to The Dynamics GP Blogster and all the different outlets provided. It keeps me going and working to bring you the some of the best content you will find about all things Dynamics GP: the events, the technical articles, the series, and much more.

You can always count on 2011 bringing new and exciting articles with innovative approaches for using Microsoft Dynamics GP and getting the best out of your investment.

Until next post!

MG.-
Mariano Gomez, MIS, MCP, MVP, PMP
Maximum Global Business, LLC
http://www.maximumglobalbusiness.com/

From the newsgroups: Tracking COBRA in Microsoft Dynamics GP Payroll (US only)

Image
This week's answer comes courtesy of Microsoft's Aaron Richards over at the Partner Online Technical Community, but first the question -- no names given to protect the innocent :-)

We are using Dynamics GP2010. How do we track COBRA in Payroll. We are not using HR.

Specifically, we are trying to track what the government reimbureses us. For example, we're trying to track 70% that we pay to the insurer on the 941 that we send to the government which eventually reimburses back from the government that we had paid.

Please advise or point me to a reference for utilizing this.As stated by the partner, the customer is not using the HR module which has full COBRA tracking capabilities. Here is what Aaron had to say:

Thank you for using Microsoft Online Communities. My name is Aaron and I will be assisting you with your questions today. This information was released when we started tracking COBRA in the hotfix pdf.

It stated the following:

Consolidated Omnibus Reconciliation Act (COBRA…

Add-In Initialization Error when launching Microsoft Dynamics GP 2010 - Follow up

Image
If you read my previous article on some table open operation issues I was faced with at a client, you know by now that it's important to have the proper writer permissions on the local %temp% folder. What I did not mention in that article was an issue we were also facing with the new Dynamics Online Services application.

Upon launching Microsoft Dynamics GP 2010 we were also receiving an add-in initialization error as shown below:



Since last month I wrote an article about this same issue, I wanted to make sure I kept this topic separated from the table open operation issues, even though they are directly related by the solution. As it turned out, writing permissions (or the lack thereof) on the %temp% folder caused the Dynamics Online Services application to fail as well with an add-in initialization error message. This error popped up a large window (shown above) detailing the nature of the problem. However, after re-enabling access to the %temp% folder the error no longer presen…

An open operation on table XXX failed because path does not exist

Image
Who hasn't come across this error? If you have been long enough in the Microsoft Dynamics GP world, you will probably even have a prescribed set of steps to address this issue:

Restart the SQL Server service to clear all tempdb database tables from memoryClear out the local temp folderMaking sure the temp folder actually existsMaking sure the %TEMP% environment variable existsMaking sure your anti-virus software is not placing some sort of restriction on the folder
And then some more...

Just recently I ran across this issue with Microsoft Dynamics GP 2010 and I thought, how bad can this be? I started by walking through the prescribed steps as mentioned above, but still could not resolve the issue. I also remembered that my friend Allan Cahill over at Developing for Dynamics GP had blogged about this in his article Unexplained Temp Table Errors so I went checking his findings. In his case the issue had to do with the Anti-virus software interfering with the temp directory during sca…

SmartList Builder "Display as a negative value based on field" option not working as expected

Image
Just recently on a newsgroup forum, a partner brought up an issue affecting SmartList Builder. The partner had just recently upgraded the client from version 9 and was testing the Smartlists the customer had built prior to the upgrade to ensure they were still working as expected. In the partner's own words:

"It was working when we were on GP9, but now we're on GP2010 SP1 none of my fields set up with Negative Values are showing up with Negative Values. When I run the smartlist from the old GP9 server, amounts are showing negative amounts for Return documents. But when we run the smartlist on GP2010, the amounts are now positive amounts, and when I check the Set Field Options window, they are still set up to "Display as negative based on field" when SOP Type = Return."In order to verify this I launched GP 2010 and recreated the SmartList mentioned above by the partner, setting the field option for the Document Amount to display a negative value based on a SO…

How to display an image at the User Interface level

Image
One of the questions I often get is, can you dynamically display an image on a Microsoft Dynamics GP form or report. The answer is No, it's not possible. The reason for this is, Microsoft Dexterity, the tool used to developed your beloved Microsoft Dynamics GP, is only capable of displaying images stored within the dictionary itself. Since the picture control in Dexterity is binded to these pre-stored images, this obviously would indicate that there is no room for dynamic images to be added. In addition, the Dexterity picture control cannot be referenced or manipulated programatically as Dexterity does not treat this object like it does with any other fields.

One *exception* may be the adding these pictures via Modifier, but even so, this is not a dynamic manipulation of a picture control. In summary, not possible!

Of course, you can always resort to VBA. The objective of this post is to see how you can use VBA to aid in displaying images where needed. One typical application is d…

Do I have to use those "Z-" currency IDs in GP?

Image
I know this seems like a trivia question, but recently I have come across a number of clients who have been using Microsoft Dynamics GP for a number of years and have been told by their former partners that they *must* use the predefined currency IDs created after adding the sample company, with no real explanation to support these claims. Case in point, my new client in Saudi Arabia, has been struggling for years to understand why they were told to prefix all currency IDs with the "Z-". So they went ahead and setup "Z-SR" for the Saudi Real.

If you are familiar with Microsoft Dynamics GP and the sample company, Fabrikam, you may have noticed by now that after adding the sample company (which is not a requirement by any means), you will get a number of predefined currencies such as Z-US$ (US Dollars), Z-UK (British Pounds), Z-C$ (Canadian Dollars), Z-AUD (Australian Dollars), and so forth, accompanied by a number of exchange rate tables. If you are not familiar wi…

Adobe PDF Converter error when sending report to PDF in Microsoft Dynamics GP

Image
Just recently, I was working on a few Report Writer reports for a client and assisting with installing the latest Adobe Acrobat Standard version for them. After Adobe was installed, we decided to run a few tests to attempt to send some of the modified reports output via email using the Send To > Mail Recipient PDF option on the Report Output window.

Upon choosing the Mail Recipient PDF option, we received the following error:


The error seems to come from the Adobe PDF Converter application which suggested that our PDF conversion process must rely on the system fonts and use document fonts. In addition, the message provided the path to address the issue as well, so we followed.
Initially, you must go to the Devices and Printers panel in Microsoft Windows, then right click on the Adobe PDF Converter printer and choose Printer Properties.
Once the Adobe PDF Converter Properties window opens, click on the Preferences button
The Preferences button will now open the Adobe PDF Converte…

Enabling a Report Writer document as a Word Template

Image
Ok, this is directly or indirectly a Report Writer subject, but nonetheless a topic related to Report Writer. In this example, I take the General Posting Journal transaction document and enable it under Word Templates. However, this example will not develop the Word Template itself, but rather show how easy it is to make the journal document template enabled.

The steps are very simple and in fact, with a little bit of creativity, a developer could potentially write code that quickly enables critical reports.

To enable an existing Microsoft Dynamics GP report:

1. Register a trigger against the IsTemplateEnabledReport() function of the syReportLookup form. Template enabled reports can be selected in the Reports lookup window.

Startup
{ Created by Mariano Gomez, MVP This code is licensed under the Creative Commons Attribution-NonCommercial-ShareAlike 2.5 Generic license. } local integer l_result; pragma (disable warning LiteralStringUsed); l_result = Trigger_RegisterFunction(functio…

Report Writer Week!

Image
In case you have missed the heated debates - all within cordiality, though there was even a call for insanity - between David Musgrave and Mark Polino on Report Writer, I now join in to continue fueling the heat by declaring this the official Report Writer week!
To make this an even more attractive proposition for you the reader, The Dynamics GP Blogster is siding  (more like ganging up against Mark :-) ) with Developing for Dynamics GP to deliver some really cool Report Writer articles and to show some advanced techniques for developing reports... yes, with Report Writer.
Until next post!

MG.-
Mariano Gomez, MVP
Maximum Global Business, LLC
http://www.maximumglobalbusiness.com/

Custom Serialization Assemblies for eConnect 2010

Image
Yesterday it was Bryan Prince demonstrating in-memory XML serialization, today is Chris Roehrich over at Developing for Dynamics GP. Chris shows a technique to create a Custom Serialization Assembly for eConnect outside of the method exposed in the eConnect Programmer's Guide.

Please be sure to visit Developing for Dynamics GP to read Chris' article.


Until next post!

MG.-
Mariano Gomez, MVP
Maximum Global Business, LLC
http://www.maximumglobalbusiness.com/

In-Memory XML Serialization with eConnect 10

Image
Over at MBS Guru, my friend Bryan Prince demonstrates a technique to perform in-memory XML serialization when working with eConnect. Bryan's technique is very helpful especially when working in environments where disk access and/or disk permissions can become an issue.

If you ever needed a cool piece of code for your eConnect projects, this is it! On a personal note...I had a chance to work on a project briefly with Bryan and I won't be surprised he will be publishing some other cool life saving techniques he used at our client.

Until next post!

MG.-
Mariano Gomez, MVP
Maximum Global Business, LLC
http://www.maximumglobalbusiness.com/

Support Debugging Tool Build 14 for Microsoft Dynamics GP now available for download

Image
Good news from the land Down Under! The critically aclaimed Support Debugging Tool now sports a new Build 14 for your delight. You can now download Support Debugging Tool from Microsoft Dynamics PartnerSource.

If you are a customer using Support Debugging Tool, please reach out to your partner for the latest build number. Support Debugging Tool Build 14 is available for versions 9 (last release for this version), 10.0, and 2010.

For more information on fixes and new features, please visit Developing for Dynamics GP and read David's release notes:

Support Debugging Tool Build 14 Released


Downloads

To download Support Debugging Tool Build 14, please use the following links:

Support Debugging Tool for Microsoft Dynamics GP 9.0

Support Debugging Tool for Microsoft Dynamics GP 10.0

Support Debugging Tool for Microsoft Dynamics GP 2010


Note to all readers:

Given the success and high marks we had at Convergence 2010 Atlanta presenting the Support Debugging Tool, and by popular demand, David…

Learning Resources page update

Image
I have received a number of emails from many of you requesting I add the Microsoft Dynamics GP 2010 Word Template series and Microsoft Dynamics GP Architectural Foundations series of articles to the Learning Resources page on this site. Your wishes are my command! Please visit the Learning Resources page under the Contents section for links to these series.

Thanks for your continuous readership and for making this site better every day.

Until next post!

MG.-
Mariano Gomez, MVP
Maximum Global Business, LLC
http://www.maximumglobalbusiness.com/