Page 2584 Dim Correct Posted Ledg Entr

Base Application, Microsoft.Finance.Dimension.Correction

src/Layers/W1/BaseApp/Finance/Dimension/Correction/DimCorrectPostedLedgEntr.Page.al373 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.GeneralLedger.Ledger;using System.Security.User;/// <summary>/// List part page displaying G/L entries after dimension correction posting. Shows the completed correction results with updated dimension values./// </summary>page 2584 "Dim Correct Posted Ledg Entr"{    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;                    ToolTip = 'Specifies the identifier for the entry. The number series for entries assigned the identifier.';                    trigger OnDrillDown()                    var                        GLEntry: Record "G/L Entry";                    begin                        if GLEntry.Get(Rec."Entry No.") then                            Page.Run(0, Rec);                    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;                    ToolTip = 'Specifies the ledger entry that is posted if you post in an additional reporting currency.';                    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(ShowSelectionCriteria)            {                ApplicationArea = All;                Caption = 'Show Selection Criteria';                Image = History;                ToolTip = 'View the filter criteria that was used to select the entries to correct.';                trigger OnAction()                var                    DimCorrectSelectionCriteria: Record "Dim Correct Selection Criteria";                    DimCorrectSelectionCriteriaPage: Page "Dim Correct Selection Criteria";                begin                    DimCorrectSelectionCriteria.SetRange("Dimension Correction Entry No.", DimensionCorrectionEntryNo);                    DimCorrectSelectionCriteriaPage.SetReadOnly();                    DimCorrectSelectionCriteriaPage.SetTableView(DimCorrectSelectionCriteria);                    DimCorrectSelectionCriteriaPage.RunModal();                end;            }        }    }    trigger OnFindRecord(Which: Text): Boolean    begin        if PreviewDisabled then begin            if Which = '+' then                LoadRecords(true);            // If filters have chaned load everythig again            if PreviousView <> Rec.GetView() then                RecordsLoaded := false;        end;        if not RecordsLoaded then begin            LoadRecords(false);            RecordsLoaded := true;            if Rec.FindFirst() then;        end;        if PreviewDisabled then            PreviousView := Rec.GetView();        exit(Rec.Find(Which));    end;    local procedure LoadRecords(Reversed: Boolean): Boolean    var        DimCorrectionEntryLog: Record "Dim Correction Entry Log";        LastDimCorrectionEntryLog: Record "Dim Correction Entry Log";        GLEntry: Record "G/L Entry";        DimensionCorrectionMgt: Codeunit "Dimension Correction Mgt";        Dimensions: Dictionary of [Text, Text];        FilterText: Text;        EntryIncluded: Boolean;    begin        if DimensionCorrectionEntryNo = 0 then            exit;        Rec.DeleteAll();        RecordCount := 0;        GLEntry.FilterGroup(4);        GLEntry.SetView(Rec.GetView());        GLEntry.SetCurrentKey("Entry No.");        GLEntry.Ascending(not Reversed);        DimCorrectionEntryLog.SetRange("Dimension Correction Entry No.", DimensionCorrectionEntryNo);        if DimCorrectionEntryLog.Count() < DimensionCorrectionMgt.GetFilterConditionsLimit() then begin            DimCorrectionEntryLog.FindSet();            repeat                if FilterText = '' then                    FilterText := StrSubstNo(FilterRangeTxt, DimCorrectionEntryLog."Start Entry No.", DimCorrectionEntryLog."End Entry No.")                else                    FilterText += '|' + StrSubstNo(FilterRangeTxt, DimCorrectionEntryLog."Start Entry No.", DimCorrectionEntryLog."End Entry No.");            until DimCorrectionEntryLog.Next() = 0;        end else begin            DimCorrectionEntryLog.FindFirst();            FilterText := Format(DimCorrectionEntryLog."Start Entry No.");            DimCorrectionEntryLog.FindLast();            FilterText := StrSubstNo(FilterRangeTxt, FilterText, DimCorrectionEntryLog."End Entry No.");        end;        GLEntry.SetFilter("Entry No.", FilterText);        if not GLEntry.FindSet() then            exit;        LastDimCorrectionEntryLog.SetRange("Dimension Correction Entry No.", DimensionCorrectionEntryNo);        LastDimCorrectionEntryLog.FindFirst();        DimCorrectionEntryLog.SetRange("Dimension Correction Entry No.", DimensionCorrectionEntryNo);        repeat            if DimCorrectionEntryLog.Count() > DimensionCorrectionMgt.GetFilterConditionsLimit() then begin                EntryIncluded := (GLEntry."Entry No." >= LastDimCorrectionEntryLog."Start Entry No.") and (GLEntry."Entry No." <= LastDimCorrectionEntryLog."End Entry No.");                if not EntryIncluded then begin                    DimCorrectionEntryLog.SetFilter("Start Entry No.", '<=%1', GLEntry."Entry No.");                    DimCorrectionEntryLog.SetFilter("End Entry No.", '>=%1', GLEntry."Entry No.");                    EntryIncluded := DimCorrectionEntryLog.FindFirst();                    if EntryIncluded then                        LastDimCorrectionEntryLog.Copy(DimCorrectionEntryLog);                end;            end else                EntryIncluded := true;            if EntryIncluded then begin                Rec.TransferFields(GLEntry, true);                if not Rec.Insert() then begin                    Dimensions.Add('Category', DimensionCorrectionTok);                    Dimensions.Add('DimCorrectionEntryNo', Format(DimensionCorrectionEntryNo));                    Dimensions.Add('GLEntryNo', Format(GLEntry."Entry No."));                    Session.LogMessage('0000EHB', DuplicateLedgerEntryFoundLbl, Verbosity::Error, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, Dimensions);                end;                RecordCount += 1;                if RecordCount > DimensionCorrectManagement.GetPreviewGLEntriesLimit() then begin                    PreviewDisabled := true;                    exit;                end;            end;        until GLEntry.Next() = 0;    end;    /// <summary>    /// Sets the dimension correction entry number for displaying posted G/L entries with corrected dimensions.    /// </summary>    /// <param name="NewDimensionCorrectionEntryNo">The dimension correction entry number to filter posted entries</param>    procedure SetDimensionCorrectionEntryNo(NewDimensionCorrectionEntryNo: Integer)    begin        if NewDimensionCorrectionEntryNo <> DimensionCorrectionEntryNo then begin            DimensionCorrectionEntryNo := NewDimensionCorrectionEntryNo;            DeselectAll();        end;    end;    local procedure DeselectAll()    begin        Rec.Reset();        Rec.DeleteALl();        PreviewDisabled := false;        Clear(Rec);        Clear(RecordsLoaded);        Clear(RecordCount);        Clear(PreviousView);    end;    var        DimensionCorrectManagement: Codeunit "Dimension Correction Mgt";        DimensionCorrectionEntryNo: Integer;        RecordsLoaded: Boolean;        RecordCount: Integer;        PreviewDisabled: Boolean;        PreviousView: Text;        DuplicateLedgerEntryFoundLbl: Label 'A duplicate ledger entry was found for the dimension correction.', Locked = true;        DimensionCorrectionTok: Label 'DimensionCorrection';        FilterRangeTxt: Label '%1..%2', Locked = true;}