Posts

Showing posts with the label SAP B1 fixed asset

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

Fixed Asset Master Data Import Fails - SAP b1

Image
Symptom   Fixed Asset Master Data Import does not import all of the fixed assets, or fails to import Solution  If not all of the fixed assets are imported by the Fixed Assets Master Data Import, you can check the log file for more information. The log file is located in a subdirectory called "SAP Business One Log" that can be found in the temp directory. To access the temp directory, open Windows Explorer and enter "%temp%" in the Address field.  You may find one or more lines beginning with, for example: [date time] BA ER CBAMasterDataTransfer::CBAMasterDataTransfer. The error message and the incorrect data are then added to this initial string. To find out what is wrong in the log file, the following is a diagnosis of the problem from system messages: a) "Import End; Number of imported asset: 0; Number of processed assets: 0; Error:             1". Reason: It is usually due to format error. b) "Import End; Number of imported assets: 0;...