How to Configure the Forecaster Data Transfer Tool

As you know, when FRx went away, so did the ability to view budget information in Financial Statements. Now, you need to import data into GP and create the reports in Management Reporter. I spoke with a Microsoft Forecaster support professional on April 11. He wouldn’t be quoted, but he said they are working on ways to view forecaster data in Management reporter. Until then, we are stuck with the Data Transfer tool, used to move data from Forecaster to GP.

Start | Microsoft Forecaster Data Transfer

General Ledger information:

Select the server.

Log in as “sa” using SQL authentication and click “Connect.”

Select the GP company.

Forecaster information:

Select the server and click “Connect.”

Log in as “sa” using SQL authentication and click “Connect.”

Select the Forecaster database.

8159-1

It is important to log into each database as “sa.”

8159-2

Single company mapping – one company in Forecaster = one company in GP

Simple account mapping – all of the centers in Forecaster match the segments in GP

Complex account mapping – different segments between GP and Forecaster

8159-3

 

Always enter the GL Account Start Position, even if it’s 1.

Save the mapping; next time, you will load mapping and not have to recreate it.

8159-4

Select the input set in Forecaster and the General Ledger budget in GP.

Map the periods from Forecaster periods to GP fiscal periods.

Click “Clear Errors” to clear any previous errors.

Click “Clear Budget” to clear the budget before reimporting.

Click “Transfer,” and your Forecaster data should be loaded.

 

Tagged on:

Leave a Reply

Your email address will not be published. Required fields are marked *