How to retrieve picked quantity for each of the item line in transfer order/sales order using Suitescript 2.0?

Question

One of the columns in item list is "Picked" which is a picked quantity for the item line. But, I cannot find its field name. Then, I try to use the following coding to retrieve picked quantity (quantitypicked) of an item line from Transfer order / Sales Order. But, didn't success as Netsuite returns an undefined value. The method of counting fulfilled quantity in item fulfilment cannot be used as user may input an item in two different item lines.

                             var tranrec = record.load({
                                 type: fnRecType, 
                                 id: fnId, 
                                 isDynamic: true,
                             });

                                 tranrec.selectLine({
                                     "sublistId": "item",
                                     "line": 0
                                 });

                                 var ItemPickedQty = tranrec.getCurrentSublistValue({
                                    sublistId: "item",
                                    fieldId: "quantitypicked"
                                }); 

Answer 1

I certainly use 'quantitypicked' and 'quantitypacked' to count items that are on item fulfillments but not yet shipped.

Does your account have PICKPACKSHIP enabled? Otherwise you can use 'quantityfulfilled'

All of these are from the Sales Order/Transfer Order point of view.

Note that you can step through the lines of an item fulfillment and relate that back to the original sales order. There is an undocumented field 'orderline' on item fulfillments' line sublist.

Answer 2

To get picked quantity, fieldId id 'quantityfulfilled' In dynamic mode try using:

var ItemPickedQty = tranrec.getCurrentSublistValue({
  sublistId: "item",
  fieldId: "quantityfulfilled"
}); 

In non dynamic mode you could use the below

var ItemPickedQty = tranrec.getSublistValue({
  sublistId: "item",
  fieldId: "quantityfulfilled",
  line: 0 // line#
});