I have some leftover inventory in miniscule amounts. For example, 0.0000067 units of one SKU. Every time I try to adjust it out there is still some small amount left over (presumably because of how NetSuite rounds adjustment qualities?) Is there any way to resolve this and completely zero out these items? PS-They are lot numbered items, so I can't use an Inventory Worksheet transaction...

I don't think this will work due to decimals but could be worth testing - can you adjust back to 1 and adjust the 1 out after that i.e 1st transaction - increase 0.9999933 2nd transaction - decrease 1

To fix the fractional item qtys that are 7 or 8 decimal places long. On the Inventory Adjustment sublist line you would need to change the Units field to the Base UoM for that item and then decrease your remaining qty to bring it to zero. This is a UoM setup issue when setting up the Multiple Units Of Measure tables.

Do you have multiple units of measure? when cleaning up tiny amounts I make sure i'm using the smallest unit of measure for that item.

I solved this by creating a UOM that was super small, something like 0.00000001 of the base. Then I used that UOM when adjusting out the small quantities. Since the adjustment was using integer quantities of the fractional UOM, NetSuite accepted it and the quantities were gone.

Thank you for the update, good to know for future