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.