Use this page to configure how summarization is performed. Essentially, the summarization phase will not alter the balance imported previously but it will redistribute it amongst a new set of account lines that has potentially different detail than the original lines. This is achieved by grouping the imported account line data using user-defined criteria which can include original values, macro commands, hard-coded values, and even omission logic and then summarizing the amounts so that no loss of balance occurs.

The reduction in data can be achieved simply by aggregated the amounts for all source account lines that were 100% identical to one another or by omitting certain properties and attributes from the comparison for source account lines that are identical only by those properties and attributes that are deemed relevant.

•Preserve Groups with Zero-Value Amounts (and Quantities) - This prevents groups that after aggregation have an amount and quantity of 0 from being eliminated from the reshaped set of account lines.

When viewing the summarization data grid, you will see rows with the following columns:

•Name - this is the name of the account line property or attribute to transform. If the name represents a built-in account line property, the background color of the row changes to green to signify importance and the name field is locked to prevent editing. Rows that represent dynamic attributes are shown with a white background and can be edited. If the attribute name exists already in the account lines that were imported the original value can be accessed directly or transformed through a macro expression. If the attribute name does not exist in the account lines that were imported a new attribute with the name specified will be created and appended to the summarized data. It is possible to have an attribute that has the same name as a built-in account line property but it is not possible to define two attribute definitions that have the same name as each other. It is recommended that attribute names avoid the user of punctuation characters and spaces where possible.

•Action - this determines whether summarization logic is applied to a property or attribute and how it is applied. Some built-in properties (such as Account Code, Transaction Date, and Accounting Period) must be present for the product to function correctly and errors may occur if you attempt to disable these properties. Attributes that are detected in the account lines previously imported will appear in the grid and remain present on subsequent runs but they can be ignored simply by choosing to disable the item with the None action (the default) and will not be used to create groupings or appear as attributes on the summarized account lines. Any property or attribute that you deem not significant for summarization is removed from the imported data set and is no longer accessible by any means (including the built in macro expression language) once summarization is complete.

•None - properties and attributes marked with this action are removed from the resultant set of data and neither included in the list of values that define groups nor as measures of aggregate functions.

•Group By - properties and attributes marked with this action will be combined with all other similarly marked items and each unique set of values will be a grouped for which the remaining aggregate function actions are applied. Groups are case sensitive so consider using Upper and Lower macros in the Macro Expression code to uniformly convert data to one case prior to grouping if case varies.

•AVG - computes the average numeric value in the set for all values for a group. Blanks or null values are treated as 0. If text values that cannot be safely converted to numbers are detected a fatal exception will be thrown unless using the AVGA variant in which case all invalid conversions will be treated as 0 values.

•COUNT - computes the total number of lines in the group. Each row is counted regardless of the values on the row. The COUNTA variant counts the number of non-blank values in the set of all values for a group.

•FUSE - creates a semicolon separated string comprised of all the distinct values from the set of values for a group. Blanks or null values are ignored. Use the FUSEA variant to include duplicate values in the string.

•MAX - computes the largest numeric value in the set for all values for a group. Blanks or null values are ignored. If text values that cannot be safely converted to numbers are detected a fatal exception will be thrown unless using the MAXA variant in which case all invalid conversions will not cause an error but will also not be factored into the logic.

•MIN - computes the smallest numeric value in the set for all values for a group. Blanks or null values are ignored. If text values that cannot be safely converted to numbers are detected a fatal exception will be thrown unless using the MINA variant in which case all invalid conversions will not cause an error but will also not be factored into the logic.

•SUM - computes the mathematical sum in the set for all values for a group. Blanks or null values are ignored. If text values that cannot be safely converted to numbers are detected a fatal exception will be thrown unless using the SUMA variant which ignores such values.

•Macro Expression - in the event that the Action option is not configured as None this text field allows you to specify a macro expression that can be used in place of existing property or attribute values. Using macro expressions can allow you to fine tune the data that was imported and even be used to construct new attributes or entirely different values for existing attributes and properties. The macro expressions you write here can access the properties and attributes of the original account lines created during import but after summarization is complete any of those values that have not been preserved will no longer be available to subsequent processing phases. All macro expressions will be evaluated prior to evaluating aggregate functions.

Of the built-in account line properties (those that are highlighted in green) there are some specific rules about each that should be observed.

•AccountCode - this option cannot be disabled but it can be overridden with a macro expression. If a macro expression is used it must yield a non-empty value or an exception will be raised.

•AccountType - this option cannot be disabled but it can be overridden with a macro expression. If a macro expression is used it must yield a value in the AccountType enumeration or one of the alias values.

•Active - this is an optional value that can be suppressed or overridden with a macro expression. If left blank, a default value of true will be applied.

•Currency - this is an optional value that can be suppressed or overridden with a macro expression. If left blank, a default value of true will be applied.

•Description - this is an optional value that can be suppressed or overridden with a macro expression. If left blank, a default value of true will be applied.

•Site - this is an optional value that can be suppressed or overridden with a macro expression. If left blank, a default value of true will be applied.

Send comments on this topic.