Hello everybody,
Our business is B to B distribution. All our customer pay custom prices for items they purchase from us. (The same item can sold to 10 different customers at 10 different prices). All these prices are stored in each customer page in the Financial / item pricing sublitst.
Now all these customers also use their own naming when they purchase these items from us, which are stored in the Customer Part Number record in NS.
I am basically desperate to have a saved search that pulls both these informations (CPN + item pricing) for a given item.
I tried a customer saved search but I cannot access item fields or CPN fields in the results.
I tried an item search but i cannot access Customer fields in the results.
When I run a CPN saved search I do have access to "customer fields / item pricing unit price" but it ends up with a strange result with wrong data and too many lines, as if the search could not match the item to the item pricing field from customer page.
I hope I am making sense, has anyone come accross such problems ? I think it is a huge weakness from NS to not be able to gather these data.
Thanks in advance for any help available,
Best regards,