I’m sure all of you have read and thoroughly enjoyed my blog post on manually changing the SysData location. Well, today I was doing a server move and ran into the same issue, so I followed my own advice but it still wouldn’t update properly! I was stumped, until I realized that, sometimes, there is …
Category Archive: GP Reporting
Sep
13
Manually changing SysData location
Recently, after installing FRx 6.7 with the media for GP 10 (the media that includes SP9), I ran into an issue changing the SysData location. Typically, when trying to change the location through the back end, I would modify the FRx32.cfg file and make the change in here. However, when trying to do it with …
Sep
13
Error message when you start Microsoft FRx after applying a service pack: “Runtime Error 32797: Application Defined or Object Defined Error”
Ran into an issue today installing a fresh installation of FRx. This is on a 32-bit version of Windows 7, using the download that includes SP9 and applying SP12 after the install. When launching Report Designer, I get the following error: Runtime Error 32797: Application Defined or Object Defined Error And, unfortunately, FRx will not …
Jan
18
Adjusting the print on W-2s or 1099s
The act of printing W-2s and 1099s is quite an accomplishment. Finding that you are just “a little off” when the item actually prints to paper can be a little deflating, but not to fear. It is not impossible to correctly align things! This is where Horizontal and Vertical Adjustments come into play. When you print …
Nov
24
Emailing Documents and Word Templates for Microsoft Dynamics GP 11
With Microsoft Dynamics GP 11 rolling out just around the corner, we are dedicating a number of blog posts to giving you a sneak peak at the new features you can expect to see. Today’s topic is focused on a new feature that will be included with GP 11. In GP 11, you will now …
Nov
20
Business Intelligence in Microsoft Dynamics GP 11
The pieces are starting to come together on what the next release of Microsoft Dynamics GP 11 is going to look like. There are going to be a number of changes coming in GP 11 that we will be giving you a sneak peak into. The first thing I’m writing about is the future of …
Nov
11
Adding a Stored Procedure to an Excel Microsoft Query
This may be somewhat technical, but for those of you who utilize Excel quite heavily and are adept at using Microsoft Query to create refreshable reports/lists, you may want to utilize a Stored Procedure that has already been created in Microsoft SQL. A Stored Procedure is a group of SQL commands that runs to produce …