Chemical inventory management
K
Kurt Grelle
Roy: I think we discussed this earlier on but it has come up a few time since when talking to prospects.
they need somewhere to record the batch number for chemicals used... this is important because occasionally chemical manufacturers get a batch wrong and the users need to be able to track back to find out which jobs they used that batch on. It will likely be more simple to just add this as a field on the job form rather than linking it back to the chemical (as this would require the chemical to be updated every time they start using a new batch - which would be very often).
Also need to consider:
expiry dates for batches if moving into inventory management capabilities.
stock locations for inventory as there are regulations they need to comply with in storing chemicals
K
Kurt Grelle
Jaeger Josh: Yes, we could do that and I think the option for an org admin toggling it could be a good idea. Here are my thoughts/questions:
- If the org admin has toggled it on presumably this means that is required when creating the job? We'd have to develop some new functionality to support this, but mightn't be too difficult.
- I think to be able to support your last point (that you should be able to look up associated jobs for a batch) that behind the scenes we would still have to update the Chemical otherwise every time the Chemical page is loaded we'd have to process the whole data base again to find what the batches are and then merge them together to find which jobs are associated with each batch.
K
Kurt Grelle
Roy: Could this one be a field on the job form that could be turned on/off by org administrator?
- It would need to pull a 'batch No' for each chemical in the recipe once the recipe is selected.
- don't have it tied back to the actual chemical setup page (this way the chemical wont need to be updated each time a new batch is started)
- the 'batch no' field could be an option field that actually behaves more like a tagging
- if you then go to the actual chemical in the chemical page it could show a list of batch numbers and if you click on a batch number it would then show a list of associated jobs.