Report 5601 Fixed Asset - List

Base Application, Microsoft.FixedAssets.Reports

src/Layers/W1/BaseApp/FixedAssets/Reports/FixedAssetList.Report.al347 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.Reports;using Microsoft.Finance.Dimension;using Microsoft.Finance.GeneralLedger.Setup;using Microsoft.FixedAssets.Depreciation;using Microsoft.FixedAssets.FixedAsset;using Microsoft.FixedAssets.Setup;report 5601 "Fixed Asset - List"{    ApplicationArea = FixedAssets;    Caption = 'Fixed Asset List';    UsageCategory = ReportsAndAnalysis;    DefaultRenderingLayout = RDLCLayout;    dataset    {        dataitem("Fixed Asset"; "Fixed Asset")        {            DataItemTableView = sorting("No.");            PrintOnlyIfDetail = true;            RequestFilterFields = "No.", "FA Class Code", "FA Subclass Code", "Budgeted Asset";            column(CompanyName; COMPANYPROPERTY.DisplayName())            {            }            column(DeprBookText; DeprBookText)            {            }            column(FATableCaptionFAFilter; TableCaption + ': ' + FAFilter)            {            }            column(FAFilter; FAFilter)            {            }            column(FANo; "No.")            {                IncludeCaption = true;            }            column(FADesc; Description)            {            }            column(FAMainAssetComponent; "Main Asset/Component")            {            }            column(BudgetedAssetFieldname; BudgetedAssetFieldname)            {            }            column(FASerialNo; "Serial No.")            {            }            column(FAComponentofMainAsset; "Component of Main Asset")            {            }            column(ComponentFieldname; ComponentFieldname)            {            }            column(GlobalDim1CodeCaption; GlobalDim1CodeCaption)            {            }            column(FAGlobalDim1Code; "Global Dimension 1 Code")            {            }            column(GlobalDim2CodeCaption; GlobalDim2CodeCaption)            {            }            column(FAGlobalDim2Code; "Global Dimension 2 Code")            {            }            column(FAClassCode; "FA Class Code")            {                IncludeCaption = true;            }            column(FASubclassCode; "FA Subclass Code")            {                IncludeCaption = true;            }            column(FALocationCode; "FA Location Code")            {                IncludeCaption = true;            }            column(PageGroupNo; PageGroupNo)            {            }            column(FAListCaption; FAListCaptionLbl)            {            }            column(CurrReportPageNoCaption; CurrReportPageNoCaptionLbl)            {            }            dataitem("FA Depreciation Book"; "FA Depreciation Book")            {                DataItemTableView = sorting("FA No.", "Depreciation Book Code");                column(FADeprBookDeprMethod; "Depreciation Method")                {                    IncludeCaption = true;                }                column(FADeprBookDeprStartingDate; Format("Depreciation Starting Date"))                {                }                column(FADeprBookFAPostingGroup; "FA Posting Group")                {                    IncludeCaption = true;                }                column(FADeprBookStraightLine; "Straight-Line %")                {                    IncludeCaption = true;                }                column(FADeprBookNoofDeprYrs; "No. of Depreciation Years")                {                    IncludeCaption = true;                }                column(FADeprBookNoofDeprMonths; "No. of Depreciation Months")                {                    IncludeCaption = true;                }                column(FADeprBookDeprEndingDate; Format("Depreciation Ending Date"))                {                }                column(FADeprBookFixedDeprAmt; "Fixed Depr. Amount")                {                    IncludeCaption = true;                }                column(FADeprBookDecliningBalance; "Declining-Balance %")                {                    IncludeCaption = true;                }                column(FADeprBookDeprTableCode; "Depreciation Table Code")                {                    IncludeCaption = true;                }                column(FADeprBookUserDefinedDeprDt; Format("First User-Defined Depr. Date"))                {                }                column(FADeprBookFinalRoundingAmt; "Final Rounding Amount")                {                    IncludeCaption = true;                }                column(FADeprBookEndingBookValue; "Ending Book Value")                {                    IncludeCaption = true;                }                column(FADeprBookFAExchangeRate; "FA Exchange Rate")                {                    IncludeCaption = true;                }                column(FADeprBookUseFALedgCheck; "Use FA Ledger Check")                {                    IncludeCaption = true;                }                column(FADeprBookDeprbelowZero; "Depr. below Zero %")                {                    IncludeCaption = true;                }                column(FADeprBookFDeprAmtbelowZero; "Fixed Depr. Amount below Zero")                {                    IncludeCaption = true;                }                column(FADeprBookProjProceedDspsl; "Projected Proceeds on Disposal")                {                    IncludeCaption = true;                }                column(FADeprBookProjDisposalDate; Format("Projected Disposal Date"))                {                }                column(FADeprBookStartingDateCustom; Format("Depr. Starting Date (Custom 1)"))                {                }                column(FADeprBookAccumDeprCustom; "Accum. Depr. % (Custom 1)")                {                    IncludeCaption = true;                }                column(FADeprBookThisYrCustom; "Depr. This Year % (Custom 1)")                {                    IncludeCaption = true;                }                column(FADeprBookEndingDateCustom; Format("Depr. Ending Date (Custom 1)"))                {                }                column(FADeprBookPropertyClassCustom; "Property Class (Custom 1)")                {                    IncludeCaption = true;                }                column(FADeprBookDeprStartDateCaption; FADeprBookDeprStartDateCaptionLbl)                {                }                column(FADeprBookDeprEndDateCaption; FADeprBookDeprEndDateCaptionLbl)                {                }                column(FADeprBookUsrDfndDeprDtCaption; FADeprBookUsrDfndDeprDtCaptionLbl)                {                }                column(FADeprBookProjDisplDateCaption; FADeprBookProjDisplDateCaptionLbl)                {                }                column(FADeprBookStartDateCustomCaption; FADeprBookStartDateCustomCaptionLbl)                {                }                column(FADeprBookEndDateCustomCptn; FADeprBookEndDateCustomCptnLbl)                {                }                trigger OnPreDataItem()                begin                    SetRange("FA No.", "Fixed Asset"."No.");                    SetRange("Depreciation Book Code", DeprBookCode);                end;            }            trigger OnAfterGetRecord()            var                ShouldSkipAsset: Boolean;            begin                ShouldSkipAsset := Inactive;                OnFixedAssetOnAfterGetRecordOnAfterCalcShouldSkipAsset("Fixed Asset", ShouldSkipAsset);                if ShouldSkipAsset then                    CurrReport.Skip();                if "Main Asset/Component" <> "Main Asset/Component"::" " then                    ComponentFieldname := FieldCaption("Component of Main Asset")                else                    ComponentFieldname := '';                if "Budgeted Asset" then                    BudgetedAssetFieldname := FieldCaption("Budgeted Asset")                else                    BudgetedAssetFieldname := '';                if PrintOnlyOnePerPage then                    PageGroupNo := PageGroupNo + 1;            end;            trigger OnPreDataItem()            begin                PageGroupNo := 1;            end;        }    }    requestpage    {        SaveValues = true;        AboutTitle = 'About Fixed Asset List';        AboutText = 'The **Fixed Asset List** report provides a comprehensive listing of all fixed assets owned by an organization at a specific point in time. This report is crucial for asset management, financial reporting, and compliance purposes.';        layout        {            area(content)            {                group(Options)                {                    Caption = 'Options';                    field(DeprBookCode; DeprBookCode)                    {                        ApplicationArea = FixedAssets;                        Caption = 'Depreciation Book';                        TableRelation = "Depreciation Book";                        AboutTitle = 'Select Depreciation Book';                        AboutText = 'Choose the Depreciation Book and specify New Page per Asset if you want each fixed asset printed on a new page.';                        ToolTip = 'Specifies the code for the depreciation book to be included in the report or batch job.';                    }                    field(PrintOnlyOnePerPage; PrintOnlyOnePerPage)                    {                        ApplicationArea = FixedAssets;                        Caption = 'New Page per Asset';                        ToolTip = 'Specifies if you want each fixed asset printed on a new page.';                    }                }            }        }        actions        {        }        trigger OnOpenPage()        begin            if DeprBookCode = '' then begin                FASetup.Get();                DeprBookCode := FASetup."Default Depr. Book";            end;        end;    }    rendering    {        layout(RDLCLayout)        {            Type = RDLC;            LayoutFile = './FixedAssets/Reports/FixedAssetList.rdlc';            Summary = 'Report layout made in the legacy RDLC format. Use an RDLC editor to modify the layout.';        }    }    labels    {    }    trigger OnPreReport()    var        GeneralLedgerSetup: Record "General Ledger Setup";        Dimension: Record Dimension;    begin        DeprBook.Get(DeprBookCode);        FAFilter := "Fixed Asset".GetFilters();        DeprBookText := StrSubstNo('%1%2 %3', DeprBook.TableCaption(), ':', DeprBookCode);        GlobalDim1CodeCaption := '';        GlobalDim2CodeCaption := '';        GeneralLedgerSetup.Get();        if GeneralLedgerSetup."Global Dimension 1 Code" <> '' then begin            Dimension.Get(GeneralLedgerSetup."Global Dimension 1 Code");            GlobalDim1CodeCaption := Dimension."Code Caption";        end;        if GeneralLedgerSetup."Global Dimension 2 Code" <> '' then begin            Dimension.Get(GeneralLedgerSetup."Global Dimension 2 Code");            GlobalDim2CodeCaption := Dimension."Code Caption";        end;    end;    var        FASetup: Record "FA Setup";        DeprBook: Record "Depreciation Book";        PrintOnlyOnePerPage: Boolean;        DeprBookCode: Code[10];        FAFilter: Text;        ComponentFieldname: Text[100];        BudgetedAssetFieldname: Text[100];        DeprBookText: Text[50];        PageGroupNo: Integer;        FAListCaptionLbl: Label 'Fixed Asset - List';        CurrReportPageNoCaptionLbl: Label 'Page';        FADeprBookDeprStartDateCaptionLbl: Label 'Depreciation Starting Date';        FADeprBookDeprEndDateCaptionLbl: Label 'Depreciation Ending Date';        FADeprBookUsrDfndDeprDtCaptionLbl: Label 'First User-Defined Depr. Date';        FADeprBookProjDisplDateCaptionLbl: Label 'Projected Disposal Date';        FADeprBookStartDateCustomCaptionLbl: Label 'Depr. Starting Date (Custom 1)';        FADeprBookEndDateCustomCptnLbl: Label 'Depr. Ending Date (Custom 1)';        GlobalDim1CodeCaption: Text[80];        GlobalDim2CodeCaption: Text[80];    [IntegrationEvent(false, false)]    local procedure OnFixedAssetOnAfterGetRecordOnAfterCalcShouldSkipAsset(FixedAsset: Record "Fixed Asset"; var ShouldSkipAsset: Boolean)    begin    end;}