Excel Stock Pinboards
Stock Levels
- product.onhand
- product.onhand.group
- product.onhand.brand
- product.onhand.range
- product.onhand.depid
- product.onhand.spid
Examples
| Formula | Output | Notes |
| =pinboard("product.onhand", 123, 4) | 17 | Current quantity on hand for Product# 123 in Store# 4 |
Writeoffs
- product.writeoff.qty
- product.writeoff.value
Arguments
| Parameter | Name | Notes | Examples |
| 1 | Product Id | Required | 123 |
| 2 | Start Date | Only include sales after this date. | 1-jan-2020 today-180 |
| 3 | End Date | Only include sales up to this date | 1-jan-2021 today-90 |
| 4 | Location | ||
| 5 | Reason | ||
| 6 | Restrictions |
Restrictions provide additional filtering, the following restrictions are available.
| Keyword | Description | Example |
| supplier N or spid N | ||
| department N or depid N |
Examples
| Formula | Output | Notes |
| =pinboard("product.onhand", 123, 4) | 17 | Current quantity on hand for Product# 123 in Store# 4 |