Average Costing of item at subinventory as well as lot level in Oracle Fusion

Summary:

Problem Summary

---------------------------------------------------

Average costing at different levels for same item

Problem Description

---------------------------------------------------

We are using Oracle fusion 23A application.

One of our requirement is regarding Average costing, where we need to have average costing calculated based on the subinventory level as well as at lot level for the same item.

For example, We have Item A which is full lot controlled. This item A has on hand in 2 sub inventories i.e. Subinv A and Subinv B.

Now,

Subinv A has 2 lots Lot1 and Lot 2.

Subinv B has 2 lots Lot3 and Lot 4.

Our requirement is, for item A, Average costing should be calculated at subinventory level for Subinv A and for Subinv B, it should be calculated at Lot3 and Lot4 level.