Report 1199 Delete Empty Res. Registers
src/Layers/W1/BaseApp/Projects/Resources/Journal/DeleteEmptyResRegisters.Report.al95 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.Projects.Resources.Ledger;using System.Utilities;report 1199 "Delete Empty Res. Registers"{ Caption = 'Delete Empty Res. Registers'; ToolTip = 'Find and delete empty resource registers.'; Permissions = TableData "Resource Register" = rimd; ProcessingOnly = true; dataset { dataitem("Resource Register"; "Resource Register") { DataItemTableView = sorting("No."); RequestFilterFields = "Creation Date"; trigger OnAfterGetRecord() begin ResLedgEntry.SetRange("Entry No.", "From Entry No.", "To Entry No."); if ResLedgEntry.FindFirst() then CurrReport.Skip(); Window.Update(1, "No."); Window.Update(2, "Creation Date"); Delete(); NoOfDeleted := NoOfDeleted + 1; Window.Update(3, NoOfDeleted); if NoOfDeleted >= NoOfDeleted2 + 10 then begin NoOfDeleted2 := NoOfDeleted; Commit(); end; end; trigger OnPreDataItem() var ConfirmManagement: Codeunit "Confirm Management"; begin if not SkipConfirm then if not ConfirmManagement.GetResponseOrDefault(DeleteRegistersQst, true) then CurrReport.Break(); Window.Open( Text001 + Text002 + Text003 + Text004); end; } } requestpage { layout { } actions { } } labels { } var ResLedgEntry: Record "Res. Ledger Entry"; Window: Dialog; NoOfDeleted: Integer; NoOfDeleted2: Integer; SkipConfirm: Boolean; DeleteRegistersQst: Label 'Do you want to delete the registers?';#pragma warning disable AA0074 Text001: Label 'Deleting empty resource registers...\\';#pragma warning disable AA0470 Text002: Label 'No. #1######\'; Text003: Label 'Posted on #2######\\'; Text004: Label 'No. of registers deleted #3######';#pragma warning restore AA0470#pragma warning restore AA0074 procedure SetSkipConfirm() begin SkipConfirm := true; end;}