How To: use Final Stock calculation as Initial Stock in Load Script
Hi all,
Im new in QS and i need to create an inventory with an initial stock from 201801 onwards .The problem is that i need to calculate te final stock for that period and use it as the iniStock for the rest. I cant do it in the app directly because i would have to insert every prev-period calculation in the new final stock and that as you already know, is completelly unefficient.
After all calculations, the table with my final inventory looks like this:
INV_CFS_KU_Temp:
LOAD
YEARMONTH_Stock_Initial,
[BLEND],
[IniStock.ActQt] as IniSotck_Blend_KU,
CompraKG_Blend,
InterStockKU_Blend,
Consumo_Blend,
InterStockKU_Blend - Consumo_Blend as FinalStockBlend
Resident InventarioCFS_KU ;
Drop Table [InventarioCFS_KU];
I have the results i need for the firt period, but the problem, i should not be taking the IniStock for each period but the final form the prev period.
Sorry if im not explain very well, hopefully somebody have an idea to do this.
