gtINStockItemCosting

---

Use this function to create or update costing information for an inventory item.

Company

The company code that the inventory item belongs to.

Branch

This is the Branch code.

StockItem

This is the inventory item code.

Batch

This is the unique identifying batch number. A new batch is created if none exists and if an existing batch is referenced, it must be an IN batch.

Location

This is the location code that the costs relate to. If left blank, costs are updated at the master level.

BatchDesc

This is the description of the batch.

AvgeCostNet

This is the net average cost of the inventory item. The average cost should be greater than or equal to zero.

LastCostNet

This is the net last cost of the inventory item. The last cost should be greater than or equal to zero.

StdCostNet

This is the net standard cost of the inventory item. The standard cost should be greater than or equal to zero.

Returns

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

Example

=gtINStockItemCosting(01,01,68SC SECRETARY,100555,A01,24/04/2000,Update Costs,,,,,45.00, 24/04/2000)

Errors Returned

• Must have a Company identifier
• Must have a Stock Item Code
• Must have a Branch Code
• Must have a Batch identifier
• Document Date must be in format dd/mm/yyyy
• Average Cost Net must be numeric or empty
• Average Cost Date must be in format dd/mm/yyyy
• Last Cost Net must be numeric or empty
• Last Cost Date must be in format dd/mm/yyyy
• Standard Cost Net must be numeric or empty
• Standard Cost Date must be in format dd/mm/yyyy

---