- Contents
- Index
- Search
Display results with all search words
gtINStockItemSellingPriceImport
This function updates inventory item selling price information to Greentree.
Company
The company code that the inventory item belongs to.
StockItem
The inventory item code that selling prices are to be updated to.
Price
The selling price for the inventory item - this is assumed to be inclusive or exclusive of tax depending on the pricing tax type set on the Inventory Module Control form.
Markup
The price markup or margin %, or margin value, to be applied for the inventory item selling price.
ReviewDate
The review date to use for this inventory item selling price.
UnitOfMeasure
The selling unit of measure for this inventory item (this may differ from the stocking or purchasing unit)
Active
A flag which indicates whether the selling price is active for this inventory item — for example, 'True' or 'False'.
CurrencyCode
The currency code this selling price is for — for example, 'NZD' (New Zealand dollars)
TaxCode
The tax code to use for this inventory item selling price.
PriceLevel
The price book to use for this selling price.
Location
The location to use for the inventory item selling price. If the pricing level is set at Location, a location must be specified.
Returns
- Not Updated - if no error is encountered
- Updated - after running the update function
- Error message - if an error is encountered
Example
=gtINStockItemSellingPriceImport(01,68SC SECRETARY,80,0,23/10/00,EACH,True,NZD,NZ GST, RETAIL,A01)
Errors Returned
- Must have a Company identifier
- Must have a Stock Item
- Must have a currency code
- Must have a valid review date
- Must have a Unit of Measure
- Must have a Price Level
- Must have a Tax Code