(RUS) Set up dynamic table requisites for text formats
Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2
Dynamic table requisites are uniform requisites that can be consolidated into a table if you do not know the number of table lines when you set up the template. In text formats, the code for dynamic table requisites is generated like the code for table requisites. The code is based on the rule in the Format field, and on the line and column number in the table. Because the number of lines in a dynamic table is not known when you set up the template, you can assign the same line number to all requisites.
Use the Requisites setup form to set up dynamic table requisites.
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.
备注
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.
On the Tables tab, in the Section field, select the section that the requisite is added to.
Click New to create a line, and then press CTRL+S to save the form. The Format field is updated with the format code that is set up in the Document templates form. You can update this format code if a different format code is required. In the right section of the form, three lines are created. One line has a column type of Line code, one has a column type of Description, and one has a column type of Value.
备注
The Description column type is not required when you set up dynamic table requisites.
Select the Dynamic table check box.
In the Excel worksheet in the lower pane of the form, select the data area of the table.
In the left section of the form, click Select, and then click Yes. The list and table cell area are displayed in the Area field.
In the right section of the form, select the line that has a column type of Line code, and then in the Column number field, enter the column number of the table in the Excel worksheet.
Select the line that has a column type of Value, and then in the Column number field, enter the column number of the table in the Excel worksheet. Create as many lines of the Value column type as there are value columns in the table.
In the Excel worksheet in the lower pane of the form, select the first cell of the appropriate data column. In the right section of the form, click Select, and then click Yes.
In the Data type field, select the data type of the column. For more information, see (RUS) Requisites setup (form).
In the Extended data type field, select the extended data type to verify the value of the requisite that is imported.
In the left and right sections of the form, click Go to, and verify that the cell ranges are selected correctly.