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!

Receiving and material transactions

Discussion in 'Oracle SCM & Manufacturing' started by springtime, Jul 5, 2016.

  1. springtime

    springtime Active Member

    Messages:
    8
    Likes Received:
    0
    Trophy Points:
    55
    Location:
    Canada
    Hi All



    We have a problem where for certain receiving transactions, the PO price is being populated in the mtl_material_transactions table rather than the costing price .



    e.g in a receiving transaction, we have RECEIVE, ACCEPT and DELIVER type of transactions.



    The problem is for the RECEIVE kind of transaction it takes the unit price for the inventory item from the Costing where as for the DELIVER type of transaction, it takes the unit price, conversion price and conversion date from the PO.



    Occasionally it happens the other way where for RECEIVE transaction it takes the information from the PO and for the DELIVER transaction, it takes information from Costing.



    I would like to know on what basis the mtl_transactions_interface table is populated. Why is this imbalance happening?



    Any help appreciated.



    Thanks
     
  2. anbeesivamm

    anbeesivamm Premium Member

    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    55
    Location:
    Singapore
    Hi,

    Item Cost usually derived from PO Price for standard costing. but the difference between PO Price (PO) and Item Cost (Receive)will be variance Purchase price variance. Refer doc for more clarity.

    Regards
    Siva
     

    Attached Files:

  3. springtime

    springtime Active Member

    Messages:
    8
    Likes Received:
    0
    Trophy Points:
    55
    Location:
    Canada
    Hi

    Thanks for your reply.we are using average costing. The variance is between intercompany price and PO price.