I’m having ongoing issues getting the AI forecasting to use historical sales data. No matter what I try, the historical data is not being considered when I run the forecast update.
I have followed Microsoft’s guidance and imported the data in multiple ways, including:
Item Journals
Sales Item Journals
I have successfully loaded three years of historical data, and this is a seasonal industry, so there should be more than enough data for the AI to calculate a forecast. However, when I run the forecasting update, it behaves as if there is no historical data at all.
I have been working with Microsoft support on this issue for over six months, and they are still unable to explain why the historical data is not being picked up by the AI forecasting engine. They do have my data and said there is nothing wrong with it.
At this point, I’m reaching out to the wider community to see if anyone else has experienced a similar issue when importing historical data and using AI forecasting in Business Central. If anyone has found a workaround, configuration setting, or underlying cause that Microsoft may have missed, I would be extremely grateful.
The situation has become quite urgent, as the clients are understandably very upset that this functionality is not working as expected.
Any insight or advice would be very much appreciated.
