vpcontroller
Level 11

Reports and accounting

Malcolm's assessment is accurate on this one, I think.

 

Your original question is how FIFO work when received item multiple time in a single day?

 

If three transaction types (inventory starting value, Bill and Invoice) happen on the same posting date, FIFO qty/cost should first come out from inventory starting value transaction because that was the first entry with "As of date" in QBO. You can't enter Bill (or Invoice) before 'As of date' in QBO.


That's how normally FIFO inventory system should work. Since it's not working that way in QBO, it's a BUG in the system. Someone needs to report this to the Product Development Team and tell them to fix it. See screenshot #1 below.

 

As a workaround for now, If you change the "As of date" a day early for inventory starting value transaction, it should work fine as in your 1st example. See screenshot #2 below.

 

inventory_valuation_detail_same_date.PNGinventory_valuation_detail_same_date2.PNG