Forum Discussion
Age FIFO Inventory
Hi stevedep - first off, thank you so much for the time and effort! Quite impressed with the complexity of the solution.
It does work when only looking at those first 4 rows of the data, however, when I add the rest of the dates back I run into issues.
Here's a screenshot of all records in my data set. The first -1 is substracted flawlessly, but the -3 should be taken from the records above respectively. Why would it not take that record into account?
Hi alexricker0928 ,
I see now. I have updated the file to work with running totals, the RT will accumulate purchases or sales. For each row the RT of a purchase is compared to the minimum RT value of the sales. If the sum of the two is below 0 this means that this item has been sold later in time.
See below. The link to the file is still the same. Kind regards, Steve.