Locations

The Locations subtab displays data about the item specific to each of your locations.

If you use Multi-Location Inventory, enter or verify the information for each location that stocks this item. The method to enter this information depends on whether you use Advanced Item Location Configuration. For more information, see Advanced Item Location Configuration.

• If you do not use Advanced Item Location Configuration, the fields listed below appear on the Locations subtab in columns. You can enter data when the record is in Edit mode.

• If you use Advanced Item Location Configuration, the following is true:

  • The fields listed below appear on the Location subtab in columns.

  • You can filter the displayed fields using the View field.

  • Click Edit next to a location to access the Item Location Configuration popup window and edit data for that location. For more information, see Edit Item Location Attributes.

Location – All views display a column for Location and the location is identified for each line.

Currency – If you use Multiple Currencies, a Currency column appears and identifies the currency for each line.

Preferred Location – When you select a preferred location, the location populates on sales orders that show line-item locations.

If you use Advanced Bin / Numbered Inventory Management and Multi-Location Inventory with serial or lot numbered items, the following is true:

• If you change the location identified on a transaction for an item that does not track bins, the inventory detail record updates. The record shows inventory data as corresponding to the new location and not the previous location.

• If you change the location identified on a transaction for an item that tracks bins, the inventory detail record clears because the bins are different.

• If you change the location on an item shipment, the inventory detail record clears because the on-hand quantities are different.

Costing

• Location Costing Group – This field displays the location costing group associated with this item. For more information, see Group Average Costing.

• Cost Accounting Status – This field identifies the state of cost accounting calculations for this item. For more information, see Cost Accounting Status on Item Records.

• Average Cost – This field shows the average cost of the item.

• Standard Cost – Enter the price you pay for this item in the Standard Cost field. You can enter a cost per location.

  If you do not enter a price, purchase orders for this item show the most recent purchase price by default.

  The value in this field can be used as the default when you create a planned standard cost record.

  If you use Multiple Currencies and select a preferred vendor for this item, the price appears in the currency selected on the vendor's record. If no preferred vendor is selected, the price is shown in your base currency.

  To streamline data entry for setting up standard costs, you can also import values into this field using CSV import. For more information, see Standard Costing.

• Inventory Cost Template – Select the inventory cost template you want to associate with this item.

• Default Return Cost – Enter the rate you want to default to show as the cost for this item when it is returned. This rate appears in the Override Rate field on item receipts. You can change this value after it appears on the item receipt.

Inventory

• Quantity On Hand – Enter the quantity currently stocked that has not been used to fulfill orders. This count includes the quantity committed. If you use Multiple Units of Measure, the quantity on hand is calculated using stock units.

  Note:

  If you do not use NetSuite OneWorld, you can enter initial quantities on hand in each location when you create an item record. However, if you use NetSuite OneWorld, you cannot enter initial quantities on hand when you create an item record. You must first create the item record. Then, you must enter an inventory adjustment to specify the initial quantities in each location.

  For more information, see Inventory Adjustments or OneWorld Overview.

• Quantity on Hand (Base Unit) – This field displays the quantity on hand in base units of measure.

• Value – This field displays the calculated value of the item.

• Quantity Committed – This field displays the quantity of this item that are committed to orders.

• Quantity Available (Base Unit) – This field displays the quantity available to be committed in base units of measure.

• Quantity on Order – This field displays the quantity of this item that have been ordered but not yet received.

• Quantity in Transit – This field displays the quantity of the item that is currently being transferred from one location to another. For any quantity of items that is in transit, that quantity is reduced from the On Hand count for the item at the source location. The quantity is not added to the receiving location until the transfer order is marked received. For more information about transfer order processing, see Inventory Transfer Orders.

• Quantity Back Ordered – This field displays the quantity of the item that has orders entered but no available stock to commit to the order.

Inventory Count

• Inventory Classification – This field displays the chosen classification used for inventory counts.

• Inventory Count Interval – 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.

• Last Inventory Count Date – This field displays the date of the most recent previous inventory count that ran for this item.

• Next Inventory Count Date – This field displays the next scheduled date an inventory count will run for this item.

Order Management

ATP Lead Time – The ATP lead time is used as a planning horizon for supply and demand considerations in the ship date recommendation calculations. It is also used to provide a ship date on an order when no inventory is available based on future supply and demand.

Other

• Last Purchase Price – This field displays the most recent purchase price of the item as determined by purchase order receipt transactions. For more information, see Sales and Shipping Information for Items.

• Build Point – For each location, enter the point at which you should build more of this assembly.

  You can have NetSuite notify you when your inventory reaches this point. Go to Home > Settings > Set Preferences. Check the Inventory Level Warnings box, and then save.

  This field is available only when you use Advanced Inventory Management. It is not available for items that use Demand Planning.

• WIP – Check this box to use Manufacturing Work In Process (WIP) with this item in this location. For more information, see Manufacturing Work In Process (WIP).

Planning

The following fields specify information related to inventory level planning.

• Preferred Stock Level – Enter the optimum quantity to maintain in stock of this item. The ideal quantity is the amount you need to fulfill orders in a timely manner without either running out or overstocking.

  This quantity 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. The preferred stock level you set is used to calculate the quantity of items to be ordered on the Order Items page.

• Reorder Point – 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.

  Tip:

  NetSuite can remind you when you have reached the reorder point. Go to Home > User Preferences. Check the Inventory Level Warnings box, and then save.

  • 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:

    • Without safety stock defined: Reorder point = (average lead time days x demand)

    • With safety stock defined in days: Reorder point = [(average lead time days + safety stock days) x demand]

    • With safety stock quantity defined: Reorder point = [(average lead time days x 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.

Demand Planning and Planning Times

The following fields provide information specific to inventory demand planning. For more information about these fields, see Demand Planning on Item Records.

Demand Planning

• Demand Source

• Supply Type

• Fixed Lot Size

• Lot Sizing Method

• Periods of Supply Increment

• Periods of Supply Type

Planning Times

• Forward Consumption Days

• Backward Consumption Days

• Demand Time Fence

• Planning Time Fence

• Reschedule In Days

• Reschedule Out Days

Related Topics

Entering Item and Cost Details

Entering Inventory Management Details

Entering Manufacturing Details

Entering Shipping Details

Entering Vendor Bill Matching Details

Lot, Serial, and Bin Numbering

Vendors

Adding Components to Kits or Item Groups

Entering Purchasing and Inventory Information on Items

General Notices