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”

Feature Explained: Reporting Ledgers

Microsoft Dynamics GPIn Microsoft Dynamics GP 2010, Microsoft introduced the Reporting Ledger functionality which allows journals to be posted to one of three reporting ledgers; base, local, or International Financial Reporting Standards (IFRS).

This functionality is controlled via the General Ledger Setup window (Microsoft Dynamics GP menu ¯ Tools ¯ Setup ¯ Financial ¯ General Ledger);

Reporting Ledgers: Enabling via General Ledger Setup

Continue reading “Feature Explained: Reporting Ledgers”

There May Be A Disruption In My Posting Frequency

As the post title says; there may be a disruption in how often I am able to post to this site over the next few days and, perhaps, weeks.

The reason is that I start a new job today.

Over the last eight years I have worked as a support analyst, a senior support analyst and as a finance consultant for a Microsoft Silver Partner in the NW of England dealing with Microsoft Dynamics GP.

As of this morning, I am starting a new job as a consultant for a Microsoft Gold Partner in the NE of England dealing with Microsoft Dynamics GP but also with the potential for learning some Microsoft Dynamics CRM.

I intend that the subject matter remain mainly with Dynamics GP but I will include anything of interest from Dynamics CRM that I come across.

I hope you’ll bear with me through any disruption and don’t forget about me 🙂

Integrations Via eConnect Disappearing

Microsoft Dynamics GPAs well as using eConnect to integrate journals from an external system into the GL, we also use it to integrate invoices into Payables Management. Overall we have far fewer problems integrating transactions via eConnect than we had in the past using Integration Manager, but we do still encounter some problems; usually with transactions being posted in the external system and then disappearing.

This is sometimes a more exotic reason but is usually an issue with the eConnect service needing to be restarted. When we first started using eConnect we often had problems when the server was rebooted as the eConnect service was starting before the MSMQ service and didn’t then function correctly.

To fix this issue we added a dependency to MSMQ on the eConnect service which ensures the eConnect one does not start until MSMQ is ready. This particular fix has just resulted in a site posting invoices in an external system which didn’t arrive in Microsoft Dynamics GP. Continue reading “Integrations Via eConnect Disappearing”

Mea Culpa: Fixing A Corrupt Sales Invoice

Microsoft Dynamics GPIn this post I discussed fixing a Sales Invoice which was corrupt and how Microsoft Dynamics GP Check Links couldn’t be used to fix the problem as it only looks at the standard tables but the invoice in question was a recurring invoice created using Nolan Business Solutions’ Advanced Sales Order processing with recurring Invoices. Continue reading “Mea Culpa: Fixing A Corrupt Sales Invoice”

Aged Debtors Report Problem

Microsoft Dynamics GPI was on site today to do a sales demo of a couple of new modules to an existing client. At the end of the demo, the new Head of Finance had a word with me about the Aged Debtors report which was not working correctly.

He showed me a copy of the report and all invoices, regardless of the transaction date, were showing in the Current Period. My first thought was that the Aging process (Microsoft Dynamics GP menu ¯ Tools ¯ Routine ¯ Sales ¯ Aging) had not been run; a hurried think for other options drew a blank. Continue reading “Aged Debtors Report Problem”

Microsoft Dynamics GP 2010 R2 On Windows 8 Developer Preview

Microsoft Dynamics GP
Microsoft Windows 8
Well, I’ve just finished installing SQL Server 2008 R2 and Microsoft Dynamics 2010 R2 on the Windows 8 Developer Preview and GP is exactly like it is on Windows 7. Continue reading “Microsoft Dynamics GP 2010 R2 On Windows 8 Developer Preview”