Currency Conversion Factors
  • 10 Jun 2024
  • 4 Minutes to read
  • Dark
    Light
  • PDF

Currency Conversion Factors

  • Dark
    Light
  • PDF

Article summary

This article is an overview of Currency Conversion Factors, a screen in the Administration section of the Accounting module of R365. Accounting Admins use this screen to configure which currencies are available on transactions so that other users can view this information on invoices when a currency conversion is applied. 

This feature is available only to Early Adopters. Contact your CSM or R365 Support to learn how Alternate Currency Entry can enhance your R365 experience! 


Overview

R365 can convert international currencies on transactions and provide details about the conversion, such as the original amount, the converted amount, and the multiplier used in the calculations. This information is helpful to Accounting users who work with international vendors. When Alternate Currency Entry is enabled, these users can more easily enter amounts on the AP Invoice form, even when the currency used on the invoice is not the local currency for the organization.

For example, if a user needs to make a payment to a vendor based in Canada but the user's organization is based in the United States, they enter the original amount on the invoice in Canadian Dollars. The Details section of the AP Invoice form displays both the amount in the Entry Currency (Canadian Dollars) and the amount in the Local Currency (US Dollars), allowing the user to make informed decisions about the payment.

To learn about tasks performed on this screen, see Working with Currency Conversion Factors.


Security

Only Accounting Admin users can access the Currency Conversion Factors screen. 

The Permissions listed here are associated with Currency Conversion Factors. These permissions can be added to Custom User Roles or individual users. Learn more about managing Permissions and Custom User Roles here.

Permissions for Currency Conversion Factors are found in the permission tree as follows:

  • General Ledger

    • Alternate Currency Entry

      • View Currency Conversion Factors

      • Edit Currency Conversion Factors

The Permission Access report can be used to determine which user roles or users already have these permissions assigned. Learn more about User Setup and Security here.


Navigation

  • In the Administration section of the left navigation pane, select Currency Conversion Factors.
    The Currency Conversion Factors screen opens.


Fields and columns in Currency Conversion Factors 

Currency Conversion Factors screen

Field

Description

Add Currency

Open the Add Currency dialog box where you can add a new currency to the table.

The first time a user accesses the screen, an Add Local Currency button appears in place of the Add Currency button. Once the local currency is added, this becomes the Add Currency button, and the local currency cannot be changed.

Refresh

Refresh the data in the table.

Currency 

Name of the currency. The default currency for the organization is marked Local.

Abbreviation

Abbreviated name for the currency.

Factor

Multiplier to be used in currency conversion calculations.

Effective Date

Date on which the factor goes into effect and the currency can be used in transactions.

Last Modified On

Date when the currency was most recently altered or updated.

Last Modified By

Username of the person who made most recent changes to the currency.

Actions menu

Open the Actions menu where the following actions can be performed:

  • Create new factor

  • View history

  • Make inactive

  • Delete

To learn more about each of these tasks and how to perform them, see Working with Currency Conversion Factors.

Add Currency dialog box

Field

Description

Currency

Select the currency to add.
This field is required.

Abbreviation

The abbreviated name for the currency fills automatically when the currency is selected.
This field is read-only.

Conversion Factor

Enter the multiplier to be used in currency conversion calculations.
This field is required.

Effective Date

Enter or use the calendar menu to select the date on which the factor goes into effect and the currency can be used in transactions.
This field is required.

Only one factor is allowed for each currency for each date.

Available in transactions

Select the checkbox to make the currency available for use in transactions.

Cancel

Exit the dialog box without saving selections.

Save

Save selections and close the dialog box.

Create new factor dialog box

Field

Description

Currency

Name of the currency.
This field is read-only.

Abbreviation

The abbreviated name for the currency fills automatically when the currency is selected.
This field is read-only.

Conversion Factor

Enter the multiplier to be used in currency conversion calculations.
This field is required.

Effective Date

Enter or use the calendar menu to select the date on which the factor goes into effect and the currency can be used in transactions.
This field is required.
Note: Only one factor is allowed for each currency for each date.

Cancel

Exit the dialog box without saving selections.

Save and Add Another

Save selections and clear the dialog box to continue adding new factors and effective dates.

Save

Save selections and close the dialog box.

Currency Conversion History sidesheet

Field

Description

Save

Save the view.

Expand / Collapse

Expand or collapse the sidesheet.

Close

Close the sidesheet.

Search

Enter a date, factor, or username in the Search field. The table automatically updates to display data that matches the search criteria.

Filter

Open the Filter columns dialog box.
For more information, see Working with Currency Conversion Factors.

Export

Download a CSV file of the history. If any search, sort, or filter options are applied, the exported file matches the data shown on the screen.

Effective Date

Date on which the change is in effect. The factor remains in effect until it is overwritten by a factor with a more recent effective date.

Factor

Multiplier to be used in currency conversion calculations.

Modified On

Date when the change was made.

Modified By

Username of the person who made the change.


Was this article helpful?