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 |
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 |
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. |
| 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.