This article describes how to create and upload an Excel import file for Purchase Orders into the ABRA Flexi web environment.
The import can be used to create new documents or bulk-edit existing ones. Compared to the desktop application, the web version offers a simpler workflow – a single import can process both document headers and their line items.
Before starting the import, we recommend reading the general article first:
Excel Imports in the Web Interface
Purchase Orders – Basic Import
After selecting "Import from Excel", you need to consider which type of file you are uploading:
Basic import – orders only, without line items
Extended import – orders including their line items
After uploading the file, Flexi displays an overview where the left column shows the column names from Excel and the right column shows the corresponding fields in Flexi. It is important to:
verify that the columns are mapped correctly,
and add any missing mappings via "Advanced Options" if needed.
Standard and Recommended Columns for Purchase Orders
Below are the columns that are visible by default or commonly used when importing purchase orders:
Column | Description |
Document Type | Text field containing the code of the purchase order type |
Internal Number | Internal identification number of the order |
Issue Date | Date of issue in |
Order Date | Date the order was placed in |
Deadline | Required delivery date in |
Cost Centre | Abbreviation of the selected cost centre |
Company Name | Name or abbreviation of the company / person |
Price List Code | Code or abbreviation of the stock item (price list entry) |
Name | Name of the imported line item |
Warehouse | Abbreviation of the warehouse from which the item will be dispatched |
Unit of Measure | Unit of measure for the item (not required if defined in the price list) |
Unit Price | Unit price of the item (not required) |
Total Amount | Total value of the order |
VAT Rate Type | Code of the VAT rate used  |
Item Type | Specifies whether the item is a standard product, a service, etc.  |
Additional columns can be added in the web interface via the settings (bottom-right corner).
To verify the correct format, we recommend using the Export to Excel in import-ready format option.
Tip: All properties of the purchase orders record can be found at:
Practical Example – Importing Purchase Orders Including Line Items
Let's walk through the specific steps:
Open the Purchase Orders agenda and select "Import from Excel".
Select your Excel file (e.g.
objednavka-prijata-polozka.xlsx)
Flexi will automatically recognise the columns and determine what is an order and what is a line item – we recommend reviewing everything carefully.
A test import will run to validate the data.
If the data looks correct, click "Import".
Flexi will notify you of new records, changes, or any errors.
Confirm the import a second time and the data will be transferred into the system.
After a successful import, the purchase orders will be created along with their line items.
Tip for item-free documents: If you are importing an order without line items, simply add a column called "Item-free doc." with the value TRUE to your file. Flexi will then recognise that the order contains no line items.