gtGLBudUpd

This function updates the Greentree General Ledger Budget information. If a new budget number is used, then a new budget number will be created in Greentree when the update is carried out.

Company

The company code that the account budget belongs to.

Account

The general ledger account code that the budget information is to be updated on. Wildcard accounts or tree identifiers are not allowed.

Budget

The budget number to be updated.

StartDate

The date that represents the posting period for the first budget amount in a standard date format.

IsQuantity

Flag that indicates quantity or unit budget information if True.

CreditAccount

Flag that indicates the account is a credit account. If True, the amounts' signs are reversed before posting.

TranCodes

The transaction codes that the budget information is to be updated on for this general ledger account code.

OpeningBalance

The opening balance for the budget year if the account specified in the function is an asset or a liability.

Note

Notes to be of the budget. These are recorded at the level of the budget entry using the account or account transaction code combination. Use the gtGLBudNote function to enter notes for a period. The cell referenced can contain a empty value.

Amount

A variable number of amounts. All amounts are in the account currency. The first amount will be posted to the period containing the StartDate. The remaining amounts will be posted into each subsequent period, up to 22, after the first.

See Budget Maintenance (Reporting Budgets) for details of how the budgets are updated.

Returns

Not Updated - where no error is encountered
New Budget No. - Indicates a new budget number is used
Error - if an error is encountered

Example

=gtGLBudUpd(01,MAS.AK.SLS.1010,01,01/04/2014,False,True,,5,000.00,,10,000.00,11,000.00...etc)

Errors Returned

Must have a Company identifier
Invalid Company identifier
Must have an Account identifier
Account does not exist
Must have a Budget number
Budget is closed for update
Must have a Start Date
Amount in position nn is not numeric