gtINAPLine

This function supplies the information to add line items to Inventory Transaction headers. The Transaction Reference parameter must be the unique ID returned by the gtINTransaction function call.

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

TransReference

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

Stock

The inventory item reference that the invoice line belongs to.

Location

The location of the inventory item.

FcAmount

If foreign currency is applicable this is the foreign currency amount.

FcTax

The tax on the foreign currency amount.

Quantity

The number of units relevant for this line. This must be zero on all but numeric based general ledger accounts.

TaxType

Valid tax types are Inclusive or Exclusive.

fcHoldAmount

If foreign currency is applicable this is the amount to be put on hold for this line.

fcDiscount

The amount of foreign currency discount given on this line.

UnitPrice

Price per unit of quantity above.

TaxPercentage

Percentage of tax for this line item.

DiscPercentage

Percentage discount given, defaults to 0.

Narration

Narration for this transaction.

UOM

Unit of measure for this line item. Usually expressed as EA (each)

TaxCode

The code that determines the tax rate and type for the transaction. If not entered and Greentree Desktop cannot find a valid default, then an error is returned and the user must enter a valid code.

Returns

Ok - if there are no errors
Error - if an error is encountered

Example

gtINARLine(INTRN-1,68SC SECRETARY,A01,47.00,5.88,1.00,Exclusive,,,,,,,EACH,NZGST)

Errors Returned

Invalid Transaction header reference. Should be INTRN-nn
Must have a Stock Identifier
Inventory Transaction header not found