Name | Type | Cardinality | Label | Required | Help |
accountingBookDetailList |
ItemAccountingBookDetailList |
0..1 |
|
|
|
alternateDemandSourceItem |
RecordRef |
0..1 |
Alternate Source Item |
F |
For demand planning purposes, choose another item if you want to examine the historical sales of an item other than the one on the current record. When this field is left blank, the source for historical data is the original item.
For example, if you are setting up Item A for demand planning, but Item A does not have an extensive sales history, you can choose Item B as an alternate source for historical data. Then, when demand calculations need to be made for Item A, NetSuite uses Item B’s history for the calculations.
Note: You can select only an item that is of the same item type to be an alternate source. For example, if the original item is an inventory item, the alternate source item must also be an inventory item. |
assetAccount |
RecordRef |
0..1 |
Asset Account |
F |
References an existing asset account at Lists > Accounting > Accounts. In order to retrieve a list of available values for this field, use the GetSelectValue operation. |
autoLeadTime |
boolean |
0..1 |
Auto-Calculate |
F |
Lead time is the average number of days between ordering this item from the vendor and receiving it.
* Check the Auto-Calculate box if you want NetSuite to calculate the lead time based on the most recent order history of this item. This 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.
o If there are multiple receipts for the item against the same purchase order, only the first receipt is used for the calculation.
o Lead time calculation is not weighted by number of units received.
o More recent purchase orders without receipts are ignored.
* 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. |
autoPreferredStockLevel |
boolean |
0..1 |
Auto-Calculate |
F |
The preferred stock level is the optimum quantity to maintain in stock of an item. Set to true 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) |
autoReorderPoint |
boolean |
0..1 |
Auto-Calculate |
F |
The Reorder Point is the quantity level at which you need to reorder or build more of this item. Set this field to false to manually calculate the point at which to reorder or build more of this item Set this field to true 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: Without safety stock defined: Reorder point = (average lead time days * demand) With safety stock defined in days: Reorder point = [(average lead time days + safety stock days) * demand] With safety stock quantity defined: Reorder point = [(average lead time days * demand) + safety stock quantity) |
availableToPartners |
boolean |
0..1 |
Available to Adv. Partners |
F |
If true, this item is available in the Advanced Partner Center. |
averageCost |
double |
0..1 |
Average Cost |
F |
This field displays the current average cost of the item across all locations. Using the weighted-average method, the average cost is calculated as the total units available during a period divided by the beginning inventory cost plus the cost of additions to inventory.
Note: The average cost calculated per location is listed for each location on the Locations subtab.
If you use Multiple Units of Measure, average cost is calculated using stock units. |
backwardConsumptionDays |
long |
0..1 |
Backward Consumption Days |
F |
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. |
billExchRateVarianceAcct |
RecordRef |
0..1 |
Exchange Rate Variance Account |
F |
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 |
RecordRef |
0..1 |
Billing Schedule |
F |
Allows users to reference default Billing Schedules for items. In order to retrieve a list of available values for this field, use the GetSelectValue operation. |
billPriceVarianceAcct |
RecordRef |
0..1 |
Price Variance Account |
F |
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.
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 |
RecordRef |
0..1 |
Quantity Variance Account |
F |
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.
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. |
binNumberList |
InventoryItemBinNumberList |
0..1 |
|
|
|
class |
RecordRef |
0..1 |
Class |
F |
References a value from a user defined list at Setup > Company > Classifications > Classes. This field is required when the Make Classes Mandatory preference is enabled at Setup > Accounting > Accounting Preferences. |
cogsAccount |
RecordRef |
0..1 |
COGS Account |
F |
References an existing COGs account at Lists > Accounting > Accounts. In order to retrieve a list of available values for this field, use the GetSelectValue operation. |
consumptionUnit |
RecordRef |
0..1 |
Consumption |
F |
If you use the Multiple Units of Measure feature, select the default unit of measure for inventory. |
contingentRevenueHandling |
boolean |
0..1 |
Eligible For Contingent Revenue Handling |
F |
Check this box to indicate that the item is subject to contingent revenue handling. When checked, revenue allocation is affected. |
copyDescription |
boolean |
0..1 |
Copy from Sales Order |
F |
Sets the description from a sales order. |
cost |
double |
0..1 |
Purchase Price |
F |
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 |
RecordRef |
0..1 |
Cost Category |
F |
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 |
double |
0..1 |
Item Defined Cost |
F |
Enter an Item Defined Cost amount. |
costEstimateType |
ItemCostEstimateType |
0..1 |
Cost Estimate Type |
F |
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. |
costEstimateUnits |
string |
0..1 |
|
F |
|
costingMethod |
ItemCostingMethod |
0..1 |
Costing Method |
F |
Because the costingMethod field becomes read-only when set, it is not returned in get and basic search operations. Instead, the read-only field costingMethodDisplay is returned. The costingMethod field can be used only for addRecord operations and in searches. |
costingMethodDisplay |
string |
0..1 |
Costing Method |
F |
This is a read-only value that returns the costing method for the item.
Because the costingMethod field becomes read-only when set, it is not returned in get and basic search operations. Instead, the read-only field CostingMethodDisplay is returned. |
costUnits |
string |
0..1 |
|
F |
|
countryOfManufacture |
Country |
0..1 |
Manufacturer Country |
F |
References a value in a system list. Values are listed at platformCommonTyp:Country. |
createdDate |
dateTime |
0..1 |
Date Created |
F |
|
createRevenuePlansOn |
RecordRef |
0..1 |
Create Revenue Plans On |
F |
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 |
string |
0..1 |
Currency |
F |
This is a read-only field. If a preferred vendor has been specified in vendorName, the field returns the currency set on that vendor record. Otherwise, the base currency for the company is returned. |
customFieldList |
CustomFieldList |
0..1 |
|
|
|
customForm |
RecordRef |
0..1 |
Custom Form |
F |
References an existing custom form for this record type. To ensure that field relationships defined within a desired custom form are maintained, you must provide the customForm value. Also, if defaults are off, then customForm is required, if defaults are on then the default form is used. Internal ID values for existing forms can be found at Setup > Customization > Entry Forms. In order to retrieve a list of available values for this field, use the GetSelectValue operation. |
dateConvertedToInv |
dateTime |
0..1 |
Date Converted To Inv. |
F |
|
defaultItemShipMethod |
RecordRef |
0..1 |
Default Shipping Method |
F |
Select the shipping method to display by default when adding the item to a sales order.
You can override the default shipping method and enter any shipping method when fulfilling an order. |
defaultReturnCost |
double |
0..1 |
Default Return Cost |
F |
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. |
deferredRevenueAccount |
RecordRef |
0..1 |
Deferred Revenue Account |
F |
Set the deferred revenue account to associate with this item. Then, when this item is sold and associated with a revenue recognition template, the revenue from the sale is deferred. The sale amount is posted to a deferred revenue account, as opposed to a standard income account. In order to retrieve a list of available values for this field, use the GetSelectValue operation. |
deferRevRec |
boolean |
0..1 |
Hold Revenue Recognition |
F |
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. |
demandModifier |
double |
0..1 |
Estimated Demand Change |
F |
Set the default percentage of expected demand change to use for calculating item demand. For example, if you know that new customers will increase sales of this item in the future, you can enter 10% expected demand change to be added on to previous sales totals. If no expected demand change percentage is set, then the default value from the Set Up Inventory Management page is used. |
demandSource |
RecordRef |
0..1 |
Demand Source |
F |
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 |
long |
0..1 |
Demand Time Fence |
F |
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. |
department |
RecordRef |
0..1 |
Department |
F |
Set a department to associate with this item. For details on existing department records, in the UI go to Setup > Company > Departments. |
directRevenuePosting |
boolean |
0..1 |
Direct Revenue Posting |
F |
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 |
string |
0..1 |
Display Name/Code |
F |
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 the sales form 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 set a display name, then item name appears on printed forms. |
distributionCategory |
RecordRef |
0..1 |
Distribution Category |
F |
Choose the appropriate category. Once a distribution category is defined on the item record, NetSuite can incorporate network transfers into demand planning for the item.
Note: The network and category you select must be associated with the subsidiary selected for the item in the Classifications section of the item record. For details about how categories are associated with subsidiaries, click Help and read Creating Distribution Categories. |
distributionNetwork |
RecordRef |
0..1 |
Distribution Network |
F |
Choose the appropriate network to determine the distribution categories available to you. If the distribution network field is blank, then distribution category must also be blank.
Note: The network and category you select must be associated with the subsidiary selected for the item in the Classifications section of the item record. For details about how networks are associated with subsidiaries, click Help and read Creating a Distribution Network. |
dontShowPrice |
boolean |
0..1 |
Don't Show Price |
F |
Check this box to hide the price of this item online.
This is useful for items you want to advertise but don't want to sell or for items that you track inventory for and want to display but are offered in combination with other items. |
dropshipExpenseAccount |
RecordRef |
0..1 |
Dropship Expense Account |
F |
When the Automated Intercompany Drop Ship feature is enabled, this field defaults to the account specified in the Default Expense Account on Accounting Preference page, but you can override this account. The account you select must have the Eliminate Intercompany Transactions box checked. |
enforceMinQtyInternally |
boolean |
0..1 |
Enforce Minimum Internally |
F |
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. |
excludeFromSitemap |
boolean |
0..1 |
Exclude from Sitemap |
F |
Check this box to exclude a tab, category or item page from the site map. |
expenseAccount |
RecordRef |
0..1 |
|
|
In order to retrieve a list of available values for this field, use the GetSelectValue operation. |
featuredDescription |
string |
0..1 |
Featured Description |
F |
Settable only if item is featured. You can provide letters, numbers and basic HTML code. |
fixedLotSize |
double |
0..1 |
Fixed Lot Size |
F |
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 |
long |
0..1 |
Forward Consumption Days |
F |
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. |
fraudRisk |
InventoryItemFraudRisk |
0..1 |
Fraud Risk |
F |
Choose the fraud risk level for this item.
This setting is used by the CyberSource Decision Manager when determining which transactions might be fraudulent. |
futureHorizon |
long |
0..1 |
Supply Chain Future Horizon |
F |
Enter the number of days ahead you want to be included in a snapshot for this item. This will include future orders beyond the snapshot generated for this item. For example, when you select 30 in this field, open orders that are past due by 30 days are included.
The default for this field is 30 days.
The maximum you can enter in this field is 365 days. |
gainLossAccount |
RecordRef |
0..1 |
Gain/Loss Account |
F |
When the Use Item Cost as Transfer Cost preference is disabled, the transfer price on a transfer order is used as the item cost on the item receipt. Any difference between the actual cost and the transfer price posts to a Gain/Loss account when the item is shipped.
In this field, select the Gain/Loss account you prefer to use to post transfer cost discrepancies. The account you select must be different than the Asset or Cost of Goods Sold (COGS) account for the item.
You can choose an Income account, Other Income account, Expense account, or Other Expense account.
Note: If you have enabled the Expand Account Lists preference, you can choose any account in this field.
If you leave this field blank or select Use Income Account, then the income account for the item is used. |
handlingCost |
double |
0..1 |
Handling Cost |
F |
As an option, you set a handling cost for this item in dollars. You must also create a shipping item for per-item shipping and handling costs at Lists > Accounting > Shipping Items > New. When this item is set on sales orders, invoices or cash sales, the appropriate shipping and handling charges are automatically calculated. |
handlingCostUnits |
string |
0..1 |
|
F |
|
hazmatHazardClass |
string |
0..1 |
Hazmat Hazard Class |
F |
Enter the DOT hazardous material class or division. |
hazmatId |
string |
0..1 |
Hazmat Id |
F |
Enter the regulatory identifier for the commodity from the Federal Express Ground Hazardous Materials Shipping Guide.
The format is UNXXXX, where XXXX is a four digit number. |
hazmatItemUnits |
string |
0..1 |
Hazmat Item Units |
F |
Enter the unit of measure for this item, such as kg or ml. |
hazmatItemUnitsQty |
double |
0..1 |
Hazmat Item Units Quantity |
F |
Enter the quantity for the item units. |
hazmatPackingGroup |
HazmatPackingGroup |
0..1 |
Hazmat Packing Group |
F |
Select the hazardous material packaging group for the item. |
hazmatShippingName |
string |
0..1 |
Hazmat Shipping Name |
F |
Enter the shipping name for the ID as listed in the Federal Express Ground Hazardous Materials Shipping Guide.
This item appears on the OP950 form. |
hierarchyVersionsList |
InventoryItemHierarchyVersionsList |
0..1 |
|
|
|
includeChildren |
boolean |
0..1 |
Include Children |
F |
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 |
RecordRef |
0..1 |
Income Account |
F |
References an existing income account at Lists > Accounting > Accounts. In order to retrieve a list of available values for this field, use the GetSelectValue operation. |
intercoCogsAccount |
RecordRef |
0..1 |
Intercompany COGS Account |
F |
Select the intercompany cost of goods account. |
intercoDefRevAccount |
RecordRef |
0..1 |
Intercompany Deferred Revenue Account |
F |
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. |
intercoIncomeAccount |
RecordRef |
0..1 |
Intercompany Income Account |
F |
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 |
invtClassification |
ItemInvtClassification |
0..1 |
Classification |
F |
This field displays the chosen classification used for inventory counts. |
invtCountInterval |
long |
0..1 |
Count Interval |
F |
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. |
isDonationItem |
boolean |
0..1 |
Variable Amount |
F |
If true, the item is set as a variable-priced donation item. This enables customers to enter their own prices for this item, such as for donations. |
isDropShipItem |
boolean |
0..1 |
Drop Ship Item |
F |
If isDropShipItem is set to true, isSpecialOrderItem can NOT be true. |
isGcoCompliant |
boolean |
0..1 |
Google Checkout Compliant |
F |
|
isHazmatItem |
boolean |
0..1 |
Hazmat/Dangerous Goods |
F |
Check this box if this item is categorized as either hazardous material or dangerous goods. These items can only be shipped using FedEx integration. |
isInactive |
boolean |
0..1 |
Inactive |
F |
Sets the item as inactive. By default, this field is set to false. |
isOnline |
boolean |
0..1 |
Display in Web Site |
F |
Set to true to make this item available online in your Web site. You cannot sell this item online unless this field is set to true. |
isSpecialOrderItem |
boolean |
0..1 |
Special Order Item |
F |
If isSpecialOrderItem is set to true, isDropShipItem can NOT be true. |
isStorePickupAllowed |
boolean |
0..1 |
Store Pickup Allowed |
F |
If this box is checked, indicates that at least one location allows store pickup of the item. If you clear the Allow Store Pickup box in the Locations sublist for all locations, this box is also cleared when you save the item record.
This field is read only. |
issueProduct |
RecordRef |
0..1 |
Product |
F |
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. |
isTaxable |
boolean |
0..1 |
Taxable |
F |
Check this box if the item is subject to sales tax. |
itemCarrier |
ShippingCarrier |
0..1 |
Carrier |
F |
Select the default shipping carrier for the item. |
itemId |
string |
0..1 |
Item Name/Number |
T |
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. If you have the option to enter a vendor name and do not, the item name prints in the Item column of purchase forms when Basic printing is used. If you have entered a display name, it will print on purchases instead of the item name when Basic printing is used. |
itemOptionsList |
ItemOptionsList |
0..1 |
|
|
|
itemRevenueCategory |
RecordRef |
0..1 |
Item Revenue Category |
F |
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. |
itemShipMethodList |
RecordRefList |
0..1 |
|
|
|
itemVendorList |
ItemVendorList |
0..1 |
|
|
|
lastInvtCountDate |
dateTime |
0..1 |
Last Count Date |
F |
|
lastModifiedDate |
dateTime |
0..1 |
Last Modified |
F |
|
lastPurchasePrice |
double |
0..1 |
Last Purchase Price |
F |
This field displays the most recent purchase price of the item.
This price is determined by the most recent transaction for the item that added positive inventory, such as a purchase receipt, inventory transfer or inventory adjustment. (This does not include item returns or assembly unbuilds.)
If two transactions are entered on the same day, the one entered later takes precedence and is used to calculate the last purchase price.
When you use the Multiple-Location Inventory feature, the following is true:
* The last purchase price reflects the most recent transaction at any location.
* The Inventory subtab of inventory item records includes a link to the last positive-inventory transaction per location.
* If multiple purchases are made on the same day with different prices and locations, then the highest price paid on that day becomes the last purchase price.
If you use Multiple Units of Measure, the last purchase price is calculated using purchase units. |
leadTime |
long |
0..1 |
Lead Time |
F |
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 |
RecordRef |
0..1 |
Location |
F |
Choose a location to associate with this item.
Note: If you have not enabled the Multi-Location Inventory feature, the location you select is used for role restriction purposes only.
Select New to enter a new location record.
Go to Lists > Locations for details about existing location records. |
locationsList |
InventoryItemLocationsList |
0..1 |
|
|
|
manufacturer |
string |
0..1 |
Manufacturer |
F |
Type the name of the company that manufactures this item. |
manufacturerAddr1 |
string |
0..1 |
Manufacturer Address |
F |
Set the address of the manufacturer. This is necessary to fill out international shipping forms when you sell and ship this item. |
manufacturerCity |
string |
0..1 |
Manufacturer City |
F |
Set the city location of the manufacturer of this item. This is necessary to automatically fill out international forms when you ship this item across borders. |
manufacturerState |
string |
0..1 |
Manufacturer State |
F |
Set the state where this item's manufacturer is located. |
manufacturerTariff |
string |
0..1 |
HS Tariff Number |
F |
Set the Harmonized System (HS) tariff code number or the Harmonized Tariff Schedule (HTS) code number. This number should be six to ten characters. |
manufacturerTaxId |
string |
0..1 |
Manufacturer Tax Id |
F |
Enter the Tax ID Number (TIN) for the manufacturer. |
manufacturerZip |
string |
0..1 |
Manufacturer Zip Code |
F |
Set the postal code of the location of this manufacturer. |
matchBillToReceipt |
boolean |
0..1 |
Match Bill To Receipt |
F |
Check the Match Bill to Receipt box if you want the Match Bill to Receipt box on transaction lines to be checked by default for this item. This enables you to generate variances based on vendor bill lines. Then, on the Post Vendor Bill Variances page, you must select Bill in the Transaction Type field to generate the variance postings.
Purchase orders that include this item default to have this box checked and variances are generated based on vendor bill lines.
Clear this box if you want to generate variance postings based on purchase order lines rather than vendor bill lines and do not want the Match Bill to Receipt box to be checked by default on transaction lines for this item. Then, on the Post Vendor Bill Variances page, you must select Purchase Order in the Transaction Type field to generate the variance postings.
This preference defaults to be disabled. Even when enabled, this option can be changed on individual purchase order lines. |
matrixItemNameTemplate |
string |
0..1 |
Matrix Item Name Template |
T |
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] |
matrixOptionList |
MatrixOptionList |
0..1 |
|
|
|
matrixType |
ItemMatrixType |
0..1 |
Matrix Type |
F |
|
maxDonationAmount |
double |
0..1 |
Maximum Variable Amount |
F |
If isDonationItem is set to true, set this field to the maximum amount that can be paid or donated for this item. |
maximumQuantity |
long |
0..1 |
Maximum Order Qty |
F |
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. |
metaTagHtml |
string |
0..1 |
Meta Tag HTML |
F |
Sets the metatag information for the item page in web store. |
minimumQuantity |
long |
0..1 |
Minimum Order Qty |
F |
Enter the smallest quantity you allow customers to purchase for this item. When customers add this item to their carts in the Web store, the quantity for this item is defaulted to the minimum number of items. Leave this field empty to allow customers to check out with no minimum quantity restrictions. |
minimumQuantityUnits |
string |
0..1 |
|
F |
|
mpn |
string |
0..1 |
Manufacturer Part Number |
F |
MPN (Manufacturers Part Number) - Set the part number used by the manufacturer to identify this item. |
multManufactureAddr |
boolean |
0..1 |
Multiple Manufacturer Addresses |
F |
Check the Multiple Manufacture Addresses box if this manufacturer uses more than one address. |
nexTagCategory |
string |
0..1 |
NexTag Category |
F |
Set the name of the NexTag category this item should be included in. This category is included in the product feeds you can export at Setup > Web Site > Product Feeds. Go to www.nextag.com for more information on the available categories. This is an optional field only displayed for the following item records: Kit/Package, Non-inventory Item for Sale, Non-inventory Item for Resale, Assembly (lot and serialized), and Inventory (lot and serialized). |
nextInvtCountDate |
dateTime |
0..1 |
Next Count Date |
F |
Enter the Next Inventory Count Date.
NetSuite uses this information to calculate when that item needs to be counted. |
noPriceMessage |
string |
0..1 |
No Price Message |
F |
If you opted to not show a price online, enter the message that should show instead of the price.
For example, you might enter "Call for Price." |
offerSupport |
boolean |
0..1 |
Offer Support |
F |
When enabled, items can be referenced on case records either through the UI or via web services using the item field. |
onHandValueMli |
double |
0..1 |
|
|
|
onSpecial |
boolean |
0..1 |
On Special |
F |
Set to true if you want to put this item on special. The item then appears in the Specials category in your store or site. |
originalItemSubtype |
ItemSubType |
0..1 |
Original Item SubType |
F |
|
originalItemType |
ItemType |
0..1 |
Original Item Type |
F |
|
outOfStockBehavior |
ItemOutOfStockBehavior |
0..1 |
Out Of Stock Behavior |
F |
Select a custom out of stock behavior for this item. It overwrites the overall site’s out of stock behavior. Your choices are:
* Default - Uses the behavior selected in the Web Store Out of Stock Items field at Setup > Web Site > Setup Tasks > Set Up Web Site > Shopping.
* Disallow back orders but display out of stock messages
* Allow back orders but display out of stock messages
* Remove items when out of stock
* Allow back orders with no out of stock message |
outOfStockMessage |
string |
0..1 |
Out Of Stock Message |
F |
You can enter a custom out of stock message for this item. The message here replaces the default out of stock message. |
overallQuantityPricingType |
ItemOverallQuantityPricingType |
0..1 |
Calculate Quantity Discounts |
F |
Available values are: _byLineQuantity _byOverallItemQuantity _byOverallParentQuantity _byOverallScheduleQuantity |
pageTitle |
string |
0..1 |
Page Title |
F |
Sets the display title in the upper-left corner of an Internet browser when customers view this item in your Web store. |
parent |
RecordRef |
0..1 |
Subitem of |
F |
References an existing item record. Only required if the item is a child of another item. In order to retrieve a list of available values for this field, use the GetSelectValue operation. |
periodicLotSizeDays |
long |
0..1 |
Periods of Supply Increment |
F |
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 |
PeriodicLotSizeType |
0..1 |
Periods of Supply Type |
F |
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. |
preferenceCriterion |
ItemPreferenceCriterion |
0..1 |
Preference Criterion |
F |
Set the NAFTA criterion for this item. Available values are: _A _B _C _D _E _F |
preferredLocation |
RecordRef |
0..1 |
Preferred Location |
F |
References an existing location record at Setup > Company > Classifications > Locations. This is only settable if the Multi-Location Inventory feature is enabled at Setup > Company > Setup Tasks > Enable Features > Items & Inventory. In order to retrieve a list of available values for this field, use the GetSelectValue operation. |
preferredStockLevel |
double |
0..1 |
Preferred Stock Level |
F |
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. |
preferredStockLevelDays |
double |
0..1 |
Days |
F |
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. |
preferredStockLevelUnits |
string |
0..1 |
|
F |
|
presentationItemList |
PresentationItemList |
0..1 |
|
|
|
pricesIncludeTax |
boolean |
0..1 |
Prices Include Tax |
F |
Check this box to save the base price as the tax inclusive price. Clear this box to save the base price as the tax exclusive price. |
pricingGroup |
RecordRef |
0..1 |
Pricing Group |
F |
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. |
pricingMatrix |
PricingMatrix |
0..1 |
|
|
|
producer |
boolean |
0..1 |
Producer |
F |
Set to true if you produce this item for the purposes of the NAFTA Certificate of Origin. |
productFeedList |
ProductFeedList |
0..1 |
|
|
|
purchaseDescription |
string |
0..1 |
Purchase Description |
F |
Sets the description of this item that is displayed on vendor orders. You should include the unit of measure in this description. |
purchaseOrderAmount |
double |
0..1 |
Vendor Bill - Purchase Order Amount Tolerance |
F |
Enter the tolerance limit for the discrepancy between the amount on the vendor bill and purchase order. |
purchaseOrderQuantity |
double |
0..1 |
Vendor Bill - Purchase Order Quantity Tolerance |
F |
Enter the tolerance limit for the discrepancy between the quantity on the vendor bill and purchase order. |
purchaseOrderQuantityDiff |
double |
0..1 |
Vendor Bill - Purchase Order Quantity Difference |
F |
Enter the difference limit for the discrepancy between the quantity on the vendor bill and purchase order. |
purchasePriceVarianceAcct |
RecordRef |
0..1 |
Purchase Price Variance Account |
F |
In the Purchase Price Variance Account field, choose the account to post a variance to when a purchase transaction calculates a cost variance. |
purchaseTaxCode |
RecordRef |
0..1 |
Purchase Tax Code |
F |
|
purchaseUnit |
RecordRef |
0..1 |
Purchase Unit |
F |
Select the unit you use to purchase this item from the vendor. |
quantityAvailable |
double |
0..1 |
Quantity Available |
F |
|
quantityAvailableUnits |
string |
0..1 |
|
F |
|
quantityBackOrdered |
double |
0..1 |
Quantity Back Ordered |
F |
|
quantityCommitted |
double |
0..1 |
Quantity Committed |
F |
This is a read-only field that returns the number of items committed to be sold and are currently showing on orders. If the Multi-Location Inventory feature is enabled, you must provide a list of quantityCommitted values for each location as needed using the locationsList element. |
quantityCommittedUnits |
string |
0..1 |
|
F |
|
quantityOnHand |
double |
0..1 |
Quantity On Hand |
F |
Sets the quantity on hand for this item. This is settable only on an add. Otherwise this is a read-only field that provides the known quantity on hand based on items received. If the Multi-Location Inventory feature is enabled, you must provide a list of quantity on hand values for each location as needed using the locationsList element. |
quantityOnHandUnits |
string |
0..1 |
|
F |
|
quantityOnOrder |
double |
0..1 |
Quantity On Order |
F |
A read-only field that returns the quantity of this item you currently have on order with the vendor. If the Multi-Location Inventory feature is enabled, you must provide a list of quantityOnOrder values for each location as needed using the locationsList element. |
quantityOnOrderUnits |
string |
0..1 |
|
F |
|
quantityPricingSchedule |
RecordRef |
0..1 |
Quantity Pricing Schedule |
F |
Set 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. |
quantityReorderUnits |
string |
0..1 |
|
F |
|
rate |
double |
0..1 |
Price |
F |
Defines the rate for this item. If a value is entered followed by the percentage sign, the discount is interpreted as a percentage discount (i.e. -.10% sets a ten percent discount for the item). If a value without the percentage sign is entered, the rate is interpreted as a flat dollar value. |
receiptAmount |
double |
0..1 |
Vendor Bill - Item Receipt Amount Tolerance |
F |
Enter the tolerance limit for the discrepancy between the amount on the vendor bill and item receipt. |
receiptQuantity |
double |
0..1 |
Vendor Bill - Item Receipt Quantity Tolerance |
F |
Enter the tolerance limit for the discrepancy between the quantity on the vendor bill and item receipt. |
receiptQuantityDiff |
double |
0..1 |
Vendor Bill - Item Receipt Quantity Difference |
F |
Enter the difference limit for the discrepancy between the quantity on the vendor bill and item receipt. |
relatedItemsDescription |
string |
0..1 |
Related Items Description |
F |
Sets the description displayed for a group of related items. |
reorderMultiple |
long |
0..1 |
Reorder Multiple |
F |
Enter the quantity you prefer to order of this item each time. Then, the Order Items page suggests ordering a quantity of this item that is always multiple of the number you enter.
For example, if the vendor only accepts orders in multiples of one thousand, you would enter 1000 in this field. Then, the Order items page might suggest that you order 1000 or 2000, but not 1500.
Note: If you use the Multiple Units of Measure feature, the reorder multiple always functions in base units. |
reorderPoint |
double |
0..1 |
Reorder Point |
F |
Enter the point at which to reorder or build more of this item.
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.
Go to Home > Set Preferences and place a check mark in the |
reorderPointUnits |
string |
0..1 |
|
F |
|
rescheduleInDays |
long |
0..1 |
Reschedule In Days |
F |
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 |
long |
0..1 |
Reschedule Out Days |
F |
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. |
revenueAllocationGroup |
RecordRef |
0..1 |
Revenue Allocation Group |
F |
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 |
RecordRef |
0..1 |
Revenue Recognition Rule |
T |
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 |
RecordRef |
0..1 |
Rev Rec Forecast Rule |
T |
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 |
RecordRef |
0..1 |
Foreign Currency Adjustment Account |
F |
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 |
RecordRef |
0..1 |
Revenue Recognition Template |
F |
Sets the revenue recognition template that will be applied to this item. In order to set this field, the item record referenced in the item field must have a deferred revenue account associated with it. This field then defaults to the rev. rec. template associated to the item on the item record. In order to retrieve a list of available values for this field, use the GetSelectValue operation. |
roundUpAsComponent |
boolean |
0..1 |
Round Up Quantity as Component |
F |
If you use the component yield preference, depending on your settings, the component yield calculation may result in a fractional quantity. You can use this setting so that the quantity for a component on a work order automatically rounds up to a whole number in base units.
For example, you have an assembly that requires 2 units of Component A. The component yield is 99%. To build 5 of these assemblies requires 10.1 units of Component A. Since you can consume components only in whole numbers, you cannot consume 10.1 units. Therefore, you need to round up to the next highest whole number in base units.
Check the Round Up Quantity as Component box to enable NetSuite to round up the quantity consumed for this item.
Clear this box if you do not want NetSuite to round up the quantity consumed for this item. |
safetyStockLevel |
double |
0..1 |
Safety Stock Level |
F |
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. |
safetyStockLevelDays |
long |
0..1 |
Safety Stock Level Days |
F |
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. |
safetyStockLevelUnits |
string |
0..1 |
|
F |
|
salesDescription |
string |
0..1 |
Sales Description |
F |
Sets the description displayed when an item's store display name is clicked. |
salesTaxCode |
RecordRef |
0..1 |
Sales Tax Code |
T |
This field is required for customers subscribing to International versions on NetSuite. Sets the default tax code to be used on sales transactions. In order to retrieve a list of available values for this field, use the GetSelectValue operation. |
saleUnit |
RecordRef |
0..1 |
Sale Unit |
F |
Select the unit you use to sell this item to customers on sales transactions. |
scheduleBCode |
ScheduleBCode |
0..1 |
Schedule B Code |
F |
Select the code for the Schedule B form for this item. Available values are: _1000, _1000cubicMeters, _barrels, _carat, _cleanYieldKilogram, _contentKilogram, _contentTon, _cubicMeters, _curie, _dozen, _dozenPairs, _dozenPieces, _fiberMeter, _gram, _gross, _grossContainers, _hundred, _kilogram, _kilogramTotalSugars, _liter, _meter, _millicurie, _noQuantityReq, _number, _pack, _pairs, _pieces, _proofLiter, _runningBales, _square, _squareCentimeters, _squareMeters, _ton |
scheduleBNumber |
string |
0..1 |
Schedule B Number |
F |
Enter the number for the Schedule B form for this item. |
scheduleBQuantity |
long |
0..1 |
Schedule B Quantity |
F |
Enter the quantity for the Schedule B form for this item. |
searchKeywords |
string |
0..1 |
Search Keywords |
F |
Enter alternative search keywords that customers might use to find this item using your Web store's internal search. These can include synonyms, acronyms, alternate languages or misspellings. These keywords are seen as equally important as the item name when searches are conducted. |
seasonalDemand |
boolean |
0..1 |
Seasonal Demand |
F |
Check the Seasonal Demand box to define how NetSuite analyzes customer demand for this item
.
Customer demand for an item is used to auto-calculate reorder points and preferred stock levels. An item’s demand rate is calculated as the average sales quantity per day.
* Historical Demand – Clear the Seasonal Demand box to calculate the demand as average sales per day over a specific period.
To set the number of months interval between analysis to evaluate sales orders and calculate item demand, go to Setup > Accounting > Set Up Inventory Management > Order Analysis Interval field.
* Seasonal Demand – Check the Seasonal Demand box to calculate the reorder quantity for this item based on inventory demand changes through the year.
To set the number of months interval between analysis to evaluate sales orders and calculate item demand, go to Setup > Accounting > Set Up Inventory Management > Order Analysis Interval field. |
shipIndividually |
boolean |
0..1 |
Ships Individually |
F |
Check this box if this item always ships alone and with no other items in the same package.
This helps determine the number of packages needed and the shipping rate on order fulfillments. |
shipPackage |
RecordRef |
0..1 |
Package |
F |
Select the type of package this item normally ships in. The information for this package type automatically fills in on order fulfillments for this item.
Setting up and assigning package types helps determine the number of packages on an order and helps return accurate real-time shipping rates.
Create package types at Setup > Accounting > Shipping > Packages subtab. |
shippingCost |
double |
0..1 |
Shipping Cost |
F |
As an option, you may set a shipping cost for this item in dollars. You must also create a shipping item for per-item shipping costs at Lists > Accounting > Shipping Items > New. When this item is set on sales orders, invoices or cash sales, the appropriate shipping charges are automatically calculated. |
shippingCostUnits |
string |
0..1 |
|
F |
|
shoppingDotComCategory |
string |
0..1 |
Shopping.com Category |
F |
Set the name of the Shopping.com category that this item should go under. This category is included in the product feeds that you can export from Setup > Web Site > Product Feeds. Go to www.shopping.com for more information on the categories available. This is an optional field only available for following item records: Kit/Package, Non-inventory Item for Sale, Non-inventory Item for Resale, Assembly (lot and serialized), and Inventory (lot and serialized). |
shopzillaCategoryId |
long |
0..1 |
Shopzilla Category ID |
F |
Set the name of the Shopzilla category this item should be included in. This category is included in the product feeds you export at Setup > Web Site > Product Feeds. Go to www.shopzilla.com for more information on the available categories. This is an optional field only displayed for the following item records: Kit/Package, Non-inventory Item for Sale, Non-inventory Item for Resale, Assembly (lot and serialized), and Inventory (lot and serialized). |
showDefaultDonationAmount |
boolean |
0..1 |
Show Default Amount |
F |
Can only be set when isDonation is set to True. If true, the item's online price is displayed as a suggested price. |
siteCategoryList |
SiteCategoryList |
0..1 |
|
|
|
sitemapPriority |
SitemapPriority |
0..1 |
Sitemap Priority |
F |
Use the Sitemap Priority list to indicate the relative importance of your Web site URLs.
You can select a priority ranging from 0.0 to 1.0 on item, category, and tab records.
NetSuite assigns the default priority “Auto” to all new and existing tab, category and item records in your account. The priority is calculated based on the position of the item or category in the hierarchy of your Web site.
For example, your Web site tabs automatically generate a default priority value of 1.0 because they are top level pages. A category published to a tab gets a priority of 0.5. An item published to a category on a tab gets a priority of 0.3. |
softDescriptor |
RecordRef |
0..1 |
Soft Descriptor |
F |
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. |
specialsDescription |
string |
0..1 |
Specials Description |
F |
Settable only if onSpecial is set to True. You can provide letters, numbers and basic HTML code. |
stockDescription |
string |
0..1 |
Stock Description |
F |
Enter up to 21 characters to specify information about this item, such as New, Refurbished or Ships 2-3 days. |
stockUnit |
RecordRef |
0..1 |
Stock Unit |
F |
Select the unit you use to stock this item in inventory. |
storeDescription |
string |
0..1 |
Store Description |
F |
Sets the item description. This field can contain plain text as well as basic html code. |
storeDetailedDescription |
string |
0..1 |
Detailed Description |
F |
Sets the detailed item description. This field can contain plain text as well as basic html code. |
storeDisplayImage |
RecordRef |
0..1 |
Item Display Image |
F |
References an existing image file in the file cabinet. In order to retrieve a list of available values for this field, use the GetSelectValue operation. |
storeDisplayName |
string |
0..1 |
Store Display Name |
F |
Sets the item name for your Web site. |
storeDisplayThumbnail |
RecordRef |
0..1 |
Item Display Thumbnail |
F |
References an existing image file in the file cabinet. In order to retrieve a list of available values for this field, use the GetSelectValue operation. |
storeItemTemplate |
RecordRef |
0..1 |
Item Drilldown Template |
F |
References an existing item template at Setup > Web Site > Item/Category Templates. |
subsidiaryList |
RecordRefList |
0..1 |
|
|
|
supplyLotSizingMethod |
RecordRef |
0..1 |
Lot Sizing Method |
F |
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. |
supplyReplenishmentMethod |
RecordRef |
0..1 |
Replenishment Method |
F |
Select one of the following Replenishment Methods to calculate item replenishment requirements:
* Reorder Point – To use Advanced Inventory Management settings for demand calculations instead of using Demand Planning.
This is the default setting for new item records.
Orders are created based on replenishment reminders generated from the Order Items page, Replenish Items, and Mass Create Work Orders.
* Time Phased – To create orders based on item demand plans instead of the Advanced Inventory Management settings.
When you choose this setting, other fields on the record that are used by Advanced Inventory Management to calculate demand are no longer available. These unavailable fields are: Seasonal Demand, Build Point, Reorder Point, Preferred Stock Level, Safety Stock Days.
The Auto calculate settings are cleared and cannot be changed for Demand Per Day, Reorder Point, Preferred Stock Level, Lead Time. |
supplyTimeFence |
long |
0..1 |
Planning Time Fence |
F |
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 |
RecordRef |
0..1 |
Supply Type |
F |
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. |
taxSchedule |
RecordRef |
0..1 |
Schedule |
T |
Select the tax schedule you want to apply to this item.
You can create new tax schedules at Setup > Accounting > Taxes > Tax Schedules > New. |
totalValue |
double |
0..1 |
Total Value |
F |
By default this field is the result of multiplying the purchase price by the quantity on hand. If the Multi-Location Inventory feature is enabled, the sum of this result for each location populates this field by default. |
trackLandedCost |
boolean |
0..1 |
Track Landed Cost |
F |
Set to true to track landed costs associated with this item. Note: You must include an item that tracks landed costs on transactions you want to source for landed costs. |
transferPrice |
double |
0..1 |
Transfer Price |
F |
Enter a transfer price on an item record to set the default value used as the transfer price on transfer orders. You can still override this default by entering a new transfer price for an item on the transfer order.
The use of the value in the Transfer Price field on a transfer order depends on your setting for the Use Item Cost as Transfer Cost preference.
When the Use Item Cost as Transfer Cost preference is enabled, the transfer price on a transfer order is not considered for posting cost accounting of line items. In the Transfer Price field, enter a declared value for the item to be used for shipping purposes only.
When the Use Item Cost as Transfer Cost preference is disabled, the transfer price on a transfer order is considered for posting cost accounting of line items. Items that do not have a transfer price set on a transfer order use a zero value for cost accounting calculations when the item is received.
Note: If the Transfer Price field is blank on the item record, a value of zero shows by default on the transfer order. Unless a transfer price value is entered on the transfer order, a value of zero is used for COGS calculations when the item is received. |
translationsList |
TranslationList |
0..1 |
|
|
|
unitsType |
RecordRef |
0..1 |
Units Type |
F |
In order to retrieve a list of available values for this field, use the GetSelectValue operation. |
upcCode |
string |
0..1 |
UPC Code |
F |
Defines whether this is a unv part code. Bar codes for items are generated in Code 128 by default. If you prefer to use the UPC code format, set this field to True on each item record. |
urlComponent |
string |
0..1 |
URL Component |
F |
Enter a short, descriptive name for this item to appear as part of its URL in the Web store.
Setting a name to show in the URL can result in better ranking from search engines.
If you leave this field blank, NetSuite terms and numbers are used as identifiers in the URL.
Note: Descriptive URL components are case sensitive. Descriptive URLs must match the case used in the URL Component field of an item record to point to the correct page. |
useBins |
boolean |
0..1 |
Use Bins |
F |
Set to true if you want to track bin locations for this item. If you choose to use bins for this item, you must associate at least one bin with the item using the Bin Numbers subtab. You can associate multiple items with one bin and multiple bins with one item. You can also designate one preferred bin per location. The preferred bin is listed by default on receipt and fulfillment transactions. To create bin records that can be entered here, go to Lists > Accounting > Bins > New. |
useMarginalRates |
boolean |
0..1 |
Use Marginal Rates |
F |
Set to true 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. The fault value is false, which applies the discount to all items sold. |
vendor |
RecordRef |
0..1 |
Preferred Vendor |
F |
In order to retrieve a list of available values for this field, use the GetSelectValue operation. |
vendorName |
string |
0..1 |
Vendor Name/Code |
F |
Sets the preferred vendor for this item. If the Multiple Vendors feature is enabled, this field is unavailable and you must set the preferred vendor in the itemVendorsList. |
vsoeDeferral |
VsoeDeferral |
0..1 |
Deferral |
F |
In this field set how to handle deferment when this item is sold as part of a bundle. The available options are: _deferBundleUntilDelivered - Until this item is marked delivered, the revenue recognition of all items 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 itself, in addition to the delivery of a separate service. For example, a specified upgrade would typically be marked Defer Bundle Until Delivered. _deferUntilItemDelivered - Until this item is marked delivered, the revenue recognition of this item is deferred. This setting is the default for this field. Note: The deferral setting you set for each item in a bundle works together with the deferral settings for other items in the bundle. |
vsoeDelivered |
boolean |
0..1 |
Default as Delivered |
F |
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 |
VsoePermitDiscount |
0..1 |
Permit Discount |
F |
Set one of the following options to determine how discounts are handled for this item. _asAllowed - Allows a portion of an applicable discount to be applied against this item if its status is Delivered when the VSOE allocation is performed. _never - Does not allow a discount to be applied against this item when the VSOE allocation is performed. This selection would be common for a Specified Upgrade. Note: The default for this field is _asAllowed. |
vsoePrice |
double |
0..1 |
Allocation Price |
F |
Set the VSOE price for this item, if the price 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 |
VsoeSopGroup |
0..1 |
Allocation Type |
F |
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. |
weight |
double |
0..1 |
Item Weight |
F |
Set the weight of this item |
weightUnit |
ItemWeightUnit |
0..1 |
Weight Unit |
F |
|
weightUnits |
string |
0..1 |
Weight Units |
F |
|