You can unexpectedly run the Calculate Exchange Differences report (12302) after you run the Adjust Exchange Rate batch job for a bank account in the Polish version of Microsoft Dynamics NAV 2009 R2

Installation information

Code changes

1. Change the code in the Fields section in the Bank Account table (270) as follows:
   Existing code

   ...
   { 111 ; ;SWIFT Code ;Code20 ;CaptionML=ENU=SWIFT Code }
   
   // Delete the following lines.
   { 12301; ;Cash/Bank Report Mandatory;Boolean ;OnValidate=VAR
   CashBankReport@1170000 : Record 12300;
   BEGIN
   IF NOT "Cash/Bank Report Mandatory" THEN BEGIN
   BankAccLedgEntry.SETCURRENTKEY("Bank Account No.","Cash/Bank Report Cons. No.","Cash/Bank Report Position");
   BankAccLedgEntry.SETRANGE("Bank Account No.","No.");
   BankAccLedgEntry.SETFILTER("Cash/Bank Report Cons. No.",'<>0');
   IF BankAccLedgEntry.FIND('-') THEN
   ERROR(Text12300,"Cash/Bank Report Mandatory",FIELDNAME("Cash/Bank Report Mandatory"),
   BankAccLedgEntry.TABLENAME,CashBankReport.TABLENAME);
   END;
   // End of the lines.
   
   END;
   ...

   Replacement code

   ...
   { 111 ; ;SWIFT Code ;Code20 ;CaptionML=ENU=SWIFT Code }
   
   // Add the following lines.
   { 12301; ;Cash/Bank Report Mandatory;Boolean ;OnValidate=BEGIN
   CheckCashBankRepMandatory;
   // End of the lines.
   
   END;
   ...

2. Change the code in the CheckCashBankRepMandatory function in the Bank Account table (270) as follows:
   Existing code

   ...
   BEGIN
   ...

   Replacement code

   ...
   // Add the following lines.
   LOCAL PROCEDURE CheckCashBankRepMandatory@1170000();
   VAR
   CashBankReport@1170000 : Record 12300;
   ExchRateAdjmtReg@1170001 : Record 86;
   BEGIN
   IF "Cash/Bank Report Mandatory" THEN BEGIN
   IF HasExchRateAdjmtReg THEN
   RaiseCashBankRepErr(ExchRateAdjmtReg.TABLECAPTION)
   END ELSE
   IF HasCashBankLedgEntries THEN
   RaiseCashBankRepErr(CashBankReport.TABLECAPTION);
   END;
   LOCAL PROCEDURE HasExchRateAdjmtReg@1170006() : Boolean;
   VAR
   ExchRateAdjmtReg@1170000 : Record 86;
   BEGIN
   ExchRateAdjmtReg.SETRANGE("Account Type",ExchRateAdjmtReg."Account Type"::"Bank Account");
   ExchRateAdjmtReg.SETRANGE("Account No.","No.");
   EXIT(NOT ExchRateAdjmtReg.ISEMPTY);
   END;
   LOCAL PROCEDURE HasCashBankLedgEntries@1170007() : Boolean;
   VAR
   BankAccLedgEntry@1170000 : Record 271;
   BEGIN
   IF NOT BankAccLedgEntry.RECORDLEVELLOCKING THEN
   BankAccLedgEntry.SETCURRENTKEY("Bank Account No.","Cash/Bank Report Cons. No.","Cash/Bank Report Position");
   BankAccLedgEntry.SETRANGE("Bank Account No.","No.");
   BankAccLedgEntry.SETFILTER("Cash/Bank Report Cons. No.",'<>0');
   EXIT(NOT BankAccLedgEntry.ISEMPTY);
   END;
   LOCAL PROCEDURE RaiseCashBankRepErr@1170001(RelatedTableCaption@1170000 : Text[80]);
   BEGIN
   ERROR(
   Text12300,"Cash/Bank Report Mandatory",FIELDCAPTION("Cash/Bank Report Mandatory"),
   BankAccLedgEntry.TABLECAPTION,RelatedTableCaption)
   END;
   // End of the lines.
   
   BEGIN
   ...

3. Change the code in the Data Item Number 3 section in the Adjust Exchange Rates report (595) as follows:
   Existing code

   ...
   DataItemTable=Table270;
   
   // Delete the following line.
   DataItemTableView=SORTING(Bank Acc. Posting Group);
   
   OnPreDataItem=BEGIN
   ...

   Replacement code

   ...
   DataItemTable=Table270;
   
   // Add the following lines.
   DataItemTableView=SORTING(Bank Acc. Posting Group)
   WHERE(Cash/Bank Report Mandatory=FILTER(No));
   // End of the lines.
   
   OnPreDataItem=BEGIN
   ...

4. Change the code in the Data Item Number 1 section in the Calculate Exchange Differences report (12302) as follows:
   Existing code

   ...
   DataItemTable=Table270;
   OnPreDataItem=BEGIN
   ...

   Replacement code

   ...
   DataItemTable=Table270;
   
   // Add the following lines.
   DataItemTableView=SORTING(No.)
   WHERE(Cash/Bank Report Mandatory=FILTER(Yes));
   // End of the lines.
   
   OnPreDataItem=BEGIN
   ...

Prerequisites

Removal information