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

Hotfix information

A supported hotfix is now available from Microsoft. However, it is only intended to correct the problem that is described in this article. Apply it only to systems that are experiencing this specific problem. This hotfix may receive additional testing. Therefore, if you are not severely affected by this problem, we recommend that you wait for the next Microsoft Dynamics NAV 2009 service pack or the next Microsoft Dynamics NAV version that contains this hotfix.

Note In special cases, charges that are ordinarily incurred for support calls may be canceled if a Technical Support Professional for Microsoft Dynamics and related products determines that a specific update will resolve your problem. The usual support costs will apply to additional support questions and issues that do not qualify for the specific update in question.

Code changes

Note Always test code fixes in a controlled environment before you apply the fixes to your production computers.
To resolve this problem, follow these steps:

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
   ...