Search Results for

    Show / Hide Table of Contents

    IP.GLDASGROUPCURAMOUNT function

    Description

    Returns the currency amount from the general ledger for Currency, Legal Entity(s), Period(s), DAS code, DAS Group code(s), Postings (Attribute, Attribute value(s) )

    Syntax

    =IP.GLDASGROUPCURAMOUNT(currency, legal_entity, period, das_code, das_group_code, postings)

    Attribute R/O Description
    Currency (required) Currency (3 char)
    Legal_entity (required) The code of the Legal entity
    Period (required) Period (yyyymm)
    DAS Code (required) The DAS code
    DAS Group Code (required) The DAS Group code
    Postings (optional) Any posting attribute such as CostCentre, Department, Product. You can have several Postings at one time.

    Example:

    =IP.GLDASGROUPCURAMOUNT("GBP","LegeA",202501,"DAS_SOFA","SOFA","CostCentre","LOND")


    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