I have entered Manual Historical Demand Planning Data on a Part.
The Part is also displayed in DP, but the Manual Historical Demand Planning Data not.
I have already run the Complete DP Data Refresh job.
Where is the error? Thanks for your help.
Demand Planner - Manual Historical Demand Planning Data
This topic has been closed for comments
Userlevel 4
+8
Hi
Yes we can use manual historical data to be displayed in Demand plan client.
In order to do that you need to define proper base flow SQL.
The view is either comb_ext_inv_part_issue_pub or hist_ext_invent_part_issue the latter is only the manual historical data recs, the first is a join between the manual data and customer order (external_invent_part_issue_pub).
Userlevel 5
+12
Hi,
It may be because you have to re-aggregate the newly imported demands into the previously closed DP periods so that the demands can be seen and used when the Create Forecast job is run.
Some things to try ...
- Go into the Forecast Parts screen and search for the Base Flow associated with your part (81731). There may be several records (Base Flow and Combined Flow)
- Select the Base Flow and change the Aggregation Type = ‘Recalculate Historic Demand’ and press SAVE.
- Run the Create Forecast Job
Thanks for the help. The historical data is now in the Demand Planner.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.