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 ?

Parents
  • +1
    verified answer

    This is the way it was designed.  Location Detail report uses what’s in the Location Details window, which is CURRENT quantities and costs (assuming costs have been updated by Day End).  Transaction Costs is the only way to back date this information.  

    And hey, congratulations on the fact that your transaction based report does match your GL!  Many companies make mistakes that cause it to go out of balance.  If your procedures are good, those should be equal, as yours are.

Reply
  • +1
    verified answer

    This is the way it was designed.  Location Detail report uses what’s in the Location Details window, which is CURRENT quantities and costs (assuming costs have been updated by Day End).  Transaction Costs is the only way to back date this information.  

    And hey, congratulations on the fact that your transaction based report does match your GL!  Many companies make mistakes that cause it to go out of balance.  If your procedures are good, those should be equal, as yours are.

Children