Concepts

Tasks

Settings

Inventory Accounts

There are two accounting settings that control how inventory offset accounts are derived: inventory offset account derivation, and the resource-specific offset account derivation for inventory. These settings are entered at the enterprise level and are the same for all sites.

•	GL account derivation for inventory: this setting controls how inventory offset accounts are derived. You can use any of the following for inventory offset accounts:

•	The warehouse’s whole account number

•	The resource category’s whole account number (from the category of the resource used in the transaction)

•	A derived account number created by combining an account number from the warehouse and category segments.

If you choose “None” for both of these settings, APM will not record an offset account on inventory transactions.

For example, you could choose to combine segments using Warehouse for the first part, and Category for the second part. If a user creates a material issue from Warehouse 1, the offset account is derived as follows:

Transaction	Part 1: Warehouse	Part 2: Resource category (from Resource)	Derived Offset Account
Material issue	Warehouse 1 GL account segment: 3001 -	Material: Regulator Resource category: Valves - Control GL account segment: 9090	3001 - 9090

 

•	Resource-specific GL account derivation for inventory: this setting controls whether users can override the derived inventory offset account on individual resources (GL Account Derivation tab, Inventory Accounts tab). When the derived account is overridden, users can select:

•	A whole account number (Resource account)

•	A segment to combine with the site’s inventory account segment (set in the site’s Properties dialog). The segment can be either the first part or the second part of the derived account number.

If the first part is set to “None”, the offset account cannot be overridden on resources.

For example, you could choose to combine segments using Site account segment for the first part, and Resource account segment for the second part. If a user creates a material issue for a resource with an override, the inventory offset account is derived as follows:

Transaction	Part 1: Site account segment	Part 2: Resource account segment	Derived Offset Account
Material issue	Site 1 Site inventory account segment: 5001 -	Material: Regulator Resource account segment: 9095	5001 - 9095

In addition, there are some special purpose accounts that are used in inventory transactions:

Consignment Account

The Consignment Usage Not Invoiced account (CNI), is used as the offset account on consignment issues. This account is similar to the purchasing account Received Not Invoiced (RNI). If necessary, you can use the same account for both purchasing receipts and consignment issues. Simply identify the same account for both uses. You must select a whole GL account number.

Serialized Inventory Account

The Holding Account for Serialized Units is used to hold the value of issued units:

•	When a serialized unit is issued, the GL account to charge is set to the Holding Account for Serialized Units account.

•	When the serialized unit is returned to inventory, the GL account to credit is set to the Holding Account for Serialized Units account.

The Holding Account for Serialized Units account overrides the account that would normally be derived based on the work order task, asset, and cost type. This account must be a whole account number.

Tools Account

The Offset Account for Tools Usage Transactions is used to hold the value of issued tools as follows:

•	When a tool is issued, the GL account to charge is set to the Offset Account for Tools Usage Transactions account.

•	When the tool is returned to inventory, the GL account to credit is set to the Offset Account for Tools Usage Transactions account.

The Offset Account for Tools Usage Transactions account overrides the account that would normally be derived based on the work order task, asset, and cost type. This account must be a whole account number.

See Selecting Site and Special Accounts.