select top 12 timeframeId from tbl_DW_Timeframes where ownerid = and ownerType = and periodCode = 'FM' order by fiscalYear desc, weeksElapsed desc select skuId, convert( int, sum( forecast_qty ) / count(*) * 12.0 * ( #_monthsToAverage# / 12.0 ) ) avgSales from tbl_MFR_TPF_Detail#_tpfSuffix# where mfr_id = and forecast_status = 'A' and tpartnerType = 'CDR' and tpartnerId = and productLevel = 'SKU' and skuId is not null and timeframeId in ( ) group by skuId having (sum( forecast_qty ) / count(*) * 12.0 * ( #_monthsToAverage# / 12.0 )) between and select -1 avgSales ,qmd_stockingGuide.#_c# from qmd_stockingGuide where skuId in ( ) select qmd_skuSales.avgSales ,qmd_stockingGuide.#_c# from qmd_skuSales, qmd_stockingGuide where qmd_stockingGuide.skuId = qmd_skuSales.skuId select * from qmd_stockingGuide order by product, sku
&##160;

Stocking		 SKU Pack Dst. SKU #attributes.monthsToAverage# Month
Average
&##160;#htmleditformat( product )# - #htmleditformat( productDesc )#(#lsnumberformat( _skuCount )# skus)
YN #htmleditformat( packSizeDesc )# #htmleditformat( customerSku )# &##160;<1#lsnumberformat( avgSales )#
No SKUs matching the search criteria above were found.

Loading, Please wait...

 #_portletBodyHTML#