Following on from the discussions/help from everyone...I have a workable system. Not ideal, but getting there (as in, I'd like to bounce a few more ideas off you all
)
I modeled the system around the real-world transactions. So ...
Lab has a W/O#1 for the PreWeighs. IssueTo materials come from Store. Store then Receives the FinishedProd PreWeighs, and this W/O is closed.
BlendPlant has W/O#2 for the bulkMix (PreWeighs are just a part of that BOM). IssueTo is again from Store. However, once closed, the BlendPlant receives the bulkMix to itself...against W/O #3 (packaging of the bulk into buckets). Once done/closed, Store receives the finished items. They can then be move from Store-warehouse to Shop-warehouse. This is all working OK. I will clean up my notes etc and post a link to them in a few days time.
My question is ...
For the above method, issues are exact to BOM (ie. if recipe needs 7.56kg of flour, that's what gets "issued", and there are no materials returns except for the finished product).
What would be ideal, is if I could issue the actual bag (eg.20kg) and then ...automatically deducting what's used at the BlendPlant ...get back the balance.
Any hints or experience on setting this up?
I have set up the inventory like this ...
eg. flour...units:kg
purchaseData: supplierUnits=20kgBag ConvertFactorToOurUnits=20
and BOMs are simply in kg or each