IP.GLPARENTYTPCURAMOUNT function
Description
Returns the currency amount from the GL for Currency, Legal Entity(s), Period, Account(s), Parent Attribute, Parent attribute value(s) including Parent postings.
Include special periods up to and including the period specified.
Syntax
=IP.GLPARENTYTPCURAMOUNT(currency, legal_entity, period, account, parent_posting_attribute, attribute_values, include_parent_postings, include_special_periods)
| Attribute | R/O | Description |
|---|---|---|
| Currency | (required) | Currency (3 char) |
| Legal_entity | (required) | The code of the Legal entity |
| Period | (required) | Period (yyyymm) |
| Account | (required) | Account group code |
| ParentPostingAttribute | (required) | Parent posting attribute |
| AttributeValues | (required) | Posting attribute values |
| IncludeParentPostings | (required) | True (1) - postings made direct to the parent attribute are included in the balance returned or False (0) postings made direct to the parent attribute are not included in the balance returned |
| IncludeSpecialPeriods | (required) | True (1) or False (0) |
Example:
=IP.GLPARENTYTPCURAMOUNT("EUR","LEGEA","202501","600100","PROJECT","PRNTPROJ1",1,0)
Note
Posting attributes
A Posting attribute refers to attributes that can be used to summarise transactions after they have be posted. Enter the argument in the next input cell. e.g.
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.
Updated May 2025