Report 799 Delete Empty Item Registers

Base Application, Microsoft.Inventory.Ledger

src/Layers/W1/BaseApp/Inventory/Ledger/DeleteEmptyItemRegisters.Report.al112 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.Inventory.Ledger;using Microsoft.Inventory.Counting.Journal;using System.Utilities;report 799 "Delete Empty Item Registers"{    Caption = 'Delete Empty Item Registers';    ToolTip = 'Find and delete empty item registers.';    Permissions = TableData "Item Register" = rimd;    ProcessingOnly = true;    dataset    {        dataitem("Item Register"; "Item Register")        {            DataItemTableView = sorting("No.");            RequestFilterFields = "Creation Date";            trigger OnAfterGetRecord()            begin                ItemLedgEntry.SetRange("Entry No.", "From Entry No.", "To Entry No.");                ItemLedgEntry.SetFilter("Item Register No.", '0|%1', "Item Register"."No.");                ValueEntry.SetRange("Entry No.", "From Entry No.", "To Entry No.");                ValueEntry.SetFilter("Item Register No.", '0|%1', "Item Register"."No.");                PhysInvtLedgEntry.SetRange("Entry No.", "From Phys. Inventory Entry No.", "To Phys. Inventory Entry No.");                PhysInvtLedgEntry.SetFilter("Item Register No.", '0|%1', "Item Register"."No.");                CapLedgEntry.SetRange("Entry No.", "From Capacity Entry No.", "To Capacity Entry No.");                CapLedgEntry.SetFilter("Item Register No.", '0|%1', "Item Register"."No.");                if not ItemLedgEntry.IsEmpty() then                    CurrReport.Skip();                if not ValueEntry.IsEmpty() then                    CurrReport.Skip();                if not PhysInvtLedgEntry.IsEmpty() then                    CurrReport.Skip();                if not CapLedgEntry.IsEmpty() 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        ItemLedgEntry: Record "Item Ledger Entry";        ValueEntry: Record "Value Entry";        PhysInvtLedgEntry: Record "Phys. Inventory Ledger Entry";        CapLedgEntry: Record Microsoft.Manufacturing.Capacity."Capacity 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 item 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;}