Hello!
I'm trying to create a custom column in POs but I'm not sure if I'm overcomplicating myself. :P
I'm basically trying to create a column that will show total quantity per piece. For example, if you are buying 2 cases of beer, where the unit type for beers is EACH and each case has 12 beers, then I want my column to show 24 total beers.
I'm trying to do this using SuiteScript using fieldChanged, so that the value updates whenever you change the quantity of the item, but I'm not quite sure how to access the unit type, so that I can get the conversion value.
We currently have two unit types, where in each, each row has its own internal ID. Comparing the two unit types, the internal IDs seem to be unique for each line. I'm not quite sure how to access these, is it a record for each type name, and then each type name has a sublist of unit types? I'm basically just trying to find the conversion base so i can multiply quantity * conversion base = total quantity per item.
Thanks!
