If a Microsoft Office Excel template is created without specialized names for cells, you can create cells in the financial reports generator that use the standard Microsoft Office Excel cell names, such as A1, B2, etc. The financial reports generator will generate all of the data in the first worksheet in the Excel template. To generate data to other worksheets in the template, use the following cell-naming format: Worksheet name in Excel template! Cell number.

Example: form A1!s42

  1. Click General ledger> Setup> Financial reports generator> Financial reports generator> Setupto open the Field setupform.

  2. In the upper section of the form, press CTRL+N to create a new line.

  3. In the Requisitefield, select the cell requisite for section of the electronic report.

    Note Note

    This field is available when you select the document template in the Templatefield, in the Reportform.

  4. In the Cellfield, enter the cell name from the template created.

  5. In the Descriptionfield, enter a description of the cell.

  6. In the Line typefield, select the default data source for the report.

  7. In the Budget modelfield, select the default budget model number.

    Note Note

    This field is activated only when you select Budgetin the Datafield.

  8. In the Periodfield, select the default voucher calculation period.

  9. Select the Manual data inputcheck box to enter cell values manually when opening a report.

  10. In the By Defaultfield, enter the default amount value for the cell.

    Note Note

    This field is activated only when you select the Manual data inputcheck box.

  11. Click the Type of transactionstab to enter transaction filter parameters based on reversing.

    Note Note

    This tab is available only when you select Transactionsin the Line typefield.

  12. On the Reversing entrytab, in the Transaction usagefield, select the type of transaction to be taken into account when creating the report. The following options are:

    • All– View all transactions.

    • Only reversing entry– View reverse transactions.

    • Without reversing entry– Hide reverse transactions.

  13. Click the Type of operationtab to enter the transaction filter parameters by transaction type.

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

  15. In the Transaction typefield, select the required transaction type.

    Note Note

    The transaction type determines which module's transactions are used in generating the report.

  16. Click the Operations/Taxtab to specify the default filter parameters.

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

  18. In the Posting layerfield, select the accounting type.

  19. Click the Tax registerstab. In the Register codefield, select the tax calculation register code.

    Note Note

    This tab is available only when you select Registerin the Line typefield.

  20. In the Register field, select the register field name.

  21. Click the Dimensiontab to generate the report for a particular dimension code of ranges but not for all dimensions.

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

  23. In the Dimensionfield, select the correct dimension type.

  24. In the Fromand Tofields, select the starting and ending codes for the dimension range whose transactions should be included in the report.

  25. Click Copyto open the Financial Report Generator parameters copyingform.

  26. Under the Source reportfield group, in the Companyfield, select the company to be copied.

  27. In the Report codefield, select the report code.

  28. In the Cellfield, select the cell to be copied.

  29. Under the Target sourcefield group, in the Companyfield, view the company to which the settings are to be copied.

  30. In the Report codefield, view the report code into which the settings are copied.

  31. In the Cellfield, select the cell into which the settings are copied.

    Note Note

    If the target cell of the current report already has specified settings, those settings are overwritten.

  32. Click OKto copy a cell, all of its settings, and cell operations from any report for any company into the current report.

    Note Note

    The fields are populated similarly to the fields, with the same names that were used when setting up the report. Values that are entered for cells supersede those entered for the report.

    If you select a data type or period other than those on the Generaltab in the Reportform, you exclude the cell being set up from the global rules for the report and set up special rules for the cell. When global rules for report settings are changed, the rules for the cell do not change. For example, if the period for cell A1 was set to January, and in the global settings it was set to March, then all cells will receive data output for March, and A1 for January.

See Also