The information in this article applies to administrations with the additional module Purchase to pay.
When a purchase invoice is read in, Zenvoices will automatically try to match the invoice with open purchase orders from your accounting package. In this article you will read how this matching process works.
Scan & recognize
The scan & recognize function of Zenvoices (only applicable for non e-invoices) automatically recognizes invoice lines including quantities, article numbers, amounts, descriptions, prices, references and your order numbers that appear in the document. Based on this information, Zenvoices matches the invoice with open purchase order lines and open receipts of the supplier. These recognized invoice lines are included in the booking proposal. Consult the recognized data to see which data is used for the matching.
If you are not using the Complete subscription (line recognition is not available in older subscription types), the above does not apply. In that case, matching can only be done with a single purchase order. The purchase order number or the customer reference of the purchase order shown on the invoice and the total invoice amount must match the outstanding amount of the purchase order.
E-invoices (UBL)
E-invoices are first matched in the same way as invoices processed through scan & recognize. If this does not result in a match, the system performs line-level matching with purchase order lines. This matching method requires that purchase order numbers, purchase order customer references and purchase order line numbers or article numbers are specified at line level in the e-invoice. This matching method is suitable for consolidated invoices. The following UBL fields are used:
OrderReference
InvoiceLine.OrderReference
InvoiceLine.Item.SellersItemIdentification.ID
InvoiceLine.Item.BuyersItemIdentification.ID
Would you like to know whether the e-invoices from your supplier are suitable for line-level matching? Our support team will be happy to review the possibilities for you.
Custom recognition fields per relation
In addition to the standard match fields, you can now apply custom recognition fields per relation. This lets you align the matching process with the working method and document structure of a specific supplier. This gives you more flexibility when matching orders, with support for supplier-specific references and characteristics, and a higher match rate for documents that deviate from the standard fields.
This is useful, for example, when a supplier adds extra punctuation to the order number on the invoice, while your accounting or ERP package only has the original order number on record. Previously, this would cause the automatic match to fail. With custom recognition fields, orders are now matched more accurately to incoming invoices, resulting in a higher automatic match rate.
Manual matching
Purchase order selection
If no automatic match is found, matching can be done manually in the booking screen using the button “Select purchase orders”. A period can be entered here, which by default is set to “Past 3 months”. The preference is stored in the browser per user/administration. Recognized purchase order numbers and references are shown as suggestions to quickly select the correct purchase order lines.
KING ERP
Goods receipts selection
Please note: updating the Zenvoices King Web service is required (version 1.18, requires KING ERP 5.67a1 or higher).
Is a purchase invoice not automatically matched with a goods receipt, for example because more quantities are invoiced than received? Then you can manually add transaction lines based on goods receipts (receipt number) in the transaction screen via ‘Select goods receipts’. This makes it easy to add multiple transaction lines based on the receipt number from KING ERP. The period preference is also saved here. Cost prices are taken from KING ERP, without linked order lines.
Invoiced column
In the goods receipts selection a column is available that shows how many times a purchase order has been invoiced. The values in “Quantity invoiced” are only based on goods receipts matched in Zenvoices. Lines invoiced through “Select purchase orders” are not included.
Please note: only the archive in Zenvoices is consulted.
Keywords: purchase orders, purchase orders, matching
