The inventory adjustment transaction allows you to change the quantity and value of an item without entering a purchase order.

If you have a mismatch between on-hand quantity versus system quantity, we need to make an adjustment to do the correction, and doing this in ExtendInsights is very easy.

💡 Tip: It is best to check out the forms and fields and identify the header, column, and required fields in NetSuite that you may need in building the template.

If you are using NetSuite Classic Interface, you can go to:

Transactions>Inventory>Adjust Inventory

Add the following fields if you have serialized or lot number items (Inventory Detail):

Step 1: Fill out the table with Account for the adjustment, item, location, and adjust qty by field values.

Step 2: Go to the Upload to NetSuite button and click Upload Records. The internal Id will show up in column B once successfully generated in NetSuite.

Add the following fields if you have serialized or lot number items (Inventory Detail):

Step 1: Fill out the table with Account for the adjustment, item, location, and adjust qty by field values.

💡Tip! Repeat the items to match the number of item quantity due to the number of rows for the serial/lot/bin number association within the inventory detail.

Step 2: Go to the Upload to NetSuite button and click Upload Records. The internal Id will show up in column B once successfully generated in NetSuite

Since you have the TranID, you can use that to easily search your newly created record in NetSuite.

Step 1: After the record has been created, click Reload Records then pull the new record to the template. It will give an automatically generated TranID. Copy the TranID value.

Step 2: In NetSuite, go to the search box and paste or type the TranID