I have a custom column in sales order that displays the exchange rate for that item based on the currency of the vendor. My issue is that the exchange rate is displaying as x.xx since I am forced to use that field type when sourcing the exchange rate for a currency field. I did find this SA - https://netsuite.custhelp.com/app/answers/detail/a_id/35925/kw/exchange%20rate%20decimal but am stuck on what the transactionparentfield is and what I should put there. Any idea what should go there?

as it is said in the SA-article, set the type of your custom column field as "Decimal Number", then use the formula(in sourcing tab) to source the field(casting it with TO_NUMBER(...), just as in the article - you refer the sourced field, in the formula - in your case, the vendor currency, which is in a field of the vendor-record)

Thanks. I got it to "work" but have another issue. I am using this on line items and if I am using different vendors with different currencies the field is defaulting to the first currency I selected instead of the 1 on the line item I am working on.

you might need a scripted customization, then.

yeah - was on the phone with NS Support about this and they are investigating. all else fails will script this but was trying to avoid doing this.