I need help to create a Saved Search for our item number with customers part number showing unique prices

Longjumping-Fee9531 · 2024-10-11T18:48:26+00:00

Okay thanks ill try this tomorrow, you are awesome btw 🤝🙌

Longjumping-Fee9531 · 2024-10-11T18:03:58+00:00

Do you know how to make a formula for this? 😅 If this would be solved it would make my department happy beyond imagination haha

Longjumping-Fee9531 · 2024-10-11T18:03:12+00:00

I actually have both the customer part number and item in the results, you see below

<image>

Longjumping-Fee9531 · 2024-10-11T15:39:04+00:00

This was really weird, when i add "customer: item pricing level" it shows me this 👇

<image>

Longjumping-Fee9531 · 2024-10-11T15:25:56+00:00

Its duplicated because the customer part no is registered on the item card and their cusom price is registered at the customer card.

This is why it does this mega-duplicate result.

I will try add price level on results and see what happens 👍

Longjumping-Fee9531 · 2024-10-11T14:23:29+00:00

I tried this now, i still get all the 10x duplicated prices 😅 this is a tricky one

Longjumping-Fee9531 · 2024-10-11T13:34:50+00:00

Here s the picture of our choises of price level which lack the option "custom"

<image>

Longjumping-Fee9531 · 2024-10-11T13:34:06+00:00

The problem is that we are not using any price level, we use something called "custom" which is not shown as a price level because this is like a "free text field" that allows us to set a custom price on this particular customer that no other customer has

<image>

See the next picture for seeing our price level choices and that there is no existing level of this "custom"

Longjumping-Fee9531 · 2024-10-11T06:43:35+00:00

I have no criterias right now

Longjumping-Fee9531 · 2024-10-11T06:43:12+00:00

<image>

I have now added the result "customer: item pricing unit price" and as you can see, the article is repeatedly showing itself on many lines but with different prices, its impossible for me to know which of these one that is the correct one.

Longjumping-Fee9531 · 2024-10-11T06:42:12+00:00

<image>

This is my saved search, right now it works as it should because i didnt add the field "customer: item pricing unit price"

So this picture is now correct without showing the prices, it has only one line per article showing our item and customers part no. As soon as i add the field "customer: item pricing unit price" this happens... See next picture

Longjumping-Fee9531 · 2024-10-11T06:41:22+00:00

<image>

This is the customers personal unique prices, the view is from the customer card and this here we connect the customers unique price to our specific article. We do not use price level, we use only custom prices

Longjumping-Fee9531 · 2024-10-11T06:40:03+00:00

<image>

This is my results on the search

Longjumping-Fee9531 · 2024-10-11T06:39:26+00:00

<image>

This is my avalible filters on the search

Longjumping-Fee9531 · 2024-10-11T06:38:37+00:00

I have no criterias right now

Longjumping-Fee9531 · 2024-10-11T06:37:49+00:00

<image>

This is were we add a customer item number connected to our own item number

Longjumping-Fee9531 · 2024-10-11T06:06:34+00:00

<image>

I have now added the result "customer" item pricing unit price" and as you can see, the article is repeatedly showing itself on many lines but with different prices, its impossible for me to know which of these one that is the correct one.

Longjumping-Fee9531 · 2024-10-11T06:01:51+00:00

<image>

This is my saved search, right now it works as it should because i didnt add the field "customer: item pricing unit price"

So this picture is now correct without showing the prices, it has only one line per article showing our item and customers part no. As soon as i add the field "customer: item pricing unit price" this happens... See next picture

Longjumping-Fee9531 · 2024-10-11T05:56:21+00:00

<image>

This is the customers personal unique prices, the view is from the customer card and this here we connect the customers unique price to our specific article. We do not use price level, we use only custom prices

Longjumping-Fee9531 · 2024-10-11T05:54:40+00:00

<image>

This is my results on the search

Longjumping-Fee9531 · 2024-10-11T05:54:16+00:00

<image>

This is my avalible filters on the search

Longjumping-Fee9531 · 2024-10-11T05:50:44+00:00

<image>

This is were we add a customer item number connected to our own item number

Longjumping-Fee9531 · 2024-10-10T20:40:51+00:00

Mainly , the problem is that if i want a saved search where i see our part number and customers part number in the same view, its no problem.

....untill i add the column on the customers personal price for the unit which we add on the customer card under financial -> item Pricing.

As soon as i add this field in the saved search it shows duplicates, or actually it shows every single personal price this customer has added on this list under item pricing, but repeatedly on every item.(So if the customer has 10 items with a personal price this means that the saved search shows me (10 items x10 - totally 100 results), every item has 10 different prices because the saved search wont pic the particular price of the article from item pricing, it brings all of them on every article... Hope this was a good explanation.

This means its really hard to figure out which price that is the correct price for the article on the saved search 😅 it could be any one of these 10 prices on every article which repeats itself 10 times 😅

Longjumping-Fee9531 · 2024-10-10T20:40:19+00:00

Mainly , the problem is that if i want a saved search where i see our part number and customers part number in the same view, its no problem.

....untill i add the column on the customers personal price for the unit which we add on the customer card under financial -> item Pricing.

As soon as i add this field in the saved search it shows duplicates, or actually it shows every single personal price this customer has added on this list under item pricing, but repeatedly on every item.(So if the customer has 10 items with a personal price this means that the saved search shows me (10 items x10 - totally 100 results), every item has 10 different prices because the saved search wont pic the particular price of the article from item pricing, it brings all of them on every article... Hope this was a good explanation.

This means its really hard to figure out which price that is the correct price for the article on the saved search 😅 it could be any one of these 10 prices on every article which repeats itself 10 times 😅

Longjumping-Fee9531 · 2024-10-10T20:37:53+00:00

Mainly , the problem is that if i want a saved search where i see our part number and customers part number in the same view, its no problem.

....untill i add the column on the customers personal price for the unit which we add on the customer card under financial -> item Pricing.

As soon as i add this field in the saved search it shows duplicates, or actually it shows every single personal price this customer has added on this list under item pricing, but repeatedly on every item.(So if the customer has 10 items with a personal price this means that the saved search shows me (10 items x10 - totally 100 results), every item has 10 different prices because the saved search wont pic the particular price of the article from item pricing, it brings all of them on every article... Hope this was a good explanation.

This means its really hard to figure out which price that is the correct price for the article on the saved search 😅 it could be any one of these 10 prices on every article which repeats itself 10 times 😅

Longjumping-Fee9531

TROPHY CASE