Wednesday, January 28, 2009
Here's some quick information on how Forecaster stores application connections.

I'm running Forecaster 7.0 under Citrix and we ran into an issue where any new application connections that we're being created weren't being saved. It turns out that these connections are stored thusly:

T:\Documents and Settings\\Local Settings\Application Data\Microsoft\Forecaster\Forecaster.ini
(where T: is our system drive letter under Citrix).

The contents of Forecaster.ini are pretty straight forward, here's an example entry:

FileName=T:\Program Files\Microsoft Forecaster 7.0\Demo70.mdb

We're getting around the fact that Citrix cleans up this file on logoff (thus erasing any newly created application connections) by using a batch file to copy this file to and from the user's home drive during logon and logoff.

I hope this helps with anyone needing make sure these entries get saved or if they need to be moved (or copied or whatever)!

Tuesday, January 27, 2009
Take Great Plains for a try out virtually!

Thursday, January 22, 2009
Found this great video covering various tools available for customizing your Great Plains install!

You ever want to know how to do something? You don't want the why or a bunch of "fluff" about the architechure, you just want to know where to click to make things happen. I find that "How To" Videos can really help out in this situation! 

I was pleasantly surprised to find a bunch of these "How To" videos posted up on YouTube! Who would have thunk it? I thought YouTube was only for music videos and RickRolling! Well, come to find out, many reputeable companies are using YouTube to post all sorts of educational videos. 

For "How To" Video's in the Great Plains world, check out this link:

This is the YouTube homepage (aka channel) of our friend from DynamicAccouting.Net, Mark Polino. It's pure gold when it comes to finding out the how to do a specific thing in GP!

If it turns out that you are after more of the "why" type info (and I guess we do that need, too, eventually), try this YouTube channel:

or this one, from Microsoft:

Happy Video Watching!

Friday, January 9, 2009
Found this little gem, a great quick reference for Great Plains 10 Table Names!

And more great downloads here:

Thanks to Mark Polino and the guys from from!
Monday, January 5, 2009
I found this bit of SQL while reviewing a trace of Great Plains acitivity:


and I was wondering what the heck the column desSPRkmhBBCreh was, as it wasn't in any tables that I could find.

Then I found this gem:

Ah ha! It's all so clear now.... :-)
Sunday, January 4, 2009
So here's something I didn't know (among many things!), adding the text <TEST> to the end of a company name in Great Plains causes a pop up message to appear when a user first logs into the sysetem. The message warns the user that they are in a test system and not to put in any real data. Here's the actual pop up:

This is especially useful in my QA and Dev environments, since I occasionally have real end users in there testing new features.

Pretty cool trick!