Check Remittance Vendor Address VBA Workaround

Ian Grieve2 minute read3 Comments

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”

PrintFriendlyLinkedin

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

Ian Grieve1 minute read9 Comments

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”

PrintFriendlyLinkedin

SmartList Pane Sizes

Ian Grieve2 minute read0 comment

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.

PrintFriendlyLinkedin

Management Reporter SP2 Now Available For Download

Ian Grieve1 minute read1 Comment

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).

PrintFriendlyLinkedin

Microsoft Dynamics GP 2010 Utilities: BCP Utility Error

Ian Grieve1 minute read2 Comments

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”

PrintFriendlyLinkedin

Microsoft Office 365 Launched

Ian Grieve2 minute read0 comment

Microsoft OfficeEarlier today Microsoft launched their Microsoft Office 365 productivity suite which combines Office, SharePoint, Exchange and Lync in a cloud based version of their earthbound variant.

The service, which replaces Microsoft Business Productivity Online Suite, was launched today by Microsoft CEO Steve Ballmer in a live webcast with over 20 partners already signed up to resell the service alongside their own services.

Kurt DelBene, president, Microsoft Office Division said, “Our partners represent some of the best-known, most-trusted brands in their local markets. Our customers will be able to rest easy knowing their cloud services are backed by Microsoft and some of the greatest service providers in the world.”

Microsoft Dynamics GP and Office 365 work together now! Microsoft Dynamics GP leverages Office 365’s functionality, such as reporting and Excel-based analysis, presence and instant messaging, transaction initiation through Lync, and many of the other features of Office that you have come to enjoy when deployed on-premises, but now available through the Cloud with Microsoft Office 365.

With Microsoft Dynamics GP, you build a foundation for the future that goes beyond standalone applications to extend their traditional ERP systems throughout their organization and into the cloud.

PrintFriendlyLinkedin

Dynamics GP “12” – Named System Database Architecture

Ian Grieve1 minute read0 comment

Microsoft Dynamics GPMicrosoft have recently been expanding on the roadmap for Microsoft Dynamics GP “12” (expected to be launched as Microsoft Dynamics GP 2012). One of the features which most interests me is the Named System Database Architecture. Continue reading “Dynamics GP “12” – Named System Database Architecture”

PrintFriendlyLinkedin