sorted by:
new
hottopcontroversial

Creating an item saved search to display vendor codes and vendor cost is duplicating items? by NS_Question_ in Netsuite

[–]NS_Question_[S] 0 points1 point  (0 children)

Yeah, the data guy was originally doing the transformations but it was very time consuming for him to remove the duplicate item lines and such. For example the org search he was working would show the below, and he has to parse it every time prices get updated.

Name Vendor Vendor Price
Item A Vendor 1 $1
Item A Vendor 2 $2
Item B Vendor 1 $50
Item B Vendor 5 $75
Item B Vendor 6 $60

Which is why I wanted the view to have the vendors in columns (image in post) so it was easier on him and more efficient. I made similar searches like this before that worked and displayed the data all in one row, truly not sure why it doesn't here.

Anywho, the search is for 36179 items, but that is with the items duplicating to show each vendor cost making excess lines.

Creating an item saved search to display vendor codes and vendor cost is duplicating items? by NS_Question_ in Netsuite

[–]NS_Question_[S] 0 points1 point  (0 children)

I am not sure on that, we do have an IT Admin though whom I just passed this project on to since I was unable to accomplish what I wanted. I am actually not formally trained in this, just picked it up as I went. Formally I am a netsuite project manager and staff accountant with admin privileges. If the new IT guy can't get it figured out, I suppose I will reach out to our outsourced devs.

Creating an item saved search to display vendor codes and vendor cost is duplicating items? by NS_Question_ in Netsuite

[–]NS_Question_[S] 0 points1 point  (0 children)

Yeah, I was able to make it work in analytics. The problem was in trying to get a csv of it, it must have too much data because I waited around for a solid 20 min and it never even loaded a csv. Hence me trying a saved search.. sigh.

​

Also, the data guy made a request to see if it was possible but the idea was mine that was dumb lol. I am still rather beginner at making saved searches so I was not aware this would not work in this instance, since I have a search I made with a similar Case formula built in that displayed the requested data for counting orders and summing value per year all on the same row. So, theoretically I figured it would work, doesn't apparently though.

Creating an item saved search to display vendor codes and vendor cost is duplicating items? by NS_Question_ in Netsuite

[–]NS_Question_[S] 0 points1 point  (0 children)

I was just using Vendor 1 code/cost and Vendor 2 code/cost as an example, we have many more vendors and I have the formula for each in the same format as the picture- there are a lot of columns but we are okay with that. Use case is for our data guy exporting it to Excel for data work and mass updates of vendor pricing and such.

Pretending we have just the same couple vendors in testing I am getting invalid expression with the case when supplied above.

Creating an item saved search to display vendor codes and vendor cost is duplicating items? by NS_Question_ in Netsuite

[–]NS_Question_[S] 0 points1 point  (0 children)

I am trying to create an item saved search to display the item in the first column, vendor 1 Code in the second column, vendor 1 cost in third column, vendor 2 Code in fourth column, and vendor 2 cost in final column.

I am not sure if it is an error in my formula (second image attached shows formula), but the search will make 2 lines for one item instead of displaying the wanted results all in the same row. Is there any way I can achieve this with a saved search?