gtGLInwardsCashGLLine

This function records the line item data needed to create an Inwards Cash transaction.

Each inwards cash transaction is uploaded to Greentree Desktop as a complete transaction set. The receipt either uploads in its entirety or nothing of the document is loaded into Greentree Desktop.

Inter-company transactions may be processed using a company that is different to the receipt header in this function.

Reference

This must be the unique identifier generated by the gtGLInwardsCash function call. It has the format GLINCASH-nnn. This ensures the lines are of the correct receipt header details and it ensures Excel creates the header information before attempting to calculate and create the receipt line item details.

AccountCompany

Company code the account belongs to. This may be different to the company code specified in the receipt header (gtGLInwardsCash) for inter-company transactions.

Account

Account number for which the receipt transaction is being created.

NetAmount

The net amount of the receipt line to be posted to the above account.

TaxAmount

The amount of tax for this line.

TaxPercentage

The percentage of tax for this line.

TaxCode

The code that determines the tax rate and type for the transaction.

Quantity

Quantity of the transaction on accounts that require quantities. Other accounts should have this parameter left blank.

SubCode

Account sub-code if its relevant for the account. This may be left empty if it's not used on the account.

TaxType

Valid tax types are I(nclusive) or E(xclusive). If omitted, defaults to E.

LedgerToTranRate

The currency conversion rate used to convert a foreign currency receipt line into the base currency of the ledger. Defaults to 1.0 for local currency if omitted.

IsLedgerToTranRateMultiply

Flags whether the rate is a multiply or divide rate. If omitted, defaults to True for multiply rate.

AccountToTranRate

The currency conversion rate used to convert a foreign currency receipt line into the currency of the account it is being posted to. If omitted, defaults to 1.0 for local currency.

IsAccountToTranRateMultiply

Flags whether the rate is a multiply or divide rate. If omitted, defaults to True for multiply rate.

Narration

Line item narration.

TransCode

The transaction tree branch code, or series of codes separated by a comma, for the analysis of the current receipt line. These may be entered into the formula or referenced to cells.

If the transaction tree branch codes are listed over several cells, these may be referenced by the cells, concatenated by the & symbol, separated by a comma enclosed in quotes — for example, if the transaction tree branches are held in cells C4, C5, C6 the TransCode parameter to reference all these cells would be: C4&,&C5&,&C6.

Returns

Ok - if no error is encountered
Error - if an error is encountered

Errors Returned

Invalid GL Inwards Cash header reference
GL Inwards Cash header not found
The account company is required
The account is required
Invalid LedgerToTranRate, must be a number or omitted
Invalid AccountToTranRate, must be a number or omitted
Invalid IsLedgerToTranRateMultiply, must be True, False, or omitted
Invalid IsAccountToTranRateMultiply, must be True, False, or omitted
This branch does not exist (for transaction codes)
A branch code specified in the TransCode parameter is not recognised
The <branch code> branch could not be posted as its dependencies overrides the setting for the <tree code> tree.