Internal ID |
Type |
nlapiSubmitField |
Label |
Required |
Help |
amortizationperiod |
integer |
false |
Amortization Period |
false |
Enter the number of periods over which the purchase amount should be amortized. For example, enter 60 to amortize the amount over 60 periods starting from the amortization start date.
Note: The starting period is specified by the amortization start date on bills. If no amortization start date is specified, the posting date of the bill is the amortization start date. |
amortizationtemplate |
select |
false |
Amortization Template |
false |
Select an amortization template to create the recognition schedule for the cost of this item.
This template is used by default on purchase transactions. You can still select a different template on transactions. |
availabletopartners |
checkbox |
false |
Available to Adv. Partners |
false |
Check this box to make this item available to partners with the Advanced Partner Center role for viewing.
These items are also available to partners with roles that are customized for the Advanced Partner Center and include view, create or edit access to item records. |
billexchratevarianceacct |
select |
|
Exchange Rate Variance Account |
false |
Select the account to post to for variances in exchange rates associated with this item. These variances occur when there are exchange rate differences between the receipt and the bill for an item.
Note: After you select a variance account in this field, you can select another account at a later date if a change is necessary. Account changes are noted on the System Notes subtab of the History subtab of item records. |
billingschedule |
select |
false |
Billing Schedule |
false |
Choose the billing schedule you want to associate with this item.
When an item is associated with a billing schedule, the billing schedule appears by default when the item is added to an order.
Note: Forms must be customized to show schedules on lines. Read Applying Billing Schedules.
Click New to enter a new billing schedule. |
billpricevarianceacct |
select |
|
Price Variance Account |
false |
Select the account to post to for variances in billing prices associated with this item. These variances occur when there is a difference in the price of an item showing on the purchase order and the price of an item showing on the bill, or receipt.
Note: After you select a variance account in this field, you can select another account at a later date if a change is necessary. Account changes are noted on the System Notes subtab of the History subtab of item records. |
billqtyvarianceacct |
select |
|
Quantity Variance Account |
false |
Select the account to post to for variances in billing quantities associated with this item. These variances occur when there is a difference in the quantity of an item showing on the receipt and the quantity of an item showing on the bill, or receipt.
Note: After you select a variance account in this field, you can select another account at a later date if a change is necessary. Account changes are noted on the System Notes subtab of the History subtab of item records. |
class |
select |
true |
Class |
false |
Select a class to associate with this item.
Click New to enter a new class record.
Go to Setup > Company > Classes for details about existing class records. |
consumptionunit |
select |
false |
Consumption Units |
false |
If you use the Multiple Units of Measure feature, select the default unit of measure for inventory. |
contingentrevenuehandling |
checkbox |
false |
Eligible For Contingent Revenue Handling |
false |
Check this box to indicate that the item is subject to contingent revenue handling. When checked, revenue allocation is affected. |
cost |
currency2 |
false |
Purchase Price |
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. |
costcategory |
select |
false |
Cost Category |
true |
Select a cost category to associate with this item.
View existing cost categories at Setup > Accounting > Setup Tasks > Accounting Lists.
For more details, click Help and read Creating Cost Categories. |
costestimate |
currency |
false |
Item Defined Cost |
false |
Enter an Item Defined Cost amount. |
costestimatetype |
select |
false |
Cost Estimate Type |
false |
The Cost Estimate Type determines what value NetSuite uses to calculate estimated Gross Profit.
The estimated Gross Profit for Items on a transaction provides the data needed to calculate the total estimated Gross Profit on that transaction.
The individual line items that you enter in a transaction determine the amounts that post when you process that transaction.
The following Cost Estimate Types on Items are available:
* Item Defined Cost - a user-defined amount, entered into the Item Defined Cost field on the Item definition page.
* Average Cost - NetSuite calculates an average cost of the units purchased.
* Last Purchase Price - This field displays the most recent purchase price of the item as determined by purchase order receipt transactions.
* Purchase Price - Price entered that you pay for this item. If you do not enter a price, then the most recent purchase price from purchase orders provides the price for this item by default.
* Preferred Vendor Rate - This option is only used if the Multi-Vendor feature is enabled and multiple vendors supply the same item.
o First priority is to use the preferred vendor rate if defined on the Item record.
o Next priority would be to use the purchase price.
o Last priority would be the purchase order rate. (Initially this uses the preferred vendor rate cost, and then after a purchase order is entered, this type uses the most recent actual purchase order rate. Special orders and drop-shipped items use this cost information.)
* Derived from member items - Total costs of items currently included in a kit. This Cost Estimate Type only applies to kits and sums the estimated costs of each item in the kit, based on each of their individual Cost Estimate Types. Uses the latest definition of the kit, not its historical definition. |
costunits |
text |
false |
|
false |
|
createddate |
datetime |
false |
Date Created |
false |
|
createrevenueplanson |
select |
false |
Create Revenue Plans On |
false |
Select the event that triggers creation of revenue recognition plans. Match the event with the amount source of the item's revenue recognition rule.
* Revenue Arrangement Creation - Revenue plans can be created when the revenue arrangement is created. Use this option with rules that have Event-Amount as the Amount Source.
* Billing - Revenue plans can be created when the sales order is billed and from stand-alone cash sales, invoices, credit memos, and cash refunds. Use this option with rules that have Event-Percent based on amount as the Amount Source.
* Fulfillment - This option is available only when Advanced Shipping is enabled. Revenue plans can be created upon fulfillment. Use this option with rules that have Event-Percent based on quantity as the Amount Source.
* Project Progress - This option is available only when the Projects feature is enabled. Use this option with rules that have Event-Percent Complete as the Amount Source. |
currency |
text |
false |
Currency |
false |
The purchase price for this item is listed in this currency.
The currency selected on the preferred vendor record is shown in this field.
If there is no preferred vendor selected, your base currency is shown. |
customform |
select |
false |
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. |
deferralaccount |
select |
false |
Deferred Expense Account |
false |
Select a deferred expense account if you want to amortize expenses instead of posting to a standard expense account.
Note: If you do not select a deferred expense account for an item, you can associate an amortization template with the item on transactions only if the template identifies a specific deferred expense account. |
deferredrevenueaccount |
select |
false |
Deferred Revenue Account |
false |
Select the deferred revenue account to associate with this item. If you use revenue recognition or advanced revenue management, the revenue from the sale of this item is deferred. |
deferrevrec |
checkbox |
false |
Hold Revenue Recognition |
false |
Check this box to delay recognizing revenue from the sale of this item. When this box is check, revenue recognition schedules or revenue plans are created with the status On Hold.
For more information, see the help topic Delaying Revenue Recognition for an Item. |
department |
select |
true |
Department |
false |
Choose a department to associate with this item.
Click New to enter a new department record.
Go to Setup > Company > Departments for details about existing department records. |
directrevenueposting |
checkbox |
false |
Direct Revenue Posting |
false |
Check this box to disable advanced revenue management for this item. When checked, posting transactions that include this item post directly to the item revenue account. No revenue element or revenue arrangement is created. When you check this box, the Deferred Revenue Account on the Accounting subtab is disabled.
When you create sales transactions that include items that have this box checked, all the items in the transaction must have the box checked. You cannot mix items that post directly to revenue with items that post to deferred revenue in the same transaction. This restriction also applies to kit items. All items in a kit must post either to revenue or to deferred revenue.
You cannot check or clear the box after the item has been used in a transaction with advanced revenue management.
By default, this box is not checked. |
displayname |
text |
false |
Display Name/Code |
false |
Enter an optional name of up to 250 characters for this item in addition to the Item Name. If you are integrating with a Yahoo! store, this field is imported from Yahoo!.
The display name prints in the Item column of sales forms when Basic printing is used. If this item is a member of a kit, this name appears in the Item column when the Print Items box is checked.
If you do not enter a display name, the item name appears on printed forms. |
enforceminqtyinternally |
checkbox |
false |
Enforce Internally |
false |
Check this box to apply the minimum quantity restriction on sales orders generated from NetSuite. When you clear this box, but enter a number in the Minimum Quantity field, the minimum quantity is only applied to web store orders. |
expenseaccount |
select |
false |
Expense Account |
false |
Select an expense account to associate with this item. |
externalid |
text |
false |
ExternalId |
false |
|
generateaccruals |
checkbox |
false |
Generate Accruals |
false |
Check this box to automatically generate and post an accrual to the General Ledger. |
includechildren |
checkbox |
false |
Include Children |
false |
Check the Include Children box to share the item with all the sub-subsidiaries associated with each subsidiary selected in the Subsidiary field.
Note: When sharing items across subsidiaries, all of the options selected on the item record must be compatible across subsidiaries.
For example, when entering an inventory item to be shared across subsidiaries, you should select Income and Asset accounts on the item record that are also shared across the same subsidiaries. |
incomeaccount |
select |
false |
Income Account |
false |
Select the income account to associate with this item. When no income account is selected, the item does not show in the Item dropdown list for sales transactions. |
intercodefrevaccount |
select |
false |
Intercompany Deferred Revenue Account |
false |
Select the account to use for intercompany deferred revenue. This account is used to record transactions between subsidiaries in NetSuite OneWorld accounts. The options include only accounts with the Eliminate Intercompany Transactions box checked.
For more more information about intercompany transactions, see the help topic Understanding Automated Intercompany Management. |
intercoexpenseaccount |
select |
false |
Intercompany Expense Account |
false |
Select the account to use for intercompany expense for this item. This account is used to record transactions between subsidiaries in NetSuite OneWorld accounts.
To be available for selection, an account must have the Eliminate Intercompany Transactions box checked. If the Eliminate Intercompany Transactions box is later cleared on the account, intercompany transactions cannot be eliminated.
The field is included on inventory type items and the following resale item types:
* Non-Inventory
* Other Charge
* Service |
intercoincomeaccount |
select |
false |
Intercompany Income Account |
false |
Select the account to use for intercompany income for this item. This account is used to record transactions between subsidiaries in NetSuite OneWorld accounts.
To be available for selection, an account must have the Eliminate Intercompany Transactions box checked. If the Eliminate Intercompany Transactions box is later cleared on the account, intercompany transactions cannot be eliminated.
The field is included on inventory type items and the following resale item types:
* Non-Inventory
* Other Charge
* Service |
isfulfillable |
checkbox |
false |
Can be Fulfilled/Received |
false |
Check the Can be Fulfilled/Received box to enable this item to be received and fulfilled during order processing.
Clear this box if this item does not require being received and fulfilled.
Note: Once this item has been added to transactions, this setting cannot be changed.
This field is used when the Advanced Billing and Advanced Shipping features are both enabled. |
isgcocompliant |
checkbox |
true |
Allow Google Checkout Purchase |
false |
|
isinactive |
checkbox |
false |
Inactive |
false |
When you check this box, this item will no longer appear on a list unless you check the Show All box at the bottom of the list page. |
isonline |
checkbox |
false |
Display in Web Store |
false |
Check this box to make this item available online in your Web site.
You cannot sell this item online unless you check this box.
If the item is of the Other Charge for Sale or Resale subtype, checking this box does not make it available in the web store catalog. However, it becomes available during web store checkout. |
issueproduct |
select |
false |
Product Name |
false |
Select the product this item is associated with.
Product records are tracked with versions and builds for issue management.
To create product records, go to Setup > Issues > Products > New. |
itemid |
text |
false |
Item Name/Number |
true |
Enter up to 250 characters for the name of this item. This name appears in lists on transactions.
If you have the option of entering a display name and do not, the item name prints in the Item column of sales forms when Basic printing is used.
If you have the option to enter a vendor name and do not, the item name prints in the Item column of purchase forms. If you have entered a display name, it will print on purchases instead of the item name when Basic printing is used. |
itemoptions |
select |
false |
Item Options |
false |
|
itemrevenuecategory |
select |
false |
Item Revenue Category |
false |
The item revenue category is a classification for items that have similar characteristics and revenue allocation requirements. It is used in the fair value price list. |
itemtype |
text |
false |
|
false |
Select the type of item you want to print labels for.
Select All to show all types of items. |
lastmodifieddate |
datetime |
false |
Last Modified |
false |
|
location |
select |
true |
Location |
false |
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. |
matrixitemnametemplate |
textarea |
false |
Matrix Item Name Template |
false |
This field is used to control how the matrix item will be displayed in the Matrix Item Name/Number field.
Compose the order in which attributes and matrix options are displayed by selecting from the Insert Item Attribute and Insert Matrix Option dropdown lists.
Add custom separator characters to easier distinguish the various options.
Example: Item Name: Fabric / Color / Waist / Length [Location] |
matrixtype |
select |
false |
Matrix Type |
false |
|
maximumquantity |
posinteger |
true |
Maximum Quantity |
false |
Enter the greatest quantity of this item that customers can purchase. If customers enter an item quantity above the maximum amount, a warning message is displayed. Web store customers are unable to complete checkout unless they enter a quantity equal to or below the maximum quantity.
Leave this field empty to allow customers to check out without maximum quantity restrictions.
You can edit this warning at Setup > Site Builder/SuiteCommerce Advanced > Customize Text. |
minimumquantity |
posinteger |
true |
Minimum Quantity |
false |
Enter the lowest quantity that customers can purchase. Web store customers receive a warning and cannot check out if they enter an item quantity below this minimum.
Leave this field empty to allow customers to check out with no minimum quantity restrictions.
You can edit this warning at Setup > Site Builder/SuiteCommerce Advanced > Customize Text. |
minimumquantityunits |
text |
false |
|
false |
|
mossapplies |
checkbox |
false |
MOSS Applies |
false |
Check this box if the Mini One Stop Shop (MOSS) VAT scheme applies to this item. If this box is checked, the item cannot be added to an item group. If this item is already part of an item group, do not check the MOSS Applies box. |
offersupport |
checkbox |
false |
Offer Support |
false |
Check this box to offer support for this particular item.
By offering support for items, customers can select on case records which item they are having trouble with. |
overallquantitypricingtype |
select |
false |
Calculate Quantity Discounts |
false |
Choose how to determine the quantity for the purpose of pricing:
* By Line Quantity - pricing is applied according to the quantity included in the line item.
* By Overall Item Quantity - pricing is applied for all line items for the same item on a transaction.
* By Overall Parent Quantity - pricing is applied for all items with the same parent item on the transaction. This can be useful for applying quantity pricing to matrix items.
* By Overall Schedule Quantity - pricing is applied to all items that use the same pricing schedule that are included in the transaction. |
overheadtype |
select |
false |
Overhead Type |
true |
|
parent |
select |
false |
Subitem of |
false |
If you want this item to be a subitem, select the parent item here. |
pricinggroup |
select |
false |
Pricing Group |
false |
Select the pricing group this item is a member of.
Using pricing groups enables you to assign customer-specific price levels for a group of items.
You can create new pricing groups at Setup > Accounting > Setup Tasks > Accounting Lists > New > Pricing Group. |
purchasedescription |
textarea |
false |
Purchase Description |
false |
Enter up to 999 characters of text for a description of this item to appear on vendor orders. Include the unit of measure in this description. |
purchaseorderamount |
posfloat |
false |
Vendor Bill - Purchase Order Amount Tolerance |
false |
Enter the tolerance limit for the discrepancy between the amount on the vendor bill and purchase order. |
purchaseorderquantity |
posfloat |
false |
Vendor Bill - Purchase Order Quantity Tolerance |
false |
Enter the tolerance limit for the discrepancy between the quantity on the vendor bill and purchase order. |
purchaseorderquantitydiff |
posfloat |
false |
Vendor Bill - Purchase Order Quantity Difference |
false |
Enter the difference limit for the discrepancy between the quantity on the vendor bill and purchase order. |
purchaseunit |
select |
false |
Purchase Units |
false |
Select the unit you use to purchase this item from the vendor. |
quantitypricingschedule |
select |
false |
Quantity Pricing Schedule |
false |
Select the pricing schedule you want to use to set prices for this item.
You can create new pricing schedules at Lists > Accounting > Quantity Pricing Schedules > New.
Selecting a pricing schedule sets the Use Marginal Rates and Calculate Quantity Discounts fields. |
receiptamount |
posfloat |
false |
Vendor Bill - Item Receipt Amount Tolerance |
false |
Enter the tolerance limit for the discrepancy between the amount on the vendor bill and item receipt. |
receiptquantity |
posfloat |
false |
Vendor Bill - Item Receipt Quantity Tolerance |
false |
Enter the tolerance limit for the discrepancy between the quantity on the vendor bill and item receipt. |
receiptquantitydiff |
posfloat |
false |
Vendor Bill - Item Receipt Quantity Difference |
false |
Enter the difference limit for the discrepancy between the quantity on the vendor bill and item receipt. |
residual |
rate |
false |
Residual |
false |
Enter an amount or percentage to remain in the deferral account and not be amortized. A residual amount generally represents the salvage value of a fixed asset.
Note: A residual amount entered on a transaction overrides a residual amount entered on an item record. |
revenueallocationgroup |
select |
false |
Revenue Allocation Group |
false |
Select a revenue allocation group to use in GroupSum functions in fair value formulas. The value you select here is the default. You can change it on the revenue element. |
revenuerecognitionrule |
select |
false |
Revenue Recognition Rule |
false |
Select the revenue rule to use by default for this item in a revenue arrangement.
Be sure the rule you select has an Amount Source that is appropriate for the value you select in the Create Revenue Plans On field. For more information, see the field level help for Create Revenue Plans On. |
revrecforecastrule |
select |
false |
Rev Rec Forecast Rule |
true |
Select a revenue rule to use for forecast revenue recognition plans. The default is determined by the same accounting preference as the Revenue Recognition Rule.
You may select the same rule or a different rule for actual and forecast rules. Percent complete rules are not available as forecast rules. For information about forecast revenue plans for project progress, see Working with Percent-Complete Revenue Recognition Plans. |
revreclassfxaccount |
select |
false |
Foreign Currency Adjustment Account |
false |
Select the account to use for the foreign currency adjustment during reclassification.
You can select any account with an account type of income, other income, expense, or other expense, including the gain and loss accounts generated by the system after qualifying revaluation transactions. You can change the Foreign Currency Adjustment Account on the revenue element before revenue recognition plans are created. |
revrecschedule |
select |
false |
Revenue Recognition Template |
false |
Select a default revenue recognition template to associate with this item on sales transactions.
You must also select a Deferred Revenue Account in order to use revenue recognition. |
salesdescription |
textarea |
false |
Sales Description |
false |
Enter a sales description for this item.
You can enter letters and numbers. There is a 999 character limit.
The sales description displays on transactions such as sales orders, cash sales and invoices.
If you use the Web Store feature, the sales description displays immediately under the item's store display name on item list pages in your store or site, if you have not entered a store description for an item. Enter the store description on the Store subtab of the item record.
The sales description also displays by default when the item is in the Web store shopping cart. |
saleunit |
select |
false |
Sale Units |
false |
Select the unit you use to sell this item to customers on sales transactions. |
softdescriptor |
select |
false |
Soft Descriptor |
false |
In the Soft Descriptor list, select the name that will appear on the customer's credit card statement when this item is purchased.
Enter soft descriptors to select in this field at Setup > Accounting > Payment Processing > Credit Card Soft Descriptors. |
subsidiary |
select |
false |
Subsidiary |
false |
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. |
subtype |
text |
false |
|
false |
|
taxschedule |
select |
false |
Tax Schedule |
true |
Select the tax schedule you want to apply to this item.
You can create new tax schedules at Setup > Accounting > Taxes > Tax Schedules > New. |
unitstype |
select |
false |
Units Type |
false |
Select the type of units you use to purchase, stock and sell this item. |
upccode |
text |
false |
UPC Code |
false |
Enter a maximum of 999 characters in this field to identify an internal name or number to store the item's UPC Code. You can use the text you enter here when adding the item to transactions, searching, or viewing reports.
* When you enter text in this field, the SKU/UPC field on item labels displays this UPC Code and prints in UPC bar code format.
* When this field is clear, the SKU/UPC field on item labels displays the Item Name/Number and prints in Code-128 bar code format. |
usemarginalrates |
checkbox |
false |
Use Marginal Rates |
false |
Check this box if you want the quantity discounts in the schedule to be applied to each pricing bracket separately.
For example, a schedule offers no discount for the first 100 items sold and a 5% discount if more than 100 are sold. If 150 items are sold, the first 100 are at normal price, and the other fifty items are sold at 5% discount.
Leave this box clear if you want the discount to apply to all of the items sold. |
vendorname |
text |
false |
Vendor Name/Code |
false |
If your vendor uses a name for this item that is different from the name you use, you can enter up to 60 characters as the vendor's name for this item here.
The vendor's name for this item prints in the Item column of purchase forms.
If you do not enter a vendor name, the item name prints in the Item column of purchase forms. If you have entered a display name, it will print on purchases instead of the item name. |
vsoedeferral |
select |
false |
Deferral |
false |
In the Deferral field, choose how to handle deferment when this item is sold as part of a bundle:
* Defer Bundle Until Delivered – Until this item is marked delivered, item revenue recognition in the bundle is deferred.
A typical use for this option is to identify items whose revenue recognition depends on the delivery of the item in addition to the delivery of a separate service. For example, a specified upgrade would typically be marked Defer Bundle Until Delivered.
* Defer Until Item Delivered – Until this item is marked delivered, the item revenue recognition is deferred. This is the default field setting.
Note: The deferral setting you choose for each item in a bundle works with the deferral settings for other items in the bundle. |
vsoedelivered |
checkbox |
false |
Default as Delivered |
false |
Check this box to automatically set this item to a Delivered status when this item is added to a transaction. Clear this box to leave the delivery status clear by default. |
vsoepermitdiscount |
select |
false |
Permit Discount |
false |
Choose from the following options to determine how discounts are handled for this item.
* As Allowed - Allows a portion of an applicable discount to be applied against this item if its status is delivered when revenue allocation is performed.
* Never - Prevents a discount from being applied against this item when revenue allocation is performed.
When you use advanced revenue management, items with VSOE values never permit discount if the residual method is used. |
vsoeprice |
currency2 |
false |
VSOE Price |
false |
Enter the VSOE Price for this item if it is known.
Note: If you need to use more than one VSOE price for an item, you can set the most common price here and then change the price on each order manually. |
vsoesopgroup |
select |
false |
Allocation Type |
false |
Select an allocation type to associate with this item on sales transactions.
* Normal - Revenue allocation follows EITF 08-01 rules when you use VSOE and the fair value price list with advanced revenue management.
* Exclude - This item is excluded from revenue allocation. The item discounted sales amount is the revenue amount.
* Software - The item is software. When you use VSOE with the EITF SuiteApp, both EITF 08-01 and SOP 97-2 rules apply for revenue allocation. When you use advanced revenue management, revenue allocation follows the fair value price list. Then if the fair value prices for any of the items in the allocation are estimates rather than VSOE, the allocation is recalculated using the residual method.
Note: Do not select the Software value unless you are using VSOE with the EITF SuiteApp or Advanced Revenue Management. |