IP.GLGROUPBASEAMOUNT function

Description

Returns the general ledger base amount for an account group.

Syntax

=IP.GLGROUPBASEAMOUNT(legal_entity, period, account_group)

Legal_entity	(required)	The code of the Legal entity
Period	(required)	Period code
Account_group	(required)	Account group code
Postings	(optional)	Any posting attribute such as CostCentre, Department, Product. You can have several Postings at one time.

Example:

=IP.GLGROUPBASEAMOUNT("LegeA",202401,"INC","CostCentre","LOND","Department","Support")

Note

Posting attributes

• A Posting attribute refers to attributes that can be used to summarise transactions after they have be posted.

• Common attributes include Cost centre and Department but can also include custom attributes.

  

• The posting attributes are derived from the Chart of account rules related to the Account code.