IP.GLBASEAMOUNT function
Description
Returns the general ledger base amount.
Syntax
=IP.GLBASEAMOUNT(legal_entity, period, account)
| Attribute | R/O | Description |
|---|---|---|
| Legal_entity | (required) | The code of the Legal entity |
| Period | (required) | Period code (yyyymm) |
| Account | (required) | Account code |
| Postings | (optional) | Any posting attribute such as CostCentre, Department, Product. You can have several Postings at one time. |
Example:
=IP.GLBASEAMOUNT("LegeA",202312,"10030 Sales, Services","Product","ENT","CostCentre","LOND")
Note
Posting attributes
A Posting attribute refers to attributes that can be used to summarise transactions after they have been posted. Enter the argument in the next input cell. e.g.
To be able to see the amounts where the Posting attribute specified is Null in the General Ledger, then enter "" as the argument value. 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 June 2025