--- title: "Action: Invoices and invoice lines" description: "Invoices (header). Imports invoices into Sapera, creating or updating the invoice header with customer and address details for each row." url: https://support.sapera.io/en/articles/612-action-invoices-and-invoice-lines collection: "SyncTool" updated: 2026-09-25 language: en alternates: [da] --- # Action: Invoices and invoice lines Invoices (header). Imports invoices into Sapera, creating or updating the invoice header with customer and address details for each row. **Invoices (header).** Imports invoices into Sapera, creating or updating the invoice header with customer and address details for each row. **Invoice lines.** Imports invoice lines into Sapera, attaching each line to its invoice with product, quantity, price and VAT details. ## How to use the action 1\. Select the action in the **Action** field. 2. Point to your data source – a **file** (CSV or Excel) or a **SQL query**. 3. Map the source columns to Sapera's fields in the column mapping (see _Source fields_ below). 4. Run **Compare** to see what will be created, changed or stay unchanged – without writing to Sapera. 5. Run **Update Sapera** to perform the import. Use the **Allow create** and **Allow update** parameters to control whether new rows are created and whether existing ones are updated. ## How matching and updating works Import the **invoice header** first (the _Invoices_ action) and then the **invoice lines** (the _Invoice lines_ action) – the lines require the invoice to already exist. - The invoice header is matched on the invoice's **identifier** (Identifier); matching invoices are updated and new ones created with customer and address details. - Each invoice line is matched on **invoice identifier + line number** and linked to its invoice with product, quantity, price and VAT. If the invoice does not exist, the line fails. - Direction: from file/SQL into Sapera. ## Key parameters ### Invoices (header)

Parameter	Explanation
ForceIdentifierInHigherRangeThan	Forces newly created invoice numbers to start above the given value to avoid clashing with existing numbers.

### Invoice lines

Parameter	Explanation
ForceSalesOrderIdentifierInHigherRangeThan	Forces newly created identifiers to start above the given value to avoid clashing with existing numbers.

## Source fields ### Invoices (header)

Field	Explanation
AddressLine1	First line of the invoice address.
AddressLine2	Second line of the invoice address.
Country	Country of the invoice address.
CurrencyCode	Currency code of the invoice, for example DKK or EUR.
CurrencyRate	Exchange rate applied to the invoice currency.
CustomerEmail	Email address of the customer.
CustomerFullName	Full name of the customer on the invoice.
CustomerIdentifier	Identifier of the customer the invoice belongs to.
CustomerOrganizationIdentifier	Organization or CVR number of the customer.
CustomerPhone	Phone number of the customer.
CustomerReferenceNumber	Customer reference shown on the invoice.
Identifier	Unique identifier (invoice number) of the invoice.
InternalNote	Internal note not shown to the customer.
InvoiceDate	Date of the invoice.
IsExemptVat	Whether the invoice is exempt from VAT.
OtherPayerIdentifier	Identifier of an alternative payer when someone other than the customer pays.
PaymentTerm	Payment term applied to the invoice.
PostalCode	Postal code of the invoice address.
PostalDistrict	Postal district or city of the invoice address.
PublicNote	Public note shown on the invoice.
RelatedProductInstanceIdentifier	Identifier of a related serial-number item linked to the invoice.
RequisitionNumber	Requisition number associated with the invoice.
Subject	Subject or heading of the invoice.

### Invoice lines

Field	Explanation
ContraAccountAccountNumber	Contra account number used when posting the line.
CostPrice	Unit cost price of the line.
DiscountAccountNumber	Financial account number used for the line discount.
DisplayName	Text shown for the line on the invoice.
InstanceIdentifier	Identifier of the specific serial-number item on the line.
InvoiceIdentifier	Identifier of the invoice this line belongs to.
IsExemptVat	Whether the line is exempt from VAT.
ItemOrder	Sequence number that orders the line within its invoice.
LocationDisplayName	Display name of the location associated with the line.
ManualDiscountAmount	Manual discount amount applied to the line.
Price	Unit sales price of the line.
ProductDisplayName	Display name of the product on the line.
ProductIdentifier	Identifier of the product on the line.
ProductKind	Kind of product on the line.
Quantity	Quantity invoiced on the line.
SaleFinancialAccountNumber	Sales financial account number the line revenue is posted to.
UsedVatFinancialAccountNumber	Financial account number actually used for the line VAT when posting.
UsedVatRate	Actual VAT rate used when posting the line.
VatAccountNumber	Financial account number used for the line VAT.
VatRate	VAT rate applied to the line.

* * * See also the overview [SyncTool – actions](https://support.sapera.io/en/articles/547-synctool-handlinger.md). * * * **Want to know more?** Read more in these related articles: [ Standard parameters for all actions The general parameters available on most SyncTool actions: step control, error handling, timeout, etc. ](https://support.sapera.io/en/articles/648.md)