gtGL

This function allows GL Account properties to be retrieved. A knowledge of the GLAccount class properties is required.

Company

The company code that the specified account belongs to.

Account

The account number that the property is to be found on.

Property

The property to retrieve from the account. This may be a nested series of properties if the property is a reference to another object in Greentree Desktop. Property names are nested with colon (:) delimiters — for example, myCurrency:code.

Returns

• GL attribute information for the account specified.

  Note: Dates are returned as a string formatted as dd/mm/yyyy. Excel is responsible for determining the final display format of the date under the control of the user. Numeric results are returned as a string with the format (-)n*(.n*) if () indicates optional segments. The gtGL function will detect numeric results and format the number appropriately.

• Error - if an error is encountered

Example

=gtGL(01,MAS.AK.SLS.1010,description)

=gtGL(01,MAS.AK.SLS.1010,myAccountType:text.

Errors Returned

• Must have a Company identifier
• Invalid Company identifier
• Must have an Account identifier
• Account does not exist
• Must have an Attribute name provided
• Attribute does not exist