This chapter covers the following topics:
First In, First Out (FIFO) and Last In, First Out (LIFO) are two separate perpetual costing methods based on actual costs. These methods are also referred to as layer costing. A perpetual costing method is selected for each inventory organization including Standard costing, Weighted Average costing, FIFO costing, or LIFO costing. Inventory balances and values are updated perpetually after each transaction is sequentially costed.
FIFO costing is based on the assumption that the first inventory units acquired are the first units used. LIFO costing is based on the assumption that the last inventory units acquired are the first units used. Layer costing methods are additional costing methods to complement the Standard and Weighted Average costing methods.
In layer costing, a layer is the quantity of an asset item received or grouped together in inventory and sharing the same costs. Available inventories are made of identifiable cost layers.
Inventory layer
On-hand inventory contains layers that are receipt-based (purchased items) or completion-based (manufactured items).
Work in Process (WIP) layer
Components issued to a WIP job are maintained in layers within the job itself. Each issue to WIP represents a separate layer within the job. In addition, each WIP layer consists of only one inventory layer initially consumed by the issue transaction. The costs of those inventory layers are held separately within the WIP layer.
FIFO/LIFO costing is processed at the inventory organizational level. Under FIFO/LIFO cost systems, the unit cost of an item is the value of one receipt in one layer, selected by the FIFO or the LIFO rule. Each receipt of material to inventory has its own unit cost. Each receipt of material is valued at the purchase order price. Each receipt or assembly completion creates either a new layer for each organization.
Layer creation is minimized for item and organization combinations. Layer creation transactions following a transaction for the same type, cost, and cost group for the same organization. Do not create single layers as in previous versions of Oracle Cost Management. The item quantity is added to the last layer created. New layers are created when the next transaction is of a different type, cost, or cost group.
Note: New layers are created for transactions where the cost is user-defined, rather than system calculated. This includes transactions that meet all the qualifying conditions and have an equal cost value.
Other features include:
If an organization is defined as a FIFO costing organization, all inventories of the organization are valued at FIFO. You cannot specify that some inventory items are costed at FIFO, while others are costed at standard or weighted-average, for example.
You can only specify only one cost flow assumption for an organization. All inventory items of an organization must be costed at FIFO or at LIFO. You cannot specify some items to be costed at FIFO and other items to be costed at LIFO.
FIFO/LIFO costing is based on purchase order prices. Neither invoices nor acquisition costs are considered when costing a receipt from a supplier.
For purchased items, each receipt creates a layer cost. For manufactured items, each completion creates a layer. All assemblies in that layer have the same unit cost.
Note: FIFO/LIFO costing cannot be applied to repetitively manufactured items. Therefore, you cannot define repetitive schedules in an organization that is defined as a manufacturing FIFO/LIFO cost organization.
This same FIFO/LIFO cost is used to value transactions. You can reconcile inventory and WIP balances to your accounting entries.
Note: Under layer costing, you cannot share costs; FIFO/LIFO costs are maintained separately in each inventory organization.
You can perpetually value inventory at a FIFO/LIFO cost. When an organization uses FIFO or LIFO costing methods, inventory costs are maintained in layers, each with its own costs. The cost flows of FIFO and LIFO are opposite.
In FIFO valuation, the earliest-received stock is assumed to be used first; the latest-received stock is assumed to be still on hand.
In LIFO valuation, the earliest-received stock is assumed to be still on hand; the latest-received stock is assumed to be used first.
FIFO/LIFO costing enables you to:
Approximate actual material costs
Value inventory and transact at layer cost
Maintain layer costs
Automatically interface with your general ledger
Reconcile inventory balances with general ledger
Analyze profit margins using an actual cost method
The first layer cost is cost of the first layer with a positive quantity. The layer item cost is the unit cost shared by the layer quantity. It is the average unit cost of a layer.
Layer Item Cost = layer’s acquisition cost / layer’s quantity
FIFO item cost is the weighted–average of all inventory layer costs divided by the sum of layer quantities.
For example:
Layer 1 LQ1 = 20 ea. | LC1 = $2/each |
Layer 2 LQ2 = 10 ea. | LC2 = $1.40/each |
FIFO Item cost = ($2*20 + $1.40*10) / (20+10) = $1.80
You can charge WIP resources at an actual rate. You can charge the same resource at different rates over time. You can also charge outside processing costs to a job at the purchase order unit cost.
Under layer costing, all asset purchased items in inventory are valued based on their purchase order cost. This results in item unit costs that reflect the layer of the purchase order unit costs for all quantity on-hand.
Elemental costs for manufactured items are kept at two levels: this level and previous level. This level costs are those costs incurred in producing the part at the current bill of material level. Previous level costs are those incurred at lower levels. This level costs might include labor and overhead supplied to bring an assembly to a certain state of completion. Previous level costs might include material and labor, and outside processing costs incurred to bring a component or subassembly to its current state of completion. Totals costs for an item are calculated by summing the this level and previous level costs as shown in the following table.
Costs in Dollars | Material | Material Overhead | Resource | Outside Processing | Overhead |
---|---|---|---|---|---|
Previous Level | 100 | 20 | 25 | 27 | 5 |
This Level | 0 | 2 | 3 | 3 | 1 |
Total Costs | 100 | 22 | 28 | 30 | 6 |
For tracking and analysis purposes, you can see cost details by cost element in two ways:
For unit costs, as a breakout of the total unit cost into each of the five cost elements. From this detail, you can determine the value of labor, overhead, and material components in inventory.
For WIP, as all job charges (including previous level subassemblies) and relief in cost element detail.
When you update layer costs, you update the layer regardless of the subinventory.
You can change costs by cost element and can choose one, several, or all cost elements at the same time. The offset to the change in inventory value resulting from a cost update is posted to the layer cost adjustment account that you specify. Items in WIP are not revalued by a layer cost update, nor are expense items or any item in an expense subinventory.
You can also perform a mass changes for multiple layers in a group for the cost, account number, and reason values.
You can add costs (receiving, stocking, material movement, and handling) using material overhead. You can define as many material overheads as required and include that additional cost be included in the layer cost.
Material overheads are associated to items in a layer. As in standard costing and in average costing, you can define default material overheads to apply to selected categories of items or all items in your organization.
Specifically, you can charge material overhead when you perform any of the following three transactions:
Deliver purchased items to subinventory
Complete assemblies from WIP to subinventory
Receive items being transferred from another organization and deliver to subinventory
Material overhead is applied at the rate or amount in effect at the time of the transaction. On-hand balances are not revalued when the rate or amount of a material overhead is redefined.
You can transfer items in inventory to a subinventory in a different organization. This is done using a direct transfer or through an intransit transfer, just as in standard costing and in average costing. Because item unit costs are held elementally, like standard costs, elemental detail is available for items being transferred whether they are in subinventory or in intransit.
When such an item is received into a layer costing organization and delivered to the destination subinventory, you can choose whether all of its cost elements from the shipping organization, plus freight, plus transfer charges, if any, are combined into the material cost element in the receiving organization or if they are to remain separate and elementally visible.
Note: Combining all cost elements into the material cost element assures that the receiving organization does not have another organization's overhead (over which they have no control and for which they have no absorption) combined with their own.
You can earn material overhead on the delivery as stated above. That amount goes into the material overhead cost element.
The transaction processor, which affects current on-hand quantities of items, can be set up to run either periodically (in the background) or on line (quantities updated immediately). Oracle strongly recommends that you set up the transaction processor to run on line. The cost processor is always run in the background at user-defined intervals.
You can backdate transactions. If you backdate transactions, the next time transactions are processed, the backdated transactions are processed first, before all other unprocessed transactions. Previously processed transactions, however, are not rolled back and reprocessed.
FIFO Costing is organization specific.
All items in inventory for an organization are valued at FIFO, when you specify FIFO as the primary costing method for the organization. You can still maintain other costing methods, such as standard or weighted-average for other inventory organizations. But each organization can have only one primary costing method.
You cannot share costs across organizations using FIFO costing.
You can specify the cost type that stores all your resource and overhead rates for FIFO costing as the rates cost type.
Receipts are valued at purchase order prices.
When you deliver a purchase order receipt to inventory, it is valued at the purchase order price. The costs to your inventory consist of the purchase order cost and any specified material overhead earned.
Inventory is maintained in receipt-based layers only.
Layer creation: Receipts into inventory create new layers with their own quantity and cost.
Layer consumption: Issues consume earliest layers that still have quantity balance. Issue transactions are costed based on the cost of the consumed layers.
You can specify the first inventory layer to be consumed, using the layer hook (client extension).
The return transactions (such as returns to vendor, WIP component returns, WIP assembly returns) are the exception to the FIFO flow.
Note: Layers are maintained only for the seeded FIFO or LIFO cost types. User-defined cost types do not have layer costs.
Layer creation is minimized for item and organization combinations.
Layer creation transactions following a transaction for the same type, cost, and cost group for the same organization - do not create a new layer as in previous versions of Oracle Cost Management. The item quantity is added to the last layer created. New layers are created when the next transaction is of a different type, cost, or cost group. The qualifying transactions include:
Return material authorizations
Miscellaneous receipts
Account receipt
Account alias receipt
Note: New layers are created for transactions where the cost is defined by the user, rather than calculated by the application. This includes transactions that meet all the qualifying conditions and have an equal cost value.
WIP components are held in layers within a job.
Component issues are held in layers within each job. Each issue creates a WIP layer. In addition, component issued to a job will not lose their inventory layer identification and costs.
Items are returned to inventory as new layers.
WIP component return
A new inventory layer is created when a component is returned to inventory from WIP. The return transaction is valued at the latest WIP layer costs. The last layers issued to a job at a specified operation are the first layers returned to inventory.
RMA receipts
A receipt of customer return also creates a new layer at the same cost as the original shipment. This new layer is created as a latest layer cost for LIFO without a sales order reference, an earliest positive layer cost for FIFO without a sales order reference, or an original sales order issue cost if the RMA has a sales order reference.
Returns to vendor are returned from inventory at original layers and layer costs.
Unlike most of the other issues from inventory, returns to vendor and assembly returns do not consume the earliest receipt layers. They are layer-identified transactions. In other words, they are issue transactions that have reference to specific layers.
Returns to vendor consume the layers created for the original receipts.
Assembly returns consume the layers created for the original completions.
Layers are maintained at the cost group level in Project Manufacturing.
Layers are maintained at the project cost group level within an inventory organization. Issues from a cost group consume the earliest layers within the cost group.
Note: Cost layers are not held at subinventory level.
Layer cost can be updated by the user.
At any given time during an open period, you can perform a cost update to revalue your inventory. You will have the option to update the costs of an item layer by a specified amount, a percent of the selected layer’s costs, or user -entered layer costs by cost element and level.
The cost update process calculates the adjustment values for your inventory layer cost, and creates corresponding adjustment accounting entries.
Note: Just as in average costing, you must specify the items to be updated. You cannot update all items or a range of items. You can update only a single receipt layer for any given item. You can update only one layer at a time.
Both FIFO item costs and layer costs are maintained at elemental levels.
Both the FIFO item cost and the layer costs are maintained at elemental levels and by cost groups.
The FIFO item costs, which is the weighted average of layer item costs, is used for current inquiries and reports, such as inventory by sub-inventory, by category, and so on. Functionality (such as copy cost, mass edits, cost rollup) also uses FIFO item costs in its process.
The layer costs are used to value the unconsumed inventory layers and to cost transactions based on FIFO cost flow.
Reports by layers are available.
Most standard reports that are currently available for average costing are also available for FIFO costing. In addition, you have reports at the layer level.
The following steps are required when setting up perpetual layer costing. Additional steps follow in the next section for those also using BOM alone, or WIP and BOM together.
Prerequisites
Set the costing method to FIFO Costing.
Set Transfer Detail to GL appropriately.
(Optional) Set the Default Material Subelement account.
Assign the user-defined cost type as the rates cost type.
To select FIFO costing, a perpetual cost method in Organization Parameters
Navigate to the Organization Parameters window, and open the Costing Information tab.
Enter the Costing Organization.
Enter FIFO as the Costing Method from the List of Values and select OK.
Enter the Rates Cost Type, previously created.
Set Transfer Detail to GL appropriately.
Optionally, specify a Default Material Subelement account.
To set up layer costing
Set the Control Level for your items to Organization. Layer cost cannot be shared between organizations.
Define, at minimum, one cost type to hold the layer rates or amounts for material overhead rates. Inventory valuation and transaction costing in a layer cost organization involve two cost types: Seeded: FIFO and User-Defined: Rates.
Assign the cost type defined above as the rates cost type in the Organization Parameters window in Oracle Inventory. See: Organization Parameters Window, Oracle Inventory User's Guide and Defining Costing Information, Oracle Inventory User's Guide.
Set the TP: INV:Transaction Processing Mode profile option in Oracle Inventory to On-line processing.
When using layer costing, transactions must be properly sequenced to ensure that the correct costs are used to value transactions so that unit costs can be accurately calculated. Proper transaction sequencing can only be ensured if all transaction processing occurs on line. See: Inventory Profile Options, Oracle Inventory User's Guide.
Transactions can be classified into two different types in the context of FIFO/LIFO costing:
Layer-identified transactions
These transactions identify specific layers. Identified layers can be new layers, like new purchase order receipt layers, or existing layers, like receipt layers specified for return to vendor transactions or for assembly returns. All receipt transactions are layer-identified transactions. Only a few issue transactions carry layer identification.
Layer-derived transactions
These transactions do not have layer identification. Most issues are layer-derived transactions; they do not consume layers created by specific transactions. Instead, they consume the oldest layers first for FIFO, and the most recent layers first for LIFO.
Receipts Into Inventory Create New Layers.
For both FIFO and LIFO cost methods, each receipt into stores creates a new receipt layer which is costed as follows:
Purchase order receipts are valued at purchase order price
Assembly completions are valued at job completion cost
Miscellaneous receipts, account receipts and user-defined transactions are valued at user-entered transaction cost, or latest receipt layer cost
Direct interorganization transfer and intransit receipt are valued at the transfer transaction cost
WIP component returns are valued at the job’s component costs
Each positive cycle count adjustment and each positive physical inventory adjustment is valued at the latest layer’s cost and creates a new layer
Positive receipt corrections are valued at purchase order price
Customer returns (RMA receive transaction) creates a new layer at the same cost as the original shipment. This new layer is created as a latest layer cost for LIFO without a sales order reference, an earliest positive layer cost for FIFO without a sales order reference, or an original sales order issue cost if the RMA has a sales order reference.
Receipt Into Inventory Replenishes Negative Layers.
If there are negative layers when the transaction is performed, then a receipt into inventory will also trigger the replenishment of the negative layers. Those layers will be replenished up to a zero balance, starting with the oldest negative layers for FIFO and the most recent layer first for LIFO.
Inventory layers are consumed when items are:
Issued to jobs
Transferred out of inventory, project cost group, or organization
Sold
Considered a loss, such as in cycle count adjustments or in physical count adjustments
Issues from inventory consume the oldest layers.
Oldest layers with positive balances are consumed by issue transactions. However, layer-identified transactions consume the specified layer first, then the oldest layers with positive quantity balances if there is insufficient quantity to be consumed from the specified layers.
Some of the layer-identified issue transactions are return to vendor, negative receipt correction, assembly return to WIP, and transactions using the layer hook (client extensions).
Consumption may drive the latest layer negative when the transaction is performed.
If there is insufficient quantity to consume, an issue transaction will drive the latest layer negative when the transaction is performed.
If the on-hand quantity is already negative, the latest layer is updated by the consumption quantity. There should be no layer with a positive quantity balance if negative layers exist for an item in a cost group.
The cost of inventory layer consumed does not always match the transaction cost.
Layer-identified transactions have their own transaction costs and consume the specified layer if it still has a positive quantity balance.
Return to Vendor (RTV) transactions, receiving correction transactions are valued at the purchase order price associated with the original receipt transactions. The sequence of a RTV (or receiving correction) layer consumption is as follows:
Consume the initial receipt layer first.
If there is insufficient quantity, consume the oldest layers with quantity balance.
The latest layer at time of transaction can be driven negative by the consumption.
Assembly Return to WIP transactions are valued at the job completion cost. (Also see WIP Layer Relief section.) The consumption sequence is similar to RTV transactions.
When a layer-identified issue transaction cannot consume the specified layer(s) because the layer quantity has already been consumed by other transactions, it will have to consume other layers that do not necessarily have the same costs. In such case, the difference between the cost of the transaction and the value of the layer(s) actually consumed is debited or credited to a variance account.
An under-costed transaction is an inventory transaction that incurs a negative variance. An over-costed transaction incurs a positive variance. You enter the variance account when defining costing information in organization parameters costing, or when defining cost groups.
A WIP Component Issue transaction creates a WIP layer and a corresponding WIP layer ID. Because components are issued to WIP at specific operations, WIP layers are maintained at the job operation level.
Each WIP layer consists of one inventory layer. Depending upon the number of inventory layers consumed by the issue transaction, the WIP layers are identified by the combination of WIP layer ID and the inventory layer IDs.
Quantity and costs are maintained separately for each inventory layer within a WIP layer.
If there are no previous issues to the job and no backflush transactions, the relieved cost of a component is computed using the cost of the earliest inventory layer with positive quantity at the time of transaction.
A WIP Component Return will move back to inventory the latest WIP layers at the specified operation. However, this transaction will create a new layer in inventory. It will not ”unconsume” the inventory layer(s) previously consumed by the initial Component Issue transaction.
At assembly completion, relieved material costs are computed using the earliest inventory layers’ costs within a WIP layer that are still available to be relieved. WIP layers at each operation are relieved on the FIFO basis.
A scrap transaction should relieve WIP layers in the FIFO manner as an assembly completion.
An assembly return should trigger an adjustment to the WIP layer quantity, and the cost relieved should initially be the assembly completion.
Note: The component cost computation for assembly completions uses the same algorithm as for average costing.
Defining bills of material parameters ensures that bill and routing information (resource, outside processing, and overhead cost elements) is accessible when you define item costs and define overhead.
Define resource subelements by creating resources, departments, bills, and routings with Bills of Material.
Resources can be costed or not costed. Because you can have multiple resources per operation, you can use a non-costed resource for scheduling and a costed resource for costing. The cost update process and accounting transaction processing ignore uncosted resources.
For each resource, the charge type determines whether the resource is for internal (labor, machine, and such) or outside processing. Use PO Move and PO Receipt charge types for outside processing. Each resource has its own absorption account and variance account.
For capacity planning and overhead assignment purposes, you must assign each resource to one or more departments. Once you assign a resource, you can select that resource when you define a routing.
The cost processor uses the assigned basis type to apply the overhead charge and assigns the activity to the calculated overhead cost. You can define pending rates and use the cost update process to specify the pending rates as the rates cost type.
For overheads based on resource units or resource value, you must specify the resources on which the overhead is based. You can then charge multiple resources in the same department for the same operation, while still earning separate overhead for each resource. If you do not associate your overheads and resources, you do not apply overhead or charge resource-based overhead in WIP.
If you use the same account numbers for different valuation and variance accounts, then Cost Management automatically maintains your inventory and WIP values by cost element. Even if you use the same cost element account for inventory or a WIP accounting class, Oracle recommends that you use different accounts for each and never share account numbers between subinventories and WIP accounting classes. If you do, you will have difficulty reconciling Inventory and Work in Process valuation reports to your account balances.
To set up layer costing with BOM and WIP
In addition to setting the TP: INV:Transaction Processing Mode profile option in Oracle Inventory to On-line processing. See: Inventory Profile Options, Oracle Inventory User's Guide.
You must also set the following WIP transaction processing profile options to On-line:
TP:WIP:Completion Transactions Form
TP:WIP:Material Transactions Form
TP:WIP:Move Transaction
TP:WIP:Operation Backflush Setup
TP:WIP:Shop Floor Material Processing
See: Profile Options, Oracle Work in Process User's Guide.
Define rates for your resources and associate these resources and rates with the Rates cost type. See: Defining a Resource, Oracle Bills of Material User's Guide.
Unlike under standard costing, charging a resource defined as a Standard rate resource does not create rate variances. For each resource the charge type determines whether the resource is for internal (labor, machine, etc.) or outside processing. Use PO Move and PO Receipt charge types for outside processing. Each resource has its own absorption account and variance account.
Define overheads and assign to departments. See: Defining Overhead.
For each overhead subelement, define a rate of amount in the cost type you have specified as the rates cost type. Overheads with a basis type of Resource Units or Resource Value use the actual transaction resource amount or hours to calculate the overhead amount. The cost processor uses the assigned basis type to apply the overhead charge and assigns the activity to the calculated overhead cost. You can define pending rates and use the cost update process to specify the pending rate as the rates cost type.
Define WIP parameters. See: Defining WIP Parameters, Oracle Work in Process User's Guide.
You can use the Require Scrap Account parameter to determine whether a scrap account is mandatory when you move assemblies into a scrap intraoperation step. Requiring a scrap account relieves scrap from the job or schedule. Not requiring a scrap account leaves the cost of scrap in the job or schedule.
If the Require Scrap Account is set to No, scrap costs remain in the job. See: the following sections from Oracle Work in Process User's Guide: WIP Parameters, Assembly Scrap, and Scrapping Assemblies.
You must set the appropriate layer costing parameters - Default Completion Cost Source, Cost Type, Auto Compute Final Completion, and System Option - to determine how completions are charged.
How these parameters are applied is explained in the Assembly Completion Transaction and Resource Transaction sections.
Define WIP accounting classes. See: WIP Accounting Classes, Oracle Work in Process User's Guide and Defining WIP Accounting Classes, Oracle Work in Process User's Guide.
Accounting classes determine which valuation and variance accounts are charged and when. You can define the following elemental accounts for WIP accounting classes that are used with layer costing: material, material overhead, resource, outside processing, overhead, material variance, resource variance, outside processing variance, overhead variance, bridging, and expense accounts. See: WIP Valuation and Variances, Oracle Work in Process User's Guide.
Note: If you use the same account numbers for different valuation and variance accounts, then Cost Management automatically maintains your inventory and WIP values by cost element even if you use the same cost element account in a given subinventory or WIP accounting class. Oracle recommends you use different accounts for each and never share account numbers between subinventories and WIP accounting classes. If you do, you will have difficulty reconciling Inventory and WIP valuation reports to your account balances.
Define subinventories and subinventory valuation accounts.
The five Valuation accounts and the default Expense account are defined at the organization level. The valuation accounts apply to each subinventory and intransit within the organization. They cannot be changed at the subinventory level under layer costing. The expense account defaults to each subinventory within the organization and can be overridden. You can choose a different valuation account for each cost element, or use the same account for several or all elements.
How you set up your accounts determines the level of elemental detail in the General Ledger and on Inventory valuation reports. See: Defining Subinventories, Oracle Inventory User's Guide.
The following sections discuss transaction flows that occur when transacting jobs in a layer costing organization:
Labor charges
Overhead charges
Component issues
Material overhead charges
Scrap charges
Assembly completions
Assembly returns
Job closures and cancellations
Layer cost update
You can charge person-type resources to jobs either at a predefined labor rate or at the actual labor rate. If you choose to charge labor at the predefined rate, move transactions that complete an operation automatically charge WIP Move resources associated with that operation at the resource's rate, as defined as the rates cost type. Resource rates are associated with cost types when you define resources. If you choose to charge labor at an actual employee rate, you can enter an employee rate as you charge manual resources. You can charge labor at either an actual or a predefined rate if you choose to import resource transaction through the Open Resource Cost Interface.
You can charge a predetermined number of labor hours by adding a WIP Move resource to a routing operation, or you can charge the actual hours to a manual resource by either:
Entering the actual hours as assemblies are moved
Entering the actual hours as part of an independent resource transaction
Importing resource transactions through the WIP Resource Cost Transaction Interface
Resource labor transactions are valued at the rate in effect at the time of the transaction. As a result, when the same labor subelement or employee is charged to the same job at different times, different rates may be in effect.
For each overhead subelement, define a rate or amount in the cost type that you have specified as the rates cost type. Overheads with a basis type of resource units or resource value use the actual transaction resource amount or hours to calculate the overhead amount. See: Defining Overhead.
Component items can be defined as push or pull requirements on your jobs. Components issued to jobs are valued at the inventory layer cost in effect at the time of the transaction. Components issued to a job in several different transactions may have different unit costs for each transaction. If a component's unit cost is composed of more than one cost element, then this elemental detail continues to be visible after it is charged to a job. These costs are held and relieved as previous level costs.
Define as many material overhead subelements as desired and base their charging in a variety of ways: by item, by activity or lot, or based on transaction value. See: Defining Overhead.
When defining item costs, you can associate material overhead(s) to items and define the rate / amount manually using the rates cost type. Once defined, the material overhead(s) are applied whenever the particular item is involved in an applicable transaction. You can change these overheads at any time. Making a change affects future transactions, but has no impact on the FIFO unit cost in inventory. See: Defining Item Costs.
For purchase order receipts and transfers between organizations, the material overhead amount earned is added to the purchase order cost / transfer cost of the item (but held as a separate cost element) when it is delivered to inventory. For assembly completions, the material overhead amount earned is added to the cost of the completion in inventory, but is never charged to the job.
For ease in assigning material overheads to items, you may choose to default them when an item is first defined rather than manually associating them item by item. You default material overhead in layer costing the same as in standard costing. You can create defaults to apply at the organization level or at an item category level. Within either of these, you can choose the default to apply to make or buy items only, or to all items.
If you define more than one rate or amount for the same material overhead subelement, the order of priority is category level make or buy items, category level all items, organization level make or buy items, and organization level all items, with the higher priority rate/amount taking precedence and overriding any other. If you want to apply more than one material overhead, then you must use different subelements. When you change material overhead defaults, the change that you make applies only to items defined later; there is no impact to existing items. See: Defining Material Overhead Defaults.
The WIP Require Scrap Account parameter determines how assembly scrap is handled. If you enter a scrap account as you move assemblies into scrap, then the transaction is costed by an algorithm that calculates the cost of each assembly through the operation at which the scrap occurred. The scrap account is debited, and the job elemental accounts are credited. If you do not enter a scrap account, the cost of scrap remains in the job. If the job is then completed using the final completion option in the Completion Transactions window, the cost is included in the finished assembly cost. Otherwise, the cost is written off as a variance when the nonstandard asset and standard discrete jobs are closed and when nonstandard expense jobs are closed for the period.
If you enter a scrap account as you move assemblies out of a scrap intraoperation step, the above accounting transactions are reversed.
When finished assemblies are completed from a job to inventory, they are costed in System Calculated - Actual Resources.
You set the default for the Completion Cost Source through the Default Completion Cost Source parameter in the WIP Parameters window.
These parameters are the defaults in the WIP Accounting Class window as you define standard and non-standard discrete accounting classes.
If you choose System Calculated, then you must choose the system option, Use Actual Resources because Use Pre-defined Resources is not available. The system option determines how the applicaton calculates costs.
If you choose User Defined, then you must choose a cost type.
If you choose System Calculated, then you can override the Default Completion Cost Source parameter.
If you choose System calculated, then select a system option. If you select Use Actual Resources, then the unit cost to be relieved from the job is calculated based on actual job charges and is charged to inventory as each unit is completed. This algorithm costs the completions using a prorated amount of actual resources charged to the job and material usages as defined on the assembly bill, multiplied by the layer costs in the job.
Note: For completions out of a nonstandard job having no routing, this algorithm selects the unit cost from the Layer cost type. This method works best for jobs that have resources charged in a timely manner.
Job assemblies completed in the same transaction have the same layer unit cost.
As part of a completion transaction, the unit cost of the assembly in inventory is recalculated when it is different from the unit cost used in the completion transaction.
If you have overcompleted a job, then it is not necessary to change the job quantity.
The Final Completion option check box in the WIP Assembly Completion window allows an additional costing option for the assemblies currently being completed:
Enabled: Costs these assemblies by taking the current job balances and spreading them evenly over the assembly units being completed or taking them to variance.
Disabled : Costs these assemblies according the Completion Cost Source method set.
Final completions ensure that no positive or negative residual balances are left in the job after the current assembly has been completed.
Note: Use of the final completion option is unrelated to whether or not this is the last completion of the job.
The WIP Auto Compute Final Completion parameter setting determines whether the Final Completion option check box defaults to selected (enabled) or clear (disabled).
Note: When the last assembly in a job is a scrap, a residual balance may remain in the job, regardless of how you have chosen to deal with assembly scrap (see Assembly Scrap paragraph above), because the above routine for clearing the job balance is not invoked.
If you return completed assemblies back to a job, then the assemblies being returned are valued at the layer cost of all completions in this job (net of any prior completion reversals), if the completion cost source is System Calculated and the Use Actual Resources option. If the completion cost source is User-defined, then the assembly is returned at User-defined costs.
Define variance accounts for each standard and non-standard discrete WIP accounting class. Any balance remaining in a job after it has been closed is written off elementally to these accounts.
Just prior to job closure, either all costs in the job have been relieved, leaving a zero balance, or a balance will be left in the job. If the job was completed, all units required were either completed or rejected / scrapped. If you used the Final Completion option, then the job balance is zero. The final units completed have absorbed all remaining job costs into their value.
However if the job balance is not zero, it is written off to the elemental variance accounts defined for the job's WIP accounting class. A residual job balance may remain under the following conditions:
On the element by level, the job was over-relieved, resulting in a negative net activity for that element by level in the WIP Value Summary.
All assemblies were completed, but the final completion was not used.
A late transaction was posted after the completions.
The job was cancelled and closed short (not all assemblies were completed / rejected).
The elemental account for the job's WIP accounting class should be different from the Cost Variance account.
Define this account in organization parameters. All variances occurring in any subinventory within an organization are charged to the same account. This account is charged if you choose to allow negative quantities in inventory or a transaction results in a negative amount in inventory for one or more cost elements of an item.
You can enter a transaction unit cost when performing a Miscellaneous Issue transaction. Because entering a cost that is significantly different from the layer can cause large swings in the unit cost of remaining on-hand inventory, you should not allow the cost to be entered.
You can manually change the layer cost of an item by performing an Layer Cost Update transaction. The Update Layer Cost window is used to enter cost transaction information for inventory layers. You first select to display the appropriate transaction records. You can perform a mass change for multiple layers in a group including cost, account number, and reason values.
Note: You should perform layer cost updates only to correct transaction costing errors that affect items in subinventory. If the cost error originates from a WIP issue transaction, then the impacted quantities must be returned to a subinventory, corrected there, then reissued to WIP after the update is completed.
You can directly update each layer cost of an item to include additional costs such as freight, invoice price variances, or job variances. You can update cost elements individually, or you can update to the total cost. You can also perform a mass edit for multiple layers in a group. You can change costs by updating one of the following values in your record. These changes can be updated for a specific record, or for the total (which is proportioned across all cost elements and levels).
Layer cost update transactions are inserted into the Transaction Open Interface in Oracle Inventory. Transaction details are viewed in the Create Transaction tabbed region.
See: Oracle Inventory Open Interfaces, Oracle Manufacturing, Distribution, Sales and Service Open Interfaces Manual.
To search for records for layer cost updates
Navigate to the Update Layer Cost window.
The Update Layer Cost search window displays for entering criteria.
In the Update Transaction Region, select a transaction date within any open period.
Select Layer Cost Update in the Type field.
Optionally, you can enter a Source type to describe the origins for transactions.
Select an expense account in the Adjustment Acct field.
In the Item region, select the item for the layer cost update.
The description, unit of measure, and cost group information defaults.
If the Project References Enabled and Project Cost Collection Enabled parameters are set in the Organization Parameters window in Oracle Inventory, you can select a cost group. See: Organization Parameters Window, Oracle Inventory User's Guide. If these parameters are not set, the organization’s default cost group is used.
Optionally, you can filter your search by selecting information in the Inventory Layer region. Select a value in the Create Transaction Type field for the transaction creating the inventory layer.
Select a value in the Transaction Source Type field for the type of transaction that created the inventory layer.
If you have a value in the Transaction Source Type field, then you can select a value in the Create Transaction Source field. This indicates the source of the transaction that created the inventory layer.
In the Create Transaction Date field, you can select a specific transaction date.
If you are searching for specific layers, then select a number or range of numbers in the Layer Number field.
The layer number comes from a layer belonging to the cost group and having positive layer quantity balance.
Choose Continue to display the results of your search on the Layer Cost Update Transactions window. Or choose Clear to remove the data entry to perform a new search.
The Layer Cost Update Transactions window has four tabbed regions for viewing and updating information:
Cost Change
Accounts
Comments
Create Transaction
To update a specific layer cost
Select the Cost Change tabbed region.
Information for your search results display in the Layer Number, Layer Quantity, Create Quantity, and Layer Cost fields.
Enter a value in one of the cost fields for that record.
New Layer Cost: Enter the new cost. The cost element and level, and the new total unit cost are automatically calculated when you save your work. Onhand inventory in all subinventories in the cost group is revalued.
Note: If you are updating the cost of an item in common inventory, then the cost of that item intransit owned by the current organization is updated.
% Change: Enter a percentage change in this field as a whole value. The item cost is updated by this percentage value. The cost element and level, and the new total unit cost are automatically calculated when you save your work. Onhand inventory in all subinventories in the cost group is revalued.
Layer Value Change: Enter the amount to increase or decrease the current on–hand inventory value. To decrease the value, enter a negative amount.
Layer inventory is revalued by this amount, and the item’s layer cost is recalculated by dividing the on–hand quantity into the new layer inventory value.
To protect each element/level from becoming negative, the cost update reduces the value to zero and distributes the remainder to the cost variance account.
Specify the adjustment quantity (Adjustment Qty) for value change.
If the layer quantity at the time of cost processing is greater than the user entered Adjustment Quantity, then the entire value change due to landed cost adjustment is applied to the layer’s inventory valuation.
If the layer quantity is less than the user entered Adjustment Quantity, then only the proportionate value change is applied to the layer’s inventory valuation. The left-off value goes to the Expense account specified by the user.
Note: Adjustment Quantity can be entered only for Layer Cost Update – Value Change transaction. Adjustment Quantity cannot be entered for Layer Cost Update – New Cost or percentage transaction.
See the Oracle Landed Cost Management Process Guide for complete details on setting up and using Landed Cost Management.
Update any changes in the other tabbed regions before saving your work. Save your work.
To update layer costs by element or level
Choose Cost Elements to display the Layer Cost Update Transactions Details window.
In the Level field, select either This Level, or Previous Level.
Select a value in the Cost Element field. Your choices are Material, Material Overhead, Resource, Outside Processing, or Overhead.
For each level or element, enter a value in one of the cost fields.
New Layer Cost: Enter the new cost.
% Change: Enter a percentage change in this field as a whole value.
Layer Value Change: Enter the amount to increase or decrease the current on–hand inventory value. To decrease the value, enter a negative amount.
For any of the values changed, the cost element, level, and total unit cost are automatically calculated when you save your work. Onhand inventory in all subinventories in the cost group is revalued.
Layer inventory is revalued by this amount and the item’s layer cost is recalculated by dividing the on–hand quantity into the new layer inventory value. You cannot change the layer cost value by this method unless the item has quantity on–hand.
Update any changes in the other tabbed regions before saving your work. Save your work.
To update layer cost by Total Cost and perform a mass change for your records
Enter a value in one of the cost Total fields.
New Layer Cost Total: Enter the new total.
% Change Total: Enter a percentage change in this field as a whole value. The total cost is updated by this percentage value.
Layer Value Change Total: Enter the amount to increase or decrease the current on–hand inventory value. To decrease the value, enter a negative amount.
Update any changes in the other tabbed regions before saving your work.
Choose Mass Edit to update all your records displaying on this window.
When you save your record, the new total cost and the amount of change is automatically proportioned across all cost elements and levels. Onhand inventory in all subinventories in the cost group is revalued.
To view and enter account information
Select the Accounts tabbed region.
Enter values for the accounts you want to change.
You can update information for the following accounts: Material, Material Overhead, Resource, Outside Processing, and Overhead.
The offset to the inventory revaluation is applied to the layer cost adjustment account specified.
You can update individual account records. You can also change all records displaying by entering an account value in the Total field.
Enter an Expense account for adjustment quantity.
Update any changes in the other tabbed regions before saving your work.
Save your work. For mass changes, choose Mass Edit to update all displayed records. You can use Mass Edit for adjustment quantity, and the application apportions the total adjustment quantity according to the layer quantity.
To view or add reason and reference information for transactions
Select the Comments tabbed region.
Select a reason code in the Reason field to classify or explain the transaction.
In the Reference field, you have the option to enter any descriptive text.
Update any changes in the other tabbed regions before saving your work.
Save your work. For mass changes, choose Mass Edit to update all displayed records.
To review all previous transactions for your search results
Select the Create Transaction tabbed region. Layer number, cost, and quantity information display – along with the transaction identification number and type of transaction.
This section discusses those transactions that create layer cost and those transactions that use layer cost.
This includes both purchase order receipts to inventory and deliveries to inventory from receiving inspection. This does not include receipts to receiving inspection, which do not update the layer cost. Inventory calculates the transaction value as follows:
Transaction value equals purchase order price times transaction quantity
If the purchase order uses a foreign currency, then inventory calculates the transaction value as follows:
Transaction value equals purchase order price converted to inventory ledger currency times transaction quantity
This includes material you receive directly from another organization and from intransit inventory. Inventory calculates the transaction value as follows:
Transaction value equals [(cost from sending organization times transaction quantity) plus freight charges plus transfer credit charges
For a direct receipt, the organization that receives the material does not perform a transaction. The sending organization performs a ship transaction to the receiving organization. Inventory considers the transfer a receipt in the receiving organization and creates the layer and cost accordingly.
This refers to a miscellaneous receipt of material from a general ledger account or account alias. Inventory calculates the transaction value as follows:
Transaction value equals latest layer cost in inventory times transaction quantity
However, you can enter your own layer cost. This cost is spread elementally proportional to the average layer cost elements.
For example, if you enter a user-defined transaction cost of $20 for an item that has an average layer cost of $10 (distributed as shown in the following table), then the transaction elemental costs are distributed proportionally (also shown in the table):
Cost Element | Weighted Average Layer Cost | Distribution of Transaction Cost |
---|---|---|
Material | $5 | $10 |
Material Overhead (MOH) | $2 | $4 |
Resource | $1 | $2 |
Overhead | $1 | $2 |
Outside Processing | $1 | $2 |
Total | $10 | $20 |
See: Performing Miscellaneous Transactions, Oracle Inventory User's Guide.
This refers to a miscellaneous issue of material to a general ledger account or account alias. Inventory calculates the transaction value as follows:
Transaction value equals first layer cost in inventory times transaction quantity
If you use the first layer's cost of the item, this transaction does not update the layer cost. For this type of transaction, you can override the defaulted first layer's cost with your own cost.
Warning: The difference between the prior layer's cost and the entered cost may greatly and adversely affect the layer cost of the layer consumed.
See: Performing Miscellaneous Transactions, Oracle Inventory User's Guide.
This includes both purchase order returns from inventory direct to the supplier and returns to receiving inspection. Inventory calculates the transaction value as follows:
Transaction value equals purchase order price times transaction quantity
If the purchase order uses a foreign currency, Inventory calculates the transaction value as follows:
Transaction value equals purchase order price converted to inventory ledger currency times transaction quantity
Material overhead is also reversed based on the current material overhead rate(s).
See: Managing Receipts, Oracle Purchasing User's Guide and Entering Receiving Transactions, Oracle Purchasing User's Guide.
Although this transaction is a receipt, it creates a new layer at the same cost as the original shipment. This new layer is created as a latest layer cost for LIFO without a sales order reference, an earliest positive layer cost for FIFO without a sales order reference, or an original sales order issue cost if the RMA has a sales order reference.
Tip: Use the layer cost update to revise this layer's cost.
This transaction uses the first layer's cost of the item to value the transfer. Since this cost is the same for all subinventories in a cost group, this transaction does not update the layer cost of the item in the receiving subinventory, if you transfer within the same cost group.
When your on-hand inventory balance is negative, the transaction is split into three parts and costed as explained below:
The receipt creates a new layer.
Immediately that layer replenishes the layer(s) with negative quantity. The difference in costs between the layers creates an entry to the cost variance account.
The new layer is updated with the balance quantity.
You can examine your FIFO/LIFO item costs to determine how and why they have changed.
The following windows can be used to assist you in this process:
View Item Costs: Displays item costs and their elemental cost components (Material, Material Overhead, Resource, Overhead, and Outside Processing) for FIFO/LIFO cost types. You cannot update layer costs here.
View Transaction Layer Costs: Displays the cost of the consumed layer(s) for each inventory transaction and shows you how much quantity and at what cost the consumption is valued. Displays the receipt layer created or the negative layer, replenished for the receipt transactions. You can query by date/date range, specific item, transaction id, transaction source type/source.
View WIP Layer Costs: For issue transactions, it displays all the WIP layers by item and by operation for a specified job. The inventory layers that make up the WIP layers and their elemental costs are also displayed.
To view transaction layer costs
Navigate to the View Transaction Layer Cost window. The Find Transaction Layer Cost window appears.
Enter your search criteria. You can search for items by the following search criteria:
Date/date range
Item (item description is only a display field)
Transaction ID
Source type and source (the source field will be enabled only after you choose a source type)
Choose the Find button. The results display in the View Transaction Layer Cost window.
Select a transaction for an item displayed in the Transactions block of the View Transaction Layer Cost window.
For each transaction selected in the master block, you can view in the detail block all the layers created, consumed or replenished by the transaction. For each layer, you can view the elemental costs as well as the source type and the source of the transaction which creates the layer.
To view WIP layer costs
Navigate to the WIP Layers window.
Select your job by entering a valid job number or choosing from the List of Values.
Choose the Find button. The results display in the detail block of the WIP Layers window.
For a specified job number, you can view all the material operation requirements by item, by operation. When you select a component which has been issued to the job, you can view WIP layers related to the issues with the quantity issued and relieved in the detail block. Quantity relieved represents the total of components reliefs due to assembly completions and scrap transactions.
Since an issue to WIP transaction can consume multiple inventory layers, you can also view those inventory layers with their elemental costs. You can view the ID of the transaction creating the WIP layers.
Inventory continually maintains the value of inventory, updating it with each transaction. This means that you can report your inventory value quickly and accurately.
You can define an unlimited number of cost types and use them with any inventory valuation and margin analysis reports. This allows you to compare simulation and budget cost types against your actual layer costs. You can also periodically save your layer costs into another cost type for year to year and other comparisons.
When you use Oracle Bills of Material with Inventory, you can specify the cost type in explosion reports and report these costs for simulation purposes.
Under layer costing, variances are generated and handled as follows:
Cost variances are generated if you issue additional material even though the inventory balances for that material are negative. Inventory balances can be driven negative if the Allow Negative Balances parameter is set in the Organization Parameters window in Oracle Inventory.
Return to Vendor (RTV) and Negative Delivery Adjustments can drive specified layers negative because they are layer-specified transactions. This can occur even if other layers have positive quantities.
If negative quantities are allowed, when a receipt (or transfer in) transaction occurs for an item with negative on-hand inventory, the following takes place:
The negative layers are replenished in a FIFO or in a LIFO manner, up to the receipt quantity available. In addition, the new receipt layer is created with zero quantity.
If the transaction quantity is greater than the absolute value of the negative on-hand quantity (that is, the on-hand quantity would be positive if the transaction were processed), then the negative layers are completely replenished in FIFO/LIFO and a new layer with the balance quantity is created.
The difference between the units valued at the negative layer unit cost and those valued at the normal transaction unit cost is written to the cost variance account.
The Cost Variance account is also charged when a transaction results in a negative amount in inventory for one or more cost elements of an item.
Important: If you develop a large balance in the Cost Variance account, adjust your layer costs.
Invoice Price Variance (IPV) is the difference between the purchase price and the invoice price paid for a purchase order receipt. IPV's are generated when the invoice is processed and matched to the purchase order line items. Upon invoice approval, Oracle Payables automatically records this variance to both the invoice price variance and the exchange rate variance accounts. IPV is determined and recorded the same under both standard and average costing.
Inventory considers cycle count and physical inventory adjustments as variances.
Distribute these variances to the general ledger when you perform the general ledger transfer or period close.
Under project manufacturing costing, borrow/payback variance accounts are set up in the Cost Group window to make it possible for one project to borrow from another and return (payback) in the original cost.
The following types of cost transactions can occur:
Note: Layer Cost Transactions use default accounts. If Subledger Accounting (SLA) is enabled and SLA rules are customized, then the default accounts are not used.
This section shows accounting entries for layer costing purchasing transactions.
Note: The following accounts are the default accounts when layer costing is used. If Subledger Accounting (SLA) is enabled and SLA rules are customized, then the default accounts are not used.
You can use the Receipts window in Oracle Purchasing to receive material or outside processing items from a supplier into a receiving location (destination type equals receiving). You can also use this window to receive material directly to inventory.
When you receive material or outside processing items from a supplier into receiving inspection, the Receiving Inspection account is debited and the Inventory A/P Accrual account is credited based on the quantity received and the purchase order price.
Account | Debit | Credit |
---|---|---|
Receiving Inspection account at PO cost | XX | - |
Inventory A/P Accrual account at PO cost | - | XX |
Important: If a purchase order line item lacks a defined price, the system uses zero to value the transaction.
You can use the Receiving Transactions window to move material from receiving inspection to inventory. The system uses the quantity and the purchase order price of the delivered item to update the receiving inspection account and quantity. The system uses the layer cost. Here are the accounting entries:
Account | Debit | Credit |
Organization Material account at PO cost | XX | - |
Receiving Inspection account at PO cost | - | XX |
A new layer is created at PO price.
If your item has material overhead(s), you earn material overhead on deliveries from receiving inspection. Here are the accounting entries:
Account | Debit | Credit |
---|---|---|
Subinventory accounts | XX | - |
Material Overhead Absorption account | - | XX |
If the purchase order uses a foreign currency, the purchase order cost is converted to the ledger currency before the accounting entries are generated. This converted value is used for receiving accounting purposes.
The layer cost is recalculated using the transaction value of the purchase price converted to the inventory ledger currency times the transaction quantity.
With Oracle Purchasing and Inventory, there are two types of expense items. Purchasing has non-inventory purchases, such as office supplies or capital equipment. These items use an expense destination type for the purchase order's distribution information. You can inspect these purchasing items in receiving, but you cannot deliver these items into inventory.
However, expense inventory items can be stocked in a subinventory, but cannot be valued. Expense inventory items use an inventory destination type for the purchase order's distribution information. Expense inventory items can be delivered into both expense or asset subinventories.
When you receive to expense locations or receive expense inventory items, here are the accounting entries:
Account | Debit | Credit |
---|---|---|
Subinventory Expense account at PO cost | XX | - |
Inventory A/P Accrual account at PO cost | - | XX |
When you receive into an expense subinventory or receive an expense (non-asset) inventory item, the system debits the subinventory expense account instead of the valuation accounts.
See: Entering Receiving Transactions, Oracle Purchasing User's Guide, Defining Ledgers, Oracle General Ledger User's Guide and Organization Parameters Window, Oracle Inventory User's Guide
You can use the Receipts window to receive material directly from a supplier to inventory (destination type equals inventory).
When you receive material from a supplier directly to inventory, a receipt and delivery transaction are performed in one step.
Here are the accounting entries for the receipt portion of the transaction:
Account | Debit | Credit |
---|---|---|
Receiving Inspection account at PO cost | XX | - |
Inventory A/P Accrual account at PO cost | - | XX |
Here are the accounting entries for the delivery portion of the transaction:
Account | Debit | Credit |
---|---|---|
Organization Material account at PO cost | XX | - |
Receiving Inspection account at PO cost | - | XX |
If your item has material overhead(s), you earn material overhead on the delivery portion of the transaction. Here are the accounting entries:
Account | Debit | Credit |
---|---|---|
Organization Material Overhead account | XX | - |
Material Overhead Absorption account | - | XX |
The layer cost is recalculated using the transaction value of the purchase price converted to the inventory ledger currency times the transaction quantity.
Use Receiving Returns and Receiving Corrections windows to return material from receiving inspection or from inventory to a supplier. If you use receiving inspection and you have delivered the material into inventory, then you must first return the goods to receiving before you can return to the supplier. For a return from inspection, the system decreases the receiving inspection balance and reverses the accounting entry created for the original receipt. To decrease the inventory balance, the return to supplier transaction uses the purchase order cost.
Entering Returns, Oracle Purchasing User's Guide.
When you do not use receiving inspection, the return to supplier transaction updates the same accounts as the direct receipt to inventory, with reverse transaction amounts. To decrease the inventory balance, the return to supplier transaction uses the purchase order cost.
As with the purchase order receipts to inventory, if the purchase order uses a foreign currency, the purchase order cost is converted to the ledger currency before the accounting entries are generated.
See: Entering Returns, Oracle Purchasing User's Guide.
This section describes the accounting entries for layer costing inventory transactions.
Note: The following accounts are the default accounts when layer costing is used. If Subledger Accounting (SLA) is enabled and SLA rules are customized, then the default accounts are not used.
You can use the Miscellaneous Transaction window to issue items from a subinventory to a general ledger account (or account alias) and to receive items into a subinventory from an account / account alias. An account alias identifies another name for a general ledger account that you define.
Tip: Use account aliases for account numbers you use frequently. For example, use the alias SCRAP for your general ledger scrap account.
Here are the accounting entries for issuing material from a subinventory to a general ledger account or alias:
Account | Debit | Credit |
---|---|---|
Entered G/L account at layer cost | XX | - |
Inventory Valuation accounts at layer cost | - | XX |
Here are the accounting entries for receiving material to a subinventory from an account or an alias:
Account | Debit | Credit |
---|---|---|
Inventory Valuation accounts at layer cost | XX | - |
Entered G/L account at layer cost | - | XX |
Note: Under layer costing, you can enter a unit cost which the system uses in place of the layer cost.
Performing Miscellaneous Transactions, Oracle Inventory User's Guide.
When you receive into an expense location or receive an expense item, you have expensed the item. If you use the miscellaneous transaction to issue from an expense location, you can issue to an account or to an asset subinventory of the INV:Allow Expense to Asset Transfer profile option in Oracle Inventory is set to Yes. If issued to an account the system assumes the item is consumed at the expense location and moves the quantity without any associated value. If transferred to an asset subinventory, the item moves at its current cost.
When you receive an expense item to either an asset or expense subinventory, no accounting occurs. Since the account balance could involve different costs over time, the system assumes the cost of the expense item is unknown.
Caution: Transaction unit costs can be entered when you perform a miscellaneous transaction in Inventory. However, entering a cost that is significantly different from the layer can cause large swings in the unit cost of remaining on-hand inventory. Oracle recommends you take the appropriate measures to control the ability to enter the transaction unit cost.
Use the Subinventory Transfer window to move material from one subinventory to another. If you specify the same subinventory as the From and To Subinventory, you can move material between locators within a subinventory.
Since you use the same valuation accounts for your subinventories (the organization inventory valuation accounts), this transaction has no net effect on overall inventory value, and no accounting entries are generated.
You can issue from an asset to an expense subinventory, and you can issue from an expense subinventory if the Oracle Inventory INV:Allow Expense to Asset Transfer profile option is set to Yes. The application assumes the item is consumed at the expense location.
See: Transferring Between Subinventories, Oracle Inventory User's Guide.
You can use cycle counting and physical inventory to correct your inventory on-hand balances.
If you physically count more than your on-hand balance, then here are the accounting entries:
Account | Debit | Credit |
---|---|---|
Inventory Valuation accounts at layer cost | XX | - |
Adjustment account at layer cost | - | XX |
If you count less than your on-hand balance, then here are the accounting entries:
Account | Debit | Credit |
---|---|---|
Adjustment account at layer cost | XX | - |
Inventory Valuation accounts at layer cost | - | XX |
The accounting entries for physical inventory adjustments are the same as those for cycle counts.
Tip: Since the quantities, not the layer cost, is kept when you freeze the physical inventory, you should not perform any transactions that might affect your layer costs until you have adjusted your physical inventory.
The system does not record accounting entries when physical inventory or cycle count adjustments involve expense subinventories or expense items. However, quantity balances in expense subinventories are corrected if the quantities in these subinventories are tracked.
Related Topics
Overview of Cycle Counting, Oracle Inventory User's Guide,
Entering Cycle Counts, Oracle Inventory User's Guide,
Overview of Physical Inventory, Oracle Inventory User's Guide, and
Processing Physical Inventory Adjustments, Oracle Inventory User's Guide.
This section shows accounting entries for layer costing order management and shipping transactions.
Note: The following accounts are the default accounts when layer costing is used. If Subledger Accounting (SLA) is enabled and SLA rules are customized, then the default accounts are not used.
You ship material on a sales order using Oracle Order Shipping Execution. Here are the accounting entries for sales order shipments:
Account | Debit | Credit |
---|---|---|
Deferred Cost of Goods Sold account at layer cost | XX | - |
Inventory Valuation accounts at layer cost | - | XX |
Important: You do not create any accounting information when you ship from an expense subinventory or ship an expense inventory item.
You can receive items back from a customer using the RMA (return material authorization) Receipts window. Non-referenced RMA receipts are made at the earliest or latest layer cost, depending on whether it is FIFO or LIFO respectively.
Here are the accounting entries for an RMA receipt:
Account | Debit | Credit |
---|---|---|
Inventory Valuation accounts at latest cost | XX | - |
Cost of Goods Sold account at latest cost | - | XX |
Deferred Cost of Goods Sold account at latest cost | - | XX |
You use the same account as the original cost of goods sold transaction.
Important: You do not create any accounting entries for a return to an expense subinventory or return for an expense inventory item.
See: Return Material Authorizations, Oracle Purchasing User's Guide.
You can return items received into inventory through an RMA back to the customer using the RMA Returns window. For example, you can send back - “return" - an item that was returned by the customer to you for repair.
This transaction reverses an RMA receipt. It also mimics a sales order shipment and updates the same accounts as a sales order shipment.
Here are the accounting entries for an RMA return:
Account | Debit | Credit |
---|---|---|
Cost of Goods Sold account at layer cost | XX | - |
Deferred Cost of Goods Sold account at layer cost | - | - |
Inventory Valuation accounts at layer cost | - | XX |
Important: You do not create any accounting entries when you return a customer RMA from an expense subinventory or for an expense inventory item.
See: Return Material Authorizations, Oracle Purchasing User's Guide.
You can view and update the layer cost of an item by cost element and level (this level and previous level). You can update layer costs using a percentage change, a new layer cost, or a value change. A change made to the total unit cost of an item is spread to all cost elements and levels in the same proportion as they existed before the update.
The offset to the inventory revaluation in all cases above will be booked to the Layer Cost Adjustment account(s) you specified at the time you perform the update.
Note: The layer cost update feature is intended to be used sparingly to correct a transaction costing error affecting items in subinventory. If the cost error is in WIP, the impacted quantities will need to be returned to a subinventory, corrected there, then reissued to WIP after the update has been completed.
If the adjustment increases inventory, then here are the accounting entries:
Note: The following accounts are the default accounts when layer costing is used. If Subledger Accounting (SLA) is enabled and SLA rules are customized, then the default accounts are not used.
Account | Debit | Credit |
---|---|---|
Inventory Valuation accounts | XX | - |
Adjustment account | - | XX |
If the adjustment decreases inventory, then here are the accounting entries:
Account | Debit | Credit |
---|---|---|
Adjustment account | XX | - |
Inventory Valuation accounts | - | XX |
Related Topics
The following cost transactions can occur when Oracle Work in Process is installed:
Component Issue and Return Transactions
Move Transactions
Resource Charges
Outside Processing Charges
Overhead Charges
Assembly Scrap Transactions
Assembly Completion Transactions
Assembly Returns
Job Close Transactions
Period Close Transactions
You can perform the following transactions:
Issue component items to jobs from an inventory layer
Return components from jobs back to inventory, creating a layer
Issue or return directly by performing a WIP material transaction or by using the Inventory Transaction Interface
Backflush components using the Move Transactions and Completion Transactions windows in WIP, the Receipts window in Purchasing (for outside processing), or by using the WIP Open Move Transaction Interface
Issue transactions increase the WIP valuation and decrease the inventory valuation. Components issued to or returned from jobs are valued at the inventory layer cost in effect at the time of the transaction. Components issued to a job or returned from a job in several different transactions may have different unit costs for each transaction. If a component's unit cost is composed of more than one cost element, this elemental detail continues to be visible after it is charged to a job.
Here are the accounting entries for issue transactions:
Note: The following accounts are the default accounts when layer costing is used. If Subledger Accounting (SLA) is enabled and SLA rules are customized, then the default accounts are not used.
Account | Debit | Credit |
---|---|---|
WIP accounting class valuation accounts | XX | - |
Subinventory elemental accounts | - | XX |
Here are the accounting entries for return transactions:
Account | Debit | Credit |
---|---|---|
Subinventory elemental accounts | XX | - |
WIP accounting class valuation accounts | - | XX |
See: Overview of Material Control, Oracle Work in Process User's Guide.
A move transaction moves assemblies within an operation, such as from Queue to Run, or from one operation to the next. Move transactions can automatically launch operation completion backflushing and charge resources and overheads.
The total quantity required at an operation is issued at the first move transaction (scrap, to move, etc.) for the operation.
You can perform move transactions using the Move Transactions window, Open Move Transaction Interface, or the Receipts window in Purchasing.
With backflushing, you issue component material used in an assembly or subassembly by exploding the bills of material, and then multiplying by the number of assemblies produced.
Move transactions can create operation pull backflush material transactions that issue component material from Inventory layers into WIP layers. For backflush components under lot or serial number control, you assign the lot or serial numbers during the move transaction.
When you move backward in a routing, WIP automatically reverses operation pull backflush transactions. Here are the accounting entries for move transactions:
Account | Debit | Credit |
---|---|---|
WIP accounting class valuation accounts | XX | - |
Inventory Valuation accounts | - | XX |
Here are the accounting entries for return transactions:
Account | Debit | Credit |
---|---|---|
Inventory Valuation accounts | XX | - |
WIP accounting class valuation accounts | - | XX |
See: Overview of Material Control, Oracle Work inProcess User's Guide.
As the assemblies you build pass through the operations on their routings, move transactions charge all pre-assigned resources with an auto-charge type of WIP Move at their standard rate.
You can charge resources based upon a fixed amount per item moved in an operation (Item basis) or based upon a fixed lot charge per item moved in an operation (Lot basis). For resources with a basis of Lot, WIP automatically charges the lot cost upon completion of the first assembly in the operation.
You can also enter manual resource transactions associated with a move, or independent of any moves. You can manually charge resources to a job, provided it has a routing. You can also transact resources through the Open Resource Transaction Interface.
See: Overview of Resource Management, Oracle Work in Process User' Guide.
WIP supports four resource auto-charging methods: Manual, WIP Move, PO Move, and PO Receipt. You can charge resources at an actual rate. You can also charge resource overheads automatically as you charge resources.
You can automatically charge resources at predefined rates to a job when you perform a move transaction using either the Move Transaction window or the Open Move Transaction Interface. When you move assemblies from the queue or run intraoperation steps forward to the to move, reject, or scrap intraoperation steps, or to the next operation, WIP charges all pre-assigned resources with an charge type of WIP Move at their predefined rate.
For resources with a basis of item, WIP automatically charges the resource's usage rate or amount multiplied by the resource's predefined cost upon completion of each assembly in the operation. For resources with a basis of lot, WIP automatically charges the resource's usage rate or amount multiplied by the resource's predefined cost upon completion of the first assembly in the operation.
You can undo the WIP Move resource charges automatically in these ways:
By moving the assemblies from queue or run of your current operation to queue or run of any prior operation
By moving the assemblies from the to move, reject, or scrap intraoperation steps backward to the queue or run intraoperation steps of the same operation, or to any intraoperation step of any prior operation
Phantom assemblies can be costed fully in Release 12. To cost the routings of the phantom, you check these BOM parameters:
Use Phantom Routings
Inherit Phantom Operation Sequence
The overhead and resources on the phantom routing are charged at this level. Your parent assembly is costed as if the operation contained the resources and overheads of the phantom routing.
You can charge manual resources associated with a move transaction or independently of any moves. Manual resource transactions require you to enter the actual resource units applied rather than autocharging the resource's usage rate or amount based on the move quantity. You can charge resources using that resource's unit of measure or any valid alternate. You can manually charge resources to a job, provided that it has a routing.
If you use the Move Transactions window to perform moves and manual resource transactions at the same time, WIP displays all pre-assigned manual resources with a charge type of manual assigned to the operations completed in the move. If the resource is a person, you can enter an employee number.
In addition to the resources that appear, you can manually charge any resource to a job, even if you have not previously assigned the resource to an operation in the job. You can also manually charge resources to an operation added ad hoc by entering any resource defined for the department associated with the operation.
You can correct or undo manual resource transactions by entering negative resource units worked.
You can charge labor charges at actual in two ways. You can enter an actual rate for the employee using the Open Resource Transaction Interface or when you define employee rates. For labor charges using an actual or employee rate for a resource for which charge standard rate is turned off, here are the accounting entries:
Account | Debit | Credit |
---|---|---|
WIP accounting class resource valuation account | XX | - |
Resource absorption account | - | XX |
If you enter an actual rate for a resource for which Charge Standard Rate is enabled, WIP charges the job at a predefined amount. If Autocharge is set to manual and actual rates and quantities are recorded, then a rate variance is recognized immediately for any rate difference. Here are the accounting entries for the actual labor charges:
Account | Debit | Credit |
---|---|---|
WIP accounting class resource valuation account | XX | - |
Resource rate variance account (Debit when actual rate is greater than the standard rate. Credit when the actual rate is less than the standard rate.) | XX | XX |
Resource absorption account | - | XX |
You can receive purchased items associated with outside resources from an outside processing operation back into WIP in Oracle Purchasing. For these items, WIP creates resource transactions at the standard or actual rate for all outside resources with an autocharge type of PO receipt or PO move.
See: Overview of Resource Management, Oracle Work in Process User's Guide , Managing Receipts, Oracle Purchasing User's Guide and Overview of Outside Processing, Oracle Work in Process User's Guide.
WIP automatically creates resource transactions at the standard or actual rate for all outside processing resources with an charge type of PO Receipt or PO Move when you use the Receipts window in Purchasing to receive assemblies from an outside processing operation back into WIP. For outside processing resources with a charge type of PO Move, WIP also performs a move of the assemblies from the queue or run intraoperation step of your outside processing operation into the queue intraoperation step of your next operation or into the to move intraoperation step if the outside processing operation is the last operation on your routing.
If you assigned internal resources to an outside operation with an charge type of manual, you use the Move Transactions window or the Open Resource Transaction Interface to charge these resources.
If you return assemblies to the supplier, the system automatically reverses the charges to all automatic resources associated with the operation. You must manually reverse all manual resource charges using the Move Transactions window. For outside processing resources with an charge type of PO Move, WIP automatically moves the assemblies from the queue intraoperation step of the operation immediately following the outside processing operation into the queue intraoperation step of your outside processing operation. If the outside processing operation is the last operation on your routing, WIP automatically moves the assemblies from the to move intraoperation step to the queue intraoperation step.
When you receive the assembly from the supplier, Purchasing sends the resource charges to WIP at either a predefined cost or actual purchase order price, depending upon how you specified the standard rate for the outside processing resource.
If you enabled Charge Standard Rate for the outside processing resource being charged, then Purchasing charges WIP at the standard rate. WIP then creates a purchase price variance for the difference between the standard rate and the purchase order price. Here are the WIP accounting entries for outside processing items:
Account | Debit | Credit |
---|---|---|
WIP accounting class outside processing valuation account | XX | - |
Purchase price variance account (Debit when the actual rate is greater than the standard rate. Credit when the actual rate is less than the standard rate.) | XX | XX |
Organization Receiving account | - | XX |
Any quantity or usage difference is recognized as an outside processing efficiency variance at period close.
Here are the accounting entries for return to supplier for outside processing:
Account | Debit | Credit |
---|---|---|
Organization Receiving account | XX | - |
Purchase price variance account (Debit when actual rate is less than the standard rate. Credit when the actual rate is greater than the standard rate. | XX | XX |
WIP accounting class outside processing valuation account | - | XX |
If you disable standard option for the outside processing resource being charged, purchasing charges WIP the purchase order price and does not create a purchase price variance.
Here are the accounting transactions for outside processing charges at purchase order price:
Account | Debit | Credit |
---|---|---|
WIP accounting class outside processing valuation account | XX | - |
Organization Receiving account | - | XX |
See: Overview of Shop Floor Control, Oracle Work in Process User's Guide
WIP automatically charges appropriate overhead costs as you move assemblies through the shop floor. You can charge overheads directly based on move transactions or based on resource charges. For overhead charges based on move transactions with a basis of item, WIP automatically charges overheads upon completion of each assembly in the operation. WIP automatically reverses these charges during a backward move transaction.
For overheads based on move transactions with a basis of lot, WIP automatically charges overheads upon completion of the first assembly in the operation. WIP automatically reverses these charges during a backward move transaction if it results in zero net assemblies completed in the operation.
WIP automatically charges appropriate overhead costs as you charge resources. You can charge overheads based on resource units or values. WIP automatically reverses overhead charges when you reverse the underlying resource charge.
Overhead charges increase WIP valuation. Here are the accounting entries for overhead charges:
Account | Debit | Credit |
---|---|---|
WIP accounting class overhead account | XX | - |
Overhead absorption account | - | XX |
You can reverse overhead charges by entering negative manual resource charges or performing backward moves for WIP move resources.
Here are the accounting entries for reverse overhead charges:
Account | Debit | Credit |
---|---|---|
Overhead absorption account | XX | - |
WIP accounting class overhead account | - | XX |
See: Overview of Shop Floor Control, Oracle Work in Process User's Guide
The cost of components in the assembly comes from FIFO/LIFO rules.
If you move assemblies into the scrap intraoperation step of an operation and the WIP Require Scrap Account parameter is set, you must enter a scrap account number or account alias. If you do not specify that a scrap account is required, then it is optional. If you do not provide a scrap account, then the cost of scrap remains in the job or schedule until job or period close. If the job is then completed using the final completion option in the Completion Transactions window, then the cost is included in the finished assembly cost. Otherwise, the cost is written off as a variance when the non-standard asset and standard discrete jobs are closed and at period close for non-standard expense jobs.
WIP considers assemblies that are moved into the scrap intraoperation step from the queue or run of the same operation as complete at that operation. Operation completion information is updated, components are backflushed, and resource and overhead costs are charged according to the elemental cost setup. See: Scrapping Assemblies, Oracle Work in Process User's Guide.
If a scrap account is entered, then the cost of scrapped assemblies is determined using an algorithm that calculates the assembly costs through the operation at which the scrap occurred. The scrap account is then debited; the job elemental accounts are credited. The scrap calculation uses jog requirements, rather than cost incurred. If you move assemblies out of a scrap operation step, therefore reversing the ordinal scrap transaction, these accounting entries are reversed.
Here are the accounting entries for scrap transactions:
Account | Debit | Credit |
---|---|---|
Scrap account | XX | - |
WIP accounting class valuation accounts at calculated scrap value | - | XX |
Here are the accounting entries for reverse scrap transactions:
Account | Debit | Credit |
---|---|---|
WIP accounting class valuation accounts at calculated scrap value | XX | - |
Scrap account | - | XX |
See: Overview of Shop Floor Control, Oracle Work in Process User's Guide.
Use the Completion Transactions or the WIP Move window in WIP or the Inventory Transaction Interface to receive completed assemblies from WIP into asset subinventories. Completion transactions relieve the valuation account of the accounting class and charge the Inventory Valuation accounts based upon the Cost Source.
Completions are in layers. Resources, overhead, and outside processing are held at job average.
Completions decrease WIP valuation and increase inventory valuation. Here are the accounting entries for completion transactions:
Account | Debit | Credit |
---|---|---|
Inventory Inventory Valuation accounts | XX | - |
WIP accounting class valuation accounts | - | XX |
When the final completion option is used for an assembly completion, no residual balance, positive or negative, is left in the job. The accounting entries are different for positive and negative residual balances. Positive residual balances post to inventory and negative residual balances post to variance. The balances are held by element, by level and are not summed. Therefore, transactions per given element may have balances going to inventory and variance for the same element, at different levels.
If there are positive residual balances at an assembly completion with the final completion option enabled, then here are the accounting entries:
Account | Debit | Credit |
---|---|---|
Inventory Inventory Valuation accounts | XX | - |
WIP accounting class valuation accounts | - | XX |
If there are negative residual balances at an assembly completion with the final completion option enabled, then here are the accounting entries:
Account | Debit | Credit |
---|---|---|
WIP accounting class variance accounts | XX | - |
WIP accounting class valuation accounts | - | XX |
You can assign overheads based on Item, Lot or Total Value basis. For standard discrete jobs, you can earn these overheads as you complete assemblies from WIP to inventory.
Use non-standard expense jobs for such activities as repair and maintenance. Use non-standard asset jobs to upgrade assemblies, for teardown, and to prototype production.
Note: Unlike standard costing, in layer costing, non-standard discrete jobs earn overhead on completion.
Here are the accounting entries for material overhead on completion transactions for both standard and non-standard, asset and expense jobs:
Account | Debit | Credit |
---|---|---|
Subinventory material overhead account | XX | - |
Inventory material overhead absorption account | - | XX |
Note: Do not complete the assembly if you want to:
Expense all the rework cost
Not add the cost to inventory
Not earn material overhead
Instead, return the assembly, by component return, to inventory and then close the job.
See: Completing and Returning Assemblies, Oracle Work in Process User's Guide.
The Completion Transactions window in WIP or the Inventory Transaction Interface is used to return completed assemblies from asset subinventories to WIP. The costing of resources, overhead, and outside processing on assembly returns differs depending on the completion cost source method: system calculated or user-defined.
The layer cost worker uses the FIFO rule to select the appropriate inventory layer from the specified job to determine the amount to credit inventory. The same cost worker calculates the debit to the WIP valuation accounts as a reversal to the latest (most recent) completion(s). The difference is captured in the Cost Variance account.
Assembly return costing is as follows for the two completion methods:
User defined - At user-defined cost
System calculated - The weighted layer of previous completions of that job.
Returns increase WIP valuation and decrease inventory valuation. Here are the accounting entries for assembly return transactions:
Account | Debit | Credit |
---|---|---|
WIP accounting class valuation accounts | XX | - |
Inventory Valuation accounts | - | XX |
Cost Variance account | XX | XX |
Until you close a job, or change the status of the job to Complete - No Charges, you can make material, resource, and scrap charges to the job. Closing a discrete job prevents any further activity on the job.
The completion method has no bearing on the Cost Variance that is generated.
WIP recognizes variances when you close a job. The actual close date that you specify determines the accounting period WIP uses to recognize variances. You can back date the close to a prior open period if desired.
The close process writes off the balances remaining in the WIP elemental valuation accounts to the elemental variance accounts that you defined by accounting class, leaving a zero balance remaining in the closed job.
If there is a positive balance in the job at the end of the close, then here are the accounting entries for a job close:
Account | Debit | Credit |
---|---|---|
WIP accounting class variance accounts | XX | - |
WIP accounting class valuation accounts | - | XX |
The period close process in Inventory recognizes variances for non-standard expense jobs. It also transfers the WIP period costs to the general ledger.
You can close a discrete job and recognize variances for non-standard expense jobs at any time. In addition, the period close process automatically recognizes variances on all non-standard expense job charges incurred during the period. Therefore, open non-standard expense jobs have zero WIP accounting balances at the start of a new period.
If there is a positive balance in the job at the end of the period, then here are the accounting entries for non-standard expense jobs at period close:
Account | Debit | Credit |
---|---|---|
WIP accounting class variance accounts | XX | - |
WIP accounting class valuation accounts | - | XX |
See: Overview of Period Close, Closing Discrete Jobs, Oracle Work in Process User's Guide and Defining WIP Parameters, Oracle Work in Process User's Guide.