Updating Average Costs in Oracle Costing


For average cost organizations only, you can directly update the average cost of items to include additional costs, such as freight, invoice price variances, or job variances. You can update one or more cost elements or levels (this and previous) individually or to the total unit cost. Any change made to the total unit cost is spread to all cost elements and levels in the same proportion as existed prior to the update.


Note: Average cost updates that fail can be viewed and resubmitted, using the View Material Transactions window from the Cost function. See Error Resubmission.

You can make the following three types of updates:

a new average cost - enter the new cost by cost element and level (and the new total unit cost is automatically calculated), or enter a new total cost (the amount of change will automatically be proportioned across all cost elements and levels); onhand inventory in all subinventories in the cost group will be revalued. If you are updating the cost of an item in common inventory, the cost of that item in intransit owned by the current organization will also be updated.
the percentage change in the unit cost - select cost element(s) and level(s) to adjust up or down (and the new total unit cost will be automatically calculated), or adjust the total (the percentage change will automatically be applied to all cost elements and levels); onhand inventory in all subinventories in the cost group will be revalued.
the value change by which onhand inventory is to be incremented or decremented - select cost element(s) and level(s) to be adjusted or adjust the total and the system will revalue onhand inventory by that amount and recalculate the item's average cost for the cost group. You cannot change the average cost in this way unless the item has quantity on hand.
Additional Information: Average cost update transactions are inserted into the Open Item Interface in Oracle Inventory. Update transaction details can be viewed using the Transaction Interface Details window. This window is accessed using the Cost Detail button from the Oracle Inventory Transaction Interface window. See: Viewing and Updating Transaction Open Interface.

  
Oracle Inventory Open Interfaces, Oracle Manufacturing, Distribution, Sales and Service Open Interfaces Manual.

   To update total unit average costs:
1. Navigate to the Update Average Cost window.
2. Select a transaction date.
You can select any date within an open period, up to and including the current date.
3. Select the Average cost update in the Type field.
4. Optionally, select a Source type for the transaction.
Source types define origins for transactions.
5. Select an average cost update Adjustment Account.
If you increase average costs, debit your subinventory accounts and credit the specified adjustment account. If you decrease average costs, the reverse adjustments are generated.
You must select an Adjustment Account.
6. If you are updating costs using a percentage change, enter a default to use as the percentage change for individual item costs.
7. Select the item for the average cost update.
8. Select a Cost Group.
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 and Defining Project Information.
If these parameters are not set, the Common group is used.
9. Update the total unit average cost. Do one of the following:
Enter a New Average Cost. This value cannot be negative. On-hand inventory in all subinventories and intransit are revalued.
Enter a percentage change in the item's average cost. The item cost is updated by this percentage value. On-hand inventory in all subinventories and intransit is revalued.
Enter the amount to increase or decrease the current on-hand inventory value. To decrease the value, enter a negative amount. However, you cannot enter a value that drives the inventory value negative.
On-hand inventory is revalued by this amount and the item's average cost is recalculated by dividing the on-hand quantity into the new inventory value. You cannot change the average cost value by this method unless the item has quantity on-hand.
The offset to the inventory revaluation in all cases above is booked to the average cost adjustment account(s) specified at the time the update is performed.
10. Open the Value Change tabbed region and review the change in inventory value.
11. Optionally, open the Comments tabbed region and enter a reason for the transaction. Use a reason code to classify or explain the transaction.
12. Optionally, enter up to 240 characters of reference text.
13. Optionally, choose the Cost Elements button to update average costs by element by level.
   To update average costs by element and / or level:
Note: This section is only relevant if you set the CST: Average Cost Option to Inventory and Work in Process.

1. Navigate to the Cost Elements window. Do this by choosing the Cost Elements button from the Update Average Costs window.
2. For each level and / or element, do one of the following:
Enter a New Average Cost. On-hand inventory in all subinventories and intransit is revalued.
Enter a percentage change in the item's average cost. The item cost is updated by this percentage value. On-hand inventory in all subinventories and intransit is revalued.
Enter the amount to increase or decrease the current on-hand inventory value. On-hand inventory is revalued by this amount and the item's average cost is recalculated by dividing the on-hand quantity into the new inventory value. You cannot change the average cost value by this method unless the item has quantity on-hand.
The offset to the inventory revaluation in all cases above is booked to the average cost adjustment account(s) specified at the time the update is performed.
3. Save your work.