Fieldpine Logo Documentation Home

product.onhand

Alternative Forms

product.onhand
product.onhand.depid
product.onhand.group
product.onhand.spid
product.onhand.group
product.onhand.range
product.onhand.brand

Returns the number of units in stock for a single product.

Syntax

 = Pinboard("product.onhand", Product-Number, Location)
Product-Number
Required. Identifies the product to calculate
Location
Optional. Requests that stock levels for a single location is returned

Example

 =Pinboard("product.onhand", 6011,32)

Return the current stocklevel for product 6011 in store #32