The manual field could be your “baseline” stock count. Whenever you do a stock check, you update this field. Then, a second calculated field can take that baseline and subtract orders or other changes automatically. This way, you can keep your physic...