My customer receives frozen raw meat in variable weights pallets, these are stored in a freezer location (each pallet in an individual d365 location). These products are consumed in a production process where pick lists are generated (advanced warehouse- A batch order is created and released to the warehouse a pick list is created). To facilitate their physical process, the customer has requested that the pallet that will NOT be fully consumed, is 'placed' at the bottom of the pick list..

Here is an example: Imagine that D365 has calculated 4300 LB requirement of frozen meat for a given batch order. In this example, it will create 6 work IDs to fulfill the requirement. All work IDs will be FULLY consumed into this batch other, EXCEPT the one for LOC FZ1-C0210, which only 619 of 1000 Lbs will be consumed and remaining qty (381) will be returned to the freezer. The requirement is that the work ID for this location is "placed" at the bottom of the pick list.

I haven't found a way to configure the work template or location directive to achieve the result above.

I was able to achieve the need for standard weight products, where my location directive would be ROUNDING UP per unit (CS) and that would create excess inventory qty on the work line (which is a field that i can sort by on the work template).

I could configure similarly and use the location directive to round up to LB as well, but that would create a different problem. The issue is when you LP qty is insufficient to round up, it will force the work qty to round down. Example, an LP with 1318.81, cannot round up to 1319, so it will round down to 1318, leaving 0.81 OUT of the work. I could use Consume full LP to guarantee that all LP qty is consumed, but that would create another 'exception' scenario for the floor user, which is not ideal.