Report 5608 Fixed Asset - Acquisition List, source in 29
Source29
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;
}