TGPGLAccountBalance() is a function that pulls the period Balance and Credits/Debits of a G/L account.
Some of the fields used are defined as follows:
- Account (Required): Either the Index or the Number of the account to search
- Year (Required): The Numeric value for the Year to search.
- Period (Required): The Numeric value for the Period to search.
- Column (Optional): A selection of the specific column to search:
- [B]alance (default)
- [E]nd Balance]
- [N]et Change
Here are some examples of the Syntax as well as the results: