Reports

Add or remove brackets from figures 

You can change the presentation of figures in your accounts reports so that brackets are added or removed to show a credit or debit.
  1. Right-click on the table that contains the brackets you want to remove, then select
    Highlight in report structure
     from the context menu.
  2. In the
    Report Structure
    , right-click on the template you've highlighted and select
    View
     from the context menu.
  3. Select
    Design
     to view the template in Design Mode.
  4. Double-click on the data you want to change.
  5. Double-click on the figures you want to change.
    The Edit Section dialog has groups of controls for
    Show section breakdown
     and
    Show section total
    . If your template has a breakdown and a total, you'll need to choose options from both these sections.
  6. Select either
    Debit
     or
    Credit
     in the
    Show section breakdown
     and
    Show section total
     options as needed to add or remove brackets from the figures.
    Example
    Screenshot of the Edit Section dialog, with the Options tab active. A marked checkbox indicates that the 'Show section breakdown' controls are activated and within this group the Debit and Credit options for Positive values are highlighted. Another marked checkbox indicates that the 'Show section total' controls are also activated. The Debit and Credit options for the Positive total are highlighted.
  7. Select
    OK
    , then
    OK
     again.
  8. Select
    Preview
     to return to Preview mode.
  9. Select
    Full report
     to run the report.
  10. If the values you've changed are tagged for iXBRL purposes, then you'll also need to take the following steps to reverse the tags on the values to reflect your changes.
  11. Right-click on the table that contains the brackets you want to remove, then select
    Highlight in report structure
     from the context menu.
  12. In the
    Report Structure
    , right-click on the template you've highlighted, then select
    View
     from the context menu.
  13. Select
    Edit XBRL
     to view the template in Edit XBRL mode.
  14. Double-click the part of the report you've changed.
  15. Move the cursor to the left until you can reveal and select the
    Tag section
     button.
  16. Select one of the rows in the iXBRL section, then
    Edit
    .
    note
    The rows that make up the iXBRL section have a blue background.
  17. Mark the
    Reverse sign
     checkbox, then select
    OK
    .
    Example
    Screenshot of the Edit XBRL Tag dialog. After the Taxonomy and Display fields, there is a Find field, then an expandable list of tags. The Trade debtors/trade receivables tag is selected. Other fields such as Type and Name describe this tag. Among these fields, the Reverse sign checkbox is highlighted.
  18. Repeat steps 15 and 16 until you've reversed the tag for all the rows in the iXBRL section.
  19. Select
    OK
     in all windows to close them and save your changes.
    When you run the report in
    Preview
     mode the report will be shown withe the correct iXBRL tags.

This article applies to:

  • Product: Digita Accounts Production Advanced
  • Subject: Documents,Reports