1. SCM (Supply Chain Management)
  2. Inventory Management
  3. Basic Inventory Management
  4. Bin Management
  5. Updating Bin Putaway Worksheets

Updating Bin Putaway Worksheets

Important:

The functions discussed in this topic require the Advanced Bin / Numbered Inventory Management feature to be enabled.

On a worksheet, you can enter the bin put away details, which include the bin numbers and item quantities. For advanced Bin Management, you can use worksheets to assign bins to specific lots or serial numbers.

If you have existing items or quantities prior to enabling basic or advanced Bin Management, worksheets enable you to assign the bins. You can also use them if you do not specify bins on inventory transactions, such as inventory adjustments or transfers.

Based on your worksheet entries, NetSuite automatically adjusts on-hand bin quantities. You can view the adjusted quantities on item records. For more information about worksheets, see Putting Away Items in Bins.

Depending on which bin feature you use, follow the instructions in one of these topics:

To update a basic putaway worksheet:

  1. Go to Transaction > Inventory > Bin Putaway Worksheet.

  2. The Date field defaults to today's date. You can edit this date to put away items from previous days.

  3. If you use the Multi-Location Inventory feature, select your location.

  4. In the Memo field, you can enter notes for this day's putaway sheet.

  5. The Quantity column shows the total on-hand amount for each item at the location selected. Click this field to edit the total quantity.

  6. The Units column displays the unit of measurement used to determine the on-hand quantity. Click this field to select a different unit of measurement.

  7. The Bins column displays the bins associated with each item.

  8. The Bin Numbers column displays the preferred bin by default.

    • If the total quantity is placed in the preferred bin, no edits are needed.

    • If some items were or will be placed in some of the other bins listed in the Bins column, click the Bins icon. Edit the quantity for each bin, and click Done.

      You can also enter bin numbers separated by commas with on-hand quantities in parentheses. For example, you can enter A101(50), A102(43).

  9. Click Save.

To update an advanced putaway worksheet:

  1. Go to Transaction > Inventory > Bin Putaway Worksheet.

  2. The Date field defaults to today's date. You can edit this date to put away items from previous days.

  3. If you use the Multi-Location Inventory feature, select your location.

  4. In the Memo field, you can enter notes for this day's put away sheet.

  5. The Quantity column shows the total on-hand amount for each item at the location selected. Click this field to edit the total quantity.

  6. The Units column displays the unit of measurement used to determine the on-hand quantity. Click this field to select a different unit of measurement.

  7. Click the icon in the Inventory Detail column next to an item to edit bin quantities.

  8. In the Inventory Detail popup window, specify the bins and quantities to be put away as follows:

    1. If the item is numbered, in the Serial/Lot Number list, select the appropriate number.

    2. In the Bin list, select the bin you want the items put into.

      The Bin column displays the preferred bin by default.

    3. In the Quantity field, enter the quantity of items to be put in this bin.

    4. Click Add.

    5. Repeat steps a - d to put away more of this item in other bins.

    6. Click OK.

  9. Repeat steps 7 and 8 for any additional items you want to make changes to.

  10. Click Save.

Related Topics

General Notices