Should Inventory Transactions of Expense Type Subinventory Create Accounting Entries? (文档 ID 1279111.1)

In this Document

Goal

Solution

APPLIES TO:

Oracle Cost Management - Version 11.5 and later
Oracle Inventory Management - Version 11.5.1 and later
Information in this document applies to any platform.

GOAL

Should inventory transactions of Expense type subinventories create accounting entries? What table drives the costing of Inventory Transactions?

SOLUTION

Expense type subinventories are not meant to create accounting entries, only Asset type are
If you do a subinventory transfer for an asset item, check both the from and to subinventories at the time of costing. If both are set as expense subinventory (2) at that point of time, then there is not accounting.

If either one is not an expense subinventory but Asset (1) , then accounting will occur.

The table that drives this behavior is:
MTL_SECONDARY_INVENTORIES. The ASSET_INVENTORY column (flag) can display values as explained below:

Type of Subinventory	Value	Meaning in Accounting Terms
Asset	1	Yes, accounting occurs
Expense	2	No, accounting does not occur

Run this query to determine your specific subinventory asset inventory flag setup:

											select asset_inventory from mtl_secondary_inventories 

where secondary_inventory_name = '&sub_inv_name' and organization_id = '&org_id';