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)

Legal_entity	(required)	The code of the Legal entity
Financial_year	(required)	The code of the Financial year
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.

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