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.
This document covers general information about the custom setting Export Settings. For details about specific export configurations, see
Export Settings Information
The custom setting Export Settings includes the following information:
||A unique name for the custom setting record, will be selectable when exporting invoice data.|
||Determines whether the configuration is available in the UI.|
|SEPA: Booking per Transaction||
||Determines whether to override SEPA batch booking (consolidated payment, default). If
If you use SEPA batch bookings (
||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.|
||Specifies the 18-digit, case-safe Salesforce record ID of the JSON configuration document, which is required for CSV exports.|
||Determines whether to create payment balances on the invoices upon exporting, which sets the invoices
If you use SEPA batch bookings (
Users can overwrite this option manually when starting the export.
|CSV: Decimal Separator||
||Specifies the decimal separator to be used for invoice CSV exports. Defaults to
|CSV: File Header||
||Specifies a first line (like a header row) for CSV exports.|
||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.
||Specifies a condition (SOQL WHERE clause) to restrict the set of included records. If empty, matches all records in the list.
For details, see SOQL SELECT Syntax in the Salesforce Help.
|Use ASCII Encoding Scheme||
||Determines whether to perform a phonetic replacement of the contents of the resulting CSV or XML file.
For CSV exports, for example,
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.
||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
||Specifies a comma-separated list of currencies that are allowed for ISO 20022 XML formats. Defaults to
|ISO20022: Service Level Code||
||Specifies the pre-agreed level of service between the parties. For SEPA, defaults to
Defining Export Settings
Depending on your organization's requirements, you must define an export configuration.
In Setup, open Custom Settings.
In Salesforce Lightning, navigate to Custom Code > Custom Settings.
In Salesforce Classic, navigate to Develop > Custom Settings.
Click Manage in the row of Export Settings.
- Click New.
Specify the details as necessary.
For information about specific export configurations, see