MYOB Greentree

HideShow

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

 

gtFAPurchase


This function creates a purchase transaction for a fixed asset.

Company

The company code the Fixed Asset belongs to.

Batch

The batch number the transaction is to be posted into. A new batch will be created if this does not already exist.

BatchDescription

The description for the batch.

Reference

The transaction reference number. This must be unique or an error will be returned.

Posting Date

The posting date for the transaction. This determines the financial period the adjustment is posted to.

AssetCode

The fixed asset code of the transaction.

SubCode

The fixed asset subcode of the transaction.

AccPrice

The accounting price to be recorded for the purchase.

TaxPrice

The tax price to be recorded for the purchase.

OffsetDepn (for Australian companies only)

Enter True if any depreciation recovered from the replaced asset is to be recovered and offset with the new asset, otherwise enter False.

ReplacesAssetCode

If OffsetDepn is True, enter the code of the asset that is being replaced.

ReplacesAssetSubcode

If OffsetDepn is True, enter the subcode of the asset that is being replaced.

Quantity

The quantity of assets being purchased with the asset code.

Notes

Enter notes about the transaction if applicable.

Narration

Enter notes about the transaction if applicable.

Returns

  • Not Updated - when no error is encountered before running function
  • Updated - after function has successfully been updated to Greentree
  • Error message - if an error is encountered

Example

=gtFAPurchase(01,1003,April Asset Purchases,5001,01/04/2004,5001,,18000,18000)

Errors Returned

  • A FA Purchase with reference <reference> already exists.
  • Invalid Posting Date.
  • A Fixed Asset with asset code: <code> and subcode: <subcode> could not be found.
  • Accounting Purchase Price cannot be zero.
  • Taxation Purchase Price cannot be zero.
  • Could not find the fixed asset for replacement with asset code: <code> and subcode: <subcode>.
  • This batch is not a Fixed Asset purchase batch