Codeunit 5623 FA MoveEntries

Base Application, Microsoft.FixedAssets.FixedAsset

src/Layers/W1/BaseApp/FixedAssets/FixedAsset/FAMoveEntries.Codeunit.al196 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.FixedAsset;using Microsoft.FixedAssets.Depreciation;using Microsoft.FixedAssets.Insurance;using Microsoft.FixedAssets.Ledger;using Microsoft.FixedAssets.Maintenance;using Microsoft.Foundation.Period;codeunit 5623 "FA MoveEntries"{    Permissions = TableData "FA Ledger Entry" = rm,                  TableData "Maintenance Ledger Entry" = rm,                  TableData "Ins. Coverage Ledger Entry" = rm;    trigger OnRun()    begin    end;    var        FA: Record "Fixed Asset";        FALedgEntry: Record "FA Ledger Entry";        MaintenanceLedgEntry: Record "Maintenance Ledger Entry";        InsCoverageLedgEntry: Record "Ins. Coverage Ledger Entry";        AccountingPeriod: Record "Accounting Period";        FiscalYearStartDate: Date;#pragma warning disable AA0074        Text000: Label 'Only disposed fixed assets can be deleted.';        Text001: Label 'You cannot delete a fixed asset that has ledger entries in a fiscal year that has not been closed yet.';#pragma warning disable AA0470        Text002: Label 'The field %1 cannot be changed for a fixed asset with ledger entries.';        Text003: Label 'The field %1 cannot be changed for a fixed asset with insurance coverage ledger entries.';#pragma warning restore AA0470#pragma warning restore AA0074    procedure MoveFAEntries(FADeprBook: Record "FA Depreciation Book")    begin        ClearAll();        FA.LockTable();        FALedgEntry.LockTable();        MaintenanceLedgEntry.LockTable();        InsCoverageLedgEntry.LockTable();        FA.Get(FADeprBook."FA No.");        AccountingPeriod.SetCurrentKey(Closed);        AccountingPeriod.SetRange(Closed, false);        if AccountingPeriod.FindFirst() then            FiscalYearStartDate := AccountingPeriod."Starting Date"        else            FiscalYearStartDate := 0D;        FALedgEntry.SetCurrentKey("FA No.", "Depreciation Book Code", "FA Posting Date");        MaintenanceLedgEntry.SetCurrentKey("FA No.", "Depreciation Book Code", "FA Posting Date");        FALedgEntry.SetRange("FA No.", FADeprBook."FA No.");        MaintenanceLedgEntry.SetRange("FA No.", FADeprBook."FA No.");        FALedgEntry.SetRange("Depreciation Book Code", FADeprBook."Depreciation Book Code");        MaintenanceLedgEntry.SetRange("Depreciation Book Code", FADeprBook."Depreciation Book Code");        if FA."Budgeted Asset" then            DeleteNo(FADeprBook)        else begin            if FALedgEntry.FindFirst() then                if FADeprBook."Disposal Date" = 0D then                    Error(Text000);            FALedgEntry.SetFilter("FA Posting Date", '>=%1', FiscalYearStartDate);            if FALedgEntry.FindFirst() then                CreateError(0);            MaintenanceLedgEntry.SetFilter("FA Posting Date", '>=%1', FiscalYearStartDate);            if MaintenanceLedgEntry.FindFirst() then                CreateError(0);            FALedgEntry.SetRange("FA Posting Date");            MaintenanceLedgEntry.SetRange("FA Posting Date");            FALedgEntry.SetCurrentKey(              "FA No.", "Depreciation Book Code", "FA Posting Category", "FA Posting Type", "Posting Date");            MaintenanceLedgEntry.SetCurrentKey("FA No.", "Depreciation Book Code", "Posting Date");            FALedgEntry.SetFilter("Posting Date", '>=%1', FiscalYearStartDate);            if FALedgEntry.FindFirst() then                CreateError(0);            MaintenanceLedgEntry.SetFilter("Posting Date", '>=%1', FiscalYearStartDate);            if MaintenanceLedgEntry.FindFirst() then                CreateError(0);            FALedgEntry.SetRange("Posting Date");            MaintenanceLedgEntry.SetRange("Posting Date");            DeleteNo(FADeprBook);        end;    end;    local procedure DeleteNo(var FADeprBook: Record "FA Depreciation Book")    var        IsHandled: Boolean;    begin        IsHandled := false;        OnBeforeDeleteNo(FADeprBook, IsHandled);        if IsHandled then            exit;        FALedgEntry.ModifyAll("FA No.", '');        FALedgEntry.SetRange("FA No.");        FALedgEntry.SetCurrentKey("Canceled from FA No.");        FALedgEntry.SetRange("Canceled from FA No.", FADeprBook."FA No.");        FALedgEntry.ModifyAll("Canceled from FA No.", '');        MaintenanceLedgEntry.ModifyAll("FA No.", '');        MoveFAInsuranceEntries(FADeprBook."FA No.");    end;    procedure MoveInsuranceEntries(Insurance: Record Insurance)    begin        InsCoverageLedgEntry.Reset();        InsCoverageLedgEntry.LockTable();        InsCoverageLedgEntry.SetCurrentKey("Insurance No.");        InsCoverageLedgEntry.SetRange("Insurance No.", Insurance."No.");        if InsCoverageLedgEntry.Find('-') then            repeat                InsCoverageLedgEntry."FA No." := '';                InsCoverageLedgEntry."Insurance No." := '';                InsCoverageLedgEntry.Modify();            until InsCoverageLedgEntry.Next() = 0;    end;    procedure MoveFAInsuranceEntries(FANo: Code[20])    begin        InsCoverageLedgEntry.SetCurrentKey("FA No.");        InsCoverageLedgEntry.SetRange("FA No.", FANo);        if InsCoverageLedgEntry.Find('-') then            repeat                InsCoverageLedgEntry."Insurance No." := '';                InsCoverageLedgEntry."FA No." := '';                InsCoverageLedgEntry.Modify();            until InsCoverageLedgEntry.Next() = 0;    end;    procedure ChangeBudget(FA: Record "Fixed Asset")    begin        FALedgEntry.Reset();        MaintenanceLedgEntry.Reset();        InsCoverageLedgEntry.Reset();        FALedgEntry.LockTable();        MaintenanceLedgEntry.LockTable();        InsCoverageLedgEntry.LockTable();        FALedgEntry.SetCurrentKey("FA No.", "Depreciation Book Code", "FA Posting Date");        MaintenanceLedgEntry.SetCurrentKey("FA No.", "Depreciation Book Code", "FA Posting Date");        InsCoverageLedgEntry.SetCurrentKey("FA No.");        FALedgEntry.SetRange("FA No.", FA."No.");        MaintenanceLedgEntry.SetRange("FA No.", FA."No.");        InsCoverageLedgEntry.SetRange("FA No.", FA."No.");        if FALedgEntry.FindFirst() then            CreateError(1);        if MaintenanceLedgEntry.FindFirst() then            CreateError(1);        if InsCoverageLedgEntry.Find('-') then            CreateError(2);    end;    local procedure CreateError(CheckType: Option Delete,Budget,Insurance)    var        FA: Record "Fixed Asset";    begin        case CheckType of            CheckType::Delete:                Error(                  Text001);            CheckType::Budget:                Error(                  Text002,                  FA.FieldCaption("Budgeted Asset"));            CheckType::Insurance:                Error(                  Text003,                  FA.FieldCaption("Budgeted Asset"));        end;    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeDeleteNo(var FADepreciationBook: Record "FA Depreciation Book"; var IsHandled: Boolean)    begin    end;}