Calculate total nett weight of Order/Shipment based on individual weights of Items

Hi,


Just got an idea, that since we can add custom fields wouldn’t it be helpful if we add a custom field in item master as the nett weight of the item and with this nett weight called into the SO or DN would then calculate the total weight of the SO or DN.

Now the only problem is that I can call the weight field from an item into the SO or DN but I would like to know how to enter the total weight of the SO which would be total quantity * weight of individual item. Even though the calculation is simple the problem is with the calculation only as to how should I go about it.

This feature would greatly help us as a shipping manager as to through which courier should the shipment go.

still waiting for a response?

1 Like

Hi,


I am still looking for a resolution to this problem. Let me explain my situation clearly here. We book orders for items with item codes now the problem is that the shipping charges are almost always dependent upon weight in our case (since the material we sell is heavy in others case it could be the shipping charges are based on volume). Now the problem is that people entering the SO have no idea as to what would be the total weight of the shipment. Now to resolve this issue I am planning:

  • To add a custom field in Item Master as net weight
  • Now whenever that item code is called in a SO the net weight would be fetched in the SO details with the help of a code which is available on this forum through the custom script
  • Now suppose Item A’s net weight is 100 gm per pc then if we receive an order for 100 Nos of A so the total weight would be like 100x100 = 10,000 gms or 10 kgs which would give the person entering the data a good idea about the charges for shipping.
  • Now I am unable to find a code to do the MATH of QTY*NET WEIGHT in custom script (Is this Possible?)

Hi Aditya,

We have complete functionality to make packing slips out of delivery
note.

Check packing slip option in Stock >> Packing slip. Also check option
to push delivery note item into packing slip in submitted delivery
notes.

How packing slip works:

  1. Mention net weight and weight uom in item master (in inventory
    section).
  2. When submitted delivery note pulled into packing slip, it will pull
    net weight and weight uom from item master.
  3. Items net weight * quantity gives you packing slips net weight.
  4. Also, you will find option to define gross weight and gross weight
    uom in packing slip.
    Gross weight will consider packing material weight also. And
    cartoon box, container etc. can be considered as gross weight uom.

Hope this helps.

Regards,
Umair Sayyed

On Feb 17, 7:13 am, Aditya Duggal ad...@rigpl.com wrote:

Hi,

I am still looking for a resolution to this problem. Let me explain my
situation clearly here. We book orders for items with item codes now the
problem is that the shipping charges are almost always dependent upon
weight in our case (since the material we sell is heavy in others case it
could be the shipping charges are based on volume). Now the problem is that
people entering the SO have no idea as to what would be the total weight of
the shipment. Now to resolve this issue I am planning:

  • To add a custom field in Item Master as net weight
  • Now whenever that item code is called in a SO the net weight would be
    fetched in the SO details with the help of a code which is available on
    this forum through the custom script
  • Now suppose Item A’s net weight is 100 gm per pc then if we receive an
    order for 100 Nos of A so the total weight would be like 100x100 = 10,000
    gms or 10 kgs which would give the person entering the data a good idea
    about the charges for shipping.
  • Now I am unable to find a code to do the MATH of QTY*NET WEIGHT in
    custom script (Is this Possible?)

Hi, how can I enable to create packign slip from submited delivery notes?
And I hava another question. I need a report, that would tell me a weight of delivered items over some specific period. Is this report possible?

thank you

Milan