Report 26 Copy Account Schedule

Base Application, Microsoft.Finance.FinancialReports

src/Layers/W1/BaseApp/Finance/FinancialReports/CopyAccountSchedule.Report.al202 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.Finance.FinancialReports;using System.Telemetry;/// <summary>/// Creates copy of existing account schedule with all associated line definitions./// Enables duplication of row structure for new financial report configurations./// </summary>report 26 "Copy Account Schedule"{    Caption = 'Copy Rows';    ProcessingOnly = true;    dataset    {        dataitem(SourceAccScheduleName; "Acc. Schedule Name")        {            DataItemTableView = sorting(Name) order(ascending);            trigger OnAfterGetRecord()            var                SourceAccScheduleLine: Record "Acc. Schedule Line";                AccScheduleName: Record "Acc. Schedule Name";            begin                AccScheduleName.Get(CopySourceAccScheduleName);                CreateNewAccountScheduleName(NewAccScheduleName, AccScheduleName);                SourceAccScheduleLine.SetRange("Schedule Name", AccScheduleName.Name);                if SourceAccScheduleLine.FindSet() then                    repeat                        CreateNewAccountScheduleLine(NewAccScheduleName, SourceAccScheduleLine);                    until SourceAccScheduleLine.Next() = 0;            end;            trigger OnPreDataItem()            begin                AssertNewAccountScheduleNameNotEmpty();                AssertNewAccountScheduleNameNotExisting();                AssertSourceAccountScheduleNameNotEmpty();                AssertSourceAccountScheduleNameExists(SourceAccScheduleName);            end;        }    }    requestpage    {        layout        {            area(content)            {                group(Options)                {                    Caption = 'Options';                    field(NewAccountScheduleName; NewAccScheduleName)                    {                        ApplicationArea = Basic, Suite;                        Caption = 'New Rows Definition Name';                        NotBlank = true;                        ToolTip = 'Specifies the name of the new rows definition after copying.';                    }                    field(SourceAccountScheduleName; CopySourceAccScheduleName)                    {                        ApplicationArea = Basic, Suite;                        Caption = 'Source Rows Definition Name';                        Enabled = false;                        NotBlank = true;                        ToolTip = 'Specifies the name of the existing rows definition to copy from.';                    }                }            }        }        actions        {        }        trigger OnOpenPage()        begin            AssertSourceAccountScheduleNameOnlyOne(SourceAccScheduleName);            if SourceAccScheduleName.FindFirst() then                CopySourceAccScheduleName := SourceAccScheduleName.Name;        end;    }    labels    {    }    trigger OnPostReport()    begin        Message(CopySuccessMsg);    end;    var        NewAccScheduleName: Code[10];        CopySuccessMsg: Label 'The new rows definition has been created successfully.';        MissingSourceErr: Label 'Could not find a rows definition with the specified name to copy from.';        NewNameExistsErr: Label 'The new rows definition already exists.';        NewNameMissingErr: Label 'You must specify a name for the new rows definition.';        CopySourceAccScheduleName: Code[10];        CopySourceNameMissingErr: Label 'You must specify a valid name for the source rows definition to copy from.';        MultipleSourcesErr: Label 'You can only copy one rows definition at a time.';        CopyEventTxt: Label 'Financial Report Row Definition copied: %1', Comment = '%1 = rows definition name', Locked = true;    /// <summary>    /// Returns the name of the newly created account schedule after copy operation.    /// </summary>    /// <returns>New account schedule name as Code[10]</returns>    procedure GetNewAccountScheduleName(): Code[10]    begin        exit(NewAccScheduleName);    end;    local procedure AssertNewAccountScheduleNameNotEmpty()    begin        if IsEmptyName(NewAccScheduleName) then            Error(NewNameMissingErr);    end;    local procedure AssertNewAccountScheduleNameNotExisting()    var        AccScheduleName: Record "Acc. Schedule Name";    begin        if AccScheduleName.Get(NewAccScheduleName) then            Error(NewNameExistsErr);    end;    local procedure CreateNewAccountScheduleName(NewName: Code[10]; FromAccScheduleName: Record "Acc. Schedule Name")    var        AccScheduleName: Record "Acc. Schedule Name";    begin        if AccScheduleName.Get(NewName) then            exit;        AccScheduleName.Init();        AccScheduleName.TransferFields(FromAccScheduleName);        AccScheduleName.Name := NewName;        AccScheduleName.Insert();        LogUsageTelemetry(FromAccScheduleName.Name, NewName);    end;    local procedure CreateNewAccountScheduleLine(NewName: Code[10]; FromAccScheduleLine: Record "Acc. Schedule Line")    var        AccScheduleLine: Record "Acc. Schedule Line";    begin        if AccScheduleLine.Get(NewName, FromAccScheduleLine."Line No.") then            exit;        AccScheduleLine.Init();        AccScheduleLine.TransferFields(FromAccScheduleLine);        AccScheduleLine."Schedule Name" := NewName;        AccScheduleLine.Insert();    end;    local procedure IsEmptyName(ScheduleName: Code[10]) IsEmpty: Boolean    begin        IsEmpty := ScheduleName = '';    end;    local procedure AssertSourceAccountScheduleNameNotEmpty()    begin        if IsEmptyName(CopySourceAccScheduleName) then            Error(CopySourceNameMissingErr);    end;    local procedure AssertSourceAccountScheduleNameExists(FromAccScheduleName: Record "Acc. Schedule Name")    begin        if not FromAccScheduleName.Get(CopySourceAccScheduleName) then            Error(MissingSourceErr);    end;    local procedure AssertSourceAccountScheduleNameOnlyOne(var FromAccScheduleName: Record "Acc. Schedule Name")    var        AccScheduleName: Record "Acc. Schedule Name";    begin        AccScheduleName.CopyFilters(FromAccScheduleName);        if AccScheduleName.Count > 1 then            Error(MultipleSourcesErr);    end;    local procedure LogUsageTelemetry(SourceCode: Code[10]; NewCode: Code[10])    var        FeatureTelemetry: Codeunit "Feature Telemetry";        TelemetryDimensions: Dictionary of [Text, Text];    begin        TelemetryDimensions.Add('ReportId', Format(CurrReport.ObjectId(false), 0, 9));        TelemetryDimensions.Add('ReportName', CurrReport.ObjectId(true));        TelemetryDimensions.Add('UseRequestPage', Format(CurrReport.UseRequestPage()));        TelemetryDimensions.Add('SourceRowDefinitionCode', SourceCode);        TelemetryDimensions.Add('NewRowDefinitionCode', NewCode);        FeatureTelemetry.LogUsage('0000OKV', 'Financial Report', StrSubstNo(CopyEventTxt, SourceCode), TelemetryDimensions);    end;}