Skip to main content
Solved

Demand Planner - Manual Historical data

  • February 23, 2024
  • 4 replies
  • 145 views

Forum|alt.badge.img+7

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

Best answer by Richard Owen

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!

View original
Did this topic help you find an answer to your question?

4 replies

Richard Owen
Superhero (Employee)
Forum|alt.badge.img+14
  • Superhero (Employee)
  • 204 replies
  • Answer
  • February 23, 2024

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!


Forum|alt.badge.img+7
  • Author
  • Sidekick (Partner)
  • 32 replies
  • February 23, 2024

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


Richard Owen
Superhero (Employee)
Forum|alt.badge.img+14
  • Superhero (Employee)
  • 204 replies
  • February 23, 2024

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.

 


Forum|alt.badge.img+7
  • Author
  • Sidekick (Partner)
  • 32 replies
  • February 23, 2024

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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings