I have a customer on 8.5, who run their stock list at the end of each month into Excel. They do this in the first week of the following month, setting the date to the end of the last month.
If they now go back and re-run the Stock List at the end of a previous month, they are getting different values for the some items. The quantities always match so this is not due to some backdated stock records. This even happens if we set the date back to the very first day, when the only stock transactions were goods receipts for the opening stock. The Stock List on that date shows a different value for some items, compared to the value on the goods receipt.
This customer is running a FIFO cost model. I don't understand why the Stock List value is changing. Any ideas?