Before you create the posting setup for work order management, agree with your accounting department which business transactions are to be posted to which accounts. This article helps you build a planning table step by step: from the business transactions to the product posting groups and accounts to the work order posting groups.
The principle
The Work Order Posting Setup works like the General Posting Setup in Business Central. Each line is a combination of two groups:
- the work order posting group of the work order, which stands for the type of work order, for example maintenance or repair, and
- the product posting group of the item or resource, which maintool takes over when posting.
For each combination, you specify the accounts. The Work Order Dimension Setup uses the same combinations and additionally determines which dimensions are posted.
Step 1: Collect business transactions
List which costs in your maintenance department are posted to work orders:
| Business transaction | What is posted |
| Consumption of inventory items | Spare and wear parts consumed via the Work Order Journal or a work order feedback. Inventory decreases, the costs go to an expense account. |
| Consumption of non-inventory items | Items without inventory, for example small material. Only posted to the general ledger if Posting Non-Inventory Item Costs to G/L is turned on. |
| Own services | Hours of resources, that is, persons or machines. Only posted to the general ledger if Posting Resource Costs to G/L is turned on. |
| External services | Services from external companies that are purchased as items of the type Service. G/L accounts cannot be planned in the work order; therefore, you set up external services as items. |
| Capital investment orders | Work orders with Capitalization whose costs go to a balance sheet account such as assets under construction. Optionally with capitalized services and capitalized indirect costs. |
| Other expenses | Postings from the General Journal with the account type Work Order. |
Step 2: Determine product posting groups
- Items: Review the items you want to use in maintool and note their product posting groups. In the simplest case, there is one group for spare and wear parts.
- Resources: Create product posting groups for the resources if none exist yet. Often one group for your own staff and one for machines is enough.
- External services: If you have so far posted external services directly to G/L accounts, use the chart of accounts to determine which accounts are used for this. From this, you derive the product posting groups of the external service items.
Step 3: Specify accounts
For each business transaction and each product posting group, specify which account is to be posted. This results in a matrix, for example:
| Type of work order | Product posting group | Expense account |
| Maintenance | Spare parts | 4711 |
| Repair | Spare parts | 4712 |
| Overhaul | Spare parts | 4713 |
Tips for the individual business transactions:
- Own services: A consumption account and an adjustment account as balancing account are posted. Often clearing accounts are needed for this that do not yet exist in the chart of accounts. If you use the same account for both, its balance is always zero; the G/L entries then only show with which cost center the posting was made.
- Capital investment orders: The balance sheet account, for example assets under construction, is entered on the work order in the Account No. field. In the posting setup, you need the accounts for capitalized services and, if you work with an Overhead Rate % (Capitalization) on items, resources or G/L accounts, for capitalized indirect costs. maintool does not post to fixed assets; you transfer the collected costs to the fixed asset yourself later.
Step 4: Derive work order posting groups
From the combinations, you derive the work order posting groups. You need one group for each type of work order that posts to its own accounts, for example:
-
WARTfor maintenance -
REPfor repairs -
REVfor overhauls -
INVfor capital investment orders
For capital investment orders, at least one separate group is recommended. How many you need depends on how many different accounts for capitalized services and capitalized indirect costs you use.
If your chart of accounts distinguishes external services by type of work order, for example maintenance and repair, there are two ways:
- separate product posting groups and therefore separate external service items, for example "External service maintenance" and "External service repair", or
- several work order posting groups that transfer the general business posting group to purchasing (see Create work order posting groups).
Result
You have a planning table with all combinations of work order posting group and product posting group and the related accounts. With it, you next create the work order posting groups and the setups.
Related articles
- Posting setup – overview
- Create work order posting groups
- Set up the work order posting setup
- Set up external service items
Related to