-
New to NetSuite | Inventory Transactions 103: (Part 2) How to Enter an Inventory Adjustment
In our previous article, New to NetSuite | Inventory Transactions 103: (Part 1) Inventory Adjustment vs Inventory Worksheet, we introduced the two transactions commonly used to correct inventory records in NetSuite. We discussed what each transaction does, when to use them, and the key difference between adding to current…
-
Inventory Adjustment for Lot Numbered Items Without Bin Numbers in Bin Enabled Location
Hi Community, How can we perform an Inventory Adjustment in NetSuite for items that have quantities associated with Lot Numbers but do not have Bin Numbers assigned? The location is Bin Enabled, and while trying to adjust the inventory quantity to zero, NetSuite is requiring a Bin Number during the adjustment process. Is…
-
removing inventory that has no lot or bin with many zeros
I am having an issue trying to clear out this inventory with many zeros after the decimal. when I try to put that number into a transfer it gives me 8e-8 on the line and I cannot go any further. How should I get clear this inventory from the system?
-
[COST OF GOODS SOLD]Advise Needed to Adjust COGS after the period is closed
Hi GURUS, I have an scenario where i would like to seek suggestion and advise from the Gurus: ** For your information, we are setting our item's Costing Method = "Group Average Cost". During end of JANUARY 2026, we have created a Purchase and Item Receipt with below information: Quantity = 5 Rate = $5 per unit Once the…
-
How to clear an inventory item when there is no stock, but there is a value
An inventory adjustment was done in July last year for transactions that were in 2023. However, due to the cost field being rounded in the inventory adjustment, this left a value of against the item. What is the correct way of handling this? I need to make the value 0. A journal entry? An item receipt then item…
-
Adjust Wrong lot in Bin using inventory Adjustment
We need to correct quantities that were stored in Bin under the wrong lot and move them to the correct lot. Following the NetSuite Community reference “NSC | Adjust Wrong Lot Number In A Bin — NetSuite Community”, we created both positive and negative lines within the same Inventory Adjustment. However, the est. unit cost…
-
Fixing component inventory after WO and WOC delete
I had made a special WO for a item line on a sales order. Order was for 48 and we built 120. For some reason I could not assign completed parts to another SO so I started deleting WOC and special WO to attempt to fix the issue. Now I have what you see below for 11-0222. I have 120 good pieces for lot P25247A183 but I need…
-
How to clear the inventory value for the items with zero quantity
-
Incorrect Inventory Adjustment Quantity when Using REST API
Greetings— We have an external system that utilizes the REST API to adjust inventory levels in NetSuite. We have noticed, however, that sometimes the adjustQtyBy value that we supply in the request body is not the same value that NetSuite adjusts the amount by. What might cause this to happen? Here is a recent example: The…
-
Unexpected Error When Creating Inventory Adjustment Using Suitescript
Hi, Guys. I created an inventory adjustment transaction using suitescript. The data I entered is the same data as the data I used to create the Inventory Adjustment transaction via the UI. The problem is, when I create a transaction using suitescript, an error message appears as below.…