Lines on transactions require a join in suiteql, you need to get line info from

transactionlines.custcoletc

thanks Sandii, what about in the query? transactionJoin.createColumn({                     fieldId: "custcol_ihm_order_price"                 }),

change fieldId to transactionlines.custcol_

thanks.