Fixing A Corrupt Sales Invoice

Microsoft Dynamics GPWe received a call from a client yesterday about a problem with a sales invoice.

They’d tried to amend the value, had a problem and then tried to void the transaction (their settings prevented the registered invoice being deleted but something went wrong.

It was at this point that they called the helpdesk to report the following error message;

This document number already exists. Please enter a new document number.

Continue reading “Fixing A Corrupt Sales Invoice”

Earlier Version of Dynamics.dic Than Installed

Microsoft Dynamics GPI did a test upgrade for a client recently (yes, I’ve been doing a few of these) so they could make sure everything still works and allow them to check out some of the new features.

I got this error message forwarded to me by one of the clients after he tried to login to do some testing;

You are using an earlier version of Dynamics.dic than the one that

Continue reading “Earlier Version of Dynamics.dic Than Installed”

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”

Automate Login To Microsoft Dynamics GP 10

Microsoft Dynamics GPClients who have upgraded to Microsoft Dynamics GP 2010 can use the new remember user and password functionality, but what about those who have not yet upgraded?

Well, in Microsoft Dynamics GP 10, and before, you can use a login macro to automate the login process. A macro can be created by pressing Alt + F8 on the login screen and following the normal login process before pressing Alt + F8 again to stop recording. Continue reading “Automate Login To Microsoft Dynamics GP 10”

Missing Data Source When Installing Microsoft Dynamics GP 2010

Microsoft Dynamics GPI have recently been upgrading an existing client to Microsoft Dynamics GP 2010 R2 from GP 10 SP1 on their test system. As they have lagged somewhat on versions I needed to upgrade them to GP 10 SP5 before then upgrading them to GP 2010 R2.

The databases were also being moved from a server running Microsoft SQL Server 2000 to one running SQL Server 2008; I would have preferred to move them to SQL Server 2008 R2 but due to some other business critical software to be installed on the same server, it needed to be SQL Server 2008 R1. Continue reading “Missing Data Source When Installing Microsoft Dynamics GP 2010”

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”