gtINJCLine

This function supplies the information to add line items to Inventory Transaction headers. It enables inventory items to be issued to Job Costing jobs. The Transaction Reference parameter that must be the unique ID returned by the INTransaction function call.

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.

Job

The code of the JC job to which the inventory is to be issued. The job must belong to a profit centre of the user's Profit Centre Group.

Activity Code

The activity code to which the inventory issue is to be assigned. This must be an activity code of type Stock, and must belong to the Job's Activity Group.

Work Centre

The work centre to which the inventory issue is to be assigned.

Stock

The inventory item code.

Location

The location of the inventory item.

Quantity

The quantity of inventory to issue.

TaxType

Valid tax types are Inclusive or Exclusive.

UOM

The item's unit of measure. If not specified, this defaults to the item's stocking unit of measure.

Price Level

Indicates pricing level for the line item. This is required if the transaction type selected in the header has Transfer at Selling Price set. If not specified, the price level defaults to the Default Price Book associated with the transaction type.

Amount

The net amount of the line.

Tax

The amount of tax for this line. If not specified, this is calculated depending on the Tax Type (inclusive/exclusive)

Discount

The amount of discount given on this line. If not specified, this is calculated as tax exclusive amount x DiscPercentage.

UnitPrice

Price per unit of quantity. If not specified, this calculates depending on the Transfer at Selling Price setting on the transaction type selected in the header.

TaxPercentage

Percentage of tax for this line. If not specified, this is calculated using the from TaxCode.

DiscPercentage

Percentage discount given.

Narration

Narration for this line.

TaxCode

The code that determines the tax rate and type for the transaction. If not specified, this is taken from the Inventory item.

Returns

INTRAN-nnn-mmm - if no errors are encountered
Error - if an error is encountered

Examples

Transfer at Cost:.

=gtINJCLine($B$21,5011,STOCK,ASSEM,00AOPEN17MONITOR,'02,2,Exclusive,EA,,,,,,,,,GST 10%)

Transfer at Selling:.

=gtINJCLine($B$21,5011,STOCK,ASSEM,750MBZIPEXT,'02,1,Exclusive,,RETAIL)

Errors Returned

Unknown INTransaction reference must be INTRAN- —
The job this stock transfer is being posted to is not in the users profit centre group
This activity code is not in activity code group assigned to this Job
The activity code (xxx) is not a stock activity code
The quantity must be greater than 0
Invalid Quantity. Must be numeric