Codeunit 5642 FA Reclass. Transfer Line

Base Application, Microsoft.FixedAssets.Journal

src/Layers/W1/BaseApp/FixedAssets/FixedAsset/FAReclassTransferLine.Codeunit.al498 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.Journal;using Microsoft.Finance.GeneralLedger.Journal;using Microsoft.FixedAssets.Depreciation;using Microsoft.FixedAssets.FixedAsset;using Microsoft.FixedAssets.Ledger;using Microsoft.Foundation.Period;codeunit 5642 "FA Reclass. Transfer Line"{    trigger OnRun()    begin    end;    var        FAJnlSetup: Record "FA Journal Setup";        OldFA: Record "Fixed Asset";        NewFA: Record "Fixed Asset";        FADeprBook: Record "FA Depreciation Book";        FADeprBook2: Record "FA Depreciation Book";        GenJnlLine: Record "Gen. Journal Line";        FAJnlLine: Record "FA Journal Line";        DepreciationCalc: Codeunit "Depreciation Calculation";        FAGetJnl: Codeunit "FA Get Journal";        FAPostingType: Enum "FA Journal Line FA Posting Type";        TransferToGenJnl: Boolean;        TemplateName: Code[10];        BatchName: Code[10];        FANo: Code[20];        TransferType: array[9] of Boolean;        Amounts: array[9] of Decimal;        FAJnlNextLineNo: Integer;        GenJnlNextLineNo: Integer;        i: Integer;        j: Integer;        OldNewFA: Integer;        Sign: Integer;        GenJnlUsedOnce: Boolean;        FAJnlUsedOnce: Boolean;        FAJnlDocumentNo: Code[20];        GenJnlDocumentNo: Code[20];#pragma warning disable AA0074#pragma warning disable AA0470        Text000: Label 'is a %1 and %2 is not a %1.';        Text001: Label 'is not different than %1.';        Text002: Label '%1 is disposed.';        Text003: Label '%2 = 0 for %1.';        Text004: Label '%2 is greater than %3 for %1.';        Text005: Label 'It was not possible to find a %1 in %2.';        Text006: Label '%1 must be %2 or %3 for %4.';        Text007: Label '%1 must be %2 for %3.';        Text008: Label 'must not be used together with %1 in %2 %3.';        Text009: Label '%1 cannot be calculated for %2.';#pragma warning restore AA0470#pragma warning restore AA0074    procedure FAReclassLine(var FAReclassJnlLine: Record "FA Reclass. Journal Line"; var Done: Boolean)    var        IsHandled: Boolean;        SkipTestFieldInactive: Boolean;    begin        IsHandled := false;        SkipTestFieldInactive := false;        OnBeforeFAReclassLine(FAReclassJnlLine, Done, IsHandled, SkipTestFieldInactive);        if IsHandled then            exit;        if (FAReclassJnlLine."FA No." = '') and (FAReclassJnlLine."New FA No." = '') then            exit;        OldFA.Get(FAReclassJnlLine."FA No.");        NewFA.Get(FAReclassJnlLine."New FA No.");        FADeprBook.Get(FAReclassJnlLine."FA No.", FAReclassJnlLine."Depreciation Book Code");        FADeprBook2.Get(FAReclassJnlLine."New FA No.", FAReclassJnlLine."Depreciation Book Code");        OldFA.TestField(Blocked, false);        NewFA.TestField(Blocked, false);        if not SkipTestFieldInactive then begin            OldFA.TestField(Inactive, false);            NewFA.TestField(Inactive, false);        end;        if OldFA."Budgeted Asset" and not NewFA."Budgeted Asset" then            FAReclassJnlLine.FieldError(              "FA No.", StrSubstNo(Text000,                OldFA.FieldCaption("Budgeted Asset"), FAReclassJnlLine.FieldCaption("New FA No.")));        if NewFA."Budgeted Asset" and not OldFA."Budgeted Asset" then            FAReclassJnlLine.FieldError(              "New FA No.", StrSubstNo(Text000,                NewFA.FieldCaption("Budgeted Asset"), FAReclassJnlLine.FieldCaption("FA No.")));        if FAReclassJnlLine."FA No." = FAReclassJnlLine."New FA No." then            FAReclassJnlLine.FieldError(              "FA No.", StrSubstNo(Text001, FAReclassJnlLine.FieldCaption("New FA No.")));        if FADeprBook."Disposal Date" > 0D then            Error(Text002, FAName(OldFA, FAReclassJnlLine."Depreciation Book Code"));        if FADeprBook2."Disposal Date" > 0D then            Error(Text002, FAName(NewFA, FAReclassJnlLine."Depreciation Book Code"));        SetFAReclassType(FAReclassJnlLine);        CalcAmounts(FAReclassJnlLine);        CalcDB1DeprAmount(FAReclassJnlLine);        for OldNewFA := 0 to 1 do begin            j := 0;            while j < 9 do begin                j := j + 1;                if j = 7 then                    j := 9;                Convert(OldNewFA, j, FAPostingType, Sign, FANo);                if FAPostingType = FAPostingType::Derogatory then                    i := 7                else                    i := FAPostingType.AsInteger() + 1;                TemplateName := '';                BatchName := '';                if TransferType[i] and (Amounts[i] <> 0) then begin                    FAGetJnl.JnlName(                      FAReclassJnlLine."Depreciation Book Code", OldFA."Budgeted Asset", FAPostingType,                      TransferToGenJnl, TemplateName, BatchName);                    SetJnlRange();                    if TransferToGenJnl then                        InsertGenJnlLine(FAReclassJnlLine, FANo, Sign * Amounts[i], FAReclassJnlLine."Insert Bal. Account")                    else                        InsertFAJnlLine(FAReclassJnlLine, FANo, Sign * Amounts[i]);                    Done := true;                end;            end;        end;    end;    local procedure CalcAmounts(var FAReclassJnlLine: Record "FA Reclass. Journal Line")    var        IsHandled: Boolean;    begin        IsHandled := false;        OnBeforeCalcAmounts(FAReclassJnlLine, Amounts, IsHandled);        if IsHandled then            exit;        FADeprBook.CalcFields("Acquisition Cost");        if TransferType[2] then            FADeprBook.CalcFields(Depreciation);        if TransferType[3] then            FADeprBook.CalcFields("Write-Down");        if TransferType[4] then            FADeprBook.CalcFields(Appreciation);        if TransferType[5] then            FADeprBook.CalcFields("Custom 1");        if TransferType[6] then            FADeprBook.CalcFields("Custom 2");        if TransferType[7] then            FADeprBook.CalcFields("Derogatory Amount");        if TransferType[9] then            FADeprBook.CalcFields("Salvage Value");        Amounts[1] := FADeprBook."Acquisition Cost";        Amounts[2] := FADeprBook.Depreciation;        Amounts[3] := FADeprBook."Write-Down";        Amounts[4] := FADeprBook.Appreciation;        Amounts[5] := FADeprBook."Custom 1";        Amounts[6] := FADeprBook."Custom 2";        Amounts[7] := FADeprBook."Derogatory Amount";        Amounts[9] := FADeprBook."Salvage Value";        OnCalcAmountsOnAfterSetAmounts(FADeprBook, Amounts, TransferType);        if Amounts[1] = 0 then            Error(Text003,              FAName(OldFA, FADeprBook."Depreciation Book Code"), FADeprBook.FieldCaption("Acquisition Cost"));        if FAReclassJnlLine."Reclassify Acq. Cost Amount" <> 0 then begin            if FAReclassJnlLine."Reclassify Acq. Cost Amount" > Amounts[1] then                Error(Text004,                  FAName(OldFA, FAReclassJnlLine."Depreciation Book Code"),                  FAReclassJnlLine.FieldCaption("Reclassify Acq. Cost Amount"),                  FADeprBook.FieldCaption("Acquisition Cost"));            FAReclassJnlLine."Reclassify Acq. Cost %" := FAReclassJnlLine."Reclassify Acq. Cost Amount" / Amounts[1] * 100;        end;        if FAReclassJnlLine."Reclassify Acq. Cost Amount" <> 0 then            Amounts[1] := FAReclassJnlLine."Reclassify Acq. Cost Amount"        else            Amounts[1] := Round(Amounts[1] * FAReclassJnlLine."Reclassify Acq. Cost %" / 100);        for i := 2 to 9 do            Amounts[i] := Round(Amounts[i] * FAReclassJnlLine."Reclassify Acq. Cost %" / 100);    end;    local procedure SetFAReclassType(var FAReclassJnlLine: Record "FA Reclass. Journal Line")    begin        TransferType[1] := FAReclassJnlLine."Reclassify Acquisition Cost";        TransferType[2] := FAReclassJnlLine."Reclassify Depreciation";        TransferType[3] := FAReclassJnlLine."Reclassify Write-Down";        TransferType[4] := FAReclassJnlLine."Reclassify Appreciation";        TransferType[5] := FAReclassJnlLine."Reclassify Custom 1";        TransferType[6] := FAReclassJnlLine."Reclassify Custom 2";        TransferType[7] := FAReclassJnlLine."Reclass. Derogatory";        TransferType[9] := FAReclassJnlLine."Reclassify Salvage Value";    end;    local procedure SetJnlRange()    begin        if (FAJnlNextLineNo = 0) and not TransferToGenJnl then begin            FAJnlLine.LockTable();            FAGetJnl.SetFAJnlRange(FAJnlLine, TemplateName, BatchName);            FAJnlNextLineNo := FAJnlLine."Line No.";        end;        if (GenJnlNextLineNo = 0) and TransferToGenJnl then begin            GenJnlLine.LockTable();            FAGetJnl.SetGenJnlRange(GenJnlLine, TemplateName, BatchName);            GenJnlNextLineNo := GenJnlLine."Line No.";        end;    end;    local procedure Convert(OldNewFA: Option OldFA,NewFA; J: Integer; var FAPostingType: Enum "FA Journal Line FA Posting Type"; var Sign: Integer; var FANo: Code[20])    begin        if OldNewFA = OldNewFA::OldFA then begin            Sign := -1;            FANo := OldFA."No.";        end else begin            Sign := 1;            FANo := NewFA."No.";        end;        if OldNewFA = OldNewFA::OldFA then            case J of                1:                    FAPostingType := FAPostingType::"Salvage Value";                2:                    FAPostingType := FAPostingType::Depreciation;                3:                    FAPostingType := FAPostingType::"Write-Down";                4:                    FAPostingType := FAPostingType::"Custom 1";                5:                    FAPostingType := FAPostingType::"Custom 2";                6:                    FAPostingType := FAPostingType::Appreciation;                7:                    FAPostingType := FAPostingType::Derogatory;                9:                    FAPostingType := FAPostingType::"Acquisition Cost";            end;        if OldNewFA = OldNewFA::NewFA then            case J of                1:                    FAPostingType := FAPostingType::"Acquisition Cost";                2:                    FAPostingType := FAPostingType::"Salvage Value";                3:                    FAPostingType := FAPostingType::Appreciation;                4:                    FAPostingType := FAPostingType::"Write-Down";                5:                    FAPostingType := FAPostingType::"Custom 1";                6:                    FAPostingType := FAPostingType::"Custom 2";                7:                    FAPostingType := FAPostingType::Derogatory;                9:                    FAPostingType := FAPostingType::Depreciation;            end;    end;    local procedure InsertFAJnlLine(var FAReclassJnlLine: Record "FA Reclass. Journal Line"; FANo: Code[20]; EntryAmount: Decimal)    begin        if not FAJnlUsedOnce then begin            ;            FAJnlUsedOnce := true;            FAJnlDocumentNo :=              FAJnlSetup.GetFAJnlDocumentNo(FAJnlLine, FAReclassJnlLine."FA Posting Date", false);        end;        FAJnlLine.Init();        FAJnlLine."Line No." := 0;        FAJnlSetup.SetFAJnlTrailCodes(FAJnlLine);        FAJnlLine."FA Posting Type" := FAPostingType;        FAJnlLine.Validate("FA No.", FANo);        FAJnlLine."FA Posting Date" := FAReclassJnlLine."FA Posting Date";        FAJnlLine."Posting Date" := FAReclassJnlLine."Posting Date";        if FAJnlLine."Posting Date" = FAJnlLine."FA Posting Date" then            FAJnlLine."Posting Date" := 0D;        FAJnlLine."Document No." := FAReclassJnlLine."Document No.";        if FAJnlLine."Document No." = '' then            FAJnlLine."Document No." := FAJnlDocumentNo;        if FAJnlLine."Document No." = '' then            FAReclassJnlLine.TestField("Document No.");        FAJnlLine."Posting No. Series" := FAJnlSetup.GetFANoSeries(FAJnlLine);        FAJnlLine.Validate("Depreciation Book Code", FAReclassJnlLine."Depreciation Book Code");        if FAJnlLine."FA Posting Type" = FAJnlLine."FA Posting Type"::Depreciation then            EntryAmount := DepreciationCalc.CalcRounding(FAReclassJnlLine."Depreciation Book Code", EntryAmount);        FAJnlLine.Validate(Amount, EntryAmount);        FAJnlLine.Description := FAReclassJnlLine.Description;        FAJnlLine."FA Reclassification Entry" := true;        FAJnlNextLineNo := FAJnlNextLineNo + 10000;        FAJnlLine."Line No." := FAJnlNextLineNo;        OnBeforeFAJnlLineInsert(FAJnlLine, FAReclassJnlLine, Sign);        FAJnlLine.Insert(true);    end;    local procedure InsertGenJnlLine(var FAReclassJnlLine: Record "FA Reclass. Journal Line"; FANo: Code[20]; EntryAmount: Decimal; BalAccount: Boolean)    var        DepCalc: Codeunit "Depreciation Calculation";        FAInsertGLAcc: Codeunit "FA Insert G/L Account";    begin        if not GenJnlUsedOnce then begin            ;            GenJnlUsedOnce := true;            GenJnlDocumentNo :=              FAJnlSetup.GetGenJnlDocumentNo(GenJnlLine, FAReclassJnlLine."FA Posting Date", false);        end;        GenJnlLine.Init();        GenJnlLine."Line No." := 0;        FAJnlSetup.SetGenJnlTrailCodes(GenJnlLine);        GenJnlLine."Account Type" := GenJnlLine."Account Type"::"Fixed Asset";        if FAPostingType = FAPostingType::"Bonus Depreciation" then            GenJnlLine."FA Posting Type" := GenJnlLine."FA Posting Type"::"Bonus Depreciation"        else            GenJnlLine."FA Posting Type" := Enum::"Gen. Journal Line FA Posting Type".FromInteger(FAPostingType.AsInteger() + 1);        GenJnlLine.Validate("Account No.", FANo);        GenJnlLine.Validate("Depreciation Book Code", FAReclassJnlLine."Depreciation Book Code");        GenJnlLine."FA Posting Date" := FAReclassJnlLine."FA Posting Date";        GenJnlLine."Posting Date" := FAReclassJnlLine."Posting Date";        if GenJnlLine."Posting Date" = 0D then            GenJnlLine."Posting Date" := FAReclassJnlLine."FA Posting Date";        if GenJnlLine."Posting Date" = GenJnlLine."FA Posting Date" then            GenJnlLine."FA Posting Date" := 0D;        GenJnlLine."Document No." := FAReclassJnlLine."Document No.";        if GenJnlLine."Document No." = '' then            GenJnlLine."Document No." := GenJnlDocumentNo;        if GenJnlLine."Document No." = '' then            FAReclassJnlLine.TestField("Document No.");        GenJnlLine."Posting No. Series" := FAJnlSetup.GetGenNoSeries(GenJnlLine);        if GenJnlLine."FA Posting Type" = GenJnlLine."FA Posting Type"::Depreciation then            EntryAmount := DepCalc.CalcRounding(FAReclassJnlLine."Depreciation Book Code", EntryAmount);        GenJnlLine.Validate(Amount, EntryAmount);        GenJnlLine.Description := FAReclassJnlLine.Description;        GenJnlLine."FA Reclassification Entry" := true;        GenJnlNextLineNo := GenJnlNextLineNo + 10000;        GenJnlLine."Line No." := GenJnlNextLineNo;        OnBeforeGenJnlLineInsert(GenJnlLine, FAReclassJnlLine, Sign);        GenJnlLine.Insert(true);        if BalAccount then begin            FAInsertGLAcc.GetBalAcc(GenJnlLine);            if GenJnlLine.Find('+') then;            GenJnlNextLineNo := GenJnlLine."Line No.";        end;    end;    local procedure FAName(var FA: Record "Fixed Asset"; DeprBookCode: Code[10]): Text[200]    begin        exit(DepreciationCalc.FAName(FA, DeprBookCode));    end;    local procedure CalcDB1DeprAmount(FAReclassJnlLine: Record "FA Reclass. Journal Line")    var        AccountingPeriod: Record "Accounting Period";        DeprBook: Record "Depreciation Book";        CalculateDepr: Codeunit "Calculate Depreciation";        DeprAmount: Decimal;        DeprAmount2: Decimal;        Custom1Amount: Decimal;        NumberOfDays: Integer;        NumberOfDays2: Integer;        Custom1NumberOfDays: Integer;        DeprUntilDate: Date;        DummyEntryAmounts: array[4] of Decimal;        FixedAmount: Decimal;        FixedAmount2: Decimal;        DaysInFiscalYear: Integer;        IsHandled: Boolean;    begin        if not FAReclassJnlLine."Calc. DB1 Depr. Amount" then            exit;        DeprBook.Get(FAReclassJnlLine."Depreciation Book Code");        DeprBook.TestField("Use Custom 1 Depreciation", false); // better        if (FADeprBook."Depreciation Method" <> FADeprBook."Depreciation Method"::"DB1/SL") and           (FADeprBook."Depreciation Method" <> FADeprBook."Depreciation Method"::"Declining-Balance 1")        then begin            FADeprBook."Depreciation Method" := FADeprBook."Depreciation Method"::"Declining-Balance 1";            FADeprBook2."Depreciation Method" := FADeprBook."Depreciation Method"::"DB1/SL";            Error(Text006,              FADeprBook.FieldCaption("Depreciation Method"),              FADeprBook."Depreciation Method",              FADeprBook2."Depreciation Method",              FAName(OldFA, FAReclassJnlLine."Depreciation Book Code"));        end;        if FADeprBook."Depreciation Method" <> FADeprBook2."Depreciation Method" then            Error(Text007,              FADeprBook.FieldCaption("Depreciation Method"),              FADeprBook."Depreciation Method",              FAName(NewFA, FAReclassJnlLine."Depreciation Book Code"));        if DeprBook."Use Custom 1 Depreciation" then            FAReclassJnlLine.FieldError("Calc. DB1 Depr. Amount",              StrSubstNo(                Text008,                DeprBook.FieldCaption("Use Custom 1 Depreciation"),                DeprBook.TableCaption(),                DeprBook.Code));        FADeprBook.TestField("Temp. Ending Date", 0D);        FADeprBook2.TestField("Temp. Ending Date", 0D);        IsHandled := false;        OnCalcDB1DeprAmountOnBeforeGetAccountingPeriod(FAReclassJnlLine, DeprUntilDate, IsHandled);        if not IsHandled then            if AccountingPeriod.IsEmpty() then                DeprUntilDate := CalcDate('<-CY>', FAReclassJnlLine."FA Posting Date") - 1            else begin                AccountingPeriod.SetRange("New Fiscal Year", true);                AccountingPeriod.SetRange("Starting Date", FAReclassJnlLine."FA Posting Date", DMY2Date(31, 12, 9999));                if AccountingPeriod.FindFirst() then begin                    if AccountingPeriod."Starting Date" <= 00000101D then                        Error(Text005, AccountingPeriod.FieldCaption("Starting Date"), AccountingPeriod.TableCaption);                    DeprUntilDate := AccountingPeriod."Starting Date" - 1                end else                    Error(Text005, AccountingPeriod.FieldCaption("Starting Date"), AccountingPeriod.TableCaption);            end;        CalculateDepr.Calculate(          DeprAmount, Custom1Amount, NumberOfDays, Custom1NumberOfDays,          FAReclassJnlLine."FA No.", FAReclassJnlLine."Depreciation Book Code",          DeprUntilDate, DummyEntryAmounts, 0D, 0);        if (DeprAmount >= 0) or (NumberOfDays <= 0) then            Error(Text009,              FADeprBook.FieldCaption("Temp. Fixed Depr. Amount"),              FAName(OldFA, FAReclassJnlLine."Depreciation Book Code"));        CalculateDepr.Calculate(          DeprAmount2, Custom1Amount, NumberOfDays2, Custom1NumberOfDays,          FAReclassJnlLine."New FA No.", FAReclassJnlLine."Depreciation Book Code",          DeprUntilDate, DummyEntryAmounts, 0D, 0);        DaysInFiscalYear := DeprBook."No. of Days in Fiscal Year";        if DaysInFiscalYear = 0 then            DaysInFiscalYear := 360;        if DeprBook."Fiscal Year 365 Days" then            DaysInFiscalYear := 365;        FixedAmount := Round(-DeprAmount / NumberOfDays * DaysInFiscalYear);        if NumberOfDays2 > 0 then            FixedAmount2 := Round(-DeprAmount2 / NumberOfDays2 * DaysInFiscalYear);        FADeprBook."Temp. Fixed Depr. Amount" :=          Round(FixedAmount * (100 - FAReclassJnlLine."Reclassify Acq. Cost %") / 100);        FADeprBook."Temp. Ending Date" := DeprUntilDate;        FADeprBook.Modify();        FADeprBook2."Temp. Fixed Depr. Amount" :=          Round(FixedAmount2 + FixedAmount - FADeprBook."Temp. Fixed Depr. Amount");        FADeprBook2."Temp. Ending Date" := FADeprBook."Temp. Ending Date";        FADeprBook2.Modify();    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeGenJnlLineInsert(var GenJournalLine: Record "Gen. Journal Line"; var FAReclassJournalLine: Record "FA Reclass. Journal Line"; Sign: Integer)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeFAJnlLineInsert(var FAJournalLine: Record "FA Journal Line"; var FAReclassJournalLine: Record "FA Reclass. Journal Line"; Sign: Integer)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeCalcAmounts(FAReclassJnlLine: Record "FA Reclass. Journal Line"; var Amounts: array[9] of Decimal; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeFAReclassLine(var FAReclassJnlLine: Record "FA Reclass. Journal Line"; var Done: Boolean; var IsHandled: Boolean; var SkipTestFieldInactive: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnCalcAmountsOnAfterSetAmounts(FADepreciationBook: Record "FA Depreciation Book"; var Amounts: array[9] of Decimal; TransferType: array[9] of Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnCalcDB1DeprAmountOnBeforeGetAccountingPeriod(FAReclassJnlLine: Record "FA Reclass. Journal Line"; var DeprUntilDate: Date; var IsHandled: Boolean)    begin    end;}