cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Level 2

Multiple Inventory Adjustments

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
Best answer July 17, 2020

Best Answers
Highlighted
Level 15

Multiple Inventory Adjustments

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

 

buy 7, @ 1.25 each

buy 4, @ 1.00 each

buy 5, @ 1.50 each

 

adjust 13 to shrinkage

 

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

 

 

View solution in original post

2 Comments
Highlighted
Level 15

Multiple Inventory Adjustments

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

 

buy 7, @ 1.25 each

buy 4, @ 1.00 each

buy 5, @ 1.50 each

 

adjust 13 to shrinkage

 

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

 

 

View solution in original post

Highlighted
Level 2

Multiple Inventory Adjustments

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 ...

Need to get in touch?

Contact us