Fixed Asset SAP Business One 9.0 Configuration

former_member196081 · ‎06-10-2013

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