This error has been bugging me for weeks. I want to adjust inventory out but I just keep getting this darn error. Sometimes it says the bin number isn't available.

Just an opinion, did you checked your Item on "Reallocate Items" page? Maybe that'll show you a way.

Also check if the item is on your bin put away worksheet

or if you use "Item Status", Check the item status on the last transaction

I FINALLY FIGURED THIS SHIT OUT!!!

Great netsuite What was causing?

The problem arises when you have a fractional quantity in a lower unit of measure for example you have 160.123456789 OZ. My inventory report was specified in pounds so the quantity was 10.0077160493. Now the problem was that netsuite rounded it UP so the quantity in pounds was higher that its respective amount in ounces (And therefore unavailable in the bin or inventory number) I realized this in the cases that NetSuite rounded it down and I was left with a tiny, tiny amount such as 0.00000034 of an Ounce. The solution was to adjust it in Ounces. This worked out. I swear to god I have an extra two hours a day now that I can fix this stupid inventory.

Yeah luckily we haven't ran into this yet.

Well I think the best way forward for my company is to keep the UM on all transactions consistent. The only reason we had this issue in the first place is because on some BOM's we consumed items stored as bags as pounds. If you only reduce or increase the inventory by one UM You won't run in to this problem

yes it is nice to be able to put in different units for Purchase, Stock, Sale and consumption but then you run into this kind of problem.

Good to hear you passed this Issue Alan, let's see what NetSuite will give us next time netsuite

Always utilize the smallest UoM as the base also, it helps alleviate the potential for fractional quantities... You can also use an Inventory Balance search to validate inventory with attributes.

Same for us metric users....with device based picks failing in WMS it was great when we could fix so readily. UI user accidentally used base UOM when trying to transact stock UOM from two bins. Left rounding error in both bins! Quick bin transfer resolved.

I should mention that this happens with inventory counts and is a clear bug in netsuite. Suppose I specify "Jug (13 pounds)" as a unit of measure in my count. I count 0 in the bin so netsuite should adjust it whatever quantity is in the bin out. Let say I had 1 jug in the bin of which I used 30 ounces in a bom. It then got damaged or something so it's gone. In terms of jugs I have 0.85576923076 of a jug in the bin. Netsuite rounds to 0.85577 jugs in a bin and tries to adjust it out. The problem is that as far as the backend goes netsuite counts 178 in oz as the base unit (13*16)- 30 oz that I used. After finishing the inventory count and approving it Netsuite tries to adjust 0.85577 jugs. Netsuite does the math and converts it to ounces. 0.85577*13*16 = 178.0016. Netsuite returns am error saying that the bin is not available as it is missing .0016 of an ounce. This is a tiny fraction but enough to fail. Obviously I cherry picked the numbers to give an error but in my industry (food manufacturing) this was happening all the damn time.