We will add a custom button ‘WO Picking List’ to generate the WO Picking List on the work order record. The Header field data will be fetched from the body fields and the table data will be of the item table of the work order record.
Deliverables
- Create a custom ‘WO Picking List’ button on the work order record.
- Deploy a script to handle the button action to generate WO Picking List
Assumptions
- The item, display name, Qty required, Unit, and Source, will be fetched from the item lines of the work order record.
- Phantom source items will not have a lot number, bin number, bin qty
- The items listed under each Phantom source item will be in ascending order.
- The lot number, bin number, and bin qty will be displayed from the item record on the basis of the lot number (smallest to largest) on the 10 eligible bins you provided.
- If there are multiple bins for the same lot number, take the bin which comes first and the bin qty will be the total qty of the same lot numbered bins.
- If the ordered quantity of items is greater than the available bin qty, we will display the next available lot number, bin number, and bin qty. Still, if the bin qty is less, we will display that item row in a ‘red’ color as an indication.
Limitation
- If there are multiple bins for the same lot number, will take the bin number which comes first.
Mockup