Currency Settings
These are settings for the invoice currency.
Depending on your selections, different settings are displayed. If a field is displayed in certain circumstances, that information is listed below.
The following settings are available.
- Dollar Sign Is USD
-
If this field is enabled, no currency is identified on the invoice, but a $ sign is found in the OCR text, the currency is set to USD.
This setting is cleared by default.
- Default PO Currency
-
If selected and no currency is identified on the invoice, the system uses the same currency as the purchase order.
This setting is selected by default.
- Default Vendor Currency
-
If selected and no currency is identified on the invoice, the system uses the same currency as the vendor country of origin.
This setting is selected by default.
Note The Default Vendor Currency value overrides the Default PO Currency when both settings are selected. - Validate From SAP
-
If enabled, the currency field is validated against SAP during the Validation Activity. You cannot select this field and Validate From DB at the same time.
Important This setting is not available in the Azure cloud environment. - Validate From DB
-
If enabled, the currency field is validated against a database during the Validation Activity. You cannot select this field and Validate From SAP at the same time.
This setting is selected by default.
Important This setting and all of its dependent settings are not available in the Azure cloud environment. - Database Connection Name
-
Select the database connection name that specifies the currency database connection string, from the list.
This setting is available only when Validate From DB is selected above.
- DB Schema
-
Enter the name of a schema to filter the list of database tables available for the selected Database Connection Name.
If this field is left blank, all database tables that you have permission to access, are displayed.
-
This setting is available only when Validate From DB is selected above.
- DB Table Name
-
Select the name of the database table that is used to validate the currency, from the list. The list is populated based on the selected Database Connection Name and if used, the specified schema. If the selected table has columns that match the settings below, they are populated automatically.
This setting is mandatory for database lookups.
This setting is available only when Validate From DB is selected above.
- DB Column Name
-
If a value for this field is not populated automatically, select the name of the column in the database table that contains the valid currency code, from the list.
This setting is mandatory for database lookups.
This setting is available only when Validate From DB is selected above.
- Activate Extended Validation
-
When selected, extended validation is performed on the extracted currency result.
The extended validation compares the system-extracted currency to the following, in the order specified.
-
Permitted global currencies. See the Global Currencies setting below.
-
The vendor currency if present in the vendor extract.
-
The currency associated with the vendor country of origin.
-
The currency of the company code.
-
The currency associated with the company code country.
If the invoice currency does not match any of the above, then the currency is set to invalid and must be corrected in the Validation Activity. Errors caused by missing, incomplete or incorrect configuration in connection to company code and country lookups also set the currency field to invalid.
User input in the Validation Activity is excluded from the above checks and are assumed to be correct.
-
- Global Currencies
-
A comma-separated list of permitted global currencies.
The value for this setting is set to USD,EUR 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.