Search Results for

    Show / Hide Table of Contents

    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

    In this article
    Back to top Generated by DocFX