Item Demand Plan Import Errors
This section describes errors that you might see on an item demand plan import. See the following:
Could not find record with internal ID = xxx
The error occurs when importing the Item Demand Plan. To fix the error, map the internal ID of the item demand plan record to the field: Demand: Item (Req).
The internal ID is what identifies the item demand plan for the import. Just like in the UI, you have to edit and overwrite the existing record when updating an Item Demand Plan with a CSV import.
Invalid start date ref key mm/dd/yyyy
The error occurs when the plan start date falls on a year ahead of the current year, and both the year and plan end date fields are not included in the mapping.
You can see these dates in the UI. For example, the current year is 2013, and you want to create a new item demand plan with a start plan date of 1/1/2014, and an end plan date of 12/31/2014.
Go to Transactions > Demand Planning > Item Demand Plans > New. The default fields in the header show:
-
Year = 2013
-
Start Date = 1/1/2013
-
End Date = 12/31/2013
Change the Start Date field to 1/1/2014. Notice the following:
-
Year field becomes null.
-
End Date remains at 12/31/2013. It does not automatically update to 12/31/2014
-
No Monthly/Weekly Start Date and End Dates appear.
To resolve the issue:
-
Map the Year to 2014
-
Map both Plan Start Date and Plan End Date in the CSV Import.