Skip to Content
0
Former Member
Feb 19, 2009 at 05:52 PM

SAP fixed asset add-on. Not able to import master data using upload pgm.

55 Views

Hi all,

I am trying to import fixed asset master data using an excel file into sap B1 2007a patch level 42. I am able to run the import transaction. It tries to process and then giving me a message ' Import end: Number of successfully imported assets: 0. Number of processed assets:2. We have looked at the event log file and couldn't find anything related to the upload. I have gone through other posts and didn't face this issue. Any hellp is apreciated.

Path which I am using to upload the fixed asset master master data: Administration --> Setup --> fixed asset --> import fixed asset master data.

Following points (see below) also taken into account while creating the master data sheet.

also replaced the ',' in the csv file to ';' before uploading and changed the fixed asset mode to 'transfer' in the administration --> system initialization > company detaills > basis initialization.

Thanks

Johnson zavier

Mandatory: Item Code = Asset Class; this Asset Class must be previous defined in the Asset Settings (don't change/delete anything in the item-master data - there are the Asset Classes Z-00u2026. Are stored

Description = Description of this Asset

Capitalization Date = do it like this (YYYY-MM-DD). This columne must be a text format

APC = Aquisition/Procuction Cost; when you have digits after coma please use dot for separation - don't use thousand separators; Example 23444.45

Quantity = only mandatory, when you use the same assets stored under one asset number. Example you have ten equal chairs, so you can handle this with one asset number and quantity ten

Dep01 = Depreciation area; this entry must be previous defined in the Asset Settings

Depr Start date 01 = do it like this (YYYY-MM-DD). This columne must be a text format. The beginning must be the first of the month. Please compare it in this case with the capitalization date

Useful Life 01 = calculated in months (not years)

Remaining Life 01 = calculated in months (not years)

Depr Type 01 = Depreciation Type must be previous defined in the Asset settings

Ordinary Depr 01 = ordinary depreciation; this is the comulated value you can see in the asset history sheet from the old asset solution. When you have digits after coma please use dot for separation - don't use thousand separators; Example 23444.45

Unplanned Depr 01 = unplanned/extraordinary depreciation; this is the comulated value you can see in the asset history sheet from the old asset solution. When you have digits after coma please use dot for separation - don't use thousand separators; Example 23444.45

SpDpAcc1 01 = Special depreciation account; when you use special depreciations and you have it to balance on special accounts fill in this account. This is an exeption - in normal projects not needed

SpDpKey2 01 = Special depreciation; when you use special depreciation you have to enter this cumulative value in this field. This is an exeption in normal projects not needed

SpDpAccu2026 = for further special depreciation accounts; This is an exeption

SpDpKey.. = for furhter special depreciation values; This is an exeption

Optional: Vendor Code = when using this please be aware that the vendor code is previous defined in the system

all others = you can use if you want. The only limitation is the type/length of these fields

When you are ready with your entries mark from the first free row on for instance the next 20 rows than right mouse key - delete rows. This is necessary to prevent that in the background are invisible signs

After entering in this default excel all your assets, please save it as .csv file. (the grey message - relation to information of csv - please say yes; when you close than excel a furhter message - would you save.. - please say no now

After entering all data please save it as .CSV file. First grey window (format information) please choose 'yes'. Second window (when you close this file) please choose 'no'.

You have now a .csv file in hands right now for uploading into the fixed assets.

This example you can use for a test-import based on the year 2004