IP.GLYTDPROJBASEAMOUNT function
Note
This function is no longer in use. Please use IP.GLYTDBASEAMOUNT instead with the appropriate posting arguments.
In case any user is still using an old Excel sheet, the user guide for GLYTDPROJBASEAMOUNT is below.
Description
Returns the general ledger base currency amount for a legal entity, financial year, account and project
Syntax
=IP.GLYTDPROJBASEAMOUNT(Legal_entity, Financial_year, Account, Project)
Legal_entity | (required) | The code of the Legal entity |
Financial_year | (required) | The code of the Financial year |
Account | (required) | Account code |
Project | (required) | Project code |
Example:
=IP.GLYTDPROJBASEAMOUNT(LegeA, 2023, "10030: Sales, Services", Playwright Project)