action.skip

Why has the SEPA export not produced the files as expected?

← Accounting Support FAQ

Your organization's business may want to export SEPA bank transfer orders for invoices or account balances – a common means for collecting payments. These payment orders can then directly be used by banks for triggering the corresponding payment operations.

Even if correctly set up, the SEPA export may fail or not produce the expected result. In this case, check for the following conditions:

Source Data Quality

Depending on the type of SEPA export and its source data, JustOn Billing & Invoice Management checks the execution conditions and validates the SEPA payment information before actually executing the export.

JustOn exports SEPA Direct Debit orders for invoices if

  • the invoice's open amount is greater than 0,
  • the invoice has not yet been exported (multiple exports can be forced, however), and
  • the payment method is SEPA (as an active picklist value).

Before executing the export, JustOn validates the SEPA payment information. It checks the format and structure (length, allowed characters, etc.) of the SEPA Creditor ID, IBAN, BIC and Direct Debit Mandate Reference according to the definitions in the SEPA Direct Debit Core Schemes.

As part of the validation, JustOn removes any whitespaces from IBAN numbers.

The result of the validation is written to the invoice field SEPA Validation Error. The bank transfer order for an invoice is exported if the SEPA Validation Error field is empty.

If you use payment instruments, the data to be validated is taken from the active payment instrument set for an account (in the field Current SEPA Mandate).

Otherwise, the following conditions must be true in order for the validation to succeed:

  • The invoice refers to a business entity.

  • The following fields of the business entity are set:

    SEPA Creditor ID

    IBAN

    Company

  • The following fields of the invoice are set:

    Bank Account

    Bank Account Owner

    Direct Debit Mandate Granted

    Direct Debit Mandate Reference

    Direct Debit Sequence Type

  • When using a CBI export format, the Member ID field of the business entity contains the ABI code of the bank.

JustOn exports SEPA Credit orders for invoices if

  • the invoice's open amount is less than 0,
  • the invoice has not yet been exported (multiple exports can be forced, however), and
  • the payment method is SEPA (as an active picklist value).

Before executing the export, JustOn validates the SEPA payment information. JustOn checks the format and structure (length, allowed characters, etc.) of the IBAN and BIC according to the definitions in the SEPA Credit Transfer Schemes.

As part of the validation, JustOn removes any whitespaces from IBAN numbers.

The result of the validation is written to the invoice field SEPA Validation Error. The bank transfer order for an invoice is exported if the SEPA Validation Error field is empty.

If you use payment instruments, the data to be validated is taken from the active payment instrument set for an account (in the field Current SEPA Mandate).

Otherwise, the following conditions must be true in order for the validation to succeed:

  • The invoice refers to a business entity.

  • The following fields of the business entity are set:

    IBAN

    Company

  • The following fields of the invoice are set:

    Bank Account

    Bank Account Owner

  • When using a CBI export format, the Member ID field of the business entity contains the ABI code of the bank.

  • If Credit IBAN and Credit BIC are set for the business entity, JustOn uses these values instead of IBAN and BIC.

JustOn exports SEPA Credit orders for account balances if

  • the balance is not assigned to an invoice,
  • the balance amount is less than 0, and
  • the balance type is Payment or Prepayment.

Before executing the export, JustOn validates the SEPA payment information. It checks the format and structure (length, allowed characters, etc.) of the IBAN and BIC according to the definitions in the SEPA Credit Transfer Schemes.

As part of the validation, JustOn removes any whitespaces from IBAN numbers.

The result of the validation is written to the balance field SEPA Validation Error. The bank transfer order for a balance is exported if the SEPA Validation Error field is empty.

If you use payment instruments, the data to be validated is taken from the active payment instrument set for an account (in the field Current SEPA Mandate).

Otherwise, the following conditions must be true in order for the validation to succeed:

  • JustOn determines the appropriate business entity according to the business entity configuration. The following fields of the business entity are set:

    IBAN

    Company

  • The following fields of the account are set:

    ON_BankAccount

    ON_BankAccountOwner

  • When using a CBI export format, the Member ID field of the business entity contains the ABI code of the bank.

  • If Credit IBAN and Credit BIC are set for the business entity, JustOn uses these values instead of IBAN and BIC.

Date Range

When exporting bank transfer orders from invoices, JustOn determines the relevant date range automatically, ignoring any specified date range. For SEPA-compliant bank transfer orders, the Next Payment Due Date is relevant. It must be in the past or within the next 14 days from today.

For invoices whose Next Payment Due Date is in the past, JustOn corrects the payment date to TODAY + 2. Any manually specified payment date beyond the next 14 days from today will be corrected to be within the allowed date range.

File Access

Salesforce Files is the default target location for storing produced files, including exported SEPA XML files.

For accessing and using file-related features, make sure that

  • the Salesforce features Content Deliveries and Salesforce CRM Content are enabled in your org, and
  • users who trigger the SEPA export or transfer the produced files to banks have the corresponding access rights (via profiles or permission sets).

Related information:

SEPA Export
Configuring SEPA Direct Debit Export
Configuring SEPA Credit Export
Enabling SEPA Mandate Payment Instruments
Exporting Bank Transfer Orders