When importing data from excel to create a target group, you must first configure the definitions for the import, according to the following rules:
· Files must not contain a title row or any blank rows.
· Business partner and item numbers must not contain any of the following invalid characters:
! < > * ? % { } =
· Microsoft Excel files must be closed before the import.
· Microsoft Excel files must be saved as .txt files (text files with Text Only).
· Import data must be saved in columns A to BT in the Microsoft Excel table. Some columns can have empty fields.
· The number of characters in the cells of the Microsoft Excel table must not be greater than the length of the corresponding fields in SAP Business One.