CLONE 2019R2 - Inventory Items By Vendor Orders Report - Date Shipped

As a store manager viewing the Inventory Items By Vendor Orders Report I want the Shipped Date to be represented differently when I 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 Date is populated for all rows, 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 Date if there is no ASN associated to the order? Represented as either:
  • dash, "-"
  • Null
  • Blank