For consumption and costs from work order management to arrive correctly in the general ledger, four setups work together in Business Central: two from standard Business Central and two from maintool. This article explains how they relate, which terms you should know, and in which order you set them up.
Prerequisites
- The chart of accounts with all required G/L and balance sheet accounts exists in Business Central.
- The account assignment has been agreed with your accounting department or your Business Central partner.
The four setups
| Setup | Origin | Role when posting from maintool |
| General Posting Setup | Business Central | Accounts per general business posting group and general product posting group. For work orders mainly used for purchasing, for example the balancing account for external services. |
| Inventory Posting Setup | Business Central | Inventory account per location and inventory posting group. Credited when inventory items are consumed on a work order. |
| Work Order Posting Setup | maintool | Accounts per work order posting group and product posting group, for example the COGS account, the external service expense account and the resource consumption account. |
| Work Order Dimension Setup | maintool | Specifies for each account which dimensions (for example cost center) are posted, separately for work orders with and without capitalization. |
Basic terms
- General business posting group: assigned to customers and vendors and distinguishes, for example, domestic, EU and foreign transactions.
- General product posting group: assigned to items and resources and distinguishes product types such as spare parts, own services and external services. maintool takes it from the item or resource when posting.
- Inventory posting group: assigned to the item and determines the inventory account together with the location.
- Work order posting group: assigned to the work order on the Accounting FastTab and plays the role of the general business posting group in work order management, for example Maintenance, Repair or Investment. You create the groups on the Work Order Posting Groups page. New work orders get the work order posting group from the Work Order Management Setup or from the work order category.
- Capitalization: switch on the work order for capital investment orders. Capitalized work orders post their costs to the account in the Account No. field of the work order instead of the expense accounts of the posting setup.
When maintool posts to the general ledger
Every posting to a work order creates work order value entries. They are posted to the general ledger immediately if Automatic Cost Posting is turned on in the Work Order Management Setup (General FastTab), otherwise with the Post Work Order Cost to G/L report. Inventory items and external services are always posted. maintool only posts the following costs if the related switch is turned on in the Work Order Management Setup:
- Non-inventory items: Posting Non-Inventory Item Costs to G/L
- Resources: Posting Resource Costs to G/L
- Costs per technical object: Posting Detail Costs to G/L
With Expected Cost Posting to G/L (Purchase FastTab), maintool additionally posts to interim accounts for receipts.
Recommended order
- Plan the account assignment: business transactions, product posting groups, accounts and work order posting groups. See Plan account assignment: business transactions and posting groups.
- Create general business and product posting groups in Business Central, assign them to customers, vendors, items and resources, and set up the General Posting Setup.
- For inventory items, set up the inventory posting groups and the Inventory Posting Setup.
- Create the work order posting groups. See Create work order posting groups.
- Set up the Work Order Posting Setup. See Set up the work order posting setup.
- Set up the Work Order Dimension Setup. See Set up the work order dimension setup.
- Check the source codes. See Source codes for work order management.
If the account assignment changes, update it in the General Posting Setup and in the Work Order Posting Setup. If a combination required for a posting is missing in the work order posting setup or in the dimension setup, maintool stops the posting with an error message.
Articles on financial accounting
- Plan account assignment: business transactions and posting groups
- Create work order posting groups
- Set up the work order posting setup
- Set up the work order dimension setup
- Source codes for work order management
- Post work order cost to G/L
- Transfer of a work order
- Reclassify and readjust postings
More information from Microsoft
Related to