Automation - Connection of Supplier

Incoming invoices are linked to the supplier in the supplier registry using the organization number and bank account number.

Both fields must be present and match in both the invoice and the supplier card for Semine to connect the supplier and the invoice. Only the first bank account number from the invoice is compared with all bank account numbers on the supplier.

See also: Rules related to supplier matching which describes how automation rules can modify or set suppliers not covered by the built-in automation.

Example

Field	Invoice	Supplier Registry	Comparison
Organization Number	NO999888777MVA	999888777	Only digits in the organization number on the invoice are compared with the digits on the supplier
Bank Account Number	4444.22.55555 NO889944442255555	NO9944442255554 44442255555 NO9944442255556	The first bank account number on the invoice is compared with all available bank account numbers on the supplier.

Manual linking in the invoice list

It is always possible to change the supplier on an invoice until it is posted.

What if automatic linking does not work

Note: Invoices with identical supplier and invoice number will be marked as duplicates without further processing. See also: Invoice Status: Duplicate

• Check if the supplier has been imported into Semine

The supplier will not be imported if the organization number or country code is missing. Solution: Enter the organization number and country code for the supplier in ERP. The organization number should be unique for all suppliers under the same client.

• Check if the supplier is registered with the correct bank account number and organization number

Correct information in the supplier registry is required for this linking to happen automatically.
Correct the organization number and/or bank account number in your accounting system so that the change is available after the next import of supplier data into Semine.

• Contact the supplier to check if they have changed the bank account number.

If the supplier for the invoice is not found in the supplier registry, the word "Select" is displayed for the ERP ID column, and the supplier name found on the invoice is displayed in the Supplier column.

By clicking on the "Select" button, Semine will display all relevant information retrieved from the invoice in the "From Invoice" line, along with a list of all available suppliers sorted alphabetically below.

Enter parts of the organization number, bank account number, or supplier name to search in this list.
Then you can choose the supplier.

EHF / UBL invoice

Extract from UBL invoice.

1. Organization Number

   ubl:Invoice / cac:AccountingSupplierParty / cac:Party / cbc:EndpointID
   

   
   Example:

     <cac:AccountingSupplierParty>
       <cac:Party>
         <cbc:EndpointID schemeID="0192">999888777</cbc:EndpointID>
         ... 
      </cac:Party>
   </cac:AccountingSupplierParty>

   
   
   NOTE: Only numbers are extracted from this field. Commas, periods, hyphens, and spaces (,.- ) are removed.
   Example:
   1. From Invoice NO 999.888.777 MVA --> 999888777
   2. From Supplier Registry: 999.888.777 --> 999888777
   3. Comparison: 999888777= 999888777= match
      
      
2. Bank Account Number
   The first occurrence of the following field is extracted without further processing:

   ubl:Invoice / cac:PaymentMeans / cac:PayeeFinancialAccount / cbc:ID
   

   This applies only if schemeID = "BBAN"
   
   Example: 
   

     <cac:PaymentMeans>
       <cbc:PaymentMeansCode>31</cbc:PaymentMeansCode>
   ...
       <cac:PayeeFinancialAccount>
         <cbc:ID>44442255555</cbc:ID>
       </cac:PayeeFinancialAccount>
     </cac:PaymentMeans>

   
   NOTE: Only numbers are extracted from this field. Commas, periods, hyphens, and spaces (,.- ) are removed. The last 11 characters are extracted from the invoice.
   Example:
   1. From Invoice ABC4444.22.55555 --> 44442255555(last 11 characters)
   2. From Supplier Registry: 4444.22.55555 --> 44442255555
   3. Comparison: 44442255555= 44442255555= match
      
      

1. Organization Number
   999888777
2. Bank Account Number
   Semine searches through all bank account numbers on the supplier 
   NO9944442255555