Hello,
The initial brief was as follows:
Show all items where itemclass in (spareparts, lvspareparts) and use date range.
Fields to show:
Inventory ID, Inventory Description
Total Sales for date range
Total qtyonhand all warehouses (just the total holding like on stock items page)
Total transferred over date range
Last invoiced date
Last Cost
On the results we are getting some larger numbers, and not all the QOH look right, any idea on how to improve on the results here?
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/29cab90c-648b-46c9-a0c1-7a87b5aa9909.png)
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/20b13b82-ba14-4676-a1aa-7699e4d81cb0.png)
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/845a56c6-154d-4d0e-a9b6-a3d22dbda8c0.png)
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/6d77e0a4-3ccf-4884-a58d-79f0bba7dbab.png)