Scenario
User wants to know how they could show the difference between the dates of when the Sales Order was created and when the Sales Order was fulfilled via a Saved Search.
Solution
To calculate the days between the date the Sales Order was created and the date it was shipped, you can try the following below:
1.Navigate to Reports > New Search > Select Transaction
2. Click Create Saved Search button
3. Under the Criteria, select the following:
- Type = Sales Order
- Fulfilling/Receiving Transaction : Type = Item Fulfillment
4. Under Results tab, you can add or remove preferred fields. To compute the difference of days:
- Add Formula (Numeric) field then on the Formula column = TRUNC({transhippeddate} - {datecreated})
5. This is how it looks like when you Preview the search:
-----
If you find this information useful, let us know by reacting or commenting on this post!
