CLONE 2019R2 - Inventory Items By Vendor Orders Report - ShippedQty

As a store manager viewing the Inventory Items By Vendor Orders Report I want the Shipped Quantity to be represented differently when I have an ASN has not been applied to an order so that I can identify differences between those orders that where processed by an ASN and those that were not

• Currently the Shipped Quantity is populated for all rows, most likely from the Shipped Qty that we store, when in fact it should only be populated when an ASN is processed against the order
• I think that we identify that an order has an ASN against it using:
  • tbTransactionSupplyOrder > DistributionGoodsDispatched = 1, if = 0 then no ASN
• Is it possible, in the download file to present a Null value in the Shipped Qty if there is no ASN associated to the order? Represented as either:
  • dash, "-"
  • Null
  • Blank