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