Generate the Inventory Value Report as at 31st December 2022

SOLVED

Hi, I want to know, which is the correct way of getting Inventory Value Report as of end of the year (31st December 2022). Today 2nd March 2022. If we Generated Item Valuation Report using Transaction Cost ( Changing the year end date to 31st December 2022) , it equals to the value of the GL Inventory Value as at 31st December 2022. however, as Location Detail costs report does not have option to select the yearend date( 31st December 2022), That total value completely different with the GL Inventory Value as at 31st December 2022. Please Advise ?