Set up the work order dimension setup

  • Updated

The Work Order Dimension Setup specifies with which dimensions, for example cost center and cost object, maintool provides each posting to the general ledger. This lets you control, for example, that the expense carries the cost center of the work order while the inventory account is posted without a cost center. Standard Business Central has no comparable setup.

Prerequisites

  • The lines of the Work Order Posting Setup exist. See Set up the work order posting setup.
  • For fixed dimension values, the dimensions and dimension values exist in Business Central.

Set up the dimension setup

  1. In the Work Order Posting Setup, select a line and choose Dimension Setup. The page opens filtered to this combination. You can also reach the page via search or via Dimension Setup on the Work Order Posting Groups page.
  2. Create a line with Work Order Posting Group and Product Posting Group. Leave Capitalization off for normal work orders.
  3. If you also post capitalized work orders with this combination, create a second line with Capitalization turned on. There are at most these two lines per combination.
  4. In each column that belongs to a posted account, select where the dimensions come from (see the tables below).
  5. For Default Code: choose the button in the field. The Work Order Dimension Default Values page opens. Enter the Dimension Code and the Dimension Value Code for each dimension.
  6. If you use Expected Cost Posting to G/L, turn on Show All Dimension Postings and also fill in the interim columns.

Options

Option Effect Typical use
No Code Posting is done without dimensions. Balance sheet accounts such as the inventory account
Work Order Value Entry The dimensions come from the work order value entry, that is, from the posting to the work order. Expense accounts, for example spare part consumption of a maintenance order
Default Code Posting is done with fixed dimension values that you specify on the Work Order Dimension Default Values page. Fixed cost center for a clearing account
Resource Card The dimensions come from the default dimensions of the resource. Only available in the columns for resources and capitalized accounts. Internal cost allocation: debit with the cost center of the work order, credit to the cost center of the employees

If you change a column from Default Code to another option, maintool deletes the default values specified there.

Columns and related accounts

Each column belongs to an account that maintool posts. Fill in the column whenever the related account is posted for this combination.

Column Applies to the posting to Required for
Work Order Account Posting the account in the Account No. field of the work order capitalized work orders and work orders with an Account No.
Inventory Account Posting the inventory account from the Inventory Posting Setup inventory items
COGS Account Posting COGS Account inventory items
Non-Inventory Item Consumption Posting, Non-Inventory Item Adjustement Posting Non-Inventory Item Consumption Account, Non-Inventory Item Adjustment Account non-inventory items
External Service Expense Account Posting External Service Expense Account external services
External Service Direct Cost Applied Account Posting the direct cost applied account from the General Posting Setup (balancing entry of the external service) external services, also on capitalized work orders
Resource Consumption Account Posting, Resource Adjustment Account Posting Resource Consumption Account, Resource Adjmt. Account resources with Posting Resource Costs to G/L
Capitalized Services Account Posting Capitalized Services resources on capitalized work orders
Capitalized Indirect Costs Account Posting Capitalized Indirect Costs capitalized work orders with an Overhead Rate % (Capitalization)

With Show All Dimension Postings, you also see the interim columns for Expected Cost Posting to G/L: Inventory Account Posting (Interim), COGS Account Posting (Interim), External Service Expense Account Posting (Interim), External Service Direct Cost Applied Account Posting (Interim) and Capitalized Indirect Costs Account Posting (Interim).

maintool uses the expense columns (COGS Account Posting, Non-Inventory Item Consumption Posting, External Service Expense Account Posting, Resource Consumption Account Posting) for work orders without Capitalization and without an Account No.; for the other work orders, Work Order Account Posting applies to the expense. Exception: with Accounting Reservation if Capitalized, maintool additionally posts resources of capitalized work orders to the resource consumption and resource adjustment accounts.

The postings to the Detail Consumption Account, the Detail Adjmt. Account and the Work Order Rounding Account are not controlled by the dimension setup: they always carry the dimensions of the work order value entry.

An empty column causes an error when posting as soon as the related account is posted. The posting also stops if no default values are specified for Default Code or if the line for the matching Capitalization is missing. Only set up the combinations and columns you really need: then missing setups or changed product posting groups become apparent at the latest when posting instead of resulting in incorrect postings unnoticed.

Related articles

Was this article helpful?

0 out of 0 found this helpful

Have more questions? Submit a request