Report 5626 Insurance - Uninsured FAs, source in 29
Source29
src/Layers/W1/BaseApp/FixedAssets/Insurance/InsuranceUninsuredFAs.Report.al174 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.Insurance;
using Microsoft.FixedAssets.Depreciation;
using Microsoft.FixedAssets.FixedAsset;
using Microsoft.FixedAssets.Setup;
report 5626 "Insurance - Uninsured FAs"
{
ApplicationArea = FixedAssets;
Caption = 'Uninsured Fixed Assets';
UsageCategory = ReportsAndAnalysis;
DefaultRenderingLayout = RDLCLayout;
dataset
{
dataitem("Fixed Asset"; "Fixed Asset")
{
RequestFilterFields = "No.", "FA Class Code", "FA Subclass Code";
column(CompanyName; COMPANYPROPERTY.DisplayName())
{
}
column(TodayFormatted; Format(Today, 0, 4))
{
}
column(FixedAssetCaptionFilter; TableCaption + ': ' + FAFilter)
{
}
column(FAFilter; FAFilter)
{
}
column(HeadLineText1; HeadLineText[1])
{
}
column(HeadLineText2; HeadLineText[2])
{
}
column(HeadLineText3; HeadLineText[3])
{
}
column(Amounts1; Amounts[1])
{
AutoFormatType = 1;
}
column(Amounts2; Amounts[2])
{
AutoFormatType = 1;
}
column(Amounts3; Amounts[3])
{
AutoFormatType = 1;
}
column(No_FixedAsset; "No.")
{
IncludeCaption = true;
}
column(Description_FixedAsset; Description)
{
IncludeCaption = true;
}
column(TotalAmounts1; TotalAmounts[1])
{
AutoFormatType = 1;
}
column(TotalAmounts2; TotalAmounts[2])
{
AutoFormatType = 1;
}
column(TotalAmounts3; TotalAmounts[3])
{
AutoFormatType = 1;
}
column(CurrReportPageNoCaption; CurrReportPageNoCaptionLbl)
{
}
column(InsUninsuredFxdAssetsCptn; InsUninsuredFxdAssetsCptnLbl)
{
}
column(TotalCaption; TotalCaptionLbl)
{
}
trigger OnAfterGetRecord()
begin
if not FADeprBook.Get("No.", DeprBook.Code) then
CurrReport.Skip();
CalcFields(Insured);
if (FADeprBook."Disposal Date" > 0D) or Insured or Inactive then
CurrReport.Skip();
FADeprBook.CalcFields("Acquisition Cost", Depreciation, "Book Value");
SetAmountsFromBook();
for i := 1 to 3 do
TotalAmounts[i] := TotalAmounts[i] + Amounts[i];
end;
}
}
requestpage
{
SaveValues = true;
layout
{
}
actions
{
}
}
rendering
{
layout(RDLCLayout)
{
Type = RDLC;
LayoutFile = './FixedAssets/Insurance/InsuranceUninsuredFAs.rdlc';
Summary = 'Report layout made in the legacy RDLC format. Use an RDLC editor to modify the layout.';
}
}
labels
{
}
trigger OnPreReport()
begin
FAFilter := "Fixed Asset".GetFilters();
MakeAmountHeadLine();
FASetup.Get();
FASetup.TestField("Insurance Depr. Book");
DeprBook.Get(FASetup."Insurance Depr. Book");
end;
var
FASetup: Record "FA Setup";
DeprBook: Record "Depreciation Book";
FADeprBook: Record "FA Depreciation Book";
FAFilter: Text;
TotalAmounts: array[3] of Decimal;
HeadLineText: array[3] of Text[80];
Amounts: array[3] of Decimal;
i: Integer;
CurrReportPageNoCaptionLbl: Label 'Page';
InsUninsuredFxdAssetsCptnLbl: Label 'Insurance - Uninsured Fixed Assets';
TotalCaptionLbl: Label 'Total';
local procedure MakeAmountHeadLine()
begin
HeadLineText[1] := FADeprBook.FieldCaption("Acquisition Cost");
HeadLineText[2] := FADeprBook.FieldCaption(Depreciation);
HeadLineText[3] := FADeprBook.FieldCaption("Book Value");
end;
local procedure SetAmountsFromBook()
begin
Amounts[1] := FADeprBook."Acquisition Cost";
Amounts[2] := FADeprBook.Depreciation;
Amounts[3] := FADeprBook."Book Value";
OnAfterSetAmountsFromBook(Amounts, FADeprBook);
end;
[IntegrationEvent(false, false)]
local procedure OnAfterSetAmountsFromBook(var Amounts: array[3] of Decimal; FADepreciationBook: Record "FA Depreciation Book")
begin
end;
}