cancel
Showing results for
Did you mean:
Level 2

QBO
When adjusting inventory Qty based to the physical inventory when making adjustments that reduce the listed inventory in QBO at times the one adjustment makes three entries instead of just one entry. It does Total correctly but why does it do this only sometimes ?

I have successfully went back into the adjustment and deleted the previous adjustment and just re-added the Qty on Hand in the New Adjustment section and it fixes this, but for some Items no matter how I do this it creates three Inventory Adjustments to get to the correct Qty on Hand.

Is it due to varying cost of the product ? If so how in the world does QBO determine this based on a specific date like the end of last quarter ?

If the price differences is not causing this, how do I stop it ?

I could just leave them, because the totals are correct, but I would prefer that QBO would stop randomly do this ...

It seems to also be an issue only if I adjust Qty down with a negative number ...

Solved

Level 15

You should not readjust the way QB does the inventory adjustment.  QBO is FIFO, first in first out, and the adjustments relate to the date order of the purchases.  ie

first purchase of 7 goes to zero, 7*1.25=8.75 to shrinkage

second purchase of 4 goes to zero, 4 * 1.00=4.00 to shrinkage

third purchase of 5 goes to 3, 2*1.50=3.00 to shrinkage

Level 15

You should not readjust the way QB does the inventory adjustment.  QBO is FIFO, first in first out, and the adjustments relate to the date order of the purchases.  ie

first purchase of 7 goes to zero, 7*1.25=8.75 to shrinkage

second purchase of 4 goes to zero, 4 * 1.00=4.00 to shrinkage

third purchase of 5 goes to 3, 2*1.50=3.00 to shrinkage

Level 2

Rustler

Thank you ... I suspected this was the case, but it didn't seem to do it consistently ...

So ... if by reducing the inventory it adds two lines ... it is stating there were two cost prices that caused this... if it added three lines ... then three cost prices, etc ...