[NL][Report][11000021][ImportRabobankmutasc][ProcessClosingBalance] Add integration event OnAfterCalculateClosingBalance

[KateDovgalova]

Why do you need this change?

Standard report calculates the "Closing Balance" as "Opening Balance" + TotalNetChange, but the Rabobank .asc format reports net changes with the opposite sign convention. In 4PS Construct we need to override the result to "Opening Balance" - TotalNetChange, correcting for this sign difference specific to Rabobank's file format.

Describe the request

Dear ALAppExtensions team,

On behalf of 4PS I would like to request integration event 'OnAfterCalculateClosingBalance' to be added to procedure ProcessClosingBalance of report 11000021 "Import Rabobank mut.asc":

    local procedure ProcessClosingBalance()
    var
        CBGStatementReconciliation: Codeunit "CBG Statement Reconciliation";
    begin
        CBGStatement."Closing Balance" := CBGStatement."Opening Balance" + TotalNetChange;
        OnAfterCalculateClosingBalance(CBGStatement, TotalNetChange); //new
        CBGStatement.Modify(true);

        if AutoReconciliation then begin
            CBGStatementReconciliation.SetHideMessages(true);
            CBGStatementReconciliation.MatchCBGStatement(CBGStatement);
        end;
    end;

    [IntegrationEvent(false, false)]
    local procedure OnAfterCalculateClosingBalance(var CBGStatement: Record "CBG Statement"; TotalNetChange: Decimal)
    begin
        //new
    end;
}

[github-actions]

✅ Analysis complete - ready for further processing

---

Implementation:

Add a new integration event in the ProcessClosingBalance() procedure of report 11000021 Import Rabobank mut.asc immediately after the closing balance is calculated and before CBGStatement.Modify(true);.

Location in ProcessClosingBalance() procedure:

local procedure ProcessClosingBalance()
var
    CBGStatementReconciliation: Codeunit "CBG Statement Reconciliation";
begin
    CBGStatement."Closing Balance" := CBGStatement."Opening Balance" + TotalNetChange;
    OnProcessClosingBalanceOnAfterCalculateClosingBalance(CBGStatement, TotalNetChange); // NEW
    CBGStatement.Modify(true);

    if AutoReconciliation then begin
        CBGStatementReconciliation.SetHideMessages(true);
        CBGStatementReconciliation.MatchCBGStatement(CBGStatement);
    end;
end;

Event Publisher (add at the end of the codeunit with other events):

[IntegrationEvent(false, false)]
local procedure OnProcessClosingBalanceOnAfterCalculateClosingBalance(var CBGStatement: Record "CBG Statement"; TotalNetChange: Decimal)
begin
end;

---

File: ImportRabobankmutasc.Report.al

Note

Automatically generated by the Triage Agent — advisory only. An engineer will review before any action is taken.

Tip

Not accurate? Reply with /not-accurate (optional: add a short explanation). Your feedback improves future responses.