Item Demand Plan

Internal ID: itemdemandplan

Supports Custom Fields

Fields

Internal ID Type nlapiSubmitField Label Required Help
alternatesourceitem text false Alternate Source Item false The Alternate Source Item field enables you to choose a different item to use that item's historical data to calculate demand.
analysisduration integer false Historical Analysis Duration false In the Historical Analysis Duration field, enter the number of periods in the past to calculate demand projection: * Moving Average - enter the number of periods in the past to calculate the next moving average value. * Linear Regression - enter the number of periods in the past to determine the linear regression projection. * Seasonal Average - enter the number of periods in the past to calculate the buckets in the future.
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 In the Projection Duration field, enter the number of periods to calculate projected future demand. For example, enter 6 to calculate demand over a six month period.
projectioninterval text false Projection Interval false In the Projection Interval field, select the period of time demand is calculated for. For example, select Weekly to project how much demand is expected per week, as opposed to per month. If you are using the Seasonal Average method, only a Monthly interval is supported.
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