Table "Bank Acc. Reconciliation Line"
ID 274
Namespace: Microsoft.Bank.Reconciliation
Detailed bank statement lines for bank account reconciliation and payment application processes.
This table contains individual transaction records imported from bank statements or payment files,
providing the line-item detail for reconciliation workflows. Each line represents a single bank
transaction with amount, description, and matching information for application to ledger entries.
Supports both automated and manual matching scenarios with comprehensive tracking of applied amounts.
Key features include statement import handling, automatic matching integration, manual application support,
text-to-account mapping, difference management, and posting preparation. The table works closely with
Applied Payment Entry records to track detailed payment applications and supports complex scenarios
including partial payments, split transactions, and multi-currency reconciliation.
Integration points include bank statement import, matching algorithms, payment application rules,
and general journal posting processes for finalizing reconciled transactions.
Properties
| Name |
Value |
| Caption |
Bank Acc. Reconciliation Line
|
| Permissions |
TableData "Data Exch. Field" = rimd
|
| DataClassification |
CustomerContent
|
Fields
| Name |
Type |
Description |
| "Bank Account No." |
Code[20]
|
Bank account number that this reconciliation line relates to.
Links the line to the specific bank account being reconciled and determines currency settings.
|
| "Statement No." |
Code[20]
|
Statement number identifying the bank reconciliation or payment application batch.
Groups related statement lines under a single reconciliation session.
|
| "Statement Line No." |
Integer
|
Sequential line number within the bank statement.
Provides unique identification and ordering of transactions within a statement.
|
| "Document No." |
Code[20]
|
Document number associated with the bank transaction.
Contains reference numbers from bank statements such as check numbers or transaction IDs.
|
| "Transaction Date" |
Date
|
Date when the bank transaction occurred.
Used for matching and validation during reconciliation processes.
|
| Description |
Text[100]
|
Descriptive text for the bank transaction.
Contains transaction details imported from bank statements, used for matching and reporting.
|
| "Statement Amount" |
Decimal
|
Amount of the bank statement transaction.
Represents the actual bank transaction amount to be reconciled against ledger entries.
|
| Difference |
Decimal
|
Calculated difference between statement amount and applied amount.
Shows remaining unreconciled amount that requires attention or posting to difference accounts.
|
| "Applied Amount" |
Decimal
|
Total amount applied to ledger entries for this statement line.
Calculated sum of all payment applications for this bank transaction.
|
| "Applied Entries" |
Integer
|
Number of ledger entries applied to this statement line.
Provides quick reference to application complexity and enables drill-down to application details.
|
| "Value Date" |
Date
|
Value date of the bank transaction as reported by the bank.
May differ from transaction date and affects interest calculations and reporting.
|
| "Ready for Application" |
Boolean
|
Indicates whether the statement line is ready for automatic payment application.
Used to control which lines participate in automated matching processes.
|
| "Check No." |
Code[20]
|
Check number associated with the bank transaction.
Contains check reference for check-based payments imported from bank statements.
|
| "Related-Party Name" |
Text[250]
|
Name of the related party (customer, vendor) for the transaction.
Used for automatic matching and payment application to appropriate accounts.
|
| "Additional Transaction Info" |
Text[100]
|
Additional transaction information from the bank statement.
Contains supplementary details that may assist in transaction identification and matching.
|
| "Data Exch. Entry No." |
Integer
|
Data exchange entry number linking to the imported bank statement file.
References the specific import session for audit trail and troubleshooting.
|
| "Data Exch. Line No." |
Integer
|
Line number within the data exchange entry.
Identifies the specific line in the imported file that created this statement line.
|
| "Statement Type" |
Enum Microsoft.Bank.Reconciliation."Bank Acc. Rec. Stmt. Type"
|
Specifies the type of the bank reconciliation statement for the line.
|
| "Account Type" |
Enum Microsoft.Finance.GeneralLedger.Journal."Gen. Journal Account Type"
|
Specifies the account type for the bank reconciliation line.
|
| "Account No." |
Code[20]
|
Specifies the account number for the bank reconciliation line.
|
| "Transaction Text" |
Text[140]
|
Specifies the transaction text from the bank statement.
|
| "Related-Party Bank Acc. No." |
Text[100]
|
Specifies the bank account number of the related party from the bank statement.
|
| "Related-Party Address" |
Text[100]
|
Specifies the address of the related party from the bank statement.
|
| "Related-Party City" |
Text[50]
|
Specifies the city of the related party from the bank statement.
|
| "Payment Reference No." |
Code[50]
|
Specifies the payment reference number from the bank statement.
|
| "Shortcut Dimension 1 Code" |
Code[20]
|
Specifies the first shortcut dimension code for the bank reconciliation line.
|
| "Shortcut Dimension 2 Code" |
Code[20]
|
Specifies the second shortcut dimension code for the bank reconciliation line.
|
| "Match Confidence" |
Enum Microsoft.Bank.Reconciliation."Bank Rec. Match Confidence"
|
Specifies the confidence level of the automatic matching for the bank reconciliation line.
|
| "Match Quality" |
Integer
|
Specifies the quality score of the automatic matching for the bank reconciliation line.
|
| "Sorting Order" |
Integer
|
Specifies the sorting order for the bank reconciliation line.
|
| "Parent Line No." |
Integer
|
Specifies the parent line number for grouped bank reconciliation lines.
|
| "Transaction ID" |
Text[50]
|
Specifies the unique transaction identifier from the bank statement.
|
| "Dimension Set ID" |
Integer
|
Specifies the ID of the dimension set for the bank reconciliation line.
|
| SystemId |
Guid
|
|
| SystemCreatedAt |
DateTime
|
|
| SystemCreatedBy |
Guid
|
|
| SystemModifiedAt |
DateTime
|
|
| SystemModifiedBy |
Guid
|
|
| SystemCreatedByUserName |
Text[50]
|
|
| SystemCreatedByFullName |
Text[80]
|
|
| SystemModifiedByUserName |
Text[50]
|
|
| SystemModifiedByFullName |
Text[80]
|
|
| SystemRowVersion |
BigInteger
|
|
Methods
DisplayApplication
Opens the payment application interface to display and manage applications for this reconciliation line.
For bank reconciliation, shows bank account ledger entries; for payment application, shows detailed payment applications.
Provides interactive interface for reviewing, modifying, or removing payment applications.
procedure DisplayApplication()
TransferFromPostedPaymentReconLine
procedure TransferFromPostedPaymentReconLine(PostedPaymentReconLine: Record "Posted Payment Recon. Line")
Parameters
GetPaymentFile
procedure GetPaymentFile(var DataExchField: Record "Data Exch. Field"): Boolean
Parameters
Returns
GetCurrencyCode
Retrieves the currency code associated with the bank account for this reconciliation line.
Optimizes performance by caching the bank account record when possible.
procedure GetCurrencyCode(): Code[10]
Returns
| Type |
Description |
|
Code[10] |
Currency code of the associated bank account; empty string if bank account not found or uses local currency.
|
GetStyle
procedure GetStyle(): Text
Returns
ClearDataExchEntries
Clears data exchange entries and related import data for this reconciliation line.
Removes data exchange field records and updates related reconciliation lines that share the same data exchange entry.
Used during cleanup operations when removing or modifying imported statement data.
procedure ClearDataExchEntries()
ShowDimensions
procedure ShowDimensions()
CreateDim
procedure CreateDim(DefaultDimSource: List of [Dictionary of [Integer, Code[20]]])
Parameters
| Name |
Type |
Description |
|
DefaultDimSource
|
List of [Dictionary of [Integer, Code[20]]] |
|
SetUpNewLine
ValidateShortcutDimCode
procedure ValidateShortcutDimCode(FieldNumber: Integer; var ShortcutDimCode: Code[20])
Parameters
| Name |
Type |
Description |
|
FieldNumber
|
Integer |
|
|
ShortcutDimCode
|
Code[20] |
|
ShowShortcutDimCode
procedure ShowShortcutDimCode(var ShortcutDimCode: array[8] of Code[20])
Parameters
| Name |
Type |
Description |
|
ShortcutDimCode
|
array[8] of Code[20] |
|
AcceptAppliedPaymentEntriesSelectedLines
procedure AcceptAppliedPaymentEntriesSelectedLines()
RejectAppliedPaymentEntriesSelectedLines
procedure RejectAppliedPaymentEntriesSelectedLines()
RejectAppliedPayment
procedure RejectAppliedPayment()
AcceptApplication
procedure AcceptApplication()
FilterManyToOneMatches
procedure FilterManyToOneMatches(var BankAccRecMatchBuffer: Record "Bank Acc. Rec. Match Buffer")
Parameters
SetManualApplication
procedure SetManualApplication()
GetAppliedEntryAccountName
procedure GetAppliedEntryAccountName(AppliedToEntryNo: Integer): Text
Parameters
| Name |
Type |
Description |
|
AppliedToEntryNo
|
Integer |
|
Returns
GetAppliedToName
procedure GetAppliedToName(): Text
Returns
GetAppliedEntryAccountType
procedure GetAppliedEntryAccountType(AppliedToEntryNo: Integer): Integer
Parameters
| Name |
Type |
Description |
|
AppliedToEntryNo
|
Integer |
|
Returns
GetAppliedToAccountType
procedure GetAppliedToAccountType(): Integer
Returns
GetAppliedEntryAccountNo
procedure GetAppliedEntryAccountNo(AppliedToEntryNo: Integer): Code[20]
Parameters
| Name |
Type |
Description |
|
AppliedToEntryNo
|
Integer |
|
Returns
| Type |
Description |
|
Code[20] |
|
GetAppliedToAccountNo
procedure GetAppliedToAccountNo(): Code[20]
Returns
| Type |
Description |
|
Code[20] |
|
AppliedEntryAccountDrillDown
procedure AppliedEntryAccountDrillDown(AppliedEntryNo: Integer)
Parameters
| Name |
Type |
Description |
|
AppliedEntryNo
|
Integer |
|
AppliedToDrillDown
procedure AppliedToDrillDown()
OpenAccountPage
procedure OpenAccountPage(AccountType: Option; AccountNo: Code[20])
Parameters
| Name |
Type |
Description |
|
AccountType
|
Option |
|
|
AccountNo
|
Code[20] |
|
DrillDownOnNoOfLedgerEntriesWithinAmountTolerance
procedure DrillDownOnNoOfLedgerEntriesWithinAmountTolerance()
DrillDownOnNoOfLedgerEntriesOutsideOfAmountTolerance
procedure DrillDownOnNoOfLedgerEntriesOutsideOfAmountTolerance()
FilterBankRecLinesByDate
procedure FilterBankRecLinesByDate(BankAccReconciliation: Record "Bank Acc. Reconciliation"; Overwrite: Boolean)
Parameters
FilterBankRecLines
procedure FilterBankRecLines(BankAccReconciliation: Record "Bank Acc. Reconciliation"; Overwrite: Boolean)
Parameters
FilterBankRecLines
procedure FilterBankRecLines(BankAccReconciliation: Record "Bank Acc. Reconciliation")
Parameters
LinesExist
procedure LinesExist(BankAccRecon: Record "Bank Acc. Reconciliation"): Boolean
Parameters
Returns
GetAppliedToDocumentNo
procedure GetAppliedToDocumentNo(SeparatorTxt: Text): Text
Parameters
| Name |
Type |
Description |
|
SeparatorTxt
|
Text |
|
Returns
GetAppliedToDocumentNo
procedure GetAppliedToDocumentNo(): Text
Returns
GetAppliedToEntryNo
procedure GetAppliedToEntryNo(): Text
Returns
GetAppliedToEntryFilter
procedure GetAppliedToEntryFilter(): Text
Returns
ShowAppliedToEntries
procedure ShowAppliedToEntries()
TransferRemainingAmountToAccount
procedure TransferRemainingAmountToAccount()
GetStatusText
procedure GetStatusText(): Text
Returns
GetAmountRangeForTolerance
procedure GetAmountRangeForTolerance(var MinAmount: Decimal; var MaxAmount: Decimal)
Parameters
| Name |
Type |
Description |
|
MinAmount
|
Decimal |
|
|
MaxAmount
|
Decimal |
|
GetAppliedPmtData
procedure GetAppliedPmtData(var AppliedPmtEntry: Record "Applied Payment Entry"; var RemainingAmountAfterPosting: Decimal; var DifferenceStatementAmtToApplEntryAmount: Decimal; PmtAppliedToTxt: Text)
Parameters
IsTransactionPostedAndReconciled
procedure IsTransactionPostedAndReconciled(): Boolean
Returns
CanImport
procedure CanImport(): Boolean
Returns
BankStatementLinesListIsEmpty
procedure BankStatementLinesListIsEmpty(StatementNo: Code[20]; StatementType: Option; BankAccountNo: Code[20]): Boolean
Parameters
| Name |
Type |
Description |
|
StatementNo
|
Code[20] |
|
|
StatementType
|
Option |
|
|
BankAccountNo
|
Code[20] |
|
Returns
GetAppliesToID
procedure GetAppliesToID(): Code[50]
Returns
| Type |
Description |
|
Code[50] |
|
GetDescription
procedure GetDescription(): Text[100]
Returns
| Type |
Description |
|
Text[100] |
|
GetMatchedAutomaticallyFilter
procedure GetMatchedAutomaticallyFilter(): Text
Returns
CreateDimFromDefaultDim
procedure CreateDimFromDefaultDim()
Events
OnAfterInitDefaultDimensionSources
[IntegrationEvent(False,False)]
local procedure OnAfterInitDefaultDimensionSources(var BankAccReconciliationLine: Record "Bank Acc. Reconciliation Line"; var DefaultDimSource: List of [Dictionary of [Integer, Code[20]]])
Parameters
OnAfterSetUpNewLine
[IntegrationEvent(False,False)]
local procedure OnAfterSetUpNewLine(var BankAccReconciliationLine: Record "Bank Acc. Reconciliation Line"; xBankAccReconciliationLine: Record "Bank Acc. Reconciliation Line")
Parameters
OnAfterShowDimensions
[IntegrationEvent(False,False)]
local procedure OnAfterShowDimensions(var BankAccReconciliationLine: Record "Bank Acc. Reconciliation Line")
Parameters
OnAfterCreateDim
[IntegrationEvent(False,False)]
local procedure OnAfterCreateDim(var BankAccReconciliationLine: Record "Bank Acc. Reconciliation Line"; DefaultDimSource: List of [Dictionary of [Integer, Code[20]]])
Parameters
OnAfterFilterBankRecLines
[IntegrationEvent(False,False)]
local procedure OnAfterFilterBankRecLines(var Rec: Record "Bank Acc. Reconciliation Line"; BankAccRecon: Record "Bank Acc. Reconciliation")
Parameters
OnAfterGetAccountName
[IntegrationEvent(False,False)]
local procedure OnAfterGetAccountName(AccountType: Option; AccountNo: Code[20]; var Name: Text)
Parameters
| Name |
Type |
Description |
|
AccountType
|
Option |
|
|
AccountNo
|
Code[20] |
|
|
Name
|
Text |
|
OnAfterGetAppliedEntryAccountNo
[IntegrationEvent(False,False)]
local procedure OnAfterGetAppliedEntryAccountNo(var BankAccReconciliationLine: Record "Bank Acc. Reconciliation Line"; AppliedToEntryNo: Integer; var AccountNo: Code[20])
Parameters
OnAfterOpenAccountPage
[IntegrationEvent(False,False)]
local procedure OnAfterOpenAccountPage(AccountType: Option; AccountNo: Code[20])
Parameters
| Name |
Type |
Description |
|
AccountType
|
Option |
|
|
AccountNo
|
Code[20] |
|
OnAfterRemoveAppliedPaymentEntries
[IntegrationEvent(False,False)]
local procedure OnAfterRemoveAppliedPaymentEntries(var BankAccReconciliationLine: Record "Bank Acc. Reconciliation Line")
Parameters
OnAfterDrillDownOnNoOfLedgerEntriesBasedOnAmount
[IntegrationEvent(False,False)]
local procedure OnAfterDrillDownOnNoOfLedgerEntriesBasedOnAmount(var BankAccReconciliationLine: Record "Bank Acc. Reconciliation Line"; AmountFilter: Text)
Parameters
OnAfterValidateShortcutDimCode
[IntegrationEvent(False,False)]
local procedure OnAfterValidateShortcutDimCode(var BankAccReconciliationLine: Record "Bank Acc. Reconciliation Line"; var xBankAccReconciliationLine: Record "Bank Acc. Reconciliation Line"; FieldNumber: Integer; var ShortcutDimCode: Code[20])
Parameters
OnBeforeOnModify
[IntegrationEvent(False,False)]
local procedure OnBeforeOnModify(var BankAccReconciliationLine: Record "Bank Acc. Reconciliation Line"; var IsHandled: Boolean)
Parameters
OnBeforeValidateShortcutDimCode
[IntegrationEvent(False,False)]
local procedure OnBeforeValidateShortcutDimCode(var BankAccReconciliationLine: Record "Bank Acc. Reconciliation Line"; var xBankAccReconciliationLine: Record "Bank Acc. Reconciliation Line"; FieldNumber: Integer; var ShortcutDimCode: Code[20])
Parameters
OnDisplayApplicationOnAfterBankAccLedgEntrySetFilters
[IntegrationEvent(False,False)]
local procedure OnDisplayApplicationOnAfterBankAccLedgEntrySetFilters(var BankAccReconciliationLine: Record "Bank Acc. Reconciliation Line"; var BankAccLedgEntry: Record "Bank Account Ledger Entry")
Parameters
OnBeforeIsTransactionPostedAndReconciled
[IntegrationEvent(False,False)]
local procedure OnBeforeIsTransactionPostedAndReconciled(var BankAccReconciliationLine: Record "Bank Acc. Reconciliation Line"; var ReturnValue: Boolean; var IsHandled: Boolean)
Parameters
OnDisplayApplicationOnAfterSetBankAccReconcLine
[IntegrationEvent(False,False)]
local procedure OnDisplayApplicationOnAfterSetBankAccReconcLine(var PaymentApplication: Page "Payment Application")
Parameters
OnRemoveApplicationOnAfterBankAccLedgEntrySetFilters
[IntegrationEvent(False,False)]
local procedure OnRemoveApplicationOnAfterBankAccLedgEntrySetFilters(var BankAccReconciliationLine: Record "Bank Acc. Reconciliation Line"; var BankAccLedgEntry: Record "Bank Account Ledger Entry")
Parameters
OnBeforeGetStyle
[IntegrationEvent(False,False)]
local procedure OnBeforeGetStyle(var BankAccReconciliationLine: Record "Bank Acc. Reconciliation Line"; var Result: Text; var IsHandled: Boolean)
Parameters
OnBeforeGetCustomerLedgerEntriesInAmountRange
[IntegrationEvent(False,False)]
local procedure OnBeforeGetCustomerLedgerEntriesInAmountRange(BankAccReconciliationLine: Record "Bank Acc. Reconciliation Line"; var CustLedgerEntry: Record "Cust. Ledger Entry"; AccountNo: Code[20]; AmountFilter: Text; MinAmount: Decimal; MaxAmount: Decimal; var Result: Integer; var IsHandled: Boolean)
Parameters
OnBeforeGetVendorLedgerEntriesInAmountRange
[IntegrationEvent(False,False)]
local procedure OnBeforeGetVendorLedgerEntriesInAmountRange(BankAccReconciliationLine: Record "Bank Acc. Reconciliation Line"; var VendorLedgerEntry: Record "Vendor Ledger Entry"; AccountNo: Code[20]; AmountFilter: Text; MinAmount: Decimal; MaxAmount: Decimal; var Result: Integer; var IsHandled: Boolean)
Parameters
OnBeforeShowDimensions
[IntegrationEvent(False,False)]
local procedure OnBeforeShowDimensions(var BankAccReconciliationLine: Record "Bank Acc. Reconciliation Line"; var IsHandled: Boolean)
Parameters
OnGetAppliedPmtDataOnAfterLoopIteration
[IntegrationEvent(False,False)]
local procedure OnGetAppliedPmtDataOnAfterLoopIteration(var BankAccReconciliationLine: Record "Bank Acc. Reconciliation Line"; AppliedPmtEntry: Record "Applied Payment Entry")
Parameters
OnAfterTransferFromPostedPaymentReconLine
[IntegrationEvent(False,False)]
local procedure OnAfterTransferFromPostedPaymentReconLine(var BankAccReconciliationLine: Record "Bank Acc. Reconciliation Line"; PostedPaymentReconLine: Record "Posted Payment Recon. Line")
Parameters
See also