Unsure how to approach this one so reaching out for some help with which direction i should go with this….
We have a configured product, once this product is configured, sold and then released for manufacture, we then ‘stack’ the product (we take the lenghts and quantities of our product from UD01 and then add them to pallets, the pallet records are stored in UD03)
some times there are too many pallets to fit onto one lorry so we need to split the delivery across multiple lorries.
I would like to be able to display on the pack slip which pallets are on that lorry at the moment just that pallet reference would be good but if i can also include the contents that would be even better (this i am certain will be a simple group by on the SSRS)
the bit i am unsure of how to complete is say if the delivery has 2 lorries, pallets 1,2 and 3 are on lorry 1 and pallets 4-7 are on lorry 2, how to i specify this?