After day end today, I checked the Inventory balance in Ledger and compared it to the Item Valuation Report. Ledger was up $1.14. Yeah!

Then I dated the Item Valuation Report back to July 31 and compared it to the Inventory balance in Ledger on July 31 and Ledger is down over $29,000.

Then I dated the Item Valuation Report back to June 30 and compared it to the Inventory balance in Ledger on June 30 and Ledger is down over $16,000.

Then I dated the Item Valuation Report back to May 31 and compared it to the Inventory balance in Ledger on May 31 and Ledger is up over $21,000.

Then I dated the Item Valuation Report back to April 30 and compared it to the Inventory balance in Ledger on April 30 and it crashed "Error Floating point overflow occured when attempting to append record to I/C Valuation Report Temp File".

I tried dating the Item Valuation Report back further (i.e. March 31) but it also crashes.

I was hoping for a fix to the problem of not being able to back date the Item Valuation report. Without back dating, it makes it very difficult to balance IC to Ledger and provide the accountant with a report to show they balance as of year end. There seems to be ongoing major problems with this report related to back dating. As it stands now, I don't think anyone should attempt to back date the Item Valuation report if they are wanting accurate results. There are also some crazy residuals reported with back dating that don't make any sense.

Please let me know if this is being looked at and if and when it will be fixed.