Solved

Inventory Value by Asset Class

  • 4 June 2021
  • 2 replies
  • 167 views

Userlevel 4
Badge +7

Is there a place in IFS EE where the Asset class is stored with the Inventory Value?

  We use the inventory value by period to report our total inventory levels, but we would like it by Asset Class.  There are views in IFS that has the information, but the views seem to capture the data when the view is displayed hence the asset class displaying with the historical inventory value is the current asset class, not the asset class when the historical data was taken.

icon

Best answer by asanka 7 June 2021, 00:56

View original

This topic has been closed for comments

2 replies

Userlevel 4
Badge +7

You could get this info with a quick report if you are handy with  abit of SQL. You will need to set up history logging for the field Asset Class. The system then would be able to track the historical value of the Asset Class on a given date. A quick report then can be based of your historical inventory value screen, and then combine with the historical values of the Asset Class to get the info you need.

Userlevel 4
Badge +7

Thank you, we will look into History Logging.  We have not turn that feature on in our system, but it could help us in a number of areas.