Bin Inventory Report by Day

[A.Baeisa (Al)]

@pilio.lee
try this BAQ, will give you what you want but per entered parameter day, see if you can modify it to a pivot one instead

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…