Importing the pre-mapped transactions for Reconciliation Compliance Applications in Data Exchange - New Options

From 25.06 release, using Data Exchange to import pre-mapped transactions, the following new options are available:

• Date format: Specifies the data format for transactions
• Use comma as decimal separator: Set Yes or No to indicate if a comma must be used as a decimal separator

When registering an application, or creating a data integration, we can set the above options by using Data Exchange under the Application card.

Where for Data format, available options are -

• MM/dd/yyyy
• MM-dd-yyyy
• MMM d, yyyy
• d-M-yyyy
• dd-MMM-yy
• dd/MM/yyyy

By default, the date format is blank, which enables the system to use means all date format to parse date values.

And

Use commas as decimal separator, select Yes to use a comma as the decimal separator.

Select No to use the user locale for number parsing. 

By default, this option is set to No (the decimal separator is based on the user locale and not a comma.)

In below section, we will talk how to register the reconciliation compliance Transactions application. 

Registering a Reconciliation Compliance Transactions Application

To register a Reconciliation Compliance Transaction application by selecting the "Data Export" category and "Reconciliation Compliance Transactions" as the application type, and then you select the application name.

To add a Reconciliation Compliance Transactions target application:

1. From the Data Integration home page, and then Actions, select Applications.

2. On the Applications page, click  (Add icon).

3. On the Create Application page, and then Category, select Data Export.

4. From Type, select Reconciliation Compliance Transactions.

5. From Application, select the Reconciliation Compliance Transactions application transaction type.

   Application Name is a drop-down list with the following transaction types:

   • Balance Explanations
   • Source System Adjustments
   • Subsystem Adjustments
   • Variance Explanations

   

6. In Prefix, optionally specify a prefix to make the application name unique.

   The prefix is concatenated with the application name to form a unique application name. For example, if you want to name an application with the same name as an existing one, you can assign your initials as the prefix.

7. Click OK.

8. From the Applications page, select the Reconciliation Compliance Transactions Application that you just registered above, then click  to the right of the application, and then select Application Details.

9. Select the Options tab.

   Your selections on the Options tab apply to the target application.

   

10. Click Save.

Business Benefit: This feature provides additional flexibility and improves usability when loading pre-mapped transactions.