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!

how to update inventory transactions

Discussion in 'Oracle SCM & Manufacturing' started by AHS30, Jun 21, 2010.

  1. AHS30

    AHS30 Active Member

    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    55
    hi,

    In Oracle Apps 11i, we have created a user transaction type of Opening Balances Receipt into Stores.
    Using this transaction type opening balances were entered through the miscellaneous transaction form.

    The fields: item, subinventory, unit of measure, account, quantity, unit cost, reason attribute3, attribute4 (as packing list/case no respectively) were entered to the mtl_material_transactions table.
    Some records were entered with wrong quantity and unit cost data.

    How can I update these transactions from the front end?

    thank you
     
  2. Sadik

    Sadik Community Moderator Forum Guru

    Messages:
    1,906
    Likes Received:
    252
    Trophy Points:
    1,455
    If you did miscellenous receipt of wrong quantity the system can do nothing. You will have to issue out the extra quantity and/or do an average cost update.
     
  3. versatile36

    versatile36 Active Member

    Messages:
    11
    Likes Received:
    1
    Trophy Points:
    75
    you can update only with backend..