Budget control

Business Central Accelerator provides budget control, which can be used to monitor the budget funds that are available for planned and actual purchases and expenditures.

You can define the budget on level of the GL Accounts for basic budgeting and budget control. When you configure budget control, you need to setup the working budget for the fiscal year.

The available budget funds can be verified when purchase documents are entered. You can view the status of the budget and actual versus budgeted amounts.

Note

In case there is not enough budget, the system will not block users to submit the purchase order.

Setup

1. Choose the search icon, enter Business Central Accelerator setup, activate Budget Control.
2. Choose the search icon, enter Budget
3. In the Budget list page, activate Working Budget
4. Enter the Budget Begin date an End Date

Note

You can have more than 1 active Working Budget. At the end of the year you can create a budget for the next year. The order date on purchase documents will be used for budget control.

5. Create the budget for the active Working Budget on GL account

Execution

1. Make a new purchase order on GL account or Item level.

Note

For items : The budget control is looking up the linked Purchase GL account in the Product Posting Group.

2. Verify the Order Date on the purchase order. This posting date is used to verify the working budget.

3. The factbox Budget Control on the right side, shows the Budget amount, Budget YTD amount, Actual on GL YTD, Ordered/Received amount, Open Purchase Invoices (non posted) and Open Credit Memo’s (non posted)YTD. It's depending on the starting date of the budget period where’s linked to

4. Post the purchase order for receiving and invoicing.The budget control is updated

Budget control on GL Balance

  1. Choose the search icon, enter Budgets
  2. Open the G/L Balance/Budget on the working budget
  3. Look into the columns
    • Open Purchase Orders
    • Received, Not invoiced Purchase orders
    • Open Purchase invoices (No link without purchase orders)
    • Open Credit memo’s

This budget overview can be exported into Excel via Select all rows and Copy Rows functionality.