I m trying to create an item saved search that shows all my NetSuite Professionals #general

I’m trying to create an item saved search that sho...

AI1

04/05/2023, 2:41 PM

I’m trying to create an item saved search that shows all my pricing and items with no pricing If I add the columns Name, Description, Base Price to the results then I get 150 items (which is correct) But when I add the pricing: price level and pricing : unit price columns it limits the list to 70 items Why doesn’t it show all 150 but the pricing data is blank for some? I’m not adding anything regarding pricing in the criteria just the results

David B

04/05/2023, 10:09 PM

This is a known limitation with saved searches. When you add joins to your results (or criteria), records where those joins don't exist (in your case, items without pricing) don't appear in the search results. (cont.)

David B

04/05/2023, 10:14 PM

I believe you're also saying that of the remaining 70 items on the search results, some of them have no data in the

Pricing : Price Level

and

Pricing : Unit Price

columns? That's a tricky one as you've said you haven't added any of the Pricing join-fields to the criteria. If you had filtered by some of the pricing fields (for example the Price Level field), then you could get blank results for Price Level and Unit Price. Consider this example: Your search is has a criteria for Price Level = Base Price, but you have an item "item A" that only has a unit price for Price Level "Online Price". Item A would show up in the results, even though unit price would be empty for the "Base Price" Price Level.

David B

04/05/2023, 10:14 PM

Anyway, to solve this, you could switch to using either a SuiteAnalytics workbook or SuiteQL (depending on your use case)

AI1

04/05/2023, 10:33 PM

I guess that isn’t really my experience. If I make an transaction search and add the applying transaction join I get results of transactions with applying transactions AND with no applying transactions.

AI1

04/05/2023, 10:33 PM

The results fields have never acted as a filter to my results until trying to join to pricing. Which is weird

David B

04/05/2023, 11:53 PM

I agree it's weird. I struggled specifically with the Item > Pricing join multiple times in the past. But yes, this behaviour is not exhibited everywhere, but I have also seen it in other item joins (a few Item > Custom Record ones). Maybe it's only an issue with Item saved searches, which would be weird. Best solution I've found is to either pivot to a SA workbook, SuiteQL, or join multiple searches via script

AI1

04/06/2023, 12:49 AM

Yeah that could be it. Maybe something with the way NetSuite is creating/linking records in specific instances. Thanks for you insight this was very helpful. I’ll try a Pivot in SA

4 Views

Open in Slack

Previous Next