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

not sure why I'm struggling so much with this, but making saved search and trying to create a vendor purchase price comparison form where it lists out all the vendors purchase price in columns. I've tried case WHEN {vendor} LIKE 'V0229 Pamlico Air' THEN {cost} ELSE 0 END and I have 4 columns like that with different vendors however it seems to only show the preferred vendor's pricing. I need each vendor's pricing to show (should pull from the item record under Vendors. I have given an example of what I'm looking fo

When you do an Item Saved Search there are field names for Vendor, Vendor Price, Vendor Price (Entered)

In a Saved Search, I would start with DECODE({vendorname},'Steve',{vendorcost},null). The group results by Item Name to get all results on one line.

That method is OK if you only have the same three vendors across all products.

You could try the Saved Search Pivot approach or Analytics would do the pivot.

Your decode worked great, i just had to use {othervendor} so it wouldn't just pull the preferred every time. THANKS!