Skip to main content

Importing Invoice Line Item Amounts

**What line item amounts to import in which case?**

Written by Petr Pech

Invoice item amounts can be entered in several ways — depending on which values you have available from your source system. ABRA Flexi will calculate the rest for you.


Which combinations work

What you send

What to specify on the item

Unit price and base amount

mnozMj, cenaMj, sumZkl — the simplest option, Flexi calculates both the VAT and the total amount.

Base amount and total

in addition sumCelkem, typCenyDphK = typCeny.bezDph and rate typSzbDphK

VAT and total

mnozMj, cenaMj, sumDph, sumCelkem, typCenyDphK = typCeny.sDph and rate typSzbDphK

🚨 The values of the typCenyDphK field are typCeny.bezDph and typCeny.sDph — i.e. with the typCeny prefix, not typCenyDph or typCenyDphK. Any other value will cause the import to fail.


Examples

Price excluding VAT and base amount:

<polozkyDokladu>
<faktura-vydana-polozka>
<nazev>Zboží</nazev>
<mnozMj>2</mnozMj>
<cenaMj>100</cenaMj>
<sumZkl>200</sumZkl>
<typCenyDphK>typCeny.bezDph</typCenyDphK>
<typSzbDphK>typSzbDph.dphZakl</typSzbDphK>
</faktura-vydana-polozka>
</polozkyDokladu>

Price including VAT and total amount:

<polozkyDokladu>
<faktura-vydana-polozka>
<nazev>Zboží</nazev>
<mnozMj>2</mnozMj>
<cenaMj>121</cenaMj>
<sumDph>42</sumDph>
<sumCelkem>242</sumCelkem>
<typCenyDphK>typCeny.sDph</typCenyDphK>
<typSzbDphK>typSzbDph.dphZakl</typSzbDphK>
</faktura-vydana-polozka>
</polozkyDokladu>

⚠️ Do not specify amounts in the document header if the document has items — Flexi calculates them from the items, and the entered value would not match. The resulting error is described in the article Error: The specified property value differs from the calculated one.

ℹ️ For a document in a foreign currency, amounts belong in the fields with the Men suffix (sumZklMen, cenaMj is always in the document's currency), and the document must have kurz filled in.


Related

Did this answer your question?