Calculate Inventory running total

[A.Baeisa (Al)]

@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

Bev_StockStatus.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…