Can I do the following in 1 saved search? I need t...
# generalj
Jessica Blickstein
12/10/2020, 9:32 PMCan I do the following in 1 saved search? I need to show items based on following criteria: Inventory Avail is greater than or =1 at Location 1 AND Inventory Avail is =0 at Location 2. The only results I need are the item numbers. I'm horrible with expressions .
n
Netsuite Tragic
12/10/2020, 10:31 PMI did a similar search using the DECODE({inventorylocation},#,{locationquantityavailable},0) replacing the # with the inventory location will return the Available for each location. You could break this into 2 crtieria on the search
Netsuite Tragic
12/10/2020, 10:33 PMFormula (numeric) DECODE({inventorylocation},1,{locationquantityavailable},0) >= 1
Formula (numeric) DECODE({inventorylocation},2,{locationquantityavailable},0) = 0
j
Jessica Blickstein
12/11/2020, 12:14 AMThank you. Will try this!
Jessica Blickstein
12/11/2020, 3:07 PMI keep getting errors unfortunately... I believe I will need custom formulas due to custom fields.
4 Views