WMS - create picking tasks based on the weight of a complete delivery
As a company we have a requirement to create picking tasks based on the weight of a complete delivery. Aim is to use the Pick Selection List Generation program to pick the orders / items etc grouping by ship to address / location for deliveries.
However i seem unable to get this to work as the move order lines get created by item and i hit the TASK rule prior to all the lines being created on the move order.
So i have looked at wms_task_v, mtl_material_transactions_temp, mtl_txn_request_lines, attempting to join them to delivery tables, order tables etc but have had no success.