Supported features

This solution handles and transfers key invoice data to 'Supplier Invoice Batch Entry' (APS450) in M3. It processes both high-level header information and detailed line-item data to facilitate accurate invoice matching.

When you run this solution, these invoice data can be transferred to M3 'Supplier Invoice Batch. Open' (APS450):

Header-level fields

These fields are automatically extracted or looked up, validated, and transferred to M3:

  • Supplier: The M3 supplier is looked-up using supplier details from the invoice such as name, VAT registration number, IBAN, address, and TAX ID number for US suppliers.
  • Invoice Number: The supplier's unique number for the invoice document.
  • Invoice Date: The date the invoice was issued.
  • Due Date: Stated date for payment.
  • Currency: The currency of the invoice such as EUR and USD.
  • Invoice Total Amount: The final, gross amount payable.
  • VAT Amount: The total amount of Value-Added Tax.
  • VAT Rate: The tax rate applied.
  • Purchase Order Number: The PO number referenced at the header level.
  • Delivery Note Number
  • Order Charges
  • Parallel Invoice Number

Line-level fields

In addition to the header information, These details captured for each line item on the invoice, enabling line-level matching in M3:

  • Item Code or Alias Number: The specific product or service identifier.
  • Quantity: The number of units being invoiced.
  • Unit Price: The price per unit.
  • Line Total Amount: The total amount for the line calculated as Quantity x Unit Price.
  • Unit of Measure (U/M): The unit for the invoiced quantity such as EA and KG.
  • Line-specific PO Number: The PO number associated with an individual line, if different from the header.
  • Delivery Note Number
  • Charges: Description and amount
Note: This invoice batch type can be transferred to 'Supplier Invoice Batch. Open' (APS450) through the solution:

20 = 'Supplier invoice'

Invoice matching levels

This solution works seamlessly with the standard invoice matching capabilities of M3 business engine. The solution extracts all necessary data from an invoice and instructs M3 on which matching method to perform.

The solution provides flexibility to process invoices at two distinct levels:

  • Header level
  • Line level

The choice between these matching levels is dynamically controlled by the solution's configuration and can be overridden for specific suppliers using ION Business Rules. After the invoice data loads into M3 with the specified matching level, the standard M3 business engine performs the final matching process, which includes checks against goods receipts based on your core M3 configuration.