Inventory and stock

For a workshop, a shop or a facilities department. Every incoming or outgoing item is a movement; each item’s stock is their sum, its value a formula, and items below their threshold appear in the “À commander” (to order) view. The AI writes each item’s description from its name and category.

3 tables

Items 5 sample rows

• Name Short text
• SKU Short text
• Category Single select
• Unit Single select
• Reorder threshold Number
• Unit price Number
• Stock Rollup
• To reorder Formula
• Stock value Formula
• ✦ Description Long text
• Supplier → Suppliers

Name	SKU	Category	Unit	Reorder threshold
27-inch monitor	3760001000011	Equipment	piece	2
Ream of letter-size paper	3760001000028	Consumable	carton	10
Ergonomic office chair	3760001000035	Furniture	piece	1

Movements 8 sample rows

• Label Short text
• Date Date
• Type Single select
• Quantity Number
• Comment Long text
• Item → Items

Label	Date	Type	Quantity	Comment
TechGear Supply order received	9/19/2026	In	6
New hire workstations	9/29/2026	Out	-3
Monthly paper order	9/24/2026	In	12

Suppliers 3 sample rows

• Name Short text
• Contact Short text
• Email Email
• Phone Short text
• Lead time (days) Number
• Items Count
• Order Button

Name	Contact	Email	Phone	Lead time (days)
Summit Office Supply	Michelle	orders@summitoffice.example	(415) 555-0123	3
Central Packaging Co.	Patrick	contact@centralpackaging.example		7
TechGear Supply		sales@techgearsupply.example		5

What the AI computes

• Items › Description

  Write a neutral two-sentence description for this item in the "{{Category}}" category, sold by the "{{Unit}}": {{Name}}.