Hi,
I need to have varying pricing for the various weights of each inventory item. I cannot find how to do this.
My client has for example an item:
Bobs Dog food 2.5kg - $5
Bobs Dog food 3kg - $10
Bobs Dog food 10kg - $30
I really need them to be arranged similar to this by using the weight as the key to the price and stored in the IN_UnitOfMeasure table or some other table that can be joined with it:
Bobs Dog Food = [
2.5kg = $5,
3kg = $10,
10kg = $30
]
I can add the various units of measure no problem for each item, but it does not allow for varying prices for those units.
Is there any way of doing this that can be added, modified and extracted programmatically?
Thank you