Setting up Forecaster and adding connections on end user machines

I know i have to do this soon, I stumbled across this blogg by Christina Pillips and it will save me the drama next week. See link below.

Dynamics GP Land: Forecaster.ini...or maybe outie?: With a 4 month old in the house, I can't resist a belly button joke :) I wanted to take a moment to share a little shortcut concerning mana...

VirtualBox – Cannot Register the Hard Drive Because a Hard Drive with UUID Already Exists

Ok so you're trying to create another virtual machine using an existing hard disk file and you get the below error... What do you do? Follow the below guaranteed steps.





Failed to open the hard disk <FilePath>.
Cannot register the hard disk <FilePath><GUID> becuase a hard disk <DifferentFilePath> with UUID <GUID> already exists.

1. Open the Command Prompt
2. Change the directory to where VirtualBox is installed (Default: C:\Program Files\Oracle\VirtualBox) (see below on how to change the command prompt directory to another location)
3. Type the following VBOXMANAGE.EXE internalcommands sethduuid <PathOfNewVHD>

Note that internalcommands and sethduuid need to be lowercase.
Below is the output of me changing the ID of the VHD located at C:\Users\bschacht\VirtualBox VMs\Windows XP (VPN) Copy.vhd





TO CHANGE THE COMMAND PROMPT DIRECTORY DEFAULT PATH:

Type "cd\program files\" etc and then press enter (in the command prompt)

i.e. cd\path and then press enter.

Microsoft Forecaster 7.0 Tip for using Revenue tab

If you are using your Revenue tab in Forecaster as the standard that is setup that is: market, product and rate, there are some things you need to know.

If you want to use a specific set of input lines for the product (for example you want a full listing of your products so users can enter units to be sold for the various periods) then when entering the product setup select a line which would include the relevant details (product listing).

If you want to use the rates feature then you need to leave the lines for the product blank and then enter the rates in the rate tab. When the user is entering the data on the revenue tab they will have to select which rate they want to enter the information against.

Hope I save you some days in trying to figure this out...

Management Reporter: Clear Queue

To clear the queue of stuck reports in Management Reporter run the below in SQL server management studio.

USE MANAGEMENTREPORTER
DELETE RepositoryMessage

This will clear the queue.

Unable to complete login process due to delay in opening server connection

You may receive this error when trying to create a new odbc connection to the server for dynamics gp.

To resolve this error:
Go to the server and change the firewall settings. Disable the firewall for the Domain Profile.

Voila!

Fatal Error: Language database file c:\prog~1\FRXSOF~1\FRX6~1.7\REPORT~2\FRxXML4.dat not found.

Unable to generate FRx reports the above error keeps displaying.

To resolve:
SOLUTION 1: Try the KB article by Microsoft 932318. 


If the KB article doesn't work the below is guaranteed to work.


SOLUTION 2:  Run the FRxReg.exe located in the FRx 6.7 directory and then attempt to run the report again. You should have no issues.

How to create a macro to automatically log in and Post a batch

STEP 1: Create macro to sign into GP and post batch.

Click on GP launch file.
When the sign in window appears click 'Alt + F8' to begin the recording of the macro.
Name your macro and the location to be saved to.
Continue the process as if you were going to post the batch.
Therefore, enter userid and password, click ok, select company, etc.
Go to Menu and click Transactions>> Sales>> Series POst (for example). click on batch to post and continue with the steps that the auto proceedure should complete. once finished click 'Alt + F8" to stop recording the macro.


STEP 2: Create Notepad file.

Create a note pad document, in the contents of the document enter the location of the Dynamics exe file, the set file and the location of the macro.
For example: "C:\Program Files\Microsoft Dynamics\GP\DYNAMICS.EXE" "C:\Program Files\Microsoft Dynamics\GP\DYNAMICS.SET" "C:\Program Files\Microsoft Dynamics\GP\DATA\AUTOPOST.MAC"


STEP 3: Change notepad file to batch file.

Right click on the notepad file and change the extention from '.txt' to '.bat'


STEP 4: Run macro.
To run macro just double click on the batch file.

*If you need to edit the batch file - right click on the file and click 'edit'

For more information on Integration manager autoposts see the following link by Mariano Gomez.
http://dynamicsgpblogster.blogspot.com/2009/01/how-to-schedule-dynamics-gp-to.html