# Calculate Inventory running total

**URL:** <https://www.epiusers.help/t/calculate-inventory-running-total/58116>\
**Category:** Epicor ERP 10\
**Tags:** inventory\
**Created:** [July 25, 2019, 1:55pm UTC](https://www.epiusers.help/t/calculate-inventory-running-total/58116 "2019-07-25T13:55:01Z")\
**Posts on this page:** 1\
**Showing post:** 4

<div class="post-metadata">

**Author:** ![A.Baeisa](https://www.epiusers.help/user_avatar/www.epiusers.help/a.baeisa/32/8988_2.png) [@A.Baeisa](https://www.epiusers.help/u/A.Baeisa)\
**Post date:** [July 25, 2019, 2:14pm UTC](https://www.epiusers.help/t/calculate-inventory-running-total/58116/4 "2019-07-25T14:14:30Z")

</div>

@mchinsky  
i am not sure if this what you looking for, but this is my BAQ to calculate inventory/stock values as per selected cut off date

> [@Stock Status Report - Zero Value on Part](https://www.epiusers.help/t/stock-status-report-zero-value-on-part/43111/12):
>
> [Bev\_StockStatus.baq](https://epiusers.help/uploads/default/original/2X/c/c1d98fec577c2c67d1a79d6716c97b7a1c682e16.baq) (41.8 KB) My Stock Status BAQ to calculate Running Total On hand at any given date, and this is the query phrase in case if you are on early than 10.1.400.20 Epicor version: select [Part].[Company] as [Part\_Company], [Part].[PartNum] as [Part\_PartNum], [Part].[UOMClassID] as [Part\_UOMClassID], [Part].[ProdCode] as [Part\_ProdCode], [Part].[InternalUnitPrice] as [Part\_InternalUnitPrice], ((case when (TTLQtyToStock.Calculated\_TTLQtyToStock) is null then 0 else TTLQtyToS…

---

_[View the full topic](https://www.epiusers.help/t/calculate-inventory-running-total/58116)._