Implemented Multiple Units of Measure
As a wholesaler, we buy and sell based items on unit prices, but for shipping we can only buy and sell shippable quantities based on how many units go in a box, or case-pack. So if 10 pans fit in a box, we can only buy and sell in multiples of 10. But we don't negotiate buying or selling prices based on total price of the case, that is done on a unit basis.
Having multiple units of measure, so we can keep track of items, dozens, cases, and pallets all for the same item would greatly aid our ability to sell in quantities that are shippable and keep inventory numbers correctly in check.
Another example that I run into often with specialty food businesses (AKA food manufacturers) is buying ingredients in bulk units such as cases, gallons, barrels, etc. while needing the ingredients in production units, such as grams or lbs.
Currently, many of these businesses use an "auto-disassembly" to do a unit conversion from the purchase unit (e.g, gallons) to the production unit (e.g., grams), which works for purposes of production but definitely has some drawbacks. The drawbacks include low inventory reporting needs to be done in the production unit (e.g., grams) which is often not very intuitive and does not allow for creating purchase orders in the purchase unit. Another drawback with the disassembly solution for unit conversion is that DEAR does not currently automatically copy the batch number from the parent unit to the disassembled unit, thereby losing the batch number uniformity. Best practice in food traceability is to keep the lot number (batch number) the same for ingredients at all times. It is possible with the disassembly to copy the batch number from the parent to the child, but using the auto-disassembly, it means going to the disassembly, undo'ing it, and then copying the batch number and expiry date to the "result" product(s)
So, when considering this new feature, please allow for
One possible design of this might be to have a Units tab for a product, with a table which defines the unit conversions. This table would have a set of quantity and unit on one side with an equal sign and a quantity and unit on the other side. For example, 1 kg = 1000 grams. Another example 1 lbs = 453.592 grams. I personally do not think you need to pre-define the conversions as leaving it to individuals to define will allow for flexibility and creativity. The unit labels (lbs, kg, cases, gallons, each, etc.) would still be defined b the individual subscription.
2 people like this
Awesome stuff thanks DEAR
Another thing to consider with this is also adding a barcode for each UOM. Often we have a barcode for the case, pack and each. So if each unit of measure had a barcode when receiving is done the case would be scanned and know how many have been received. This would make receiving a faster process.
A few additional requirements and thoughts:
Hi DEAR Support,
Can we ask for update on Multiple Units of Measure please?
Thank you.
Hi DEAR Support,
When this feature will be available?
It's really surprising for a inventory ERP that you haven’t this feature,
An answer will be highly appreciated
Thanks
Sorry, I just found it in your documentation,
http://support.dearsystems.com/support/solutions/articles/11000041299-additional-units-of-measure
You can use SAP Business one ERP, Smart companies will always do their best to improve customer retention rates if they want to remain efficient and continue growing consistently year to year. ERP software is central to improving customer retention rates. It’s for that reason that the ERP market size is expected to exceed $49.5 billion by 2024.