Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
How to marry 2 different search formulas in a single Saved Search?
Goal is to create a Saved Search to compute Safety Stock Level. Trying to combine two formulas and unable to determine how it should be constructed. I created two test searches to verify my formulas work, as follows:
Search 1 (Item Search): Avg Qty Sold/Day - Summary Type: Average, Function: Round
using formula:
To_char({transaction.quantity}/{custitem_nsacs_uomconvrate}/182.5)
Search 2 (Transaction Search): Avg Days to Receive - Summary Type: Sum
using formula:
CASE WHEN {recordtype}='purchaseorder' THEN {fulfillingtransaction.trandate}-{trandate} ELSE NULL END + 14
These work great individually. However, I wish to combine these two saved searches into one and cannot get it to work. Still fairly new to this.