How to Import Fixed Assets Legacy Data into SAP Business One from Excel
If you are implementing SAP Business One Fixed Assets solution and you are confused how to import the legacy data, this article will help you. A simple example will show you how to import opening balance from Excel. Business Scenario: Your company owns a car. It was acquired in September 2016 with price 600000 EUR and it is expected to be used for 10 years. This car started depreciation since September 2016 and 20000 EUR has been depreciated in year 2016. Now you would like to implement the Fixed Assets solution since year 2017 and import the value of this car into SAP Business One. What need to be done? Steps: Enable Fixed Assets solution Go to Administration -> System Initialization -> Company Details -> Basic Initialization, tick the checkbox ‘Enable Fixed Assets 2. Define the basic parameters for Fixed Assets management Account Determination: Administration -> Setup ->Financials ->Fixed Assets -> Account Determination ...