Hello all,
I’m working on a generic inquiry. I need a total inventory amount for each item. The result as below.
The item existed in different warehouse.
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/c2644527-8faa-4b0a-96c5-40cf073adcc5.png)
When I add a grouping for InventoryID. The result become to :
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/3adfab02-d77f-405f-8232-47bb442231f5.png)
My question is how do I ignore grouping on MSRP column?
My GI setting is below.
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/e07b3bdf-72dd-4b00-9a43-838523c21580.png)
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/c714a639-64bc-4427-8b0e-7a322073ada8.png)
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/66460b05-a575-41a7-a0bb-7ce732996b25.png)
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/33fdf59a-6545-4ea2-8669-344f318721a1.png)
Best answer by wfilipiak67
View original