Exercise - Create and copy budgets
This exercise is written to use the Cronus sample company from the US version of Business Central. You might need to make adjustments to the steps if you use the sample company from your country or region.
Create a budget
You are the CFO at CRONUS and you need to set up a new January 2022 expense budget by department.
Name the budget EXP2020 -Expenses by department 2022 and use the Budget Dimensions Department. The budgeted expenses are as shown in the following table.
| Department | G/L Account | Budgeted Amount |
|---|---|---|
| ADM | 61200 | 40,000.00 |
| PROD | 61200 | 56,000.00 |
| SALES | 61200 | 24,000.00 |
| ADM | 61400 | 8,900.00 |
| PROD | 61400 | 18.980.00 |
| SALES | 61400 | 21,00.00 |
Task
Set up the budget.
Steps
Select the Search for Page icon in the top-right corner of the page, enter G/L budgets, and then select the related link.
Select New.
In the Name field, enter EXP2022.
In the Description field, enter Expenses by department 2020.
Select Process > Edit Budget.
In the Show as Columns field, select DEPARTMENT.
In the View by field, select Year.
Expand the Filters FastTab.
In the Date Filter field, enter 01/01/2022..12/31/2022.
In the G/L Account Filter field, enter 61200..61400.
In the Budget Matrix area, enter the amounts by using the table from the exercise introduction.
Close the Budget page.
Copy a budget
Now that you have entered the expense budget for 2022, you want to configure the 2023 budget by using the copy function. Because you expect to have higher expenses in 2023, you want to increase the 2022 budget amounts by 10 percent.
Task
Use the copy function to create the 2023 budget.
Steps
Select the Search for Page icon in the top-right corner of the page, enter G/L budgets, and then select the related link.
Select the EXP2022 budget.
Select Process > Edit Budget.
Select Budget > Copy Budget.
In the Copy from area of the Copy G/L Budget page, in the Source field, select G/L Budget Entry.
In the Budget Name field, enter EXP2022.
In the Date field, enter 01/01/2022..12/31/2022.
In the Dimensions field, select AssistEdit and then select DEPARTMENT. Select Close.
In the Budget Name field, select the Lookup Value and then select New.
In the Name field, enter EXP2023.
In the Description field, enter Expenses by department 2023.
Select OK.
In the Adjustment Factor field, enter 1.1.
In the Date Change Formula field, enter +1Y.
Select OK.
Select Yes.
Select OK.