This question has been flagged
3 Replies
6246 Views

Hi,

I'm having an issue, which I'm trying to figure it out.

There is a product, I receive it in the warehouse in boxes (Unit), but I also need to set the weight on this receiving.

So I can sell it either in Kg or Box (Unit).

Example:

I bought 10 Boxes of Mango for $ 50, its total weight is 57 Kg.

I want in stock move to receive 10 Unit, and to set also a weight of 57 Kg. So I can see the price of each Kg as ($ 50 / 57 Kg) = $ 0.88

Then when selling the product, I can sell it in Kg (I already have the Kg price), or even sell it in Boxes, and also set the weight of each Box I will sell, so it will calculate the price and Cost based on the Kg not the Unit.

Avatar
Discard
Best Answer

The suggested link provided by Niyas,  solves the problem by setting a conversion rate (equation) between the base UoM and the selling UoM. ( Purchasing in Gallons, and selling in Liters) as both has the same Category (weight). This is done on the product card. So you need to define the boxes within the same family. For example call the purchasing unit Box15, and the base unit KG. which means you will end creating Box5,Box7, Box19,...etc as a new unit of measure in the same category. 
In other software ( like ERPNext and others)  they solved it by allowing the user to add the conversion rate  at the level of the item line on the Sales/purchase order.  This issue is important for businesses working in food industry like fruits and vegetables. May be we can work on a module to solve this issue. 

Avatar
Discard
Best Answer

This can not work from a logical point of view. How do you want to track stock? You'll have to track your Mangos in kg (and/or pieces maybe, if at all) and boxes can only be packages with no UoM functionality (each box has a different weight). So you can only buy your mangos in kg, store them in kg and sell them in kg, no matter if they are packaged in boxes or not.

Avatar
Discard