I have a client with an item that has 2 FIFO tiers: 1 from 2013 with 4 on hand (original qty of 8 when it came from PO) & 1 from 2016 with 5 on hand (original qty of 7 when it came from PO).

Total on hand is correct, but they have had a bunch of POs & SOs in between that should have cleared the 2013 tier by now; they have sold over 100 of this item since 2013.  I've looked at the audit on this item & it has always been FIFO. What would cause this tier to get stuck? I have looked at the record in DFDM & it all looks correct; dates have correct formats, etc. The last SO return was back in Oct 2015 for only 2 pcs, but plenty have been sold before & after that so this return shouldn't have used the old tier.I don't see any IA adjustments where someone could have grabbed this old tier & put items to it.

There are even 6 Negative Tier Adjustments over the years, which doesn't make sense since this old one is still out there. The largest qty on the Neg Tiers is 4 & it happens 4 separate times. I am guessing if it would see this tier, there wouldn't be a scenario to take the qty negative.

It is already starting to relieve the 2016 tier & still has 2013 left to use.

Is there a table that shows the history of a tier? I have looked at the data in the IM_ItemCost & IM_TransactionHistory, but neither give me what I need. Was wondering if I could see the ins & outs of this tier?

I am assuming I can fix it by manually removing it in an IA entry & then putting it back in with a new date.  Just trying to figure out how these get stuck & give an answer to the client instead of "its just a fluke".