MoneyWorks Manual
Edit
Inventory
Internal name Inventory
The inventory table is a subfile of Product, and stores the stock on hand of an item for each serial/batch and location combination.
| Expiry | D | The expiry date for expiring batches | |
| Identifier | 31 | 31 | The serial/batch number of the item |
| LastModifiedTime | S | Date and time the record was last altered | |
| Location | T | 15 | The location |
| ProductSeq | N | The sequencenumber of the product master record for the item | |
| Qty | N | The qty (stock on hand) of the item at this location. Use the SOHForLocation(location) function for the stock at a given location. | |
| StockTakeNewQty | N | The total entered stock count for a stock take. Use the StocktakeNewQtyForLocation(location) function for the stock at a given location. | |
| StockTakeStartQty | N | The total stock on hand when a stock take is commenced. Use the StocktakeStartQtyForLocation(location) function for the stock at a given location. |