does netsuite have any other formula function in s...
# generalk
Kevin Cook
02/10/2021, 5:07 PMdoes netsuite have any other formula function in save search similar to case when? or is that it? like for each ?
p
PNJ
02/10/2021, 5:10 PMforeach doesn't really make sense in set-based things, I think. There's
DECODE()k
Kevin Cook
02/10/2021, 5:11 PMi have multiple warehouse; when i run a save search of sales orders that dont have items committed, on my results pafe I am trying to see only the inventory in one warehouse; formula is as follows:
CASE WHEN {inventorydetail.location}='Baxter Warehouse' THEN {item.quantityonhand} ELSE 0 END
Kevin Cook
02/10/2021, 5:12 PMbut it always returns 0. Basically I want to say "for this result return the quantity on hand at this location
s
scottvonduhn
02/10/2021, 5:16 PMCreate a formula result column with just
{inventorydetail.location}k
Kevin Cook
02/10/2021, 5:18 PMinventory detail location returns null
Kevin Cook
02/10/2021, 5:21 PMthere is the beginning of the problem! inventory detail location isn't a field with values but location is! I just need to get it to now limit to just the one location
Kevin Cook
02/10/2021, 5:23 PMSo i have this now:
CASE WHEN {location}='Baxter Warehouse' THEN {item.quantityonhand} ELSE 0 END
but it is still pulling from all locations
Kevin Cook
02/10/2021, 5:24 PMi think after my THEN I need to specify only the one location?
g
Gregory Jones
02/10/2021, 5:30 PMYou may want to try adding the location to the criteria of the saved search, as opposed to the results
k
Kevin Cook
02/10/2021, 5:32 PMi tried that; still getting two when I know i only have one
Kevin Cook
02/10/2021, 5:39 PMi got it! It was {item.locationquantityonhand}
Kevin Cook
02/10/2021, 5:40 PMthe only tricky part left is that I am getting a result for every line item of my sales order instead of just the one time
Kevin Cook
02/10/2021, 5:56 PMsorry; its not for every sales order line item; it is evaluating for every warehouse location
g
Gregory Jones
02/10/2021, 6:20 PMHave you tried using the {item.locationquantityonhand} in the criteria and setting that to the location you're looking for in your formula? If that works, then I don't think you would need to use the formula...
k
Kevin Cook
02/10/2021, 6:26 PMyou got it!
Kevin Cook
02/10/2021, 6:26 PMthank you!
peanutbutterjellytime 1
g
Gregory Jones
02/10/2021, 6:31 PMAwesome! Glad it worked out
3 Views