I’m building out a base to track plant inventory in a nursery.
The way it should work is I receive plant material, and assign values to several fields in a Table called “Receiving”
Once the material is added to the system, an automation adds it to my main “Nursery Inventory” Table
Here’s where I’m stuck.
Let’s say I order 500 seeds, I plant 100 of them, 98 of them sprout. then they go into “hardening” phase. while in that phase 5 of them get sick and need to be quarantined, another phase.
In the end we sell 97 of the original 100.
I want to record the receipt of the 500 seeds, subtract 100 from that, hold them in a phase/location for a period of time, subtract 5 from that and move them to a “sick phase”, move the remaining 95 to a third location/phase, add 2 back to the 100 in the 3rd phase, and then ultimately record that we sold 94 of the 100.
Then with the remaining 400 seeds, I want to do it all over again.
Basically, I need a way to track my inventory through a series of phases, minding a total “par” that is automatically updated.
All the other inventory bases I’ve seen rely on 2 phases, where the final sale is used to decrease stock levels.
The other issue is that any given species of plant may have multiple entries. I will have started groups of seeds throghout the course of several weeks, this means I can’t just add and subtract from a master “lettuce” item, I have 3/12/21 batch, 3/17/21 batch and so on.
Any suggestions on how to manage this?