How to split lines based on condition in Business Central Report

xhirvanaxhirvana Member Posts: 6
edited 2022-07-29 in NAV Three Tier
We have this packing list report that we need to put pallet no. Column. Per sales line. Ex. Is that if we have an item no. With 1000 qty, if this item has 200cases per pallet,the item needs to split into 5 lines with qty 200 cases and with pallet no. 1 to 5. This will repeat for all the sales lines given the no. Of cases per pallet as maximum qty per line. Kindly help me with this one please...🙏. Thank you.


This discussion has been closed.