Report 5608 Fixed Asset - Acquisition List

Base Application, Microsoft.FixedAssets.Reports

src/Layers/W1/BaseApp/FixedAssets/Reports/FixedAssetAcquisitionList.Report.al205 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.FixedAssets.Depreciation;using Microsoft.FixedAssets.FixedAsset;using Microsoft.FixedAssets.Setup;report 5608 "Fixed Asset - Acquisition List"{    ApplicationArea = FixedAssets;    Caption = 'Fixed Asset Acquisition List';    UsageCategory = ReportsAndAnalysis;    DefaultRenderingLayout = RDLCLayout;    dataset    {        dataitem("Fixed Asset"; "Fixed Asset")        {            RequestFilterFields = "No.", "FA Class Code", "FA Subclass Code", "Budgeted Asset";            column(CompanyName; COMPANYPROPERTY.DisplayName())            {            }            column(DeprBookText; DeprBookText)            {            }            column(FixAssetTableCaptFaFilter; TableCaption + ': ' + FAFilter)            {            }            column(No_FixedAsset; "No.")            {                IncludeCaption = true;            }            column(Desc_FixedAsset; Description)            {                IncludeCaption = true;            }            column(LocCode_FixedAsset; "FA Location Code")            {                IncludeCaption = true;            }            column(RespEmp_FixedAsset; "Responsible Employee")            {                IncludeCaption = true;            }            column(SerialNo_FixedAsset; "Serial No.")            {                IncludeCaption = true;            }            column(FaDeprBookAcquDate; Format(FADeprBook."Acquisition Date"))            {            }            column(FixedAssetAcqListCptn; FixedAssetAcqListCptnLbl)            {            }            column(CurrReportPageNoCaption; CurrReportPageNoCaptionLbl)            {            }            column(FADeprBkAcquisitionDtCptn; FADeprBkAcquisitionDtCptnLbl)            {            }            trigger OnAfterGetRecord()            begin                Clear(FADeprBook);                PrintFA := false;                if not FADeprBook.Get("No.", DeprBookCode) then begin                    if FAWithoutAcqDate then                        PrintFA := true;                end else                    if FADeprBook."Acquisition Date" = 0D then begin                        if FAWithoutAcqDate then                            PrintFA := true;                    end else                        PrintFA := (FADeprBook."Acquisition Date" >= StartingDate) and                          (FADeprBook."Acquisition Date" <= EndingDate);                if not PrintFA then                    CurrReport.Skip();            end;        }    }    requestpage    {        SaveValues = true;        AboutTitle = 'About Fixed Asset Acquisition List';        AboutText = 'The **Fixed Asset Acquisition List** report is a detailed accounting document that provides an organized summary of all fixed assets acquired by an organization during a specific period. This report is essential for tracking new additions to the asset base and ensuring accurate financial reporting.';        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 the Starting Date and Ending Date for 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.';                    }                    group("Acquisition Period")                    {                        Caption = 'Acquisition Period';                        field(StartingDate; StartingDate)                        {                            ApplicationArea = FixedAssets;                            Caption = 'Starting Date';                            ToolTip = 'Specifies the date when you want the report to start.';                        }                        field(EndingDate; EndingDate)                        {                            ApplicationArea = FixedAssets;                            Caption = 'Ending Date';                            ToolTip = 'Specifies the date when you want the report to end.';                        }                    }                    field(FAWithoutAcqDate; FAWithoutAcqDate)                    {                        ApplicationArea = FixedAssets;                        Caption = 'Include Fixed Assets Not Yet Acquired';                        AboutTitle = 'Enable Include Fixed Assets Not Yet Acquired';                        AboutText = 'Specifies if you want to include a fixed asset for which the first acquisition cost has not yet been posted.';                        ToolTip = 'Specifies if you want to include a fixed asset for which the first acquisition cost has not yet been posted.';                    }                }            }        }        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/FixedAssetAcquisitionList.rdlc';            Summary = 'Report layout made in the legacy RDLC format. Use an RDLC editor to modify the layout.';        }    }    labels    {    }    trigger OnPreReport()    begin        FAGenReport.AppendFAPostingFilter("Fixed Asset", StartingDate, EndingDate);        FAFilter := "Fixed Asset".GetFilters();        DeprBookText := StrSubstNo('%1%2 %3', DeprBook.TableCaption(), ':', DeprBookCode);        ValidateDates(StartingDate, EndingDate);        FAGenReport.ValidateDates(StartingDate, EndingDate);    end;    var        FASetup: Record "FA Setup";        DeprBook: Record "Depreciation Book";        FADeprBook: Record "FA Depreciation Book";        FAGenReport: Codeunit "FA General Report";        DeprBookCode: Code[10];        DeprBookText: Text[50];        FAFilter: Text;        StartingDate: Date;        EndingDate: Date;        FAWithoutAcqDate: Boolean;        PrintFA: Boolean;#pragma warning disable AA0074        Text001: Label 'You must specify a Starting Date.';        Text002: Label 'You must specify an Ending Date.';        Text003: Label 'You must specify an Ending Date that is later than the Starting Date.';#pragma warning restore AA0074        FixedAssetAcqListCptnLbl: Label 'Fixed Asset - Acquisition List';        CurrReportPageNoCaptionLbl: Label 'Page';        FADeprBkAcquisitionDtCptnLbl: Label 'Acquisition Date';    local procedure ValidateDates(StartingDate: Date; EndingDate: Date)    begin        if StartingDate = 0D then            Error(Text001);        if EndingDate = 0D then            Error(Text002);        if StartingDate > EndingDate then            Error(Text003);    end;}