Example of Preparing Import Data - SAP Documentation

Example of Preparing Import Data

Procedure

Define an import template, as below:

Column

Field

A

Item Code

B

Item Description

C

Warehouse Code

D

Bin Location Code

E

Counted Quantity

F

Bar Code

G

UoM Code

H

Batch Number

Create an Excel file, as below:

	A	B	C	D	E	F	G	H	I	J	K
1	Item Code	Item Description	Warehouse	Bin Location	Counted Quantity	Bar Code	UoM	Batch	Counter Type	Counter ID	Individual/Team Counter
2	I006	I006	03	03-SYSTEM-BIN-LOCATION	20	1234	BOX	B60000	U	user2	I
3	I006	I006	03	03-SYSTEM-BIN-LOCATION	20	1234	BOX	B60001	U	user2	I
4	I006	I006	03	03-SYSTEM-BIN-LOCATION	20	1234	BOX	B60000	U	user3	I
5	I006	I006	03	03-SYSTEM-BIN-LOCATION	18	1234	BOX	B60001	U	user3	I
6	I006	I006	03	03-SYSTEM-BIN-LOCATION	19	1234	BOX	B60000	U	user4	I
7	I006	I006	03	03-SYSTEM-BIN-LOCATION	20	1234	BOX	B60001	U	user4	I
8	I006	I006	03	03-SYSTEM-BIN-LOCATION	21	1234	BOX	B60000	U	user5	I
9	I006	I006	03	03-SYSTEM-BIN-LOCATION	20	1234	BOX	B60001	U	user5	I
10	I006	I006	03	03-SYSTEM-BIN-LOCATION	15	1234	BOX	B60000	U	manager	T
11	I006	I006	03	03-SYSTEM-BIN-LOCATION	8	1234	BOX	B60001	U	user1	T
12	I006	I006	03	03-SYSTEM-BIN-LOCATION	15	1234	BOX	B60000	U	user2	T
13	I006	I006	03	03-SYSTEM-BIN-LOCATION	7	1234	BOX	B60001	U	user2	T

After finishing entering counting results into the Excel file, delete the first row (A1 - K1), leaving only the counting data.
Save the Excel file as a TXT file (tab-delimited, unicode, or MS-DOS).
Import the TXT file into the Inventory Counting window in SAP Business One.

More Information

Importing Counting Results from Microsoft Excel