Read digital invoices

Incoming documents that are available in electronic form (ZUGFeRD EN16931 format) can be read into a data record of the Receipt entry.

 

Configuration

The following settings must be made for document import:

 

In the program settings / Selection lists

An e-invoice contains various data in the form of standardized codes, e.g. codes for article units.

This data is maintained in the ingenious software as individual selection lists.

To ensure that user-readable values ​​are displayed in the XML preview of the e-invoice, an export mapping column has been added to the tables.

 

Product catalog / Price per unit EK:

A mapping has been added that maps the existing units to selected codes in accordance with the UN-ECE recommendations (No. 20).

The units stored in the selection list must each be assigned to a valid code.

These are:

 

Code Name DE Name EN
H87 Stück piece
XPP Stück piece
NAR Anzahl an Artikeln number of articles
EA je each
C62 Eins one
PR Paar pair
SET Set set
T3 Tausend Stück thousand piece
KMT Kilometer kilometre
KMK Quadratkilometer square kilometre
H20 Kubikkilometer cubic kilometre
MTR Meter metre
MTK Quatratmeter square metre
MTQ Kubikmeter cubic metre
CMT Zentimeter centimetre
CMK Quadratzentimeter square centimetre
CMQ Kubikzentimeter cubic centimetre
MMT Millimeter millimetre
MMK Quadratmillimeter square millimetre
MMQ Kubikmillimeter cubic millimetre
FOT Fuß foot
FTK Quadratfuß square foot
FTQ Kubikfuß cubic foot
INH Zoll inch
INK Quadratzoll square inch
INQ Kubikzoll cubic inch
KGM Kilogramm kilogram
GRM Gramm gram
MGM Milligramm milligram
LTR Liter litre
MLT Milliliter mililitre
ANN Jahr year
MON Monat month
WEE Woche week
DAY Tag day
HUR Stunde hour
MIN Minute minute [unit of time]
SEC Sekunde second [unit of time]
E48 Serviceeinheit service unit
E49 Arbeitstag working day

 

Mapping of article units
Mapping of article units

 

Contacts / Payment method:

A mapping has been added that maps the existing payment methods to selected codes from the code list 4461 (Payment means code) of the United Trade Data Interchange Directory (UNTDID).

A valid code must be assigned to each of the payment methods stored in the selection list.

These are:

Code Name DE Name EN
10 Bar In cash
20 Scheck Cheque
30 Überweisung (Nicht SEPA) Credit transfer (non-SEPA)
31 Lastschrift (Nicht SEPA) Debit transfer (non-SEPA)
42 Auszahlung auf Bankkonto Payment to bank account
48 Bankkarte Bank card (Use for all payment cards)
49 Lastschrift Direct debit
50 Zahlung per Postgiro Payment by postgiro
54 Kreditkarte Credit card
55 Debitkarte Debit card
58 SEPA-Überweisung SEPA credit transfer
59 SEPA-Lastschrift SEPA direct debit

 

Mapping of payment types
Mapping of payment types

 

Maintaining contact records

Documents are automatically assigned to a supplier using the customer number.

For correct assignment, the customer number must be maintained for each supplier.

If no suitable supplier is found when reading in the receipt, this can be searched for manually using the supplier field in the sidebar.

The saved address data and payment conditions are loaded from the linked supplier.

These must be compared with the data in the XML preview and adjusted if necessary.

 

Import digital invoices

You can import a digital receipt using the  “Add file attachment” button or drag and drop the document into the file attachments area.

The fields in the sidebar are automatically filled with the readable values ​​of the e-invoice.

ZUGFeRD invoices are opened in PDF view, X-invoices start with the XML preview.

The XML preview shows the entire content of the e-invoice in a form that the user can read to make invoice checking easier.

The invoice checking for ZUGFeRD invoices should also be carried out using the XML preview, as only these values ​​are relevant.

In addition, you can use the  “Change view” button to switch to the view of the original content of the XML.

 

The individual views:

XML preview If available, the data in the XML file is displayed in tabular form. The most important data is presented in a more understandable form. All other data is listed in the “Unbound fields” section. The node name is displayed in column 1 and the content of the node in column 2.
PDF If available, the PDF file of the original documents is displayed in the preview. Note: A PDF is “read in” by the plug-in used and not simply displayed. This can lead to different formatting, e.g. with special fonts.
XML If available, the raw data of the XML file is displayed in text form.

 

Marking the original invoice

Since additional documents can be stored in the file attachments, the e-invoice must be marked as “original” using the corresponding checkbox.

The first XML (or PDF with integrated XML) inserted into the file attachments is automatically marked as “original”.

Only the documents marked as original are displayed in the preview.

Additional documents can be opened by double-clicking in the computer’s default app assigned for the file format.

 

Notes:

The current ingenious version takes the ZUGFeRD EN16931 format into account.

At this level of detail, payment terms are mainly transferred as text.

In particular, discount periods cannot be read reliably.

In the case of discount agreements, the corresponding fields may need to be adjusted manually.

 

The import of digital invoices will gradually be supplemented with the extended format and the XRechnung format.

 

 

Start typing and press Enter to search