gtFAMasterMain

This function creates and updates Fixed Assets in Greentree Desktop. The function provides the basic information required to create and update a new Fixed Asset. If the Fixed Asset does not exist in the company then a new record is created. If the code does exist, then that record updates.

You can update additional detail for a Fixed Asset using the FA Other Detail functions, and an opening balance updated using the FA Opening Balance function.

Company

The company code the Fixed Asset belongs to.

Code

The Fixed Asset code that is to be updated or created.

SubCode

The Fixed Asset subcode.

AccountCode

The accounting depreciation code for the Fixed Asset. If it is not specified, the code and depreciation details of the Analysis Code are used.

TaxDepnCode

The tax depreciation code for the Fixed Asset. If it is not specified, the code and depreciation details of the Analysis Code are used.

Description

The description of the Fixed Asset.

BalType

The balance type code that determines how long transaction history is kept for an asset. Select Forever or Yearly.

Comments

A short comment about this Fixed Asset.

Notes

Provided for additional general information about this Fixed Asset.

PurcStatus.

Defines the current purchase status of a Fixed Asset.

SerialNo.

The serial number, if applicable, to this Fixed Asset.

AnalysisCode

The analysis group that this asset belongs to.

ProfitCentre

The profit centre for this Fixed Asset.

JobCode

The job code, if applicable, used to record this Fixed Asset.

Location

The location short code for this Fixed Asset.

IsPool

A flag that indicates the pool status of a Fixed Asset — for example, 'True' or 'False'. If this is left blank, it defaults to False.

Branch

The branch code for this fixed asset.

Effective Date

This is the date on which the depreciation rate details start to apply. It must be a period start date. If the Effective Date is not specified here, the asset is imported with depreciation details using the AccountCode and TaxDepnCode. If these are not specified, then the depreciation details of the specified analysis group code are imported, and the effective date on both accounting and tax rates is set to the beginning of the current FA period.

AccBasedOnCurrentBV

This indicates whether the accounting depreciation details are to be applied to the original cost or current book value. If this is not specified, it defaults to False. If set to:

False, then the depreciation details are to be applied based on the original cost (straight-line method) or opening book value (diminishing value).
True, then the depreciation details are to be applied based on the current book value of the asset, as at the effective date of the depreciation details.

TaxBasedOnCurrentBV.

This indicates whether the tax depreciation details are to be applied to the original cost or current book value. If this is not specified, it defaults to False. If set to:

False, then the depreciation details are to be applied based on the original cost (straight-line method) or opening book value (diminishing value).
True, then the depreciation details are to be applied based on the current book value of the asset, as at the effective date of the depreciation details.

Activity Code

Mandatory if the Job uses a Work Centre Plan.

Work Centre Plan

Mandatory if the Job uses a Work Centre Plan.

For the last two parameters:

If Job is not specified, these parameters are ignored.
If the Job does not use a Work Centre Plan and the Activity Code is specified, then it must belong to the Job's Activity Group.
If the Job does not use a Work Centre Plan and these parameters are not specified, then the Activity Code set up in Fixed Assets Module Control and its Work Centre are used.
If the Job uses a Work Centre Plan, the Activity Code and Work Centre combination must be valid for the Plan.

Returns

Not Updated - when no error is encountered
Updated - after Update Fixed Assets is run
Error message - if an error is encountered

Example

=gtFAMasterMain(01,1001,01,DM20,DM20,Honda Civic,Yearly,,,,,MV,0101,,AUCK,,)

Errors Returned

Must have a Company identifier
Must have a Fixed Asset Code
Must have a Fixed Asset Sub Code
Asset <asset code> Activity Code <activity code> does not belong to Activity Group
Asset <asset code> Activity Code <activity code> and Work Centre <work centre code> are not valid for the Job - the Activity Code does not belong to the Activity Code Group of Plan Work Centre <work centre code>.
Asset <asset code> Activity Code <activity code> and Work Centre <work centre code> are not valid for the Job - Work Centre is completed
Activity Code <activity code> and Work Centre <work centre code> are not valid for the Job