Stock

Stock related solutions

Stock Snapshots
Posted ByJason VollaireDate Of Post14 February 2019ReferenceN/aProblem / SymptomVolatility in stock reconciliations have created a need to be able to identif...
Thu, 14 Feb, 2019 at 10:24 AM
Manually Adjust Factory transfers - Yield numbers
INSERT INTO                                DW_DATAWAREHOUSE.DBO.FACT_FACTORY_TRANSFERS --where actual_date_id > 11144 and plu_id = 1481 (PLU_ID, STD_ID...
Fri, 10 Sep, 2021 at 2:20 PM
Update yield - Orders vs Produced
/****** Script for SelectTopNRows command from SSMS  ******/ SELECT TOP 5 [OVP_ID]       ,[Plu_ID]       ,[Actual_Date_ID]       ,[Quid]       ,[Order_...
Fri, 10 Sep, 2021 at 2:21 PM