Hi,
I got an issue regarding importing the historical data to D365FO for it to be used in generating the baseline forecast.
Say I have the following info imported:
Item A ------- WH1 ----------- 10 pcs ------------- 4/1/2020
Then when imported in D365FO and generate the demand forecast I don't get any issue.
But whenever I wanted to use the same item for importing the historical demand data, seems like system is adding up the value of the new lines imported, say:
Item A ------- WH1 ----------- 15 pcs ------------- 4/1/2020
So when I generate baseline forecast, system reads the historical data as 25 derived from (10 +15) and definitely doubles my forecast.
Is there any way I can clean-up the table on which the historical data is written whenever we do an import?
Regards,
RIEL