Author Archives: Steve

Reconcile Receivable/Payable agings to the general ledger and voids

Posted on February 2, 2017 by Steve

Voiding receivable or payable transactions can create differences when reconciling your subledgers to the GL. On the void windows for receivable or payables there are two date fields, one refers to the general ledger and one refers to subledger so … Continue reading →

Posted in Dynamics GP | Tagged | Leave a comment

Export Payables Detail Historical Trial Balance to excel from reporting services

Posted on March 27, 2015 by Steve

Microsoft provides an accounts payable detail historical aging report in SQL report services that I have modified to easily export to excel, here’s what the output looks like: This report originates from the standard report Dynamics GP provides when you … Continue reading →

Posted in Dynamics GP, SQL reporting | Leave a comment

Keeping the header rows visible in SQL reporting services

Posted on December 22, 2014 by Steve

Have you every had problems where your reporting services report loses it’s header row as you scroll?  Take a look at this video – It helped the look and feel of my reports significantly.

Posted in SQL reporting | Leave a comment

FRx launcher run-time error 9 subscript out of range

Posted on October 24, 2014 by Steve

Of all the issues that can come up from this error message, I have not found this one anywhere.  It’s a combination of running the FRx launcher (not designer) and a report with rounding.  The top is the error message … Continue reading →

Posted in FRx | Leave a comment

In Dynamics GP 2013 R2 you can copy/paste a GL entry from excel directly to the transaction entry window

Posted on September 12, 2014 by Steve

You’ll need the following columns set up in excel, just copy them to your clipboard (Ctrl+C), be sure to exclude the header row. The column names do not matter but the column order does matter. Open up the GL transaction … Continue reading →

Posted in Dynamics GP | Leave a comment

Deletion of GL accounts during the year-end close process

Posted on June 20, 2014 by Steve

In Dynamics GP when users run the general ledger year-end close some GL accounts may be deleted if the following criteria is met. • No balance• No activity for an open period• No account history amounts• Not part of an … Continue reading →

Posted in Dynamics GP | Leave a comment

Management Reporter Export Report Definition Listing to Excel

Posted on June 5, 2014 by Steve

A client asked me if I can get a listing of report definitions out to excel so I contacted an MR colleague and here’s what she came up with that works well: 1. Open up Report Designer 2. Open up … Continue reading →

Posted in Management Reporter | Leave a comment

How do I remove a budget password in Dynamics GP 2010

Posted on March 28, 2014 by Steve

A client forgot the password for her Dynamics GP budget, here’s a SQL update statement to blank out the password, be sure not to put quotes around the password because it’s not a text field.  It should be run against your … Continue reading →

Posted in Dynamics GP | Leave a comment

Export group name in SSRS 2008 to worksheet tab name in excel

Posted on March 14, 2014 by Steve

Recently, I tried to name a worksheet tab in excel from each group in SQL Reporting Services 2008.  I found that the group name needs to be entered into the tablix member group called “PageName”. The first screenshot shows the … Continue reading →

Posted in SQL reporting | 6 Comments

Change fixed assets from fiscal to calendar year end

Posted on November 8, 2013 by Steve

After changing the GL year end from fiscal to calendar on GP10sp2 by reopening all the history years with Microsoft support we found that fixed assets would not depreciate correctly because it was in the middle of a fiscal year … Continue reading →

Posted in Dynamics GP | 4 Comments