Skip to main content

Hi,

For a forecast Part I have entered data in ‘Manual Historical Demand Planning Data’ page. I did run the jobs ‘Aggregate Daily’ and ‘Create Forecast’ which were okay without errors.

However when I check for the Forecast part → Historical data tab, I cannot see any of this data and historical values are shown as 0 even in the Demand Planner Client (Forecast tables values are all 0)

 

This is my sql I have used Combination of Historical data + External issues, I guess this is correct.

Version I am working on - 23R2

What am I missing? Appreciate if someone can guide me in the right direction

 

Kind Regards

Yashodha

Hi Yash,

Take another look at the Base Flow SQL … I think you need to express it like this.

This is because you have ‘Ship Date’ and ‘Shipped Qty’ in your historic transactions which matches to ‘Issue Date’ and ‘Issue Qty’ in the SQL 😀

Good luck!

Hi @Richard Owen this worked !

Thanks so much !!!

One more question, Is it possible for me to round up my forecast ? I would like to see the forecast without decimals. (I have set up my lot sizes all as 1 as well, but no chage)

 

Kind Regards

Yashodha

Hi Yash,

That’s great news!

In IFS Cloud 23R2 you can set the decimal precision per user here

I can’t quite remember the old DP Client functionality, but have you tried the RMB option in the ‘Detail’ section or Forecast Table?  Perhaps there are some possibilities to change the decimal precision there.

 

Hi Richard,

Yes it worked :)

We can still use the RMB even in 23R2.

Thanks a lot for your explanations. much appreciated !

 

Kind Regards

Yashodha

Reply


Terms & ConditionsCookie settings