Fixed Asset DTW.

[Former Member]

Dear Friends,

I'm trying to upload 'Fixed Asset' Master data for a client. Basically I'm new to 'Fixed Asset', so please

help me out.

I have following Excel datasheet which I want to upload in the DTW template provided.

Asset Name	Assets Category	Depreciation Method	Useful Life of Asset	Remaining Useful Life	Depreciation Rate	WDV As on 01.04.2015
Air Compressor - Co Co Outlet	Equipments	WDV	10	8	28.63%	9,545.75
Air Compressor - Co Co Outlet	Equipments	WDV	10	8	28.63%	9,329.48
Air Compressor - Co Co Outlet	Equipments	WDV	10	8	28.64%	7,226.00
Air Compressor - Co Co Outlet	Equipments	WDV	10	8	28.64%	6,756.62
Air Compressor - Cofo Outlet	Equipments	WDV	10	8	28.70%	36,285.09
Bidadi Land Fencing	Buildings	WDV	60	57	4.89%	126,689.99
Bore Well	Buildings	WDV	60	55	4.92%	48,329.50
Bore Well	Buildings	WDV	5	5	45.07%	154,563.52
Building At Ameenabagh	Buildings	WDV	60	58	4.93%	279,583.55
Building At Ameenabagh	Buildings	WDV	60	58	4.95%	330,088.93
Building At B.M.Road	Buildings	WDV	60	57	4.30%	9,516,000.22
Building Upgrading - At Mysore Road	Buildings	WDV	60	56	4.99%	1,503,212.37
Capital Work In Progress	Capital Work In Progress	WDV	0	0	0.00%	928,214.00
Computer	Computers	WDV	3	1	87.17%	2,662.50
Computer	Computers	WDV	3	1	89.10%	2,311.50
Computer	Computers	WDV	3	1	89.33%	487.95
Computer	Computers	WDV	3	1	90.44%	2,939.50
Computer	Computers	WDV	3	2	72.23%	65,711.11
Computer	Computers	WDV	3	2	73.23%	2,364.29
Computer	Computers	WDV	3	3	63.16%	10,264.25

My basic questions are:

1. There are multiple assets with same name; do I need to create a separate asset master for each items or consolidate into one Asset Master?
2. There are different depreciation % for each items; do I need to create different depreciation types?
3. Please explain where the data in the columns “Assets Category”, "Depreciation Method", "Useful Life of Asset", "Remaining Useful Life", "Depreciation Rate", " WDV As on 01.04.2015" should go in DTW template?

Thanks in advance.

With Warm Regards

Shiva Venkat

[julie_jamieson2]

You should create one Master data record for each asset, as they may be retired at different times. The name should be sufficient to identify each asset separately.

Each asset belongs to an asset class, each class can have it's own account determination for accounting purposes.

There needs to be a depreciation type set up for each rate, or you can use useful life for straight line.

All the set up needs to be completed before creating the master data.

I recommend creating a test system and testing all the options before committing the data to the live system, configuration from test can be copied to production using Quick Copy once it has been settled on.

[Former Member]

Hi V. Siva Shankar,

I think you should import Fixed Asset from SAP B1 which is easy.

You can do it in the menu path: Administration -> Data Import/Export -> Data Import -> Import Fixed Asset Master Data from Excel.

http://help.sap.com/saphelp_sbo900/helpdata/EN/94/7e131c04ca428d933f5375a98aef0e/content.htm

I think this will help you.

Regard,

Hang