Master data: Supplier banks

You can use supplier-bank master data to supplement supplier master data with bank account information. Unlike other types of master data, supplier banks are not displayed in their own node under the Master data node in the administration tree view. Instead, the information is displayed in the Edit supplier dialog.

You use AP Essentials Connect to import master data in XML format.

To use this feature:

  • The supplier numbers in the SupplierNumber elements must match supplier numbers that already exist in the supplier master data. If there is no matching supplier number for a particular bank account, it is skipped.

To ensure master data is synchronized on a regular basis, export master data from your ERP system and use automatic uploading, or update the master data using the API.

Supplier bank XML Schema

The supplier-bank schema is listed below for your convenience. For the most up-to-date and complete schema, refer to the API documentation.

Creating master data in XML format requires knowledge of XML. Master data must adhere to an XML schema, which describes the structure the XML document you upload. Only the fields specified in the schema are allowed. You can omit some elements, but the order must remain the same. See the schema and example XML below for reference.

<xs:complexType name="SupplierBankAccount">
    <xs:sequence>
      <xs:element minOccurs="0" name="BankName" nillable="true" type="xs:string" />
      <xs:element minOccurs="0" name="SupplierNumber" nillable="true" type="xs:string" />
      <xs:element minOccurs="0" name="BankNumberType" nillable="true" type="xs:string" />
      <xs:element minOccurs="0" name="BankNumber" nillable="true" type="xs:string" />
      <xs:element minOccurs="0" name="AccountNumberType" nillable="true" type="xs:string" />
      <xs:element minOccurs="0" name="AccountNumber" nillable="true" type="xs:string" />
    </xs:sequence>
  </xs:complexType>

Example

You can use the XML below as an example to create your own supplier-bank data.

<?xml version="1.0"?>
<SupplierBankAccounts xmlns:i="http://www.w3.org/2001/XMLSchema-instance">
<SupplierBankAccount>
<BankName>Example Bank</BankName>
<SupplierNumber>00001</SupplierNumber>
<BankNumberType>bic</BankNumberType>
<BankNumber>1234567</BankNumber>
<AccountNumberType>plusgiro</AccountNumberType>
<AccountNumber>123456</AccountNumber>
</SupplierBankAccount><SupplierBankAccount>
<BankName>Another Example Bank</BankName>
<SupplierNumber>02</SupplierNumber>
<BankNumberType>bic</BankNumberType>
<BankNumber>7654321</BankNumber>
<AccountNumberType>bankgiro</AccountNumberType>
<AccountNumber>654321</AccountNumber>
</SupplierBankAccount>
</SupplierBankAccounts>