Change the code in Global Variables in the CBG Statement Reconciliation codeuint (11000006) as follows:
Existing code 1...
PostDesRec@1000016 : Record 11000006;
PaymenthistorylineRec@1000017 : Record 11000002;
TransactionModeRec@1000018 : Record 11000004;
// Delete the following lines.
Tab@1000019 : Text[2];
BankaccountNo@1000020 : ARRAY [5] OF Code[40];
Name@1000021 : Code[40];
// End of the deleted lines.
Address@1000022 : Code[40];
City@1000023 : Code[40];
Identification@1000024 : Code[40];
...
Replacement code 1...
PostDesRec@1000016 : Record 11000006;
PaymenthistorylineRec@1000017 : Record 11000002;
TransactionModeRec@1000018 : Record 11000004;
// Add the following lines.
TempBankAccount@1000025 : Record 270;
Name@1000021 : Code[80];
// End of the added lines.
Address@1000022 : Code[40];
City@1000023 : Code[40];
Identification@1000024 : Code[40];
...
Existing code 2...
Address@1000022 : Code[40];
City@1000023 : Code[40];
Identification@1000024 : Code[40];
// Delete the following lines.
Invoicenumber@1000025 : Text[250];
Len@1000026 : Integer;
NumberOfPossibleBankAccounts@1000027 : Integer;
// End of the deleted lines.
NumberOfDocumentNumbers@1000028 : Integer;
NumberOfLinesProcessed@1000029 : Integer;
NumberOfLinesChanged@1000030 : Integer;
...
Replacement code 2...
Address@1000022 : Code[40];
City@1000023 : Code[40];
Identification@1000024 : Code[40];
NumberOfDocumentNumbers@1000028 : Integer;
NumberOfLinesProcessed@1000029 : Integer;
NumberOfLinesChanged@1000030 : Integer;
...
Existing code 3...
Window@1000040 : Dialog;
LocalFunctionalityMgt@1000041 : Codeunit 11400;
HideMessages@1000042 : Boolean;
PROCEDURE MatchCBGStatement@1000000(CBGStatementRec@1000000 : Record 11400);
VAR
...
Replacement code 3...
Window@1000040 : Dialog;
LocalFunctionalityMgt@1000041 : Codeunit 11400;
HideMessages@1000042 : Boolean;
// Add the following line.
BankAccountCharsToKeep@1000019 : Text[250];
PROCEDURE MatchCBGStatement@1000000(CBGStatementRec@1000000 : Record 11400);
VAR
...
Change the code in the MatchCBGStatementLine function in the CBG Statement Reconciliation codeuint (11000006) as follows:
Existing code 1...
PROCEDURE MatchCBGStatementLine@1000001(CBGStatementRec@1000000 : Record 11400;VAR CBGStatementlineRec@1000001 : Record 11401);
VAR
RecChanged@1000002 : Boolean;
// Delete the following line.
Found@1000003 : Boolean;
PaymentHistoryFound@1000004 : Boolean;
i@1000005 : Integer;
strFilter@1000006 : Text[250];
...
Replacement code 1...
PROCEDURE MatchCBGStatementLine@1000001(CBGStatementRec@1000000 : Record 11400;VAR CBGStatementlineRec@1000001 : Record 11401);
VAR
RecChanged@1000002 : Boolean;
PaymentHistoryFound@1000004 : Boolean;
i@1000005 : Integer;
strFilter@1000006 : Text[250];
...
Existing code 2...
NumberOfLinesProcessed := NumberOfLinesProcessed + 1;
RecChanged := FALSE;
- CLEAR(BankaccountNo);
CLEAR(Name);
CLEAR(Address);
CLEAR(City);
...
Replacement code 2...
NumberOfLinesProcessed := NumberOfLinesProcessed + 1;
RecChanged := FALSE;
// Add the following line.
CLEAR(TempBankAccount);
CLEAR(Name);
CLEAR(Address);
CLEAR(City);
...
Existing code 3...
CLEAR(Address);
CLEAR(City);
CLEAR(Identification);
// Delete the following line.
NumberOfPossibleBankAccounts := 0;
PostDesRec.SETRANGE("Journal Template Name", CBGStatementlineRec."Journal Template Name");
PostDesRec.SETRANGE("CBG Statement No.", CBGStatementlineRec."No.");
...
Replacement code 3...
CLEAR(Address);
CLEAR(City);
CLEAR(Identification);
PostDesRec.SETRANGE("Journal Template Name", CBGStatementlineRec."Journal Template Name");
PostDesRec.SETRANGE("CBG Statement No.", CBGStatementlineRec."No.");
...
Existing code 4...
PostDesRec.SETRANGE("CBG Statement No.", CBGStatementlineRec."No.");
PostDesRec.SETRANGE("CBG Statement Line No.", CBGStatementlineRec."Line No.");
// Delete the following line.
IF PostDesRec.FIND('-') THEN BEGIN
REPEAT
CASE PostDesRec."Information Type" OF
PostDesRec."Information Type"::"Description and Sundries":
...
Replacement code 4...
PostDesRec.SETRANGE("CBG Statement No.", CBGStatementlineRec."No.");
PostDesRec.SETRANGE("CBG Statement Line No.", CBGStatementlineRec."Line No.");
// Add the following line.
IF PostDesRec.FIND('-') THEN
REPEAT
CASE PostDesRec."Information Type" OF
PostDesRec."Information Type"::"Description and Sundries":
...
Existing code 5...
REPEAT
CASE PostDesRec."Information Type" OF
PostDesRec."Information Type"::"Description and Sundries":
// Delete the following lines.
IF NOT SplitAccountnumber(PostDesRec.Description) THEN
SplitInvoicenumber(PostDesRec.Description);
PostDesRec."Information Type"::"Account No. Balancing Account":
SplitAccountnumber(PostDesRec.Description);
// End of the dle
PostDesRec."Information Type"::"Name Acct. Holder":
Name := PostDesRec.Description;
PostDesRec."Information Type"::"Address Acct. Holder":
...
Replacement code 5...
REPEAT
CASE PostDesRec."Information Type" OF
PostDesRec."Information Type"::"Description and Sundries":
// Add the following lines.
SplitAccountNumber(PostDesRec.Description);
PostDesRec."Information Type"::"Account No. Balancing Account":
AddPossibleBankAccount(PostDesRec.Description);
// End of the added lines.
PostDesRec."Information Type"::"Name Acct. Holder":
Name := PostDesRec.Description;
PostDesRec."Information Type"::"Address Acct. Holder":
...
Existing code 6...
Identification := PostDesRec.Description;
END;
UNTIL PostDesRec.NEXT = 0;
// Delete the following lines.
END;
IF CBGStatementlineRec."Account No." = '' THEN BEGIN
FOR i := 1 TO 5 DO BEGIN
IF BankaccountNo[i] <> '' THEN BEGIN
IF CBGStatementlineRec.Credit > 0 THEN BEGIN
IF FindAccountnumber(BankaccountNo[i], TempRec."Source Type"::Customer,CBGStatementlineRec."Account No.") THEN BEGIN
// End of the deleted lines.
CBGStatementlineRec."Account Type" := CBGStatementlineRec."Account Type"::Customer;
CBGStatementlineRec.VALIDATE("Account No.", CBGStatementlineRec."Account No.");
CBGStatementlineRec."Reconciliation Status" := CBGStatementlineRec."Reconciliation Status"::Changed;
...
Replacement code 6...
Identification := PostDesRec.Description;
END;
UNTIL PostDesRec.NEXT = 0;
// Add the following lines.
IF CBGStatementlineRec."Account No." = '' THEN BEGIN
IF TempBankAccount.FINDFIRST THEN
REPEAT
IF TempBankAccount.IBAN <> '' THEN BEGIN
IF CBGStatementlineRec.Credit > 0 THEN BEGIN
IF FindAccountnumber(TempBankAccount.IBAN,TempRec."Source Type"::Customer,CBGStatementlineRec."Account No.") THEN BEGIN
// End of the added lines.
CBGStatementlineRec."Account Type" := CBGStatementlineRec."Account Type"::Customer;
CBGStatementlineRec.VALIDATE("Account No.", CBGStatementlineRec."Account No.");
CBGStatementlineRec."Reconciliation Status" := CBGStatementlineRec."Reconciliation Status"::Changed;
...
Existing code 7...
RecChanged := TRUE;
END;
END ELSE BEGIN
// Delete the following line.
IF FindAccountnumber(BankaccountNo[i], TempRec."Source Type"::Vendor,CBGStatementlineRec."Account No.") THEN BEGIN
CBGStatementlineRec."Account Type" := CBGStatementlineRec."Account Type"::Vendor;
CBGStatementlineRec.VALIDATE("Account No.", CBGStatementlineRec."Account No.");
CBGStatementlineRec."Reconciliation Status" := CBGStatementlineRec."Reconciliation Status"::Changed;
...
Replacement code 7...
RecChanged := TRUE;
END;
END ELSE BEGIN
// Add the following line.
IF FindAccountnumber(TempBankAccount.IBAN,TempRec."Source Type"::Vendor,CBGStatementlineRec."Account No.") THEN BEGIN
CBGStatementlineRec."Account Type" := CBGStatementlineRec."Account Type"::Vendor;
CBGStatementlineRec.VALIDATE("Account No.", CBGStatementlineRec."Account No.");
CBGStatementlineRec."Reconciliation Status" := CBGStatementlineRec."Reconciliation Status"::Changed;
...
Existing code 8...
END;
END;
END;
// Delete the following line.
END;
IF NOT RecChanged THEN BEGIN
IF Name <> '' THEN BEGIN
IF CBGStatementlineRec.Credit > 0 THEN BEGIN
...
Replacement code 8...
END;
END;
END;
// Add the following line.
UNTIL TempBankAccount.NEXT = 0;
IF NOT RecChanged THEN BEGIN
IF Name <> '' THEN BEGIN
IF CBGStatementlineRec.Credit > 0 THEN BEGIN
...
Existing code 9...
END;
END;
// Delete the following lines.
IF RecChanged THEN BEGIN
CBGStatementlineRec.MODIFY(TRUE);
// End of the deleted lines.
END;
END;
...
Replacement code 9...
END;
END;
// Add the following lines.
IF RecChanged THEN
CBGStatementlineRec.MODIFY(TRUE);
END;
PROCEDURE SplitAccountNumber@1000002(strBuf@1000001 : Text[250]);
VAR
AccNo@1000003 : Text[30];
BEGIN
IF LocalFunctionalityMgt.CheckBankAccNo(COPYSTR(strBuf,1,30),'',AccNo) THEN
AddPossibleBankAccount(AccNo);
END;
PROCEDURE FindAccountnumber@1000004("Account Name"@1000001 : Code[80];"Source Type"@1000002 : Integer;VAR Sourcenumber@1000003 : Code[20]) found@1000000 : Boolean;
BEGIN
TempRec.SETRANGE("Data Type",TempRec."Data Type"::Bankaccount);
TempRec.SETRANGE("Source Type","Source Type");
TempRec.SETRANGE(Word,"Account Name");
IF TempRec.FIND('-') THEN BEGIN
Sourcenumber := TempRec."Source No.";
EXIT(TRUE);
// End of the added lines.
END;
END;
...
Change the code in the FindNAC function in the CBG Statement Reconciliation codeuint (11000006) as follows:
Existing code 1...
AddressResultTemp.SETCURRENTKEY("Source Type", "Source No.");
CityResultTemp.SETCURRENTKEY("Source Type", "Source No.");
// Delete the following lines.
TempRec.SETRANGE(TempRec."Source Type", "Source Type");
TempRec.SETRANGE(TempRec."Data Type", TempRec."Data Type"::Name);
TempRec.SETRANGE(TempRec.Word, COPYSTR(Name,1,20));
// End of the deleted lines.
IF TempRec.FIND('-') THEN
REPEAT
NameResultTemp := TempRec;
...
Replacement code 1...
AddressResultTemp.SETCURRENTKEY("Source Type", "Source No.");
CityResultTemp.SETCURRENTKEY("Source Type", "Source No.");
// Add the following lines.
TempRec.SETRANGE("Source Type","Source Type");
TempRec.SETRANGE("Data Type",TempRec."Data Type"::Name);
TempRec.SETRANGE(Word,COPYSTR(Name,1,20));
// End of the added lines.
IF TempRec.FIND('-') THEN
REPEAT
NameResultTemp := TempRec;
...
Existing code 2...
NameResultTemp.INSERT;
UNTIL TempRec.NEXT = 0;
// Delete the following lines.
TempRec.RESET();
TempRec.SETRANGE(TempRec."Source Type", "Source Type");
TempRec.SETRANGE(TempRec."Data Type", TempRec."Data Type"::Street);
TempRec.SETRANGE(TempRec.Word, COPYSTR(Address,1,20));
// End of the deleted lines.
IF TempRec.FIND('-') THEN
REPEAT
NameResultTemp.SETRANGE("Source Type",TempRec."Source Type");
...
Replacement code 2...NameResultTemp.INSERT;
UNTIL TempRec.NEXT = 0;
// Add the following lines.
TempRec.RESET;
TempRec.SETRANGE("Source Type","Source Type");
TempRec.SETRANGE("Data Type",TempRec."Data Type"::Street);
TempRec.SETRANGE(Word,COPYSTR(Address,1,20));
// End of the added lines.
IF TempRec.FIND('-') THEN
REPEAT
NameResultTemp.SETRANGE("Source Type",TempRec."Source Type");
...
Existing code 3...
END;
UNTIL TempRec.NEXT = 0;
// Delete the following lines.
TempRec.RESET();
TempRec.SETRANGE(TempRec."Source Type", "Source Type");
TempRec.SETRANGE(TempRec."Data Type", TempRec."Data Type"::City);
TempRec.SETRANGE(TempRec.Word, COPYSTR(City,1,20));
// End of the deleted lines.
IF TempRec.FIND('-') THEN
REPEAT
AddressResultTemp.SETRANGE("Source Type",TempRec."Source Type");
...
Replacement code 3...
END;
UNTIL TempRec.NEXT = 0;
// Add the following lines.
TempRec.RESET;
TempRec.SETRANGE("Source Type","Source Type");
TempRec.SETRANGE("Data Type",TempRec."Data Type"::City);
TempRec.SETRANGE(Word,COPYSTR(City,1,20));
// End of the added lines.
IF TempRec.FIND('-') THEN
REPEAT
AddressResultTemp.SETRANGE("Source Type",TempRec."Source Type");
...
Change the code in the GetTransactionModeFilter function in the CBG Statement Reconciliation codeuint (11000006) as follows:
Existing code 1...
LOCAL PROCEDURE GetTransactionModeFilter@1000012(VAR CBGStatementLineRec@1000000 : Record 11401;VAR strFilter@1000001 : Text[250];Account_Type@1000002 : Integer);
VAR
CBGStatementRec@1000003 : Record 11400;
// Delete the following line.
BankAccountRec@1000004 : Record 270;
BEGIN
strFilter := '';
IF CBGStatementRec.GET(CBGStatementLineRec."Journal Template Name",CBGStatementLineRec."No.") THEN BEGIN
...
Replacement code 1...
LOCAL PROCEDURE GetTransactionModeFilter@1000012(VAR CBGStatementLineRec@1000000 : Record 11401;VAR strFilter@1000001 : Text[250];Account_Type@1000002 : Integer);
VAR
CBGStatementRec@1000003 : Record 11400;
BEGIN
strFilter := '';
IF CBGStatementRec.GET(CBGStatementLineRec."Journal Template Name",CBGStatementLineRec."No.") THEN BEGIN
...
Existing code 2...
strFilter := '';
IF CBGStatementRec.GET(CBGStatementLineRec."Journal Template Name",CBGStatementLineRec."No.") THEN BEGIN
TransactionModeRec.SETRANGE("Account Type", Account_Type);
// Delete the following line.
TransactionModeRec.SETRANGE(TransactionModeRec."Our Bank", CBGStatementRec."Account No.");
IF TransactionModeRec.FIND('-') THEN BEGIN
strFilter := '''''';
REPEAT
...
Replacement code 2...
strFilter := '';
IF CBGStatementRec.GET(CBGStatementLineRec."Journal Template Name",CBGStatementLineRec."No.") THEN BEGIN
TransactionModeRec.SETRANGE("Account Type", Account_Type);
// Add the following line.
TransactionModeRec.SETRANGE("Our Bank",CBGStatementRec."Account No.");
IF TransactionModeRec.FIND('-') THEN BEGIN
strFilter := '''''';
REPEAT
...