Creating an Inventory Worksheet

Inventory Worksheets enable you to enter changes to the quantity or value of inventory items other than lot numbered items, serial numbered items, or inactive items. You can enter adjustments for up to 1,000 line items at a time. However, be aware that the exclusive nature of the adjustment described in the following paragraphs applies to all items you adjust on the worksheet.


Depending on your requirements, you may be able to use the Single Inventory Worksheet Import to automate the creation of an inventory worksheet. For this import, you submit inventory adjustment data in a CSV file.

Adjustment Exclusive of Previous Stock Totals

Adjustment amounts on the Adjust Inventory Worksheet form do not change as of the worksheet transaction date. The stock count is adjusted to remain at the level indicated by the worksheet on the worksheet date.

For example, you took a physical count of your inventory on January 1st, 2008. You want to enter that count. You do not want that count changed in the future due to transactions entered prior to the inventory count date. When you enter an inventory worksheet adjustment, the count remains the same as of the date of the worksheet.

For another example, you can enter an adjust inventory worksheet dated 10-25-08 and show 10 of your item Deluxe Widget in Location One. You then create an invoice dated 10-24-08 which sells two Deluxe Widgets from Location One. The quantity of the Deluxe Widgets at Location One on 10-25-08 remains at 10, as determined by the inventory worksheet.

Costing History is Averaged

When you use the Adjust Inventory Worksheet with LIFO or FIFO costing, the cost of any item you adjust is averaged. NetSuite ignores LIFO or FIFO, and your costing history is lost. To preserve LIFO or FIFO, use Adjust Inventory for any inventory adjustments. If you use the average costing method, you can make any changes you want on this worksheet.

Calculating On Hand Quantities

Inventory transactions with the same date are calculated in a particular order to find the On Hand quantity of an item. An inventory worksheet transaction posts at the start of the transaction date. Any additional inventory transactions on that date affect its figures.

NetSuite uses the default order transactions to calculate this quantity:

  1. Adjust Inventory Worksheet, Distributions

    Worksheets can also be set to post as the last transaction of the day. For details, read about the Order in Day field below.

  2. Adjust Inventory transaction

  3. Receive Purchase Order

  4. Bill Payment

  5. Bill Credit

  6. Item Fulfillment

  7. Invoice, Cash Sale

  8. Credit Memo, Return Authorization Item Receipts

For example, you enter an invoice dated 1-1-08 selling a quantity of 1 of your item Deluxe Widget. Later, you enter an inventory worksheet dated 1-1-08 with Deluxe Widget showing a quantity of 5 on hand. The On Hand count on 1-1-08 is 4 Deluxe Widgets.

In another example, you enter an inventory worksheet dated 3-13-2008 with Deluxe Widget showing a quantity on hand of 15, valued at $75. Then, you run an inventory report dated 3-13-2008 with Deluxe Widget showing a quantity on hand of 15, valued at $75.


If you enter a backdated inventory worksheet, you may not see the adjustment immediately on associated records and reports. A scheduled task adjusts the affected quantities based on the new quantity and transactions dated on or after the inventory worksheet date.

Adjusting the quantity of an assembly item changes the quantity of the assembly only. It does not change the quantity of individual member items.

Changing Inventory Adjustment Worksheets

When you open an existing inventory adjustment to make changes, only items included in the original adjustment appear in the list. The list shows all items from the original adjustment and cannot be filtered to exclude any of these original items.

Showing all items from the previously saved worksheet ensures that no lines are filtered out and deleted upon saving changes.


When processing transactions, you must submit one page at a time. If you do not submit each page individually, information is not saved and can be lost when you switch between pages. To process multiple pages of information, always submit each page individually.

To use the adjust inventory worksheet:

  1. Go to Transactions > Inventory > Adjust Inventory Worksheet.

    The Inventory Worksheet page appears.

  2. For OneWorld accounts, in the Subsidiary field, select the subsidiary you want to associate with this adjustment.

  3. Set values in fields of each of the following sections or subtabs: Primary, Classification, and Adjustments.

  4. Click Save.

  1. In the Inactive field, select one of the following options to filter the list of items:

    • Select No to exclude inactive items from the list.

    • Select Yes to show only inactive items in the list.

    • Select All to show both active and inactive items in the list.

    Serialized items and lot numbered items do not show in this list whether they are active or not.

  2. In the New Qty column, enter a new total quantity for the item.


    If you use LIFO or FIFO costing, the cost of any item you adjust is averaged. NetSuite ignores LIFO or FIFO, and your costing history is lost.

  3. In the New Value column, you can change the auto-calculated new total value for the item.


    If you use LIFO or FIFO costing, the cost of any item you adjust is averaged. NetSuite ignores LIFO or FIFO, and your costing history is lost.

  4. For items that use bins, you can do one of the following to enter the quantity by which you want to adjust each bin:

    • If you use the Bin Management feature, in the Bin Numbers column, click the field, and then click the Bins icon. On the popup window, enter the quantity for each bin you want to adjust, and then click Done.

      Alternatively, you can directly enter the bin with the quantity in parenthesis, in the following format: Bin#(Quantity). Separate multiple bins with a comma.

      Example: Bin101(50), Bin102(43)


      You can enter only bins associated with the item, which are listed on the Bin Numbers subtab of the item record. See Setting Up Item Records for Bins.

    • If you use the Advanced Bin/Numbered Inventory Management feature, click the Inventory Detail icon to enter the bins and quantities on its popup window.

To enter values for another item, repeat steps 1 to 4.

After you save the worksheet, your inventory is updated. You can access the associated item records to view the updated inventory details.

To view your inventory worksheets, go to Transactions > Inventory > Adjust Inventory Worksheet > List.

Related Topics

Inventory Management Overview
Basic Inventory Management
Multi-Location Inventory
Bin Management
Handling Backorders
Advanced Inventory Management

General Notices