Search Results for

    Show / Hide Table of Contents

    IP.CP.GLYTPBASEAMOUNT function

    Description

    Returns the general ledger base amount YTP for the account code.

    Syntax

    =IP.CP.GLYTPBASEAMOUNT(legal_entity, consolidation_period, account)

    Legal_entity (required) The code of the Legal entity
    Consolidation Period (required) Period code
    Account (required) Account code
    Postings (optional) Any posting attribute such as CostCentre, Department, Product. You can have several Postings at one time.

    Example:

    =IP.CP.GLYTPBASEAMOUNT("LegeA","January 2024","10030: Sales, Services",,"CostCentre","LOND","Department","Support")


    Note

    Posting attributes

    • A Posting attribute refers to attributes that can be used to summarise transactions after they have be posted.

    • 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.

    In this article
    Back to top Generated by DocFX