IP.GLYTPPERIODDATECURAMOUNT function
Description
Returns GL base amount up to a date in the financial year for Currency, Legal Entity(s), Period Date, Account(s) including special periods, Postings (Attribute, Attribute value(s)).
Syntax
=IP.GLYTPPERIODDATECURAMOUNT(Currency, Legal_entity, Period Date, Account)
Attribute | R/O | Description |
---|---|---|
Currency | (required) | The currency (3 char) |
Legal_entity | (required) | The code of the Legal entity |
Period Date | (required) | Period Date (yyyy-mm-dd) |
Account | (required) | Account code as in Chart of Accounts |
IncludeSpecialPeriods | (optional) | True (1) or False (0) |
Example:
=IP.GLYTPPERIODDATECURAMOUNT("GBP", "LEGEA","2025-05-01","10344",1)
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