0 Replies Latest reply on Jun 21, 2011 7:04 PM by 516409

    Error with Return To Vendor

    516409
      Hi,
      I'm trying to use the Rcv_Transactions_interface table to return the received quantity to the vendor.

      Transaction_type : RETURN TO VENDOR

      The PO line has the item_id from the Mtl_Related_Items table and the Rcv_shipment_lines has the original Inventory_item_id of the related Item.

      I get this error
      Error: The ITEM_ID specified is invalid. The value specified (7001) does not match the expected value (7028).

      Where as 7001 is the PO line Item_id and 7028 is the Rcv_shipment_lines item_id.

      If I pass the Item_id , I still get the error as

      Error: The ITEM_ID specified is invalid. The value specified (7028) does not match the expected value (7001).

      I have passed the Parent_transation_id from the Rcv_transactions table into Rcv_Transactions_interface table to pick up the correct receipt to be returned. Am wondering why it is still erroring out.

      I need to return 3000 records in production. Any help is greatly appreciated.

      Thanks
      GM