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:

  • Initial

  • Previous

  • Same

  • Next

 

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:

  • Initial

  • Previous

  • Same

  • Next

 

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:

  • Day

  • Week

  • Month

  • Quarter

  • Year

  • Accounting Period

 

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.