Hi Jing,

Are you changing the Item Valuation report date to be the same as your year end date? If you are modifying the report date, then the report will recalculate the amounts as of that date. The caveat is that a complete transaction history is required in order to be able to do this recalculation successfully. If any pertinent IC Transaction History records were purged, then amounts on the Item Valuation report with an edited date are not guaranteed to be correct.

You indicated that amounts did not match 3 years ago, different by the same amount. It is possible that an error occurred that long ago or longer. To attempt to track this down, you would have to go back as far as the last time amounts did reconcile.

There are other threads in this forum related to attempting to track down differences in balancing to the GL. Using the Search function may be able to bring up a link similar to what you are experiencing and some help that works for you too. Try using +item +valuation as a search term.