Report 5634 Maintenance - Details
src/Layers/W1/BaseApp/FixedAssets/Maintenance/MaintenanceDetails.Report.al231 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.Maintenance;using Microsoft.FixedAssets.Depreciation;using Microsoft.FixedAssets.FixedAsset;using Microsoft.FixedAssets.Setup;report 5634 "Maintenance - Details"{ ApplicationArea = FixedAssets; Caption = 'Fixed Asset Maintenance Details'; UsageCategory = ReportsAndAnalysis; DefaultRenderingLayout = RDLCLayout; dataset { dataitem("Fixed Asset"; "Fixed Asset") { DataItemTableView = sorting("No."); PrintOnlyIfDetail = true; RequestFilterFields = "No.", "FA Class Code", "FA Subclass Code", "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(GroupCounter; GroupCounter) { } column(Fixed_Asset__No__; "No.") { } column(Fixed_Asset_Description; Description) { } column(Maintenance___DetailsCaption; Maintenance___DetailsCaptionLbl) { } column(CurrReport_PAGENOCaption; CurrReport_PAGENOCaptionLbl) { } column(Maintenance_Ledger_Entry__FA_Posting_Date_Caption; Maintenance_Ledger_Entry__FA_Posting_Date_CaptionLbl) { } column(Maintenance_Ledger_Entry__Document_Type_Caption; "Maintenance Ledger Entry".FieldCaption("Document Type")) { } column(Maintenance_Ledger_Entry__Document_No__Caption; "Maintenance Ledger Entry".FieldCaption("Document No.")) { } column(Maintenance_Ledger_Entry_DescriptionCaption; "Maintenance Ledger Entry".FieldCaption(Description)) { } column(Maintenance_Ledger_Entry_AmountCaption; "Maintenance Ledger Entry".FieldCaption(Amount)) { } column(Maintenance_Ledger_Entry__Entry_No__Caption; "Maintenance Ledger Entry".FieldCaption("Entry No.")) { } column(Maintenance_Ledger_Entry__User_ID_Caption; "Maintenance Ledger Entry".FieldCaption("User ID")) { } column(Maintenance_Ledger_Entry__Posting_Date_Caption; Maintenance_Ledger_Entry__Posting_Date_CaptionLbl) { } column(Maintenance_Ledger_Entry__G_L_Entry_No__Caption; "Maintenance Ledger Entry".FieldCaption("G/L Entry No.")) { } column(Maintenance_Ledger_Entry__Maintenance_Code_Caption; "Maintenance Ledger Entry".FieldCaption("Maintenance Code")) { } dataitem("Maintenance Ledger Entry"; "Maintenance Ledger Entry") { DataItemTableView = sorting("FA No.", "Depreciation Book Code", "FA Posting Date"); column(Maintenance_Ledger_Entry__FA_Posting_Date_; Format("FA Posting Date")) { } column(Maintenance_Ledger_Entry__Document_Type_; "Document Type") { } column(Maintenance_Ledger_Entry__Document_No__; "Document No.") { } column(Maintenance_Ledger_Entry_Description; Description) { } column(Maintenance_Ledger_Entry_Amount; Amount) { } column(Maintenance_Ledger_Entry__Entry_No__; "Entry No.") { } column(Maintenance_Ledger_Entry__User_ID_; "User ID") { } column(Maintenance_Ledger_Entry__Posting_Date_; Format("Posting Date")) { } column(Maintenance_Ledger_Entry__G_L_Entry_No__; "G/L Entry No.") { } column(Maintenance_Ledger_Entry__Maintenance_Code_; "Maintenance Code") { } 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() begin if Inactive then CurrReport.Skip(); if PrintOnlyOnePerPage then GroupCounter += 1; end; } } requestpage { SaveValues = true; layout { area(content) { group(Options) { Caption = 'Options'; field(DepreciationBook; DeprBookCode) { ApplicationArea = FixedAssets; Caption = 'Depreciation Book'; TableRelation = "Depreciation Book"; ToolTip = 'Specifies the code for the depreciation book to be included in the report or batch job.'; } field(NewPagePerFA; PrintOnlyOnePerPage) { ApplicationArea = FixedAssets; Caption = 'New Page per FA'; ToolTip = 'Specifies if you want the report to print data for each fixed asset on a separate page.'; } field(IncludeReversedEntries; PrintReversedEntries) { ApplicationArea = FixedAssets; Caption = 'Include Reversed Entries'; ToolTip = 'Specifies if you want to include reversed 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/Maintenance/MaintenanceDetails.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); GroupCounter := 0; end; var FASetup: Record "FA Setup"; DeprBook: Record "Depreciation Book"; DeprBookCode: Code[10]; DeprBookText: Text[50]; PrintOnlyOnePerPage: Boolean; FAFilter: Text; PrintReversedEntries: Boolean; GroupCounter: Integer; Maintenance___DetailsCaptionLbl: Label 'Maintenance - Details'; CurrReport_PAGENOCaptionLbl: Label 'Page'; Maintenance_Ledger_Entry__FA_Posting_Date_CaptionLbl: Label 'FA Posting Date'; Maintenance_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;}