Report 5604 Fixed Asset - Details

Base Application, Microsoft.FixedAssets.Reports

src/Layers/W1/BaseApp/FixedAssets/Reports/FixedAssetDetails.Report.al257 lines, Copyright (c) Microsoft Corporation. MIT

#if not CLEAN28// ------------------------------------------------------------------------------------------------// 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.FixedAssets.Depreciation;using Microsoft.FixedAssets.FixedAsset;using Microsoft.FixedAssets.Ledger;using Microsoft.FixedAssets.Setup;report 5604 "Fixed Asset - Details"{    ApplicationArea = FixedAssets;    Caption = 'Fixed Asset Details (Obsolete)';    UsageCategory = ReportsAndAnalysis;    WordMergeDataItem = "Fixed Asset";    ObsoleteState = Pending;    ObsoleteReason = 'This report has been replaced by the report Fixed Asset Details (Excel). This report will be removed in a future release.';    ObsoleteTag = '28.0';    DefaultRenderingLayout = RDLCLayout;    dataset    {        dataitem("Fixed Asset"; "Fixed Asset")        {            DataItemTableView = sorting("No.");            PrintOnlyIfDetail = true;            RequestFilterFields = "No.", "FA Class Code", "FA Subclass Code", "Budgeted Asset", "FA Posting Date Filter";            column(FORMAT_TODAY_0_4_; Format(Today, 0, 4))            {            }            column(COMPANYNAME; COMPANYPROPERTY.DisplayName())            {            }            column(DeprBookText; DeprBookText)            {            }            column(Fixed_Asset__TABLECAPTION__________FAFilter; TableCaption + ': ' + FAFilter)            {            }            column(FAFilter; FAFilter)            {            }            column(PrintOnlyOnePerPage; PrintOnlyOnePerPage)            {            }            column(Fixed_Asset__No__; "No.")            {            }            column(Fixed_Asset_Description; Description)            {            }            column(Fixed_Asset___DetailsCaption; Fixed_Asset___DetailsCaptionLbl)            {            }            column(CurrReport_PAGENOCaption; CurrReport_PAGENOCaptionLbl)            {            }            column(FA_Ledger_Entry__FA_Posting_Date_Caption; FA_Ledger_Entry__FA_Posting_Date_CaptionLbl)            {            }            column(FA_Ledger_Entry__Document_Type_Caption; "FA Ledger Entry".FieldCaption("Document Type"))            {            }            column(FA_Ledger_Entry__Document_No__Caption; "FA Ledger Entry".FieldCaption("Document No."))            {            }            column(FA_Ledger_Entry_DescriptionCaption; "FA Ledger Entry".FieldCaption(Description))            {            }            column(FA_Ledger_Entry_AmountCaption; "FA Ledger Entry".FieldCaption(Amount))            {            }            column(FA_Ledger_Entry__Entry_No__Caption; "FA Ledger Entry".FieldCaption("Entry No."))            {            }            column(FA_Ledger_Entry__FA_Posting_Type_Caption; "FA Ledger Entry".FieldCaption("FA Posting Type"))            {            }            column(FA_Ledger_Entry__No__of_Depreciation_Days_Caption; "FA Ledger Entry".FieldCaption("No. of Depreciation Days"))            {            }            column(FA_Ledger_Entry__User_ID_Caption; "FA Ledger Entry".FieldCaption("User ID"))            {            }            column(FA_Ledger_Entry__Posting_Date_Caption; FA_Ledger_Entry__Posting_Date_CaptionLbl)            {            }            column(FA_Ledger_Entry__G_L_Entry_No__Caption; "FA Ledger Entry".FieldCaption("G/L Entry No."))            {            }            column(FA_Ledger_Entry__FA_Posting_Category_Caption; "FA Ledger Entry".FieldCaption("FA Posting Category"))            {            }            dataitem("FA Ledger Entry"; "FA Ledger Entry")            {                DataItemTableView = sorting("FA No.", "Depreciation Book Code", "FA Posting Date");                column(FA_Ledger_Entry__FA_Posting_Date_; Format("FA Posting Date"))                {                }                column(FA_Ledger_Entry__Document_Type_; "Document Type")                {                }                column(FA_Ledger_Entry__Document_No__; "Document No.")                {                }                column(FA_Ledger_Entry_Description; Description)                {                }                column(FA_Ledger_Entry_Amount; Amount)                {                }                column(FA_Ledger_Entry__Entry_No__; "Entry No.")                {                }                column(FA_Ledger_Entry__FA_Posting_Type_; "FA Posting Type")                {                }                column(FA_Ledger_Entry__No__of_Depreciation_Days_; "No. of Depreciation Days")                {                }                column(FA_Ledger_Entry__User_ID_; "User ID")                {                }                column(FA_Ledger_Entry__Posting_Date_; Format("Posting Date"))                {                }                column(FA_Ledger_Entry__G_L_Entry_No__; "G/L Entry No.")                {                }                column(FA_Ledger_Entry__FA_Posting_Category_; "FA Posting Category")                {                }                trigger OnPreDataItem()                begin                    SetRange("FA No.", "Fixed Asset"."No.");                    SetRange("Depreciation Book Code", DeprBookCode);                    SetFilter("FA Posting Date", "Fixed Asset".GetFilter("FA Posting Date Filter"));                    if not PrintReversedEntries then                        SetRange(Reversed, false);                end;            }            trigger OnAfterGetRecord()            var                ShouldSkipAsset: Boolean;            begin                ShouldSkipAsset := Inactive;                OnFixedAssetOnAfterGetRecordOnAfterCalcShouldSkipAsset("Fixed Asset", ShouldSkipAsset);                if ShouldSkipAsset then                    CurrReport.Skip();            end;        }    }    requestpage    {        SaveValues = true;        AboutTitle = 'About Fixed Asset Details (Obsolete)';        AboutText = 'The **Fixed Asset Details** report provides a comprehensive overview of all relevant information pertaining to each fixed asset owned by an organization. This report serves as a detailed transaction information and reference tool for asset management.** This report is obsolete and will be removed in a future release.** Please refer to the report documentation for alternative ways to retrieve this information.';        layout        {            area(content)            {                group(Options)                {                    Caption = 'Options';                    field(DepreciationBook; DeprBookCode)                    {                        ApplicationArea = FixedAssets;                        Caption = 'Depreciation Book';                        TableRelation = "Depreciation Book";                        AboutTitle = 'Select Depreciation Book';                        AboutText = 'Choose the Depreciation Book and specify the applicable options against which details are to be seen in the report.';                        ToolTip = 'Specifies the code for the depreciation book to be included in the report or batch job.';                    }                    field(NewPagePerAsset; PrintOnlyOnePerPage)                    {                        ApplicationArea = FixedAssets;                        Caption = 'New Page per Asset';                        ToolTip = 'Specifies if you want each fixed asset printed on a new page.';                    }                    field(IncludeReversedEntries; PrintReversedEntries)                    {                        ApplicationArea = FixedAssets;                        Caption = 'Include Reversed Entries';                        ToolTip = 'Specifies if you want to include reversed fixed asset entries in the report.';                    }                }            }        }        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/FixedAssetDetails.rdlc';            Summary = 'Report layout made in the legacy RDLC format. Use an RDLC editor to modify the layout.';        }    }    labels    {    }    trigger OnPreReport()    begin        DeprBook.Get(DeprBookCode);        FAFilter := "Fixed Asset".GetFilters();        DeprBookText := StrSubstNo('%1%2 %3', DeprBook.TableCaption(), ':', DeprBookCode);    end;    var        FASetup: Record "FA Setup";        DeprBook: Record "Depreciation Book";        DeprBookCode: Code[10];        DeprBookText: Text[50];        PrintOnlyOnePerPage: Boolean;        FAFilter: Text;        PrintReversedEntries: Boolean;        Fixed_Asset___DetailsCaptionLbl: Label 'Fixed Asset - Details';        CurrReport_PAGENOCaptionLbl: Label 'Page';        FA_Ledger_Entry__FA_Posting_Date_CaptionLbl: Label 'FA Posting Date';        FA_Ledger_Entry__Posting_Date_CaptionLbl: Label 'Posting Date';    procedure InitializeRequest(NewDeprBookCode: Code[10]; NewPrintOnlyOnePerPage: Boolean; NewPrintReversedEntries: Boolean)    begin        DeprBookCode := NewDeprBookCode;        PrintOnlyOnePerPage := NewPrintOnlyOnePerPage;        PrintReversedEntries := NewPrintReversedEntries;    end;    [IntegrationEvent(false, false)]    local procedure OnFixedAssetOnAfterGetRecordOnAfterCalcShouldSkipAsset(FixedAsset: Record "Fixed Asset"; var ShouldSkipAsset: Boolean)    begin    end;}#endif