How to Use the Adjust Inventory Worksheet

Primary

• Reference # - If enabled, you can enter a unique number to identify and track of your adjustments.

  This number appears on register and account detail reports.

  Note: If you use auto-generated numbering, a reference number can be manually entered if you allow the override of auto-generated numbers for an inventory adjustment. Otherwise, the reference number is generated and cannot be changed after the transaction is saved.

• Adjustment Account – Select an account for this adjustment.

  Usually, this is an expense account for inventory adjustment.

• Estimated Value – This field shows the total value of the change in your inventory. When you submit the adjustment worksheet, the current cost is determined from your inventory database and your adjustment totals are updated.

  • Estimated Total Value = sum(new Value) - sum(Value As Of Date Above)

  The Estimated Total Value represents the changed valuation of the worksheet transaction, not the new value for the items. So, you have an item with an on-hand value of $25. You adjust it using the worksheet to have a new value of $100. After you save the worksheet, the estimated total value of the worksheet is $75, not $100.

• Transaction Order - Select one of the following options for when you want to post this worksheet:

  • First in Day – This option posts the worksheet at the beginning of the day and does not include additional inventory transactions entered during that day.

  • Last in Day – This option posts the worksheet at the end of the day and includes all inventory transactions entered during that day.

• Date – This field is populated with today’s date. You can enter or select another date.

• Posting Period – Select the posting period on which you want this transaction to post.

• Memo – (Optional) Enter a short memo for this adjustment.

  Memos appear only on account registers and on the account detail report.

Classification

• (Optional) To classify transactions, you can select values in the following fields: Department or Class

• Location – Select the location where you need to make inventory adjustments.

  When you select a location, the quantities of items in that location show in the list at the bottom of the page.

Adjustments

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.

   Note: 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.

   Note: 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)

     Note: You can enter only bins associated with the item, which are listed on the Bin Numbers subtab of the item record.

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