| Internal ID |
Type |
nlapiSubmitField |
Label |
Required |
Help |
| advancewarningthreshold |
integer |
|
Firm/Release Advance Warning Threshold |
false |
|
| atpleadtime |
integer |
|
ATP Lead Time |
false |
Enter an ATP Lead Time to use as a planning horizon for supply and demand considerations in the ship date recommendation calculations.
It also provides a ship date on orders when no inventory is available based on future supply and demand. |
| backwardconsumptiondays |
integer |
|
Backward Consumption Days |
false |
When you use the Forecast Consumption demand source method, set the following:
* Forward Consumption – Number of days after the order date to consider
* Backward Consumption – Number of days prior to the order date to consider
When backward and forward consumption days are entered for an item, these fields determine the window, or time period, that is considered for each sales order when a forecast amount may be consumed to calculate demand. If an order falls within the consumption window, that order quantity is calculated as being consumed and the forecast is adjusted to account for the order consumption.
Note: NetSuite always considers backward consumption first.
The forecast closest to the order in the backward window is consumed first.
The forecast closest to the order in the forward window is considered if there are remaining quantities to be consumed.
Note: Only sales order and invoice quantities can consume forecast quantities. Demand from transfer orders and work orders does not consume forecast quantities. |
| buildtime |
float |
|
Work Order Variable Lead Time |
false |
Enter the production build time (in days) to build one assembly in the base unit. You can also have NetSuite automatically calculate lead times. Click the Auto Calculate Production Lead Time box. |
| cost |
currency2 |
|
Standard Cost |
false |
Enter the price you pay for this item.
If you do not enter a price, purchase orders for this item show the most recent purchase price by default.
If you select a preferred vendor for this item, the price is shown in the currency selected on the vendor's record. If no preferred vendor is selected, the price is shown in your base currency. |
| costinglotsize |
float |
|
Costing Lot Size |
false |
Enter the Costing Lot Size to display on the assembly item Locations subtab.
The default value for this field is 1 and the minimum value is 0.01. |
| customform |
select |
|
Custom Form |
false |
Select the form you want to use to enter this record.
You can select the standard form, a custom form you have already created, or select New to create a custom form. |
| defaultreturncost |
currency2 |
|
Default Return Cost |
false |
Enter the rate you want to default to show as the cost for this item when it is returned. What you enter in this field defaults to show in the Override Rate field on item receipts. You can still change this value after it appears on the item receipt. |
| demandsource |
select |
|
Demand Source |
false |
Select a Demand Source to determine where demand data is sourced for an item.
* Forecast from Demand Plan – Source only the item's demand plan record.
Note: A sales order with a related work order generates a supply plan for the sales order. The Mass Create Work Orders page automatically suggests a supply for the sales order.
* Entered and Planned Orders – Source open orders and use the expected ship date as the demand date. If the item is a member of an assembly, demand for the assembly is included demand calculations for the item.
* Order and Forecast – Calculates demand for an item by including both the forecast amount and the amount on orders that have been entered.
Forecast demand for an item is calculated by combining (Quantity forecast over time) + (quantity on sales orders and invoices entered)
* Forecast Consumption – Calculates demand for an item by subtracting from the forecast quantity any item quantities on orders entered. This removes duplication if an order is already included as part of a forecast.
Demand for an item is calculated as (Quantity forecast over time) - (quantity on sales orders and invoices entered). |
| demandtimefence |
integer |
|
Demand Time Fence |
false |
Demand Time Fence defaults to the number entered in the Default Demand Time Fence field.
Verify the default or enter a number between zero and 365 to determine the demand time fence for this item. |
| externalid |
text |
|
ExternalId |
false |
|
| fixedlotsize |
posfloat |
|
Fixed Lot Size |
false |
If you selected Fixed Lot Size as the lot sizing method, then enter a quantity in the Fixed Lot Size field. This is the quantity that procurement of this item is always based on, regardless of demand projections. |
| forwardconsumptiondays |
integer |
|
Forward Consumption Days |
false |
When you use the Forecast Consumption demand source method, set the following:
* Forward Consumption – Number of days after the order date to consider
* Backward Consumption – Number of days prior to the order date to consider
When backward and forward consumption days are entered for an item, these fields determine the window, or time period, that is considered for each sales order when a forecast amount may be consumed to calculate demand. If an order falls within the consumption window, that order quantity is calculated as being consumed and the forecast is adjusted to account for the order consumption.
Note: NetSuite always considers backward consumption first.
The forecast closest to the order in the backward window is consumed first.
The forecast closest to the order in the forward window is considered if there are remaining quantities to be consumed.
Note: Only sales order and invoice quantities can consume forecast quantities. Demand from transfer orders and work orders does not consume forecast quantities. |
| id |
integer |
|
Internal ID |
false |
|
| inventorycosttemplate |
select |
|
Inventory Cost Template |
false |
Select the inventory cost template you want to associate with this item. |
| invtclassification |
select |
|
Classification |
false |
This field displays the chosen classification used for inventory counts. |
| invtcountinterval |
posinteger |
|
Count Interval |
false |
This field displays the total number of days between required counts. For example, if you enter 30, the date a count is required is calculated based on 30 day intervals. |
| isautolocassignmentallowed |
checkbox |
|
Auto Loc. Assignment Allowed |
false |
|
| isautolocassignmentsuspended |
checkbox |
|
Auto Loc. Assignment Suspended |
false |
|
| iswip |
checkbox |
|
WIP |
false |
|
| item |
select |
|
Item |
true |
Enter or select one or more items to determine which items the attributes are copied to.
Click the Select Multiple icon to open the Choose Item window and select more than one item.
Note: If the source item is a different item type than the target item, data in extraneous fields is copied over but does not affect calculations. For example, if the source item processed is a time-phased planning item but the target item is not a time-phased planning item, fields relevant to time-phased planning will be populated on the target item but the data is not used for calculations. |
| latedemandthreshold |
float |
|
High Impact Late Demand Threshold |
false |
|
| leadtime |
integer |
|
Lead Time |
false |
Lead time is the average number of days between ordering this item from the vendor and receiving it.
* Auto-Calculating – Check the Auto-Calculate box if you want NetSuite to calculate the lead time based on the most recent order history of this item. Lead time is calculated by taking the number of days between the order entry and receipt on the three most recent purchase orders, and dividing by three. If more than three purchase orders exist, all purchase orders within the period specified in the Order Analysis Interval field on the Inventory Management Preferences dialog will be used.
o If there are multiple receipts for the item against the same purchase order, the calculation is made using the difference between the purchase order and the last receipt (the receipt that fully receives the order).
o Lead time calculation is not weighted by number of units received.
o More recent purchase orders without receipts are ignored.
* Manually Calculating – Clear the Auto-Calculate box to manually enter a lead time value in days. If the Auto-Calculate box is cleared and no value is entered, then the default value from the Set Up Inventory Management page is used. |
| location |
select |
|
|
true |
Select a location to associate with this item.
To use a location, the Multi-Location Inventory feature must be enabled.
* If the Multi-Location Inventory feature is not enabled:
Selecting an item record location limits the items that certain roles can access.
For example, Role A is set up to access only items associated with Location One. Therefore, employees who have Role A can access only items associated with Location One.
Note: If the Multi-Location Inventory feature is not enabled, you cannot use this field to track inventory by locations. For example, you cannot track how many widgets you have in stock in Location One.
For more information click here.
* If the Multi-Location Inventory feature is enabled:
Selecting an item record location classifies the item by that location to limit the items that certain roles can access. To track inventory per location, use the Locations subtab at the bottom of this form.
For more information click here.
Select New to enter a new location record.
Go to Setup > Company > Locations for details about existing location records. |
| locationallowstorepickup |
checkbox |
|
Allow Store Pickup |
false |
Check the Allow Store Pickup box to enable store pickup.
All items are enabled for store pickup by default. |
| locationstorepickupbufferstock |
integer |
|
Buffer Stock |
false |
In the Store Pickup Buffer Stock field, enter the minimum inventory to be maintained at the location when creating store pickup orders.
NetSuite uses the store pickup buffer stock to calculate the quantity available for store pickup of an item. Visitors to the web store will only be able to create a pickup order if the quantity available for store pickup is greater than zero.
The store pickup buffer stock applies to all items at the location. |
| memo |
textarea |
|
Memo |
false |
Optionally enter a memo. Later, you can search for the text you enter in this field. |
| minimumrescheduledays |
integer |
|
Minimum Reschedule Days |
false |
|
| name |
text |
|
Name |
true |
Enter the item name. |
| nextinvtcountdate |
date |
|
Next Count Date |
false |
Enter the Next Inventory Count Date.
NetSuite uses this information to calculate when that item needs to be counted. |
| pastdueforecastdays |
integer |
|
Past Due Forecast Days |
false |
|
| periodiclotsizedays |
integer |
|
Periods of Supply Increment |
false |
In the Period of Supply Increment field, enter a number from 1 to 90. The default setting is 1.
The increment starts on the first day an order is required. From the first day, NetSuite aggregates all orders in the increment. Orders are placed on the first day of the period.
Note: The Periodic Lot Size Increment field is enabled only when you select Interval in the Periodic Lot Size Type field. |
| periodiclotsizetype |
select |
|
Periods of Supply Type |
false |
The Supply Type field shows the method by which more stock is procured, either Purchase or Assembly. On assembly items, if you have enabled the Allow Purchase of Assembly Items preference, you can choose whether to build additional supply or purchase it. |
| poreceiptcost |
currency2 |
|
PO Receipt Cost |
false |
|
| preferredstocklevel |
float |
|
Preferred Stock Level |
false |
The preferred stock level is the optimum quantity to maintain in stock of an item.
The quantity you enter here is used to determine your replenishment needs on the Order Items page. It is the quantity you want to have in stock after an order is placed.
* Auto-Calculating – Check the Auto-Calculate box if you want NetSuite to calculate the preferred stock level based on demand for the item.
The preferred stock level is calculated as:
(daily demand * number of days supply preferred).
If no preferred stock level is identified, then the default preferred stock level is used from the Set Up Inventory Management page.
* Manually Calculating – Clear the Auto-Calculate box to manually enter the preferred stock quantity.
The preferred stock level you set is used to calculate the quantity of items to be ordered on the Order Items page. |
| reorderpoint |
float |
|
Reorder Point |
false |
The Reorder Point is the quantity level at which you need to reorder or build more of this item.
* Auto-Calculating – Check the Auto-Calculate box if you want NetSuite to calculate the reorder point based on demand for the item over time. The reorder point depends on the safety stock definition and is calculated as follows:
o Without safety stock defined:
Reorder point = (average lead time days * demand)
o With safety stock defined in days:
Reorder point = [(average lead time days + safety stock days) * demand]
o With safety stock quantity defined:
Reorder point = [(average lead time days * demand) + safety stock quantity)
* Manually Calculating – Clear the Auto-Calculate box if you want to manually enter the point at which to reorder or build more of this item.
If you go to Home > User Preferences and place a check mark in the Inventory Level Warnings box, you are reminded when you have reached the reorder point. |
| rescheduleindays |
integer |
|
Reschedule In Days |
false |
In the Reschedule In Days field, enter a number between one and 90 that is the maximum number of days that the order can be advanced from the current day. For example, if you enter 10 in this field, an order for this item can be moved up ten days earlier, but not eleven or more days. This field defaults to be blank.
Note: If this field is left blank, NetSuite does not make recommendations to reschedule orders for this item to a later date. |
| rescheduleoutdays |
integer |
|
Reschedule Out Days |
false |
In the Reschedule Out Days field, enter a number between one and 180 that is the maximum number of days that the order can be delayed from the current day. For example, if you enter 10 in this field, an order for this item can be moved to ten days later, but not eleven or more days. This field defaults to be blank.
Note: If this field is left blank, NetSuite does not make recommendations to reschedule orders for this item to a later date. |
| safetystocklevel |
float |
|
Safety Stock Level |
false |
Enter the amount of an item you prefer to keep in stock at all times. Safety stock can be a quantity or a number of days worth of stock.
This amount is used to auto-calculate the reorder point of an item.
* To define safety stock as a quantity, enter a value.
* To define safety stock as a number of days, enter a value in the field next to Days.
If no safety stock value is entered, then the default value from the Set Up Inventory Management page is used. |
| savedleadtime |
integer |
|
|
false |
|
| savedpreferredstocklevel |
float |
|
|
false |
|
| savedreorderpoint |
float |
|
Reorder Point |
false |
|
| subsidiary |
select |
|
|
true |
Select one or multiple subsidiaries.
To select multiple subsidiaries, press and hold the Ctrl key while selecting each subsidiary.
A subsidiary must be associated with an item in order for the item to be added to a transaction related to that Subsidiary.
For example, you can enter a sales order and select the Wolfe US subsidiary on the transaction. When you select an item to add to the sales order, only items associated with Wolfe US can be added to the sales order. |
| supplylotsizingmethod |
select |
|
Lot Sizing Method |
false |
Select a Lot Sizing Method:
* Lot For Lot – Orders are suggested for procurement based on the exact projections for that day. The suggested order quantity may vary from day to day depending on demand calculations.
* Fixed Lot Size – Orders are suggested for procurement based on a fixed amount or a multiple of the fixed amount.
* Periods of Supply – Generates aggregated purchase orders or work orders based on the overall demand requirements extended over a designated period, such as weekly or monthly.
For example, rather than creating multiple purchase orders for each instance of demand, you can consolidate into one order created from the demand planning engine for all items required within the next 2 weeks. By sending a consolidated purchase order to a vendor, the vendor can ship all items at one time rather than in multiple shipments, potentially resulting in reduced shipping costs.
Note: Be aware of costs from vendor holding charges. You can consolidate orders for a period, but after being consolidated, the Bill of Materials (BOM) for that specific work order on that specific level will also be used for subsequent levels. |
| supplytimefence |
integer |
|
Planning Time Fence |
false |
This field defaults to the number entered in the Default Planning Time Fence field. Verify the default or enter a number between zero and 365 to determine the planning time fence for this item. |
| supplytype |
select |
|
Supply Type |
false |
In the Supply Type list, select a method for procuring more stock: Purchase or Assembly.
On assembly items, if you have enabled the Allow Purchase of Assembly Items preference, you can choose whether to build additional supply or purchase it. |
| templatestored |
checkbox |
|
|
false |
|