Hi there,
I have created a GI to know the qty beg, qty in/out and ending qty during a date range. I only use one table INItemSiteHistDay
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/94c030ec-5e9d-4b47-8bb0-00fda9ac0c8b.png)
- Before I group by InventoryID and SiteID:
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/b62ffd15-5048-49f0-a8de-259f7c485625.png)
I expect to only show one line as below, but when I group by inventory ID and siteID, then I select the max Date, but Qty Beg and Ending are sum up, the Qty In or Out is correct. I do not know how to take two values from 2 rows: qty beginning of date from and ending qty of date to.
- After grouping
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/da1a9554-9ea0-46dc-94bb-9513af95ec1d.png)
My parameter:
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/402df52f-37cd-4dfb-88d2-b27d13c50c3c.png)
If you have any idea, pls advise me how to achieve it.
Thanks, in advanced.
Best answer by bryanb39
View original