Purchase to pay: points of attention when using Purchase to pay with KING ERP

Is your KING ERP integration older than January 2020? Contact your KING ERP partner or the Zenvoices support team to verify whether an update is required.

Purchase invoices are booked as purchase invoices in KING ERP.

Processing in KING ERP is manual unless configured otherwise.

No document number is shown in Zenvoices.

Go to Manage > Environment > Administrations > Edit > Tab King.

Enable the setting “Automatically process purchase invoices in King”.

Requirements: Zenvoices King Webservice 1.18 and King 5.67a1 or newer.

In case of errors: delete the invoice manually in KING ERP.

Set the correct journal via Master data purchasing > Journal for purchasing in KING ERP.

This journal is always used for booking purchase invoices, regardless of the journal in which the booking was processed in Zenvoices.

Automatic matching of purchase orders is possible.

Manual selection can be done via “Select warehouse receipts”.

Available in Zenvoices as articles.

The article type is determined through the field article type. Using this field the article type (article, rate or text block) can be determined.

Only possible if automatic processing is enabled.

Otherwise invoices will appear in payable items without affecting KING ERP. If you do not use this setting, purchase invoices will appear in payable items in Zenvoices in the normal way, however this will have no effect in KING ERP.

Disable the option “Automatically remove fully received purchase orders” under Master data purchase orders in KING ER

Supported from KING ERP 5.62a1 and Zenvoices King Webservice 1.7 or higher.

Choose between invoice number, order number or warehouse receipt reference.

Configurable through administration settings in Zenvoices.

Requires Zenvoices King Webservice 1.8 or higher. If no purchase order line is linked to a purchase invoice line, the invoice number will always be used as the reference number. When a warehouse receipt line is linked to a booking line, the warehouse receipt reference number is used and this administration setting is not applied.

Not shown as open during the first synchronization. Because KING ERP does not track the invoiced quantity per purchase order line, Zenvoices assumes that all fully received purchase order lines created before the first synchronization are fully invoiced.

Only supported when both units are equal, meaning the purchase unit equals the inventory unit.

If they differ: the price per purchase unit is calculated and used. If this is not the case, the purchase price per purchase unit is calculated, shown in Zenvoices and used when booking the purchase invoice line in KING ERP.

The field “purchase unit” is supplemented with “(Zenvoices)” for differing units due to limitations in King Webservices 5.63a and earlier. In this case the purchase unit field of a purchase invoice line in KING ERP is filled with the suffix “(Zenvoices)” when the corresponding purchase order line uses a purchase price “per x number of inventory units”.

Disable “Allow creating purchase invoice” via Inventory > Master data purchasing > Receipts.

Avoid negative prices in purchase orders.

They are converted to a positive price with a negative quantity, which affects control. In KING ERP it is not possible to book purchase invoices with negative prices, just like in Zenvoices. These lines are converted to a booking line with a positive price and a negative quantity.

Advice: use rates only for purchasing or only for sales. Our recommendation is to use a rate only for purchasing or only for sales to prevent incorrect use of VAT codes.

A column is available showing how many times an item has been invoiced.

Only the Zenvoices archive is consulted.

Delete the booking in KING ERP and export it again from Zenvoices.