Are you tired of spending time every year-end modifying your FRx or Management Reporter reports to report against the new budget? It can be a painful and time consuming process if you have lots of reports.

Here is a simple solution to this annual headache:

Create a budget called CUR_YR and another one called PRIOR_YR in Dynamics GP. All your standard reports that have budget column(s) will reference Book Code CUR_YR.

Dynamics GP Budget

 

Create a set of reports indicating they are Prior Year reports and associate column building blocks with PRIOR_YR in the Book Code. You will do this once and never need to change them again or worry that you missed changing a column.

When creating your budget for the new fiscal year in Dynamics GP, create it with a code that includes the fiscal year. Make sure to have a set of columns for confirming that your budget is correct. You will need to maintain the Book Code in this column building block, but this should be the only column building block you are manipulating for the budget.

Once your budget for the new year is correct and you have closed your year, you will need to do the following steps from Financial >> Cards >> Budgets.

1. Delete budget PRIOR_YR (This is assuming it exists because you did this last year. If it doesn’t exist, skip this step.)

2. Export budget CUR_YR to Excel (This is assuming you did this last year. If this is your first time, export the budget for the prior fiscal year.)

a) Highlight budget CUR_YR and press Excel >> Export to Excel (If this is your first time, highlight the appropriate sheet.)

Dynamics GP Budget Selecetion

b) Export a New workbook

 Dynamics GP Export Budget to Excel

c) Select the location to save the file and hit Open.

Dynamics GP Budget Excel

d) The Excel file will display. Close the file.

3. Import from Excel and create budget PRIOR_YR

Budget Selection Dynamics GP

a) This will open the Budget Wizard for Excel; hit Next >

Budget Wizard for Excel Dynamics GP

b) Select the option to import ‘A new Microsoft Dynamics GP budget’ and hit Next >

Budget Wizard for Excel

c) Enter PRIOR_YR as the budget ID, a description for the budget, select Fiscal Year as how to base the budget, and select the prior fiscal year as the date range for the budget and hit Next >

Dynamics GP Budget Wizard for Excel

d) Browse to the location where you saved the budget you exported in step c and select the appropriate worksheet and hit Next >

Great Plains Budget Wizard for Excel

e) Press Finish and budget PRIOR_YR will be created using the data you exported.

Great Plains Budget Wizard for Excel

4. Run your budget report with PRIOR_YR in the columns to confirm that the budget imported correctly and reflects the data you want.

5. If step four has the data you want, you will start the process over to import the current year budget. Delete budget CUR_YR. (If this is the first time you are doing this, there will not be a budget to delete.)

6. Export the new year’s budget to Excel.

a) Highlight the appropriate budget and hit Excel >> Export to Excel

Budget Selection Great Plains

b) Export a New workbook

Export Budget to Excel

c) Select the location to save the file and hit Open.

Select Excel file

7. Import from Excel and create budget CUR_YR

Budget Selection Import from Excel

a) This will open the Budget Wizard for Excel; hit Next >

Budget Wizard

b) Select the option to import A new Microsoft Dynamics GP budget and hit Next >

Wizard Budget

c) Enter CUR_YR as the budget ID, a description for the budget, select Fiscal Year as how to base the budget, and select the Current fiscal year as the date range for the budget and hit Next >

Current Year Budget

d) Browse to the location where you saved the budget you exported in step c and press Open; select the appropriate worksheet and hit Next >

Budget Wizard for Excel Fical Year

e) Click Finish and budget CUR_YR will be created using the data you exported.

Excel Budget

8. Run your budget report with CUR_YR in the columns to confirm that the budget imported correctly and reflects the data you want.

This might seem like a lot of steps, but it is really quite simple and has saved me lots of time over the years.

Feel free to reach out should you have questions or need assistance with Dynamics GP.

Written by:
Sue Walker-Johnson, Senior Dynamics GP Consultant
FMT Consultants