Page 1290 "Payment Reconciliation Journal"
Base Application · Microsoft.Bank.Reconciliation
- 42controls
- 25actions
- 23procedures
- 6events
- 9Learn pages
- 2event subscribers
- 5objects it calls
- 3objects call it
Across versions
- BC23present
- BC241 events changed
- BC25-30unchanged
Neighbourhood 20 connected objects and pages
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)- subscribers: Codeunit 1351 “Telemetry Subscribers” LogTelemetryOnPaymentRecJournalOnBeforeInvokePost
OnValidateAccountNoOnBeforeTransferRemainingAmountToAccount(var BankAccReconciliationLine: Record "Bank Acc. Reconciliation Line"; var IsHandled: Boolean)(integration)
Trigger event subscribers
- OnAfterGetCurrRecordEvent: Codeunit 20117 “AMC Bank Assisted Mgt.” ShowAssistedSetupNotificationPaymntReconJour
Procedures
17 local procedures, no public ones.
Triggers
OnAfterGetCurrRecord, OnAfterGetRecord, OnNewRecord, OnOpenPage, OnInsertRecord, OnDeleteRecord
Relations
- source table Table 274 “Bank Acc. Reconciliation Line”
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.
- Codeunit 1255 “Match Bank Payments” (2 calls:
GetLinesForReview → GetLinesForReview,UpdateNumberSeriesNotification → GetNumberSeriesNotificationId) - Codeunit 371 “Bank Acc. Recon. Post (Yes/No)” (1 call:
InvokePost → BankAccReconPostYesNo) - Codeunit 408 “DimensionManagement” (1 call:
SetDimensionsVisibility → UseShortcutDims) - Codeunit 6723 “Server Setting” (1 call:
OnOpenPage → GetIsSaasExcelAddinEnabled) - Codeunit 8703 “Feature Telemetry” (1 call:
OnOpenPage → LogUptake)
Called by
- Codeunit 386 “Reverse Payment Rec. Journal” (1 call:
RunReversalWizard → (object)) - Codeunit 9022 “Pmt. Rec. Journals Launcher” (1 call:
OpenJournal → (object)) - Table 273 “Bank Acc. Reconciliation” (1 call:
OpenWorksheet → (object))
Recent changes
- 2026-09-09 #11056 29.x: Allow bank rec. duplicated transactions surfaced in UI (releases/29.x, BC29, feature)
- 2026-09-09 #11055 Allow bank rec. duplicated transactions surfaced in UI (main, BC30, feature)
Documented on Microsoft Learn
- Set Up Yodlee Bank Feeds
- Reconcile bank accounts and apply payments
- Setting up Text-to-Account mapping for recurring payments
- Apply payments to unpaid sales documents
- Reconcile payments using automatic application
- Using the transfer difference to account feature to reconcile payments
- Review and apply payments manually after automatic application
- Rules for automatic application of payments
- Working with general journals to post directly to G/L
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
- codesrc/Layers/W1/BaseApp/Bank/Reconciliation/PaymentReconciliationJournal.Page.alreleases/29.x @ ea08af5e
- learnSet Up Yodlee Bank Feeds
- learnReconcile bank accounts and apply payments
- learnSetting up Text-to-Account mapping for recurring payments
- learnApply payments to unpaid sales documents
- learnReconcile payments using automatic application
- learnUsing the transfer difference to account feature to reconcile payments
- learnReview and apply payments manually after automatic application