Enterprise Resource Planning Blogs by Members
Gain new perspectives and knowledge about enterprise resource planning in blog posts from community members. Share your own comments and ERP insights today!
cancel
Showing results for 
Search instead for 
Did you mean: 
former_member196081
Active Contributor

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.

Depreciation Group:

Now Define your template in excel with columns as below

Item codeItem NameAsset Classdep GroupAsset GroupDep TypeDep AreaUsefull Life
FA00001Voltas Split 2.0 TonsAIR CONDITIONERA CA CSLM4.75Main Books252
FA00002Voltas Split 2.0 TonsAIR CONDITIONERA CA CSLM4.75Main Books252
FA00003Voltas Split 2.0 TonsAIR CONDITIONERA CA CSLM4.75Main Books252
FA00004Voltas Split 2.0 TonsAIR CONDITIONERA CA CSLM4.75Main Books252
FA00005Voltas Split 2.0 TonsAIR CONDITIONERA CA CSLM4.75Main Books252
FA00006Voltas Split 2.0 TonsAIR CONDITIONERA CA CSLM4.75Main Books252

(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 :smile: .check link

Fixed Assets by DTW]

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.

Fixed Assets Import in v9

Please check below also specialy Mr. Jose reply..

Fixed Assets Imports Issues

{

You can Import fixed assets that have to be capitalized for current Financial year as NEW:

Meaning:

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:::

http://scn.sap.com/thread/s3373105

Check Below Threads for Fixed Asset related queries or issues.

Assistance needed with importing fixed assets with salvage value in SAP 9.0

SAP 9.0 Fixed Assets

Fixed Asset APC displays 0

SAP Business One 9.0 Fixed Assets, change existing depreciation

Asset Class Transfer

Fixed Asset Mode

Calculation Base in Fixed Asset

Fixed Asset with later capitalization date

Documents for Fixed Assets module in SAP B1 9.1 India Localization

Fiscal Year Change Failure

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 :smile: .

Edit..Now the size of pictures has been reduced as suggested by friends.

Please rate the document if you feel helpful this.

Regards

Deepak Tyagi

64 Comments