Hi all,
I am looking for a way to add the customer price class to the customer list view. I am trying to do this so I can sort the customers based on the price class and also to quickly see what customers have what price classes. I am trying to add fields to the generic inquiry, however I cannot seem to get it to work. Here is how I currently have the GI set up (I have tried all different join types)
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/c674bef2-fdae-4e6c-a33f-1bc79ec454b2.png)
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/d5dc0117-8d1c-4515-a50b-69b9b526392f.png)
And here is the result I am getting
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/3ef3e4ef-1182-45b8-b0a9-b8430f5f4793.png)
Those are all the same customer. As you can see, it is just repeating the price classes for each customer.
I wouldn't mind using a report that would show this, however I cannot seem to find one. I do need to be able to export it to Excel.
Any help is appreciated!
Best answer by Kandy Beatty
View original