Codeunit 123 Calc. Running FA Balance

Base Application, Microsoft.FixedAssets.Ledger

src/Layers/W1/BaseApp/FixedAssets/FixedAsset/CalcRunningFABalance.codeunit.al65 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.FixedAssets.Ledger;codeunit 123 "Calc. Running FA Balance"{    InherentPermissions = X;    var        FALedgerEntry2: Record "FA Ledger Entry";        ClientTypeManagement: Codeunit System.Environment."Client Type Management";        DayTotals: Dictionary of [Date, Decimal];        EntryValues: Dictionary of [Integer, Decimal];        PrevAccNo: Code[20];        PrevDebrBook: Code[10];    procedure GetFABalance(var FALedgerEntry: Record "FA Ledger Entry"): Decimal    var        RunningBalance: Decimal;    begin        CalcFABalance(FALedgerEntry, RunningBalance);        exit(RunningBalance);    end;    local procedure CalcFABalance(var FALedgerEntry: Record "FA Ledger Entry"; var RunningBalance: Decimal)    var        DateTotal: Decimal;    begin        if ClientTypeManagement.GetCurrentClientType() in [ClientType::OData, ClientType::ODataV4] then            exit;        if (PrevAccNo <> '') and (PrevAccNo <> FALedgerEntry."FA No.") or (PrevDebrBook <> '') and (PrevDebrBook <> FALedgerEntry."Depreciation Book Code") then            Clear(DayTotals);        PrevAccNo := FALedgerEntry."FA No.";        PrevDebrBook := FALedgerEntry."Depreciation Book Code";        if EntryValues.Get(FALedgerEntry."Entry No.", RunningBalance) then            exit;        FALedgerEntry2.Reset();        FALedgerEntry2.SetLoadFields("Entry No.", "FA No.", "Posting Date", Amount);        FALedgerEntry2.SetRange("FA No.", FALedgerEntry."FA No.");        FALedgerEntry2.SetRange("Depreciation Book Code", FALedgerEntry."Depreciation Book Code");        if not DayTotals.Get(FALedgerEntry."Posting Date", DateTotal) then begin            FALedgerEntry2.SetFilter("Posting Date", '<=%1', FALedgerEntry."Posting Date");            FALedgerEntry2.CalcSums(Amount);            DateTotal := FALedgerEntry2.Amount;            DayTotals.Add(FALedgerEntry."Posting Date", DateTotal);        end;        RunningBalance := DateTotal;        FALedgerEntry2.SetRange("Posting Date", FALedgerEntry."Posting Date");        FALedgerEntry2.SetCurrentKey("Entry No.");        FALedgerEntry2.Ascending(false);        if FALedgerEntry2.FindSet() then            repeat                if FALedgerEntry2."Entry No." = FALedgerEntry."Entry No." then                    RunningBalance := DateTotal;                if not EntryValues.ContainsKey(FALedgerEntry2."Entry No.") then                    EntryValues.Add(FALedgerEntry2."Entry No.", DateTotal);                DateTotal -= FALedgerEntry2.Amount;            until FALedgerEntry2.Next() = 0;    end;}