I am having trouble understanding the aged inventory report. See the output of one of the items below. If I just looked at the over 730 days column I would think that I had 602 quantity that was over 730 days old. But in fact I have to look at the other columns to then see that it was all sold, due to the negative numbers. This isn't a very easy to read report, and different than most conventional aging reports. Is there any work around or am I reading this wrong, its not very useful.
-------0 To 180Days------- | ------181 To 365 Days------ | ------366 To 730 Days ------ | ------ Over 730 Days ------ | ||||
Quantity | Cost | Quantity | Cost | Quantity | Cost | Quantity | Cost |
-3.00 | -1,278.26 | 0.00 | 0.00 | -597.00 | -258,438.56 | 602.00 | 260,569.00 |