The system does not close or open the annual profit or loss account when you run the "Close/Open Balance Statement" report in the Italian version of Microsoft Dynamics NAV

Installation information

Code changes

1. Change the code of the Keys in the G/L Entry table (17) as follows:
   Existing code

   ...
         {    ;IC Partner Code                         ;KeyGroups=Acc(IC) }
         {    ;G/L Account No.,Job No.,Posting Date    ;SumIndexFields=Amount }
         {    ;Official Date                           ;SumIndexFields=Debit Amount,Credit Amount }
   
   // Delete the following line.
           {    ;G/L Account No.,Posting Date,Bal. Account No.;
   
                                                        SumIndexFields=Amount,Debit Amount,Credit Amount,Additional-Currency Amount,Add.-Currency Debit Amount,Add.-Currency Credit Amount }
         {    ;G/L Account No.,Business Unit Code,Global Dimension 1 Code,Global Dimension 2 Code,Close Income Statement Dim. ID,Posting Date,Bal. Account No.;
                                                        SumIndexFields=Amount,Debit Amount,Credit Amount,Additional-Currency Amount,Add.-Currency Debit Amount,Add.-Currency Credit Amount }
   ...
   

   Replacement code

   ...
         {    ;IC Partner Code                         ;KeyGroups=Acc(IC) }
         {    ;G/L Account No.,Job No.,Posting Date    ;SumIndexFields=Amount }
         {    ;Official Date                           ;SumIndexFields=Debit Amount,Credit Amount }
   
   // Add the following line.
           {    ;G/L Account No.,Posting Date,Bal. Account No.,Transaction No.;
   
                                                        SumIndexFields=Amount,Debit Amount,Credit Amount,Additional-Currency Amount,Add.-Currency Debit Amount,Add.-Currency Credit Amount }
         {    ;G/L Account No.,Business Unit Code,Global Dimension 1 Code,Global Dimension 2 Code,Close Income Statement Dim. ID,Posting Date,Bal. Account No.;
                                                        SumIndexFields=Amount,Debit Amount,Credit Amount,Additional-Currency Amount,Add.-Currency Debit Amount,Add.-Currency Credit Amount }
   ...
   

2. Change the code of the Properties in the Close/Open Balance Sheet report (12113) as follows:
   Existing code

   ...
                       Window.OPEN(
                         Text008 +
                         Text009);
                     END;
     
         OnPostReport=VAR
   ...
   

   Replacement code

   ...
                       Window.OPEN(
                         Text008 +
                         Text009);
   
   // Add the following lines. 
                         "G/L Entry".SETCURRENTKEY("Transaction No.");
                         "G/L Entry".FINDLAST;
                         LastTransactionNo := "G/L Entry"."Transaction No.";
                         "G/L Entry".RESET;
   // End of the lines.
   
                     END;
     
         OnPostReport=VAR
   ...
   

3. Change the code of the Data Item Number 3 in the Close/Open Balance Sheet report (12113) as follows:
   Existing code

   ...
                             SETRANGE("Posting Date",FiscalYearStartDate,FiscYearClosingDate);
    
   // Delete the following lines. 
                               IF Integer.Number = 2 THEN
                                 SETFILTER("Bal. Account No.",'<>%1',ClAccNo);
   // End of the lines.
     
                             EntryNoAmountBuf.DELETEALL;
   ...
   

   Replacement code

   ...
                             SETRANGE("Posting Date",FiscalYearStartDate,FiscYearClosingDate);
    
   // Add the following lines. 
                               IF GLSetup."Additional Reporting Currency" <> '' THEN
                                 SETFILTER("Transaction No.", '<=%1',LastTransactionNo);
   // End of the lines.
     
                             EntryNoAmountBuf.DELETEALL;
   ...
   

4. Add the following global variable in the Close/Open Balance Sheet report (12113):

   LastTransactionNo@1130063 : Integer;

Prerequisites

• The Italian version of Microsoft Dynamics NAV 2009 R2
• The Italian version of Microsoft Dynamics NAV 2009 Service Pack 1
• The Italian version of Microsoft Dynamics NAV 5.0 Service Pack 1

Removal information