gtINStockItem

This function creates and updates inventory item masterfile information in Greentree Desktop.

Company

The company code that the inventory item belongs to.

Code

The inventory item code update or create. This code must be unique.

Description

The description of the inventory item to update or create.

Note: This option is mandatory if the inventory item is a new one.

Status

The status of the inventory item. You must specify a valid status.

Note: This option is mandatory if the inventory item is a new one.

Notes

Use this field to record any notes about an inventory item.

AnalCode

The Inventory Analysis code for this inventory item. You must specify a valid analysis code.

Decimals

The number of decimal places used for this inventory item. If left empty the Module Control default is used. The decimal place must be between 1 and 4.

JCActivityCode

If applicable this is the Job Cost Activity code for the inventory item.

StockType

The type of this inventory item — for example, Serial Number. If a new inventory item is created and this field is left blank, the Module Control default is used.

SerialLotFormat

Lot Serial Format.

SerialLotLength

Length of Serial Lot Number.

Weight

The unit weight of the inventory item. If a new inventory item is created and this field is left blank, the default value of 0.00 is used.

Volume

The unit volume of the inventory item. If a new inventory item is created and this field is left blank, the default value of 0.00 is used.

Ranking

The ranking of the inventory item. If a new inventory item is created and this field is left blank, the default value of None is used.

NonDiminishing

Sets the inventory item up as a service item that can be sold but no current quantities are kept — for example, freight. Non Diminishing inventory items must use EACH as the stocking unit.

Warranty

A flag that determines whether or not warranty details are kept for Lot Serial items on sale.

AllowOverSell

A flag that indicates over selling is allowed.

AllowNegOnHand

A flag that indicates whether the item can have a negative quantity on hand.

PrintLabel

A flag that indicates receiving or item labels can be printed for the item.

InNextStockTake

Forces the item to include in the next stock take run when running cyclical stock takes — for example, daily or weekly.

StockTakeCycle

The Stocktaking cycle (for example, monthly) for the inventory item. If not specified the default stocktake cycle from the Inventory Module Control is used.

Dimensions

Indicates whether the item is dimension controlled.

Returns

Not Updated - if no error is encountered
Updated - after running Greentree Desktop update function
Error message - if an error is encountered

Example

=gtINStockItem(01,75695YF RECEPTION,PLAIN RECEPTION CHAIR,Active,,CH)

Errors Returned

Must have a Company Identifier
Must have a Stock Item code
New Stock Item must have a description
New Stock Item must have a status code
Invalid Inventory Analysis Code