Lot Numbered Inventory Item

Internal ID: lotnumberedinventoryitem

Supports Deleted Record Search

Fields

Internal ID Type nlapiSubmitField Label Required Help
alternatedemandsourceitem select false Alternate Source Item false 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 select false Asset Account false Select the asset account that tracks the value of the inventory on hand for this item. Click —New— to set up a new account. Go to Lists > Accounts for details about existing accounts.
atpmethod select false Default ATP Method true
auctionquantity posinteger false Auction Quantity false
auctiontype select false Auction Type false
autoleadtime checkbox true Auto-Calculate false 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 checkbox true Auto-Calculate false The preferred stock level is the optimum quantity to maintain in stock of an item. The quantity you enter here is used to determine your replenishment needs on the Order Items page. It is the quantity you want to have in stock after an order is placed. * Auto-Calculating – Check the Auto-Calculate box if you want NetSuite to calculate the preferred stock level based on demand for the item. The preferred stock level is calculated as: (daily demand * number of days supply preferred). If no preferred stock level is identified, then the default preferred stock level is used from the Set Up Inventory Management page. * Manually Calculating – Clear the Auto-Calculate box to manually enter the preferred stock quantity. The preferred stock level you set is used to calculate the quantity of items to be ordered on the Order Items page.
autoreorderpoint checkbox true Auto-Calculate false 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. If you go to Home > User Preferences and place a check mark in the Inventory Level Warnings box, NetSuite reminds you when you have reached the reorder point.
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.
averagecost currency false Average Cost false 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.
billexchratevarianceacct select false 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 false 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. 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 false 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. 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.
buyitnowprice currency true Buy It Now Price false
class select true Class false Select a class to associate with this item. Click New to enter a new class record. Go to <_TABNAME=LIST_CLASS_> > <_TASKCATEGORY=LIST_CLASS_> > Classes for details about existing class records.
cogsaccount select false COGS Account false Select the Cost of Goods Sold account that tracks the cost of this item. Click &#x2014;New&#x2014; to set up a new account. Go to Lists > Accounts for details about existing accounts.
conditionenabled text false false
conditionhelpurl text false false
copydescription checkbox false Copy from Sales Order false Check this box to copy the purchase description from the item description you enter on a sales order. Clear this box to enter a purchase description in the field above.
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 <_TABNAME=LIST_ACCOUNTINGOTHERLIST_> > <_TASKCATEGORY= LIST_ACCOUNTINGOTHERLIST_> > Accounting Lists > Cost Category. For more details, click Help and read Creating Cost Categories.
costestimate currency false Item Defined Cost false A user-defined amount, entered into the Item Defined Cost field on the Item definition page.
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 in NetSuite 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. With Multi-Location Inventory enabled, NetSuite calculates the average across all locations. Otherwise, the average calculation uses location-specific costs. * Last Purchase Price - This field displays the most recent purchase price of the item as determined by purchase order receipt transactions. If you make multiple purchases on the same day that use different rates, this field shows the highest purchase price on that day, per location if applicable. When you use the Multiple-Location Inventory feature, the last purchase price reflects the most recent receipt at any location. If you track Cost of Goods Sold (COGS), NetSuite identifies the cost of the item based on your COGS settings. * Purchase Price - Enter the price 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 meaningful if the Multi-Vendor feature is enabled and multiple vendors supply the same item. In order of precedence: o Preferred vendor rate, if defined on the Item record Purchase price o Purchase Order Rate - Initially 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.
costingmethod select false Costing Method false Select your inventory costing method. The costing method you choose determines how Cost of Goods Sold (COGS) calculations are handled for costs associated with buying the same item at different purchase prices over a given period. Costing methods include the following: * Average (weighted-average method) &#x2013; COGS are calculated as the total units available during a period divided by the beginning inventory cost plus the cost of additions to inventory. * Group Average &#x2013; Group average costing enables you to track one average cost for an item across multiple locations within a defined group. For details, click Help and read Group Average Costing. * First-In, First-Out (FIFO) &#x2013; Using FIFO, the first goods purchased are assumed to be the first goods sold so that the ending inventory consists of the most recently purchased goods. This method is useful to track different shipments of similar products. * Last-In, First-Out (LIFO) &#x2013; Using LIFO, the last goods purchased are assumed to be the first goods sold so that the ending inventory consists of the first goods purchased. * Standard &#x2013; Standard Costing enables you track standard costs for items and to track variances between these expected costs and actual costs. In NetSuite, Average costing is the default costing method. Note: Once the costing method is saved on the item record, it cannot later be changed.
costingmethoddisplay text false Costing Method false The costing method is displayed here. A costing method determines how to handle costs associated with buying the same item at different purchase prices over a given period. The costing method for serialized items is always Serialized. Serialized costing associates the purchase price of each item individually. The costing method for lot numbered items is always Lot Numbered. Lot numbered costing associates the purchase price of the lot of items.
costunits text false false
countryofmanufacture select true Manufacturer Country false Enter the name of the country where this item is manufactured. This information is used for customs purposes when shipping.
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.
custreturnvarianceaccount select false Customer Return Variance Account false
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
demandmodifier percent true Expected Demand Change false Enter 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 a 10% expected demand change to be added on to previous sales totals. If no expected demand change percentage is entered, then the default value from the Set Up Inventory Management page is used.
demandtimefence integer false Demand Time Fence false
department select true Department false Choose a department to associate with this item. Click New to enter a new department record. Go to <_TABNAME=LIST_DEPARTMENT_> > <_TASKCATEGORY=LIST_DEPARTMENT_> > Departments for details about existing department records.
displayinebaystore checkbox true eBay Store false
displayname text false Display Name/Code false You can enter an optional name 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. 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.
distributioncategory select false Distribution Category false
distributionnetwork select false Distribution Network false
dontshowprice checkbox false Don't Show Price false 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 select false Dropship Expense Account false 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.
ebayhandlingtime select false Handling Time false
ebayintlinsurancefee currency false Insurance Amount false
ebayintlpackagehandlingfee currency false Package & Handling Fee false
ebayintlshipinsurance select false Shipping Insurance false
ebayintlshippingitem1 select false Shipping Item 1 false
ebayintlshippingitem2 select false Shipping Item 2 false
ebayintlshippingitem3 select false Shipping Item 3 false
ebayisintlcalculatedrate radio false Flat Rates false
ebayisirregularpackage checkbox false Irregular Package false
ebayitemdescription textarea false Item Description false
ebayitemlocdisplay text false Item Location false
ebayitemloczipcode text false Item Location Zip Code false
ebayitemlots integer false Lot Size false
ebayitemsubtitle text true Subtitle false
ebayitemtitle text true Item Title false
ebayitemweightamt posfloat false Item Weight false
ebaylayout select false Default Chart Type false
ebaypackagetype select false Package false
ebaypagecounter select false Page Counter false
ebayrelistingoption select false Relisting Option false
ebaytheme select false Theme false
ebaythemegroup select false Theme Group false
endauctionswhenoutofstock checkbox true End Auctions When Item is Out of Stock false
enforceminqtyinternally checkbox false Enforce Internally false Check this box to only allow sales orders created in NetSuite to be submitted when the minimum quantity of this item is ordered. When the item is selected on a sales order, the quantity is set to the minimum by default. If the quantity is edited below the minimum amount, an alert pops up, and the item cannot be added to the order. When you clear this box but enter a number in the Minimum Quantity field, the minimum only applies in the Web store.
excludefromsitemap checkbox false Exclude From Sitemap false Check this box to exclude a tab, category or item page from the site map.
externalid text false ExternalId false
featureddescription textarea false Featured Description false If this item is displayed on the home page of your Web site, enter a featured description for this item. This description appears below the item's store display name on the Home page of your store or site. You can enter up to 999 characters including basic HTML code. Enter and format text using the formatting options, or click the HTML Source Code link to enter HTML.
fraudrisk select true Fraud Risk false
froogleproductfeed text false false
gainlossaccount select false Gain/Loss Account false 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.
galleryfeatured checkbox false Featured First false
gifttypeexpressship checkbox false Express shipping false
gifttypegiftwrap checkbox false Gift wrap / gift card false
gifttypeshiptorecipient checkbox false Ship to gift recipient false
handlingcost currency false Handling Cost false As an option, you may enter a handling cost for this item in dollars. You must also create a shipping item for per-item shipping and handling costs at Lists > Shipping Items > New. When this item is selected on sales orders, invoices or cash sales, the appropriate shipping and handling charges are automatically calculated.
handlingcostunits text false false
handlinggroup text false Handling false
imagesgroup text false Images false
imageslocation select false Images Location false
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.
intercocogsaccount select false Intercompany COGS Account false
intercoincomeaccount select false Intercompany Income Account false
internalid integer false Internal ID false
iscalculatedrate radio false Flat Rates false
isdonationitem checkbox false Variable Amount false Check this box to set this item as variable-priced. This enables customers to enter their own prices for this item, such as for donations.
isdropshipitem checkbox false Drop Ship Item false Check this box to have this item default as a drop ship item on sales orders. When a sales transaction for a drop ship item is approved, a linked purchase order for the preferred vendor is automatically generated. The vendor ships this item to your customer directly. Note: an item can be a drop ship or a special order, but not both.
isgcocompliant checkbox true Allow Google Checkout Purchase false Check this box to make the item available for purchase with Google Checkout.
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.
isspecialorderitem checkbox false Special Order Item false Check this box if you want this item to default as a special order on sales transactions. When a sales transaction for a special order item is approved, a linked purchase order is automatically generated. Then, the order cannot be fulfilled until the linked purchase order is received. Special order items can be used for custom orders or "just-in-time" inventory. Important: You must identify a preferred vendor and a purchase price on an item record in order for that item to be selected as a special order. Note: An item can be a drop ship or a special order, but not both.
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 <_TABNAME=ADMI_ISSUEPRODUCT_> > <_TASKCATEGORY=ADMI_ISSUEPRODUCT_> > Products > New.
itemcondition select false Item Condition false
itemhandlingfee currency false Package & Handling Fee false
itemid text false Item Name/Number true Type up to 60 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. If you have entered a display name, it will print on purchases instead of the item name.
iteminsurancefee currency false Insurance Amount false
itemnumberoptions select false Item Number Options false
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.
itemshipinsurance select false Shipping Insurance false
itemtype text false false
lastmodifieddate datetime false Last Modified false
lastpurchaseprice currency false Last Purchase Price false 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 integer true Lead Time false Lead time is the average number of days between ordering this item from the vendor and receiving it. * Auto-Calculating &#x2013; 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 &#x2013; 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.
listimmediate radio false Start listing when submitted false
listingduration select false Duration false
listingstartdate date false Start Date false
listingstarttime select false Start Time false
location select true Location false
manufacturer text false Manufacturer false Enter the name of the company that manufactures this item.
manufactureraddr1 text true Manufacturer Address false Enter the address of the manufacturer. This is necessary to fill out international shipping forms when you sell and ship this item.
manufacturercity text true Manufacturer City false Enter 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 text true Manufacturer State false Enter the state where this item's manufacturer is located. This is necessary to fill out international forms when you ship this item.
manufacturertariff text true Manufacturer Tariff false Enter the Harmonized System (HS) tariff code number or the Harmonized Tariff Schedule (HTS) code number. This number should be six to ten characters.
manufacturertaxid text true Manufacturer Tax Id false Enter the Tax ID Number (TIN) for the manufacturer.
manufacturerzip text true Manufacturer Zip false Enter the postal code of the location of this manufacturer. This is necessary to create international forms when you ship this item.
matchbilltoreceipt checkbox false Match Bill To Receipt false 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 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
maxdonationamount currency2 false Maximum Variable Amount false If you checked the Variable Amount box, enter the maximum amount that can be paid or donated for this item.
metataghtml textarea false Meta Tag HTML false Enter the Meta Tag HTML you want to appear in the < head > section of this item page. Meta tags enable your Web site to be found by search engines.
minimumquantity posinteger true Minimum Quantity false 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. Web store customers receive a warning and cannot check out if they enter an item quantity below this minimum. If you use Advanced Site Customization, you can edit this warning at Setup > Web Site > Customize Web Site Text. Leave this field empty to allow customers to check out with no minimum quantity restrictions.
minimumquantityunits text false false
mossapplies checkbox false MOSS Applies false
mpn text false MPN false MPN (Manufacturers Part Number) - Enter the part number used by the manufacturer to identify this item.
multmanufactureaddr checkbox true Multiple Manufacture Addresses false
nextagcategory text false NexTag Category false Enter 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).
nextagproductfeed text false false
nopricemessage text false No Price Message false 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."
numactivelistings integer true Active Listings false
numcurrentlylisted integer true Quantity Currently Listed false
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.
outofstockbehavior select false Out Of Stock Behavior false Select a custom out of stock behavior for this item. It overwrites the overall site&#x2019;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 textarea false Out Of Stock Message false You can enter a custom out of stock message for this item. The message here replaces the default out of stock message.
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.
packageheight posinteger false Height false
packagelength posinteger false Length false
packagewidth posinteger false Width false
pagetitle textarea false Page Title false Enter the text you want to appear in the upper-left corner of an Internet browser when customers view this item in your Web store.
parent select false Subitem of false If you want this item to be a subitem, select the parent item here.
preferencecriterion select true Preference Criterion false Set the NAFTA criterion for this item.
preferredlocation select false Preferred Location false Choose the location you would like to associate with this item. This location will autofill on sales orders that show locations on a line-item basis. This field is also used to calculate real-time shipping cost on web orders. If this item displays in your web site, be sure to select a Preferred Location. When the Automatic Location Assignment feature is enabled and this location is autofilled on sales order lines, it prevents the automatic location assignment engine from assigning locations.
preferredstockleveldays float true Days false The preferred stock level is the optimum quantity to maintain in stock of an item. The quantity you enter here is used to determine your replenishment needs on the Order Items page. It is the quantity you want to have in stock after an order is placed. * Auto-Calculating &#x2013; 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 &#x2013; 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.
pricinggroup select false Pricing Group false Select the pricing group this item is a member of. Using pricing groups allows you to assign customer-specific price levels for a group of items. You can create new pricing groups at <_TABNAME=EDIT_OTHERLIST_> > <_TABNAME=EDIT_OTHERLIST_> > Accounting Lists > New > Pricing Group.
primarycatdisplayname text false false
primarycategory integer true Primary Category false
producer checkbox false Producer false Check this box if you produce this item for the purposes of the NAFTA Certificate of Origin.
productfeed select false Product Feed false
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.
purchasepricevarianceacct select false Purchase Price Variance Account false In the Purchase Price Variance Account field, choose the account to post a variance to when a purchase transaction calculates a cost variance.
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 <_TABNAME=EDIT_QUANTITYPRICINGSCHEDULE_> > <_TASKCATEGORY=EDIT_QUANTITYPRICINGSCHEDULE_> > Quantity Pricing Schedules > New. Selecting a pricing schedule sets the Use Marginal Rates and Calculate Quantity Discounts fields.
quantityreorderunits text false false
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.
refundgivenas select false Refund will be given as false
relateditemsdescription textarea false Related Items Description false Enter a description for the related items you show with this item in your Web site. You can enter up to 999 characters of letters, numbers and basic HTML code. You can also clear the View as HTML box below to enter and format text using the formatting options above. This eliminates the need for HTML code.
reordermultiple posinteger false Reorder Multiple false 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 a 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.
rescheduleindays integer false Reschedule In Days false
rescheduleoutdays integer false Reschedule Out Days false
reserveprice currency true Reserve Price false
returnpolicy select false Return Policy false
returnpolicydetails textarea false Details false
returnshippingpaidby select false Return Shipping will be paid by false
returnswithin select false Item must be returned within false
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.
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.
safetystocklevel float false Safety Stock Level false Enter the amount of an item you prefer to keep in stock at all times. Safety stock can be a quantity or a number of days worth of stock. This amount is used to auto-calculate the reorder point of an item. * To define safety stock as a quantity, enter a value. * To define safety stock as a number of days, enter a value in the field next to Days. If no safety stock value is entered, then the default value from the Set Up Inventory Management page is used.
safetystockleveldays integer true Days false Enter the amount of an item you prefer to keep in stock at all times. Safety stock can be a quantity or a number of days worth of stock. This amount is used to auto-calculate the reorder point of an item. * To define safety stock as a quantity, enter a value. * To define safety stock as a number of days, enter a value in the field next to Days. If no safety stock value is entered, then the default value from the Set Up Inventory Management page is used.
safetystocklevelunits text false false
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.
schedulebcode select true Schedule B Code false Select the unit of measure used to express the quantity entered in the Schedule B Quantity field. These two fields are used together to determine the amount represented by one of this item on the Schedule B form for Shipping Export Declarations. For example, if you enter 5 in the Schedule B Quantity field, and you select kilogram in the Schedule B Code field, when you fulfill two of these items on an order, the Schedule B form presents the item's amount as 10 kilograms. Schedule B is the form for Statistical Classification of Domestic and Foreign Commodities Exported from the U.S. See www.census.gov/foreign-trade for more information.
schedulebnumber text true Schedule B Number false Enter the number for the Schedule B form for this item.
schedulebquantity posinteger true Schedule B Quantity false Enter the numeric quantity in relation to the unit of measure entered in the Schedule B Code field. These two fields are used together to determine the amount represented by one of this item on the Schedule B form for Shipping Export Declarations. For example, if you enter 5 in the Schedule B Quantity field, and you select kilogram in the Schedule B Code field, when you fulfill two of these items on an order, the Schedule B form presents the items&#x2019; amount as 10 kilograms.
searchkeywords textarea false Search Keywords false Enter alternative search keywords that customers might use to find this item using your Web store&#x2019;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 checkbox true Seasonal Demand false This setting defines the way 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&#x2019;s demand rate is calculated as the average sales quantity per day. * Historical Demand &#x2013; Clear the Seasonal Demand box if you prefer 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 &#x2013; 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.
secondarycatdisplayname text false false
secondarycategory integer false Secondary Category false
sellonebay checkbox true Sell on eBay false
shipasia checkbox false Asia false
shipaustralia checkbox false Australia false
shipcanada checkbox false Canada false
shipeurope checkbox false Europe false
shipgermany checkbox false Germany false
shipindividually checkbox true Ships Individually false 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.
shipjapan checkbox false Japan false
shipmexico checkbox false Mexico false
shipnorthsouthamerica checkbox false North and South America false
shippackage select true Package false 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 currency false Shipping Cost false As an option, you may enter a shipping cost for this item in dollars. You must also create a shipping item for per-item shipping costs at Lists > Shipping Items > New. When this item is selected on sales orders, invoices or cash sales, the appropriate shipping charges are automatically calculated.
shippingcostunits text false false
shippingdomesticmethodsgroup text false Shipping Methods false
shippingdomgroup text false Domestic Shipping Settings false
shippingintlgroup text false International Shipping Settings false
shippingintlgroup1 text false Shipping Method 1 false
shippingintlgroup2 text false Shipping Method 2 false
shippingintlgroup3 text false Shipping Method 3 false
shippingitem1 select false Shipping Item 1 false
shippingitem2 select false Shipping Item 2 false
shippingitem3 select false Shipping Item 3 false
shippinglocationsgroup text false Ship-to Locations false
shippingpackaginggroup text false Packaging false
shippingrate1 currency false Rate false
shippingrate2 currency false Rate false
shippingrate3 currency false Rate false
shipuk checkbox false United Kingdom false
shipworldwide checkbox false Worldwide false
shoppingdotcomcategory text false Shopping.com Category false Enter 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).
shoppingproductfeed text false false
shopzillacategoryid integer false Shopzilla Category ID false Enter 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).
shopzillaproductfeed text false false
showasgift checkbox false Show as Gift false
showdefaultdonationamount checkbox false Show Default Amount false Check this box to suggest the item's online price for the item. When customers navigate to a donation item, they first see the online price for the item and then can choose to enter any amount they like.
sitemappriority select false Sitemap Priority false 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 &#x201c;Auto&#x201d; 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 select false Soft Descriptor false Select the brand name or name that should appear on customers' credit card statements when this item is purchased. Enter soft descriptors to select in this field at Setup > Accounting > Payment Processing > Credit Card Soft Descriptors.
standardimages radio false Standard false
startingprice currency true Starting Price false
stockdescription text false Stock Description false Enter up to 21 characters to specify information about this item, such as New, Refurbished or Ships 2-3 days.
stockunit select false Stock Units false Select the unit you use to stock this item in inventory.
storecatdisplayname text false false
storecatdisplayname2 text false false
storecategory integer false Store Category false
storecategory2 integer false Secondary Store Category false
storedescription textarea false Web Store Description false The store description appears under the item's store display name on item list pages in your store or site. You can enter letters, numbers, and basic HTML code. Note: To make the store description display when an item is in the Web store shopping cart, go to Setup > Web Site > Set Up Web Site. Click the Cart subtab, and check the box next to Store Description.
storedetaileddescription textarea false Detailed Description false Enter a detailed description for this item. When your customers click an item's store display name for more information, they see this description. You can enter letters, numbers or basic HTML code. If you are using Internet Explorer, you can also clear the View Source box below to enter and format text using the formatting options above. This eliminates the need for HTML code. If you do not see the View Source box, make sure Rich Text Editing is enabled at Home > Set Preferences > Appearance.
storedisplayimage select false Item Display Image false Select an image from your file cabinet to display with this item in your Web site. Upload images at Lists > Web Site > Images. You can automatically resize images less than 5 megapixels in size at Setup > Web Site > Image Resizing.
storedisplayname text false Web Store Display Name false Enter the name of this item as you want it displayed in your Web site.
storedisplaythumbnail select false Item Display Thumbnail false Select an image from your file cabinet you want to use as the thumbnail image for this item. This image shows with this item before a customer clicks the item for more information. Upload images at Lists > Web Site > Images. You can automatically resize images less than 5 megapixels in size at Setup > Web Site > Image Resizing.
storeitemtemplate select false Item Drilldown Template false If you have created an item template to display this item in your Web site, select the template here. Create item templates at Lists > Item Templates. You can set an item template for all your items at Setup > Site Templates > Body.
subsidiary select false Subsidiary false
supersizeimages checkbox false Supersize Pictures false
supplyreplenishmentmethod select true Replenishment Method false Choose a method to use for calculating item replenishment requirements: * Reorder Point &#x2013; Choose this setting 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 &#x2013; When you choose this setting, orders are created 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 integer false Planning Time Fence false
taxable checkbox false Taxable false
taxschedule select false Tax Schedule true
templatesgroup text false Templates false
totalvalue currency false Total Value false Enter or accept the total value of this item. NetSuite generates this amount by multiplying your purchase price and your quantity on hand. As you buy and sell additional inventory, NetSuite continues to calculate the total value.
tracklandedcost checkbox true Track Landed Cost false Check this box 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. For example, on the Landed Costs subtab of item receipts, a vendor bill shows in the source transaction list only if the bill includes a landed cost item.
transferprice currency2 false Transfer Price false 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.
transferpriceunits text false false
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.
urlcomponent textarea false URL Component false 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 checkbox true Use Bins false Check this box 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 selected here, go to <_TABNAME=EDIT_BINNUMBERRECORD_> > <_TASKCATEGORY=EDIT_BINNUMBERRECORD_> > Bins > New.
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.
vendreturnvarianceaccount select false Vendor Return Variance Account false
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 &#x2013; 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. * Defer Until Item Delivered &#x2013; 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 choose for each item in a bundle works together 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.
weight float false Item Weight false Enter the weight of this item and select the units in the dropdown.
weightunit select false false
weightunits text false false
willship radio false Will Ship to the US and the following: false
yahooproductfeed text false false

