Hi,
I have this existing Generic Inquiry and I added in the Selling Price Sales Price which comes from the ARSalesPrice Data Class and the Data Field is SalesPrice in as I need to see the Sales Price on each Stock Item.
The Table joins & relations seem to be ok as I am seeing the correct Sales Price on the Stock Items and now it is creating a double line items for each Stock Item and I am not sure how to Group or create a group on the Field and then create a aggregate function such as MIN to fix if that is the solution I read on some other posts if that is even the solution.
Any help would be great. I have attached some screen shots.
Thanks.
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/55d130f3-bba0-41c5-933f-d0911479deb7.png)
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/c73b55ab-da14-44f3-8fb6-6cdacfecdf2c.png)
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/5a7deb45-c18c-47a1-b779-c2d3496bd5f4.png)
Best answer by Laura02
View original