gtINTransaction

This function records the header data needed for an inventory transaction.

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

The unique identifier returned by the function call is structured as INTRN-nnn if nnn is a sequential number that is unique for the current Excel session. This number links the line item functions with the inventory transaction header. This number is not updated to or passed to Greentree.

Company

The company identifier that the transaction is created in.

Transaction Type

Denotes the type of transaction — for example, an AP transaction may have the type AP Credit.

Reference

A user defined reference for the transaction.

Batch

The batch number the transaction is posted to. A new batch is created if it does not exist (and a Batch Description must be entered)

Batch Description

The batch description if a new batch is created. This is ignored if the batch already exists. If the batch description is null and the batch does not exist an error is returned.

Branch

The branch identifier. This is required.

Location

The inventory batch location.

Posting Date

The posting date for the Inventory transactions. This determines the financial period the transactions post to.

Document Date

The document date for the transaction.

Currency Code

The currency code. Only needed for foreign currency transactions.

CurrencyRate

The rate for the foreign currency transaction. Defaults to 1.

IsMultiply

Defaults to True. If true, the rate above is a multiply rate rather than a divide rate.

Narration

The narration for the transaction header.

BillReference

The waybill or freight docket reference for the transaction.

Carrier

The carrier involved with the transaction.

Description

The description of the inventory transaction.

Detail

Transaction detail.

Eta

The expected delivery date.

Returns

Unique identifier - to be used to link the document header with its inventory lines
Error - if an error is encountered

Example

gtINTransaction(01,+ADJ,14576,1111,IN Adj Batch 1111,01,A01,01/01/01,01/01/01,)

Errors Returned

Must have a Company Identifier
Must have a Transaction Type
Must have a Reference
Must have a Batch Identifier
Must have a Branch Identifier
Must have a Document Date
Must have a Posting Date
Must have a Currency Code
ETA is not a valid date and is not blank