https://netsuiteprofessionals.com logo
Join Slack
Powered by
Hello, is there a way to show item total weight in...
# suitescript
c
Hello, is there a way to show item total weight in base units in sales order line item? Ex: I have an item who unit type is gm but base unit is kg, in line item can I see 1kg if user enters 1000 quantity ? I tried adding weight as transaction line item, but is not showing any value. Any suggestions please?
b
i believe unit type and weight are different things
however the weight field of the item refers to the weight of the item in sales units
to calculate weight, you would take the quantity, convert it to base units, then convert it to sale units then multiply by weight
if you make an arbitrary restriction to only sell in sale units, the calculation should be pretty easy
c
Thanks @battk. Weight is showing as empty always for me. I will recheck. To convert to base units, we need to get conversation rate right? How can we get that.
How can we restrict to sell In sales units please?
b
weight is an item field, make sure it has a value
if you are looking for a restriction in the ui, the easiest way is to hide the units field on the form
c
Ok got it. If we hide units field it will always be in sale units of that item.
But here we need something like aggregated weight. Suppose sales order has 4 different items and if we need to get aggregated weight of all 4 we need to convert them to common base unit.
b
use suitescript
c
So I thought If we can add transaction line field with that calculation, we can aggregate easily.
b
although thats generally assumed in the suitescript channel
c
Yes @battk, once we have that field we can use suitscript to calculate aggregated. This was one thought. Thanks once again.
b
you can do things like a saved search field if you only want it in the ui, but i generally find its too much work for a field with so many limits
7 Views
Open in Slack
PreviousNext
Powered by