Tag Archives: Reports

Microsoft Dynamics GP 2013 Reporting – Review Incoming

I have received a copy of Microsoft Dynamics GP 2013 Reporting to review which I will be doing over the next couple of weeks.

This is an update to the previous edition of the book for Microsoft Dynamics GP 2010, but this one is for the current version:

Microsoft Dynamics GP 2013 Reporting

I’ll be giving it a thorough read and, setting aside my distaste for reporting outside of Management Reporter, I may even follow some of the examples and post a detailed account.

If you don’t want to wait for my review of the book, it can be bought now from Packt Publishing.

Posted in Dynamics, GP, Management Reporter, Microsoft, Reporting Services Reports, SmartList Builder | Tagged , , , , , , , , , , , , , , , , , | Leave a comment

Collation Conflict Printing The Tax Detail Report

We upgraded a client from Microsoft Dynamics GP 9 to Microsoft Dynamics GP 2010 recently, and the first time they tried to run the VAT 100 report they received a number of errors:

Microsoft Dynamics GP - An error occurred executing SQL statements.Microsoft Dynamics GP – An error occurred executing SQL statements.

Continue reading

Posted in Dynamics, GP, Microsoft | Tagged , , , , , , , , | Leave a comment

How To Configure Business Analyzer for Microsoft Dynamics GP 2013

In the last post, I showed how to install Microsoft Dynamics GP Business Analyzer and in this one I’ll show how to configure it.

When you first log into Business Analyzer, you’ll be presented with the configuration window;

Microsoft Dynamics Business Analyzer Configuration

Continue reading

Posted in Business Analyzer, Dynamics, GP, Microsoft | Tagged , , , , , , , , | 2 Comments

How To Realign Trial Balance Summary Modified Report Columns

I 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

Posted in Dynamics, GP, Microsoft, Report Writer | Tagged , , , , , , , , , , | 3 Comments

MDGP 2013 Feature of the Day: Multitenant SQL Server Reporting Services Reports

Microsoft are posting the Microsoft Dynamics GP 2013 Feature of the Day series on the Inside Microsoft Dynamics GP Blog.

The forty fourth feature they’ve announced is Multitenant SQL Server Reporting Services Reports.

The current version of Microsoft Dynamics GP only supports a dedicated instance of SQL Server Reporting Services for each Microsoft Dynamics GP data instance. With the introduction of the Multi-tenant System Database Architecture, the SQL Server Reporting Services needed to be updated to allow for similar functionality.

With this Multi-tenant SQL Server Reporting Services Reports feature, multiple data instances can be deployed to a single SQL Server Reporting Services instance by allowing the implementer to to deploy the reports to a “tenant” folder.

Continue reading

Posted in Dynamics, GP, Microsoft, Reporting Services Reports | Tagged , , , , , , , | 4 Comments

MDGP 2013 Feature of the Day: Reconcile Bank Reconciliation to General Ledger

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

The twenty sixth feature they’ve announced is Reconcile Bank Reconciliation to General Ledger.

In Microsoft Dynamics GP 2013, Microsoft have added the Bank Reconciliation module to the Reconcile to GL routine, which was first introduced in Microsoft Dynamics GP 10, to help users analyse differences between the checkbook balances in the Checkbook Balance Inquiry window and the associated General Ledger cash account for the checkbook.

Continue reading

Posted in Dynamics, GP, Microsoft | Tagged , , , , , , , , , , | 1 Comment

MDGP 2013 Feature of the Day: SSRS Reports On Forms

Microsoft 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

Posted in Dynamics, GP, Microsoft | Tagged , , , , , , , , , , , , , , , , , , | 1 Comment

MDGP 2013 Feature of the Day: Reconcile IV To GL

Microsoft 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

Posted in Dynamics, GP, Microsoft | Tagged , , , , , , , , , , , | 1 Comment

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

Microsoft 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

Posted in Dynamics, GP, Microsoft | Tagged , , , , , , , | 1 Comment

MDGP 2013 Feature of the Day: Print on Picklist Shortage Enquiry

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

The fourth feature they’ve announced is Print on Picklist Shortage Enquiry.

Continue reading

Posted in Dynamics, GP, Microsoft | Tagged , , , , , , , , , | 1 Comment