pageFinanceofficial - Microsoftderived - from the source, no model text

Page 1290 "Payment Reconciliation Journal"

Base Application · Microsoft.Bank.Reconciliation

Across versions

  1. BC23present
  2. BC241 events changed
  3. BC25-30unchanged

Neighbourhood 20 connected objects and pages

Table 274 "Bank Acc. Reconciliation Line" (relates to)Bank Acc. Reconciliation LineCodeunit 1351 "Telemetry Subscribers" (event subscribers)Telemetry SubscribersCodeunit 20117 "AMC Bank Assisted Mgt." (event subscribers)AMC Bank Assisted Mgt.Codeunit 1255 "Match Bank Payments" (calls, 2 links)Match Bank PaymentsCodeunit 371 "Bank Acc. Recon. Post (Yes/No)" (calls)Bank Acc. Recon. Post (Yes/No)Codeunit 386 "Reverse Payment Rec. Journal" (calls)Reverse Payment Rec. JournalCodeunit 408 "DimensionManagement" (calls)DimensionManagementCodeunit 6723 "Server Setting" (calls)Server SettingCodeunit 8703 "Feature Telemetry" (calls)Feature TelemetryCodeunit 9022 "Pmt. Rec. Journals Launcher" (calls)Pmt. Rec. Journals LauncherTable 273 "Bank Acc. Reconciliation" (calls)Bank Acc. ReconciliationApply payments to unpaid sales documents (Learn pages)Apply payments to unpaid sal…Reconcile bank accounts and apply payments (Learn pages)Reconcile bank accounts and …Reconcile payments using automatic application (Learn pages)Reconcile payments using aut…Review and apply payments manually after automatic application (Learn pages)Rules for automatic application of payments (Learn pages)Set Up Yodlee Bank Feeds (Learn pages)Setting up Text-to-Account mapping for recurring payments (Learn pages)Using the transfer difference to account feature to reconcile payments (Learn pages)Working with general journals to post directly to G/L (Learn pages)

Open in the neighbourhood explorer

One hop out, from the extracted relations and call graph. Up to 40 shown; the sections below list them all.

Base Application · Microsoft.Bank.Reconciliation · BC23-30 · source at ea08af5e · facts from BC29

Properties

Property Value
Caption Payment Reconciliation Journal
SourceTable Bank Acc. Reconciliation Line
PageType Worksheet

Fields on this page

Layout controls in source order, grouped by the container they sit in. Shows: the table field a control is bound to (or its expression as written); ToolTip: the control’s own, else the bound field’s (marked).

