This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

image.png

Hey guys, Does netsuite create mapping tables behind the scenes? This is not a long alias its a table that has a custom record and custom field name slammed together and maps values. I did not create this

Yes, NetSuite does this for multi-select fields I believe

It will allow you to extract the values if multiple selections are made. I use it like this:

`(`
        `SELECT LISTAGG(i.itemid || ' - ' || i.displayname, '<br/>') WITHIN GROUP (ORDER BY i.itemid)`
        `FROM map_CUSTOMRECORD_CARTON_TRANS_custrecord_cf_item map`
        `JOIN item i ON i.id = map.maptwo`
        `WHERE map.mapone = c.id`
    `) AS item_descriptions,`