These settings configure the invoice date formatting and validation.

The following settings are available.

Validation Format

Select the date format that is displayed during the Validation Activity. Choose from:

• DDMMYYYY

• MMDDYYYY

• YYYYMMDD

The value for this setting is set to MMDDYYYY by default.

Export Format

Select the output date format for export. This setting applies to database output and all flat file exports. Choose from:

• DDMMYYYY

• MMDDYYYY

• YYYYMMDD

The value for this setting is set to MMDDYYYY by default.

Export Separator

The separator that is used when exporting a date value.

The value for this setting is set to / by default.

MMDD Countries

A comma-separated list of countries that use MM/DD/YYYY for the date format.

The value for this setting is set to US by default.

YYMMDD Countries

The comma-separated list of countries that use the YY-MM-DD date format.

The value for this setting is set to SE for Sweden by default.

Delivery Date Includes Ship Date

If selected, this expands the scope of delivery dates to also include ship dates. This means that dates with label indicating a shipping date, such as Shipped are also extracted.

This setting is cleared by default.

Enable Date Cross Check

If this setting is selected, date cross checks are executed during extraction and validation. If the checks fail, the date field is marked as invalid and the invoice is sent to the Validation Activity. Any invalid date fields can be overridden by the Validation Activity user.

The expected date sequence is as follows.

Delivery Date  Invoice Date  Due Date.

This setting is cleared by default.

The following buttons are available at the bottom of the window.

Save

Saves your changes and the window is closed.

Reload

Deletes any unsaved changes and resets the field values back to the last saved settings.