Group Control Shows ToolTip
Control1 Match Confidence Match Confidence Specifies the quality of the automatic payment application on the journal line. from the table field
Transaction Date Transaction Date Specifies the date when the payment represented by the journal line was recorded in the bank account.
Transaction Text Transaction Text Specifies the text that the customer or vendor entered on that payment transaction that is represented by the journal line. from the table field
Transaction ID Transaction ID Specifies the ID of the imported bank transaction. from the table field
Transaction Amount Statement Amount Specifies the amount that was paid into the bank account and then imported as a bank statement line represented by the journal line. from the table field
Applied Amount Applied Amount Specifies the amount that has been applied to one or more open entries.
Difference Difference Specifies the difference between the amount in the Statement Amount field and the amount in the Applied Amount field. from the table field
Difference from Remaining Amount StatementToRemAmtDifference Specifies the difference between the values in the Statement Amount and the Remaining Amount After Posting fields.
Document No. Rec.GetAppliedToDocumentNo() Specifies the document number of the open entry that the payment is applied to.
Description AppliedPmtEntry.Description Specifies the description on the open entry that the payment is applied to.
Due Date AppliedPmtEntry."Due Date" Specifies the due date on the open entry that the payment is applied to.
Account Name Rec.GetAppliedToName() Specifies the name of the customer or vendor that the payment is applied to.
Account Type Account Type Specifies the type of account that the payment application will be posted to when you post the worksheet.
Account No. Account No. Specifies the account number that the payment application will be posted to when you post the worksheet.
Posting Date AppliedPmtEntry."Posting Date" Specifies the posting date on the open entry that the payment is applied to.
Entry Currency Code AppliedPmtEntry."Currency Code" Specifies the currency code on the open entry that the payment is applied to.
Match Details MatchDetails Specifies details about the payment application on the journal line.
Applied Entries Applied Entries Specifies for a journal line where the payment has been applied, how many entries the payment has been applied to.
Remaining Amount After Posting RemainingAmountAfterPosting Specifies the amount that remains to be paid on the open entry that the payment is applied to.
Additional Transaction Info Additional Transaction Info Specifies additional information on the bank statement line for the payment. from the table field
Related-Party Address Related-Party Address Specifies the address of the customer or vendor who made the payment that is represented by the journal line. from the table field
Related-Party Bank Acc. No. Related-Party Bank Acc. No. Specifies the bank account number of the customer or vendor who made the payment. from the table field
Related-Party City Related-Party City Specifies the city name of the customer or vendor. from the table field
Related-Party Name Related-Party Name Specifies the name of the customer or vendor who made the payment that is represented by the journal line. from the table field
Shortcut Dimension 1 Code Shortcut Dimension 1 Code Specifies the code for Shortcut Dimension 1, which is one of two global dimension codes that you set up on the General Ledger Setup page. from the table field
Shortcut Dimension 2 Code Shortcut Dimension 2 Code Specifies the code for Shortcut Dimension 2, which is one of two global dimension codes that you set up om the General Ledger Setup page. from the table field
ShortcutDimCode3 ShortcutDimCode[3] Specifies the dimension value code linked to the journal line.
ShortcutDimCode4 ShortcutDimCode[4] Specifies the dimension value code linked to the journal line.
ShortcutDimCode5 ShortcutDimCode[5] Specifies the dimension value code linked to the journal line.
ShortcutDimCode6 ShortcutDimCode[6] Specifies the dimension value code linked to the journal line.
ShortcutDimCode7 ShortcutDimCode[7] Specifies the dimension value code linked to the journal line.
ShortcutDimCode8 ShortcutDimCode[8] Specifies the dimension value code linked to the journal line.
ReviewRequiredGroup Number of Lines TotalLinesCount Specifies the total number of lines in the journal.
Lines For Review LinesForReviewCount Specifies the number of lines that you should review because they were matched automatically. The matching rule used is marked as Review Required on the Payment Application Rules page.
Lines With differences LinesWithDifferenceCount Specifies the number of lines that must be addressed before posting.
TotalTransactionAmountGroup1 Total Transaction Amount BankAccReconciliation."Total Transaction Amount" Specifies the sum of values in the Statement Amount field on all the lines on the Payment Reconciliation Journal page.
Total Credit Amount BankAccReconciliation."Total Paid Amount" Specifies the sum of values in the Statement Amount field on all the paid lines on the Payment Reconciliation Journal page.
Total Debit Amount BankAccReconciliation."Total Received Amount" Specifies the sum of values in the Statement Amount field on all the received lines on the Payment Reconciliation Journal page.
Balances1 Balance on Bank Account BankAccReconciliation."Total Balance on Bank Account" Specifies the balance of the bank account per the last time you reconciled the bank account.
Balance After Posting BankAccReconciliation."Total Balance on Bank Account" + BankAccReconciliation."Total Unposted Applied Amount" + AppliedBankAmounts Specifies the total amount that will exist on the bank account as a result of payment applications that you post on the Payment Reconciliation Journal page.
Statement Ending Balance StatementEndingBalance Specifies the balance on your actual bank account after the bank has processed the payments that you have imported with the bank statement file.
FactBoxes Control2 part Page 1286 “Payment Rec Match Details” —

Actions

