Table 4 "Currency"

Base Application · Microsoft.Finance.Currency · BC23-30 · source at ea08af5e · facts from BC29

Learn documents this table through its pages: Page 5 “Currencies” (5 Learn pages), Page 30019 “APIV2 - Currencies” (5), Page 495 “Currency Card” (2).

Properties

Fields

Explanation: the field’s ToolTip in the code; without one, the ToolTip of a page control bound to the field (marked via the page); without that, its Caption (marked caption) when that differs from the name.

Keys

• Key1: Code (clustered)
• Key2: SystemModifiedAt

Events published

• OnAfterInitRoundingPrecision(var Currency: Record Currency; var xCurrency: Record Currency; var GeneralLedgerSetup: Record "General Ledger Setup") (integration): Integration event raised after initializing currency rounding precision settings. Allows customization of rounding precision initialization logic.
• OnBeforeGetGainLossAccount(var Currency: Record Currency; DtldCVLedgEntryBuffer: Record "Detailed CV Ledg. Entry Buffer") (integration): Integration event raised before determining the gain/loss account for currency transactions. Allows customization of account determination logic.
• OnBeforeResolveCurrencySymbol(var Currency: Record Currency; var CurrencyCode: Code[10]) (integration): Integration event raised before resolving a currency symbol. Allows customization of currency symbol resolution logic.
• OnGetGainLossAccountOnOtherEntryType(var Currency: Record Currency; DtldCVLedgEntryBuffer: Record "Detailed CV Ledg. Entry Buffer"; var IsHandled: Boolean; var ReturnValue: Code[20]) + BC25 (integration): Integration event raised when determining gain/loss account for entry types not handled by default logic. Allows handling of custom entry types for currency gain/loss posting.

Trigger event subscribers

• OnAfterDeleteEvent: Codeunit 347 “Amount Auto Format” ResetGlobalsOnCurrencyDelete
• OnAfterInsertEvent: Codeunit 347 “Amount Auto Format” ResetGlobalsOnCurrencyInsert
• OnAfterModifyEvent: Codeunit 347 “Amount Auto Format” ResetGlobalsOnCurrencyModify

Procedures

• InitRoundingPrecision(): Initializes currency rounding precision fields with values from General Ledger Setup. Sets default values for Amount Rounding Precision, Unit-Amount Rounding Precision, Invoice Rounding settings, VAT settings, and raises the OnAfterInitRoundingPrecision event.
• GetExchangeRate(ConversionDate: Date): Decimal + BC29: Retrieves the most recent exchange rate for the actual currency, based on 1FCY. If no exchange rate is specified, it returns 1
• VATRoundingDirection(): Text[1]: Returns the directional symbol for VAT rounding based on the VAT Rounding Type setting. Used in rounding calculations to determine rounding behavior.
• InvoiceRoundingDirection(): Text[1]: Returns the directional symbol for invoice rounding based on the Invoice Rounding Type setting. Used in invoice rounding calculations to determine rounding behavior.
• CheckAmountRoundingPrecision(): Validates that required rounding precision fields are properly set. Ensures both Unit-Amount Rounding Precision and Amount Rounding Precision have values.
• GetGainLossAccount(DtldCVLedgEntryBuf: Record "Detailed CV Ledg. Entry Buffer"): Code[20]: Determines the appropriate G/L account for posting currency gain/loss based on entry type. Routes to specific account getter methods based on the type of gain/loss being processed. Raises OnBeforeGetGainLossAccount event for customization opportunities.
• GetRealizedGainsAccount(): Code[20]: Returns the G/L account for posting realized currency gains. Validates that the account is specified before returning it.
• GetRealizedLossesAccount(): Code[20]: Returns the G/L account for posting realized currency losses. Validates that the account is specified before returning it.
• GetRealizedGLGainsAccount(): Code[20]: Returns the G/L account for posting realized currency gains on G/L transactions. Validates that the account is specified before returning it.
• GetRealizedGLLossesAccount(): Code[20]: Returns the G/L account for posting realized currency losses on G/L transactions. Validates that the account is specified before returning it.
• GetResidualGainsAccount(): Code[20]: Returns the G/L account for posting residual currency gains. Validates that the account is specified before returning it.
• GetResidualLossesAccount(): Code[20]: Returns the G/L account for posting residual currency losses. Validates that the account is specified before returning it.
• GetUnrealizedGainsAccount(): Code[20]: Returns the G/L account for posting unrealized currency gains. Validates that the account is specified before returning it.
• GetUnrealizedLossesAccount(): Code[20]: Returns the G/L account for posting unrealized currency losses. Validates that the account is specified before returning it.
• GetConvLCYRoundingDebitAccount(): Code[20]: Returns the G/L account for posting debit rounding differences during LCY conversion. Validates that the account is specified before returning it.
• GetConvLCYRoundingCreditAccount(): Code[20]: Returns the G/L account for posting credit rounding differences during LCY conversion. Validates that the account is specified before returning it.
• GetCurrencySymbol(): Text[10]: Gets the display symbol for this currency, falling back to the currency code if no symbol is defined.
• ResolveCurrencySymbol(CurrencyCode: Code[10]): Text[10]: Resolves an appropriate display symbol for a given currency code. First checks if the currency record has a custom symbol, then falls back to built-in symbol mappings for common currencies. Raises OnBeforeResolveCurrencySymbol event for customization.
• ResolveCurrencyDescription(CurrencyCode: Code[10]): Text: Resolves a descriptive name for a given currency code. First checks if the currency record has a custom description, then falls back to built-in description mappings for common currencies.
• ResolveGLCurrencySymbol(CurrencyCode: Code[10]): Text[10]: Resolves the currency symbol for use in General Ledger contexts. If a currency code is provided, resolves its symbol. If empty, returns the LCY symbol from GL Setup.
• Initialize(CurrencyCode: Code[10]): Initializes the currency record by loading it if a currency code is provided. If no currency code is provided, initializes rounding precision from GL Setup. This is an overload that calls the full Initialize method with CheckAmountRoundingPrecision set to false.
• Initialize(CurrencyCode: Code[10]; CheckAmountRoundingPrecision: Boolean): Initializes the currency record by loading it if a currency code is provided. If no currency code is provided, initializes rounding precision from GL Setup. Optionally validates that Amount Rounding Precision is properly set.
• SuggestSetupAccounts(): Suggests appropriate G/L accounts for currency posting based on existing currency setups. Analyzes other currency records to suggest commonly used accounts for gain/loss posting. Shows a message if no suggestions can be made.
• CheckDuplicateCurrencySymbol(CurrencySymbol: Text[10]) + BC27

