1 Reply Latest reply: Feb 5, 2013 10:12 AM by user427024 RSS

    Item Related

    968368
      If item is Serial Controlled, then how we will migrate the onhand quantity ?
        • 1. Re: Item Related
          user427024
          You have to populate two tables MTL_TRANSACTIONS_INTERFACE and MTL_SERIAL_NUMBERS_INTERFACE.

          If you are transacting items under serial control, you need to link the serial transaction detail rows to their parent row. You accomplish this by populating MTL_TRANSACTIONS_INTERFACE.TRANSACTION_INTERFACE_ID with a unique value to be used as the primary key to link the child lot/serial rows. If the item is under serial control, you populate the foreign key MTL_SERIAL_NUMBERS_INTERFACE.TRANSACTION_INTERFACE_ID with the value in the parent row and ensure that the total number of serial numbers adds up to the transaction quantity of the parent row.