As part 3 of our blog series on budgeting in Dynamics SL, we are now ready to take a look at how simple it is to build reports for budgeting.
If you didn’t get a chance to read Part 1/3: Budget Import in Dynamics SL: How to create an Excel budget template and fill it in properly blog or Part 2/3: Budget Import in Dynamics SL: How to perform the Excel Budget import you may want to view them now for a complete step by step process on budgeting in SL.
For now, let’s focus on how to prepare the budget reports in Management Reporter. In an effort to simplify the process, be sure to follow these steps carefully while utilizing the screen shot to verify you are following the steps properly.
Let’s get started!
Step 1: Create new Column Definition or Revise a Current One
Add a new column:
- Column Type: FD (financial Dimension)
- Book Code: Ledger id used in the budget import
- Fiscal Year: Base for report year
- Period: Base for current period budget
or YTD for budget as of report period
or 12 for end of year budget
Step 2: Variance Column may also be added to calculate difference between Actual and Budget.
Step 3: Save format with new name : Budget vs Actual
Step 4: Update Report definition to use new column format.
Step 5: Lastly, run the report and review.
Fairly simple, don’t you think? After all of the work that it takes to get a budget together before it is even entered into Dynamics SL, it is nice to see that the last step, preparing the report is not too difficult. Happy Budgeting!