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.
Best answer by asanka
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.
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.
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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
