Tables and processings involved in order matching

The following tables and processings are used for order matching.

Order table

Field name SQL name Description
Proposed order total gross IIGOrdSm Order total gross amount based on the supplier invoice document.
Proposed order total net IINOrdSum Order total net amount based on the supplier invoice document.
Proposed VAT amount IIVatAm VAT amount based on the supplier invoice document.
Accounting document no. IncAcDocNo The accounting document no refers to the Accounting document table.
Order status 2 OrdPrSt2 See order match status in Processing - Order status, tab Miscellaneous. This is updated according to the order match statuses on the order line.

Order line table

Field name SQL name Description
Proposed amount IIAm Amount based on the supplier invoice document.
Proposed disc. % IIDcP Discount % based on the supplier invoice document.
Proposed disc. amount IIDcAm Discount amount based on the supplier invoice document.
Proposed price IIPrice Price based on the supplier invoice document.
Proposed quantity IINoInvoAb Quantity based on the supplier invoice document.
Proposed VAT amount IIVatAm VAT amount based on the supplier invoice document.
Order line status OrdLnSt Displays the different statuses for the order match process on the order lines.
Processing Description
Update invoice values Update the existing purchase order with the values from the supplier invoice document.
Update values and receive invoice Updates the existing purchase order with the values from the supplier invoice document and performs the invoice receival process.
Reject invoice Removes all fields on an order line which have been set during the order match process.

Company information table

Field name SQL name Description
Additional fees and rounding product OnAcProd Checked by the order match processing when creating order lines for the fee charges or rounding amount that exist in the incoming XML invoice. The Product no. specified in this field has to correspond to the product that has been designated as fee/rounding amount in the Product table
Incoming invoice deviation tolerance % IIDvTIP The allowed deviation tolerance in % (based on the invoice amount) between the supplier invoice amount and the purchase order amount in Business NXT. Only values between 0 and 100 are permitted in this field. Automatic invoice receipt can be performed if the deviation between both values is within the given tolerance %.
Incoming invoice deviation tolerance amount IIDvTIAm The allowed deviation tolerance amount between the supplier invoice amount and the purchase order amount in Business NXT. Automatic invoice receipt can be performed if the deviation between both values is within the tolerance amount.
Incoming document pre-registration series OrdMaPRVoSr The series number for the pre-registration voucher.
Product no. freight 4 Fr4Prod Checked by the order match processing when creating order lines for the freight charges that exist in the incoming XML invoice. The Product no. specified in this field has to correspond to the product that has been designated as freight in the Product table.
Order processing 2 option Description
Do not tolerate any deviation All deviations will be flagged as outside deviation tolerance and in these cases it will not be possible to do invoice receival.
Pre-registration incoming documents If enabled, an updated batch with one voucher is automatically created when an invoice is transferred from AutoInvoice and subsequently order matched. The voucher series is fetched from the Incoming document pre-registration series field. This voucher series must have a voucher type. And the debit account from the voucher type will be used as a debit account on the voucher (or credit account if the invoice transferred is a credit invoice). Sup. no. from the Updated voucher table will be used as cross account.
Order match automatic invoice receive Enables automatic invoice receipt of order lines that have been order matched and are inside the deviation tolerance.
Note:
You can’t enable this setting in combination with Pre-registration incoming documents.
Order processing 3 option Description
No partial invoice receival for order match Performs the automatic invoice receipt only when all the order lines of an order matched invoice are inside tolerance level. This flag is checked by the order match processing only if the Order match automatic invoice receive option is also enabled.
Note:
It's usually recommended to enable this setting to avoid creating multiple vouchers for the same invoice.
Reverse the pre-registration for order match when rejecting invoice When an order matched invoice is rejected, an updated batch that reverses the previously created pre-registration batch is created.

Associate table

Field name SQL name Description
Incoming invoice deviation tolerance % IIDvTIP Makes it possible to specify the allowed deviation tolerance in % (based on the invoice amount) for each supplier, between the supplier invoice amount and the original purchase order amount in Business NXT. Only values between 0 and 100 are permitted. If Do not tolerate any deviation is enabled, the order match processing will disregard the value in this field and then unless no deviation in amount exists the order line will be flagged as outside deviation tolerance.
Incoming invoice deviation tolerance amount IIDvTIAm Makes it possible to specify the allowed deviation tolerance amount for each supplier, between the supplier invoice amount and the original purchase order amount in Business NXT. If Do not tolerate any deviation is enabled, the order match processing will disregard the value in this field and then unless no deviation in amount exists the order line will be flagged as outside deviation tolerance.
Supplier option Description
No automatic invoice receive if freight Automatic invoice receipt of an order matched invoice is not performed in case the incoming invoice contains at least one freight charge. This setting is checked by the order match processing only if Order match automatic invoice receive is enabled.
No automatic invoice receive if additional fees Automatic invoice receipt of an order matched invoice is not performed in case the incoming invoice contains at least one fee charge or rounding amount. This setting is checked by the order match processing only if Order match automatic invoice receive is enabled.

Document table

Field name SQL name Description
Order no. OrdNo The supplier purchase order number according to the received supplier invoice document.
Order match status OrdMaSt

Displays the different statuses for the order match process. The following statuses are currently supported:

1 - Completed by automatic match

2 - In progress

3 - Order no. not found

4 - Outside tolerance level

5 - Completed manually

6 - Rejected

7 - Mandatory value missing

8 - Pending

9 - Incomplete product mapping

10 - Currency mismatch

11 - Freight/fee product not defined
XML data XmlD Contains the supplier invoice XML document.
Processing Description
Order match

Starts the order match process flow.

The following settings are taken into consideration.

Company information table:

  • Additional fees and rounding product
  • Incoming invoice deviation tolerance %
  • Incoming invoice deviation tolerance amount
  • Incoming document pre-registration series
  • Product no. freight 4
  • Order attachment processing
    • Do not tolerate any deviation
    • Pre-registration incoming documents
    • Order match automatic invoice receive
  • Order processing 3
    • No partial invoice receival for order match
    • Reverse the pre-registration for order match when rejecting invoice

Associate table:

  • Incoming invoice deviation tolerance %
  • Incoming invoice deviation tolerance amount
  • Supplier options
    • No automatic invoice receive if freight
    • No automatic invoice receive if additional fees

Delivery alternative table:

  • Sup. prod. no.

Product table:

  • EAN item no.

Document link table

Field name SQL name Description
Amount Am Amount based on the supplier invoice document
Disc. amount DcAm Discount amount based on the supplier invoice document.
Disc. % DcP Discount % based on the supplier invoice document.
Price Price Price based on the supplier invoice document.
Quantity NoInvoAb Quantity based on the supplier invoice document.
CID code CID The CID from the supplier invoice.
Due date DueDt The due date from the supplier invoice.
Invoice date InvoDt The invoice date from the supplier invoice.
Invoice no. InvoNo The invoice number from the supplier invoice.
Order line no. OrdLnNo The order line number from the supplier invoice.

Product transaction table

Field name SQL name Description
Accounting document no. InAcDocNo This field refers to the Accounting document table.

Voucher table

Field name SQL name Description
Accounting document no. InAcDocNo This field refers to the Accounting document table.