How to build inventory tracking on Elastbiz

Inventory is another graph pretending to be a spreadsheet: items you stock, the suppliers you buy from, and every movement in or out. Model those as rows and the questions you actually ask — what is low, what is on order, what moved last week — become saved views.

What you will build

• A Products partition (SKU, name, on-hand, reorder point, supplier reference).
• A Movements partition (product reference, direction, quantity, reason, date).
• A low-stock view and an automation that opens a reorder task when on-hand drops below the reorder point.

Step by step

1. Model products. Columns: SKU, Name, On-hand, Reorder point, Supplier (reference to a Suppliers partition). Keep a per-row subtable for variants if you have them.
2. Record movements as rows. Each stock-in or stock-out is a Movement row referencing the product. On-hand is derived from movements, so the ledger and the number always agree.
3. Build a low-stock view. Filter Products where On-hand is at or below Reorder point. That view is your purchasing to-do list.
4. Automate the reorder. When a Movement pushes On-hand below the reorder point, open a Reorder task assigned to purchasing and post to #ops in Connect.
5. Attach the paperwork. Drop the supplier PO or delivery note into Files and link it to the product row — the document lives in the same graph as the stock number.
6. Let AI reconcile. An AI worker can compare movements against supplier invoices in Mail and flag mismatches as AIRecords on the product.

Where to go next

The same modelling approach powers the CRM and invoicing walkthroughs — pick any business process and it is usually just a few partitions and an automation.