Hi,
I am not getting the correct results of the below line items, kindly help me to validate the below formulas:
1. Forecast Demand : 'DEM03 Demand Forecast'.Final Forecast
2. Shipping Time Weeks: 'DAT02 Shipping Metrics'.'Shipping Time (Weeks)'[LOOKUP: 'Temp - P2 Product', LOOKUP: Shipping Method]
Thanks!
Solved! Go to Solution.
1. The value which I am getting is 2025 and what is available in "Page Review the INV01 Line Item Formulas and Summary Method settings" is 2048.
2. Bingo, I was referring the incorrect module - Thanks a lot!
Any update?
Hi @sharmagh
The value of Forecast Demand in INV01 references Final Forecast in DEM03 which in turn depends on Override, So check that out.
The 2048 is the number based on the initial data loaded from the files, but if you make any changes to this period then the Forecast Demand will be different.
In summary, having a different number doesn't mean you have the wrong formula, it is most probably due to changes in input data