Hi Guru's
I have been trying to import a demand plan history, because we are moving inventory locations and I want the history to be copied over. However, I am running into some issues.
Demand Plan wants history, so the start date will only be accepted if it is in the past. Makes sense, and works when I upload it for January 1 2023.
However, when I run the supply plan nothing comes up. This is because when demand plans are generated and not manually created, they are for the future (2024). That generates a supply plan.
When I try to upload a demand plan for 2024, it says invalid start date.
If I manually create a demand plan for 2024, it works and a supply plan recommends PO's.
I am able to edit the deman plans that have been imported, and I can manually add the 2024 monthly demand, but that is not very helpful.
How do I upload the monthly item demand plan for 2700 items, without having to edit them all?
Attached I have the spreadsheet. I have tried just 2023 YTD, I tried 2024 (failed), I tried 2023 & 2024 (failed).
Any help would be extremely appreciated.
Here are screen shots of:
- the import mapping,
- demand plans generated by Netsuite that work and clearly show 2024, (Calgary Warehouse location which is current)
- the import demand plan that does not generate supply recomendations. (New CGY (new location)