2.07. Entity Trees

In SocrateCloud, entity trees are used, to obtain reports for entity groups. Every entity has a tree associated by default.

The Tree window, located in the System Admin -> General Rules -> System Rules menu, allows the users to create entity trees. The following fields are available:

• Name, Description - relevant name and description for the entity tree;

• Active - is used to indicate whether the entity tree is active or not within the system. An inactive tree cannot be used for reporting;

• Do not use in reports - this option prevents the entity tree from being used when reporting, because of the long reporting times that would result when attempting to generate a detailed report using hierarchies. This option greatly improves report generation times, when processing large numbers of records (>1mil.);

  • Table - the database table this tree is built on (e.g. product, business parter, menu);

• Type / Area - the corresponding entity type. The Table - TYpe association must be correct in for the tree to be valid (e.g. Business Partner table -> "Business Partner" Area);

• All Nodes - option is used when the tree has parent child relationships between entities. If the tree is simple and linear, the option should not be selected;

• Verify Tree - starts the process used to verify if the tree is complete and correct.

The Tree Maintenance window, located in the System Admin -> General Rules -> System Rules menu, allows the users to manage tree-like classifications by creating, modifying or deleting parent-child relationships:

In the Tree field select the tree you would like to manage.

If the tree does not have All Nodes checked, the tree can be managed using the Add All and Delete All buttons. A simple, linear entity tree will be obtained.

If the tree has All Nodes checked, the tree can be managed using the columns described below:

• The left column displays the groups defined for the selected tree.

• The center displays the elements included in those groups.

• The right column shows all the elements from the tree table.

Tree elements can be moved within the tree structure only from one group to another. To do this select an item from the center or right column and drag & drop it to a group in the left column. As a result of this, the element will be moved to the group where it was dropped onto. Each column can be sorted or ordered manually using drag & drop. In case of large amounts of data, sorting and filter functions are available.

Note: For a tree element to be a group and have subordinate elements, at it's definition, select the Summary level checkbox.

Reporting Hierarchy

In SocrateCloud you can define multiple classifications for every element of the accounting schema. These allows multiple hierarchy structures to be used for reporting. The Reporting Hierarchy window, located in the Performance Analysis -> Financial Reporting -> Financial Report SetUp menu, is used to define reporting hierarchies. For every element of the hierarchy you can select a tree:

• Organization Tree

• Trx Organization Tree

• Account Tree

• Activity Tree

• BPartner Tree

• Product Tree

• Project Tree

• Campaign Tree

• Sales Region Tree

Note: If an Element is not used in the accounting schema defined for the financial report, it is ignored.