gtINStockItemCost

---

This function returns the cost price of an inventory item at location level. It is used with the Refresh Data menu option.

Company

The Company code for the inventory item.

StockItem

The inventory item for which a cost is to be found.

Location

The location of the inventory item cost required.

CostType

The code that determines which cost is returned. Valid codes are:

• A - average cost is returned
• L - last cost is returned
• S - standard cost is returned

Returns

• The location cost - if found
• Error message - if an error is encountered

Example

=gtINStockItemCost (01,68SC SECRETARY,A01,A)

Errors Returned

There is no Excel sensibility checking on this function. Greentree Desktop errors only are returned.

---