select psfa.skuForecastAdviceId, psfa.forecastAdviceId, s.skuId, s.sku, s.skuDesc, m.firstName, m.lastName, m.phone, m.phoneExt, m.email, psfa.adviceDate, psfa.partnerComments, psfa.forecast_year, psfa.forecast_qty_01, psfa.forecast_chng_01, psfa.forecast_qty_02, psfa.forecast_chng_02, psfa.forecast_qty_03, psfa.forecast_chng_03, psfa.forecast_qty_04, psfa.forecast_chng_04, psfa.forecast_qty_05, psfa.forecast_chng_05, psfa.forecast_qty_06, psfa.forecast_chng_06, psfa.forecast_qty_07, psfa.forecast_chng_07, psfa.forecast_qty_08, psfa.forecast_chng_08, psfa.forecast_qty_09, psfa.forecast_chng_09, psfa.forecast_qty_10, psfa.forecast_chng_10, psfa.forecast_qty_11, psfa.forecast_chng_11, psfa.forecast_qty_12, psfa.forecast_chng_12 from tbl_MFR_TPF_PartnerSkuForecastAdvice psfa inner join tbl_MFR_TPF_PartnerForecastAdvice pfa on pfa.forecastAdviceId = psfa.forecastAdviceId and pfa.ownerId = psfa.ownerId and pfa.ownerType = psfa.ownerType and pfa.recordType = 'ADV' inner join tbl_FSpro_members m on m.fspro_userid = psfa.partnerContactId and m.orgId = psfa.partnerId and m.orgType = psfa.partnerType and m.ownerId = psfa.ownerId and m.fsl_tablecode = psfa.ownerType inner join tbl_PRD_Skus s on s.skuId = psfa.skuId and s.ownerId = psfa.ownerId and s.fsl_tablecode = psfa.ownerType where psfa.skuId = and psfa.disposition = '?' and psfa.ownerId = and psfa.ownerType = and psfa.partnerId = and psfa.partnerType = 'OPR' order by psfa.adviceDate desc, psfa.forecast_year asc

Below is the volume forecast advice by year and month provided by the customer.

Change the status to ''Closed'' to indicate that you have reviewed the volume advice provided by the customer and have applied it to their working forecast as necessary.

#sku# - #skuDesc#
Source: #firstName# #lastName# on #LSDateFormat(adviceDate)#
Status:
#partnerComments#
#colIdx# Total
#forecast_year#
#qty#
+#chng#&##160;
#totalAdvice#
+#totalChange#&##160;

The top number for a given year and month is the actual case esitmate provided by the customer. The bottom number if present, represents the change made by the customer.

e.g. A top number of 475 and a bottom number of +20 means that the customer advice is to use a forecast of 475 and that forecast was value was obtained by increasing current forecast as of the advice date by 20 cases.

Submitting this dialog only changes the status of the customer provided advice. It does not change the working forecast.