SAP launched Fixed Asset add-on as the part of solution in 9.0 for all location.
Below are the steps to import the Fixed Asset master data successfully.
First of all Enable the Fixed Asset functionality as given in below screen.
Go to Administration > System initialization > Company Details > Basic Initialization Tab > and Tick on Enable Fixed Asset Check Box.
Now define the Masters and FA set up information.
First Define the account determination as shown in below Screen.
If you will not determine the Accounts for any group then system will generate errors when you will start to import the Master Data.
After configure the account determination, Define Depreciation Type as per your requirement as below
Now define the Asset Classes as below and link the account determination group with depreciation area as below
Now Make Asset group and Depreciation Group at Fixed Asset Master Data as below.
Now Define your template in excel with columns as below
|Item code||Item Name||Asset Class||dep Group||Asset Group||Dep Type||Dep Area||Usefull Life|
|FA00001||Voltas Split 2.0 Tons||AIR CONDITIONER||A C||A C||SLM4.75||Main Books||252|
|FA00002||Voltas Split 2.0 Tons||AIR CONDITIONER||A C||A C||SLM4.75||Main Books||252|
|FA00003||Voltas Split 2.0 Tons||AIR CONDITIONER||A C||A C||SLM4.75||Main Books||252|
|FA00004||Voltas Split 2.0 Tons||AIR CONDITIONER||A C||A C||SLM4.75||Main Books||252|
|FA00005||Voltas Split 2.0 Tons||AIR CONDITIONER||A C||A C||SLM4.75||Main Books||252|
|FA00006||Voltas Split 2.0 Tons||AIR CONDITIONER||A C||A C||SLM4.75||Main Books||252|
(Note:: I have removed columns Capitalization Date and depreciation start date from above txt file. These columns were generating the issues at the time of capitalization and run depreciation Time. ) ℹ
[Note :: SAP has been provided DTW format to import the fixed asset master data with PL07 onwards 🙂 .check link
Save the above template as .txt file.(Please remove the header line before saving) .
Now go to Data Import/Export menu as below and choose the column in sequence as you mentioned in .txt file and Import.
Note :::: If you are importing FA Master DATA for more then one Fiscal Year then first defined all fiscal year in System and execute all fiscal year one by one from lower to top through below screen.
Note :: There can be some issue due to Transaction notification. If you do face as such issue than please comment all transaction notification related to ITEM MASTER.
Please check below also specialy Mr. Jose reply..
You can Import fixed assets that have to be capitalized for current Financial year as NEW:
a) The start depreciation date is empty
b) The APC, Accumulated depreciation are empty
c) Capitalization date is empty
Once you have imported the asset as ‘new’, you can use application or DTW to enter the capitalizations
This is a logical consequence of system definition documented in the Help File: when you import an asset in any given year the values that you enter must be the values that the asset has on the first day of the fiscal year selected for the import:
BASIC RULES FOR IMPORT FIXED ASSET FROM EXCEL 9.0 (some documented and some based in my experience)
a)Capitalization date, if entered must be <= first day of fiscal year selected for import
b)Depreciation start date, if entered must be <=first day of fiscal year selected for import
c)Remaining useful life = Total number of months of total useful life -Number of calendar months counting from the calendar month of Depreciation start date until the last month of fiscal year prior to the year selected for import
d) If Remaining Useful life is 0, then APC – Accumulated Depreciation – Salvage Value =0
e) Having Salvage Value is only compatible with Depreciation type that has marked a % of salvage value <>0
f) If Asset Class selected has several areas active, all areas must have value in the import
g) Depreciation areas ‘ derived’ must have exactly same values than the area that is derived from, except accumulated depreciation and depreciation type, that can be different,
h) Values must be defined always for ‘main’ Depreciation Area
I) Keep the same date format order and separator used in company database general settings for date type values. Only change the alphanumeric to numeric, example ‘July’ , is 07
j) For numeric values: do only use the decimal separator if the value has decimals. For example ‘10,00’ should be entered as 10
k) For numeric values ensure that you use the same decimal separator used in company database general settings ‘,’ or ‘.’
l) Do not use thousands separators, example ‘10.000,43’ should be entered as 10000,43
j) Do use the same number of decimals that are allowed in company database general settings
k) Use Item No in the template as the first column A
Note: Check below thread if there is any issue in FA import:::
Check Below Threads for Fixed Asset related queries or issues.
The specified item was not found. ——-its about multiple depreciation areas
**********you can cancel the “Depreciation run” now in latest PL of SAP B1 V9.0 and V9.1.
Please share your suggestion and feedback too so that the document could be helpful for others.
CHEERS 🙂 .
Edit..Now the size of pictures has been reduced as suggested by friends.
Please rate the document if you feel helpful this.