Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
saved search to show transaction with quantity greather than x from a manufacturer
Hi,
I am looing to create a saved search that shows me the following on sales orders
Items from the same manufacturer (custom dropdown field) that total to mare than 2 cases (transactions list by each, but item record custom field that shows how many items per case), and also at the base price level
Example
Item abc1 quantity 15 price level 'base price'
Item abc2 quantity 12 price level 'base price'
quantity per case for each is 12, thererore 2.x cases from that manufacturer all at base price.
I want to see this in the search results but nothing else that is either less than 2 cases from the same manufacturer or price other than 'base price'.
0