Hi everyone,
I work in a small-medium sized company and wanted to start using the "Planning Worksheets" for inventory management. However in order to do so I need to have sales forecast in the system.
I've gone to "Demand Forecast" and have read and followed the instructions found here: https://docs.microsoft.com/en-au/dynamics365/business-central/production-how-to-create-a-forecast
Our company has around 40 finished goods SKUs that we sell and we have 12 month rolling forecasts. That's around 480 cells of forecast information to enter manually into the "Demand Forecast Matrix" which could potentially change each month when forecasts are updated.
As our 12 month rolling forecast information is currently in Excel is there a simple way to upload/paste this information into the "Demand Forecast Matrix"?
I've managed to get click the "Edit in Excel" button on the "Demand Forecast Entries" but I'm not able to publish the changes I make in Excel - I get the following error message: 'Entity does not support insert. CorrelationId: 3b5a3063-fd15-4483-bea6-6cc233b5f8ed.'
Currently using Version: US Business Central 18.3 (Platform 18.0.27224.29197 + Application 18.3.27240.27381)
Thanks,
John
