I have a saved search that lists all Sales Order item lines (not the main) and the Ship Date which comes from the main line.
This used to work but since we enabled Supply Chain Allocation in our account, I only get the Expected Ship Date from the line.
The problem is that I am using a non-inventory clearing location for Special Order lines and this causes the Expected Ship Date to always be blank.
Even if I turned on inventory on that location (which I don't want to do), the Expected Ship Date would automatically be filled in based on the related purchase order, not based on the Ship Date from the main line.
This has been asked many times around the internet, usually by users who have the Demand Planning feature enabled. (see also the discussion on this community: Ship Date on Saved Search, the response there doesn't match my experience). One of the ideas posted online was to use a SQL statement in a formula field which seems to work for some users but not for me.
Here's the Stack Overflow discussion: How can I include the main line ship date in line item results for a sales order saved search? and here's the formula they suggest to use:
MIN/*_*/({shipdate}) OVER (PARTITION BY {internalid})
I suppose I can use different fields, sourcing, workflows and what not. My question is: is there no "normal" approach to this issue?