The following tables show the input and output parameters for two matrix management functions in codeunit 9200, Matrix Management, in the standard application. Codeunit 9200 contains functions to manage the behavior of the new matrix forms after you have redesigned them so that they can be transformed. For more information about how to redesign matrix forms, see How to: Redesign Matrix Forms.
Function GenerateMatrixData
Var | Input | Output | Name | Date type | Description |
---|---|---|---|---|---|
|
X |
|
RedRef |
RecordRef |
The matrix record. You can filter as appropriate. |
|
X |
|
SetWanted |
Option |
Defines set of records that you want. The following options are available:
|
|
X |
|
MaximumSetLength |
Integer |
The maximum number of records allowed in the set. Normally 32. |
|
X |
|
CaptionFieldNo |
Integer |
The field number of the field in the RecRef that is used as the caption. |
X |
X |
X |
PKFirstRecInCurrSet |
Text |
The primary key of the first record in the current set. |
X |
|
X |
CaptionSet |
Text |
An array that contains the captions for the matrix. |
X |
|
X |
CaptionRange |
Text |
The range of the specified CaptionSet. |
X |
|
X |
CurrSetLength |
Integer |
The number of records in the current set. |
Function GeneratePeriodMatrixData
The GeneratePeriodMatrixData function works in the same way as the GenerateMatrixData function except that it also does the following:
-
Generates an array of the matrix records in the set.
-
Generates more user-friendly captions (such as quarter/year instead of quarter).
-
Performs the typical date record filtering, such as when the period is an accounting period.
Var | Input | Output | Name | Date type | Description |
---|---|---|---|---|---|
|
X |
|
SetWanted |
Option |
The set of records that you want. The following options are available:
|
|
X |
|
MaximumSetLength |
Integer |
The maximum number of records allowed in the set. Normally 32. |
|
X |
|
UseNameForCaption |
Boolean |
Specifies whether the Period Name field of the date record is used for captions. We recommend that you set this to No so that a user-friendly caption will be generated. |
|
X |
|
PeriodType |
Option |
The following options are available:
|
|
X |
|
DateFilter |
Text |
The date filter. |
X |
X |
X |
PKFirstRedInCurrSet |
Text |
The primary key of the first record in the current set. |
X |
|
X |
CaptionSet |
Text |
An array that contains the captions for the matrix. |
X |
|
X |
CaptionRange |
Text |
The range of the specified CaptionSet. |
X |
|
X |
CurrSetLength |
Integer |
The number of records in the current set. |
X |
|
X |
PeriodRecords |
Record Date |
An array of the period records in the set. |