GRPENT Function

The GRPENT function retrieves the balance in Working Papers for the specified grouping separating balances by entity. You can specify whether to include positive or negative balances.

Syntax

GRPENT("Group","Value","Group Number",<"Sign">)

Where

Group represents the custom grouping 1, which can be 1 for Grouping 1 (L/S), 2 for Grouping 2, etc., M for the Mapping numbers, T for the Tax codes, G for GIFI and A for Accounts.

Value represents the type of balance to link to the cell.

Group Number represents the leadsheet, group number from the custom grouping, map number or the tax code.

Sign represents the ability to state the sign of the group or to filter particular accounts in the group based on their balance (debit or credit).

"-1"

Credit only - only include accounts with credit balances. Use the "sign" parameter for credit balances.

"1"

Debit only - only include accounts with debit balances. By default accounts with debit balances are included and there is no need to use the "sign" parameter.

Example 1

GRPENT("1","BR","5000")

Returns the actual year to date report balance by entity for all accounts referenced to leadsheet number 5000 in grouping 1 in Working Papers.

Example 2

GRPENT("2","BR:YR1,"2000")

Returns the prior year to date report balance by entity for all accounts referenced to group number 2000 in grouping 2 in Working Papers.

Example 3

The following example uses a wildcard in the form of the question mark (?) to link multiple group numbers using the specified number format.

GRPENT("2","BA:YR0","2??")

Returns the current year-to-date adjusted balances by entity for all accounts assigned to grouping 2 group numbers that are 3 digits long and that begin with the number 2. In other words, this functions links to balances from group numbers 200, 201, 201 and so on.

Example 4

GRPENT("M","BA:YR1","100")

Returns the prior year adjusted balance by entity for all accounts assigned to map number 100 in Working Papers. This is identical to inserting the calculation MAP("BA:YR1","100").

Example 5

GRPENT("T", "BA", "13.A", "-1")

Returns the active year to date balance by entity for all accounts with credit balances assigned to tax code 13.A in Working Papers.

Example 6

There is support for the balance identifier "SUB". Using this includes the children of a group number in a total.

GRPENT("3", BA:SUB","4")

Returns the final balance by entity for all accounts assigned to grouping 3 group numbers that begin with the number 4. In other words, this function links to balances from group numbers 4, 4.10, 4.20, and so on.

Related Topics