Report 1496 Suggest Bank Acc. Recon. Lines
src/Layers/W1/BaseApp/Bank/Reconciliation/SuggestBankAccReconLines.Report.al218 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.Bank.Reconciliation;using Microsoft.Bank.BankAccount;using Microsoft.Bank.Check;using Microsoft.Bank.Ledger;using System.Telemetry;/// <summary>/// Report for automatically suggesting bank account reconciliation lines based on open bank ledger entries./// Analyzes unmatched bank account ledger entries within a specified date range and creates/// corresponding reconciliation lines for processing. Supports filtering options for reversed/// entries and provides automatic matching with existing reconciliation data./// </summary>/// <remarks>/// Key functionality includes date-based filtering of open bank entries, automatic creation/// of reconciliation lines from ledger entries, optional exclusion of reversed transactions,/// and integration with automatic payment matching workflows. Used to populate reconciliation/// worksheets with unprocessed bank transactions for efficient reconciliation processing./// </remarks>report 1496 "Suggest Bank Acc. Recon. Lines"{ Caption = 'Suggest Bank Acc. Recon. Lines'; ProcessingOnly = true; dataset { dataitem("Bank Account"; "Bank Account") { DataItemTableView = sorting("No."); trigger OnAfterGetRecord() var FeatureTelemetry: Codeunit "Feature Telemetry"; begin Session.LogMessage('0000JLH', Format(ExcludeReversedEntries), Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', BankAccRecon.GetBankReconciliationTelemetryFeatureName()); Session.LogMessage('0000JLI', Format("Bank Account"."Disable Automatic Pmt Matching"), Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', BankAccRecon.GetBankReconciliationTelemetryFeatureName()); FeatureTelemetry.LogUptake('0000JLF', BankAccRecon.GetBankReconciliationTelemetryFeatureName(), Enum::"Feature Uptake Status"::Used); BankAccLedgEntry.Reset(); BankAccLedgEntry.SetCurrentKey("Bank Account No.", "Posting Date"); BankAccLedgEntry.SetRange("Bank Account No.", "No."); BankAccLedgEntry.SetRange("Posting Date", StartDate, EndDate); BankAccLedgEntry.SetRange(Open, true); BankAccLedgEntry.SetRange("Statement Status", BankAccLedgEntry."Statement Status"::Open); if ExcludeReversedEntries then BankAccLedgEntry.SetRange(Reversed, false); OnBankAccountOnAfterGetRecordOnAfterSetFilters(BankAccLedgEntry, "Bank Account"); EOFBankAccLedgEntries := not BankAccLedgEntry.Find('-'); while not EOFBankAccLedgEntries do begin InsertBankAccReconciliationLine(BankAccLedgEntry); MatchBLEToBankAccReconciliationLine(BankAccReconLine, BankAccLedgEntry); EOFBankAccLedgEntries := BankAccLedgEntry.Next() = 0; end; FeatureTelemetry.LogUsage('0000JLG', BankAccRecon.GetBankReconciliationTelemetryFeatureName(), EventNameTelemetryTxt); end; trigger OnPreDataItem() begin OnPreDataItemBankAccount(ExcludeReversedEntries); if EndDate = 0D then Error(EnterEndingDateErr); if BankAccRecon."Statement Date" <> 0D then if BankAccRecon."Statement Date" < EndDate then EndDate := BankAccRecon."Statement Date"; BankAccReconLine.FilterBankRecLines(BankAccRecon); if not BankAccReconLine.FindLast() then begin BankAccReconLine."Statement Type" := BankAccRecon."Statement Type"; BankAccReconLine."Bank Account No." := BankAccRecon."Bank Account No."; BankAccReconLine."Statement No." := BankAccRecon."Statement No."; BankAccReconLine."Statement Line No." := 0; end; SetRange("No.", BankAccRecon."Bank Account No."); end; } } requestpage { SaveValues = true; layout { area(content) { group(Options) { Caption = 'Options'; group("Statement Period") { Caption = 'Statement Period'; field(StartingDate; StartDate) { ApplicationArea = Basic, Suite; Caption = 'Starting Date'; ToolTip = 'Specifies the date from which the report or batch job processes information.'; } field(EndingDate; EndDate) { ApplicationArea = Basic, Suite; Caption = 'Ending Date'; ToolTip = 'Specifies the date to which the report or batch job processes information.'; } } field(IncludeChecks; IncludeChecks) { ApplicationArea = Basic, Suite; Visible = false; Caption = 'Include Checks'; ToolTip = 'Specifies if you want the report to include check ledger entries. If you choose this option, check ledger entries are suggested instead of the corresponding bank account ledger entries.'; } field(ExcludeReversedEntries; ExcludeReversedEntries) { ApplicationArea = Basic, Suite; Caption = 'Exclude Reversed Entries'; ToolTip = 'Specifies if you want to exclude reversed entries from the report.'; } } } } actions { } } labels { } var BankAccLedgEntry: Record "Bank Account Ledger Entry"; BankAccRecon: Record "Bank Acc. Reconciliation"; BankAccReconLine: Record "Bank Acc. Reconciliation Line"; BankAccSetStmtNo: Codeunit "Bank Acc. Entry Set Recon.-No."; StartDate: Date; EndDate: Date; EventNameTelemetryTxt: Label 'Suggest lines', Locked = true; IncludeChecks: Boolean; EOFBankAccLedgEntries: Boolean; ExcludeReversedEntries: Boolean; EnterEndingDateErr: Label 'Enter the Ending Date.'; procedure SetStmt(var BankAccRecon2: Record "Bank Acc. Reconciliation") begin BankAccRecon := BankAccRecon2; EndDate := BankAccRecon."Statement Date"; end; local procedure InsertBankAccReconciliationLine(var BankAccountLedgerEntry: Record "Bank Account Ledger Entry") begin BankAccReconLine.Init(); BankAccReconLine."Statement Line No." := BankAccReconLine."Statement Line No." + 10000; BankAccReconLine."Transaction Date" := BankAccountLedgerEntry."Posting Date"; BankAccReconLine.Description := BankAccountLedgerEntry.Description; BankAccReconLine."Document No." := BankAccountLedgerEntry."Document No."; BankAccReconLine.Validate("Statement Amount", BankAccountLedgerEntry."Remaining Amount"); OnBeforeInsertBankAccReconLine(BankAccReconLine, BankAccountLedgerEntry); BankAccReconLine.Insert(); end; local procedure MatchBLEToBankAccReconciliationLine(var BankAccReconciliationLine: Record "Bank Acc. Reconciliation Line"; var BankAccountLedgerEntry: Record "Bank Account Ledger Entry") var BankAccount: Record "Bank Account"; CheckLedgerEntry: Record "Check Ledger Entry"; begin if BankAccount.Get(BankAccountLedgerEntry."Bank Account No.") then if not BankAccount."Disable Automatic Pmt Matching" then begin BankAccReconciliationLine.Validate("Applied Amount", BankAccReconciliationLine."Statement Amount"); BankAccReconciliationLine."Applied Entries" := 1; BankAccSetStmtNo.SetReconNo(BankAccountLedgerEntry, BankAccReconciliationLine); CheckLedgerEntry.SetRange("Bank Account Ledger Entry No.", BankAccountLedgerEntry."Entry No."); if CheckLedgerEntry.FindFirst() then BankAccReconciliationLine."Check No." := CheckLedgerEntry."Check No."; end; BankAccReconciliationLine.Modify(); end; procedure InitializeRequest(NewStartDate: Date; NewEndDate: Date; NewIncludeChecks: Boolean) begin StartDate := NewStartDate; if (BankAccRecon."Statement Date" = 0D) or (NewEndDate < BankAccRecon."Statement Date") then EndDate := NewEndDate else EndDate := BankAccRecon."Statement Date"; NewIncludeChecks := false; IncludeChecks := NewIncludeChecks; ExcludeReversedEntries := false; end; [IntegrationEvent(false, false)] local procedure OnBeforeInsertBankAccReconLine(var BankAccReconLine: Record "Bank Acc. Reconciliation Line"; var BankAccLedgEntry: Record "Bank Account Ledger Entry") begin end; [IntegrationEvent(false, false)] [Scope('OnPrem')] procedure OnPreDataItemBankAccount(var ExcludeReversedEntries: Boolean) begin // ExcludeReversedEntries = FALSE by default end; [IntegrationEvent(false, false)] local procedure OnBankAccountOnAfterGetRecordOnAfterSetFilters(var BankAccLedgEntry: Record "Bank Account Ledger Entry"; var BankAccount: Record "Bank Account") begin end;}