Inventory Transaction Types List

[A.Baeisa (Al)]

you can use this BAQ to extract the SQL code if you want as i can see you are on an erlier Epicor Version

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…