Author Archives: Steve

eConnect error when adding a new Dynamics GP company

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

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

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

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

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

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

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

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

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

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