--- id: object/table/86 type: object title: Table 86 "Exch. Rate Adjmt. Reg." summary: Table 86 "Exch. Rate Adjmt. Reg." in Base Application (Microsoft.Finance.Currency). 17 fields. Present since at least BC23, still in BC30, changed in BC24, BC28-29. tier: official language: en tags: - table - base application versions: introduced: null last_changed: "29" deprecated: null review: state: derived by: null at: null flags: [] generated: at: "2026-10-11T00:31:51.816Z" pipeline: 0.2.0 prompts: {} input_hash: 7a1ef63c00d93fa216922dee9b2af44edb9a10b1a73adf129656215ce0514df3 evidence: - kind: code url: https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Layers/W1/BaseApp/Finance/Currency/ExchRateAdjmtReg.Table.al title: src/Layers/W1/BaseApp/Finance/Currency/ExchRateAdjmtReg.Table.al (releases/29.x) date: null commit: ea08af5ef2d6a9b5c5af4a029288abbe2c883220 t: null quote: null links: learn: [] objects: [] features: [] topics: [] localizations: [] videos: [] posts: [] guidelines: [] object_type: table object_id: 86 name: Exch. Rate Adjmt. Reg. namespace: Microsoft.Finance.Currency app: Base Application extends: null first_version: "23" last_version: "30" present_in: - "23" - "24" - "25" - "26" - "27" - "28" - "29" - "30" changed_in: - "24" - "28" - "29" source_major: "29" obsolete: null countries: [] ms_search_form_ids: [] counts: fields: 17 procedures: 1 events: 0 subscribers: 0 relations: out: 11 referenced_by: 4 pages: 1 extended_by: 0 event_subscribers: 0 calls: 0 called_by: 0 implements: 0 --- # Table 86 "Exch. Rate Adjmt. Reg." > Table 86 "Exch. Rate Adjmt. Reg." in Base Application (Microsoft.Finance.Currency). 17 fields. Present since at least BC23, still in BC30, changed in BC24, BC28-29. Base Application · Microsoft.Finance.Currency · BC23-30 · [source at ea08af5e](https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Layers/W1/BaseApp/Finance/Currency/ExchRateAdjmtReg.Table.al) · facts from BC29 ## Properties | Property | Value | |---|---| | Caption | Exch. Rate Adjmt. Reg. | | 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 | No. | Integer | Specifies the number of the involved entry or record, according to the specified number series. | | | 2 | Creation Date | Date | Specifies the posting date for the exchange rate adjustment register. | | | 3 | Account Type | Enum "Exch. Rate Adjmt. Account Type" | Specifies the account type that was adjusted for exchange rate fluctuations when you ran the Adjust Exchange Rates batch job. | enum [Enum 596 "Exch. Rate Adjmt. Account Type"](../enum/596.md) | | 4 | Posting Group | Code[20] | Specifies the posting group of the exchange rate adjustment register on this line. | TableRelation [Table 277 "Bank Account Posting Group"](../table/277.md), [Table 5221 "Employee Posting Group"](../table/5221.md), [Table 92 "Customer Posting Group"](../table/92.md) (if ("Account Type" = const(Customer)) "Customer Posting Group" else if ("Account Type" = const(Vendor)) "Vendor Posting Group" else if ("Account Type" = const("Bank Account")) "Bank Account Posting Group" else if ("Account Type" = const(Employee)) "Employee Posting Group") | | 5 | Currency Code | Code[10] | Specifies the code for the currency whose exchange rate was adjusted. | TableRelation [Table 4 "Currency"](../table/4.md) | | 6 | Currency Factor | Decimal | — | | | 7 | Adjusted Base | Decimal | Specifies the amount that was adjusted by the batch job for customer, vendor and/or bank ledger entries. | | | 8 | Adjusted Base (LCY) | Decimal | Specifies the amount in LCY that was adjusted by the batch job for G/L, customer, vendor and/or bank ledger entries. via [Page 106 "Exchange Rate Adjmt. Register"](../page/106.md) | | | 9 | Adjusted Amt. (LCY) | Decimal | Specifies the amount by which the batch job has adjusted G/L, customer, vendor and/or bank ledger entries for exchange rate fluctuations. via [Page 106 "Exchange Rate Adjmt. Register"](../page/106.md) | | | 10 | Adjusted Base (Add.-Curr.) | Decimal | Specifies the additional-reporting-currency amount the batch job has adjusted G/L, customer, and other entries for exchange rate fluctuations. via [Page 106 "Exchange Rate Adjmt. Register"](../page/106.md) | | | 11 | Adjusted Amt. (Add.-Curr.) | Decimal | Specifies the additional-reporting-currency amount the batch job has adjusted G/L, customer, and other entries for exchange rate fluctuations. via [Page 106 "Exchange Rate Adjmt. Register"](../page/106.md) | | | 14 | Journal Template Name | Code[10] | — | | | 15 | Journal Batch Name | Code[10] | — | | | 21 | Adjusted Customers | Integer | Specifies the number of customer ledger entries with remaining amount that was adjusted. | FlowField: count("Detailed Cust. Ledg. Entry" where("Exch. Rate Adjmt. Reg. No." = field("No."))); not editable | | 22 | Adjusted Vendors | Integer | Specifies the number of vendor ledger entries with remaining amount that was adjusted. | FlowField: count("Detailed Vendor Ledg. Entry" where("Exch. Rate Adjmt. Reg. No." = field("No."))); not editable | | 23 | Adjustment Amount | Decimal | Specifies the total adjustment amount of exchange rate adjustment ledger entries. | FlowField: sum("Exch. Rate Adjmt. Ledg. Entry"."Adjustment Amount" where("Register No." = field("No."))); not editable | | 24 | Adjusted Employees | Integer | Specifies the number of emplooyee ledger entries with remaining amount that was adjusted. | FlowField: count("Detailed Employee Ledger Entry" where("Exch. Rate Adjmt. Reg. No." = field("No."))); not editable | ## Keys - Key1: No. (clustered) ## Procedures 1 local procedures, no public ones. ## Triggers OnDelete ## Relations - drill-down page [Page 106 "Exchange Rate Adjmt. Register"](../page/106.md) - lookup page [Page 106 "Exchange Rate Adjmt. Register"](../page/106.md) - Adjustment Amount: CalcFormula [Table 186 "Exch. Rate Adjmt. Ledg. Entry"](../table/186.md) - Posting Group: TableRelation [Table 277 "Bank Account Posting Group"](../table/277.md) (conditional) - Adjusted Customers: CalcFormula [Table 379 "Detailed Cust. Ledg. Entry"](../table/379.md) - Adjusted Vendors: CalcFormula [Table 380 "Detailed Vendor Ledg. Entry"](../table/380.md) - Currency Code: TableRelation [Table 4 "Currency"](../table/4.md) - Posting Group: TableRelation [Table 5221 "Employee Posting Group"](../table/5221.md) (conditional) - Adjusted Employees: CalcFormula [Table 5223 "Detailed Employee Ledger Entry"](../table/5223.md) - Posting Group: TableRelation [Table 92 "Customer Posting Group"](../table/92.md) (conditional) - Posting Group: TableRelation [Table 93 "Vendor Posting Group"](../table/93.md) (conditional) ## Referenced by 4 fields in 4 objects relate to this table (TableRelation or CalcFormula). - [Table 379 "Detailed Cust. Ledg. Entry"](../table/379.md): Exch. Rate Adjmt. Reg. No. - [Table 380 "Detailed Vendor Ledg. Entry"](../table/380.md): Exch. Rate Adjmt. Reg. No. - [Table 383 "Detailed CV Ledg. Entry Buffer"](../table/383.md): Exch. Rate Adjmt. Reg. No. - [Table 5223 "Detailed Employee Ledger Entry"](../table/5223.md): Exch. Rate Adjmt. Reg. No. ## Pages and codeunits on this table - [Page 106 "Exchange Rate Adjmt. Register"](../page/106.md) (source table) ## Across versions - Present in: BC23-30 - Changed (declaration) in: BC24, BC28-29 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: "Exch. Rate Adjmt. Reg.")`, then `bcatlas_get_procedure_body` or `bcatlas_get_neighbors` on the returned id.