If one section of a report format contains several similar information blocks, you can create a dynamic Microsoft Office Excel sheet for this section. Generally, this is the first section of the template, which displays totals for the objects.

  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. In the Sectionfield, select the section code that the dynamic requisite refers to.

    Note Note

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


  4. In the left section of the form, press CTRL+N to set up a dynamic requisite for this section.

  5. Click the Tablestab.

  6. Press CTRL+N to set up a dynamic table that includes all requisites for the section. Select the appropriate area of the table to include all lines of the section.

    Note Note

    For more information, see (EEUR) Set up dynamic table requisites for text formatsand (EEUR) Set up dynamic table requisites for XML format.

    You can map child sections for each information block. For more information, see (EEUR) Set up a child dynamic section for electronic reporting.


  7. Press CTRL+S or close the form.

See Also