Restoring a Deleted Posted Bank Reconciliation in Business Central: A Comprehensive Guide


Introduction:

Are you struggling with restoring a deleted posted bank reconciliation in Business Central?

In this blog, I’m going to guide you through the process of effectively restoring a deleted posted bank reconciliation and ensuring the accuracy of your financial records. You’ll learn the step-by-step procedure to re-post a deleted bank reconciliation, along with best practices to prevent future errors and maintain the integrity of your financial data. Let’s get started!

Steps to Achieve Goal:

  • Create a New Editable Bank Ledger Entry Page:
  • Use AL code to create a new page, ensuring it allows for editing the Bank Ledger Entry.
  • The code should expose fields such as Statement No, Statement Line No, and Statement Status so they can be modified. Here’s an example of how to create a simple editable page in AL
page 50100 BankLedgerEntryEditable
{
    ApplicationArea = All;
    Caption = 'Bank Ledger Entry Editable';
    PageType = List;
    SourceTable = "Bank Account Ledger Entry";
    UsageCategory = Lists;
    Permissions = tabledata "Bank Account Ledger Entry" = RIMD;

    layout
    {
        area(Content)
        {
            repeater(General)
            {
                field("Document No."; Rec."Document No.")
                {
                    ToolTip = 'Specifies the document number on the bank account entry.';
                }
                field("Statement No."; Rec."Statement No.")
                {
                    ToolTip = 'Specifies the bank account statement that the ledger entry has been applied to, if the Statement Status is Bank Account Ledger Applied.';
                }
                field("Statement Line No."; Rec."Statement Line No.")
                {
                    ToolTip = 'Specifies the number of the statement line that has been applied to by this ledger entry line.';
                }
                field("Statement Status"; Rec."Statement Status")
                {
                    ToolTip = 'Specifies the statement status of the bank account ledger entry.';
                }
                field(Amount; Rec.Amount)
                {
                    ToolTip = 'Specifies the amount of the entry denominated in the applicable foreign currency.';
                }
                field("Amount (LCY)"; Rec."Amount (LCY)")
                {
                    ToolTip = 'Specifies the amount of the entry in LCY.';
                }
                field("Posting Date"; Rec."Posting Date")
                {
                    ToolTip = 'Specifies the posting date for the entry.';
                }
            }
        }
    }
}
  • Access the Bank Ledger Entry:
  • Open the Bank Ledger Entry Editable page created above.
  • Locate the deleted reconciliation entry that you want to undo. 
  • Remove "Statement No", "Statement Line No", and Change "Statement Status" from Closed to Open in bank Ledger Entry editable page using filters in Bank Account Ledger Entry editable page.
  • Now do the Bank Account Reconciliation again with same statement No and post bank Reconciliation.
  • To prevent users from accidentally deleting posted bank account reconciliations, we can implement a check in the OnDelete trigger. This will block any attempt to delete a posted reconciliation.

  • Here's an example of the logic to include in the OnDelete trigger in page extension of Bank Account Statement List and Bank Account Statement page:

pageextension 50101 PostedBankAccRecon extends "Bank Account Statement List"
{
    trigger OnDeleteRecord(): Boolean
    begin
        Error('You cannot delete a bank account reconciliation entry.');
    end;
}

Conclusion:
By following these steps, you can successfully undo a deleted posted bank reconciliation in Business Central. The process involves editing the Bank Ledger Entry, recreating the bank reconciliation with the same details, and ensuring the previously deleted reconciliation is removed through AL.

With this approach, you maintain accurate financial records and ensure that your bank account reconciliation process runs smoothly without any discrepancies.
If you need further assistance or have specific questions about your Business Central setup, feel free to reach out for personalized guidance. 
Happy Reconciliation!

Comments

Post a Comment

Popular posts from this blog

Seamless Integration: How to Sync Business Central with External Systems Instantly or in Batches

Introduction: In today's fast-paced business world, integrating your ERP system (like Business Central) with other external systems is crucial for streamlining processes and ensuring data consistency. However, if you're new to API integrations or struggling with how to send data from Business Central to another system, don't worry! In this post, I am going to walk you through the process of sending data from Business Central to an external system using APIs. By the end of this guide, you'll have a clear understanding of how to perform integrations smoothly, without the complexity. Steps to Achieve Goal: You can easily send data from Business Central to an external system by calling the link set in General Ledger Setup. Below is the logic for sending data via an API. You can encapsulate this logic inside a Codeunit, and call it as needed based on your synchronization requirements: Real-Time Data Sync: If you want the data to be synced in real-time (for example, as soon ...
Read more
Image
  Agent Payables Configuration in Business Central Introduction Accounts Payable (AP) is often one of the most repetitive and error-prone areas in finance. With the Payables Agent in Microsoft Dynamics 365 Business Central (2025 Wave 1), companies can now automate much of this process. Instead of clerks manually entering invoice details, the agent uses AI to capture, draft, and suggest invoice data—freeing finance teams to focus on strategic tasks. Steps to Achieve Agent Payables Configuration             On the top right corner of Business Central, click the AP (Accounts Payable) icon Activate the Agent Connect the mailbox where you wish to get all your invoice in pdf form. The agent will monitor this inbox, import PDFs, and archive them automatically The agent matches invoices with existing vendors. If no match is found, supervisors can approve the creation of a new vendor card. if the vendor exist you will get notificat...
Read more