Every report template contains a number of tables with requisites in the table cells,

  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 file opens in the lower section of the form.

  3. Click the Tablestab.

  4. In the Sectionfield, select the section to which you have to add a requisite.

    Note 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 the form.

    Note Note

    The Formatfield is updated with the format code that was set up in the Document templatesform. You can modify this format code for a specific table. In the right section of the form, three lines are created with Column typeas Line code, Description, and Value.


  6. Select the data area of the table you are setting up.

  7. In the left section of the form, click Select, and then click Yes. The list and table cell area are displayed in the Areafield.

  8. In the Description formatfield, enter the description format for the requisite code.

  9. In the right section of the form, select the Line codecolumn type line.

  10. In the lower section of the form, select the first cell of the column that contains the line code.

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

  12. In the Column numberfield, enter the number that will be used to create requisite codes.

  13. Select the Descriptioncolumn type line.

  14. Select the first cell of the column that contains the description, and then repeat steps 10 and 11.

  15. Select the Valuecolumn type line.

  16. Select the first cell of the column that contains the value, and then repeat steps 10 and 11.

  17. In the Data typefield, select the column data type to verify the values of table requisites when importing the data.

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

    Note Note

    Create as many Valuecolumn types as there are value columns in the table. You can click Upor Downto arrange the table columns in correct order.


  19. Click the Go tobuttons to verify that the cell ranges were selected correctly.

  20. In the left section of the form, click Requisitesto create requisites in the specified section.

  21. Click the Requisitestab and verify the requisites that you created.

    Note Note

    Delete any requisites that should not exist.


  22. Press CTRL+S or close the form.

See Also