Table 589 "G/L Account Source Currency"

Base Application · Microsoft.Finance.GeneralLedger.Account · BC24-30 · source at ea08af5e · facts from BC29

Properties

Property	Value
Caption	G/L Account Source Currency
DataClassification	CustomerContent
DrillDownPageId	Exchange Rate Adjmt. Register

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.

No.	Name	Type	Explanation	Notes
1	G/L Account No.	Code[20]	—	TableRelation Table 15 “G/L Account” (G/L Account)
2	Currency Code Δ BC29	Code[10]	Specifies the source currency code.	TableRelation Table 4 “Currency”
28	Date Filter	Date	—	FlowFilter
29	Global Dimension 1 Filter	Code[20]	—	TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(1))); FlowFilter
30	Global Dimension 2 Filter	Code[20]	—	TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(2))); FlowFilter
31	Balance at Date Δ BC28 Δ BC29	Decimal	Specifies the account balance in local currency.	FlowField: sum(“G/L Entry”.Amount where(“G/L Account No.” = field(“G/L Account No.”), “Source Currency Code” = field(“Currency Code”), “Global Dimension 1 Code” = field(“Global Dimension 1 Filter”), “Global Dimension 2 Code” = field(“Global Dimension 2 Filter”), “Posting Date” = field(upperlimit(“Date Filter”)…; not editable
75	Source Currency Net Change	Decimal	—	FlowField: sum(“G/L Entry”.“Source Currency Amount” where(“G/L Account No.” = field(“G/L Account No.”), “Source Currency Code” = field(“Currency Code”), “Global Dimension 1 Code” = field(“Global Dimension 1 Filter”), “Global Dimension 2 Code” = field(“Global Dimension 2 Filter”), “Posting Date” = field(“Date F…; not editable
76	Source Curr. Balance at Date Δ BC29	Decimal	Specifies the account balance in source currency.	FlowField: sum(“G/L Entry”.“Source Currency Amount” where(“G/L Account No.” = field(“G/L Account No.”), “Source Currency Code” = field(“Currency Code”), “Global Dimension 1 Code” = field(“Global Dimension 1 Filter”), “Global Dimension 2 Code” = field(“Global Dimension 2 Filter”), “Posting Date” = field(upperli…; not editable
77	Entries Exists Δ BC29	Boolean	Specifies if general ledger entries with this source currency code exists.	FlowField: exist(“G/L Entry” where(“G/L Account No.” = field(“G/L Account No.”), “Source Currency Code” = field(“Currency Code”))); not editable

Keys

Key1: G/L Account No., Currency Code (clustered)

Procedures

BuildCurrencyList(): Builds a complete list of source currency records for a general ledger account based on existing entries. Scans all general ledger entries for the filtered account and creates source currency records as needed.
InsertRecord(GLAccountNo: Code[20]; CurrencyCode: Code[10]): Creates a new source currency record for the specified general ledger account and currency combination. Initializes the record with proper validation for account and currency relationships.

Triggers

OnDelete, OnInsert, OnRename

Relations

drill-down page Page 106 “Exchange Rate Adjmt. Register”
lookup page Page 106 “Exchange Rate Adjmt. Register”
G/L Account No.: TableRelation Table 15 “G/L Account”
Balance at Date: CalcFormula Table 17 “G/L Entry”
Entries Exists: CalcFormula Table 17 “G/L Entry”
Source Curr. Balance at Date: CalcFormula Table 17 “G/L Entry”
Source Currency Net Change: CalcFormula Table 17 “G/L Entry”
Global Dimension 1 Filter: TableRelation Table 349 “Dimension Value”
Global Dimension 2 Filter: TableRelation Table 349 “Dimension Value”
Currency Code: TableRelation Table 4 “Currency”

Pages and codeunits on this table

Page 589 “G/L Account Source Currencies” (source table)
Page 590 “G/L Account Currency FactBox” (source table)

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: "G/L Account Source Currency"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.