Difference Between Actual Ship/Receipt Date and Actual Ship Date in a Transaction Saved Search

In transaction saved searches, the Actual Ship Date and Actual Ship/Receive Date is different.

The “Actual Ship/Receipt Date” (internal ID = actualshipdate) focuses per Line item level while the other field (internal ID = transhippeddate) uses the last date of item fulfillment for the sales order. Consider the following Sales Order:

  • 1st Line item = Item X, Item Fulfillment date = June 01, 2021
  • 2nd Line Item = Item Y, Item Fulfillment date = June 05, 2021 
  • 3rd Line Item = Item Z, Item Fulfillment date = June 03, 2021 

Results:

  • Column of “Actual Ship/Receipt Date” (internal ID = actualshipdate) will show the dates June 01, June 05, and June 03 for items X, Y, Z, respectively.
  • Column of “Actual Ship Date” (internal ID = transhippeddate) will show June 05, 2021 for all items.

Leave a comment

Your email address will not be published. Required fields are marked *