Codeunit 5615 Budget Depreciation

Base Application, Microsoft.FixedAssets.Depreciation

src/Layers/W1/BaseApp/FixedAssets/Depreciation/BudgetDepreciation.Codeunit.al214 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.Depreciation;using Microsoft.Finance.Dimension;using Microsoft.Finance.GeneralLedger.Budget;using Microsoft.FixedAssets.FixedAsset;using Microsoft.FixedAssets.Journal;using Microsoft.FixedAssets.Ledger;codeunit 5615 "Budget Depreciation"{    trigger OnRun()    begin    end;    var#pragma warning disable AA0074#pragma warning disable AA0470        Text000: Label 'In a budget report, %1 must be %2 in %3.';        Text001: Label 'Budget calculation has not been done on fixed assets with %1 %2, %3 or %4.';#pragma warning restore AA0470#pragma warning restore AA0074        NoOfErrors: Integer;        CallNo: Integer;    procedure Calculate(FANo: Code[20]; EndingDate1: Date; EndingDate2: Date; DeprBookCode: Code[10]; var DeprAmount1: Decimal; var DeprAmount2: Decimal)    var        DeprBook: Record "Depreciation Book";        FADeprBook: Record "FA Depreciation Book";        CalculateNormalDepr: Codeunit "Calculate Normal Depreciation";        NumberOfDays: Integer;        DummyEntryAmounts: array[4] of Decimal;        IsHandled: Boolean;    begin        DeprAmount1 := 0;        DeprAmount2 := 0;        if CallNo = 0 then begin            CallNo := 1;            DeprBook.Get(DeprBookCode);            if DeprBook."Use Custom 1 Depreciation" then                Error(                  Text000,                  DeprBook.FieldCaption("Use Custom 1 Depreciation"), false, DeprBook.TableCaption());        end;        IsHandled := false;        OnCalculateOnAfterCallNoCheck(FANo, EndingDate1, EndingDate2, DeprBookCode, DeprAmount1, DeprAmount2, IsHandled);        if IsHandled then            exit;        if not FADeprBook.Get(FANo, DeprBookCode) then            exit;        case FADeprBook."Depreciation Method" of            FADeprBook."Depreciation Method"::"Declining-Balance 1",            FADeprBook."Depreciation Method"::"DB1/SL",            FADeprBook."Depreciation Method"::"DB2/SL":                if NoOfErrors = 0 then begin                    CreateMessage();                    NoOfErrors := 1;                end;            else begin                if EndingDate1 > 0D then                    CalculateNormalDepr.Calculate(                      DeprAmount1, NumberOfDays, FANo, DeprBookCode, EndingDate1, DummyEntryAmounts, 0D, 0);                if EndingDate2 > 0D then                    CalculateNormalDepr.Calculate(                      DeprAmount2, NumberOfDays, FANo, DeprBookCode, EndingDate2, DummyEntryAmounts, 0D, 0);            end;        end;    end;    local procedure CreateMessage()    var        FADeprBook2: Record "FA Depreciation Book";        FADeprBook3: Record "FA Depreciation Book";        FADeprBook4: Record "FA Depreciation Book";    begin        FADeprBook2."Depreciation Method" := FADeprBook2."Depreciation Method"::"Declining-Balance 1";        FADeprBook3."Depreciation Method" := FADeprBook3."Depreciation Method"::"DB1/SL";        FADeprBook4."Depreciation Method" := FADeprBook4."Depreciation Method"::"DB2/SL";        Message(          Text001,          FADeprBook2.FieldCaption("Depreciation Method"),          FADeprBook2."Depreciation Method",          FADeprBook3."Depreciation Method",          FADeprBook4."Depreciation Method");    end;    procedure CopyProjectedValueToBudget(FADeprBook: Record "FA Depreciation Book"; BudgetNameCode: Code[10]; PostingDate: Date; DeprAmount: Decimal; Custom1Amount: Decimal; BalAccount: Boolean)    var        FA: Record "Fixed Asset";        FALedgEntry: Record "FA Ledger Entry";        BudgetText: Text[150];    begin        FADeprBook.TestField("FA Posting Group");        FALedgEntry."FA No." := FADeprBook."FA No.";        FALedgEntry."Depreciation Book Code" := FADeprBook."Depreciation Book Code";        FALedgEntry."FA Posting Group" := FADeprBook."FA Posting Group";        FALedgEntry."Posting Date" := PostingDate;        FALedgEntry."FA Posting Date" := PostingDate;        FALedgEntry."FA Posting Type" := FALedgEntry."FA Posting Type"::Depreciation;        FALedgEntry.Amount := DeprAmount;        BudgetText :=          StrSubstNo('%1 %2: %3', FA.TableCaption(), FADeprBook."FA No.", FALedgEntry."FA Posting Type");        if FALedgEntry.Amount <> 0 then            CopyFAToBudget(FALedgEntry, BudgetNameCode, BalAccount, BudgetText);        FALedgEntry."FA Posting Type" := FALedgEntry."FA Posting Type"::"Custom 1";        FALedgEntry.Amount := Custom1Amount;        BudgetText :=          StrSubstNo('%1 %2: %3', FA.TableCaption(), FADeprBook."FA No.", FALedgEntry."FA Posting Type");        if FALedgEntry.Amount <> 0 then            CopyFAToBudget(FALedgEntry, BudgetNameCode, BalAccount, BudgetText);    end;    procedure CopyFAToBudget(FALedgEntry: Record "FA Ledger Entry"; BudgetNameCode: Code[10]; BalAccount: Boolean; BudgetText: Text[150])    var        BudgetName: Record "G/L Budget Name";        GLBudgetEntry: Record "G/L Budget Entry";        FAGLPostBuf: Record "FA G/L Posting Buffer";        FAInsertGLAcc: Codeunit "FA Insert G/L Account";        NextEntryNo: Integer;    begin        GLBudgetEntry.LockTable();        BudgetName.LockTable();        BudgetName.Get(BudgetNameCode);        BudgetName.TestField(Blocked, false);        NextEntryNo := GLBudgetEntry.GetLastEntryNo() + 1;        GLBudgetEntry.Init();        GLBudgetEntry."Budget Name" := BudgetNameCode;        FALedgEntry."G/L Entry No." := NextEntryNo;        FAInsertGLAcc.DeleteAllGLAcc();        FAInsertGLAcc.Run(FALedgEntry);        if BalAccount then            FAInsertGLAcc.InsertBalAcc(FALedgEntry);        if FAInsertGLAcc.FindFirstGLAcc(FAGLPostBuf) then            repeat                GLBudgetEntry."Entry No." := FAGLPostBuf."Entry No.";                GLBudgetEntry."G/L Account No." := FAGLPostBuf."Account No.";                GLBudgetEntry.Amount := FAGLPostBuf.Amount;                GLBudgetEntry.Date := FALedgEntry."Posting Date";                GLBudgetEntry.Description := FALedgEntry.Description;                if BudgetText <> '' then                    GLBudgetEntry.Description := CopyStr(BudgetText, 1, MaxStrLen(GLBudgetEntry.Description));                GLBudgetEntry."User ID" := CopyStr(UserId(), 1, MaxStrLen(GLBudgetEntry."User ID"));                if FAGLPostBuf."FA Posting Group" <> '' then                    GLBudgetEntry."Dimension Set ID" := FAGLPostBuf."Dimension Set ID"                else                    GLBudgetEntry."Dimension Set ID" := GetFADefaultDimSetID(FALedgEntry);                UpdateDimCodesFromDimSetID(GLBudgetEntry, BudgetName);                OnBeforeGLBudgetEntryInsert(GLBudgetEntry, FALedgEntry, FAGLPostBuf, BudgetName);                GLBudgetEntry.Insert();            until FAInsertGLAcc.GetNextGLAcc(FAGLPostBuf) = 0;    end;    local procedure GetFADefaultDimSetID(var FALedgerEntry: Record "FA Ledger Entry"): Integer    var        DefaultDim: Record "Default Dimension";        TempDimSetEntry: Record "Dimension Set Entry" temporary;        DimVal: Record "Dimension Value";        DimMgt: Codeunit DimensionManagement;    begin        DefaultDim.SetRange("Table ID", DATABASE::"Fixed Asset");        DefaultDim.SetRange("No.", FALedgerEntry."FA No.");        if DefaultDim.FindSet() then            repeat                DimVal.Get(DefaultDim."Dimension Code", DefaultDim."Dimension Value Code");                TempDimSetEntry."Dimension Code" := DimVal."Dimension Code";                TempDimSetEntry."Dimension Value Code" := DimVal.Code;                TempDimSetEntry."Dimension Value ID" := DimVal."Dimension Value ID";                TempDimSetEntry.Insert();            until DefaultDim.Next() = 0;        exit(DimMgt.GetDimensionSetID(TempDimSetEntry));    end;    local procedure UpdateDimCodesFromDimSetID(var GLBudgetEntry: Record "G/L Budget Entry"; GLBudgetName: Record "G/L Budget Name")    var        DimMgt: Codeunit DimensionManagement;    begin        DimMgt.UpdateGlobalDimFromDimSetID(GLBudgetEntry."Dimension Set ID", GLBudgetEntry."Global Dimension 1 Code", GLBudgetEntry."Global Dimension 2 Code");        UpdateBudgetDimFromDimSetID(GLBudgetEntry."Budget Dimension 1 Code", GLBudgetEntry."Dimension Set ID", GLBudgetName."Budget Dimension 1 Code");        UpdateBudgetDimFromDimSetID(GLBudgetEntry."Budget Dimension 2 Code", GLBudgetEntry."Dimension Set ID", GLBudgetName."Budget Dimension 2 Code");        UpdateBudgetDimFromDimSetID(GLBudgetEntry."Budget Dimension 3 Code", GLBudgetEntry."Dimension Set ID", GLBudgetName."Budget Dimension 3 Code");        UpdateBudgetDimFromDimSetID(GLBudgetEntry."Budget Dimension 4 Code", GLBudgetEntry."Dimension Set ID", GLBudgetName."Budget Dimension 4 Code");    end;    local procedure UpdateBudgetDimFromDimSetID(var BudgetDimensionValue: Code[20]; DimSetID: Integer; BudgetDimensionCode: Code[20])    var        DimensionSetEntry: Record "Dimension Set Entry";    begin        if DimensionSetEntry.Get(DimSetID, BudgetDimensionCode) then            BudgetDimensionValue := DimensionSetEntry."Dimension Value Code";    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeGLBudgetEntryInsert(var GLBudgetEntry: Record "G/L Budget Entry"; var FALedgerEntry: Record "FA Ledger Entry"; var FAGLPostingBuffer: Record "FA G/L Posting Buffer"; var GLBudgetName: Record "G/L Budget Name")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnCalculateOnAfterCallNoCheck(FANo: Code[20]; EndingDate1: Date; EndingDate2: Date; DeprBookCode: Code[10]; var DeprAmount1: Decimal; var DeprAmount2: Decimal; var IsHandled: Boolean);    begin    end;}