Is the unique identifier for a stock item. It must be in capital letters and cannot be duplicated and must have more than 5 characters.
A description of the product that will appear on invoices.
A description of the packing size of the product for example:
A 10 character group code. Group codes collect together multiple products in to groups.
A 10 character group code. Price list codes collect together multiple products in to groups and create an independent grouping to the Group field above
The default supplier for this item
The suppliers code that will be ordered when ordering this product form the default supplier.
Some internal comments for this product. The content of this field is not used my the system.
The current stock on hand for this item. This is stock that is available for sales and not reserved for sales see Checkout or on stock on Returns notes
A count of the number of items on purchase orders . There may be two number separated by a slash, this indicates <total on order> / <total dispatched>
A count of the number of items on backorder, see backorders .
The threshold for the minimum stock level. At this point the stock is running low and need to be reordered. A stock minimum of zero means “we do not hold stock of this item”.
The maximum quantity to keep in stock at any given time. This value is only a guide and not an absolute limit. It could be the maximum size of the storage allocated for this item or the a safe amount of stock to keep without risk of over stocking.
An arbitrary cost price, ideally the project cost of the item at the next purchase.
The cost price when this item was last purchased.
The cost price of this item two purchases ago.
The cost price of this item three purchases ago.
A rolling average cost as calculated by the software.
Average cost is calculated by linking it with the stock value.
average cost * stock on hand = stock value
| Stock on hand | Stock value | Average cost |
|---|---|---|
| 10 | £25.00 | £2.50 |
| We purchase 10 more items at £2.00 each (the value of the new stock is £20.00). The new Stock value is £45.00 and the new stock on hand is 20. | ||
| 20 | £45.00 | £2.25 |
| Stock on hand | Stock value | Average cost |
|---|---|---|
| 10 | £25.00 | £2.50 |
| We sell 4 items to a customer, the stock value is reduced by 4 x £2.50 = £10 | ||
| 6 | £15.00 | £2.50 |
| We purchase 10 more items at £2.00 each (the value of the new stock is £20.00). The new Stock value is £35.00 and the new stock on hand is 16. | ||
| 16 | £35.00 | £2.18 |
| We sell 6 items to a customer, stock value is reduced by 6 x £2.18 = £10.90 | ||
| 10 | £21.80 | £2.18 |
| Stock on hand | Stock value | Average cost |
|---|---|---|
| 5 | £25.00 | £2.50 |
| We sell 6 items to a customer | ||
| -1 | -£2.50 | £2.50 |
| We purchase 10 more items at £2.00 each (the value of the new stock is £20.00). The new Stock value is £18.00 and the new stock on hand is 9. | ||
| 9 | £18.00 | £2.00 |
In the case where the stock on hand is negative, the new average cost becomes the current cost. The negative value is ignored.
The gross weight of the product including any packing.
The net weight of the product contents.
The number of items that can be fit in to 1 cubic meter.
The last time this item was stock checked. If and only if there was a stock adjustment made at the time of the stock take, there will be an adjustment entry in the stock adjust log. When a stock take shows that the stock on hand is correct, a log entry will not be created.