Skip to main content

Window: Currency Rate

[Created: 11/06/1999 - Updated: 02/01/2000 ]
Description: Maintain Currency Conversion Rates
Help: The Conversion Rates window is used to define the conversion rates that will be used when converting document amounts from one currency to another. Note that only the multiply rate is used; The divide rate is for visualization only.

Tab: Conversion Rate

[Created: 30/08/1999 - Updated: 02/01/2000 ]
Description: Define Currency Conversion Rates
Help: The Conversion Rates tab is used to define conversion rates to be used when converting document amounts from one currency to another. Conversion rates can be defined for multiple rate types. They can also be effective for a defined range of dates. Note that only the multiply rate is used; The divide rate is for visualization only.
Tab Level: 0

Table 10: Conversion Rate - Fields

Table: Report Parameters

NameDescriptionHelpTechnical Info
TenantTenant for this installation.A Tenant is a company or a legal entity. You cannot share data between Tenants.c_conversion_rate.AD_Client_ID numeric(10)
Table Direct
OrganizationOrganizational entity within tenantAn organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations.c_conversion_rate.AD_Org_ID numeric(10)
Table Direct
CurrencyThe Currency for this recordIndicates the Currency to be used when processing or reporting on this recordc_conversion_rate.C_Currency_ID numeric(10)
Table
Currency ToTarget currencyThe Currency To defines the target currency for this conversion rate.c_conversion_rate.C_Currency_ID_To numeric(10)
Table
ActiveThe record is active in the systemThere are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.There are two reasons for de-activating and not deleting records:(1) The system requires the record for audit purposes.(2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries.c_conversion_rate.IsActive character(1)
Yes-No
Currency TypeCurrency Conversion Rate TypeThe Currency Conversion Rate Type lets you define different type of rates, e.g. Spot, Corporate and/or Sell/Buy rates.c_conversion_rate.C_ConversionType_ID numeric(10)
Table Direct
Valid fromValid from including this date (first day)The Valid From date indicates the first day of a date rangec_conversion_rate.ValidFrom timestamp without time zone
Date
Valid toValid to including this date (last day)The Valid To date indicates the last day of a date rangec_conversion_rate.ValidTo timestamp without time zone
Date
Multiply RateRate to multiple the source by to calculate the target.To convert Source number to Target number, the Source is multiplied by the multiply rate. If the Multiply Rate is entered, then the Divide Rate will be automatically calculated.c_conversion_rate.MultiplyRate numeric
Number
Divide RateTo convert Source number to Target number, the Source is dividedTo convert Source number to Target number, the Source is divided by the divide rate. If you enter a Divide Rate, the Multiply Rate will be automatically calculated.c_conversion_rate.DivideRate numeric
Number