Search Results for

    Show / Hide Table of Contents

    IP.GLGROUPCURAMOUNT function

    Description

    Returns currency amount balance from the GL for Currency, Legal entity(s), Period(s), Account Group(s), Postings (Attribute, Attribute value(s)).

    Syntax

    =IP.GLGROUPCURAMOUNT(currency, legal_entity, period, account_group)

    Attribute R/O Description
    Currency (required) Currency
    Legal_entity (required) The code of the Legal entity
    Period (required) Period (yyyymm)
    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.GLGROUPCURAMOUNT("GBP","LegeA",202401,"INC","CostCentre","Department")


    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 June 2025

    In this article
    Back to top Generated by DocFX