Stock.Level & Stock.Value

Stock.Level returns the total quantity of stock on hand, while Stock.Value returns the total value of stock on hand.

Stock.Level

Syntax

 = Pinboard("stock.level", "Required Information", Location)

Required Information

Required. Selects exactly which statistic you want. If not supplied, the default of "sum" is used

Keyword	Description
sum	Simple total of all products. If you have 3x "A" and -1 "B" in stock the value returned will be "2"
sum.positive	Simple total of all products with positive stock levels. If you have 3x "A" and -1 "B" in stock the value returned will be "3"
sum.negative	Simple total of all products negative stock levels. If you have 3x "A" and -1 "B" in stock the value returned will be "-1"
count	Simple count of products with any stock levels. This is the number of product lines NOT the actual amount of stock. If you have 301x "A" and -1 "B", and 16 "C" in stock the value returned will be "3"
count.positive	Simple count of products with stock positive levels. This is the number of product lines NOT the actual amount of stock. If you have 301x "A" and -1 "B", and 16 "C" in stock the value returned will be "2"
count.negative	Simple count of products with stock levels. This is the number of product lines NOT the actual amount of stock. If you have 301x "A" and -1 "B", and 16 "C" in stock the value returned will be "-1"

Location

Optional. Requests that stock levels for a single location is returned. If not supplied details for all stores are returned.

Caution. When calculating the results for all stores the value of "sum.positive" +/- "sum.negative" may not equal "sum". This happens when one store has "2" and another has "-2". This also applies to the other values such as "count"

If using variant based inventory, such as tracking different issues of magazines and periodicals, the "count" statistics will group all the variants together and only report one figure for a single product

Example

 =Pinboard("stock.level", "sum.positive",32)

Return the total number of items in stock for store #32

Stock.Value

Syntax

 = Pinboard("stock.value", "Required Information", Location)

Required Information

Required. Selects exactly which statistic you want. If not supplied, the default of "sum" is used

Keyword	Description
sum	Simple total value of all products.
sum.positive	Simple total value of all products with positive stock levels.
sum.negative	Simple total value of all products negative stock levels

Location

Optional. Requests that stock levels for a single location is returned. If not supplied details for all stores are returned.

Caution. stock.value pinboard can be show small rounding differences especially if you have variable weight items.

Example Spreadsheet (Requires correctly installed Excel Addin)