Report 98 Date Compress General Ledger
src/Layers/W1/BaseApp/Finance/GeneralLedger/Ledger/DateCompressGeneralLedger.Report.al749 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.GeneralLedger.Ledger;using Microsoft.Finance.Analysis;using Microsoft.Finance.Dimension;using Microsoft.Finance.GeneralLedger.Setup;using Microsoft.Finance.VAT.Ledger;using Microsoft.Foundation.AuditCodes;using Microsoft.Foundation.Period;using Microsoft.Inventory.Ledger;using System.DataAdministration;using System.Utilities;/// <summary>/// Compresses G/L entries by date to reduce database size and improve performance./// Combines multiple G/L entries with the same G/L account and date into single summarized entries./// </summary>/// <remarks>/// Data sources: G/L Entry table. Supports flexible date compression periods and field retention options./// Maintains VAT entry links, dimension information, and audit trail through registers./// Extensibility: OnBeforeInitRegisters, OnGLEntryOnAfterGetRecordOnBeforeInitNewEntry events available./// </remarks>report 98 "Date Compress General Ledger"{ Caption = 'Date Compress General Ledger'; Permissions = TableData "G/L Entry" = rimd, TableData "G/L Register" = rimd, TableData "G/L Transaction" = rimd, TableData "Date Compr. Register" = rimd, TableData "G/L Entry - VAT Entry Link" = rimd, TableData "Dimension Set ID Filter Line" = rimd, TableData "G/L - Item Ledger Relation" = rimd; ProcessingOnly = true; dataset { dataitem("G/L Entry"; "G/L Entry") { DataItemTableView = sorting("G/L Account No.", "Posting Date"); trigger OnAfterGetRecord() var SummarizedGLEntryCount: Integer; SkippedEntryNos: Dictionary of [Integer, Boolean]; LastProcessedAccountNo: Code[20]; begin GLEntry2 := "G/L Entry"; GLEntry2.SetCurrentKey("G/L Account No.", "Posting Date"); GLEntry2.CopyFilters("G/L Entry"); GLEntry2.SetFilter("Posting Date", DateComprMgt.GetDateFilter(GLEntry2."Posting Date", EntrdDateComprReg, true)); repeat GLEntry2.SetRange("G/L Account No.", GLEntry2."G/L Account No."); GLEntry2.SetRange("Gen. Posting Type", GLEntry2."Gen. Posting Type"); GLEntry2.SetRange("Gen. Bus. Posting Group", GLEntry2."Gen. Bus. Posting Group"); GLEntry2.SetRange("Gen. Prod. Posting Group", GLEntry2."Gen. Prod. Posting Group"); if DateComprRetainFields."Retain Document Type" then GLEntry2.SetRange("Document Type", GLEntry2."Document Type"); if DateComprRetainFields."Retain Document No." then GLEntry2.SetRange("Document No.", GLEntry2."Document No."); if DateComprRetainFields."Retain Job No." then GLEntry2.SetRange("Job No.", GLEntry2."Job No."); if DateComprRetainFields."Retain Business Unit Code" then GLEntry2.SetRange("Business Unit Code", GLEntry2."Business Unit Code"); if DateComprRetainFields."Retain Global Dimension 1" then GLEntry2.SetRange("Global Dimension 1 Code", GLEntry2."Global Dimension 1 Code"); if DateComprRetainFields."Retain Global Dimension 2" then GLEntry2.SetRange("Global Dimension 2 Code", GLEntry2."Global Dimension 2 Code"); if DateComprRetainFields."Retain Journal Template Name" then GLEntry2.SetRange("Journal Templ. Name", GLEntry2."Journal Templ. Name"); if GLEntry2.Amount <> 0 then begin if GLEntry2.Amount > 0 then GLEntry2.SetFilter(Amount, '>0') else GLEntry2.SetFilter(Amount, '<0'); end else begin GLEntry2.SetRange(Amount, 0); if GLEntry2."Additional-Currency Amount" >= 0 then GLEntry2.SetFilter("Additional-Currency Amount", '>=0') else GLEntry2.SetFilter("Additional-Currency Amount", '<0'); end; OnGLEntryOnAfterGetRecordOnBeforeInitNewEntry(GLEntry2, "G/L Entry"); InitNewEntry(NewGLEntry); SummarizedGLEntryCount := 0; Clear(SkippedEntryNos); DimBufMgt.CollectDimEntryNo(TempSelectedDim, GLEntry2."Dimension Set ID", GLEntry2."Entry No.", 0, false, DimEntryNo); ComprDimEntryNo := DimEntryNo; SummarizeEntry(NewGLEntry, GLEntry2, false, SummarizedGLEntryCount); if not UseDataArchive then GLEntry2.SetLoadFields( "G/L Account No.", Amount, "Additional-Currency Amount", "Dimension Set ID", "Source Currency Amount", "VAT Amount", "Source Currency VAT Amount", "Debit Amount", "Credit Amount", "Add.-Currency Debit Amount", "Add.-Currency Credit Amount", Quantity); while GLEntry2.Next() <> 0 do begin DimBufMgt.CollectDimEntryNo(TempSelectedDim, GLEntry2."Dimension Set ID", GLEntry2."Entry No.", ComprDimEntryNo, true, DimEntryNo); if DimEntryNo = ComprDimEntryNo then SummarizeEntry(NewGLEntry, GLEntry2, false, SummarizedGLEntryCount) else SkippedEntryNos.Add(GLEntry2."Entry No.", false); end; DeleteCompressedEntries(GLEntry2, SkippedEntryNos, SummarizedGLEntryCount); InsertNewEntry(NewGLEntry, ComprDimEntryNo); ComprCollectedEntries(); LastProcessedAccountNo := GLEntry2."G/L Account No."; GLEntry2.CopyFilters("G/L Entry"); GLEntry2.SetFilter("Posting Date", DateComprMgt.GetDateFilter(GLEntry2."Posting Date", EntrdDateComprReg, true)); // Skip past already-processed accounts so FindFirst seeks into the index // instead of scanning through deleted-row ghosts with UPDLOCK. // FilterGroup(2) keeps this separate from any user "G/L Account No." filter in group 0. GLEntry2.FilterGroup(2); GLEntry2.SetFilter("G/L Account No.", '>=%1', LastProcessedAccountNo); GLEntry2.FilterGroup(0); if not UseDataArchive then GLEntry2.SetLoadFields( "Posting Date", "G/L Account No.", "Gen. Posting Type", "Gen. Bus. Posting Group", "Gen. Prod. Posting Group", "Document Type", "Document No.", "Job No.", "Business Unit Code", "Global Dimension 1 Code", "Global Dimension 2 Code", "Journal Templ. Name", Amount, "Additional-Currency Amount", "Dimension Set ID", "Source Currency Amount", "VAT Amount", "Source Currency VAT Amount", "Debit Amount", "Credit Amount", "Add.-Currency Debit Amount", "Add.-Currency Credit Amount", Quantity, "User ID"); until not GLEntry2.FindFirst(); if DateComprReg."No. Records Deleted" >= NoOfDeleted + 10 then begin NoOfDeleted := DateComprReg."No. Records Deleted"; InsertRegisters(GLReg, DateComprReg); end; end; trigger OnPostDataItem() begin if DateComprReg."No. Records Deleted" > NoOfDeleted then InsertRegisters(GLReg, DateComprReg); if AnalysisView.FindFirst() then AnalysisView.UpdateLastEntryNo(); if UseDataArchive then DataArchive.Save(); end; trigger OnPreDataItem() var GLSetup: Record "General Ledger Setup"; begin if EntrdDateComprReg."Ending Date" = 0D then Error(EndDateMustBeSetErr, EntrdDateComprReg.FieldCaption("Ending Date")); if AnalysisView.FindFirst() then begin AnalysisView.CheckDimensionsAreRetained(3, REPORT::"Date Compress General Ledger", false); if not SkipAnalysisViewUpdateCheck then AnalysisView.CheckViewsAreUpdated(); Commit(); end; Window.Open( DateCompressTxt + CurrGLAccountNoTxt + CurrPostingDateTxt + NewEntriesCountTxt + DelEntriesCountTxt); SourceCodeSetup.Get(); SourceCodeSetup.TestField("Compress G/L"); SelectedDim.GetSelectedDim(UserId, 3, REPORT::"Date Compress General Ledger", '', TempSelectedDim); GLSetup.Get(); DateComprRetainFields."Retain Global Dimension 1" := TempSelectedDim.Get(UserId, 3, REPORT::"Date Compress General Ledger", '', GLSetup."Global Dimension 1 Code"); DateComprRetainFields."Retain Global Dimension 2" := TempSelectedDim.Get(UserId, 3, REPORT::"Date Compress General Ledger", '', GLSetup."Global Dimension 2 Code"); NewGLEntry.LockTable(); GLReg.LockTable(); DateComprReg.LockTable(); NewGLEntry.GetLastEntry(LastEntryNo, NextTransactionNo); NextTransactionNo := NextTransactionNo + 1; SetRange("Entry No.", 0, LastEntryNo); SetRange("Posting Date", EntrdDateComprReg."Starting Date", EntrdDateComprReg."Ending Date"); InitRegisters(); if UseDataArchive then DataArchive.Create(DateComprMgt.GetReportName(Report::"Date Compress General Ledger")); end; } } requestpage { SaveValues = true; layout { area(content) { group(Options) { Caption = 'Options';#pragma warning disable AA0100 field("EntrdDateComprReg.""Starting Date"""; EntrdDateComprReg."Starting Date")#pragma warning restore AA0100 { ApplicationArea = Suite; Caption = 'Starting Date'; ClosingDates = true; ToolTip = 'Specifies the date from which the report or batch job processes information.'; } field(EndingDate; EntrdDateComprReg."Ending Date") { ApplicationArea = Suite; Caption = 'Ending Date'; ClosingDates = true; ToolTip = 'Specifies the date to which the report or batch job processes information.'; trigger OnValidate() var DateCompression: Codeunit "Date Compression"; begin DateCompression.VerifyDateCompressionDates(EntrdDateComprReg."Starting Date", EntrdDateComprReg."Ending Date"); end; }#pragma warning disable AA0100 field("EntrdDateComprReg.""Period Length"""; EntrdDateComprReg."Period Length")#pragma warning restore AA0100 { ApplicationArea = Suite; Caption = 'Period Length'; OptionCaption = 'Day,Week,Month,Quarter,Year,Period'; ToolTip = 'Specifies the period for which data is shown in the report. For example, enter "1M" for one month, "30D" for thirty days, "3Q" for three quarters, or "5Y" for five years.'; } field("EntrdGLEntry.Description"; EntrdGLEntry.Description) { ApplicationArea = Suite; Caption = 'Posting Description'; ToolTip = 'Specifies a text that accompanies the entries that result from the compression. The default description is Date Compressed.'; } group("Retain Field Contents") { Caption = 'Retain Field Contents'; field("Retain[1]"; DateComprRetainFields."Retain Document Type") { ApplicationArea = Suite; Caption = 'Document Type'; ToolTip = 'Specifies the type of document that is processed by the report or batch job.'; } field("Retain[2]"; DateComprRetainFields."Retain Document No.") { ApplicationArea = Suite; Caption = 'Document No.'; ToolTip = 'Specifies the number of the document that is processed by the report or batch job.'; } field("Retain[3]"; DateComprRetainFields."Retain Job No.") { ApplicationArea = Suite; Caption = 'Project No.'; ToolTip = 'Specifies the project number.'; } field("Retain[4]"; DateComprRetainFields."Retain Business Unit Code") { ApplicationArea = Basic, Suite; Caption = 'Business Unit Code'; ToolTip = 'Specifies the code for the business unit, in a company group structure.'; } field("Retain[7]"; DateComprRetainFields."Retain Journal Template Name") { ApplicationArea = Suite; Caption = 'Journal Template Name'; ToolTip = 'Specifies the name of the journal template that is used for the posting.'; } } field(RetainDimText; RetainDimText) { ApplicationArea = Dimensions; Caption = 'Retain Dimensions'; Editable = false; ToolTip = 'Specifies which dimension information you want to retain when the entries are compressed. The more dimension information that you choose to retain, the more detailed the compressed entries are.'; trigger OnAssistEdit() begin DimSelectionBuf.SetDimSelectionMultiple(3, REPORT::"Date Compress General Ledger", RetainDimText); end; } group("Retain Totals") { Caption = 'Retain Totals'; field("Retain[8]"; DateComprRetainFields."Retain Totals") { ApplicationArea = Suite; Caption = 'Quantity'; ToolTip = 'Specifies the item quantity on the ledger entries that will be date compressed.'; } } field(UseDataArchiveCtrl; UseDataArchive) { ApplicationArea = Suite; Caption = 'Archive Deleted Entries'; ToolTip = 'Specifies whether the deleted (compressed) entries will be stored in the data archive for later inspection or export.'; Visible = DataArchiveProviderExists; } } } } actions { } trigger OnQueryClosePage(CloseAction: Action): Boolean var ConfirmManagement: Codeunit "Confirm Management"; begin if CloseAction = Action::Cancel then exit; if not ConfirmManagement.GetResponseOrDefault(CompressEntriesQst, true) then CurrReport.Break(); end; trigger OnOpenPage() begin InitializeParameter(); end; trigger OnInit() begin DataArchiveProviderExists := DataArchive.DataArchiveProviderExists(); end; } labels { } trigger OnPreReport() var DateCompression: Codeunit "Date Compression"; begin DimSelectionBuf.CompareDimText(3, REPORT::"Date Compress General Ledger", '', RetainDimText, DimTextFieldNameTxt); DateCompression.VerifyDateCompressionDates(EntrdDateComprReg."Starting Date", EntrdDateComprReg."Ending Date"); LogStartTelemetryMessage(); end; trigger OnPostReport() begin LogEndTelemetryMessage(); end; var SourceCodeSetup: Record "Source Code Setup"; DateComprReg: Record "Date Compr. Register"; EntrdDateComprReg: Record "Date Compr. Register"; GLReg: Record "G/L Register"; GLTransaction: Record "G/L Transaction"; EntrdGLEntry: Record "G/L Entry"; NewGLEntry: Record "G/L Entry"; GLEntry2: Record "G/L Entry"; SelectedDim: Record "Selected Dimension"; TempSelectedDim: Record "Selected Dimension" temporary; DimSelectionBuf: Record "Dimension Selection Buffer"; DateComprRetainFields: Record "Date Compr. Retain Fields"; AnalysisView: Record "Analysis View"; DateComprMgt: Codeunit DateComprMgt; DimBufMgt: Codeunit "Dimension Buffer Management"; DimMgt: Codeunit DimensionManagement; DataArchive: Codeunit "Data Archive"; Window: Dialog; LastEntryNo: Integer; NextTransactionNo: Integer; NoOfDeleted: Integer; GLRegExists: Boolean; ComprDimEntryNo: Integer; DimEntryNo: Integer; RetainDimText: Text[250]; UseDataArchive: Boolean; DataArchiveProviderExists: Boolean; SkipAnalysisViewUpdateCheck: Boolean; EndDateMustBeSetErr: Label '%1 must be specified.', Comment = '%1 - Ending Date field caption'; DateCompressTxt: Label 'Date compressing G/L entries...\\'; CurrGLAccountNoTxt: Label 'G/L Account No. #1##########\', Comment = '#1 - Current G/L Account No.'; CurrPostingDateTxt: Label 'Date #2######\\', Comment = '#2 - Current Posting Date'; NewEntriesCountTxt: Label 'No. of new entries #3######\', Comment = '#3 - Number of new G/L entries'; DelEntriesCountTxt: Label 'No. of entries del. #4######', Comment = '#4 - Number of deleted G/L entries'; PostingDescrTxt: Label 'Date Compressed'; DimTextFieldNameTxt: Label 'Retain Dimensions'; CompressEntriesQst: Label 'This batch job deletes entries. We recommend that you create a backup of the database before you run the batch job.\\Do you want to continue?'; StartDateCompressionTelemetryMsg: Label 'Running date compression report %1 %2.', Locked = true; EndDateCompressionTelemetryMsg: Label 'Completed date compression report %1 %2.', Locked = true; EntryCountMismatchErr: Label 'Count of filtered G/L Entries (%1) does not match the number of summarized entries (%2).', Comment = '%1 - number of filtered G/L Entries, %2 - number of summarized entries'; PostingDateOutsideRangeErr: Label 'Posting Date filter (%1..%2) is outside the specified range (%3..%4).', Comment = '%1 - min posting date, %2 - max posting date, %3 - starting date, %4 - ending date'; local procedure InitRegisters() begin OnBeforeInitRegisters("G/L Entry"); GLReg.Initialize(GLReg.GetLastEntryNo() + 1, LastEntryNo + 1, 0, SourceCodeSetup."Compress G/L", '', ''); DateComprReg.InitRegister( DATABASE::"G/L Entry", DateComprReg.GetLastEntryNo() + 1, EntrdDateComprReg."Starting Date", EntrdDateComprReg."Ending Date", EntrdDateComprReg."Period Length", '', GLReg."No.", SourceCodeSetup."Compress G/L"); if DateComprRetainFields."Retain Document Type" then AddFieldContent(NewGLEntry.FieldName("Document Type")); if DateComprRetainFields."Retain Document No." then AddFieldContent(NewGLEntry.FieldName("Document No.")); if DateComprRetainFields."Retain Job No." then AddFieldContent(NewGLEntry.FieldName("Job No.")); if DateComprRetainFields."Retain Business Unit Code" then AddFieldContent(NewGLEntry.FieldName("Business Unit Code")); if DateComprRetainFields."Retain Global Dimension 1" then AddFieldContent(NewGLEntry.FieldName("Global Dimension 1 Code")); if DateComprRetainFields."Retain Global Dimension 2" then AddFieldContent(NewGLEntry.FieldName("Global Dimension 2 Code")); if DateComprRetainFields."Retain Journal Template Name" then AddFieldContent(NewGLEntry.FieldName("Journal Templ. Name")); DateComprReg."Retain Field Contents" := CopyStr(DateComprReg."Retain Field Contents", 2); if DateComprRetainFields."Retain Quantity" then DateComprReg."Retain Totals" := CopyStr( DateComprReg."Retain Totals" + ',' + NewGLEntry.FieldName(Quantity), 1, MaxStrLen(DateComprReg."Retain Totals")); DateComprReg."Retain Totals" := CopyStr(DateComprReg."Retain Totals", 2); GLRegExists := false; NoOfDeleted := 0; end; local procedure AddFieldContent(FieldName: Text) begin DateComprReg."Retain Field Contents" := CopyStr( DateComprReg."Retain Field Contents" + ',' + FieldName, 1, MaxStrLen(DateComprReg."Retain Field Contents")); end; local procedure InsertRegisters(var GLReg: Record "G/L Register"; var DateComprReg: Record "Date Compr. Register") var FoundLastEntryNo: Integer; LastTransactionNo: Integer; begin GLReg."To Entry No." := NewGLEntry."Entry No."; if GLRegExists then begin GLReg.Modify(); DateComprReg.Modify(); end else begin GLReg.Insert(); DateComprReg.Insert(); GLRegExists := true; end; Commit(); NewGLEntry.LockTable(); GLReg.LockTable(); DateComprReg.LockTable(); NewGLEntry.GetLastEntry(FoundLastEntryNo, LastTransactionNo); if LastEntryNo <> FoundLastEntryNo then begin LastEntryNo := FoundLastEntryNo; NextTransactionNo := LastTransactionNo + 1; InitRegisters(); end; end; local procedure SummarizeEntry(var NewGLEntry: Record "G/L Entry"; GLEntry: Record "G/L Entry"; DeleteGLEntry: Boolean; var SummarizedGLEntryCount: Integer) var GLItemLedgRelation: Record "G/L - Item Ledger Relation"; GLEntryVatEntrylink: Record "G/L Entry - VAT Entry Link"; GLEntryVatEntrylink2: Record "G/L Entry - VAT Entry Link"; begin NewGLEntry.Amount += GLEntry.Amount; NewGLEntry."Source Currency Amount" += GLEntry."Source Currency Amount"; NewGLEntry."VAT Amount" += GLEntry."VAT Amount"; NewGLEntry."Source Currency VAT Amount" += GLEntry."Source Currency VAT Amount"; NewGLEntry."Debit Amount" += GLEntry."Debit Amount"; NewGLEntry."Credit Amount" += GLEntry."Credit Amount"; NewGLEntry."Additional-Currency Amount" += GLEntry."Additional-Currency Amount"; NewGLEntry."Add.-Currency Debit Amount" += GLEntry."Add.-Currency Debit Amount"; NewGLEntry."Add.-Currency Credit Amount" += GLEntry."Add.-Currency Credit Amount"; if DateComprRetainFields."Retain Quantity" then NewGLEntry.Quantity += GLEntry.Quantity; OnSummarizeEntryOnBeforeGLEntryDelete(NewGLEntry, GLEntry); if DeleteGLEntry then GLEntry.Delete(); SummarizedGLEntryCount += 1; GLItemLedgRelation.SetRange("G/L Entry No.", GLEntry."Entry No."); GLItemLedgRelation.DeleteAll(); GLEntryVatEntrylink.SetRange("G/L Entry No.", GLEntry."Entry No."); if GLEntryVatEntrylink.FindSet() then repeat GLEntryVatEntrylink2 := GLEntryVatEntrylink; GLEntryVatEntrylink2.Delete(); GLEntryVatEntrylink2."G/L Entry No." := NewGLEntry."Entry No."; if GLEntryVatEntrylink2.Insert() then; until GLEntryVatEntrylink.Next() = 0; DateComprReg."No. Records Deleted" := DateComprReg."No. Records Deleted" + 1; Window.Update(4, DateComprReg."No. Records Deleted"); if UseDataArchive then DataArchive.SaveRecord(GLEntry); end; local procedure DeleteCompressedEntries(var GLEntry: Record "G/L Entry"; SkippedEntryNos: Dictionary of [Integer, Boolean]; SummarizedGLEntryCount: Integer) begin if SkippedEntryNos.Count() > 0 then begin // remove one by one if some entries were not summarized due to different non-global dimensions if GLEntry.FindSet() then repeat if not SkippedEntryNos.ContainsKey(GLEntry."Entry No.") then GLEntry.Delete(); until GLEntry.Next() = 0; end else begin // remove all at once if all entries were summarized if GLEntry.Count() <> SummarizedGLEntryCount then Error(EntryCountMismatchErr, GLEntry.Count(), SummarizedGLEntryCount); if (GLEntry.GetRangeMin("Posting Date") < EntrdDateComprReg."Starting Date") or (GLEntry.GetRangeMax("Posting Date") > EntrdDateComprReg."Ending Date") then Error(PostingDateOutsideRangeErr, Format(GLEntry.GetRangeMin("Posting Date")), Format(GLEntry.GetRangeMax("Posting Date")), Format(EntrdDateComprReg."Starting Date"), Format(EntrdDateComprReg."Ending Date")); GLEntry.DeleteAll(); end; end; /// <summary> /// Compresses collected dimension buffer entries into summarized G/L entries. /// </summary> /// <remarks> /// Processes dimension buffer entries and creates compressed G/L entries with summarized amounts. /// Maintains dimension information and creates proper audit trail entries. /// </remarks> procedure ComprCollectedEntries() var GLEntry: Record "G/L Entry"; OldDimEntryNo: Integer; Found: Boolean; GLEntryNo: Integer; DummyCount: Integer; begin OldDimEntryNo := 0; if DimBufMgt.FindFirstDimEntryNo(DimEntryNo, GLEntryNo) then begin InitNewEntry(NewGLEntry); repeat GLEntry.Get(GLEntryNo); SummarizeEntry(NewGLEntry, GLEntry, true, DummyCount); OldDimEntryNo := DimEntryNo; Found := DimBufMgt.NextDimEntryNo(DimEntryNo, GLEntryNo); if (OldDimEntryNo <> DimEntryNo) or not Found then begin InsertNewEntry(NewGLEntry, OldDimEntryNo); if Found then InitNewEntry(NewGLEntry); end; OldDimEntryNo := DimEntryNo; until not Found; end; DimBufMgt.DeleteAllDimEntryNo(); end; /// <summary> /// Initializes a new G/L entry record for date compression with default values. /// </summary> /// <param name="NewGLEntry">G/L entry record to initialize with compression defaults</param> procedure InitNewEntry(var NewGLEntry: Record "G/L Entry") begin LastEntryNo := LastEntryNo + 1; NewGLEntry.Init(); NewGLEntry."Entry No." := LastEntryNo; NewGLEntry."G/L Account No." := GLEntry2."G/L Account No."; NewGLEntry."Posting Date" := GLEntry2.GetRangeMin("Posting Date"); NewGLEntry.Description := EntrdGLEntry.Description; NewGLEntry."Gen. Posting Type" := GLEntry2."Gen. Posting Type"; NewGLEntry."Gen. Bus. Posting Group" := GLEntry2."Gen. Bus. Posting Group"; NewGLEntry."Gen. Prod. Posting Group" := GLEntry2."Gen. Prod. Posting Group"; NewGLEntry."System-Created Entry" := true; NewGLEntry."Prior-Year Entry" := true; NewGLEntry."Source Code" := SourceCodeSetup."Compress G/L"; NewGLEntry."User ID" := CopyStr(UserId(), 1, MaxStrLen(GLEntry2."User ID")); NewGLEntry."Transaction No." := NextTransactionNo; if DateComprRetainFields."Retain Document Type" then NewGLEntry."Document Type" := GLEntry2."Document Type"; if DateComprRetainFields."Retain Document No." then NewGLEntry."Document No." := GLEntry2."Document No."; if DateComprRetainFields."Retain Job No." then NewGLEntry."Job No." := GLEntry2."Job No."; if DateComprRetainFields."Retain Business Unit Code" then NewGLEntry."Business Unit Code" := GLEntry2."Business Unit Code"; if DateComprRetainFields."Retain Global Dimension 1" then NewGLEntry."Global Dimension 1 Code" := GLEntry2."Global Dimension 1 Code"; if DateComprRetainFields."Retain Global Dimension 2" then NewGLEntry."Global Dimension 2 Code" := GLEntry2."Global Dimension 2 Code"; if DateComprRetainFields."Retain Journal Template Name" then NewGLEntry."Journal Templ. Name" := GLEntry2."Journal Templ. Name"; Window.Update(1, NewGLEntry."G/L Account No."); Window.Update(2, NewGLEntry."Posting Date"); DateComprReg."No. of New Records" := DateComprReg."No. of New Records" + 1; Window.Update(3, DateComprReg."No. of New Records"); OnAfterInitNewEntry(NewGLEntry); end; local procedure InsertNewEntry(var GLEntry: Record "G/L Entry"; DimEntryNo: Integer) var TempDimBuf: Record "Dimension Buffer" temporary; TempDimSetEntry: Record "Dimension Set Entry" temporary; begin TempDimBuf.DeleteAll(); DimBufMgt.GetDimensions(DimEntryNo, TempDimBuf); DimMgt.CopyDimBufToDimSetEntry(TempDimBuf, TempDimSetEntry); GLEntry."Dimension Set ID" := DimMgt.GetDimensionSetID(TempDimSetEntry); GLEntry."G/L Register No." := GLReg."No."; GLEntry.Insert(); GLTransaction.InsertFromGLEntry(GLEntry, GLReg); end; local procedure InitializeParameter() var DateCompression: Codeunit "Date Compression"; begin if EntrdDateComprReg."Ending Date" = 0D then EntrdDateComprReg."Ending Date" := DateCompression.CalcMaxEndDate(); if EntrdGLEntry.Description = '' then EntrdGLEntry.Description := PostingDescrTxt; DataArchiveProviderExists := DataArchive.DataArchiveProviderExists(); UseDataArchive := DataArchiveProviderExists; RetainDimText := DimSelectionBuf.GetDimSelectionText(3, REPORT::"Date Compress General Ledger", ''); end; /// <summary> /// Initializes date compression parameters for programmatic execution. /// </summary> /// <param name="StartingDate">First date of the compression period</param> /// <param name="EndingDate">Last date of the compression period</param> /// <param name="PeriodLength">Period length option for compression grouping</param> /// <param name="Description">Description for compressed entries</param> /// <param name="NewDateComprRetainFields">Field retention options for compression</param> /// <param name="RetainDimensionText">Dimension retention specification</param> /// <param name="DoUseDataArchive">Whether to use data archiving for deleted entries</param> procedure InitializeRequest(StartingDate: Date; EndingDate: Date; PeriodLength: Option; Description: Text[100]; NewDateComprRetainFields: Record "Date Compr. Retain Fields"; RetainDimensionText: Text[250]; DoUseDataArchive: Boolean) begin InitializeParameter(); EntrdDateComprReg."Starting Date" := StartingDate; EntrdDateComprReg."Ending Date" := EndingDate; EntrdDateComprReg."Period Length" := PeriodLength; EntrdGLEntry.Description := Description; DateComprRetainFields := NewDateComprRetainFields; RetainDimText := RetainDimensionText; UseDataArchive := DataArchiveProviderExists and DoUseDataArchive; end; internal procedure SetSkipAnalysisViewUpdateCheck(); begin SkipAnalysisViewUpdateCheck := true; end; local procedure LogStartTelemetryMessage() var 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('StartDate', Format(EntrdDateComprReg."Starting Date", 0, 9)); TelemetryDimensions.Add('EndDate', Format(EntrdDateComprReg."Ending Date", 0, 9)); TelemetryDimensions.Add('PeriodLength', Format(EntrdDateComprReg."Period Length", 0, 9)); TelemetryDimensions.Add('RetainDocumentType', Format(DateComprRetainFields."Retain Document Type", 0, 9)); TelemetryDimensions.Add('RetainDocumentNo', Format(DateComprRetainFields."Retain Document No.", 0, 9)); TelemetryDimensions.Add('RetainJobNo', Format(DateComprRetainFields."Retain Job No.", 0, 9)); TelemetryDimensions.Add('RetainBusinessUnitCode', Format(DateComprRetainFields."Retain Business Unit Code", 0, 9)); TelemetryDimensions.Add('RetainQuantity', Format(DateComprRetainFields."Retain Quantity", 0, 9)); TelemetryDimensions.Add('RetainJnlTemplate', Format(DateComprRetainFields."Retain Journal Template Name", 0, 9)); TelemetryDimensions.Add('RetainDimensions', RetainDimText); TelemetryDimensions.Add('UseDataArchive', Format(UseDataArchive)); Session.LogMessage('0000F4O', StrSubstNo(StartDateCompressionTelemetryMsg, CurrReport.ObjectId(false), CurrReport.ObjectId(true)), Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::All, TelemetryDimensions); end; local procedure LogEndTelemetryMessage() var TelemetryDimensions: Dictionary of [Text, Text]; begin TelemetryDimensions.Add('ReportId', Format(CurrReport.ObjectId(false), 0, 9)); TelemetryDimensions.Add('ReportName', CurrReport.ObjectId(true)); TelemetryDimensions.Add('RegisterNo', Format(DateComprReg."Register No.", 0, 9)); TelemetryDimensions.Add('TableID', Format(DateComprReg."Table ID", 0, 9)); TelemetryDimensions.Add('NoRecordsDeleted', Format(DateComprReg."No. Records Deleted", 0, 9)); TelemetryDimensions.Add('NoofNewRecords', Format(DateComprReg."No. of New Records", 0, 9)); Session.LogMessage('0000F4P', StrSubstNo(EndDateCompressionTelemetryMsg, CurrReport.ObjectId(false), CurrReport.ObjectId(true)), Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::All, TelemetryDimensions); end; /// <summary> /// Integration event raised before initializing registers during G/L entry date compression. /// </summary> /// <param name="GLEntry">G/L Entry record being processed.</param> [IntegrationEvent(false, false)] local procedure OnBeforeInitRegisters(var GLEntry: Record "G/L Entry") begin end; /// <summary> /// Integration event raised during G/L entry processing before initializing a new entry. /// </summary> /// <param name="GLEntry2">New G/L Entry record being created.</param> /// <param name="GLEntry">Source G/L Entry record being processed.</param> [IntegrationEvent(false, false)] local procedure OnGLEntryOnAfterGetRecordOnBeforeInitNewEntry(var GLEntry2: Record "G/L Entry"; var GLEntry: Record "G/L Entry") begin end; /// <summary> /// Integration event raised before deleting a G/L entry during the summarization process. /// </summary> /// <param name="NewGLEntry">New summarized G/L Entry record.</param> /// <param name="GLEntry">Original G/L Entry record to be deleted.</param> [IntegrationEvent(false, false)] local procedure OnSummarizeEntryOnBeforeGLEntryDelete(var NewGLEntry: Record "G/L Entry"; GLEntry: Record "G/L Entry") begin end; [IntegrationEvent(false, false)] local procedure OnAfterInitNewEntry(var NewGLEntry: Record "G/L Entry") begin end;}