<< Click to Display Table of Contents >> Navigation: PaXcel - functions > GL Functions > GLDetails() |
GLDetails( Company, Account, FieldToReturn )
This function will allow you to return some information about the GL account itself.
The arguments are as follows:
Company: This is the path to your Pastel directory. For example: c:\PastelData\_demo would enable you to retrieve information from the Pastel Partner demo company.
Account No: This is the Pastel GL account number that you wish to retrieve information for; for example this could be account no 1000000 which is the Sales account.
FieldToReturn: This can be one of the following keywords.
Value to Return Keyword
Financial Category FinCat
Description Descr
Report Category RepCat
External Code External
GAAP Code GAAP
GAAP Title GAAPTitle
Return the description for the account contained in cell A9.
GLDetails(C1, A9, "Descr")
Return the external code for this account.
GLDetails(C1, A9, "External")
|