投料退回数据卡在接口里,推送过去之后,该批次无法做任何操作,提示无可用数量

解决方法:

UPDATE mtl_material_transactions_temp

 SET cost_group_id = (SELECT cost_group_id FROM mtl_onhand_quantities_detail WHERE inventory_item_id = 571 AND subinventory_code = 'XB01' AND organization_id = 361 AND lot_number = '131206LY131125')

 WHERE inventory_item_id = 571;