This window is used to import Accounts, Journal Entries, Sales and Purchasing and Item data. The import file must be in a specific Excel format or an Access text file. Columns within the file can remain empty, but cannot be deleted as the order of the columns is crucial. Certain fields are mandatory, for example the G/L Accounts field must have a value when importing an Accounts file.

Fields on the right side of the window should be defined, to ensure that the correct columns are imported into the most specific locations. If required, specific ranges can be defined for the accounts and customers and/or vendors. An account defined in an account field on the left side of the window can become a G/L Account in the import.

For more details about this procedure and for information about the file format, contact SAP Business One Support. This window is only available in certain localizations.

To display this window, choose  Administration Data Import/Export Data Import Comprehensive Import window.