Table 86 Exch. Rate Adjmt. Reg.

Base Application, Microsoft.Finance.Currency

src/Layers/W1/BaseApp/Finance/Currency/ExchRateAdjmtReg.Table.al181 lines, Copyright (c) Microsoft Corporation. MIT

// ------------------------------------------------------------------------------------------------// Copyright (c) Microsoft Corporation. All rights reserved.// Licensed under the MIT License. See License.txt in the project root for license information.// ------------------------------------------------------------------------------------------------namespace Microsoft.Finance.Currency;using Microsoft.Bank.BankAccount;using Microsoft.Finance.GeneralLedger.Setup;using Microsoft.HumanResources.Employee;using Microsoft.HumanResources.Payables;using Microsoft.Purchases.Payables;using Microsoft.Purchases.Vendor;using Microsoft.Sales.Customer;using Microsoft.Sales.Receivables;/// <summary>/// Maintains a register of exchange rate adjustment runs for audit and tracking purposes./// Records details of each adjustment process including date ranges, account types processed,/// and statistical information about the adjustments performed./// </summary>/// <remarks>/// Linked to Exchange Rate Adjustment Ledger Entries for detailed transaction tracking./// Provides drill-down capabilities to view specific adjustments and supports/// audit trail requirements for currency revaluation procedures./// </remarks>table 86 "Exch. Rate Adjmt. Reg."{    Caption = 'Exch. Rate Adjmt. Reg.';    DrillDownPageId = "Exchange Rate Adjmt. Register";    LookupPageID = "Exchange Rate Adjmt. Register";    DataClassification = CustomerContent;    fields    {        field(1; "No."; Integer)        {            Caption = 'No.';            ToolTip = 'Specifies the number of the involved entry or record, according to the specified number series.';        }        field(2; "Creation Date"; Date)        {            Caption = 'Creation Date';            ToolTip = 'Specifies the posting date for the exchange rate adjustment register.';        }        field(3; "Account Type"; Enum "Exch. Rate Adjmt. Account Type")        {            Caption = 'Account Type';            ToolTip = 'Specifies the account type that was adjusted for exchange rate fluctuations when you ran the Adjust Exchange Rates batch job.';        }        field(4; "Posting Group"; Code[20])        {            Caption = 'Posting Group';            ToolTip = 'Specifies the posting group of the exchange rate adjustment register on this line.';            TableRelation = 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";        }        field(5; "Currency Code"; Code[10])        {            Caption = 'Currency Code';            ToolTip = 'Specifies the code for the currency whose exchange rate was adjusted.';            TableRelation = Currency;        }        field(6; "Currency Factor"; Decimal)        {            AutoFormatType = 0;            Caption = 'Currency Factor';            DecimalPlaces = 0 : 15;            MinValue = 0;        }        field(7; "Adjusted Base"; Decimal)        {            AutoFormatExpression = Rec."Currency Code";            AutoFormatType = 1;            Caption = 'Adjusted Base';            ToolTip = 'Specifies the amount that was adjusted by the batch job for customer, vendor and/or bank ledger entries.';        }        field(8; "Adjusted Base (LCY)"; Decimal)        {            AutoFormatExpression = '';            AutoFormatType = 1;            Caption = 'Adjusted Base (LCY)';        }        field(9; "Adjusted Amt. (LCY)"; Decimal)        {            AutoFormatExpression = '';            AutoFormatType = 1;            Caption = 'Adjusted Amt. (LCY)';        }        field(10; "Adjusted Base (Add.-Curr.)"; Decimal)        {            AccessByPermission = TableData Currency = R;            AutoFormatExpression = GetCurrencyCodeFromGLSetup();            AutoFormatType = 1;            Caption = 'Adjusted Base (Add.-Curr.)';        }        field(11; "Adjusted Amt. (Add.-Curr.)"; Decimal)        {            AccessByPermission = TableData Currency = R;            AutoFormatExpression = GetCurrencyCodeFromGLSetup();            AutoFormatType = 1;            Caption = 'Adjusted Amt. (Add.-Curr.)';        }        field(14; "Journal Template Name"; Code[10])        {            Caption = 'Journal Template Name';        }        field(15; "Journal Batch Name"; Code[10])        {            Caption = 'Journal Batch Name';        }        field(21; "Adjusted Customers"; Integer)        {            Caption = 'No. of Adj. Cust. Ledger Entries';            ToolTip = 'Specifies the number of customer ledger entries with remaining amount that was adjusted.';            CalcFormula = count("Detailed Cust. Ledg. Entry" where("Exch. Rate Adjmt. Reg. No." = field("No.")));            Editable = false;            FieldClass = FlowField;        }        field(22; "Adjusted Vendors"; Integer)        {            Caption = 'No. of Adj. Vend. Ledger Entries';            ToolTip = 'Specifies the number of vendor ledger entries with remaining amount that was adjusted.';            CalcFormula = count("Detailed Vendor Ledg. Entry" where("Exch. Rate Adjmt. Reg. No." = field("No.")));            Editable = false;            FieldClass = FlowField;        }        field(23; "Adjustment Amount"; Decimal)        {            AutoFormatExpression = '';            AutoFormatType = 1;            Caption = 'Adjustment Amount';            ToolTip = 'Specifies the total adjustment amount of exchange rate adjustment ledger entries.';            CalcFormula = sum("Exch. Rate Adjmt. Ledg. Entry"."Adjustment Amount" where("Register No." = field("No.")));            Editable = false;            FieldClass = FlowField;        }        field(24; "Adjusted Employees"; Integer)        {            Caption = 'No. of Adj. Empl. Ledger Entries';            ToolTip = 'Specifies the number of emplooyee ledger entries with remaining amount that was adjusted.';            CalcFormula = count("Detailed Employee Ledger Entry" where("Exch. Rate Adjmt. Reg. No." = field("No.")));            Editable = false;            FieldClass = FlowField;        }    }    keys    {        key(Key1; "No.")        {            Clustered = true;        }    }    fieldgroups    {    }    trigger OnDelete()    var        ExchRateAdjmtLedgEntry: Record "Exch. Rate Adjmt. Ledg. Entry";    begin        ExchRateAdjmtLedgEntry.SetRange("Register No.", "No.");        ExchRateAdjmtLedgEntry.DeleteAll();    end;    local procedure GetCurrencyCodeFromGLSetup(): Code[10]    var        GLSetup: Record "General Ledger Setup";    begin        GLSetup.Get();        exit(GLSetup."Additional Reporting Currency");    end;}