Dynamics GP

PLEASE NOTE– GP 2010

**Please note**   2014 was the LAST year end update for GP 2010…end of tax / updates is October of 2015…if you are on GP 2010, you will need to look at upgrading and planning.   Please contact us for further assistance  

GP2015 R2 not deploying all of the SSRS reports

Encountered an issue where GP2015 R2 was not deploying all of the SSRS reports.  Performed the following to resolve it:  Cleared all the records from the DYNAMICS..syDeployedReports table.  Changed the execution timeout line of the the web.config file (usually located in the C:\Program Files\Microsoft SQL Server\MSRS12.MSSQLSERVER\Reporting Services\ReportServer folder) Look for the line : <httpRuntime executionTimeout=”9000″ […]

Management Reporter Web Viewer Prints Only One Page

If using the web viewer in Management Reporter, with the print destination set to the Screen, you may notice an issue where only the first page of a report will print. The issue reported in known by Microsoft and a software patch is necessary to fix it. Below is Microsoft description of the issue: KB […]

Migrating Management Reporter Database to New SQL Server

When migrating a Management Reporter database to a new SQL server, we followed the exact steps in KB 2744330. Backup Management Reporter on the old SQL Server. Remove the integration in Configuration Console. Remove the Application and Process services in Configuration Console. Restore Management Reporter database on the new SQL Server. Run script provided by […]

GP/CRM Connector – Invoices Only with Write-In Products

In the middle of an implementation of CRM 2015, a client of ours expressed that they needed the invoices to come over into CRM from GP without Products.  We reviewed the connector and tried multiple attempts, but the invoices would fail if the invoice in GP was tied to a product in GP.  Even if […]

Financial Reporting for Non-profit Organizations with Dynamics GP

Financial Reporting for Non-profit Organizations with Dynamics GP By Opal Business Solutions Financial reporting has been the leading Business Intelligence process since the inception of analytics – and this is no different for non-profit organizations.  If you’re using Microsoft Dynamics GP, you’re aware of the accounting system’s built-in financial report writing functionality.  That said, several […]

OLE Notes Window in GP Not Appearing

In a terminal server environment where GP is deployed as a remote app, and users have dual monitors, the notes window may be hidden.  Someone may have launched the notes window and moved between monitors or sized it differently within their session.  GP or Windows is remembering the position and size.  When another user is […]

Microsoft Dynamics GP Workflow

Dynamics GP users may experience an issue with workflow emails not functioning.  The Test Email will work, but the actual workflow does not initiate the email to an intended recipient. When sending the email, Dynamics GP relies on Active Directory account information. The Active Directory user maintenance screen must have an email address field entered […]

Management Reporter Database Upgrade – SQL Timeout Error

While upgrading a client to Management Reporter (MR) 2012, the database upgrade failed due to a SQL timeout exception. The timeout setting was originally set to a time that could not do all conversions, causing the configuration to fail. The solution: 1. Find the SQL timeout value setting in the MRConfigurationConsole file. This is in […]

Dynamics GP: Deduction in Arrears – Hourly vs. Salary

To arrear or not to arrear? You may be required to by law! If an employee’s pay is insufficient to pay for mandatory deductions like health coverage, the Deductions in Arrears (DIA) feature in Dynamics GP helps to track what is owed by that employee. The Problem The client had one employee where DIA would […]