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