Lines, locations and the ledger
Stock lines, locations, the movement ledger and the reorder list, in one area.
One item's balance at two locations while a transfer posts: the source falls and the destination rises by the same quantity.
Trade counter rises by 6 to 10
What is in it
Every product writes movements through one writer, and each balance is summed from them.
Locations
Every place stock is held, each renamed or counted from its own row.
Every location has a code to scan, and a van becomes a location when Route is on.
Movements
The ledger, newest first: every receipt, issue, transfer and count, with who and when.
The Stock ledger for one item, newest first: two opening counts, then a transfer between locations with the balance after each movement.
Transfer of 6 from Main store posts: 37 left there
Lines
One balance per item per location, derived from the ledger and never typed over.
Reorder
Lines under their reorder point, turned into a supplier request or a purchase order.
Comes with
Questions
- Promises made at the quote need a quantity that is true wherever the stock sits.
- Design Engineer, Machinist, Route and Source add movements when Stock is on, all through the one writer.
- Only at a location that allows it, such as a van between a load scan and its reconciliation. Everywhere else the movement is refused.