Sales Order SKUs need to be delivered as a raw data format, one SKU per line comprising

• Sales order number

• Parent only SKU

  • SKU Code

  • SKU Quantity

  • Child SKUs on the same line in further columns:

    • SKU Code1

    • SKU Code1

    • SKU Code2

    • SKU Code2

    • SKU Code2

    • SKU Code3

    • SKU Code4

      • (in this example, 2xSKU Code 1, 3xSKU Code 2, 1xSKU Code 3, 1xSKU Code4)

New Requirements

The SKU layouts should be as follows:

For any sales order, the SKUs which are dispatched from the warehouse should be displayed, which is 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