Prospero supports using a full account mask in rows of the Line Definition. (Rows in the Line Definition can specify the account(s) shown on reports.) Using the Full Account Mask allows you to specify a more-specific data element from the general ledger for the given row. Each segment in this field can then be defined using a specific Tree summary or General Ledger code. You may want to use this feature if you have exceptions to groupings of accounts at a posting level which includes all segments.
Each reporting unit in the reporting tree must be either a child unit that has an account mask to draw data from the general ledger or a parent unit with detail information rolling up to it from a lower unit. Typically, detail units have a general ledger account mask. Summary units often summarize data from their child units, so they usually will not need a mask. However, any unit in the reporting tree can contain an account mask and draw data directly from the General Ledger. Account Mask: XXX - XXXX - XXXX - XXX (1st segment = Company Code, 2nd segment = Natural Account Code, 3rd segment = Department/Location, 4th segment = Sub-accounts).
In Prospero, the Full Account Mask checkbox in the Line Definition workspace’s Properties pane will display the full account mask of the row item.
When checked, the Full Account Mask of the Natural account row item will be displayed in the Line Definition workspace. You can enter the mask in to the field using wildcards options. Valid wildcard characters are limited to the question mark (?) or asterisk (*). A wildcard value can be entered directly to the field and its sections such as (1???) or (1*).
Corresponding to any account segment section in the mask beginning with “11”. The full number of places needs to be specified.
Corresponding to any account segment section in the mask ending with “11”. The full number of places needs to be specified.
Corresponding to any account segment section in the mask beginning with “1”. The full number of places does not need to be specified.
Corresponding to any account segment section in the mask ending with “1”. The full number of places does not need to be specified.
Note: Summary Lines do not display a full account mask as they do not have a direct corresponding account.
Tips and Tricks when entering the Full Account Mask:
1.) When entering the Full Account Mask in the field, the length of the data in the entire field must conform to the length as defined for the segment. If this is not the case, the field will be blanked out and truncated to the valid length. You can press the Esc key to clear and re-enter the value into the field.
2.) You can enter a new range or formula into the segment field, which will also update the Full Account Mask.
3.) If any other segment is (temporarily) enabled, the Full Account Mask will also be updated.
4.) Remember, the Label field will be updated only if the segment code being changed is the only code on the row at the time of the change.
For more information and help with designing your reports, contact MSX Group Support.