FRx Forecaster Import is Easy

In presenting demos of FRx Forecaster over the past years, I have always avoided using the import tools to get data into Forecaster. However for the demo I presented last week I wanted to import actual data from Dynamics GP and comma delimted data from MS Project, so I could show our prospect how Forecaster could be used to compre actual and plan data for a project oriented developer.

As it turned out, it was easy to do.

For Dynamics GP data, navigate to: Tools >> Import >> ExpressLink. This will start the ExpressLink Wizard that will direct you to login into FRx and Dynamics GP. The next process is to set up a mapping of the accounts and time periods from Dynamics GP, to Forecaster. This map can be reused. Then you just start the import and the data rolls into your column layouts. Easy.

For the MS Project data, I used the Data Import screen which one gets to by navigating to: Tools >> Import >> Data. This will create a batch of "transactions" that will then be "posted" by Forecaster. The process will have you create a mapping of accounts and time periods; that can be saved for future use.

These two processes were easy to learn and ran without problems.

When I get more time, I'm going to mess around with the "Import Detail Data" import to see how that works.

Bottom-Up Collaborative Budgeting

Now is a good time to take a look at FRx Forecaster. The recent release of FRx Forecaster 7.0 provides a new user interface that is much more compelling than the previous releases. The new interface will make it much easier to get others within your organization to use the product.

I see FRx Forecaster primarily as a collaborative tool; the benefits of which, are realized when a number of people are involved in the budgeting process. If you are responsible for creating and managing the budget for your organization by yourself, FRx Forecaster is probably not for you. Continue to use Excel. But if you have several other people involved in the process, FRx Forecaster provides control and security that eliminates the headaches of managing dozens of Excel spreadsheets with countless versions.

FRx Forecaster allows input worksheets to be distributed to individuals in your organization so that individuals only get the information they are allowed to view and modify. Individuals can add notes and additional lines of detail and explanation, but cannot ruin the structure of the worksheets, that traditionally wreaks havoc on Excel-based systems.

FRx Forecaster also provides three small applications that can be used to walk individuals through the budget process. These include Fixed Assets, HR, and a user-defined model; that traditionally is used for sales, but could be used for other purposes.

More good news: If you currently own or are acquiring an Advanced Management (BRL) system, The FRx Forecaster Server and one user are included.

If you do not budget alone, check out FRx Forecaster.

Review Dave McClure’s review of budgeting offerings.