A budget is never charged directly. Costs always reach the budget through work orders: you assign a work order to a budget position, and everything posted to the work order from then on appears in the cost columns of that position. In addition, you can have the budget calculate which costs are still to be expected from the planning lines and which external services have been ordered but not yet invoiced.
Prerequisites
- A budget with at least one position exists, see Create and structure a budget.
- The work order has the status Planning. From the status Execution onwards, Budget Name and Budget Position No. can no longer be changed.
Assign a work order to a budget
- Open the work order and go to the Accounting FastTab.
- In the Budget Name field, select the budget.
- In the Budget Position No. field, select the position. The list only shows positions of the selected budget that are not blocked.
maintool derives the parent budget of the position from this.
Always select a budget position as well. In the budget, costs are assigned via the position. To clear the Budget Name again, first delete the Budget Position No.
From now on, posted costs of the work order, for example from work order feedback or purchase invoices, appear in the cost columns of the position, such as Total Costs. maintool always calculates these columns automatically.
Calculate planned work order lines
With this function, the budget shows which costs from the planning lines of the assigned work orders are still outstanding.
- Search for Work Order Budgets, select the budget and choose Edit Budget.
- Use personalization to show the columns you need, for example Total Costs (Planning), Material Costs (Planning), Resource Costs (Planning), Resource Group Costs (Planning) and External Service Costs (Planning). They are hidden by default.
- Choose Related > Function > Calculate planned Work Order Lines.
Which lines count
maintool includes all lines of work orders assigned to the budget if
- the work order is neither closed nor canceled (the statuses Closed and Canceled do not count, see Cancel a work order),
- the line still has an Outstanding Quantity, that is, it has not been completely reported yet,
- there is no purchase order for the line. Ordered lines appear via Calculate ordered External Service instead (see below), provided they are external services.
For each line, only the part that is still open counts, the Outstanding Amount: the Line Amount in proportion to the Outstanding Quantity. A partially reported line remains in the planning with its remainder. Whatever has already been posted is shown in the cost columns. How the outstanding quantity comes about is described in Enter planning lines.
View the planned lines in detail
Click an amount in a column with the suffix (Planning). The Planned Work Order Lines page shows the lines that make up the amount, with Work Order No., Line No., Type, No., Description, Quantity, Outstanding Quantity, Unit Cost, Line Amount, Outstanding Amount and Execution Date. With Work Order Card, you open the work order of the selected line.
Calculate ordered external services
Ordered external services are costs that are already fixed but have not yet been posted as costs to the work order.
- Open the budget with Edit Budget.
- Choose Related > Function > Calculate ordered External Service.
The result appears in the Ordered External Service column. maintool includes purchase order lines
- that contain an item of the type Service, that is, an external service item,
- that are assigned to a work order which belongs to the budget and has a budget position.
For each line, the quantity not yet invoiced multiplied by the Unit Cost (LCY) counts. Received external services therefore remain in this column until the invoice is posted. How to order and post external services is described in Plan and post external services in a work order.
Click an amount in the Ordered External Service column to see the purchase order lines, with Document No., Buy-from Vendor No., No., Description, Quantity, Unit Cost (LCY), Unit Amount (LCY) and Order Date.
Calculate automatically
Instead of running the two functions each time, you can switch on the calculation per budget:
- Search for Work Order Budgets.
- In the line of the budget, switch on Planned Work Order Lines automaticly calculate and/or Ordered External Services automaticly calculate.
maintool then calculates the values each time you open the budget or select a different Budget Name on the budget page.
Result
- The cost columns show what has been posted to the work orders of the position.
- The columns with the suffix (Planning) show what is still to come according to the planning lines.
- Ordered External Service shows open purchase orders for external services. They are included in Difference and Available.
How each column is calculated is described in Budget columns and calculations.
The results of Calculate planned Work Order Lines and Calculate ordered External Service only apply as long as the budget page is open. If work orders or purchase orders change in the meantime, run the function again. If the budget, the budget position or the parent budget is blocked, nothing can be posted to the work order; maintool then reports, for example, … must not be blocked.
Available from version 20260900.2: Planned work order lines only count with their Outstanding Amount, closed and canceled work orders no longer count, and the Planned Work Order Lines page shows the Outstanding Quantity and Outstanding Amount columns as well as the Type as text.
Related articles
- Budgets – overview
- Budget columns and calculations
- Enter planning lines
- Plan and post external services in a work order
Related to