MYOB Greentree

HideShow

  • Contents
  • Index
  • Search
 
Display results with all search words

 

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