Symptom
* How to import Serial/Batch Numbers into SAP Business One via Data Transfer Workbench (DTW).
* Import Serial/Batch Numbers into SAP Business One via Data Transfer Workbench and you receive error : ‘Cannot add row without complete selection of serial/batch numbers’
Cause
Consulting
Solution
Importing Serial/Batch Numbers into SAP Business One can only be possible with Stock Transaction.
Assigning Serial/Batch Numbers is done upon receiving stock either via Goods Receipt or Purchase Invoice etc.
Releasing Serial/Batch Numbers is done when issuing stock either via Goods Issue or Sales Delivery Note etc.
Below are the key points for successfully importing Serial/Batch Numbers into SAP Business One :
1. In the Document_Lines.csv, LineNum field should be filled according to the number of Items in the file.
2. In the BatchNumbers.csv and SerialNumbers1.csv, BaseLineNumber corresponds to the LineNum in Document_Lines.csv.
3. In the BatchNumbers.csv and SerialNumbers1.csv, LineNum should be an increment starting from 0 for every BaseLineNumber in BatchNumbers.csv and SerialNumbers1.csv.
Important Points :
* If you are assigning Serial/Batch Numbers either via Goods Receipt or Purchase Invoice etc, The total Serial/Batch Quantity required for the Item would be :
Total Serial/Batch Quantity required : Quantity (in Document_Lines.csv) * Items Per Purchase Unit (For the Item)
* If you are releasing Serial/Batch Numbers either via Goods Issue or Sales Delivery Note etc, The total Serial/Batch Quantity required for the Item would be :
Total Serial/Batch Quantity required : Quantity (in Document_Lines.csv) * Items Per Sales Unit (For the Item)