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. |