Report 5693 Delete Empty FA Registers, source in 29
Source29
src/Layers/W1/BaseApp/FixedAssets/FixedAsset/DeleteEmptyFARegisters.Report.al115 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.Ledger;
using Microsoft.FixedAssets.Maintenance;
using System.Utilities;
report 5693 "Delete Empty FA Registers"
{
Caption = 'Delete Empty FA Registers';
Permissions = TableData "FA Register" = rimd;
ProcessingOnly = true;
dataset
{
dataitem("FA Register"; "FA Register")
{
DataItemTableView = sorting("No.");
trigger OnAfterGetRecord()
begin
FALedgEntry.SetRange("Entry No.", "From Entry No.", "To Entry No.");
if FALedgEntry.FindFirst() then
CurrReport.Skip();
MaintenanceLedgEntry.SetRange("Entry No.", "From Maintenance Entry No.", "To Maintenance Entry No.");
if MaintenanceLedgEntry.FindFirst() then
CurrReport.Skip();
Window.Update(1, "No.");
Window.Update(2, SystemCreatedAt);
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);
if RequestFilterDate <> 0D then
SetRange(SystemCreatedAt, CreateDateTime(RequestFilterDate, 000000T), CreateDateTime(RequestFilterDate, 235959T));
end;
}
}
requestpage
{
layout
{
area(Content)
{
group(Options)
{
Caption = 'Options';
field(RequestFilterDate; RequestFilterDate)
{
Caption = 'Creation Date';
ToolTip = 'Creation Date of the G/L Register.';
}
}
}
}
actions
{
}
}
labels
{
}
var
FALedgEntry: Record "FA Ledger Entry";
MaintenanceLedgEntry: Record "Maintenance 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 FA 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
RequestFilterDate: Date;
procedure SetSkipConfirm()
begin
SkipConfirm := true;
end;
}