Mass Asset Revaluation using Excel File upload
In this Blog post you will learn about Mass Assets Revaluation process, As such Revaluation of assets is a daunting task, more so when you are faced with the challenge of revaluation of multiple assets in one go and most of us would have run into issues while executing revaluation.
I am sharing the solution which could help in mitigating the issues faced in mass asset revaluation.
Let us now look into the aspects of mass assets revaluation process using excel file upload functionality in transaction AR29N.
Prerequisites for Assets Revaluation:
Define Revaluation measure in AUFW [specify Base area & Revaluation area, select depreciation area 01 or 32]
Create a new Revaluation transaction type, say Z80 [use standard transaction type as reference]
Create Excel file template in the required format to include data like Asset number, Sub numbers and value and save it on Desktop.
let us perform mass asset revaluation by using transaction AR29N
Select tab ‘New Valuation Multiple Assets’ and upload the excel file with list of Assets for Revaluation, also input the right parameters like Transaction type, Revaluation measure and check the create revaluation area.
Note: Ensure that Depreciation is posted as on the date of Revaluation and also Depreciation key with multilevel method is assigned to all those assets which are to be revalued
after execution the system will display all the assets, as shown in the below image
As can be seen, Depreciation for previous year and current year is written back along with revaluation amount and the asset value is increased/decreased by the net amount. System generates Accounting document with postings to relevant G/L Accounts.
Spool file is generated which can be displayed from SM37 transaction.
after Revaluation new Asset values are reflected and can be displayed in Asset Explorer transaction
you can also navigate to FI document by double clicking on Transaction.
The above solution would help to a great extent in executing mass assets revaluation and would make your life more easier.
This completes my blog post on mass asset revaluation process, in my next blog post i will try and cover some more Asset processes.
Hope you like this blog post………Happy learning !!
Feel free to reach out for any issues or concerns.
Thanks Sanjay Great blog
Could you please share the excel format and please i want to know if i want to edit the depreciation start date because i have fully depreciated assets want to revaluate them.
Hi Ahmed, use the attached file format for AR29N for "New Valuation multiple assets"
Nice documentation on Asset mass revaluation.
You have suggested to create new transaction type (Z80 as example you have quoted). Is it really necessary to create a new one? If yes, why Transaction Type 800 is not sufficient to use? Would there be any pros and cons?
Further you have indicated to check the "Create Revaluation Area" under tab "New Valuation multiple assets" whereas before that you advised to use Depreciation Area 01 (or 32) in AUFW. If I am using Dep Area 01 (which is already defined in system) in AUFW then checking the "Create Revaluation Area" in AR29N does not seem consistent. If I am wrong please explain.