Plus 5 local procedures.

Triggers

OnDelete, OnInsert, OnModify, OnRename

Relations

• lookup page Page 5 “Currencies”
• Conv. LCY Rndg. Credit Acc.: TableRelation Table 15 “G/L Account”
• Conv. LCY Rndg. Debit Acc.: TableRelation Table 15 “G/L Account”
• Realized G/L Gains Account: TableRelation Table 15 “G/L Account”
• Realized G/L Losses Account: TableRelation Table 15 “G/L Account”
• Realized Gains Acc.: TableRelation Table 15 “G/L Account”
• Realized Losses Acc.: TableRelation Table 15 “G/L Account”
• Residual Gains Account: TableRelation Table 15 “G/L Account”
• Residual Losses Account: TableRelation Table 15 “G/L Account”
• Unrealized Gains Acc.: TableRelation Table 15 “G/L Account”
• Unrealized Losses Acc.: TableRelation Table 15 “G/L Account”
• Customer Filter: TableRelation Table 18 “Customer”
• Cust. Ledg. Entries in Filter: CalcFormula Table 21 “Cust. Ledger Entry”
• Vendor Filter: TableRelation Table 23 “Vendor”
• Vendor Ledg. Entries in Filter: CalcFormula Table 25 “Vendor Ledger Entry”
• Global Dimension 1 Filter: TableRelation Table 349 “Dimension Value”
• Global Dimension 2 Filter: TableRelation Table 349 “Dimension Value”
• Customer Outstanding Orders: CalcFormula Table 37 “Sales Line”
• Customer Shipped Not Invoiced: CalcFormula Table 37 “Sales Line”
• Customer Balance: CalcFormula Table 379 “Detailed Cust. Ledg. Entry”
• Customer Balance (LCY): CalcFormula Table 379 “Detailed Cust. Ledg. Entry”
• Customer Balance Due: CalcFormula Table 379 “Detailed Cust. Ledg. Entry”
• Vendor Balance: CalcFormula Table 380 “Detailed Vendor Ledg. Entry”
• Vendor Balance (LCY): CalcFormula Table 380 “Detailed Vendor Ledg. Entry”
• Vendor Balance Due: CalcFormula Table 380 “Detailed Vendor Ledg. Entry”
• Vendor Amt. Rcd. Not Invoiced: CalcFormula Table 39 “Purchase Line”
• Vendor Outstanding Orders: CalcFormula Table 39 “Purchase Line”
• Coupled to Dataverse: CalcFormula Table 5331 “CRM Integration Record”

Referenced by

188 fields in 170 objects relate to this table (TableRelation or CalcFormula).

