Error: Attempting To Log In From A Data Source Using A Trusted Connection

Microsoft Dynamics GPI’ve been building a test environment in a virtual machine the last few days to do a migration from Microsoft Dynamics GP 9 SP3 to 2010 R2.

After completing the upgrade I tried to log into GP and received the following error;

You

Continue reading “Error: Attempting To Log In From A Data Source Using A Trusted Connection”

Microsoft Dynamics GP 9 SP3 Upgrade Path To 2010 R2

Microsoft Dynamics GPI did a bit of searching and couldn’t find a specific declaration of the upgrade path from Microsoft Dynamics GP 9 SP3 to Microsoft Dynamics GP 2010 R2.

After reading around and trying to work out the correct path, I decided the likely upgrade path would be GP 9 SP3 > GP 10 SP5 > GP 2010 R2, but I would try GP 9 SP3 > GP 2010 R2 and see if it would work (although I was extremely skeptical) as this would save some time on the upgrades if it was possible. Continue reading “Microsoft Dynamics GP 9 SP3 Upgrade Path To 2010 R2”

Enabling Email Cheque Remittances For All Suppliers

Microsoft Dynamics GPIn two previous posts I discussed testing Microsoft Dynamics GP 2010’s new Email Remittance functionality; first, by setting up creditors with an internal email address and, then, by transferring the email address from the INET1 field to the new EmailToAddress field.

The other script which I used, and forgot to post, was the one which configures all of the creditors, who are not currently configured for email remittances Continue reading “Enabling Email Cheque Remittances For All Suppliers”

eConnect Messages Not Posting To GL

Microsoft Dynamics GPThe morning opened with a feeling of déjà vu. A client testing Microsoft Dynamics GP reported that transactions they were posting in an external system were not appearing in GP.

After checking out the other issues I’ve seen recently (Domain Trust issues, Windows Updates restarting MSMQ and timeouts) without luck I expanded the investigation. Continue reading “eConnect Messages Not Posting To GL”

eConnect Error: Unrecognized error 232 (0xe8)

Microsoft Dynamics GPA couple of weeks ago, a client was testing Microsoft Dynamics GP 2010 R2 and reported that some of their postings from an external system were not arriving in GP (these postings are transferred using eConnect).

When I installed eConnect I enabled Journalling on the econnect_incoming queue so we would have a record of messages which had been submitted. After receiving the error I went to make sure the messages had reached the GP server (Start menu » Control Panel » Administrative Tools » Computer Management » Services and Applications » Message Queuing » Private Queues » econnect_incoming » Journal Messages) Continue reading “eConnect Error: Unrecognized error 232 (0xe8)”

Missing Transaction In Cashbook Bank Management?

Microsoft Dynamics GPI dealt with an issue yesterday where a manual payment had been entered into Payables Transaction Entry (Transactions » Purchasing » Transaction Entry) but was not showing up in Bank Management’s Reconciliation screen (Transactions » Financial » Bank Management » Reconciliation).

The reason for this is actually quite simple, but I can’t help but feel it is a little bug like. Only payments made directly via Transaction Entry or those produced during the payment run (Transactions » Purchasing » Select Cheques) are posted to Bank Management. If you need to do a manual payment into Payables, or a manual receipt into Receivables, then this needs to be done via CBM Batch Entry (Transactions » Financial » Bank Management » Batches) Continue reading “Missing Transaction In Cashbook Bank Management?”

Changing The eConnect Password In Microsoft Dynamics GP 2010

Microsoft Dynamics GPIn this post I discussed changing the password in eConnect 10. However, changes were made to eConnect 11 which means the password is not changed in the same way when using Microsoft Dynamics GP 2010.

eConnect 10 is a COM+ application while eConnect 11 is a Windows Communication Foundation (WCF) service-oriented application. This means the password change is a different process although it must still be done in two places. Continue reading “Changing The eConnect Password In Microsoft Dynamics GP 2010”

Changing The eConnect Password In Microsoft Dynamics GP 10

Microsoft Dynamics GPWhen we install Microsoft Dynamics eConnect 10 we also do so using a specially created Windows Domain user, DynamicsGPUser, which has the password policy disabled so the password never changes.

It turns out that despite this user only being used by the eConnect service, some client’s still prefer to change the password occasionally. Changing the password is a relatively simple thing to do, so long as you’re aware that the password is stored in two places. Continue reading “Changing The eConnect Password In Microsoft Dynamics GP 10”

Locked Payables Transaction: You cannot display this record while another user is editing it

Microsoft Dynamics GPWith sites using Microsoft Dynamics GP over Citrix Presentation or XenApp, where they have set Citrix to time users out after a certain period of inactivity, we occasionally see the following error message when another user tries to open the voucher in Payables Transaction Entry (Transactions » Purchasing » Transaction Entry);

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

Continue reading “Locked Payables Transaction: You cannot display this record while another user is editing it”