Codeunit 1262 Pre & Post Process XML Import

Base Application, System.IO

src/Layers/W1/BaseApp/System/DataExchange/PrePostProcessXMLImport.Codeunit.al240 lines, Copyright (c) Microsoft Corporation. MIT

namespace System.IO;using Microsoft.Bank.BankAccount;using Microsoft.Finance.GeneralLedger.Journal;using Microsoft.Finance.GeneralLedger.Setup;using System.Utilities;codeunit 1262 "Pre & Post Process XML Import"{    trigger OnRun()    begin    end;    var        DiffCurrQst: Label 'The bank statement that you are importing contains transactions in %1 %2. This conflicts with the %3 %4.\\Do you want to continue?', Comment = '%1 %2 = Currency Code EUR; %3 %4 = LCY Code DKK.';        MissingStmtDateInDataMsg: Label 'The statement date was not found in the data to be imported.';        MissingCrdDbtIndInDataMsg: Label 'The credit/debit indicator was not found in the data to be imported.';        MissingBalTypeInDataMsg: Label 'The balance type was not found in the data to be imported.';        MissingClosingBalInDataMsg: Label 'The closing balance was not found in the data to be imported.';#pragma warning disable AA0470        MissingBankAccNoQst: Label 'Bank account %1 does not have a bank account number.\\Do you want to continue?';#pragma warning restore AA0470        BankAccCurrErr: Label 'The bank statement that you are importing contains transactions in currencies other than the %1 %2 of bank account %3.', Comment = '%1 %2 = Currency Code EUR; %3 = Bank Account No.';        MultipleStmtErr: Label 'The file that you are trying to import contains more than one bank statement.';        MissingBankAccNoInDataErr: Label 'The bank account number was not found in the data to be imported.';        BankAccMismatchQst: Label 'Bank account %1 does not have the bank account number %2, as specified in the bank statement file.\\Do you want to continue?', Comment = '%1=Value; %2 = Bank account no.';    procedure PostProcessStatementDate(DataExch: Record "Data Exch."; var RecRef: RecordRef; FieldNo: Integer; StmtDatePathFilter: Text)    var        DataExchFieldDetails: Query "Data Exch. Field Details";    begin        SetValueFromDataExchField(DataExchFieldDetails, DataExch, StmtDatePathFilter, MissingStmtDateInDataMsg, RecRef, FieldNo);    end;    procedure PostProcessStatementEndingBalance(DataExch: Record "Data Exch."; var RecRef: RecordRef; FieldNo: Integer; BalTypeDescriptor: Text; BalTypePathFilter: Text; BalAmtPathFilter: Text; CrdDbtIndPathFilter: Text; ParentNodeOffset: Integer)    var        DataExchFieldDetails: Query "Data Exch. Field Details";        GroupNodeID: Text;    begin        DataExchFieldDetails.SetRange(FieldValue, BalTypeDescriptor);        if not HasDataExchFieldValue(DataExchFieldDetails, DataExch."Entry No.", BalTypePathFilter) then begin            Message(MissingBalTypeInDataMsg);            exit;        end;        GroupNodeID := GetSubTreeRoot(DataExchFieldDetails.Node_ID, ParentNodeOffset);        Clear(DataExchFieldDetails);        DataExchFieldDetails.SetFilter(Node_ID, '%1', GroupNodeID + '*');        if not SetValueFromDataExchField(DataExchFieldDetails, DataExch, BalAmtPathFilter, MissingClosingBalInDataMsg, RecRef, FieldNo) then            exit;        if CrdDbtIndPathFilter = '' then            exit;        SetValueFromDataExchField(DataExchFieldDetails, DataExch, CrdDbtIndPathFilter, MissingCrdDbtIndInDataMsg, RecRef, FieldNo);    end;    procedure PreProcessBankAccount(DataExch: Record "Data Exch."; BankAccNo: Code[20]; IBANPathFilter: Text; BankAccIDPathFilter: Text; CurrCodePathFilter: Text)    var        BankAccount: Record "Bank Account";        IsHandled: Boolean;    begin        IsHandled := false;        OnBeforePreProcessBankAccount(DataExch, BankAccNo, IBANPathFilter, BankAccIDPathFilter, CurrCodePathFilter, IsHandled);        if IsHandled then            exit;        BankAccount.Get(BankAccNo);        CheckBankAccNo(DataExch, BankAccount, IBANPathFilter, BankAccIDPathFilter);        CheckBankAccCurrency(DataExch, BankAccount, CurrCodePathFilter);    end;    procedure PreProcessGLAccount(DataExch: Record "Data Exch."; var GenJournalLineTemplate: Record "Gen. Journal Line"; CurrencyCodePathFilter: Text)    var        GLSetup: Record "General Ledger Setup";        DataExchFieldDetails: Query "Data Exch. Field Details";        StatementCurrencyCode: Code[10];        Confirmed: Boolean;        IsHandled: Boolean;    begin        GLSetup.Get();        DataExchFieldDetails.SetFilter(FieldValue, '<>%1&<>%2', '', GLSetup."LCY Code");        if HasDataExchFieldValue(DataExchFieldDetails, DataExch."Entry No.", CurrencyCodePathFilter) then begin            IsHandled := false;            OnPreProcessGLAccountOnBeforeConfirm(DataExch, DataExchFieldDetails, GenJournalLineTemplate, CurrencyCodePathFilter, IsHandled, Confirmed);            if not IsHandled then                Confirmed := Confirm(StrSubstNo(DiffCurrQst, GenJournalLineTemplate.FieldCaption("Currency Code"),                   DataExchFieldDetails.FieldValue, GLSetup.FieldCaption("LCY Code"), GLSetup."LCY Code"));            if not Confirmed then                Error('');        end;        DataExchFieldDetails.SetRange(FieldValue);        if HasDataExchFieldValue(DataExchFieldDetails, DataExch."Entry No.", CurrencyCodePathFilter) then begin            StatementCurrencyCode := Format(DataExchFieldDetails.FieldValue, -MaxStrLen(GenJournalLineTemplate."Currency Code"));            GenJournalLineTemplate.Validate("Currency Code", GLSetup.GetCurrencyCode(StatementCurrencyCode));        end;    end;    procedure PreProcessFile(DataExch: Record "Data Exch."; StatementIdPathFilter: Text)    var        IsHandled: Boolean;    begin        IsHandled := false;        OnBeforePreProcessFile(DataExch, StatementIdPathFilter, IsHandled);        if IsHandled then            exit;        CheckMultipleStatements(DataExch, StatementIdPathFilter);    end;    local procedure GetSubTreeRoot(Node: Text; Distance: Integer): Text    begin        exit(CopyStr(Node, 1, StrLen(Node) - Distance * 4));    end;    local procedure CheckBankAccNo(DataExch: Record "Data Exch."; BankAccount: Record "Bank Account"; IBANPathFilter: Text; BankAccIDPathFilter: Text)    var        DataExchFieldDetails: Query "Data Exch. Field Details";        FileHasIBAN: Boolean;        FileHasBankAccID: Boolean;        Handled: Boolean;        CheckedResult: Boolean;    begin        if BankAccount.GetBankAccountNo() = '' then begin            if not Confirm(StrSubstNo(MissingBankAccNoQst, BankAccount."No.")) then                Error('');            exit;        end;        FileHasIBAN := HasDataExchFieldValue(DataExchFieldDetails, DataExch."Entry No.", IBANPathFilter);        if not FileHasIBAN and (BankAccIDPathFilter <> '') then            FileHasBankAccID := HasDataExchFieldValue(DataExchFieldDetails, DataExch."Entry No.", BankAccIDPathFilter);        if not FileHasIBAN and not FileHasBankAccID then            Error(MissingBankAccNoInDataErr);        OnCheckBankAccNo(Handled, CheckedResult, DataExchFieldDetails, BankAccount);        if Handled and not CheckedResult then            exit;        if (DelChr(DataExchFieldDetails.FieldValue, '=', '- ') <> DelChr(BankAccount."Bank Account No.", '=', '- ')) and           (DelChr(DataExchFieldDetails.FieldValue, '=', '- ') <> DelChr(BankAccount.IBAN, '=', '- '))        then            if not Confirm(StrSubstNo(BankAccMismatchQst, BankAccount."No.", DataExchFieldDetails.FieldValue)) then                Error('');    end;    local procedure CheckBankAccCurrency(DataExch: Record "Data Exch."; BankAccount: Record "Bank Account"; CurrCodePathFilter: Text)    var        GeneralLedgerSetup: Record "General Ledger Setup";        DataExchFieldDetails: Query "Data Exch. Field Details";    begin        GeneralLedgerSetup.Get();        DataExchFieldDetails.SetFilter(FieldValue, '<>%1&<>%2', '', GeneralLedgerSetup.GetCurrencyCode(BankAccount."Currency Code"));        if HasDataExchFieldValue(DataExchFieldDetails, DataExch."Entry No.", CurrCodePathFilter) then            Error(BankAccCurrErr, BankAccount.FieldCaption("Currency Code"),              GeneralLedgerSetup.GetCurrencyCode(BankAccount."Currency Code"), BankAccount."No.");    end;    local procedure CheckMultipleStatements(DataExch: Record "Data Exch."; StatementIdPathFilter: Text)    var        DataExchFieldDetails: Query "Data Exch. Field Details";        StmtCount: Integer;    begin        if HasDataExchFieldValue(DataExchFieldDetails, DataExch."Entry No.", StatementIdPathFilter) then begin            StmtCount := 1;            while DataExchFieldDetails.Read() do                StmtCount += 1;        end;        if StmtCount > 1 then            Error(MultipleStmtErr);    end;    procedure HasDataExchFieldValue(var DataExchFieldDetails: Query "Data Exch. Field Details"; DataExchEntryNo: Integer; PathFilter: Text): Boolean    begin        DataExchFieldDetails.SetRange(Data_Exch_No, DataExchEntryNo);        DataExchFieldDetails.SetFilter(Path, PathFilter);        DataExchFieldDetails.Open();        exit(DataExchFieldDetails.Read());    end;    procedure SetValueFromDataExchField(var DataExchFieldDetails: Query "Data Exch. Field Details"; DataExch: Record "Data Exch."; PathFilter: Text; NotFoundMessage: Text; RecRef: RecordRef; FieldNo: Integer): Boolean    var        DataExchField: Record "Data Exch. Field";        TempFieldIdsToNegate: Record "Integer" temporary;        DummyDataExchFieldMapping: Record "Data Exch. Field Mapping";        ProcessDataExch: Codeunit "Process Data Exch.";    begin        if not HasDataExchFieldValue(DataExchFieldDetails, DataExch."Entry No.", PathFilter) then begin            Message(NotFoundMessage);            exit(false);        end;        DataExchField.Get(          DataExchFieldDetails.Data_Exch_No,          DataExchFieldDetails.Line_No,          DataExchFieldDetails.Column_No,          DataExchFieldDetails.Node_ID);        DummyDataExchFieldMapping."Data Exch. Def Code" := DataExch."Data Exch. Def Code";        DummyDataExchFieldMapping."Data Exch. Line Def Code" := DataExch."Data Exch. Line Def Code";        DummyDataExchFieldMapping."Column No." := DataExchFieldDetails.Column_No;        DummyDataExchFieldMapping."Field ID" := FieldNo;        DummyDataExchFieldMapping."Table ID" := RecRef.Number;        ProcessDataExch.SetField(RecRef, DummyDataExchFieldMapping, DataExchField, TempFieldIdsToNegate);        ProcessDataExch.NegateAmounts(RecRef, TempFieldIdsToNegate);        RecRef.Modify(true);        exit(true);    end;    [IntegrationEvent(false, false)]    local procedure OnBeforePreProcessBankAccount(DataExch: Record "Data Exch."; BankAccNo: Code[20]; IBANPathFilter: Text; BankAccIDPathFilter: Text; CurrCodePathFilter: Text; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforePreProcessFile(DataExch: Record "Data Exch."; StatementIdPathFilter: Text; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnCheckBankAccNo(var Handled: Boolean; var CheckedResult: Boolean; DataExchFieldDetails: Query "Data Exch. Field Details"; BankAccount: Record "Bank Account")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnPreProcessGLAccountOnBeforeConfirm(DataExch: Record "Data Exch."; DataExchFieldDetails: Query "Data Exch. Field Details"; GenJournalLine: Record "Gen. Journal Line"; CurrencyCodePathFilter: Text; var IsHandled: Boolean; var Confirmed: Boolean)    begin    end;}