1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Want to calculate material average cost at sub-inventory level.

Discussion in 'Oracle SCM & Manufacturing' started by nilesh.dudhane, Aug 13, 2015.

  1. nilesh.dudhane

    nilesh.dudhane Active Member

    Messages:
    42
    Likes Received:
    2
    Trophy Points:
    135
    Location:
    India
    Hi All,
    Generally in Oracle Inventory Material Cost is calculated at Inventory Level,but I want to calculate Material cost at Sub-Inventory level is it possible or not??

    If possible please guide me to how to achieve this.

    Thanks
    Nilesh
     
  2. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Hi Nilesh,

    I think its possible, because while doing Sub-Inventory setup we can see the field called Cost Group. Have you checked in CST_Item_Costs tables and all?
     
  3. nilesh.dudhane

    nilesh.dudhane Active Member

    Messages:
    42
    Likes Received:
    2
    Trophy Points:
    135
    Location:
    India
    Hi Bharat,
    Thanks for your idea, will check and update you.

    Thanks
    Nilesh
     
    Bharat likes this.
  4. MANOJB

    MANOJB Starter

    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    10
    Location:
    Austin
    I dont think it is possible. Average costing works only at Org level. My client gave me same requirement, I ended up setting that subinventory as the separate inventory org.

    Nilesh,
    If you find solution with cost group, please let me know.
     
  5. Sandeep Patel

    Sandeep Patel Active Member

    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    55
    Location:
    Hyderabad
    Hi Nilesh,

    It is not possible to implement Average Material costing or any other costing methods at Sub Inventory level,The costing method is setup only at Inventory organization level.As the Subinventories are structures with in Inventory Organization the same costing method is used.