(RUS) Set up simple cell type requisites
Important
This content is archived and is not being updated. For the latest documentation, see Microsoft Dynamics 365 product documentation. For the latest release plans, see Dynamics 365 and Microsoft Power Platform release plans.
Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2
Use the Requisites setup form to set up Cell requisite types that are used in document templates.
Click General ledger > Setup > Financial reports generator > Document templates.
Select a template, and then click Setup. Click Open. The Microsoft Excel worksheet opens in the lower pane of the form.
Note
If the worksheet opens in a new window, you must update the system register to open the worksheet in the lower pane of the form. For more information, see (RUS) Update the system register for electronic reporting.
In the Section field, select a section for the requisite.
Click New to create a line.
In the Requisite type field, select Cell.
In the Requisite field, enter a requisite code. The Attribute field is updated with the XML attribute name. You can change the name if a different name is required.
In the Description field, enter a description for the requisite.
In the Data type field, select the data type of the requisite, from the following options:
General – The requisite can have any type of value.
Numeric – The requisite must be numeric. If a cell contains text, the imported value of the requisite is blank.
Text – The requisite can have any value.
Date – The requisite must be in date format. If a cell contains any other type of value, the value of the requisite is blank.
Conditional – The requisite depends on the value that is displayed in the cell when the requisite is imported. If the cell is not blank, the requisite value is updated with the value in the Value field in the right section of the Requisites setup form. Otherwise, the requisite value is updated with the value in the Default field.
In the Output type field, select an output type for the requisite, from the following options:
Optional – The requisite is excluded from the report file if the requisite value is blank.
Required – The requisite is required and is always included in the report file. The requisite value cannot be blank.
Predefined – A requisite code must be available. The requisite value can be blank.
In the Extended data type field, select the extended data type to verify the value of the requisite that is imported.
In the Excel worksheet in the lower pane of the form, select the source and target cells for the requisite value.
In the left section of the form, click Select, and then click Yes to change the area for the requisite. A new line is created in the right section of the form, and the Cell field is updated with the selected cell number.
Note
The order of requisites that are in the same section is the same as the order in the output text file. You can change the location of the requisites in the right section of the form.