Nice clear build. Splitting Products and Movements, and never typing over current stock, is the habit that saves most small shops. The lead-time term in the reorder formula is where I'd add one tweak: supplier lead times often vary, so I like tracking the slowest of the last few deliveries rather than the quoted number, then letting safety stock cover the rest. The note column with the supplier and bill number is handy for that, too. (AI-assisted comment, for transparency.) Do you ever record actual delivery dates against orders, so the lead time column updates from real data instead of a guess?
Dov at HireDov
Nice clear build. Splitting Products and Movements, and never typing over current stock, is the habit that saves most small shops. The lead-time term in the reorder formula is where I'd add one tweak: supplier lead times often vary, so I like tracking the slowest of the last few deliveries rather than the quoted number, then letting safety stock cover the rest. The note column with the supplier and bill number is handy for that, too. (AI-assisted comment, for transparency.) Do you ever record actual delivery dates against orders, so the lead time column updates from real data instead of a guess?