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. The code of dynamic requisites for the XML format is not generated, but is determined by the XSD schema.
-
Click General ledger> Setup> Financial reports generator> Document templatesto open the Document templatesform.
-
Click Setup, and then click Yesto open the Requisites setupform. The specified Microsoft Office Excel sheet opens in the lower section of the form.
-
Click the Tablestab.
-
In the Sectionfield, select the section code that the dynamic requisites refer to.
Note You can select the section code on the Overviewor Treetab.
-
In the left section of the form, press CTRL+N to create and save a new line. The Dynamic tablecheck box is activated automatically. Requisites for all table columns are added automatically to the table in the right section of the form.
-
In the lower section of the form, select the data area of the table that you are creating.
-
In the left section of the form, click Select, and then click Yesto change the area for table. The list and table cell area appear in the appropriate fields in the table line.
-
In the Data typefield, select the requisite data type.
-
In the Extended data typefield, select the extended data type for the columns that you created in order to verify the value of the imported requisite.
-
In the lower section of the form, select the first cell of the appropriate data column.
-
In the right section of the form, click Select, and then click Yesto change the area for the cell.
-
In the left and right sections of the form, click Go toto verify that cell ranges were selected correctly.
-
Press CTRL+S or close the form.