A conversion rate between two currency codes, effective from a date: one unit of the From Currency equals Rate units of the To Currency. The only reader of these rows is the period-end currency revaluation calculation, which looks up the latest active rate of the run's rate type (Closing by default). No seeded app, screen, button or scheduled job runs that calculation, and no invoice, bill, payment or journal reads an exchange rate, so rows you add today are reference data only. Exchange Rate is not in any seeded app and has no seeded form or list view. Nothing reads the Average rate type.
Fields
| Field | Label | Type | Required | What it does |
|---|
CreatedById | Created By | Lookup → UserAccount | Yes | |
CreatedDateTime | Created On | DateAndTime | Yes | |
EffectiveDate | Effective Date | DateAndTime | | Date the rate applies from. The lookup takes the row with the latest Effective Date on or before the date being converted. A row with no Effective Date is never used. |
FromCurrency | From Currency | Text | | Currency code being converted from, up to 8 characters, typed as free text (it is not a lookup to the Currency list). Use the same code that the revaluation positions carry, for example USD. |
Id | Id | Guid | Yes | |
IsActive | Is Active | Boolean | | Clear it to retire a rate without deleting it. Inactive rows are ignored by the lookup; a blank value counts as active. |
ModifiedById | Modified By | Lookup → UserAccount | Yes | |
Name | Name | Text | Yes | Identifier for the rate row, for example the pair and date. It is required and typed by hand, because no document name series is seeded for exchange rates. |
OwnerId | Owner | Lookup → UserAccount | Yes | |
PartnerAccountId | Partner Account | Lookup → Account | | Company the rate belongs to. The lookup uses rows for the company being converted and rows with no company, which apply to every company. When both exist for the same date, which one wins is not defined, so keep one or the other per currency pair. |
Rate | Rate | Currency | | Units of the To Currency for one unit of the From Currency, stored to 8 decimal places. A rate of zero or blank is skipped by the lookup, as if the row did not exist. |
RateType | Rate Type | Text | | Free-text rate type. The revaluation lookup matches it exactly against the run's rate type, which defaults to Closing, so a row of any other type (Spot, Average, or a misspelling) is never picked up by revaluation. No feature reads the Average type. |
RecordTypeId | Record Type | Guid, hidden | | |
ToCurrency | To Currency | Text | | Currency code being converted into, up to 8 characters, free text. For revaluation this is the base currency of the run. When only the reverse pair is on file, the lookup uses the reciprocal of that row's rate. |
UIProps | UI Props | Text | | |
UpdatedDateTime | Updated On | DateAndTime | Yes | |
Actions
| Action | Label | Type | What it does |
|---|
Clone | Clone | ServerAction (Clone) | Create a copy of this record |
