I have some leftover inventory in miniscule amount...
# inventory
j
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...
t
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
👍 1
a
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.
p
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.