In this article, we will show you how to import serial numbers into ABRA Flexi in both variants — received serial numbers; issued serial numbers.

First and foremost, it is important to mention that serial numbers can only be imported via document line items — warehouse document line items; invoice line items.

The general principles for importing document line items (or invoice line items) can be found at the following links — issued invoice line items; received invoice line items. The most important point, however, is that in order to import a document line item, the document header (i.e., the document itself) must already exist. You reference it using the Document column.

Received serial numbers can be imported via received invoice line items or via goods receipt line items. The principles are the same in both cases — the choice depends on your workflow, specifically whether you have a goods receipt (delivery note) available as the first step, or whether you work directly with an invoice that will generate the goods receipt.

The codes for received serial numbers can be freely assigned — they are entirely up to you.

In both cases, the import option can be found in the Tools - Import - Import from Excel module. Here you then choose between Received Invoice Line Items and Goods Receipt/Issue Line Items.

The first step is to prepare the relevant Excel file for import. The example below shows only the most common columns — your file may of course contain more.

The file can follow the template below; column names are labeled exactly as they appear when selecting columns for import in Flexi. Download the sample XLSX file here.

Price List Code — the code/abbreviation of the price list item

Document — the internal document number to which the line items will be imported

Quantity — the number of units of the given price list item

Received Serial Numbers — codes of the received serial numbers, separated by commas

Warehouse — the warehouse code

You can then import the file via the Tools - Import - Import from Excel module mentioned above.

The column selection for the import must be configured as shown in this case.

Once everything is correctly configured, you can confirm the import by clicking the OK button.

The received invoice line items along with the relevant serial numbers will then be imported into the specified received invoice. This will also trigger the stocking-in of the given item (provided that this is configured in the document type).

The first step is to prepare the relevant Excel file for import. The example below shows only the most common columns — your file may of course contain more.

The file can follow the template below; column names are labeled exactly as they appear when selecting columns for import in Flexi. Download the sample XLSX file here.

Price List Code — the code/abbreviation of the price list item

Goods Receipt/Issue — the internal goods receipt number to which the line items will be imported

Quantity — the number of units of the given price list item

Received Serial Numbers — codes of the received serial numbers, separated by commas

Warehouse — the warehouse code

You can then import the file via the Tools - Import - Import from Excel module mentioned above.

The column selection for the import must be configured as shown in this case.

Once everything is correctly configured, you can confirm the import by clicking the OK button.

The goods receipt line items along with the relevant serial numbers will then be imported into the specified goods receipt. This will also trigger the stocking-in of the given item.

Issued serial numbers can be imported via issued invoice line items or via goods issue line items. The principles are the same in both cases — the choice depends on your workflow, specifically whether you create a goods issue as the first step or work directly with an invoice.

The codes for issued serial numbers must reference serial numbers that are currently in stock (i.e., existing serial numbers in the Serial Numbers table).

In both cases, the import option can be found in the Tools - Import - Import from Excel module. Here you then choose between Issued Invoice and Point-of-Sale Line Items and Goods Receipt/Issue Line Items.

The first step is to prepare the relevant Excel file for import. The example below shows only the most common columns — your file may of course contain more.

The file can follow the template below; column names are labeled exactly as they appear when selecting columns for import in Flexi. Download the sample XLSX file here.

Price List Code — the code/abbreviation of the price list item

Document — the internal document number to which the line items will be imported

Quantity — the number of units of the given price list item

Issued Serial Numbers — codes of the issued serial numbers, separated by commas

Warehouse — the warehouse code

You can then import the file via the Tools - Import - Import from Excel module mentioned above.

The column selection for the import must be configured as shown in this case.

Once everything is correctly configured, you can confirm the import by clicking the OK button.

The issued invoice line items along with the relevant serial numbers will then be imported into the specified issued invoice. This will also trigger the stocking-out of the given item (provided that this is configured in the document type).

The first step is to prepare the relevant Excel file for import. The example below shows only the most common columns — your file may of course contain more.

The file can follow the template below; column names are labeled exactly as they appear when selecting columns for import in Flexi. Download the sample XLSX file here.

Price List Code — the code/abbreviation of the price list item

Goods Receipt/Issue — the internal goods issue number to which the line items will be imported

Quantity — the number of units of the given price list item

Issued Serial Numbers — codes of the issued serial numbers, separated by commas

Warehouse — the warehouse code

You can then import the file via the Tools - Import - Import from Excel module mentioned above.

The column selection for the import must be configured as shown in this case.

Once everything is correctly configured, you can confirm the import by clicking the OK button.

The goods issue line items along with the relevant serial numbers will then be imported into the specified goods issue. This will also trigger the stocking-out of the given item.