gtINStockItemSellingPrice
This function returns the selling price of an inventory item. A valid inventory item returns a selling price for a specific date and customer.
Company
The company code that the inventory item belongs to.
StockItem
The inventory item to be checked.
CurrencyCode
The currency code to use for the price of the specified inventory item — for example, NZD.
SellingDate
The selling date to use for the inventory item.
UnitOfMeasure
The unit of measure for this inventory item.
PriceLevel
Indicates the price book from which the price is required.
Qty
If quantity breaks are used the selling price is returned for this quantity. The quantity is validated otherwise it is taken as zero. The value entered must be a whole number.
Location
The location path for the inventory item to be checked. The location passed is validated otherwise a null is accepted.
TaxInclusive
Flag indicating if transactions are to be created tax inclusive or exclusive. If True, the price returned is Tax Inclusive.
ReturnType
Denotes the type of the value returned. Discount and TaxRate are valid types. If not entered the price value is returned.
TaxCode
The code that determines the tax rate and tax type for the transaction. If not entered and Greentree Desktop cannot find a valid default, then an error is returned and the user must enter a valid code.
Customer
The customer code that this price applies to.
Returns
- Value returned
- Error - if an error is encountered
Example
gtINStockItemSellingPrice(01,69EC EXECUTIVE,NZD,31/03/2002,EACH)
Errors Returned
- Must have a Company Identifier
- Must have a Stock Item
- Must have a Currency Code
- Must have a valid date
- Must have a unit of measure