In this chapter, we will look at a specific example of importing line items of issued invoices and sales receipts from Excel. For general principles of Excel imports, we recommend reading the first chapter - Introduction. Excel imports are available from the Business plan and above.
Provided your license includes the import of issued invoices — which also covers the import of their line items — the import will be available at Tools -> Import -> Import from Excel -> Line items of issued invoices and sales receipts.
Recommendation: If you already have issued invoice line items created in Flexi, you can export them (via Sales -> Document Items -> Line items of issued invoices and sales receipts) and use them as a template for subsequent imports.
We can now proceed to importing specific line items of issued invoices or sales receipts from Excel. We will be importing the following file: fakVydPolozky_vzor.xlsx
Note 1: Line items can only be imported if the document they are to be imported into already exists.
Since the Excel file contains column headers, check the "Ignore first row (column headers)" option when selecting columns.
Note 2: The order of columns selected for import must exactly match the order of columns in the Excel file.
Document - The internal number of the issued invoice into which you want to import the line items. Required field.
Order - The position of the line item within the invoice; not required. Enter as a number.
Price list code - If the invoice line item is a price list item, enter its code from the price list here.
Label - The label for the given line item; a text field.
Name - The name of the given line item; a text field.
Quantity - The quantity of the given line item.
Unit price - The unit price of the given line item; required.
Tax base [CZK] - The tax base in CZK for the given line item (Unit price × Quantity). Not required — it is calculated automatically based on the Unit price, Quantity, and VAT [%] fields.
VAT [%] - The VAT rate as a percentage. Enter as a number (e.g. 21).
VAT [CZK] - The VAT amount in CZK for the given line item. Not required — it is calculated automatically based on the Unit price, Quantity, and VAT [%] fields.
Price type - The price type for the given line item. A specific value must be entered.
Possible values are:
typCeny.bezDph
typCeny.sDph
typCeny.sDphKoef
Line item type - The type of the given line item. A specific value must be entered.
Possible values are:
typPolozky.obecny
typPolozky.katalog
typPolozky.ucetni
typPolozky.text
VAT rate type - The rate type. A specific value must be entered.
Possible values are:
typSzbDph.dphOsv
typSzbDph.dphSniz
typSzbDph.dphSniz2
typSzbDph.dphZakl
Copy debit account for tax base - Should the debit account for the tax base be copied from the document header? Boolean value (Yes = 1; No = 0).
Copy credit account for tax base - Should the credit account for the tax base be copied from the document header?
Boolean value (Yes = 1; No = 0).
Copy debit account for VAT - Should the debit VAT account be copied from the document header?
Boolean value (Yes = 1; No = 0).
Copy credit account for VAT - Should the credit VAT account be copied from the document header?
Boolean value (Yes = 1; No = 0).
Copy posting template - Should the posting template be copied from the document header?
Boolean value (Yes = 1; No = 0).
Copy project - Should the project be copied from the document header?
Boolean value (Yes = 1; No = 0).
Copy cost centre - Should the cost centre be copied from the document header?
Boolean value (Yes = 1; No = 0).
Copy VAT line - Should the VAT line be copied from the document header?
Boolean value (Yes = 1; No = 0).
Posting date - The posting date of the line item (DD - MM - YYYY). Not required — it is filled in automatically based on the posting configuration.
Credit account for tax base - The credit account for the tax base; fill in only when copying from the document header = false. References the chart of accounts (enter the account code).
Copy VAT control statement line - Should the VAT control statement line be copied from the document header?
Boolean value (Yes = 1; No = 0).
All properties of the issued invoice line items register can be found at:
https://demo.flexibee.eu/c/demo/faktura-vydana-polozka/properties
After clicking the "OK" button in the column selection dialog, a window will appear showing the data types and properties of the selected columns. Among other things, the required special values for each column can be looked up here.
After confirming the properties of the imported columns, a window will appear showing a summary of how many newly created or updated records will be added to the relevant registers.
If the import does not complete successfully and the Excel file needs to be corrected, a window with specific error details should appear, along with the option to send an error report to Flexi support.
If the import completes successfully, the new or updated line items will appear on the relevant issued invoice (they can also be found in the Sales -> Document Items -> Line items of issued invoices and sales receipts register).