Sublists

accountingbookdetail - Accounting Books

Internal ID Type Label Required
revrecschedule select Revenue Recognition Template false
sameasprimaryrevrec checkbox Same as Primary Book Rev Rec false

binnumber - Bin Numbers

Internal ID Type Label Required
binnumber select Bin Number true
location text false
locationactive text Location Active false
onhand float On Hand false
onhandavail float Available false
preferredbin checkbox Preferred (per Location) false

price1 - US Dollar

Internal ID Type Label Required
currency text Currency false
discount percent Default Discount % false
discountdisplay percent Default Discount % false
pricelevel text Price Level false

price2 - British pound

Internal ID Type Label Required
currency text Currency false
discount percent Default Discount % false
discountdisplay percent Default Discount % false
pricelevel text Price Level false

price3 - Canadian Dollar

Internal ID Type Label Required
currency text Currency false
discount percent Default Discount % false
discountdisplay percent Default Discount % false
pricelevel text Price Level false

price4 - Euro

Internal ID Type Label Required
currency text Currency false
discount percent Default Discount % false
discountdisplay percent Default Discount % false
pricelevel text Price Level false

sitecategory - Web Site Categories

Internal ID Type Label Required
category select Site Category true
categorydescription text Description false
isdefault checkbox Preferred Category false
website select Site true

Tabs

Name Label
basic Basic
custom Custom
history History
inventory Inventory
inventorydetail Inventory Detail
inventorynumbers Inventory Numbers
matrix Matrix
pricing Pricing
relitems Related Items
specials Specials
store Store
translation Translation
vsoepricing Rev Rec / Amort
workflow Workflow

Search Data

Item