MYOB Greentree

HideShow
  • Contents
  • Index
  • Search
 
Display results with all search words

 

gtGLBudUpd

This function updates the General Ledger Budget information. If a new budget number is used, then a new budget number is created in Greentree Desktop 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 is posted to the period containing the StartDate. The remaining amounts is 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 - if 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