In this chapter, we will look at a specific example of importing received invoice line items 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 -> Received Invoice Line Items.
Recommendation: If you already have received invoice line items created in Flexi, you can export them (registry: Purchases -> Document Line Items -> Received Invoice Line Items) and use them as a template for importing new ones.
We can now proceed to importing specific received invoice line items from Excel.
We will be importing the following file: fakPrijPolozky_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 the columns selected for import must exactly match the order of the columns in the Excel file.
Document - The internal number of the received invoice into which you want to import the line items. Required field.
Price list code - If the invoice line item is a price list item, enter its code from the price list here.
Label - The label of 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; must be specified.
Total [CZK] -
Base [CZK] - The tax base in CZK for the given line item (Unit Price * Quantity). Does not need to be entered — 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. Does not need to be entered — it is calculated automatically based on the Unit Price, Quantity, and VAT [%] fields.
Line item type - The type of the given line item. A special value must be specified.
Possible values are:
typPolozky.obecny
typPolozky.katalog
typPolozky.ucetni
typPolozky.text
VAT rate type - The rate type. A special value must be specified.
Possible values are:
typSzbDph.dphOsv
typSzbDph.dphSniz
typSzbDph.dphSniz2
typSzbDph.dphZakl
Copy debit account for base - Should the debit account for the base be copied from the document header? Boolean value (Yes = 1; No = 0).
Copy credit account for base - Should the credit account for the 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 job/order - Should the job/order be copied from the document header?
Boolean value (Yes = 1; No = 0).
Copy cost center - Should the cost center 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).
VAT control statement line - The VAT control statement line (if copied from the header, this field does not need to be filled in). If filling in, enter its code from the code list.
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 received invoice line items registry can be found at:
https://demo.flexibee.eu/c/demo/faktura-prijata-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 respective registries.
If the import does not complete successfully and the Excel file needs to be corrected, a window should appear listing the specific errors, along with an 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 received invoice (they can also be found in the registry Purchases -> Document Line Items -> Received Invoice Line Items).