Skip to main content

Account Grouping

Account Groupings serve two main purposes:

  • Calculating KPIs.
  • Building reports.

Account Groupings in Sage X3 are imported during template installation. You can also create custom groupings directly in Nectari.

Create an Account Grouping​

Account Groupings are specific to each Chart of Accounts.

First, define from which Chart of Accounts you want to perform an Account Grouping by doing the following:

  1. In Data Models and Views, expand Sage X3 > Configuration.
  2. Right-click Reporting Groups and select View Info Pages.
  3. Select the Charts of Accounts code, confirm, and click Generate based on your server type (SQL or Oracle).
  4. Click on Generate depending on your server (SQL or Oracle) to finish.
  5. The generated list of an Account Grouping will be inserted in the Account Setup view.
  6. Expand the Report Account Mapping data model to open the Account Setup view.
    Details

    Example Here, we used NA1 as the Chart of Accounts code to generate this Account Grouping from North America.

  7. Fill in the Accounts columns with account numbers as follows:
    1. Use commas and colons to separate accounts and intervals, respectively (e.g., 12100,12250:12300,12305).
    2. Use the asterisk (*) to replace multiple characters (e.g., 456* means all accounts beginning with 456).
    3. Use the question mark (?) to replace a single character (e.g., 456? means a 4-digit account beginning with 456).

Refresh Reporting Codes​

Reporting Codes defined in Sage X3 are automatically imported during installation, and changes made in Nectari will automatically be reflected in financial data models. However, if they are being maintained in Sage X3 itself, they must be manually refreshed in Nectari following any changes:

  1. In the Data Models and Views tab, expand the Sage X3 and Configuration folders.
  2. Right-click on the Reporting Codes data model and select View Info Pages.
  3. Under the Import Account Grouping from ERP section, click on the import associated with your (SQL or Oracle) server to finish.

Note: Using the Import feature won't remove previously added groupings.