Restoring a Deleted Posted Bank Reconciliation in Business Central: A Comprehensive Guide
Are you having trouble restoring a deleted posted bank reconciliation in Microsoft Dynamics 365 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;
}
To conclude, 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!
We hope you found this blog useful, and if you would like to discuss anything, you can reach out to us at transform@cloudfonts.com.
