2. 由于1,在系统中可能会存在同物料不同的接收号对应相同的序列号。在退货时,较早的接收将不能进行退货;此问题属于系统BUG
原因官方解释为‘There is one restriction to prevent returning serials against earlier deliver, as the serial is also delivered by another later deliver transaction.'
请参考官方文档ID:Unable to Return Serialized Item, 0 choice for Serial Number LOV, FRM-40212 (文档 ID 1053770.1)
Select rt2.* from rcv_transactions RT2, mtl_material_transactions mmt2, mtl_unit_transactions mut2
WHERE RT2.transaction_id >1737312
AND RT2.transaction_type = 'DELIVER'
AND RT2.transaction_id = mmt2.rcv_transaction_id
AND MMT2.transaction_id = mut2.transaction_id
AND MUT2.serial_number ='GB89469'
AND MUT2.inventory_item_id = 689007
AND MUT2.organization_id = 778;
AND RT2.transaction_type = 'DELIVER'
AND RT2.transaction_id = mmt2.rcv_transaction_id
AND MMT2.transaction_id = mut2.transaction_id
AND MUT2.serial_number ='GB89469'
AND MUT2.inventory_item_id = 689007
AND MUT2.organization_id = 778;
mtl_serial_numbers:物料序列号表 (使用SERIAL_NUM_STATUS lookup type , 1. 已定义但尚未使用 3.驻留在库存中 4 从库存发放 5. 在途驻留 7 在接收中 8 在WIP 中)
mtl_unit_transactions:物料事务处理控制表;(使用MTL_TRX_ISSUE_RECEIPT lookup type 1.发放 2.接收)