• Table 5200 “Employee”: Currency Code, Currency Filter, Payroll Currency Code
• Table 1208 “Direct Debit Collection Entry”: Applies-to Entry Currency Code, Currency Code
• Table 1226 “Payment Export Data”: Currency Code, Sender Bank Account Currency
• Table 167 “Job”: Currency Code, Invoice Currency Code
• Table 179 “Reversal Entry”: Currency Code, Source Currency Code
• Table 18 “Customer”: Currency Code, Currency Filter
• Table 181 “Posted Gen. Journal Line”: Currency Code, Source Currency Code
• Table 21 “Cust. Ledger Entry”: Closed by Currency Code, Currency Code
• Table 210 “Job Journal Line”: Currency Code, Source Currency Code
• Table 23 “Vendor”: Currency Code, Currency Filter
• Table 25 “Vendor Ledger Entry”: Closed by Currency Code, Currency Code
• Table 330 “Currency Exchange Rate”: Currency Code, Relational Currency Code
• Table 37203 “Remit. Advice Buffer”: Currency Code, Line Currency Code
• Table 382 “CV Ledger Entry Buffer”: Closed by Currency Code, Currency Code
• Table 5135 “Job Archive”: Currency Code, Invoice Currency Code
• Table 5222 “Employee Ledger Entry”: Closed by Currency Code, Currency Code
• Table 81 “Gen. Journal Line”: Currency Code, Source Currency Code
• Table 1001 “Job Task”: Invoice Currency Code
• Table 1003 “Job Planning Line”: Currency Code
• Table 1012 “Job Resource Price”: Currency Code
• Table 1013 “Job Item Price”: Currency Code
• Table 1014 “Job G/L Account Price”: Currency Code
• Table 110 “Sales Shipment Header”: Currency Code
• Table 112 “Sales Invoice Header”: Currency Code
• Table 114 “Sales Cr.Memo Header”: Currency Code
• Table 120 “Purch. Rcpt. Header”: Currency Code
• Table 1206 “Credit Transfer Entry”: Currency Code
• Table 122 “Purch. Inv. Header”: Currency Code
• Table 124 “Purch. Cr. Memo Hdr.”: Currency Code
• Table 1293 “Payment Application Proposal”: Currency Code
• Table 1294 “Applied Payment Entry”: Currency Code
• Table 1304 “Sales Price and Line Disc Buff”: Currency Code
• Table 1315 “Purch. Price Line Disc. Buff.”: Currency Code
• Table 1381 “Customer Templ.”: Currency Code
• Table 1383 “Vendor Templ.”: Currency Code
• Table 15 “G/L Account”: Source Currency Code
• Table 1572 “Approval Entry Buffer”: Currency Code
• Table 169 “Job Ledger Entry”: Currency Code
• Table 1690 “Bank Deposit Header”: Currency Code
• Table 1691 “Posted Bank Deposit Header”: Currency Code
• Table 1692 “Posted Bank Deposit Line”: Currency Code
• Table 17 “G/L Entry”: Source Currency Code
• Table 170 “Standard Sales Code”: Currency Code
• Table 172 “Standard Customer Sales Code”: Currency Code
• Table 173 “Standard Purchase Code”: Currency Code
• Table 175 “Standard Vendor Purchase Code”: Currency Code
• Table 186 “Exch. Rate Adjmt. Ledg. Entry”: Currency Code
• Table 19 “Cust. Invoice Disc.”: Currency Code
• Table 201 “Resource Price”: Currency Code
• Table 20500 “Subcontractor Price”: Currency Code
• and 120 more objects (120 fields): data/code/relations/29.json

Pages and codeunits on this table

• Page 20019 “APIV1 - Currencies” (source table)
• Page 30019 “APIV2 - Currencies” (source table)
• Page 486 “Cust. Stats. by Curr. Lines” (source table)
• Page 487 “Vend. Stats. by Curr. Lines” (source table)
• Page 495 “Currency Card” (source table)
• Page 5 “Currencies” (source table)

Recent changes

• 2026-09-25 #10717 Enable amount formatting with currency symbols (main, BC30, feature)
• 2026-07-31 #8959 Deliverable 638799: Spend Requests in Base App (main, BC30, feature)
• 2026-07-20 #9089 Merge-ES-Excluded-from-Calculation-to-W1 (main, BC30, feature)

Countries that replace it

ES, NO, RU

Deprecations

• field Coupled to CRM: Removed 26.0 (#if not CLEANSCHEMA26), “Replaced by flow field Coupled to Dataverse”

Source: AL metadata extracted from the code (names, ids, signatures, properties); no code bodies (D10).

Ask your agent

Procedure bodies are not stored here (D10). For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: bcatlas_resolve_node(object_type: "table", object_name: "Currency"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.