Table 1284 Outstanding Bank Transaction
src/Layers/W1/BaseApp/Bank/Reconciliation/OutstandingBankTransaction.Table.al261 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.Ledger;/// <summary>/// Tracks bank transactions that remain unmatched or outstanding during bank reconciliation processes./// This table maintains records of bank account ledger entries and check transactions that have not been/// cleared or matched against bank statement lines. Used for identifying discrepancies, monitoring/// outstanding items, and generating reconciliation reports for management review./// </summary>/// <remarks>/// Key functionality includes outstanding transaction tracking across multiple transaction types,/// age analysis for overdue items, currency handling for multi-currency bank accounts,/// and integration with bank reconciliation workflows. Supports both automatic detection/// of outstanding items and manual addition of reconciling items. Used extensively for/// month-end reconciliation processes and audit trail maintenance./// </remarks>table 1284 "Outstanding Bank Transaction"{ Caption = 'Outstanding Bank Transaction'; DataClassification = CustomerContent; fields { /// <summary> /// Unique entry number for the outstanding bank transaction. /// Provides identification and linking to source ledger entries. /// </summary> field(1; "Entry No."; Integer) { Caption = 'Entry No.'; ToolTip = 'Specifies the number of the entry, as assigned from the specified number series when the entry was created.'; } /// <summary> /// Posting date of the original bank transaction. /// Used for chronological analysis and reconciliation matching. /// </summary> field(2; "Posting Date"; Date) { Caption = 'Posting Date'; ToolTip = 'Specifies the posting date of the entry.'; } /// <summary> /// Document type of the original transaction. /// Indicates the nature of the business transaction creating the outstanding item. /// </summary> field(3; "Document Type"; Option) { Caption = 'Document Type'; ToolTip = 'Specifies the type of document that generated the entry.'; OptionCaption = ' ,Payment,Invoice,Credit Memo,Finance Charge Memo,Reminder,Refund'; OptionMembers = " ",Payment,Invoice,"Credit Memo","Finance Charge Memo",Reminder,Refund; } /// <summary> /// Document number of the original transaction. /// Used for reference matching and transaction identification. /// </summary> field(4; "Document No."; Code[20]) { Caption = 'Document No.'; ToolTip = 'Specifies the number of the document that generated the entry.'; } /// <summary> /// Bank account number where the outstanding transaction occurred. /// Identifies which bank account has the unreconciled transaction. /// </summary> field(5; "Bank Account No."; Code[20]) { Caption = 'Bank Account No.'; } /// <summary> /// Description of the outstanding bank transaction. /// Provides context and identification for reconciliation purposes. /// </summary> field(6; Description; Text[100]) { Caption = 'Description'; ToolTip = 'Specifies the description of the entry.'; } /// <summary> /// Transaction amount for the outstanding bank transaction. /// Shows the unreconciled amount that needs to be matched with bank statements. /// </summary> field(7; Amount; Decimal) { AutoFormatType = 1; AutoFormatExpression = GetCurrencyCode(); Caption = 'Amount'; ToolTip = 'Specifies the amount of the entry.'; } /// <summary> /// Type of source ledger entry for the outstanding transaction. /// Determines which ledger table contains the original transaction record. /// </summary> field(8; Type; Option) { Caption = 'Type'; ToolTip = 'Specifies the type of the entry.'; OptionCaption = 'Bank Account Ledger Entry,Check Ledger Entry'; OptionMembers = "Bank Account Ledger Entry","Check Ledger Entry"; } /// <summary> /// Indicates whether the outstanding transaction has been applied in reconciliation. /// Controls visibility and processing during bank reconciliation workflows. /// </summary> field(9; Applied; Boolean) { Caption = 'Applied'; ToolTip = 'Specifies if the entry has been applied.'; } /// <summary> /// Type of statement used for reconciliation processing. /// Determines the reconciliation workflow and processing logic. /// </summary> field(10; "Statement Type"; Option) { Caption = 'Statement Type'; OptionCaption = 'Bank Reconciliation,Payment Application'; OptionMembers = "Bank Reconciliation","Payment Application"; } /// <summary> /// Statement number when the transaction was applied during reconciliation. /// Links the transaction to the specific reconciliation session. /// </summary> field(11; "Statement No."; Code[20]) { Caption = 'Statement No.'; } } keys { key(Key1; "Entry No.") { Clustered = true; } key(Key2; Type) { } } fieldgroups { } procedure DrillDown(BankAccNo: Code[20]; TransactionType: Option; StatementType: Integer; StatementNo: Code[20]) var TempOutstandingBankTransaction: Record "Outstanding Bank Transaction" temporary; begin CreateTempOutstandingBankTrxs(TempOutstandingBankTransaction, BankAccNo, StatementType, StatementNo); SetOutstandingBankTrxFilter(TempOutstandingBankTransaction, TransactionType); RunOustandingBankTrxsPage(TempOutstandingBankTransaction, TransactionType); end; procedure CreateTempOutstandingBankTrxs(var TempOutstandingBankTransaction: Record "Outstanding Bank Transaction" temporary; BankAccNo: Code[20]; StatementType: Integer; StatementNo: Code[20]) var BankAccountLedgerEntry: Record "Bank Account Ledger Entry"; RemainingAmt: Decimal; begin BankAccountLedgerEntry.SetRange("Bank Account No.", BankAccNo); BankAccountLedgerEntry.SetRange(Open, true); if BankAccountLedgerEntry.FindSet() then repeat RemainingAmt := BankAccountLedgerEntry.Amount - GetAppliedAmount(BankAccountLedgerEntry."Entry No."); if RemainingAmt <> 0 then begin TempOutstandingBankTransaction.Init(); TempOutstandingBankTransaction."Posting Date" := BankAccountLedgerEntry."Posting Date"; TempOutstandingBankTransaction."Document Type" := BankAccountLedgerEntry."Document Type".AsInteger(); TempOutstandingBankTransaction."Document No." := BankAccountLedgerEntry."Document No."; TempOutstandingBankTransaction."Bank Account No." := BankAccountLedgerEntry."Bank Account No."; TempOutstandingBankTransaction.Description := BankAccountLedgerEntry.Description; TempOutstandingBankTransaction.Amount := RemainingAmt; TempOutstandingBankTransaction."Entry No." := BankAccountLedgerEntry."Entry No."; TempOutstandingBankTransaction."Statement Type" := StatementType; TempOutstandingBankTransaction."Statement No." := StatementNo; BankAccountLedgerEntry.CalcFields("Check Ledger Entries"); if BankAccountLedgerEntry."Check Ledger Entries" > 0 then TempOutstandingBankTransaction.Type := TempOutstandingBankTransaction.Type::"Check Ledger Entry" else TempOutstandingBankTransaction.Type := TempOutstandingBankTransaction.Type::"Bank Account Ledger Entry"; TempOutstandingBankTransaction.Insert(); end; until BankAccountLedgerEntry.Next() = 0; end; procedure GetCurrencyCode(): Code[10] var BankAcc: Record "Bank Account"; begin if ("Bank Account No." = BankAcc."No.") or BankAcc.Get("Bank Account No.") then exit(BankAcc."Currency Code"); exit(''); end; local procedure SetOutstandingBankTrxFilter(var TempOutstandingBankTransaction: Record "Outstanding Bank Transaction" temporary; TransactionType: Option) begin TempOutstandingBankTransaction.Reset(); TempOutstandingBankTransaction.FilterGroup := 2; TempOutstandingBankTransaction.SetRange(Type, TransactionType); TempOutstandingBankTransaction.SetRange(Applied, false); TempOutstandingBankTransaction.FilterGroup := 0; end; local procedure RunOustandingBankTrxsPage(var TempOutstandingBankTransaction: Record "Outstanding Bank Transaction" temporary; TransactionType: Option) var OutstandingBankTransactions: Page "Outstanding Bank Transactions"; begin OutstandingBankTransactions.SetRecords(TempOutstandingBankTransaction); OutstandingBankTransactions.SetPageCaption(TransactionType); OutstandingBankTransactions.SetTableView(TempOutstandingBankTransaction); OutstandingBankTransactions.Run(); end; procedure CopyFromBankAccLedgerEntry(BankAccountLedgerEntry: Record "Bank Account Ledger Entry"; BankTransacType: Integer; StatementType: Integer; StatementNo: Code[20]; RemainingAmt: Decimal) begin Init(); "Entry No." := BankAccountLedgerEntry."Entry No."; "Posting Date" := BankAccountLedgerEntry."Posting Date"; "Document Type" := BankAccountLedgerEntry."Document Type".AsInteger(); "Document No." := BankAccountLedgerEntry."Document No."; "Bank Account No." := BankAccountLedgerEntry."Bank Account No."; Description := BankAccountLedgerEntry.Description; Amount := RemainingAmt; Type := BankTransacType; "Statement Type" := StatementType; "Statement No." := StatementNo; Insert(); end; procedure GetAppliedAmount(EntryNo: Integer) AppliedAmt: Decimal var AppliedPaymentEntry: Record "Applied Payment Entry"; begin AppliedPaymentEntry.SetRange("Applies-to Entry No.", EntryNo); if AppliedPaymentEntry.FindSet() then repeat AppliedAmt += AppliedPaymentEntry."Applied Amount"; until AppliedPaymentEntry.Next() = 0; exit(AppliedAmt); end; procedure GetRemainingAmount(EntryNo: Integer) RemainingAmt: Decimal var AppliedPaymentEntry: Record "Applied Payment Entry"; begin AppliedPaymentEntry.SetRange("Applies-to Entry No.", EntryNo); if not AppliedPaymentEntry.FindFirst() then exit; RemainingAmt := AppliedPaymentEntry.GetRemAmt(); exit(RemainingAmt); end;}