Table 1284 Outstanding Bank Transaction

Base Application, Microsoft.Bank.Reconciliation

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;}