General ledger> Setup> Financial reports generator> Document templates
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.
Task that uses this form
Navigating the form
The following tables provide descriptions for the controls in this form.
Tabs
Tab |
Description |
---|---|
Overview |
Enter the document template details. |
General |
View or modify the document template details. |
Structure |
Enter the section details for the document template. |
Sections |
View or modify the section details for the document template. |
Buttons
Button |
Description |
||
---|---|---|---|
Setup |
Open the Requisites setupform to set up requisites for electronic reporting. |
||
Document |
Open the document template in Microsoft Office Excel. |
||
Report |
Open the Reportform to set up the Financial reports generator. |
||
Functions |
Open a menu with the following items:
|
||
Up |
Move the selected section upward in the tree structure.
|
||
Down |
Move the selected section downward in the tree structure.
|
||
Add |
Open the Add standard sectionsform to add standard sections.
|
||
Import |
Open the Requisites importform to import fixed requisites.
|
||
Copy |
Open the Copy from templateform to copy the document template settings.
|
Fields
Field |
Description |
||
---|---|---|---|
Template |
Enter the document template code. |
||
Name |
Enter a description for the document template. |
||
Report code |
Select the report code.
|
||
Format version |
Select the identification code of the format version for the document template. |
||
File name |
Specify the path of the report template file. |
||
Format |
Select the format code for the requisite. |
||
Locked |
This check box appears selected if the template is locked for editing.
|
||
User ID |
The login ID of the employee who is currently using the file. |
||
Section |
Enter the document section code. |
||
Name |
Enter the document section name. |
||
Delimiter "before" |
Select the delimiter code to be inserted as a prefix before this section.
|
||
Delimiter "after" |
Select the delimiter code to be inserted as a suffix after this section.
|
||
Section number |
Enter the section number.
|
||
Content |
Select this check box for the section that is a parent section for all main report data sections.
|
||
Optional section |
Select this check box to identify sections that should not be included in the output file.
|
||
Dynamic section |
This check box is activated automatically after a dynamic requisite is created in the Requisites Setupform in this section. |
||
On the next page |
Select this check box for sections that require two or more pages in the Microsoft Office Excel workbook.
|
||
Find next |
If several sections are included in the same Office Excel template sheet, this check box is activated automatically to ensure that other sections in the same spreadsheet are also searched.
|
||
Requisite |
The requisite for the dynamic section document template. |
||
Dynamic table |
This check box is activated automatically if a dynamic table is set up in the Requisites Setupform in this section.
|