Page 381 Apply Bank Acc. Ledger Entries
src/Layers/W1/BaseApp/Bank/Ledger/ApplyBankAccLedgerEntries.Page.al464 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.Ledger;using Microsoft.Bank.BankAccount;using Microsoft.Bank.Check;using Microsoft.Bank.Reconciliation;using Microsoft.Finance.GeneralLedger.Setup;/// <summary>/// List part page for selecting and applying bank account ledger entries during bank reconciliation./// Provides filtering, selection, and balance calculation functionality for matching bank statement lines/// with posted bank account transactions during the reconciliation process./// </summary>page 381 "Apply Bank Acc. Ledger Entries"{ Caption = 'Apply Bank Acc. Ledger Entries'; DeleteAllowed = false; InsertAllowed = false; PageType = ListPart; SourceTable = "Bank Account Ledger Entry"; layout { area(content) { repeater(Control1) { ShowCaption = false; field(LineApplied; StatementNoLineApplied <> '') { ApplicationArea = Basic, Suite; Caption = 'Applied'; Editable = false; ToolTip = 'Specifies if the bank account ledger entry has been applied to its related bank transaction.'; } field("Posting Date"; Rec."Posting Date") { ApplicationArea = Basic, Suite; Editable = false; StyleExpr = StyleTxt; } field("Document Type"; Rec."Document Type") { ApplicationArea = Basic, Suite; Editable = false; StyleExpr = StyleTxt; } field("Document No."; Rec."Document No.") { ApplicationArea = Basic, Suite; Editable = false; StyleExpr = StyleTxt; } field(Description; Rec.Description) { ApplicationArea = Basic, Suite; Editable = false; StyleExpr = StyleTxt; } field(Amount; Rec.Amount) { ApplicationArea = Basic, Suite; Editable = false; StyleExpr = StyleTxt; Visible = AmountVisible; } field("Debit Amount"; Rec."Debit Amount") { ApplicationArea = Basic, Suite; Visible = DebitCreditVisible; } field("Credit Amount"; Rec."Credit Amount") { ApplicationArea = Basic, Suite; Visible = DebitCreditVisible; } field("Remaining Amount"; Rec."Remaining Amount") { ApplicationArea = Basic, Suite; Editable = false; StyleExpr = StyleTxt; } field(Open; Rec.Open) { ApplicationArea = Basic, Suite; Editable = false; } field(Positive; Rec.Positive) { ApplicationArea = Basic, Suite; Editable = false; Visible = false; } field("Bal. Account Type"; Rec."Bal. Account Type") { ApplicationArea = Basic, Suite; Editable = false; Visible = false; } field("Bal. Account No."; Rec."Bal. Account No.") { ApplicationArea = Basic, Suite; Editable = false; Visible = false; } field("Statement Status"; Rec."Statement Status") { ApplicationArea = Basic, Suite; Editable = false; Visible = false; } field("Statement No."; Rec."Statement No.") { ApplicationArea = Basic, Suite; Editable = false; Visible = false; } field("Statement Line No."; Rec."Statement Line No.") { ApplicationArea = Basic, Suite; Editable = false; Visible = false; } field("Check Ledger Entries"; Rec."Check Ledger Entries") { ApplicationArea = Basic, Suite; } 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("External Document No."; Rec."External Document No.") { ApplicationArea = Basic, Suite; } } group(Control7) { ShowCaption = false; label(Control15) { ApplicationArea = Basic, Suite; ShowCaption = false; Caption = ' '; } field(Balance; Balance) { ApplicationArea = Basic, Suite; AutoFormatExpression = Rec."Currency Code"; AutoFormatType = 1; Caption = 'Balance'; Editable = false; ToolTip = 'Specifies the balance of the bank account since the last posting, including any amount in the Total on Outstanding Checks field.'; } field(CheckBalance; CheckBalance) { ApplicationArea = Basic, Suite; AutoFormatExpression = Rec."Currency Code"; AutoFormatType = 1; Caption = 'Total on Outstanding Checks'; Editable = false; ToolTip = 'Specifies the part of the bank account balance that consists of posted check ledger entries. The amount in this field is a subset of the amount in the Balance field under the right pane in the Bank Acc. Reconciliation window.'; trigger OnDrillDown() var CheckLedgerEntry: Record "Check Ledger Entry"; begin if BankAccount."No." = '' then exit; CheckLedgerEntry.FilterGroup(2); CheckLedgerEntry.SetRange("Bank Account No.", BankAccount."No."); CheckLedgerEntry.SetRange("Entry Status", CheckLedgerEntry."Entry Status"::Posted); CheckLedgerEntry.SetFilter("Statement Status", '<>%1', CheckLedgerEntry."Statement Status"::Closed); CheckLedgerEntry.SetFilter("Posting Date", '<=%1', BankAccReconciliation."Statement Date"); CheckLedgerEntry.FilterGroup(0); if not CheckLedgerEntry.IsEmpty() then Page.Run(Page::"Check Ledger Entries", CheckLedgerEntry); end; } field(BalanceToReconcile; BalanceToReconcile) { ApplicationArea = Basic, Suite; AutoFormatExpression = Rec."Currency Code"; AutoFormatType = 1; Caption = 'Balance To Reconcile'; Editable = false; ToolTip = 'Specifies the balance of the bank account since the last posting, excluding any amount in the Total on Outstanding Checks field.'; } } } } actions { } trigger OnAfterGetCurrRecord() begin SetUserInteractions(); CalcBalance(); ApplyControledFilters(); end; trigger OnAfterGetRecord() begin StatementNoLineApplied := Rec.GetAppliedStatementNo(); SetUserInteractions(); end; trigger OnInit() begin AmountVisible := true; SetUserInteractions(); end; trigger OnModifyRecord(): Boolean begin SetUserInteractions(); end; trigger OnOpenPage() begin SetControlVisibility(); end; var BankAccount: Record "Bank Account"; BankAccReconciliation: Record "Bank Acc. Reconciliation"; StyleTxt: Text; StatementNoLineApplied: Code[20]; Balance: Decimal; CheckBalance: Decimal; BalanceToReconcile: Decimal; AmountVisible: Boolean; DebitCreditVisible: Boolean; ShowingReversed: Boolean; ShowingNonMatched: Boolean; /// <summary> /// Retrieves bank account ledger entries selected by the user for application. /// Copies selected entries to a temporary table for further processing during reconciliation. /// </summary> /// <param name="TempBankAccountLedgerEntry">Temporary table to receive the selected entries.</param> procedure GetSelectedRecords(var TempBankAccountLedgerEntry: Record "Bank Account Ledger Entry" temporary) var BankAccountLedgerEntry: Record "Bank Account Ledger Entry"; IsHandled: Boolean; begin IsHandled := false; OnBeforeGetSelectedRecords(Rec, TempBankAccountLedgerEntry, IsHandled); if IsHandled then exit; CurrPage.SetSelectionFilter(BankAccountLedgerEntry); if BankAccountLedgerEntry.FindSet() then repeat TempBankAccountLedgerEntry := BankAccountLedgerEntry; TempBankAccountLedgerEntry.Insert(); until BankAccountLedgerEntry.Next() = 0; end; /// <summary> /// Sets user interaction styling based on the application status of entries. /// Updates visual styling to indicate applied, mismatched, or unmatched entries. /// </summary> procedure SetUserInteractions() begin StyleTxt := ''; if StatementNoLineApplied = '' then exit; if StatementNoLineApplied = BankAccReconciliation."Statement No." then StyleTxt := 'Favorable' else StyleTxt := 'AttentionAccent'; end; /// <summary> /// Shows all available bank account ledger entries for reconciliation without filtering. /// Resets filters and displays the complete set of entries for the bank account. /// </summary> procedure ShowAll() begin Rec.Reset(); ShowingNonMatched := false; if BankAccReconciliation.Get(BankAccReconciliation."Statement Type", BankAccReconciliation."Bank Account No.", BankAccReconciliation."Statement No.") then; ApplyDateFilter(BankAccReconciliation.MatchCandidateFilterDate()); ApplyControledFilters(); CurrPage.Update(false); end; /// <summary> /// Filters the list to show only bank account ledger entries that have not been matched to statement lines. /// Useful for identifying outstanding transactions during reconciliation. /// </summary> procedure ShowNonMatched() begin ShowingNonMatched := true; ApplyControledFilters(); CurrPage.Update(false); end; /// <summary> /// Shows reversed bank account ledger entries in the reconciliation list. /// Includes previously hidden reversed entries for complete transaction visibility. /// </summary> procedure ShowReversed() begin ShowingReversed := true; ApplyControledFilters(); CurrPage.Update(false); end; /// <summary> /// Hides reversed bank account ledger entries from the reconciliation list. /// Excludes reversed entries to focus on active transactions for reconciliation. /// </summary> procedure HideReversed() begin ShowingReversed := false; ApplyControledFilters(); CurrPage.Update(false); end; /// <summary> /// Applies date-based filtering to show entries within the bank reconciliation date range. /// Filters entries to optimize reconciliation matching by focusing on relevant date periods. /// </summary> /// <param name="StatementDate">Statement date to use for filtering criteria.</param> procedure SetBankRecDateFilter(StatementDate: Date) begin ApplyDateFilter(StatementDate); CurrPage.Update(false); end; local procedure ApplyDateFilter(StatementDate: Date) begin if StatementDate = 0D then Rec.SetRange("Posting Date") else Rec.SetRange("Posting Date", 0D, StatementDate); end; local procedure ApplyControledFilters() begin ApplyPartFilters(); if ShowingNonMatched then begin Rec.SetRange("Statement Status", Rec."Statement Status"::Open); Rec.SetRange("Statement No.", ''); Rec.SetRange("Statement Line No.", 0); end else begin Rec.SetRange("Statement No."); Rec.SetRange("Statement Line No."); end; if not ShowingReversed then Rec.SetRange(Reversed, false) else Rec.SetRange(Reversed); OnAfterApplyControledFilters(Rec); end; local procedure ApplyPartFilters() begin Rec.SetRange("Bank Account No.", BankAccReconciliation."Bank Account No."); Rec.SetRange(Open, true); Rec.SetFilter("Statement Status", '%1|%2|%3', Rec."Statement Status"::Open, Rec."Statement Status"::"Bank Acc. Entry Applied", Rec."Statement Status"::"Check Entry Applied"); end; local procedure CalcBalance() begin if BankAccount.Get(Rec."Bank Account No.") then begin BankAccount.CalcFields(Balance, "Total on Checks"); Balance := BankAccount.Balance; CheckBalance := CalcOutstandingChecks(BankAccReconciliation."Statement Date"); BalanceToReconcile := CalcBalanceToReconcile(); end; end; local procedure CalcOutstandingChecks(StatementEndingDate: Date): Decimal var CheckLedgerEntry: Record "Check Ledger Entry"; TotalOutstanding: Decimal; begin if BankAccount."No." = '' then exit(0); CheckLedgerEntry.SetLoadFields("Bank Account No.", "Entry Status", "Statement Status", "Posting Date"); CheckLedgerEntry.SetRange("Bank Account No.", BankAccount."No."); CheckLedgerEntry.SetRange("Entry Status", CheckLedgerEntry."Entry Status"::Posted); CheckLedgerEntry.SetFilter("Statement Status", '<>%1', CheckLedgerEntry."Statement Status"::Closed); CheckLedgerEntry.SetFilter("Posting Date", '<=%1', StatementEndingDate); CheckLedgerEntry.CalcSums(Amount); TotalOutstanding := CheckLedgerEntry.Amount; exit(TotalOutstanding); end; local procedure CalcBalanceToReconcile(): Decimal var BankAccountLedgerEntry: Record "Bank Account Ledger Entry"; begin BankAccountLedgerEntry.CopyFilters(Rec); BankAccountLedgerEntry.CalcSums(Amount); exit(BankAccountLedgerEntry.Amount); end; local procedure SetControlVisibility() var GLSetup: Record "General Ledger Setup"; begin GLSetup.Get(); AmountVisible := not (GLSetup."Show Amounts" = GLSetup."Show Amounts"::"Debit/Credit Only"); DebitCreditVisible := not (GLSetup."Show Amounts" = GLSetup."Show Amounts"::"Amount Only"); end; /// <summary> /// Associates the page with a specific bank account reconciliation record. /// Sets up filtering and context for the reconciliation process. /// </summary> /// <param name="NewBankAccReconciliation">Bank account reconciliation record to associate with the page.</param> procedure AssignBankAccReconciliation(var NewBankAccReconciliation: Record "Bank Acc. Reconciliation") begin BankAccReconciliation := NewBankAccReconciliation; ApplyControledFilters(); CurrPage.Update(false); end; /// <summary> /// Integration event raised after applying controlled filters to the bank account ledger entries. /// Allows subscribers to modify or extend the filtering logic for reconciliation scenarios. /// </summary> /// <param name="BankAccountLedgerEntry">Bank account ledger entry record with applied filters.</param> [IntegrationEvent(false, false)] local procedure OnAfterApplyControledFilters(var BankAccountLedgerEntry: Record "Bank Account Ledger Entry") begin end; /// <summary> /// Integration event raised before collecting selected records for reconciliation processing. /// Allows subscribers to customize selection logic or handle records differently. /// </summary> /// <param name="BankAccountLedgerEntry">Source bank account ledger entry being processed.</param> /// <param name="TempBankAccountLedgerEntry">Temporary table receiving selected entries.</param> /// <param name="IsHandled">Set to true to skip standard selection processing.</param> [IntegrationEvent(false, false)] local procedure OnBeforeGetSelectedRecords(var BankAccountLedgerEntry: Record "Bank Account Ledger Entry"; var TempBankAccountLedgerEntry: Record "Bank Account Ledger Entry" temporary; var IsHandled: Boolean) begin end;}