Import Item Demand Plan With Weekly Projected Quantities

Scenario

Import Item Demand Plan With Weekly Projected Quantities

Solution

Prior to import, check the item record and related item demand plan and take note of the following:

1. The item is not inactive
2. Replenishment method is set to Time Phased
   Note: The item demand plan has the same View (Month, Weekly, Daily, etc.) Note that the system only allows for one demand plan per item per location.  If user need to update current demand plan, edit the demand plan on file by navigating to Transactions > Demand Planning > Item Demand Plans > Edit the item plan > At the table headings look for view and set to preferred based on import data. Hit Save.

Importing the Item Demand Plan

1. Navigate to Set Up > Import/Export > Import CSV Records
2. At the Scan & Upload CSV File window, enter the following:
• Import Type: Transactions
• Record Type: Item Demand Plan
• CSV Files: Mark One File to Upload and click Select to choose file to be imported.
• Click Next.
3. At the Data Handling Window, select Add or Update 
4. At the Field Mapping window, expand the folders under the NetSuite fields in preparation for mapping:
• Click the (+) sign at the end of Item Demand Plan Demand Planning Folder until the target number of quantity/start date to be entered (based on CSV import columns). If 7 references are entered, the folders under the Item Demand Plan Demand Planning should also be up to 7 (Item Demand Plan Demand Planning 7 folder).  For weekly views, 53 or 54 folders will be generated depending on the number of weeks for the year. 
• Click each numbered subfolder to display mapping fields. Click Quantity for each folder. This will display a message "When you map field Quantity (Req) for sublist item demand plan, Demand Planning XX, you must map all required fields in the sublist. Do you want to continue?" Click OK.
5. Still at the field mapping window, map the file import fields vs. NetSuite import fields.
• Weekly (click on pencil icon) ----- Demand: View (Req)
• Internal ID ------ Internal ID (for updates)
• Item ----- Demand: Item (Req)
• Warehouse (Location) ----- Demand: Location (Req)
• Start Date (Main) ----- Demand: Plan Start Date (Req)
• Year ----- Demand: Year
• QTY 1 ----- Demand Planning 1: Quantity (Req)
• Start Date 1 ----- Demand Planning 1: Start Date (Req)
• QTY 2 ----- Demand Planning 2: Quantity (Req)
• Start Date 2 ----- Demand Planning 2: Start Date (Req)
  Note: Continue doing steps until user map all sublist/numbered folders. At the Saved Mapping and Start Import window, enter the Import name for future imports of the same nature
6. Click Save and Run
   Note: User will now be redirected to another window. Click on the Import Job Status link to be directed to the status window. To verify successful imports, if data have been correctly imported, go back to the Item Demand Plan by navigating to Transactions > Demand Plan > Item Demand Plans