Import Fixed Asset Master Data from Excel Window

Use this window to map the Microsoft Excel sheet columns to the fixed asset data in SAP Business One.

You can save the data mapping method as a template to use directly for future imports.

To access the window, from the SAP Business One Main Menu, choose Administration Data Import/Data Export Data Import Import Fixed Asset Master Data from Excel .

General Area Fields

Import to Fiscal Year
Select the fiscal year of which you want to import the asset values. The system copies the asset values from the Excel sheet to the asset master data in SAP Business One as the values at the beginning of the specified fiscal year.

Use Data Template
If you have saved a data mapping template, you can load the template by choosing (Browse). To save the data mapping method as a template, choose the Save As pushbutton.

Save As
Lets you save the data mapping method as a template for future imports.

Table Area Fields

Column
Displays the columns in the Microsoft Excel sheet.

Field
Select the SAP Business One field to which each column in the Microsoft Excel sheet corresponds. You can select among the following: Item Description – The Item Description field in the asset master data. Description in Foreign Lang. – The Foreign Name field in the asset master data. Bar Code – The Bar Code field in the asset master data. Sales Tax Definition – The Tax Group field on the Sales Data tab in the asset master data. Purchase Tax Definition – The Tax Group field on the Purchasing Data tab in the asset master data. Asset Class – The Asset Class field in the asset master data. Capitalization Date – The Capitalization Date field on the Overview subtab of the Fixed Assets tab in the asset master data. Retirement Date – The date on which an asset retires completely. The value is stored in the database. Asset Group – The Asset Group field on the Overview subtab of the Fixed Assets tab in the asset master data. Depreciation Group – The Depreciation Group field on the Overview subtab of the Fixed Assets tab in the asset master data. Inventory Number of Asset – The Inventory No. field on the Overview subtab of the Fixed Assets tab in the asset master data. Asset Serial Number – The Serial Number field on the Overview subtab of the Fixed Assets tab in the asset master data. Depreciation Area – The Depreciation Area field on the Overview subtab of the Fixed Assets tab in the asset master data. Depreciation Start Date – The Depreciation Start Date field on the Overview subtab of the Fixed Assets tab in the asset master data. Useful Life – The Useful Life field on the Overview subtab of the Fixed Assets tab in the asset master data. Remaining Life – The Remaining Life field on the Overview subtab of the Fixed Assets tab in the asset master data. Depreciation Type – The Depreciation Type field on the Overview subtab of the Fixed Assets tab in the asset master data. APC – The Acquisition and Production Costs field on the Overview subtab of the Fixed Assets tab in the asset master data. Historical APC – The Historical APC field on the Overview subtab of the Fixed Assets tab in the asset master data. Asset Quantity – The Quantity field on the Overview subtab of the Fixed Assets tab in the asset master data. Salvage Value – The Salvage Value field on the Overview subtab of the Fixed Assets tab in the asset master data. Accumulated Ordinary Depr. – The accumulated ordinary depreciation of an asset. The value is stored in the database. Accumulated Unplanned Depr. – The accumulated unplanned depreciation of an asset. The value is stored in the database. Special Depreciation 01, 02, 03 – The special depreciation of an asset in depreciation pool 01, 02, and 03. The values are stored in the database. Accumulated Special Depr. 01, 02, 03 – The accumulated depreciation of an asset in depreciation pool 01, 02, and 03. The values are stored in the database Accumulated Write-Up – The accumulated write-up of an asset. The value is stored in the database.

More Information

Importing Fixed Asset Master Data from Microsoft Excel