Page 2583 Dim. Correct Ledger Entries

Base Application, Microsoft.Finance.Dimension.Correction

src/Layers/W1/BaseApp/Finance/Dimension/Correction/DimCorrectLedgerEntries.Page.al617 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.Dimension.Correction;using Microsoft.Finance.Dimension;using Microsoft.Finance.GeneralLedger.Ledger;using System.Automation;using System.Security.User;using System.Utilities;/// <summary>/// List part page displaying G/L entries selected for dimension correction. Shows entries that will be modified during the correction process./// </summary>page 2583 "Dim. Correct Ledger Entries"{    PageType = ListPart;    SourceTable = "G/L Entry";    SourceTableTemporary = true;    Editable = false;    InsertAllowed = false;    DeleteAllowed = false;    layout    {        area(Content)        {            repeater(Control1)            {                ShowCaption = false;                field("Entry No."; Rec."Entry No.")                {                    ApplicationArea = Basic, Suite;                    Editable = false;                    trigger OnDrillDown()                    var                        GLEntry: Record "G/L Entry";                    begin                        if GLEntry.Get(Rec."Entry No.") then                            Page.Run(0, GLEntry);                    end;                }                field("Posting Date"; Rec."Posting Date")                {                    ApplicationArea = Basic, Suite;                    Editable = false;                }                field("Document Type"; Rec."Document Type")                {                    ApplicationArea = Basic, Suite;                    Editable = false;                }                field("Document No."; Rec."Document No.")                {                    ApplicationArea = Basic, Suite;                    Editable = false;                }                field("G/L Account No."; Rec."G/L Account No.")                {                    ApplicationArea = Basic, Suite;                    Editable = false;                }                field("G/L Account Name"; Rec."G/L Account Name")                {                    ApplicationArea = Basic, Suite;                    DrillDown = false;                    Editable = false;                    Visible = false;                }                field(Description; Rec.Description)                {                    ApplicationArea = Basic, Suite;                }                field("Job No."; Rec."Job No.")                {                    ApplicationArea = Jobs;                    Editable = false;                    Visible = false;                }                field("Global Dimension 1 Code"; Rec."Global Dimension 1 Code")                {                    ApplicationArea = Dimensions;                    Editable = false;                    Visible = false;                }                field("Global Dimension 2 Code"; Rec."Global Dimension 2 Code")                {                    ApplicationArea = Dimensions;                    Editable = false;                    Visible = false;                }                field("IC Partner Code"; Rec."IC Partner Code")                {                    ApplicationArea = Intercompany;                    Editable = false;                    Visible = false;                }                field("Gen. Posting Type"; Rec."Gen. Posting Type")                {                    ApplicationArea = Basic, Suite;                    Editable = false;                }                field("Gen. Bus. Posting Group"; Rec."Gen. Bus. Posting Group")                {                    ApplicationArea = Basic, Suite;                    Editable = false;                    ToolTip = 'Specifies the vendor''s or customer''s trade type to link transactions made for this business partner with the appropriate ledger account according to the general posting setup.';                }                field("Gen. Prod. Posting Group"; Rec."Gen. Prod. Posting Group")                {                    ApplicationArea = Basic, Suite;                    Editable = false;                    ToolTip = 'Specifies the item''s product type to link transactions made for this item with the appropriate ledger account according to the general posting setup.';                }                field(Quantity; Rec.Quantity)                {                    ApplicationArea = Basic, Suite;                    Editable = false;                    Visible = false;                }                field("Additional-Currency Amount"; Rec."Additional-Currency Amount")                {                    ApplicationArea = Suite;                    Editable = false;                    Visible = false;                }                field("VAT Amount"; Rec."VAT Amount")                {                    ApplicationArea = Basic, Suite;                    Editable = false;                    Visible = false;                }                field("Bal. Account Type"; Rec."Bal. Account Type")                {                    ApplicationArea = Basic, Suite;                    Editable = false;                }                field("Bal. Account No."; Rec."Bal. Account No.")                {                    ApplicationArea = Basic, Suite;                    Editable = false;                    ToolTip = 'Specifies the number of the ledger, customer, vendor, or bank account that the balancing entry is posted to, such as a cash account for cash purchases.';                }                field("User ID"; Rec."User ID")                {                    ApplicationArea = Basic, Suite;                    Editable = false;                    Visible = false;                    trigger OnDrillDown()                    var                        UserMgt: Codeunit "User Management";                    begin                        UserMgt.DisplayUserInformation(Rec."User ID");                    end;                }                field("Source Code"; Rec."Source Code")                {                    ApplicationArea = Suite;                    Editable = false;                    Visible = false;                }                field("Reason Code"; Rec."Reason Code")                {                    ApplicationArea = Suite;                    Editable = false;                    Visible = false;                }                field(Reversed; Rec.Reversed)                {                    ApplicationArea = Basic, Suite;                    Editable = false;                    Visible = false;                }                field("Reversed by Entry No."; Rec."Reversed by Entry No.")                {                    ApplicationArea = Basic, Suite;                    Editable = false;                    Visible = false;                }                field("Reversed Entry No."; Rec."Reversed Entry No.")                {                    ApplicationArea = Basic, Suite;                    Editable = false;                    Visible = false;                }                field("FA Entry Type"; Rec."FA Entry Type")                {                    ApplicationArea = FixedAssets;                    Editable = false;                    Visible = false;                }                field("FA Entry No."; Rec."FA Entry No.")                {                    ApplicationArea = FixedAssets;                    Editable = false;                    Visible = false;                }                field("Dimension Set ID"; Rec."Dimension Set ID")                {                    ApplicationArea = Dimensions;                    Editable = false;                    Visible = false;                }                field("External Document No."; Rec."External Document No.")                {                    ApplicationArea = Basic, Suite;                    Editable = false;                }            }        }    }    actions    {        area(Processing)        {            action(AddByTransaction)            {                ApplicationArea = All;                Caption = 'Add Related Entries';                Image = AddAction;                ToolTip = 'Find and add all entries that are related to the selected entry.';                trigger OnAction()                var                    GLEntry: Record "G/L Entry";                    DimCorrectSelectionCriteria: Record "Dim Correct Selection Criteria";                    GLEntryRecordRef: RecordRef;                begin                    VerifyCanChangePart();                    if Rec."Transaction No." = 0 then                        Error(NoRelatedEntriesErr);                    GLEntry.SetRange("Transaction No.", Rec."Transaction No.");                    if not (GLEntry.Count() > 1) then                        Error(NoRelatedEntriesErr);                    GLEntryRecordRef.GetTable(GLEntry);                    DimensionCorrectionMgt.InsertNewDimCorrectSelectionCriteria(GLEntryRecordRef, DimCorrectSelectionCriteria."Filter Type"::"Related Entries", DimCorrectSelectionCriteria, DimensionCorrectionEntryNo);                    DimensionCorrectionMgt.ReloadDimensionChangesTable(DimensionCorrectionEntryNo);                    Commit();                    LoadRecordsForSelection(DimCorrectSelectionCriteria);                    CurrPage.Update(false);                end;            }            action(AddByFilter)            {                ApplicationArea = All;                Caption = 'Add by Filter';                Image = FilterLines;                ToolTip = 'Add new entries to the correction by using filters.';                trigger OnAction()                var                    DimCorrectSelectionCriteria: Record "Dim Correct Selection Criteria";                    DummyGLEntry: Record "G/L Entry";                    RequestPageParametersHelper: Codeunit "Request Page Parameters Helper";                    TempBlob: Codeunit "Temp Blob";                    GLEntryRecordRef: RecordRef;                    RequestFilterPageBuilder: FilterPageBuilder;                    TempBlobOutStream: OutStream;                    RequestPageView: Text;                begin                    VerifyCanChangePart();                    RequestPageParametersHelper.BuildDynamicRequestPage(RequestFilterPageBuilder, SelectLedgerEntriesToCorrectLbl, Database::"G/L Entry");                    if not RequestFilterPageBuilder.RunModal() then                        exit;                    RequestPageView := RequestPageParametersHelper.GetViewFromDynamicRequestPage(RequestFilterPageBuilder, SelectLedgerEntriesToCorrectLbl, Database::"G/L Entry");                    GLEntryRecordRef.Open(Database::"G/L Entry");                    TempBlob.CreateOutStream(TempBlobOutStream);                    TempBlobOutStream.WriteText(RequestPageView);                    RequestPageParametersHelper.ConvertParametersToFilters(GLEntryRecordRef, TempBlob);                    if GLEntryRecordRef.GetView() = DummyGLEntry.GetView() then                        Error(ViewWasNotModifiedErr);                    DimensionCorrectionMgt.InsertNewDimCorrectSelectionCriteria(GLEntryRecordRef, DimCorrectSelectionCriteria."Filter Type"::"Custom Filter", DimCorrectSelectionCriteria, DimensionCorrectionEntryNo);                    DimensionCorrectionMgt.ReloadDimensionChangesTable(DimensionCorrectionEntryNo);                    Commit();                    LoadRecordsForSelection(DimCorrectSelectionCriteria);                    CurrPage.Update(false);                end;            }            action(SelectManually)            {                ApplicationArea = All;                Caption = 'Select Manually';                Image = PickLines;                ToolTip = 'Select entries to correct manually.';                trigger OnAction()                var                    GLEntry: Record "G/L Entry";                    DimCorrectSelectionCriteria: Record "Dim Correct Selection Criteria";                    GeneralLedgerEntries: Page "General Ledger Entries";                    GLEntryRecordRef: RecordRef;                begin                    VerifyCanChangePart();                    GeneralLedgerEntries.LookupMode(true);                    if GeneralLedgerEntries.RunModal() = Action::LookupOK then begin                        GeneralLedgerEntries.SetSelectionFilter(GLEntry);                        GLEntry.SetLoadFields("Entry No.");                        GLEntry.SetCurrentKey("Entry No.");                        GLEntry.Ascending(true);                        GLEntry.FindFirst();                        if GLEntry.Count() > 1000 then                            Error(TooManyGLEntriesSelectedErr);                        DimensionCorrectionMgt.TransferSelectionFilterToRecordRef(GLEntry, GLEntryRecordRef);                        DimensionCorrectionMgt.InsertNewDimCorrectSelectionCriteria(GLEntryRecordRef, DimCorrectSelectionCriteria."Filter Type"::Manual, DimCorrectSelectionCriteria, DimensionCorrectionEntryNo);                        DimensionCorrectionMgt.ReloadDimensionChangesTable(DimensionCorrectionEntryNo);                        Commit();                        LoadRecordsForSelection(DimCorrectSelectionCriteria);                        CurrPage.Update(false);                    end;                end;            }            action(AddByDimension)            {                ApplicationArea = All;                Caption = 'Add by Dimension';                Image = MapDimensions;                ToolTip = 'Select entries to correct based on dimension values.';                trigger OnAction()                var                    TempDimensionSetEntry: Record "Dimension Set Entry" temporary;                    DimCorrectSelectionCriteria: Record "Dim Correct Selection Criteria";                    GLEntry: Record "G/L Entry";                    FindbyDimension: Page "Dim Corr Find by Dimension";                    GLEntryRecordRef: RecordRef;                    DimensionSetIDFieldRef: FieldRef;                    SelectionFilterText: Text;                begin                    VerifyCanChangePart();                    FindbyDimension.LookupMode(true);                    if FindbyDimension.RunModal() <> Action::LookupOK then                        exit;                    FindbyDimension.GetRecords(TempDimensionSetEntry);                    GLEntryRecordRef.Open(Database::"G/L Entry");                    DimensionSetIDFieldRef := GLEntryRecordRef.Field(GLEntry.FieldNo("Dimension Set ID"));                    SelectionFilterText := DimensionCorrectionMgt.GetSelectedDimensionSetIDsFilter(TempDimensionSetEntry);                    if SelectionFilterText = '' then                        exit;                    DimensionSetIDFieldRef.SetFilter(SelectionFilterText);                    DimensionCorrectionMgt.InsertNewDimCorrectSelectionCriteria(GLEntryRecordRef, DimCorrectSelectionCriteria."Filter Type"::"By Dimension", DimCorrectSelectionCriteria, DimensionCorrectionEntryNo);                    DimensionCorrectionMgt.ReloadDimensionChangesTable(DimensionCorrectionEntryNo);                    Commit();                    LoadRecordsForSelection(DimCorrectSelectionCriteria);                    CurrPage.Update(false);                end;            }            action(ExcludeEntries)            {                ApplicationArea = All;                Caption = 'Remove entries';                Image = RemoveLine;                ToolTip = 'Exclude selected entries from the dimension correction.';                trigger OnAction()                var                    DimCorrectSelectionCriteria: Record "Dim Correct Selection Criteria";                    TempGLEntry: Record "G/L Entry" temporary;                    GLEntryRecordRef: RecordRef;                begin                    VerifyCanChangePart();                    TempGLEntry.Copy(Rec);                    CurrPage.SetSelectionFilter(Rec);                    if Rec.Count() > 5000 then                        Error(TooManyExcludedEntriesErr);                    DimensionCorrectionMgt.TransferSelectionFilterToRecordRef(Rec, GLEntryRecordRef);                    DimensionCorrectionMgt.InsertNewDimCorrectSelectionCriteria(GLEntryRecordRef, DimCorrectSelectionCriteria."Filter Type"::Excluded, DimCorrectSelectionCriteria, DimensionCorrectionEntryNo);                    DimensionCorrectionMgt.ReloadDimensionChangesTable(DimensionCorrectionEntryNo);                    Commit();                    Rec.DeleteAll();                    Rec.Copy(TempGLEntry);                    CurrPage.Update(false);                end;            }            action(ManageSelectionCriteria)            {                ApplicationArea = All;                Caption = 'Manage Selection Criteria';                Image = History;                ToolTip = 'See criteria that was used to select the entries for correction. This page will allow you to undo some steps.';                trigger OnAction()                var                    DimCorrectSelectionCriteria: Record "Dim Correct Selection Criteria";                    DimCorrectSelectionCriteriaPage: Page "Dim Correct Selection Criteria";                    DeletedEntries: List of [Guid];                    DeletedEntrySystemId: Guid;                begin                    VerifyCanChangePart();                    DimCorrectSelectionCriteria.SetRange("Dimension Correction Entry No.", DimensionCorrectionEntryNo);                    DimCorrectSelectionCriteriaPage.SetTableView(DimCorrectSelectionCriteria);                    DimCorrectSelectionCriteriaPage.RunModal();                    DimCorrectSelectionCriteriaPage.GetEntriesToDelete(DeletedEntries);                    if DeletedEntries.Count() = 0 then                        exit;                    foreach DeletedEntrySystemId in DeletedEntries do                        if DimCorrectSelectionCriteria.GetBySystemId(DeletedEntrySystemId) then                            DimCorrectSelectionCriteria.Delete();                    DimensionCorrectionMgt.ReloadDimensionChangesTable(DimensionCorrectionEntryNo);                    Commit();                    DeselectAll();                    LoadRecords();                    CurrPage.Update(false);                end;            }        }    }    trigger OnFindRecord(Which: Text): Boolean    begin        if DimensionCorrectionEntryNo <= 0 then            exit(false);        if PreviewDisabled then begin            if Which = '+' then                SendFindLastNotSupportedNotification();            // If filters have chaned load everythig again            if PreviousView <> Rec.GetView() then                RecordsLoaded := false;        end;        if not RecordsLoaded then begin            LoadRecords();            RecordsLoaded := true;            if Rec.FindFirst() then;        end;        if PreviewDisabled then            PreviousView := Rec.GetView();        exit(Rec.Find(Which));    end;    local procedure LoadRecords(): Boolean    var        OriginalView: Text;    begin        Rec.DeleteAll();        UpdateRecordCount(0);        OriginalView := Rec.GetView();        LoadPage();        Rec.SetView(OriginalView);    end;    local procedure SendFindLastNotSupportedNotification()    var        FindLastNotSupportedOnLargeReconciliationNotification: Notification;    begin        FindLastNotSupportedOnLargeReconciliationNotification.Id := GetFindLastNotificationIsNotSupported();        if FindLastNotSupportedOnLargeReconciliationNotification.Recall() then;        FindLastNotSupportedOnLargeReconciliationNotification.Message := FindLastNotSupportedTooManyEntriesLbl;        FindLastNotSupportedOnLargeReconciliationNotification.Scope := NotificationScope::LocalScope;        FindLastNotSupportedOnLargeReconciliationNotification.Send();    end;    local procedure LoadPage()    var        DimCorrectSelectionCriteria: Record "Dim Correct Selection Criteria";        ExcludedEntriesDimCorrectSelectionCriteria: Record "Dim Correct Selection Criteria";        ExcluedEntriesExist: Boolean;    begin        DimCorrectSelectionCriteria.SetRange("Dimension Correction Entry No.", DimensionCorrectionEntryNo);        DimCorrectSelectionCriteria.SetFilter("Filter Type", '<>%1', DimCorrectSelectionCriteria."Filter Type"::Excluded);        if not DimCorrectSelectionCriteria.FindSet() then            exit;        ExcludedEntriesDimCorrectSelectionCriteria.SetRange("Dimension Correction Entry No.", DimensionCorrectionEntryNo);        ExcludedEntriesDimCorrectSelectionCriteria.SetRange("Filter Type", DimCorrectSelectionCriteria."Filter Type"::Excluded);        ExcluedEntriesExist := not ExcludedEntriesDimCorrectSelectionCriteria.IsEmpty();        repeat            LoadRecordsForSelection(DimCorrectSelectionCriteria, ExcludedEntriesDimCorrectSelectionCriteria, ExcluedEntriesExist);        until DimCorrectSelectionCriteria.Next() = 0;    end;    local procedure DeselectAll()    begin        Rec.Reset();        Rec.DeleteALl();        PreviewDisabled := false;        Clear(Rec);        Clear(RecordCount);        Clear(RecordsLoaded);        Clear(PreviousView);    end;    local procedure LoadRecordsForSelection(var DimCorrectSelectionCriteria: Record "Dim Correct Selection Criteria")    var        ExcludedEntriesDimCorrectSelectionCriteria: Record "Dim Correct Selection Criteria";        ExcluedEntriesExist: Boolean;    begin        if RecordCount > DimensionCorrectionMgt.GetPreviewGLEntriesLimit() then            exit;        ExcludedEntriesDimCorrectSelectionCriteria.SetRange("Dimension Correction Entry No.", DimensionCorrectionEntryNo);        ExcludedEntriesDimCorrectSelectionCriteria.SetRange("Filter Type", DimCorrectSelectionCriteria."Filter Type"::Excluded);        ExcluedEntriesExist := not ExcludedEntriesDimCorrectSelectionCriteria.IsEmpty();        LoadRecordsForSelection(DimCorrectSelectionCriteria, ExcludedEntriesDimCorrectSelectionCriteria, ExcluedEntriesExist);        if Rec.FindFirst() then;    end;    local procedure LoadRecordsForSelection(var DimCorrectSelectionCriteria: Record "Dim Correct Selection Criteria"; var ExcludedEntriesDimCorrectSelectionCriteria: Record "Dim Correct Selection Criteria"; ExcluedEntriesExist: Boolean)    var        GLEntry: Record "G/L Entry";        InsertEntry: Boolean;        SelectionFilter: Text;    begin        if RecordCount > DimensionCorrectionMgt.GetPreviewGLEntriesLimit() then            exit;        DimCorrectSelectionCriteria.GetSelectionFilter(SelectionFilter);        GLEntry.FilterGroup(4);        GLEntry.SetView(Rec.GetView());        GLEntry.FilterGroup(0);        GLEntry.SetView(SelectionFilter);        if GLEntry.FindSet() then            repeat                InsertEntry := not ExcluedEntriesExist;                if not InsertEntry then                    InsertEntry := not DimensionCorrectionMgt.IsEntryExclued(GLEntry, ExcludedEntriesDimCorrectSelectionCriteria);                if InsertEntry then                    InsertEntry := not Rec.GET(GLEntry."Entry No.");                if InsertEntry then begin                    Rec.TransferFields(GLEntry, true);                    Rec.Insert();                    UpdateRecordCount(RecordCount + 1);                    if RecordCount > DimensionCorrectionMgt.GetPreviewGLEntriesLimit() then begin                        PreviewDisabled := true;                        Session.LogMessage('0000EHL', StrSubstNo(LargeCorrectionTelemetryLbl, DimensionCorrectionEntryNo), Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', DimensionCorrectionTok);                        exit;                    end;                end;            until GLEntry.Next() = 0;    end;    /// <summary>    /// Sets the dimension correction entry number for filtering and processing G/L entries.    /// </summary>    /// <param name="NewDimensionCorrectionEntryNo">The dimension correction entry number to associate with the ledger entries</param>    procedure SetDimensionCorrectionEntryNo(NewDimensionCorrectionEntryNo: Integer)    begin        if NewDimensionCorrectionEntryNo <> DimensionCorrectionEntryNo then begin            DimensionCorrectionEntryNo := NewDimensionCorrectionEntryNo;            DeselectAll();        end;    end;    local procedure UpdateRecordCount(NewRecordCount: Integer)    begin        RecordCount := NewRecordCount;        if not PreviewDisabled then            PreviewDisabled := RecordCount > DimensionCorrectionMgt.GetPreviewGLEntriesLimit();    end;    local procedure GetFindLastNotificationIsNotSupported(): Guid    begin        exit('b00322cc-7367-42ef-b0cc-708f1a347f48');    end;    local procedure VerifyCanChangePart()    begin        DimensionCorrectionMgt.VerifyCanModifyDraftEntry(DimensionCorrectionEntryNo);    end;    var        DimensionCorrectionMgt: Codeunit "Dimension Correction Mgt";        DimensionCorrectionEntryNo: Integer;        RecordCount: Integer;        RecordsLoaded: Boolean;        PreviewDisabled: Boolean;        PreviousView: Text;        SelectLedgerEntriesToCorrectLbl: Label 'Ledger Entries';        NoRelatedEntriesErr: Label 'No entries are related to the selected ledger entry.';        FindLastNotSupportedTooManyEntriesLbl: Label 'There are more entries than the list can show. Filter the list to find fewer entries.';        LargeCorrectionTelemetryLbl: Label 'Large dimension correction created. Dimension Correction Entry No. %1.', Locked = true, Comment = '%1 Dimension Correction Entry No.';        DimensionCorrectionTok: Label 'DimensionCorrection';        TooManyGLEntriesSelectedErr: Label 'You have selected too many G/L entries. Use filters to reduce the number of entries.';        ViewWasNotModifiedErr: Label 'You have not entered any selection criteria.';        TooManyExcludedEntriesErr: Label 'You have excluded too many entries. Consider updating the filter or other selection criteria.';}