Report 5986 Prepaid Contr. Entries - Test
src/Layers/W1/BaseApp/Service/Reports/PrepaidContrEntriesTest.Report.al220 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.Service.Reports;using Microsoft.Service.Contract;using Microsoft.Service.Ledger;using System.Utilities;report 5986 "Prepaid Contr. Entries - Test"{ DefaultLayout = RDLC; RDLCLayout = './Service/Reports/PrepaidContrEntriesTest.rdlc'; Caption = 'Prepaid Contr. Entries - Test'; ToolTip = 'View the prepaid service contract.'; dataset { dataitem("Service Ledger Entry"; "Service Ledger Entry") { DataItemTableView = sorting("Service Contract No.", "Entry No.", "Entry Type", Type, "Moved from Prepaid Acc.", "Posting Date", Open, Prepaid) where(Type = const("Service Contract"), "Moved from Prepaid Acc." = const(false), Open = const(false)); RequestFilterFields = "Service Contract No."; column(FORMAT_TODAY_0_4_; Format(Today, 0, 4)) { } column(COMPANYNAME; COMPANYPROPERTY.DisplayName()) { } column(Service_Ledger_Entry__User_ID_; "User ID") { } column(PostingDate; Format(PostingDate)) { } column(UntilDate; Format(UntilDate)) { } column(Service_Ledger_Entry__TABLECAPTION__________ServLedgerFilters; TableCaption + ': ' + ServLedgerFilters) { } column(ServLedgerFilters; ServLedgerFilters) { } column(Service_Ledger_Entry__Service_Contract_No__; "Service Contract No.") { } column(Service_Ledger_Entry__Serial_No___Serviced__; "Serial No. (Serviced)") { } column(Service_Ledger_Entry__Posting_Date_; Format("Posting Date")) { } column(Service_Ledger_Entry__Serv__Contract_Acc__Gr__Code_; "Serv. Contract Acc. Gr. Code") { } column(Service_Ledger_Entry__Amount__LCY__; "Amount (LCY)") { } column(Service_Ledger_Entry__Amount__LCY___Control7; "Amount (LCY)") { } column(Service_Ledger_Entry_Entry_No_; "Entry No.") { } column(Prepaid_Contract_Entries___TestCaption; Prepaid_Contract_Entries___TestCaptionLbl) { } column(CurrReport_PAGENOCaption; CurrReport_PAGENOCaptionLbl) { } column(PostingDateCaption; PostingDateCaptionLbl) { } column(UntilDateCaption; UntilDateCaptionLbl) { } column(Service_Ledger_Entry__Service_Contract_No__Caption; FieldCaption("Service Contract No.")) { } column(Service_Ledger_Entry__Serial_No___Serviced__Caption; FieldCaption("Serial No. (Serviced)")) { } column(Service_Ledger_Entry__Posting_Date_Caption; Service_Ledger_Entry__Posting_Date_CaptionLbl) { } column(Service_Ledger_Entry__Serv__Contract_Acc__Gr__Code_Caption; FieldCaption("Serv. Contract Acc. Gr. Code")) { } column(Service_Ledger_Entry__Amount__LCY__Caption; FieldCaption("Amount (LCY)")) { } column(TotalCaption; TotalCaptionLbl) { } dataitem(ErrorLoop; "Integer") { DataItemTableView = sorting(Number) order(ascending); column(ErrorText; ErrorText) { } column(Warning_Caption; Warning_CaptionLbl) { } trigger OnPostDataItem() begin ErrorCounter := 0; end; trigger OnPreDataItem() begin SetRange(Number, 1, ErrorCounter); end; } trigger OnAfterGetRecord() begin ServContractHdr.SetFilter("Contract No.", "Service Contract No."); if ServContractHdr.FindFirst() then begin ServContractHdr.CalcFields("No. of Unposted Credit Memos"); if ServContractHdr."No. of Unposted Credit Memos" <> 0 then AddError(Text002); end; end; trigger OnPreDataItem() begin if UntilDate = 0D then Error(Text000); if PostingDate = 0D then Error(Text001); SetRange("Posting Date", 0D, UntilDate); end; } } requestpage { layout { area(content) { group(Options) { Caption = 'Options'; field(UntilDate; UntilDate) { ApplicationArea = Service; Caption = 'Post until Date'; ToolTip = 'Specifies the date up to which you want to post prepaid entries. The report includes service ledger entries with posting dates on or before this date.'; } field(PostingDate; PostingDate) { ApplicationArea = Service; Caption = 'Posting Date'; ToolTip = 'Specifies the date that you want to use as the posting date on the service ledger entries.'; } } } } actions { } } labels { } trigger OnInitReport() begin if PostingDate = 0D then PostingDate := WorkDate(); end; trigger OnPreReport() begin ServLedgerFilters := "Service Ledger Entry".GetFilters(); end; var#pragma warning disable AA0074 Text000: Label 'You must fill in the Post Until Date field.'; Text001: Label 'You must fill in the Posting Date field.';#pragma warning restore AA0074 ServContractHdr: Record "Service Contract Header"; UntilDate: Date; PostingDate: Date; ErrorText: Text[250]; ServLedgerFilters: Text;#pragma warning disable AA0074 Text002: Label 'There is at least one unposted credit memo linked to this contract.';#pragma warning restore AA0074 ErrorCounter: Integer; Prepaid_Contract_Entries___TestCaptionLbl: Label 'Prepaid Contract Entries - Test'; CurrReport_PAGENOCaptionLbl: Label 'Page'; PostingDateCaptionLbl: Label 'Posting Date'; UntilDateCaptionLbl: Label 'Post until Date'; Service_Ledger_Entry__Posting_Date_CaptionLbl: Label 'Posting Date'; TotalCaptionLbl: Label 'Total'; Warning_CaptionLbl: Label 'Warning!'; procedure InitVariables(LocalUntilDate: Date; LocalPostingDate: Date) begin UntilDate := LocalUntilDate; PostingDate := LocalPostingDate; end; local procedure AddError(Text: Text[250]) begin ErrorCounter += 1; ErrorText := Text; end;}