Page 542 Default Dimensions-Multiple
src/Layers/W1/BaseApp/Finance/Dimension/DefaultDimensionsMultiple.Page.al546 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;using Microsoft.HumanResources.Employee;/// <summary>/// Manages default dimensions for multiple master data records simultaneously./// Enables bulk configuration of common default dimension settings across selected entities./// </summary>/// <remarks>/// Supports multi-record dimension setup with common dimension value assignment and posting type configuration./// Provides extensibility through integration events for custom multi-record dimension processing./// </remarks>page 542 "Default Dimensions-Multiple"{ Caption = 'Default Dimensions-Multiple'; DataCaptionExpression = Rec.GetCaption(); PageType = List; SourceTable = "Default Dimension"; SourceTableTemporary = true; SaveValues = true; layout { area(content) { repeater(Control1) { ShowCaption = false; field("Dimension Code"; Rec."Dimension Code") { ApplicationArea = Dimensions; trigger OnValidate() begin if (xRec."Dimension Code" <> '') and (xRec."Dimension Code" <> Rec."Dimension Code") then Error(CannotRenameErr, Rec.TableCaption); end; } field("Dimension Value Code"; Rec."Dimension Value Code") { ApplicationArea = Dimensions; } field("Value Posting"; Rec."Value Posting") { ApplicationArea = Dimensions; trigger OnValidate() begin UpdateAllowedValues(); end; } field(AllowedValuesFilter; Rec."Allowed Values Filter") { ApplicationArea = Dimensions; trigger OnAssistEdit() var DimMgt: Codeunit DimensionManagement; begin Rec.TestField("Dimension Code"); Rec.TestField("Value Posting", Rec."Value Posting"::"Code Mandatory"); if Rec."Allowed Values Filter" <> '' then begin TempDimValuePerAccount.Reset(); DimMgt.SyncTempDimValuePerAccountWithDimValues(Rec, TempDimValuePerAccount); Rec.UpdateDimValuesPerAccountFromAllowedValuesFilter(TempDimValuePerAccount); end; DimMgt.OpenAllowedDimValuesPerAccountDimMultiple(Rec, TempDimValuePerAccount); Rec."Allowed Values Filter" := CopyStr(Rec.GetFullAllowedValuesFilter(TempDimValuePerAccount), 1, MaxStrLen(Rec."Allowed Values Filter")); UpdateTempDimValuePerAcount(TempDimValuePerAccount); CurrPage.Update(); end; trigger OnValidate() var DimMgt: Codeunit DimensionManagement; begin TempDimValuePerAccount.Reset(); DimMgt.SyncTempDimValuePerAccountWithDimValues(Rec, TempDimValuePerAccount); Rec.UpdateDimValuesPerAccountFromAllowedValuesFilter(TempDimValuePerAccount); UpdateTempDimValuePerAcount(TempDimValuePerAccount); end; } } } } actions { } trigger OnAfterGetRecord() begin DimensionValueCodeOnFormat(Format(Rec."Dimension Value Code")); ValuePostingOnFormat(Format(Rec."Value Posting")); end; trigger OnDeleteRecord(): Boolean begin Rec."Multi Selection Action" := Rec."Multi Selection Action"::Delete; Rec.Modify(); exit(false); end; trigger OnInit() begin CurrPage.LookupMode := true; end; trigger OnInsertRecord(BelowxRec: Boolean): Boolean begin Rec.SetRange("Dimension Code", Rec."Dimension Code"); if not Rec.Find('-') and (Rec."Dimension Code" <> '') then begin Rec."Multi Selection Action" := Rec."Multi Selection Action"::Change; Rec.Insert(); end; Rec.SetRange("Dimension Code"); exit(false); end; trigger OnModifyRecord(): Boolean begin Rec."Multi Selection Action" := Rec."Multi Selection Action"::Change; Rec.Modify(); exit(false); end; trigger OnOpenPage() begin GetDefaultDim(); end; trigger OnQueryClosePage(CloseAction: Action): Boolean begin if (CloseAction = ACTION::LookupOK) then LookupOKOnPush(); DeleteDefaultDim(); end; var TempDimValuePerAccount: Record "Dim. Value per Account" temporary; TempDimValuePerAccount2: Record "Dim. Value per Account" temporary;#pragma warning disable AA0470 CannotRenameErr: Label 'You cannot rename a %1.';#pragma warning restore AA0470#pragma warning disable AA0074 Text001: Label '(Conflict)';#pragma warning restore AA0074 TempDefaultDim2: Record "Default Dimension" temporary; TempDefaultDim3: Record "Default Dimension" temporary; TotalRecNo: Integer; TableIDNo: Integer; /// <summary> /// Clears all entries from the temporary default dimension table. /// Resets the multi-record dimension configuration state for new selection. /// </summary> procedure ClearTempDefaultDim() begin TempDefaultDim2.DeleteAll(); end; local procedure SetCommonDefaultDim() var DefaultDim: Record "Default Dimension"; begin Rec.SetRange("Multi Selection Action", Rec."Multi Selection Action"::Change); if Rec.Find('-') then repeat if TempDefaultDim3.Find('-') then repeat if DefaultDim.Get( TempDefaultDim3."Table ID", TempDefaultDim3."No.", Rec."Dimension Code") then begin DefaultDim."Dimension Code" := Rec."Dimension Code"; DefaultDim."Dimension Value Code" := Rec."Dimension Value Code"; DefaultDim."Value Posting" := Rec."Value Posting"; UpdateDimValuePerAccount(DefaultDim); OnBeforeSetCommonDefaultCopyFields(DefaultDim, Rec); DefaultDim.Modify(true); end else begin DefaultDim.Init(); DefaultDim."Table ID" := TempDefaultDim3."Table ID"; DefaultDim."No." := TempDefaultDim3."No."; DefaultDim."Dimension Code" := Rec."Dimension Code"; DefaultDim."Dimension Value Code" := Rec."Dimension Value Code"; DefaultDim."Value Posting" := Rec."Value Posting"; UpdateDimValuePerAccount(DefaultDim); OnBeforeSetCommonDefaultCopyFields(DefaultDim, Rec); DefaultDim.Insert(true); end; OnSetCommonDefaultDimOnBeforeNextTempDefaultDim3(Rec, TempDefaultDim3) until TempDefaultDim3.Next() = 0; until Rec.Next() = 0; end; local procedure UpdateDimValuePerAccount(var DefaultDim: Record "Default Dimension") var DimValuePerAccount: Record "Dim. Value per Account"; begin if Rec."Value Posting" <> Rec."Value Posting"::"Code Mandatory" then exit; DefaultDim."Allowed Values Filter" := Rec."Allowed Values Filter"; TempDimValuePerAccount.Reset(); TempDimValuePerAccount.SetRange("Dimension Code", DefaultDim."Dimension Code"); TempDimValuePerAccount.SetRange("No.", DefaultDim."No."); if TempDimValuePerAccount.FindSet() then repeat if DimValuePerAccount.Get(DefaultDim."Table ID", DefaultDim."No.", DefaultDim."Dimension Code", TempDimValuePerAccount."Dimension Value Code") then begin DimValuePerAccount.Allowed := TempDimValuePerAccount.Allowed; DimValuePerAccount.Modify(); end else begin DimValuePerAccount.Init(); DimValuePerAccount."Table ID" := DefaultDim."Table ID"; DimValuePerAccount."No." := DefaultDim."No."; DimValuePerAccount."Dimension Code" := DefaultDim."Dimension Code"; DimValuePerAccount."Dimension Value Code" := TempDimValuePerAccount."Dimension Value Code"; DimValuePerAccount.Allowed := TempDimValuePerAccount.Allowed; DimValuePerAccount.Insert(); end; until TempDimValuePerAccount.Next() = 0; end; local procedure UpdateAllowedValues() begin Rec.ClearAllowedValuesFilter(TempDimValuePerAccount); if Rec."Value Posting" = Rec."Value Posting"::"Code Mandatory" then begin CreateDimValuesPerAccount(); Rec."Allowed Values Filter" := Rec.GetAllowedValuesFilter(); end; end; local procedure CreateDimValuesPerAccount() var DimValue: Record "Dimension Value"; begin DimValue.SetRange("Dimension Code", Rec."Dimension Code"); if DimValue.FindSet() then repeat CreateDimValuePerAccountFromDimValue2(DimValue); until DimValue.Next() = 0; end; local procedure CreateDimValuePerAccountFromDimValue2(DimValue: Record "Dimension Value") begin if TempDefaultDim3.FindSet() then repeat TempDimValuePerAccount.Init(); TempDimValuePerAccount."Dimension Code" := DimValue."Dimension Code"; TempDimValuePerAccount."Dimension Value Code" := DimValue.Code; TempDimValuePerAccount."Table ID" := TempDefaultDim3."Table ID"; TempDimValuePerAccount."No." := TempDefaultDim3."No."; TempDimValuePerAccount.Insert(); until TempDefaultDim3.Next() = 0; end; /// <summary> /// Copies default dimensions from a specified master data record to the temporary dimension collection. /// Enables dimension inheritance and bulk processing for multi-record dimension operations. /// </summary> /// <param name="TableID">Table ID of the source master data record</param> /// <param name="No">Record number of the source master data record</param> procedure CopyDefaultDimToDefaultDim(TableID: Integer; No: Code[20]) var DefaultDim: Record "Default Dimension"; begin TotalRecNo := TotalRecNo + 1; TempDefaultDim3."Table ID" := TableID; TempDefaultDim3."No." := No; TempDefaultDim3.Insert(); TableIDNo := TableID; DefaultDim.SetRange("Table ID", TableID); DefaultDim.SetRange("No.", No); if DefaultDim.Find('-') then repeat TempDefaultDim2 := DefaultDim; TempDefaultDim2.Insert(); if DefaultDim."Value Posting" = DefaultDim."Value Posting"::"Code Mandatory" then CopyDefaultDimPerAccountToDefaultDimDimPerAccount(DefaultDim); until DefaultDim.Next() = 0; end; local procedure CopyDefaultDimPerAccountToDefaultDimDimPerAccount(DefaultDim: Record "Default Dimension") var DimValuePerAccount: Record "Dim. Value per Account"; begin DimValuePerAccount.SetRange("Table ID", DefaultDim."Table ID"); DimValuePerAccount.SetRange("No.", DefaultDim."No."); DimValuePerAccount.SetRange("Dimension Code", DefaultDim."Dimension Code"); if DimValuePerAccount.FindSet() then repeat TempDimValuePerAccount2 := DimValuePerAccount; TempDimValuePerAccount2.Insert(); until DimValuePerAccount.Next() = 0; end; local procedure GetDefaultDim() var Dim: Record Dimension; RecNo: Integer; begin Rec.Reset(); Rec.DeleteAll(); if Dim.Find('-') then repeat RecNo := 0; TempDefaultDim2.SetRange("Dimension Code", Dim.Code); Rec.SetRange("Dimension Code", Dim.Code); if TempDefaultDim2.Find('-') then repeat if Rec.FindFirst() then begin if Rec."Dimension Value Code" <> TempDefaultDim2."Dimension Value Code" then if (Rec."Multi Selection Action" <> 10) and (Rec."Multi Selection Action" <> 21) then begin Rec."Multi Selection Action" := Rec."Multi Selection Action" + 10; Rec."Dimension Value Code" := ''; end; if Rec."Value Posting" <> TempDefaultDim2."Value Posting" then if (Rec."Multi Selection Action" <> 11) and (Rec."Multi Selection Action" <> 21) then begin Rec."Multi Selection Action" := Rec."Multi Selection Action" + 11; Rec."Value Posting" := Rec."Value Posting"::" "; end; OnGetDefaultDimOnBeforeModify(Rec, TempDefaultDim2); Rec.Modify(); RecNo := RecNo + 1; end else begin Rec := TempDefaultDim2; Rec.Insert(); RecNo := RecNo + 1; end; if Rec."Value Posting" = Rec."Value Posting"::"Code Mandatory" then FillDimValuePerAccountBuffer(); until TempDefaultDim2.Next() = 0; if Rec.Find('-') and (RecNo <> TotalRecNo) then if (Rec."Multi Selection Action" <> 10) and (Rec."Multi Selection Action" <> 21) then begin Rec."Multi Selection Action" := Rec."Multi Selection Action" + 10; Rec."Dimension Value Code" := ''; Rec.Modify(); end; until Dim.Next() = 0; Rec.Reset(); Rec.SetCurrentKey("Dimension Code"); Rec.SetFilter("Multi Selection Action", '<>%1', Rec."Multi Selection Action"::Delete); end; local procedure FillDimValuePerAccountBuffer() begin TempDimValuePerAccount2.SetRange("Table ID", TempDefaultDim2."Table ID"); TempDimValuePerAccount2.SetRange("No.", TempDefaultDim2."No."); TempDimValuePerAccount2.SetRange("Dimension Code", TempDefaultDim2."Dimension Code"); if TempDimValuePerAccount2.FindSet() then repeat TempDimValuePerAccount := TempDimValuePerAccount2; TempDimValuePerAccount.Insert(); until TempDimValuePerAccount2.Next() = 0; end; local procedure LookupOKOnPush() begin SetCommonDefaultDim(); end; local procedure DimensionValueCodeOnFormat(Text: Text[1024]) begin if Rec."Dimension Code" <> '' then if (Rec."Multi Selection Action" = 10) or (Rec."Multi Selection Action" = 21) then Text := Text001; end; local procedure ValuePostingOnFormat(Text: Text[1024]) begin if Rec."Dimension Code" <> '' then if (Rec."Multi Selection Action" = 11) or (Rec."Multi Selection Action" = 21) then Text := Text001; end; /// <summary> /// Integration event raised before copying field values during common default dimension setup. /// Enables customization of field assignment logic for multi-record dimension operations. /// </summary> /// <param name="DefaultDimension">Target default dimension record being modified</param> /// <param name="FromDefaultDimension">Source default dimension record providing field values</param> [IntegrationEvent(false, false)] local procedure OnBeforeSetCommonDefaultCopyFields(var DefaultDimension: Record "Default Dimension"; FromDefaultDimension: Record "Default Dimension") begin end; /// <summary> /// Sets up multi-record dimension processing for a collection of master data records. /// Enables bulk default dimension operations across multiple records of the same table type. /// </summary> /// <param name="MasterRecord">Master data record variant containing selected records</param> /// <param name="NoField">Field number of the record identifier field</param> procedure SetMultiRecord(MasterRecord: Variant; NoField: Integer) var MasterRecordRef: RecordRef; NoFieldRef: FieldRef; No: Code[20]; begin OnBeforeSetMultiRecord(MasterRecord); ClearTempDefaultDim(); MasterRecordRef.GetTable(MasterRecord); NoFieldRef := MasterRecordRef.Field(NoField); if MasterRecordRef.FindSet() then repeat No := NoFieldRef.Value(); CopyDefaultDimToDefaultDim(MasterRecordRef.Number, No); until MasterRecordRef.Next() = 0; end; /// <summary> /// Sets up multi-record dimension processing specifically for employee records. /// Deprecated method maintained for backwards compatibility - use SetMultiRecord instead. /// </summary> /// <param name="Employee">Employee record set for bulk dimension processing</param> procedure SetMultiEmployee(var Employee: Record Employee) begin //DEPRECATED - TO BE REMOVED FOR FALL 19 ClearTempDefaultDim(); if Employee.Find('-') then repeat CopyDefaultDimToDefaultDim(Database::Employee, Employee."No."); until Employee.Next() = 0; end; local procedure UpdateTempDimValuePerAcount(var DimValuePerAcc: Record "Dim. Value per Account") var TempDimValuePerAcc3: Record "Dim. Value per Account" temporary; begin InsertTempDimValuePerAccountAfterChanges(TempDimValuePerAcc3, DimValuePerAcc); if TempDimValuePerAcc3.FindSet() then repeat UpdateTempDimValuePerAccountAfterChanges(TempDimValuePerAcc3, DimValuePerAcc); until TempDimValuePerAcc3.Next() = 0; end; local procedure GetTableIdNo(TableID1: Integer; TableID2: Integer): Integer begin if TableID1 = 0 then exit(TableID2); exit(TableID1); end; local procedure InsertTempDimValuePerAccountAfterChanges(var TempDimValuePerAcc3: Record "Dim. Value per Account"; var DimValuePerAcc: Record "Dim. Value per Account") begin DimValuePerAcc.Reset(); DimValuePerAcc.SetRange("Table ID", Rec."Table ID"); DimValuePerAcc.SetRange("No.", Rec."No."); DimValuePerAcc.SetRange("Dimension Code", Rec."Dimension Code"); if DimValuePerAcc.FindSet() then repeat TempDimValuePerAcc3.Init(); TempDimValuePerAcc3 := DimValuePerAcc; TempDimValuePerAcc3.Insert(); until DimValuePerAcc.Next() = 0; end; local procedure UpdateTempDimValuePerAccountAfterChanges(TempDimValuePerAcc3: Record "Dim. Value per Account"; var DimValuePerAcc: Record "Dim. Value per Account") begin DimValuePerAcc.Reset(); DimValuePerAcc.SetRange("Table ID", GetTableIdNo(TempDimValuePerAcc3."Table ID", TableIDNo)); DimValuePerAcc.SetRange("Dimension Code", TempDimValuePerAcc3."Dimension Code"); DimValuePerAcc.SetRange("Dimension Value Code", TempDimValuePerAcc3."Dimension Value Code"); DimValuePerAcc.SetFilter("No.", '<>%1', TempDimValuePerAcc3."No."); if DimValuePerAcc.FindSet() then repeat DimValuePerAcc.Allowed := TempDimValuePerAcc3.Allowed; DimValuePerAcc.Modify(); until DimValuePerAcc.Next() = 0; end; local procedure DeleteDefaultDim() var DefaultDim: Record "Default Dimension"; begin Rec.SetRange("Multi Selection Action", Rec."Multi Selection Action"::Delete); if Rec.Find('-') then repeat if TempDefaultDim3.Find('-') then repeat if DefaultDim.Get( TempDefaultDim3."Table ID", TempDefaultDim3."No.", Rec."Dimension Code") then DefaultDim.Delete(true); until TempDefaultDim3.Next() = 0; until Rec.Next() = 0; end; /// <summary> /// Integration event raised before processing multi-record dimension setup. /// Enables customization of master record validation and preprocessing logic. /// </summary> /// <param name="MasterRecord">Master data record variant to be processed</param> [IntegrationEvent(false, false)] local procedure OnBeforeSetMultiRecord(var MasterRecord: Variant) begin end; /// <summary> /// Integration event raised before modifying default dimension record during common dimension processing. /// Enables custom field validation and modification logic for multi-record operations. /// </summary> /// <param name="DefaultDimension">Default dimension record being modified</param> /// <param name="TempDefaultDimension2">Temporary default dimension record for reference</param> [IntegrationEvent(false, false)] local procedure OnGetDefaultDimOnBeforeModify(var DefaultDimension: Record "Default Dimension"; var TempDefaultDimension2: Record "Default Dimension" temporary) begin end; /// <summary> /// Integration event raised before processing next record during common default dimension setup. /// Enables custom processing logic for each master data record in multi-record operations. /// </summary> /// <param name="DefaultDimension">Default dimension record being processed</param> /// <param name="TempDefaultDimension3">Temporary default dimension record for the current master data record</param> [IntegrationEvent(false, false)] local procedure OnSetCommonDefaultDimOnBeforeNextTempDefaultDim3(var DefaultDimension: Record "Default Dimension"; var TempDefaultDimension3: Record "Default Dimension" temporary) begin end;}