Remittance format

The fields as described in the following subsections are available to control the file format for periodic import tasks available in additional licensed feature Finance utilities - AR utilities.

Number sequence

Cash and bank management > Setup > Advanced bank reconciliation setup > Financial utilities parameters

The following number sequences are required for setting up AR Utilities Remittance format.

Data management

Ensure entity Customer payment journal header contains field DXCARIMPORTVIAFINU.
Create a new import Data management project using composite entity Customer payment journal.

Remittance format

Note: The page is only available where additional licensed feature Finance utilities - AR utilities is enabled.

To open the Remittance format page, go to Accounts receivable > Payment setup > Remittance format.
On the Action Pane, select New and enter the following details.

Setup

Field format

The ability to set field format is available for the following fields:

• Customer reference
• Tax invoice

Select the Field format for the applicable field and set one of the following options:

• No format - The remittance field will be used as-is.
• Fixed field position - Set Start position and Length.
• Delimited field position - Set Delimiter (default is space) and Field position.
• Custom format - Ability to use a regex format

The Example and Value field is automatically updated based on above selection. The user can also paste/type their own example into Example to view the resulted Value from their setup.

Example result for each option:

Mapping

Where Custom format is set to Yes, select Mapping to map the file format fields.

The mapping is made up of two sections:

• File sections (structured only) and
• Field mappings (structured and flat)

File sections

Flat

Select Add to add mappings for a text file

Note: The Section type information will be defaulted and only a single Line entry is possible for flat text templates.

Structured

File sections are the different types of lines that can be found in a structured type file (as defined in the Template’s setup called Flat or structured).
Field mappings belong to each file section.

A Structured file can have many different file sections, all with an associated section type.

• Select New to create a new record
• Specify the Name of the file section. Exampled include header, lines, summary.
• Select the Section type. The options are:
  • Header – Header information often related to the Customer information.
  • Line – Related to line information.
  • Line Detail – A sub line data line whose data will be mapped to the same record as the Line’s section type data.
  • Footer – Summary/Total information.

    Note: Only one element is possible for Footer and Line sections within a file Section. Multiple elements are possible for Header and Line Details.
    Note: Each section type that is included in the file must be specified even if no mappings are required.

• Enter the section type Description
• Enter the Record Identifier - The identifier value used to identify the line type from the files data. The position of this identifier is specified on the template’s setup called Row identifier position.

Field mappings

Field mappings define how the data is positioned in the file on the section line. Fields can also be statically set to values and certain functions are available to transform the fields data if required.

Note: ** Available for Fixed type text templates.

There are two ways to add a field mapping:

Manual selection

1. To create a new mapping, select Add from the mapping FastTab.
2. Select if the Value type will be:
   • Field - mapped to or from staging field, or
   • Static - Static value used
3. If the Value type is Static, complete the Static value
   Note: Static value can be either plain text or a method between brackets for outbound files. Example:
   (currentDate())
   (currentLanguageId())
   (currentSessionDate())
   (currentSessionDateTime())
   
4. Specify the Staging field. Switch bewteen the header and lines table to find the required field.
5. Enter the Field position within the file.

Note: To delete a line, select the record then select Remove.

Fields picker

Alternatively, a bulk field picker can be used to add multiple mappings at once.

• Select Fields picker
• A new form is displayed allowing Header and Line selection of multiple available records

• Select Update to update the mapping

Buttons Select all and Clear all are also available to easily select or clear all fields for the mapping.

Note: To delete a line, select the record then select Remove. Lines can also be moved using the Move up or Move down buttons. If a field needs to be added more than once, use manual Add button on the Mappings FastTab.

Where used

The Remittance format is assigned on Methods of payment.
The Methods of payment is assigned in the Periodic task called Payment journal import.

Also see:

• Setup
• Processing

Data entities