Skip to content

Export Settings

JustOn can export invoice and booking detail data

  • to CSV files to be imported in accounting or ERP systems, and
  • to SEPA XML files for triggering payment operations with banks.

The custom setting Export Settings controls the export of invoice and booking detail data.

Info

This document covers general information about the custom setting Export Settings. For details about specific export configurations, see

Invoice & Booking Details CSV
SEPA Direct Debit XML
SEPA Credit XML
Cloud Storage

Export Settings Information

The custom setting Export Settings includes the following information:

Field Possible Values Description
Name SAP_CSV
SEPA Direct Debit
A unique name for the custom setting record, will be selectable when exporting invoice data.
Active true | false Determines whether the configuration is available in the UI.
SEPA: Booking per Transaction true | false Determines whether to override SEPA batch booking (consolidated payment, default). If true, forces an individual SEPA transaction per payment. Produces a corresponding <BtchBookg> element in the SEPA XML.
CUC 3121975D The unique CBI code that identifies all parties in the CBI community (clients, banks and network access points). Required when using a CBI format string, is applied for and registered by the access bank.
Configuration <Salesforce record ID> Specifies the Salesforce record ID of the JSON configuration document, which is required for CSV exports.
Create Payments true | false Determines whether to create payment balances on the invoices upon exporting, which sets the invoices Paid or Settled.
Users can overwrite this option manually when starting the export.
JustOn evaluates this setting only when using the Invoice CSV format.
CSV: Decimal Separator , Specifies the decimal separator to be used for invoice CSV exports. Defaults to . (full stop).
CSV: File Header Number;Date;Amount Specifies a first line (like a header row) for CSV exports.
Format Invoice CSV
XML CDD pain.008.003.02
Determines the export format.
CSV: Record Template Specifies a model for a line in the CSV export, may contain static text and placeholders for the actual values.
Is no longer used, left for compatibility reasons with older JustOn versions.
Select Condition Date__c = THIS_YEAR Specifies a condition (SOQL WHERE clause) to restrict the set of included records. If empty, matches all invoices in the list.
For details, see SOQL SELECT Syntax in the Salesforce Help.
Use ASCII Encoding Scheme true | false Determines whether to perform a phonetic replacement of the contents of the resulting CSV or XML file.
For CSV exports, for example, ä becomes ae, ç becomes c and so on. All non-ASCII characters that could not be replaced are substituted by a . (full stop).
For XML exports, all required replacements for the SEPA format are performed. For details, see SEPA Requirements for an Extended Character Set (UNICODE Subset) - Best Practices.
Target <file distribution target> Specifies the name of a file distribution target for the exported files. This can be used to upload the exported files to Amazon S3 or Google Drive or to save them in Salesforce libraries and folders.
If left empty, the file will only be available on Salesforce's Files tab as of JustOn 2.49.
Note that the file distribution target must be configured with the use case Export.
Allowed Currencies EUR,SEK Specifies a comma-separated list of currencies that are allowed for ISO 20022 XML formats. Defaults to EUR, which is the only allowed currency for SEPA.
ISO20022: Service Level Code SEPA Specifies the pre-agreed level of service between the parties. For SEPA, defaults to SEPA. For non-SEPA payments, contact your bank.

Defining Export Settings

Depending on your organization's requirements, you must define an export configuration.

  1. In Setup, open Custom Settings.

    In Salesforce Lightning, navigate to Custom Code > Custom Settings.

    In Salesforce Classic, navigate to Develop > Custom Settings.

  2. Click Manage in the row of Export Settings.

  3. Click New.
  4. Specify the details as necessary.

    For information about specific export configurations, see

  5. Click Save.