This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

need some help with a basic transaction saved search, need to filter to only show negative inventory adjustments at the line level, i have it working to show all adjustment + and -, but when I filter to only show when quantity less than 0 i get no results even though there are plenty of negative adjustments

Try using a formula numeric
CASE WHEN {quantity} < 0 THEN 1  END
With The criteria is equal to 1

If you are looking at Inventory Detail.... use {ItemCount} instead not {Quantity}  took me ages to figure that out and finally replace all my case statements... they get squirrely with bin transfers...

CASE WHEN {transaction.type} = 'Item Fulfillment'THEN -{quantity} WHEN ( {transaction.type} = 'Inventory Adjustment' and {transaction.quantity}&lt;0) THEN -{quantity} ELSE {quantity}END

became just:
(Item_count)

image.png

Thanks, I tried adding Item Count but not seeing that field available on the search. We are not using advanced bin management so i wonder if thats why it's not showing.

yes that sounds like why... case statements it is... lol