Finvoice import

• General
• Finvoice import details
• Phases of Finvoice import
• Finvoice examples
  • Finvoice minimum
  • Finvoice maximum

General

It is possible to import sales invoices into Netvisor in Finvoice XML format using Data import tool. Data import is available for all companies and the user importing invoices has to have editing authorization for "Perustietojen hallinta" and "Perustietojen tuonti" in Accouting function specific rights. Data import can be found in Netvisor UI: Company menu > Data import and export > Data import.

To be able to import sales invoices you need invoice material in Finvoice standard. The oldest supported version of Finvoice is 1.2 but newer versions can also be used.

The Web Service Interface has to be activated in order to import sales invoices. You can activate Web Service Interface in Company menu > Rights of interface resources by typing "Netvisor laskutietojen tuonti (Finvoice)" in the search bar. Select the right integration and enable all resources.

The person importing sales invoices must create API identifiers in Company menu > API and identifiers > click "Create new API identifier".

Importing sales invoices in Finvoice format is included in all service packages.

Finvoice import requires the following resources in order for it to work correctly:

Finvoice import details

The table below shows fields taken from the Finvoice material and what field is uses in Netvisor. Secondary information is used if primary information is not given in the Finvoice material.

To be able to import scandinavian letters (å, ä, ö) the material needs to be encoded in ISO/IEC 8859-15 form. 

It is also possible to import dimension headers and dimension items in fields RowDefinitionHeaderText and RowDefinitionValue. 

If customer doesn't exist in Netvisor before import, the e-invoice details and e-mail invoicing address are imported to Netvisor if this information is found in the finvoice file. And if customer is already in Netvisor (i.e. the customer code used in the finvoice is found in Netvisor), the e-invoice details/e-mail invoicing address are not updated from the finvoice file. E-invoice details/email invoicing address should be manually saved to customer details in Netvisor or imported using csv Customer Data import. If you want invoices to be allocated to a customer card in Netvisor in the future, the customer code (InvoiceRecipientPartyIdentifier or BuyerPartyIdentifier) must be same in the finvoice file and in the Netvisor customer card.

One Finvoice file can include multiple invoices. This way there is no need to import invoices one at a time.

Phases of Finvoice import

1. Open Company menu and choose "Data import"
2. Choose "Lasku/suoritus XML" (see picture below, step 1) and press "Selaa" (2)
3. Find the right Finvoice file and press ""Submit data" -button (3). This starts the Finvoice import.

If there are no errors in the import, Netvisor will show a specification of imported data and links to formed material.

Finvoice import establishes customers and products used in the import if customers or products do not exist in Netvisor before import. Please note that customer's e-invoice details or e-mail invoicing addresses are not imported. If customers and products used in the import exist in Netvisor, the imported customers and products are targeted to existing ones.

If the imported material contains errors an error message is shown. The message tells why the material cannot be imported into Netvisor. If the material includes more than one invoice the invoices in right form are imported. There is an editor window below the error message but the material cannot be edited in that window. All changes to the invoice material must be done in the original file. After correcting the material the invoices can be imported again. Please do not edit the imported invoices in Netvisor after the import. 

Finvoice examples

The examples below show the minimum information that the Finvoice material must have in order to import a sales invoice, as well as the maximum information that can be read from the material. In addition to these, the Finvoice material may have other information according to the Finvoice standard, but it is not read into Netvisor.

Finvoice minimum

<?xml version="1.0" encoding="ISO-8859-15"?>
<?xml-stylesheet type="text/xsl" href="Finvoice.xsl"?>
<Finvoice>
  <SellerPartyDetails>
    <SellerOrganisationTaxCode>FI12345678</SellerOrganisationTaxCode>
  </SellerPartyDetails>
  <BuyerPartyDetails>
    <BuyerOrganisationName>Esimerkkiasiakas</BuyerOrganisationName>
  </BuyerPartyDetails>
  <InvoiceDetails>
    <InvoiceNumber>100</InvoiceNumber>
    <InvoiceDate Format="CCYYMMDD">20230124</InvoiceDate>
    <InvoiceDueDate Format="CCYYMMDD">20230207</InvoiceDueDate>
  </InvoiceDetails>
  <InvoiceRow>
    <ArticleName>Esimerkkituote</ArticleName>
    <DeliveredQuantity QuantityUnitCode="pcs">10,00</DeliveredQuantity>
    <RowAmount AmountCurrencyIdentifier="EUR">100,00</RowAmount>
  </InvoiceRow>
</Finvoice>

