Author Archives: Steve

eConnect error when adding a new Dynamics GP company

Posted on January 3, 2012 by Steve

During the creation of companies in Dynamics GP version 10 I came across the following error: The following SQL statement produced an error: set nocount on declare @NAME varchar(100) declare @TEXT varchar(8000) declare taCreateRequesterProcs insensitive cursor for select DOCTYPE from … Continue reading →

Posted in Dynamics GP | 1 Comment

New features – Dynamics GP 2012

Posted on November 17, 2011 by Steve

Here are some of the new features slated for Dynamics GP 2012 which is scheduled to be released in 2012. 1. Select a printer after viewing a report onscreen. 2. Print SSRS reports from a GP window (GP report writer’s … Continue reading →

Posted in Dynamics GP | Leave a comment

Interview with Ryan Zweng

Posted on July 14, 2011 by Steve

Ryan Zweng from accountingsoftwaredeals.com interviewed me about Dynamics GP and its usage. Here’s the interview: Microsoft Dynamics GP Overview with Steve Reese In order to expand our coverage of available accounting software options, ASD sought out Steve Reese, an expert … Continue reading →

Posted in Dynamics GP | Leave a comment

Microsoft’s change in Corporate Performance Management Roadmap

Posted on July 1, 2011 by Steve

Microsoft has changed their Product Road Map for Corporate Performance Management which includes Management Reporter -a Financial Reporting tool (FRx replacement) and Forecaster – a financial budgeting tool. At Microsoft’s recent conference (Convergence), the Corporate Performance Management products show “continued support … Continue reading →

Posted in Forecaster, Management Reporter | Leave a comment

What does not migrate from FRx to Management Reporter

Posted on June 28, 2011 by Steve

When you use the Migration Wizard in Microsoft Management Reporter to migrate all your FRx data not all information is migrated. The following list of features is not part of the migration process.  Many of these features exist in Management Reporter, they’re just not part of … Continue reading →

Posted in Management Reporter | Leave a comment

Export the Dynamics GP Payables or Receivables Historical Aged Trial Balance to Excel

Posted on June 27, 2011 by Steve

This is a modified Dynamics GP report (see download) I’ve provided to my clients for years that can be exported to a text file and imported into excel that includes the customer ID, name, and the aging columns. Through GP … Continue reading →

Posted in Dynamics GP | 80 Comments

Consolidations (of multiple currencies) in FRx

Posted on November 22, 2010 by Steve

The basic problem is how do I create a single set of financial reports in US dollars when I do business in multiple countries and currencies which is basically called “Consolidations”. There are quite a few alternatives to consolidations in … Continue reading →

Posted in FRx | Leave a comment

YTD amounts and statistics in one column in FRx using Dynamics GP

Posted on November 17, 2010 by Steve

Problem: In one column in FRx how can I have YTD amounts and statistics where the statistics need be based on “net change”? By nature, YTD columns include any accounts with beginning balances including statistical accounts so how can I … Continue reading →

Posted in FRx | Leave a comment

Importing to Dynamics GP without integration manager or SQL

Posted on October 26, 2010 by Steve

Not all Dynamics GP users own integration manager nor does integration manager support every field, another way of importing data is to use a macro. This feature could be used to insert new records or make updates and it could … Continue reading →

Posted in Dynamics GP | 2 Comments

MSXML error after installing FRx 6.7 sp9 on Windows 7

Posted on October 2, 2010 by Steve

After installing FRx 6.7 with service pack 9 on a windows 7 machine (x86) the user gets the following error when launching the drill-down viewer file “A newer version of msxml.dll is required” FRx 6.7 service pack 11 is compatible … Continue reading →

Posted in FRx | 1 Comment