Basic Report, All Periods

BW_RT102.xml

BW_BasicReportAllPeriods.xlsx

ReportSheet

Admin User > Basic Input and Report Templates > Reports

All options on the Advanced Options tab can be used. In the User Interface Management, add the 'showadvanced' setting with value 'yes' to the task (no component definitions are needed).

Internal Transaction Reconciliation Report

BW_RT103.xml

BW_ReconciliationReport.xlsx

ReportSheet

Admin User > Basic Input and Report Templates > Reports

The user interface task requires the parameter setting value=yes for the 'allentriesallocated' component. To enable reporting all entries when either the unit or the counter unit is the selected unit (or sub-unit), set value=yes for the 'allinternaltransactions' component.

Unit and counter unit generation in each sheet includes xml element "Groupby". Add definitions for these in the local report copy if you want to reconcile internal transactions on consolidated levels. Add the same definition to each sheet, to both unit and counter unit. In UI management, an applicable example for parameters is available to add.

By default, the data includes only series 20000 and 23000 (can be changed in Advanced Options).

Internal Inventories and Margins Used for Eliminations

BW_RT401.xml

BW_IntMargins_report.xlsx

ReportSheet

Admin User > Basic Input and Report Templates > Reports

Used with document series type 4. The default template includes Clausion FAS/IFRS Package inventory accounts. To add or remove accounts, create own copy of the template and make changes to the xml definition file account generation (the account codes listing).

General Ledger

BW_RT104.xml

BW_GeneralLedger.xlsx

ReportSheet

Admin User > Basic Input and Report Templates > Reports

To view the data by document number, position and input type, drill down to the data from the report.

Journal Ledger

BW_RT105.xml,

BW_JournalLedger.xlsx

ReportSheet

Admin User > Basic Input and Report Templates > Reports

Recommended for type 6 and 7 document series. To view the data by position and input type, drill down to the data from the report. On report sheet Filtered, end user account selections is used for filtering accounts. This sheet does not include calculated entries (usually include result shown in balance sheet).

Journal Ledger with Subtotals by Unit

BW_RT105B.xml

BW_JournalLedger.xlsx

ReportSheet

Admin User > Basic Input and Report Templates > Reports

Recommended for type 1, 2, 23, 3 and 4 document series. To view the data by position and input type, drill down to the data from the report. On report sheet Filtered, end user account selections is used for filtering accounts. This sheet does not include calculated entries (usually include result shown in balance sheet).