Dynamic table requisites are uniform requisites that can be consolidated into a table when 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 similarly to table requisite code, based on the rule in the Formatfield and on the line and column number in the table. Because the number of lines in a dynamic table is not known at the time of setup, you can assign the same line number to all requisites.

1. Click General ledger> Setup> Financial reports generator> Document templatesto open the Document templatesform.

2. Click Setup, and then click Opento open the Requisites setupform. The specified Microsoft Office Excel sheet opens in the lower section of the form.

3. Click the Tablestab.

4. In the Sectionfield, select the section code that the dynamic requisites refer to.

   Note
   You can select the section code on either the Overviewor Treetab.

5. In the left section of the form, press CTRL+N to create a new line, and then save it. A value derived from the document template settings is displayed in the Formatfield. You can modify this value for a specific table.

   Note
   Columns of the Line code, Description, and Valuetypes are created in the right section of the form. The Descriptioncolumn type is not needed to create dynamic requisites.

6. Select the Dynamic tablecheck box.

7. In the lower section of the form, select the data area of the table that you are setting up.

8. In the left section of the form, click Select, and then click Yes. The table cell area is updated in the Areafield.

9. In the right section of the form, select the Line codeline.

10. In the Column numberfield, enter the column number to create the requisite code that is listed above the table in the Microsoft Office Excel report template.

11. Select the line with the Valuecolumn type.

12. In the Column numberfield, enter the column number to create the requisite code, which is normally listed above the table in the Office Excel report template.

    Note
    Create as many Valuecolumn types as there are value columns in the table.

13. In the lower section of the form, select the first cell of the appropriate data column.

14. In the right section of the form, click Select, and then click Yes.

15. In the Data typefield, select the requisite data type to verify the values of table requisites, based on the type when exporting the data.

16. In the Extended data typefield, select the extended data type to verify the value of the imported requisite.

17. In the left and right sections of the form, click Go toand verify that the cell ranges were selected correctly.

18. Press CTRL +S or close the form.