on 07-25-2011 1:09 PM
It seems like that all standard asset reports can not display fields from the master record of the asset like room, user fields, etc. But those fields are there in the selection screen of standard reports. Is there standard report that can show me the asset values and fields from the asset master record?
Consider creating a query
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Have you checked asset history report?
Regards,
Sayujya
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
A comment from my side, for fixed asset related data like the fields you mentioned are available in asset history sheet report and all available fields are easily exported into Excel sheet if only the 'Use ALV grid' indicator under the 'Display options' is activated. Alternatively building a separate report using the query tool as mentioned.
However from end user perspective, the former may be readily accessible and with minimum maintenance when compared to the later as it requires the knowledge of database table relationship and query creation.
Thanks for the attention.
Kind regards,
John Chin
Also I tried to create query by joining tables ANLA, ANLZ, and ANLC (when trying to use logical database ADA I got error No component exists with the name "VALUE0". .InfoSet Cannot be Used for InfoSet Query) but there I can't find how to add the report date and the revaluation value (as we revaluate some assets).
User | Count |
---|---|
91 | |
8 | |
7 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.