Error Printing Batch Of Cheque Remittances

Microsoft Dynamics GPI recently assisted a client with an upgrade of Microsoft Dynamics GP 10 to GP 2013 R2. As part of the upgrade we assisted the client to create some Word Template versions of sales invoice, purchase order, and cheque remittance (or check remittance to the American readers).

Everything appeared fine during development and initial testing. Fine that is until we tried producing a batch of twenty remittances which produced the following two error messages:

Microsoft Word - The file Check Remittance~2 cannot be opened because there are problems with the contents.Microsoft Word – The file Check Remittance~2 cannot be opened because there are problems with the contents.

Continue reading “Error Printing Batch Of Cheque Remittances”

Adding the Vendor’s Address To The Check Remittance

Microsoft Dynamics GPIn Microsoft Dynamics GP 2010, Microsoft changed the underlying tables used by the Check Remittance; I believe this was for purposes of efficiency. However, the downside is that the table, pmRemittanceTemp, used to replace PM_Payment_WORK did not contain the vendor’s address or a link to a table which did.

In the past I have tended to use VBA to add the vendor’s address to the Check Remittance because it was quick and easy to do and I didn’t revisit this approach until Microsoft Dynamics GP 2013 was released. And the reason I revisited, was because of the new Web Client which does not support VBA customisations.

As always, I figured I might as well do a blog post about this and had it scheduled in to write when Richard Wheeler asked the question on the Community Forum. So, here is the step-by-step guide to adding the vendor address back onto the Check Remittance modified report.

Continue reading “Adding the Vendor’s Address To The Check Remittance”

How To Realign Trial Balance Summary Modified Report Columns

Microsoft Dynamics GPI was recently asked to assist the Support team to look into an issue with the Trail Balance Summary modified report. The problem was that when sent to screen or printer the report was fine, but when exported to Tab Delimited file, the columns didn;t match up with the totals at the bottom.

Trial Balance Summary on Screen shows as aligned;

Trial Balance Summary - Screen Output

Continue reading “How To Realign Trial Balance Summary Modified Report Columns”

MDGP 2013 Feature of the Day: Additional Word Templates

Microsoft Dynamics GPMicrosoft have started the Microsoft Dynamics GP 2013 Feature of the Day series on the Inside Microsoft Dynamics GP Blog.

The twelfth feature they’ve announced is Additional Word Templates.

Microsoft Dynamics GP 2010 introduced the Word Templates as alternatives to the standard Modified Reports but the selection available was limited. In Microsoft Dynamics GP 2013, users can now use Word Templates for all Sales Order Processing document types (such as Back Orders) as well as Packing Slips and Picking Tickets;

Continue reading “MDGP 2013 Feature of the Day: Additional Word Templates”

MDGP 2013 Feature of the Day: Alternative/Modified Forms and Reports

Microsoft Dynamics GPMicrosoft have started the Microsoft Dynamics GP 2013 Feature of the Day series on the Inside Microsoft Dynamics GP Blog.

The tenth feature they’ve announced is some enhancements to the Alternative/Modified Forms and Reports window.

This feature covers several enhancements to the window to improve usability.

Continue reading “MDGP 2013 Feature of the Day: Alternative/Modified Forms and Reports”

Installing Microsoft Dynamics GP 2010 – Insufficient Privileges To Modify The VBA Project Error

Microsoft Dynamics GPI upgraded a clients test system from Microsoft Dynamics GP 10 SP3 to 2010 R2 successfully on the main system such as installing the main client and upgrading the system and company databases.

The client has a few modified reports on the system which needed to be brought across to Microsoft Dynamics GP 2010. These reports were exported from Customisation Maintenance (Microsoft Dynamics GP menu ¯ Tools ¯ Customise ¯ Customisation Maintenance);

Customisation Maintenance

Continue reading “Installing Microsoft Dynamics GP 2010 – Insufficient Privileges To Modify The VBA Project Error”

Check Remittance Run-time error ’13’ – Type Mismatch: Follow Up

Microsoft Dynamics GPWe heard back from the Development Team in Fargo, who David Musgrave contacted regarding the issue we encountered with the Microsoft ActiveX Data Objects 2.7 Library.

They recommend that packages should be moved around using the Customisation Maintenance (Microsoft Dynamics GP menu ¯ Tools ¯ Customise ¯ Customisation Maintenance) to Import/Export the modified reports. Rather than doing this, which runs the potential risk of leaving client machines with an outdated REPORTS.dic we have been pointing the clients at a centralised REPORTS.dic on a server and copying only the Dynamics.vba to each client (we change the reports more often than the VBA).

Using Customisation Maintenance to Import the package file to each client would have prevented the problem as it would use the Microsoft ActiveX Data Objects 2.7 Library reference on the local machine. Doing it the way we do, by copying the VBA, transfers the reference within the VBA file.

This is an issue for internal discussion and we perhaps need to change the process we use for dictionary files.

Check Remittance Run-time error ’13’ – Type Mismatch

Microsoft Dynamics GPI implemented the VBA workaround for cheque remittances on a test system for another client site, to make sure they don’t see the undefined symbol error, the other day after I upgraded Microsoft Dynamics GP 10 to GP 2010 and tested the remittance to ensure it worked. amend VBA on Server 2008 R2 SP1

When the client came to test the remittance themselves on the test Citrix Server they got a type mismatch error;

Run-time error 13: Type mismatch

Continue reading “Check Remittance Run-time error ’13’ – Type Mismatch”

Not Privileged To Run this Report Error in Payables Select Checks

Microsoft Dynamics GPI upgraded a customer to Microsoft Dynamics GP 2010 a couple of weeks ago and they have started to explore some of the new features. After fixing their payment run problem they enabled the new functionality for emailing remittances. Continue reading “Not Privileged To Run this Report Error in Payables Select Checks”