Run Account Structure Reports

You can use this function to print a number of different reports for accounts and account structures.

There are various types of account reports, with the reports showing:

  • Codes - displays a report on all selected accounts, with the report divided into parts 1 and 2. The accounts are sorted in accordance with the user-defined sorting order.
  • Codes (sort by Account) - displays a report on all selected accounts, with the report divided into parts 1 and 2. The accounts are sorted by code in alphanumeric order.
  • Codes (sort by Summation 1), Codes (sort by Summation 2) and Codes (sort by Summation 3) - displays a report on all selected accounts, with the report divided into parts 1 and 2. The accounts are sorted according to the text box Summations 1, 2 and 3. Accounts not included in any summation structure are shown first.
  • Codes (Sort by Reconc. between Account 1) and Codes (Sort by Reconc. between Account 2) - displays a report on all selected accounts, with the report divided into parts 1 and 2. The accounts are sorted according to the text box Reconciliation between Accounts 1 and 2. Accounts not included in any reconciliation are shown first.
  • Codes (sort by curr. conv. current method) - displays a report on all selected accounts, divided into parts 1 and 2. The accounts are sorted according to the account reference to conversion codes of the current method. Accounts without reference to conversion codes are printed first.
  • Codes (sort by curr. conv. MNM method) - displays a report on all selected accounts, divided into parts 1 and 2. The accounts are sorted according to the account reference to conversion codes of the monetary method. Accounts without reference to conversion codes are printed first.
  • Analyze - generates reports covering:
    • The summation accounts in which the detail accounts are included.
    • The sub-accounts included in a summation account.
    • The accounts where the selected accounts are used as reference accounts for the reconciliation between accounts 1 and 2.
    • The accounts where the selected accounts are used as reference accounts for the conversion codes according to the current method.
    • The accounts where the selected accounts are used as reference accounts for the conversion codes according to the monetary method.
    • The forms in which the accounts are included.
    • The lock groups in which the accounts are included.
    • The linked structures in which the accounts are included.
  • Advanced Analysis of Summations - displays a report at all summation levels for detail accounts.
  • Descriptions - displays a report on the account descriptions entered in each account.
  • Texts - displays a report on the account name and the short name in both the group language and the local language.
  • Detail Accounts added more than once to a summation Account.
  • Accounts Not Used in any Forms.
  • Locked Groups - displays a report on the locked groups set up in the account structure and the accounts of which are included in each locked group.

The account codes in the report are sorted into two different parts.

Volume 1 contains:

  • account code
  • account name
  • sign
  • account type
  • summations 1-3
  • reconciliation between accounts 1 and 2
  • conversion codes for the current method
  • conversion codes for the MNM method
  • generated movement accounts

Volume 2 contains:

  • account code
  • account name
  • sign
  • account type
  • decimals
  • dimension levels 1-4
  • intercompany codes
  • investment codes
  • consolidation
  • comments
  • summation account
  • sorting order
  • generated movement accounts

Procedure

  1. On the Maintain menu, click Account Structure/Reports. The Account Structure Reports window opens.
  2. Select the relevant Report Selections check box.
  3. If you want to select specific accounts to generate the report for, select the Account option button and enter one or several accounts you want to print the report for. If you want to select accounts within a specific form, select the Form option button and enter the form in the Form text box.
  4. Select the relevant Additional Reports check box.
  5. Click the Preview button to generate the report.

Results

The report will be displayed in the customized order defined on the Reorder tab in the Define Account Structure window.