Search Results for

    Show / Hide Table of Contents

    IP.GLYTDBASEAMOUNT function

    Description

    Returns the general ledger base currency amount for a legal entity, financial year & account

    Syntax

    =IP.GLYTDBASEAMOUNT(Legal_entity, Financial_year, Account)

    Attribute R/O Description
    Legal_entity (required) The code of the Legal entity
    Financial_year (required) Financial year (yyyy)
    Account (required) Account code
    Postings (optional) Any posting attribute such as CostCentre, Department, Product. You can have several Postings at one time.

    Example:

    =IP.GLYTDBASEAMOUNT("LegeA",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. 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