The applied dimension filter in the Invt. Analysis by Dimension page (7159) is not applied to the Invt. Analys by Dim. Matrix page (9209) in the UK version of Microsoft Dynamics NAV

Installation information

Code changes

1. Change the code in the Controls in the Invt. Analysis by Dimensions form (9208) as follows:
   Existing code

   ...
     CLEAR(MatrixForm);
   MatrixForm.Load(MATRIX_CaptionSet,MATRIX_MatrixRecords,MATRIX_CurrentNoOfColumns,
   LineDimOption,ColumnDimOption,RoundingFactor,DateFilter,
   
   // Delete the following line.
   ValueType,ItemAnalysisView,CurrentItemAnalysisViewCode,PeriodType,ItemFilter,CalendarSource);
   // End of the deleted line.
   
   MatrixForm.RUNMODAL;
   END;
   }
   ...

   Replacement code

   ...
    CLEAR(MatrixForm);
   MatrixForm.Load(MATRIX_CaptionSet,MATRIX_MatrixRecords,MATRIX_CurrentNoOfColumns,
   LineDimOption,ColumnDimOption,RoundingFactor,DateFilter,
   
   // Add the following lines.
   ValueType,ItemAnalysisView,CurrentItemAnalysisViewCode,PeriodType,ItemFilter,CalendarSource,
   LocationFilter,BudgetFilter,Dim1Filter,Dim2Filter,Dim3Filter);
   // End of the added lines.
   
   MatrixForm.RUNMODAL;
   END;
   }
   ...

2. Change the code in the Load function in the Invt. Analys by Dim. Matrix form (9209) as follows:
   Existing code

   ...
     EXIT(Amt);
   END;
   
   // Delete the following lines.
   PROCEDURE Load@1125(VAR MatrixColumns1@1005 : ARRAY [32] OF Text[1024];VAR MatrixRecords1@1006 : ARRAY [32] OF Record 367;CurrentNoOfMatrixColumns@1007 : Integer;_LineDimOption@1000 : Integer;_ColumnDimOption@1001 : Integer;_RoundingFactor@1002 : Integer;_DateFilter@1003 : Text[30];_ValueType@1004 : Integer;_ItemAnalysisView@1008 : Record 7152;_CurrentItemAnalysisViewCode@1010 : Code[10];_PeriodType@1040000 : 'Day,Week,Month,Quarter,Year';_ItemFilter@1040001 : Code[10];_CalendarSource@1040002 : ' ,System,AccPeriod');
   // End of the deleted lines.
   
   VAR
   i@1009 : Integer;
   BEGIN
   ...

   Replacement code

   ...
    EXIT(Amt);
   END;
   
   // Add the following lines.
   PROCEDURE Load@1125(VAR MatrixColumns1@1005 : ARRAY [32] OF Text[1024];VAR MatrixRecords1@1006 : ARRAY [32] OF Record 367;CurrentNoOfMatrixColumns@1007 : Integer;_LineDimOption@1000 : Integer;_ColumnDimOption@1001 : Integer;_RoundingFactor@1002 : Integer;_DateFilter@1003 : Text[30];_ValueType@1004 : Integer;_ItemAnalysisView@1008 : Record 7152;_CurrentItemAnalysisViewCode@1010 : Code[10];_PeriodType@1040000 : 'Day,Week,Month,Quarter,Year';_ItemFilter@1040001 : Code[250];_CalendarSource@1040002 : ' ,System,AccPeriod';_LocationFilter@1040003 : Code[250];_BudgetFilter@1040004 : Code[250];_Dim1Filter@1040005 : Code[250];_Dim2Filter@1040006 : Code[250];_Dim3Filter@1040007 : Code[250]);
   // End of the added lines.
   VAR
   i@1009 : Integer;
   BEGIN
   ...

3. Change the code in the Load function in the Invt. Analys by Dim. Matrix form (9209) as follows:
   Existing code

   ...
     PeriodType := _PeriodType;
   ItemFilter := _ItemFilter;
   CalendarSource := _CalendarSource;
   END;
   
   LOCAL PROCEDURE MATRIX_OnDrillDown@1126(MATRIX_ColumnOrdinal@1008 : Integer);
   ...

   Replacement code

   ...
    PeriodType := _PeriodType;
   ItemFilter := _ItemFilter;
   CalendarSource := _CalendarSource;
   
   // Add the following lines.
   LocationFilter := _LocationFilter;
   BudgetFilter := _BudgetFilter;
   Dim1Filter := _Dim1Filter;
   Dim2Filter := _Dim2Filter;
   Dim3Filter := _Dim3Filter;
   // End of the added lines.
   END;
   
   LOCAL PROCEDURE MATRIX_OnDrillDown@1126(MATRIX_ColumnOrdinal@1008 : Integer);
   ...

Prerequisites

• The UK version of Microsoft Dynamics NAV 2009 Service Pack 1 (SP1)
• The UK version of Microsoft Dynamics NAV 2009 R2

Removal information