We have a sales order saved search that was working perfectly for a few years and now the formula does not work. We show the amount of business days (excluding weekends) that a sales order shipped after or before its due date. The search has always been main line= false as we want to show each line of the sales order as they sometimes ship on different dates. This was the formula that worked previously and now is not populating.
(TRUNC(To_Char({actualshipdate}-{shipdate})))-((((TRUNC({actualshipdate},'D'))-(TRUNC({shipdate},'D')))/7)*2) - (CASE WHEN TO_CHAR({shipdate},'DY') ='SUN' THEN 1 ELSE 0 END) - (CASE WHEN TO_CHAR({actualshipdate},'DY') ='SAT' THEN 1 ELSE 0 END) + 1
These are the results we used to get:
These are the results we are currently getting:
The last column is no longer populating. I'm assuming there is something that needs to be updated in the formula that was triggered by a Netsuite release possibly, as we have not changed the formula. The highlighting shown in the first picture, when the search was working, is all formula based therefore I think there is something that needs to be updated.
Here are the screenshots of the search:
