Table 1248 Ledger Entry Matching Buffer
src/Layers/W1/BaseApp/Bank/Reconciliation/LedgerEntryMatchingBuffer.Table.al384 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.Ledger;using Microsoft.Finance.GeneralLedger.Journal;using Microsoft.HumanResources.Payables;using Microsoft.Purchases.Payables;using Microsoft.Sales.Receivables;/// <summary>/// Temporary buffer table for managing ledger entries during payment application and bank reconciliation matching./// This table provides a standardized interface for working with different types of ledger entries (customer, vendor,/// employee, bank account) during matching algorithms. Enables efficient processing of large datasets by consolidating/// relevant fields from various ledger entry tables into a single, optimized structure for matching operations./// Supports payment discount calculations, tolerance handling, and complex matching scenarios./// </summary>/// <remarks>/// Key features include multi-ledger-type support, payment discount integration, remaining amount calculations,/// document reference matching, and optimized data access patterns. The table abstracts differences between/// customer, vendor, employee, and bank account ledger entries, providing unified matching logic while preserving/// specific characteristics of each entry type. Enables sophisticated matching algorithms with performance optimization/// for large transaction volumes and complex application scenarios./// </remarks>table 1248 "Ledger Entry Matching Buffer"{ Caption = 'Ledger Entry Matching Buffer'; ReplicateData = false; TableType = Temporary; DataClassification = CustomerContent; fields { /// <summary> /// Entry number from the source ledger entry table. /// Provides unique identification and enables linking back to original ledger records. /// </summary> field(1; "Entry No."; Integer) { Caption = 'Entry No.'; } /// <summary> /// Type of account that this ledger entry belongs to. /// Determines the source table and application logic for matching operations. /// </summary> field(2; "Account Type"; Enum "Matching Ledger Account Type") { Caption = 'Account Type'; } /// <summary> /// Account number for the ledger entry. /// Identifies the specific customer, vendor, employee, or bank account for the transaction. /// </summary> field(3; "Account No."; Code[20]) { Caption = 'Account No.'; } /// <summary> /// Balancing account type for the original ledger entry. /// Used for advanced matching scenarios and application logic validation. /// </summary> field(4; "Bal. Account Type"; enum "Gen. Journal Account Type") { Caption = 'Bal. Account Type'; } /// <summary> /// Balancing account number for the original ledger entry. /// Provides additional context for matching and validation processes. /// </summary> field(5; "Bal. Account No."; Code[20]) { Caption = 'Bal. Account No.'; } /// <summary> /// Description text from the original ledger entry. /// Used for text-based matching and user identification during manual application. /// </summary> field(7; Description; Text[100]) { } /// <summary> /// Document type from the original ledger entry. /// Determines application behavior and business logic for different transaction types. /// </summary> field(8; "Document Type"; Enum "Gen. Journal Document Type") { Caption = 'Document Type'; } /// <summary> /// Due date for payment or collection from the original ledger entry. /// Used for payment discount calculations and aging analysis during matching. /// </summary> field(9; "Due Date"; Date) { Caption = 'Due Date'; } /// <summary> /// Original posting date of the ledger entry. /// Used for date-based matching algorithms and chronological validation. /// </summary> field(10; "Posting Date"; Date) { Caption = 'Posting Date'; } /// <summary> /// Document number from the original ledger entry. /// Primary field for document reference matching with bank statement data. /// </summary> field(11; "Document No."; Code[20]) { Caption = 'Document No.'; } /// <summary> /// External document number from the original ledger entry. /// Used for matching with external references in bank statement transactions. /// </summary> field(12; "External Document No."; Code[35]) { Caption = 'External Document No.'; } /// <summary> /// Payment reference from the original ledger entry. /// Used for payment identification and reference-based matching algorithms. /// </summary> field(13; "Payment Reference"; Code[50]) { Caption = 'Payment Reference'; } /// <summary> /// Remaining open amount for the ledger entry. /// Core field for amount-based matching and application calculations. /// </summary> field(20; "Remaining Amount"; Decimal) { AutoFormatType = 0; Caption = 'Remaining Amount'; } /// <summary> /// Remaining amount including available payment discounts. /// Used for payment discount calculations and tolerance matching. /// </summary> field(21; "Remaining Amt. Incl. Discount"; Decimal) { AutoFormatType = 0; Caption = 'Remaining Amt. Incl. Discount'; } /// <summary> /// Due date for payment discount from the original ledger entry. /// Determines payment discount eligibility during application processes. /// </summary> field(22; "Pmt. Discount Due Date"; Date) { Caption = 'Pmt. Discount Due Date'; } } keys { key(Key1; "Entry No.", "Account Type") { Clustered = true; } } fieldgroups { } /// <summary> /// Inserts a customer ledger entry into the matching buffer with appropriate field mapping. /// Transfers relevant fields from customer ledger entry records into the standardized buffer format, /// handling currency conversions, payment discount calculations, and remaining amount computations. /// </summary> /// <param name="CustLedgerEntry">Customer ledger entry to insert into the matching buffer.</param> /// <param name="UseLCYAmounts">Whether to use local currency amounts for matching calculations.</param> /// <param name="UsePaymentDiscounts">Whether to include payment discounts in remaining amount calculations.</param> procedure InsertFromCustomerLedgerEntry(CustLedgerEntry: Record "Cust. Ledger Entry"; UseLCYAmounts: Boolean; var UsePaymentDiscounts: Boolean) begin OnBeforeProcedureInsertFromCustomerLedgerEntry(CustLedgerEntry); Clear(Rec); "Entry No." := CustLedgerEntry."Entry No."; "Account Type" := "Account Type"::Customer; "Account No." := CustLedgerEntry."Customer No."; "Due Date" := CustLedgerEntry."Due Date"; "Posting Date" := CustLedgerEntry."Posting Date"; "Document No." := CustLedgerEntry."Document No."; "External Document No." := CustLedgerEntry."External Document No."; "Payment Reference" := CustLedgerEntry."Payment Reference"; if UseLCYAmounts then "Remaining Amount" := CustLedgerEntry."Remaining Amt. (LCY)" else "Remaining Amount" := CustLedgerEntry."Remaining Amount"; "Pmt. Discount Due Date" := GetCustomerLedgerEntryDiscountDueDate(CustLedgerEntry); "Remaining Amt. Incl. Discount" := "Remaining Amount"; if "Pmt. Discount Due Date" > 0D then begin if UseLCYAmounts then "Remaining Amt. Incl. Discount" -= Round(CustLedgerEntry."Remaining Pmt. Disc. Possible" / CustLedgerEntry."Adjusted Currency Factor") else "Remaining Amt. Incl. Discount" -= CustLedgerEntry."Remaining Pmt. Disc. Possible"; UsePaymentDiscounts := true; end; OnBeforeInsertFromCustomerLedgerEntry(Rec, CustLedgerEntry); Insert(true); end; procedure InsertFromVendorLedgerEntry(VendorLedgerEntry: Record "Vendor Ledger Entry"; UseLCYAmounts: Boolean; var UsePaymentDiscounts: Boolean) begin OnBeforeProcedureInsertFromVendorLedgerEntry(VendorLedgerEntry); Clear(Rec); "Entry No." := VendorLedgerEntry."Entry No."; "Account Type" := "Account Type"::Vendor; "Account No." := VendorLedgerEntry."Vendor No."; "Due Date" := VendorLedgerEntry."Due Date"; "Posting Date" := VendorLedgerEntry."Posting Date"; "Document No." := VendorLedgerEntry."Document No."; "External Document No." := VendorLedgerEntry."External Document No."; "Payment Reference" := VendorLedgerEntry."Payment Reference"; if UseLCYAmounts then "Remaining Amount" := VendorLedgerEntry."Remaining Amt. (LCY)" else "Remaining Amount" := VendorLedgerEntry."Remaining Amount"; "Pmt. Discount Due Date" := GetVendorLedgerEntryDiscountDueDate(VendorLedgerEntry); "Remaining Amt. Incl. Discount" := "Remaining Amount"; if "Pmt. Discount Due Date" > 0D then begin if UseLCYAmounts then "Remaining Amt. Incl. Discount" -= Round(VendorLedgerEntry."Remaining Pmt. Disc. Possible" / VendorLedgerEntry."Adjusted Currency Factor") else "Remaining Amt. Incl. Discount" -= VendorLedgerEntry."Remaining Pmt. Disc. Possible"; UsePaymentDiscounts := true; end; OnBeforeInsertFromVendorLedgerEntry(Rec, VendorLedgerEntry); Insert(true); end; procedure InsertFromEmployeeLedgerEntry(EmployeeLedgerEntry: Record "Employee Ledger Entry") begin InsertFromEmployeeLedgerEntry(EmployeeLedgerEntry, false); end; procedure InsertFromEmployeeLedgerEntry(EmployeeLedgerEntry: Record "Employee Ledger Entry"; UseLCYAmounts: Boolean) begin Clear(Rec); "Entry No." := EmployeeLedgerEntry."Entry No."; "Account Type" := "Account Type"::Employee; "Account No." := EmployeeLedgerEntry."Employee No."; "Posting Date" := EmployeeLedgerEntry."Posting Date"; "Document No." := EmployeeLedgerEntry."Document No."; "Payment Reference" := EmployeeLedgerEntry."Payment Reference"; if UseLCYAmounts then "Remaining Amount" := EmployeeLedgerEntry."Remaining Amt. (LCY)" else "Remaining Amount" := EmployeeLedgerEntry."Remaining Amount"; OnBeforeInsertFromEmployeeLedgerEntry(Rec, EmployeeLedgerEntry); Insert(true); end; procedure InsertFromBankAccLedgerEntry(BankAccountLedgerEntry: Record "Bank Account Ledger Entry") begin Clear(Rec); "Entry No." := BankAccountLedgerEntry."Entry No."; "Account Type" := "Account Type"::"Bank Account"; "Account No." := BankAccountLedgerEntry."Bank Account No."; "Bal. Account Type" := BankAccountLedgerEntry."Bal. Account Type"; "Bal. Account No." := BankAccountLedgerEntry."Bal. Account No."; Description := BankAccountLedgerEntry.Description; "Posting Date" := BankAccountLedgerEntry."Posting Date"; "Document Type" := BankAccountLedgerEntry."Document Type"; "Document No." := BankAccountLedgerEntry."Document No."; "External Document No." := BankAccountLedgerEntry."External Document No."; "Remaining Amount" := BankAccountLedgerEntry."Remaining Amount"; "Remaining Amt. Incl. Discount" := "Remaining Amount"; OnBeforeInsertFromBankAccountLedgerEntry(Rec, BankAccountLedgerEntry); Insert(true); end; procedure GetApplicableRemainingAmount(BankAccReconciliationLine: Record "Bank Acc. Reconciliation Line"; UsePaymentDiscounts: Boolean): Decimal begin if not UsePaymentDiscounts then exit("Remaining Amount"); if BankAccReconciliationLine."Transaction Date" > "Pmt. Discount Due Date" then exit("Remaining Amount"); exit("Remaining Amt. Incl. Discount"); end; procedure GetNoOfLedgerEntriesWithinRange(MinAmount: Decimal; MaxAmount: Decimal; TransactionDate: Date; UsePaymentDiscounts: Boolean): Integer begin exit(GetNoOfLedgerEntriesInAmountRange(MinAmount, MaxAmount, TransactionDate, '>=%1&<=%2', UsePaymentDiscounts)); end; procedure GetNoOfLedgerEntriesOutsideRange(MinAmount: Decimal; MaxAmount: Decimal; TransactionDate: Date; UsePaymentDiscounts: Boolean): Integer begin exit(GetNoOfLedgerEntriesInAmountRange(MinAmount, MaxAmount, TransactionDate, '<%1|>%2', UsePaymentDiscounts)); end; local procedure GetNoOfLedgerEntriesInAmountRange(MinAmount: Decimal; MaxAmount: Decimal; TransactionDate: Date; RangeFilter: Text; UsePaymentDiscounts: Boolean): Integer var NoOfEntreis: Integer; begin SetFilter("Remaining Amount", RangeFilter, MinAmount, MaxAmount); SetFilter("Pmt. Discount Due Date", '<%1', TransactionDate); NoOfEntreis := Count; SetRange("Remaining Amount"); if UsePaymentDiscounts then begin SetFilter("Remaining Amt. Incl. Discount", RangeFilter, MinAmount, MaxAmount); SetFilter("Pmt. Discount Due Date", '>=%1', TransactionDate); NoOfEntreis += Count; SetRange("Remaining Amt. Incl. Discount"); end; SetRange("Pmt. Discount Due Date"); exit(NoOfEntreis); end; local procedure GetCustomerLedgerEntryDiscountDueDate(CustLedgerEntry: Record "Cust. Ledger Entry"): Date begin if CustLedgerEntry."Remaining Pmt. Disc. Possible" = 0 then exit(0D); if CustLedgerEntry."Pmt. Disc. Tolerance Date" >= CustLedgerEntry."Pmt. Discount Date" then exit(CustLedgerEntry."Pmt. Disc. Tolerance Date"); exit(CustLedgerEntry."Pmt. Discount Date"); end; local procedure GetVendorLedgerEntryDiscountDueDate(VendorLedgerEntry: Record "Vendor Ledger Entry"): Date begin if VendorLedgerEntry."Remaining Pmt. Disc. Possible" = 0 then exit(0D); if VendorLedgerEntry."Pmt. Disc. Tolerance Date" >= VendorLedgerEntry."Pmt. Discount Date" then exit(VendorLedgerEntry."Pmt. Disc. Tolerance Date"); exit(VendorLedgerEntry."Pmt. Discount Date"); end; [IntegrationEvent(false, false)] local procedure OnBeforeInsertFromCustomerLedgerEntry(var LedgerEntryMatchingBuffer: Record "Ledger Entry Matching Buffer"; CustLedgerEntry: Record "Cust. Ledger Entry") begin end; [IntegrationEvent(false, false)] local procedure OnBeforeInsertFromEmployeeLedgerEntry(var LedgerEntryMatchingBuffer: Record "Ledger Entry Matching Buffer"; EmployeeLedgerEntry: Record "Employee Ledger Entry") begin end; [IntegrationEvent(false, false)] local procedure OnBeforeInsertFromVendorLedgerEntry(var LedgerEntryMatchingBuffer: Record "Ledger Entry Matching Buffer"; VendorLedgerEntry: Record "Vendor Ledger Entry") begin end; [IntegrationEvent(false, false)] local procedure OnBeforeInsertFromBankAccountLedgerEntry(var LedgerEntryMatchingBuffer: Record "Ledger Entry Matching Buffer"; BankAccountLedgerEntry: Record "Bank Account Ledger Entry") begin end; [IntegrationEvent(false, false)] local procedure OnBeforeProcedureInsertFromVendorLedgerEntry(var VendorLedgerEntry: Record "Vendor Ledger Entry") begin end; [IntegrationEvent(false, false)] local procedure OnBeforeProcedureInsertFromCustomerLedgerEntry(var CustLedgerEntry: Record "Cust. Ledger Entry") begin end;}