MDGP 2013 Feature of the Day: Reconciled Indicator

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

The eighteenth feature they’ve announced is Reconciled Indicator.

With the introduction of the Reconciled Indicator users will be able see at a glance whether a payment has been reconciled within Microsoft Dynamics GP.

Continue reading “MDGP 2013 Feature of the Day: Reconciled Indicator”

MDGP 2013 Feature of the Day: Item Standard Cost Adjustment

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

The seventeenth feature they’ve announced is Item Standard Cost Adjustment.

In Microsoft Dynamics GP 2013, a new window for changing the Standard Cost of an item has been introduced. When the Standard Cost of an item is changed, an adjusting entry will be made to the General Ledger which will keep the General Ledger and Inventory Control series in balance.

Continue reading “MDGP 2013 Feature of the Day: Item Standard Cost Adjustment”

MDGP 2013 Feature of the Day: SSRS Reports On Forms

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

The sixteenth feature they’ve announced is SSRS Reports On Forms.

This feature allows users to print SQL Server Reporting Services (SSRS) reports directly from a window in Microsoft Dynamics GP. This has been made available on a range of windows across General Ledger, Receivables Management, Sales Order Processing, Payables Management, Inventory Management, Human Resources and Payroll.

Continue reading “MDGP 2013 Feature of the Day: SSRS Reports On Forms”

MDGP 2013 Feature of the Day: Reconcile IV To GL

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

The fifteenth feature they’ve announced is Reconcile IV To GL.

Microsoft Dynamics GP 10 saw the introduction of the Reconcile to GL report which allowed the automation of the reconciliation of differences in Receivables Management and Payables Management to the General Ledger. In Microsoft Dynamics GP 2013 the Inventory Control module will be added to the Reconcile to GL to help users identify the differences between the Historical Inventory Trial Balance and the GL inventory accounts;

Continue reading “MDGP 2013 Feature of the Day: Reconcile IV To GL”

MDGP 2013 Feature of the Day: Email Indicator

MDGP 2013 Feature of the Day: Email Indicator

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

The fourteenth feature they’ve announced is Email Indicators.

Microsoft Dynamics GP 2010 introduced the ability to email various differrent trransactions directly without the need for third party products. In Microsoft Dynamics GP 2013, an icon has been introduced to the navigation lists to show a visible indicator that a particular record has been emailed.

Continue reading “MDGP 2013 Feature of the Day: Email Indicator”

MDGP 2013 Feature of the Day: Fixed Assets Historical Depreciation Report

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

The thirteenth feature they’ve announced is Fixed Assets Historical Depreciation Report.

This feature was one of the most requested features for the Fixed Asset Management series for quite a while so it is nice for it to arrive.

Continue reading “MDGP 2013 Feature of the Day: Fixed Assets Historical Depreciation Report”

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: Tenant Services

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

The eleventh feature they’ve announced is Tenant Services.

Tenant Services enables multi-tenant deployments of select Microsoft Dynamics GP applications which will improve the efficiency in delivery as a hosted solution to multiple customers.

Continue reading “MDGP 2013 Feature of the Day: Tenant Services”

Management Reporter 2012 Doesn’t Process Reports In Queue

Microsoft Dynamics GPI was on site with a client last week to do training on various parts of the system, one of which was Management Reporter.

Before the training started, I was alerted to the fact that Management Reporter had stopped working. We ran through a few issues such as the Microsoft Dynamics GP adapter disappearing from the Configuration Console (we re-added it), the Application Service was not running and couldn’t be started (it had been setup by the client using the Network Service and for some reason stopped working; we changed it to Local System and was able to restart the service but I’ve advised them to change both Management Reporter services to a Domain User account).

Once everything was set up and apparently working we encountered the final problem. When we tried to produce a report, it was added to the Management Reporter queue where it remained and did not move to a status of Processing.

I found a website discussing changing the SQL Server broker on the ManagementReporter database to true (and it was set to false) so I did this but no luck.

A little more prodding and poking at both Management Reporter and SQL Server, and I turned up the problem which was actually a fairly obvious one.

The ManagementReporter database was owned by Domain\Administrator. Running the below script to change the database owner to sa resolved the problem and allowed the reports to be processed;


sp_changedbowner 'sa'

Fortunately the investigation and resolution didn’t take a long time so we were able to do the full length training session.