I'm trying to show the base units of the item as a column in a saved search? For example, if the units type of the item is "weight", the column should show "kg" as base unit even though some transactions are in grams. Tried all fields related to item and unit but no avail.

I guess it depends of what kind of record are you searching with the saved search. If you’re looking for bills, for example, and want the items units type, then it should be Item Fields at the end of the dropdown list. If you’re searching for items, then you just need to know the label of the field (for example, Primary Units Type). In any case, I’d advice you to add the plug-in for Chrome ‘Netsuite Field Explorer’ (https://chrome.google.com/webstore/detail/netsuite-field-explorer/cekalaapeajnlhphgdpmngmollojdfnd?hl=en). In any record it allows you to see the list of body and line fields with their internal ids and their assigned values, and I find it helpful when designing saved searches. Hope this helps!

The saved search is a transaction search trying to show item movements like item receipts / item sales / item transfers. The transaction units may differ. For example, an item can be received in 20kg boxes, and sold per kilogram. So we made a search of all these transactions but we also made a column for transaction quantity in base units (to easily account using one unit of measure), but I'm not sure where to get the base unit.

I’m not 100% sure I understand your process, but it looks to me that you’re going to have to print the 2nd unit column with a Formula(text) with a CASE WHEN in which you create conditions for each of the quantity field options you have and, thus, print the corresponding unit