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”

Support Debugging Tool Build 15 Released

Microsoft Dynamics GPOn Developing for Dynamics GP David Musgrave has announced the release of the Support Debugging Tool Build 15

Build 15 introduces lots of new functionality as well as many fixes and improvements. Available from PartnerSource (login required)

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”

Check Remittance Undefined Symbol Error When Upgrading to Microsoft Dynamics GP 2010

Microsoft Dynamics GPThe customer I recently upgraded from Microsoft Dynamics GP 10 to GP 2010 have encountered an error during the payment run at the cheque remittances step;

Undefined Symbol F01343D00789 Sequence Num

Continue reading “Check Remittance Undefined Symbol Error When Upgrading to Microsoft Dynamics GP 2010”

SmartList Pane Sizes

Microsoft Dynamics GPOne of my biggest problems with the SmartList in Microsoft Dynamics GP is the size of the two panes. The left hand pane resizes itself when you change the size of SmartList; when maximised it ends up being two fifths of the screen size which seriously cuts down the space for viewing the report.

But, now, help is at hand. Frank Hamelly, a Microsoft Dynamics GP MVP, on GP2themax has posted a modified SmartList window, from Nicole Albertson of Microsoft, which resizes the left pane.

The modified window is loaded in via Customisation Maintenance (Microsoft Dynamics menu » Tools » Customise » Customisation Maintenance) from a .package file and works by keeping the left pane a set size which maximises the pane showing the report data.

Hopefully, the next version of Microsoft Dynamics GP will come with a built in solution to this.

Management Reporter SP2 Now Available For Download

Microsoft Dynamics GPDynamics Corporate Performance Management has announced that Management Reporter Service Pack 2 was now available for download. This release of Management Reporter adds compliance with Microsoft Dynamics GP 2010, better support for rounding adjustments and adjustment periods and performance improvements for reports with large numbers of transactions, many calculated rows, and Analytical Accounting.

It is available now from PartnerSource or CustomerSource (login required).

Microsoft Dynamics GP 2010 Utilities: BCP Utility Error

Microsoft Dynamics GPI have just returned from customer site where I did an upgrade of Microsoft Dynamics GP 10 to Microsoft Dynamics GP 2010 (I wish they’d called it GP 11 as the current nomenclature confuses customers) and got the error I often get when upgrading or installing GP on Windows 7 or Windows Server 2008 systems and have forgotten to do one of two very simple things. The explanation of the two things later, but first, the error message;

An error occurred while using the BCP utility--data was not correctly copied to the server. Please verify your ODBC settings and that BCP has been correctly installed. Microsoft Dynamics Utilities will now exit.

Continue reading “Microsoft Dynamics GP 2010 Utilities: BCP Utility Error”