<?xml version="1.0" encoding="ISO-8859-15"?>
<?xml-stylesheet type="text/xsl" href="Finvoice.xsl"?>
<Finvoice>
    <MessageTransmissionDetails>
        <MessageReceiverDetails>
            <ToIdentifier>FI109700021497</ToIdentifier>
            <ToIntermediator>NDEAFIHH</ToIntermediator>
        </MessageReceiverDetails>
    </MessageTransmissionDetails>
    <SellerPartyDetails>
        <SellerPartyIdentifier>1234567-8</SellerPartyIdentifier>
        <SellerOrganisationTaxCode>FI12345678</SellerOrganisationTaxCode>
    </SellerPartyDetails>
    <InvoiceRecipientPartyDetails>
        <InvoiceRecipientPartyIdentifier>1967543-8</InvoiceRecipientPartyIdentifier>
        <InvoiceRecipientOrganisationName>Esimerkkiasiakas5</InvoiceRecipientOrganisationName>
    <InvoiceRecipientOrganisationName>c/o uusi tilitoimisto</InvoiceRecipientOrganisationName>
        <InvoiceRecipientOrganisationTaxCode>FI19675438</InvoiceRecipientOrganisationTaxCode>
        <InvoiceRecipientPostalAddressDetails>
            <InvoiceRecipientStreetName>Soratie 2</InvoiceRecipientStreetName>
            <InvoiceRecipientTownName>OULU</InvoiceRecipientTownName>
            <InvoiceRecipientPostCodeIdentifier>00000</InvoiceRecipientPostCodeIdentifier>
            <CountryCode>FI</CountryCode>
        </InvoiceRecipientPostalAddressDetails>
    </InvoiceRecipientPartyDetails>
    <BuyerCommunicationDetails>
        <BuyerPhoneNumberIdentifier>000000</BuyerPhoneNumberIdentifier>
        <BuyerEmailaddressIdentifier>[email protected]</BuyerEmailaddressIdentifier>
    </BuyerCommunicationDetails>
    <DeliveryPartyDetails>
        <DeliveryOrganisationName>Esimerkkitoimitus5</DeliveryOrganisationName>
        <DeliveryPostalAddressDetails>
            <DeliveryStreetName>Katu</DeliveryStreetName>
            <DeliveryTownName>Kaupunki</DeliveryTownName>
            <DeliveryPostCodeIdentifier>00000</DeliveryPostCodeIdentifier>
            <CountryCode>FI</CountryCode>
        </DeliveryPostalAddressDetails>
    </DeliveryPartyDetails>
    <DeliveryDetails>
        <DeliveryDate Format="CCYYMMDD">20230223</DeliveryDate>
        <DeliveryMethodText>Toimitustapa</DeliveryMethodText>
        <DeliveryTermsText>Toimitusehto</DeliveryTermsText>
    </DeliveryDetails>
    <InvoiceDetails>
        <InvoiceNumber>202</InvoiceNumber>
        <InvoiceDate Format="CCYYMMDD">20230223</InvoiceDate>
        <SellerReferenceIdentifier>Viitteemme</SellerReferenceIdentifier>
        <OrderIdentifier>Tilausnro</OrderIdentifier>
        <BuyerReferenceIdentifier>Viitteenne</BuyerReferenceIdentifier>
        <InvoiceTotalVatIncludedAmount AmountCurrencyIdentifier="USD">0</InvoiceTotalVatIncludedAmount>
        
        <InvoiceFreeText>Vapaa teksti</InvoiceFreeText>
        <PaymentTermsDetails>
            <InvoiceDueDate Format="CCYYMMDD">20230309</InvoiceDueDate>
      <CashDiscountDate>20230301</CashDiscountDate>
      <CashDiscountPercent>10</CashDiscountPercent>
        </PaymentTermsDetails>
    </InvoiceDetails>
    <InvoiceRow>
    <RowFreeText>Kommenttirivi</RowFreeText>
    </InvoiceRow>
    <InvoiceRow>
        <ArticleIdentifier>1x1</ArticleIdentifier>
        <ArticleName>Esimerkkituote5</ArticleName>
        <DeliveredQuantity 
QuantityUnitCode="kpl">10,00</DeliveredQuantity>
        <RowIdentifier>Tilausnro</RowIdentifier>
        <RowFreeText>Riviselite</RowFreeText>
        <RowDiscountPercent>10,00</RowDiscountPercent>
        <RowVatRatePercent>24,00</RowVatRatePercent>
        <RowAmount>90,00</RowAmount>
		<RowNormalProposedAccountIdentifier>3000</RowNormalProposedAccountIdentifier>
		<RowDefinitionDetails>
			<RowDefinitionHeaderText>Projekti</RowDefinitionHeaderText>
			<RowDefinitionValue>Projekti 15</RowDefinitionValue>
		</RowDefinitionDetails>
    </InvoiceRow>
    <EpiDetails>
        <EpiIdentificationDetails>
            <EpiReference>123</EpiReference>
        </EpiIdentificationDetails>
        <EpiPaymentInstructionDetails>
            <EpiRemittanceInfoIdentifier>123</EpiRemittanceInfoIdentifier>
        </EpiPaymentInstructionDetails>
    </EpiDetails>
</Finvoice>

Did you find it helpful? Yes No