Scenario
User has an existing Transaction Saved Search showing individual items of Sales Orders. All of a sudden, they noticed that some of the formula columns in the search results stopped working and are now blank. Upon digging deeper, this was caused by a field used in the formula which is the main line Ship Date field no longer returning any values in the saved search even though the field is populated in the Sales Order.
Troubleshooting
1. Navigate to Setup > Company > Enable Features > Items & Inventory
2. Check if the following features have been recently enabled:
- Demand Planning
- Supply Allocation
- Material Requirements Planning
Note: When those features are not enabled, the Ship Date column for the individual sales order item lines in the saved search will just source the value from the main line Ship Date field in the Sales Order's Shipping subtab. If any of those three features have been recently enabled in your account, it is expected that in the search results, the main line Ship Date field will become blank for the individual item lines for all the existing Sales Orders created prior to the enablement of any of those features.
Alternate Solution
When those features are enabled, the Expected Ship Date field will become exposed for the individual item lines in the Sales Order. What you can do is to populate the Expected Ship Date line field in those existing Sales Orders created prior to the enablement of the mentioned features. Just make sure that this field is shown in your sales order form. Then, instead of using the main line Ship Date field in your saved search, you may use the Expected Ship Date line field.
Note: If those three features mentioned are not enabled at all and the main line Ship Date field is still returning blank values in the search results for the individual sales order item lines, you may submit a Support Case instead as there may be a different reason specific to your account.
-----
If you find this information useful, let us know by reacting or commenting on this post!