Codeunit 1415 Automatic Import of Bank Stmt.

Base Application, Microsoft.Bank.Statement

src/Layers/W1/BaseApp/Bank/Statement/AutomaticImportofBankStmt.Codeunit.al77 lines, Copyright (c) Microsoft Corporation. MIT

// ------------------------------------------------------------------------------------------------// Copyright (c) Microsoft Corporation. All rights reserved.// Licensed under the MIT License. See License.txt in the project root for license information.// ------------------------------------------------------------------------------------------------namespace Microsoft.Bank.Statement;using Microsoft.Bank.BankAccount;using Microsoft.Bank.Reconciliation;using System.IO;using System.Threading;/// <summary>/// Handles automated bank statement import processing through job queue entries./// Processes scheduled bank statement imports and creates new bank reconciliation records./// </summary>/// <remarks>/// Runs as a job queue processor for automated bank statement import scenarios./// Creates bank reconciliation records from imported bank statement data./// Integrates with automatic import setup for scheduled processing workflows./// </remarks>codeunit 1415 "Automatic Import of Bank Stmt."{    TableNo = "Job Queue Entry";    trigger OnRun()    var        BankAccount: Record "Bank Account";        DataExchDef: Record "Data Exch. Def";        DataExch: Record "Data Exch.";        BankAccReconciliation: Record "Bank Acc. Reconciliation";        DummyBankAccReconciliationLine: Record "Bank Acc. Reconciliation Line";        RecRef: RecordRef;        LastStatementNo: Code[20];    begin        Rec.TestField("Record ID to Process");        RecRef.Get(Rec."Record ID to Process");        RecRef.SetTable(BankAccount);        if not BankAccount."Automatic Stmt. Import Enabled" then            exit;        BankAccount.GetDataExchDef(DataExchDef);        DataExch."Related Record" := BankAccount.RecordId;        if not DataExch.ImportFileContent(DataExchDef) then            exit;        BankAccount.LockTable();        LastStatementNo := BankAccount."Last Statement No.";        BankAccReconciliation.CreateNewBankPaymentAppBatch(BankAccount."No.", BankAccReconciliation);        if not BankAccReconciliation.ImportStatement(BankAccReconciliation, DataExch) then begin            DeleteBankAccReconciliation(BankAccReconciliation, BankAccount, LastStatementNo);            exit;        end;        if not DummyBankAccReconciliationLine.LinesExist(BankAccReconciliation) then begin            DeleteBankAccReconciliation(BankAccReconciliation, BankAccount, LastStatementNo);            exit;        end;        Commit();        BankAccReconciliation.ProcessStatement(BankAccReconciliation);    end;    local procedure DeleteBankAccReconciliation(var BankAccReconciliation: Record "Bank Acc. Reconciliation"; var BankAccount: Record "Bank Account"; LastStatementNo: Code[20])    begin        if BankAccReconciliation.GetBySystemId(BankAccReconciliation.SystemId) then            BankAccReconciliation.Delete();        BankAccount.Find();        BankAccount."Last Statement No." := LastStatementNo;        BankAccount.Modify();        Commit();    end;}