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

does anyone have any tips on how to reference an item’s UOM conversion rate on an item saved search?

If you know what the conversion is express it numerically perhaps?

So ive done this in the past by adding a field to the item to do the conversion. Then use it in my formula. However it was a pretty simple model from a UOM standpoint where they basically transacted in just two levels

It was a case statement formula that essentially said when uom is not base unit then divide quantity by 
Modifier field else quantity end

oh that’s a good thought! i am really just wanting to say the item is available at a base unit (one each) at $X while it’s also available in a carton of say 6 at $Y

Isn't that a function of quantity breaks on pricing?

I don't remember what we did for that, but I know we did something.

well it’s an item that we buy as a carton of 6 from our supplier but we (at least for now) default to selling the base unit of 1 of those 6. i just want to be able to express both price points in a saved search which ultimately ends up on a printed PDF. i think that custom field might work