Group Action ToolTip Runs
Process Import Bank Transactions Import a file for transaction payments that was made from your bank account and apply the payments to the entry. The file name must end in .csv, .txt, asc, or .xml.
Allow Duplicated Transactions Toggle whether transactions that have the same transaction ID can be imported into this journal.
Import Posted Transactions Toggle whether transactions that are already applied, but whose related bank account ledger entries are not closed, can be imported into this journal.
Apply Automatically Apply payments to their related open entries based on data matches between bank transaction text and entry information.
Post Test Report Preview the resulting payment reconciliations to see the consequences before you perform the actual posting.
Post Payments and Reconcile Bank Account Reconcile the bank account for payments that you post with the journal and close related ledger entries.
Post Payments Only Post payments but do not close related bank account ledger entries or reconcile the bank account.
Preview Posting Review the different types of entries that will be created when you post the document or journal.
New Documents New Finance Charge Memo Define a memo that includes information about the calculated interest on outstanding balances of an account. You can then send the memo in an email to the customer. Page 446 “Finance Charge Memo”
General Journal Open the general journal, for example, to record or post a payment that has no related document. Page 39 “General Journal”
Payment Journal View or edit the payment journal where you can register payments to vendors. Page 256 “Payment Journal”
Manual Application Transfer Difference to Account Specify the balancing account to which you want a non-applicable payment amount on a payment reconciliation journal line to be posted when you post the journal.
Map Text to Account Associate text on payments with debit, credit, and balancing accounts, so payments are posted to the accounts when you post payments. The payments are not applied to invoices or credit memos, and are suited for recurring cash receipts or expenses.
Apply Manually Review and apply payments that were applied automatically to wrong open entries or not applied at all.
Review Accept Applications Accept a payment application after reviewing it or manually applying it to entries. This closes the payment application and sets the Match Confidence to Accepted.
Remove Applications Remove a payment application from an entry. This unapplies the payment.
Custom Sorting Show Non-Applied Lines Display only payments in the list that have not been applied.
Show All Lines Show all payments in the list no matter what their status is.
Sort for Review Descending Sort the lines in ascending order.
Sort for Review Ascending Sort the lines in descending order.
Navigation Dimensions View or edit dimensions, such as area, project, or department, that you can assign to sales and purchase documents to distribute costs and analyze transaction history.
Line Dimensions View or edit the line dimensions sets that are set up for the current line.
Bank Account Card View or edit information about the bank account that is related to the payment reconciliation journal. Page 1283 “Payment Bank Account Card”
Details Bank Transaction Details View the values that exist in an imported bank statement file for the selected line. Page 1221 “Bank Statement Line Details”
Page Edit in Excel Send the data in the journal to an Excel file for analysis or editing.

Events published

  • OnAtActionApplyAutomatically(BankAccReconciliation: Record "Bank Acc. Reconciliation"; var SubscriberInvoked: Boolean) (integration): Integration event raised when the Apply Automatically action is triggered in the payment reconciliation journal. Enables customization of the automatic application process with custom matching logic or pre-processing steps.
  • OnUpdateSorting(BankAccReconciliation: Record "Bank Acc. Reconciliation"; var SubscriberInvoked: Boolean) Δ BC24 (integration): Integration event raised when line sorting is updated in the payment reconciliation journal. Enables custom sorting logic implementation or additional processing when sort order changes.
  • OnAfterImportBankTransactions(var SubscriberInvoked: Boolean; var BankAccReconciliationLine: Record "Bank Acc. Reconciliation Line") (integration): Integration event raised after importing bank transactions into the payment reconciliation journal. Enables custom post-processing of imported transaction data or additional validation steps.
  • OnAfterValidateShortcutDimCode(var BankAccReconciliationLine: Record "Bank Acc. Reconciliation Line"; var ShortcutDimCode: array[8] of Code[20]; DimIndex: Integer) (integration)
  • OnBeforeInvokePost(BankAccReconciliation: Record "Bank Acc. Reconciliation") (integration)
  • OnValidateAccountNoOnBeforeTransferRemainingAmountToAccount(var BankAccReconciliationLine: Record "Bank Acc. Reconciliation Line"; var IsHandled: Boolean) (integration)

Trigger event subscribers

Procedures

17 local procedures, no public ones.

Triggers

OnAfterGetCurrRecord, OnAfterGetRecord, OnNewRecord, OnOpenPage, OnInsertRecord, OnDeleteRecord

Relations

Calls

From the extracted call graph of BC29 (graphify-al on the snapshot checkout): calls whose target is known from a declared type or an Object::"Name" argument. Interface dispatch and calls through events are not counted, so the list is not complete.

Called by

Recent changes

Documented on Microsoft Learn

Source: AL metadata extracted from the code (names, ids, signatures, properties); no code bodies (D10).

Ask your agent

Procedure bodies are not stored here (D10). The call sections above are our own, per object, from the BC29 call graph. For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: bcatlas_resolve_node(object_type: "page", object_name: "Payment Reconciliation Journal"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.

Evidence 8 of 10 sources

Show 2 more