Multiple Inventory Adjustments

AEIILLC · ‎July 17, 2020

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

Rustler · ‎July 17, 2020

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

Rustler · ‎July 17, 2020

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

AEIILLC · ‎July 17, 2020

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

Topics

Training

Community

Resources

Multiple Inventory Adjustments