gtGLImportAccount

This function creates and updates General Ledger Account information in Greentree Desktop.

Company

The company code that the general ledger account belongs to.

Account

The general ledger account code for the account to be created or updated.

ShortCode

The Short Code for the general ledger account.

Description

The description of the general ledger account.

SecurityLevel

If security applies to the account, this is a number, which denotes the security level of the general ledger account.

AccountType

The Account type for this account: 'Income', 'Expense', 'Asset' or 'Liability'.

AccountSign

Indicates whether the account is a debit or credit account.

AltDesc

An alternate description for the account.

KeepTrans

Denotes the length of time the transaction is to be kept. A valid code must be used — for example, 'Keep for two years'.

CurrencyCode

The currency in which the account is to be held in the ledger for example, 'NZD' (New Zealand Dollars)

ActualRate

If the account is a quantity account this is the rate per unit. Defaults to 1.

BudgetRate

If the account is a quantity account this is the budget rate per unit. Defaults to 1.

QuantityAccount

Indicates whether the account is a quantity/unit account — for example, True or False. Defaults to False.

UnitDesc

The description of the units — for example, kilos. Must be a maximum of six characters. If the GL Account is a quantity account, the unit description must be specified.

MonetaryItem

Indicates whether the account is a monetary account — for example, True or False. Defaults to True.

Delete

A flag which indicates whether the account is ready for deletion, for example, True or False. Defaults to False.

PrintInDetail

A flag that indicates whether details are to be printed — for example, True or False.

Notes

Notes about the GL Account.

AllowZeroQty

Indicates if zero qty transactions can be entered if the account specified is a quantity account — for example, True or False.

AllowZeroVal

Indicates if zero value transactions can be entered if the account specified is a quantity account — for example, True or False.

TaxClass

Account tax class. Must be valid class, existing in Tax Class Maintenance.

TaxCode

Account tax code. Must be valid code, existing in Tax Code Maintenance.

Returns

Not Updated - if no error is encountered
Updated - after running Greentree Desktop update function
Error message - if an error is encountered

Example

=gtGLImportAccount(01,MAS.AK.SLS.1010,SLS,SALES - DESKS & CHAIRS,1,Income,Credit,,.

Keep for two years,NZD,,,,,,,False)

Errors Returned

Must have a Company identifier
Must have an Account Number
Must have an Account Short Code
Must have an Account Description
Must have an Account Type defined
Must have an Account Sign defined