...
For any sales order, the SKUs which actually go to are dispatched from the warehouse are necessary to should be displayed, which is as follows:
SKU Types
A Sales Order can comprise of
lines where there is a parent SKU and child SKUs of the parent
lines where there is only a parent SKU and no child SKU
Lines where there is a parent SKU and child SKUs of the parent
In the case of lines where there is a parent SKU and child SKUs of the parent, only the child SKUs need to be extracted.
Lines where there is a parent SKU only
In the case of lines where there is a parent SKU only, the parent SKUs need to be extracted.
Total of each SKU
The total quantity of each SKU across a Sales Order needs to be shown for each a list of SKUs and SKU quantity per Sales Order. The best way to achieve this could be from a join to the dispatch table of the warehouse for that Sales Order.
Layout
Sales Order Number (External Ref)
SKU
SKU Quantity
...