Excel Reporting
Library Overview Reference Products Sales Stock Departments

Excel Stock Pinboards

Stock Levels

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

Examples

FormulaOutputNotes
=pinboard("product.onhand", 123, 4)17Current quantity on hand for Product# 123 in Store# 4

Writeoffs

  • product.writeoff.qty
  • product.writeoff.value

Arguments

ParameterNameNotesExamples
1Product IdRequired123
2Start DateOnly include sales after this date. 1-jan-2020
today-180
3End DateOnly include sales up to this date1-jan-2021
today-90
4Location
5Reason
6Restrictions

Restrictions provide additional filtering, the following restrictions are available.

KeywordDescriptionExample
supplier N
or spid N
department N
or depid N

Examples

FormulaOutputNotes
=pinboard("product.onhand", 123, 4)17Current quantity on hand for Product# 123 in Store# 4