How to Reforecast Group of Products
1) Backup files.
At minimum back up files K_PRODUCT, K_PRODHIS (monthly or 13 four weekly), and/or K_PRODH52 (weekly).
2) Set the first sales year and period.
Call program K3S_5OBJ/K3S_3034FX with PARM of ‘Y’. This will ensure the 1st sales period (PR_FSTSLPR) and 1st sales year (PR_FSTSLYR) fields in K_PRODUCT are in sync with history.
3) Re-set values in K_PRODUCT and create unique group code to identify products to reforecast.
Run the following SQL:
UPDATE K3S_5DTA.K_PRODUCT set pr_forcast = 0, pr_fordevp = 20, pr_seasonl = ‘ ‘, pr_forserr = 0, pr_sysstat = ‘N’, pr_group1 = ‘MYGROUP’
4) Re-forecast the products.
Program K3S_3037CL will need to be called for each location if the product span multiple locations.
CALL K3S_5OBJ/K3S_3037CL with 4 PARMs of COMP, LOCN, GROUP1, LOGYN
Comp = ‘Z’ Locn = ‘ZZZ’ GROUP1 = ‘MYGROUP’ LOGYN = ‘Y’
