Stock orders

This table is used to model individual lots that make up the current inventory.

Most businesses can represent the current inventory as a single onhand number in the buffer table.

Some businesses do require a more detailed lot-by-lot representation of the current inventory:

  • to track the expiry date of perishable inventory.

  • to track the batch information of inventory reserved for specific demands or customers in a make-to-order environment.

This table exists when the shelflife app is installed (which is only available in the Enterprise and Cloud Editions).

Field

Type

Description

reference

string

Unique identifier for the stock order.

item

item

The item being purchased.

location

location

The location receiving the stock order.

batch

string

Blank/unused for make-to-stock items.
Identification of the batch for make-to-order items.

quantity

number

The quantity in stock.

end date

datetime

Date of the .

expiry

datetime

Defines the date when the material will expire.
When left unspecified, it is computed as the end date plus the item’s shelf life.

demands

list

The demand(s) (and quantity) pegged to the stock order. This is a computed field.

period of cover

duration

This is a computed field that shows how long the material of a stock order is expected to stay in your inventory.
The period of cover represents how long it will last until the last material of the stock order will be consumed.