You must configure a document template for each type of report that is submitted electronically to the tax authorities, such as the Assessed tax declaration. The structure of the electronic file defines the list of sections, as well as their content and the order in which they are loaded.

Templates are configured in two steps:

  • Set up the template structure in the Document templatesform.

  • Set up template requisites in the Requisites setupform.

Document templates can be set up for text formats as well as XML formats.

Set up a template for text formats

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

  2. Press CTRL+N to create a new line.

  3. In the Templatefield, enter the document template code.

  4. In the Namefield, enter a description for the document template.

    Note Note

    If you are setting up a report that will be generated by the Financial reports generator, in the Report Codefield, select the report code.

  5. In the Format versionfield, select the identification code for the format version.

  6. Click the Generaltab. In the File namefield, specify the path of the report template file.

  7. In the Formatfield, select the format code for the requisite.

  8. Click the Structuretab, and then press CTRL+N to create a new element.

  9. In the Sectionfield, enter the document section code.

  10. In the Namefield, enter the document section name.

  11. In the Delimiter "before"field, select the delimiter code to be inserted before this section.

    Note Note

    This field is available only if the format is earlier than Version 4.

  12. In the Delimiter "after"field, select the delimiter code to be inserted after this section.

    Note Note

    This field is available only if the format is earlier than Version 4.

  13. In the Section numberfield, enter the section number.

    Note Note

    This field is available only if the format is earlier than Version 4.

  14. Select the Contentcheck box for the section that is a parent section for all main report data sections.

    Note Note

    This field is available only if the format is earlier than Version 4.

    The Dynamic sectioncheck box is activated automatically after a dynamic requisite and dynamic table are created in the Requisites Setupform in this section.

  15. Select the On the next pagecheck box for sections that take two or more pages in the Microsoft Office Excel workbook.

    Note Note

    In some text format versions, you might have sections that take two or more sheets in the Office Excel template, such as section 206 of the text version of the Profit Tax form. In these cases, it is important that the sheets are in the correct order when you create the dynamic requisites. The first sheet should be followed by the next sheet of the same section. Otherwise, the values of the requisites will be selected incorrectly. If several sections are contained within the same Excel template sheet, this check box is activated automatically to ensure that other sections in the spreadsheet are also searched after one section is found.

  16. Click Upor Downto change the order of sections in the tree.

    Note Note

    You can also drag the tree elements to move them up or down.

  17. Click Addto open the Add standard sectionsform.

  18. Select the Selectcheck box for the standard section to be added in the required order, and then click OK.

  19. In the Document templatesform, click Importto add several requisites to a section at the same time.

  20. To create several identical sections, press CTRL+N on the Structuretab to create the new sections.

  21. Select the section in the tree, and then click Copyto open the Copy from templateform.

  22. In the Form templatefield, select the section to copy data from, and then click OK.

    Note Note

    If the section contains a dynamic table, you must create a separate auxiliary section for the dynamic table, the dynamic table totals, and any other requisites from this section. These sections will be child sections of the main section in the information part of the report.

  23. Press CTRL+S or close the form.

Set up a template for XML formats

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

  2. Press CTRL+N to create a new line.

  3. In the Templatefield, enter a short name for the document template.

  4. In the Namefield, enter a description for the document template.

    Note Note

    If you are setting up a report that will be generated by the Financial reports generator, in the Report Codefield, select the code created in the Reportform.

  5. In the Form versionfield, select the identification code for the format version.

    Note Note

    For more information, see (EEUR) Set up the periods of formats application directory.

  6. Click the Generaltab. In the File namefield, specify the path of the report template file.

  7. Click Functions> Update structureto open the Update template structureform.

  8. Select the Delete template contentcheck box to delete the content in the template.

  9. Click OKto create the report structure automatically.

    Note Note

    You can use this process for templates that have already been created for XML formats, although all previous settings will be deleted. You can view the created template structure on the Structuretab. Each section in the template structure corresponds to an element in the XSD schema for the document.

  10. Select the Optional sectioncheck box to designate sections that should not be included in the output file.

    Note Note

    If the Optional sectioncheck box is activated for a section, the section will appear in the output file only if there are values in the appropriate field boxes. The Optional sectioncheck box must be activated for requisites in optional sections.

  11. Press CTRL+S or close the form.

See Also