Item Demand Plan

Internal ID: itemdemandplan

Supports Custom Fields

Fields

Internal ID Type nlapiSubmitField Label Required Help
alternatesourceitem text false Alternate Source Item false
analysisduration integer false Historical Analysis Duration false
customform select false Custom Form false
demandplancalendartype select false View false You can alter your view of the demand plan by changing the date range or the plan view, as described below: * Year – Enter the year to view. * Month – Select a month to view * Start Date – Enter the first date of the period you want to view. * End Date – Enter the last date of the period you want to view. * View – Choose to see the demand results in a Daily, Weekly or Monthly format.
enddate date false End Date false You can alter your view of the demand plan by changing the date range or the plan view, as described below: * Year – Enter the year to view. * Month – Select a month to view * Start Date – Enter the first date of the period you want to view. * End Date – Enter the last date of the period you want to view. * View – Choose to see the demand results in a Daily, Weekly or Monthly format.
externalid text false ExternalId false
item select false Item true Select the item you are entering a demand plan for.
location select false Location true If you use the Multi-Location Inventory feature, select a location. Then, the list of items that shows is filtered to show only items for the selected location that are time-phased replenishment items.
memo text false Memo false Optionally enter a memo for this plan. Later, you can search for this plan by the text entered here.
month select false Month false You can alter your view of the demand plan by changing the date range or the plan view, as described below: * Year – Enter the year to view. * Month – Select a month to view * Start Date – Enter the first date of the period you want to view. * End Date – Enter the last date of the period you want to view. * View – Choose to see the demand results in a Daily, Weekly or Monthly format.
projectionduration integer false Projection Duration false
projectioninterval text false Projection Interval false
projectionmethod text false Projection Method false Select a Projection Method: * Linear Regression – Use previous demand to project future inventory needs assuming a steady linear growth. * Moving Average – Use previous demand to calculate the overall average stock level needed, and then project future stock levels using that overall average. * Seasonal Average – Use previous demand to examine the seasonal trend of inventory flow, and then project a similar seasonal trend for future stock levels. Note: Using this method, the projection interval must be set to Monthly intervals. * Sales Forecast – When using NetSuite for your sales operations, this option uses forward looking sales forecast data to project inventory demand. When you use the Sales Forecast method, transaction types sourced for projection calculations are cash sale, invoice, estimate, opportunity, sales order, and item fulfillment.
projectionstartdate date false Projection Start Date false Once you select a projection interval, the first date of the period you want to forecast demand for is displayed in the Projection Start Date field.
startdate date false Start Date false You can alter your view of the demand plan by changing the date range or the plan view, as described below: * Year – Enter the year to view. * Month – Select a month to view * Start Date – Enter the first date of the period you want to view. * End Date – Enter the last date of the period you want to view. * View – Choose to see the demand results in a Daily, Weekly or Monthly format.
subsidiary select false Subsidiary true Select the subsidiary associated with this item demand plan.
units select false Unit of Measure false Select a Unit of Measure to create a demand plan based on the unit.
year year false Year false You can alter your view of the demand plan by changing the date range or the plan view, as described below: * Year – Enter the year to view. * Month – Select a month to view * Start Date – Enter the first date of the period you want to view. * End Date – Enter the last date of the period you want to view. * View – Choose to see the demand results in a Daily, Weekly or Monthly format.

Sublists

demandplandetail - Demand

Internal ID Type Label Required Help
enddate date End Date false
quantity_1_ posfloat Quantity false
startdate date Start Date false
systemcalculated float Monthly Calculated false

Tabs

Name Label
demand Demand
workflow Workflow

Search Joins

Join ID Join Description Actual Join Name
location Location Location

Search Filters

Internal ID Type Label
alternatesourceitem select Last Alternate Source Item
analysisduration integer Last Historical Analysis Duration
demanddate date Demand Date
externalid select External ID
externalidstring text External ID (Text)
formuladate date Formula (Date)
formulanumeric float Formula (Numeric)
formulatext text Formula (Text)
internalid select Internal ID
internalidnumber integer Internal ID (Number)
item select Item
lastmodifieddate datetime Last Plan Modified
location select Location
memo text Memo
projectionduration integer Last Projection Duration
projectioninterval select Last Projection Interval
projectionmethod select Last Projection Method
projectionstartdate date Last Projection Start Date
quantity float Quantity
subsidiary select Subsidiary
units select Units

Search Columns

Internal ID Type Label
alternatesourceitem select Last Alternate Source Item
analysisduration integer Last Historical Analysis Duration
demanddate date Demand Date
externalid select External ID
formulacurrency currency Formula (Currency)
formuladate date Formula (Date)
formuladatetime datetime Formula (Date/Time)
formulanumeric float Formula (Numeric)
formulapercent percent Formula (Percent)
formulatext text Formula (Text)
internalid select Internal ID
item select Item
lastmodifieddate datetime Last Plan Modified
location select Location
memo text Memo
projectionduration integer Last Projection Duration
projectioninterval text Last Projection Interval
projectionmethod text Last Projection Method
projectionstartdate date Last Projection Start Date
quantity float Quantity
quantityuom float Quantity in Demand Plan Units
subsidiary select Subsidiary
units select Units