Hi Everyone, I’m looking to do a SuiteScript 2.0 search against the inventory number table. No issues with that however I’d like to add a column that links to the “Inventory Number Bin” table and shows the bin number. Basically, I’m doing a Serial Number lookup and trying to find out what bin it is currently in. The Inventory Number Bin table has a note “Search Join Only” but I’ve not managed to get that working. I tried adding the column using
search.createColumn({'name':'binnumber', join: 'inventorynumberbin'})
but it failed saying the nlObjSearchColumn contained an invalid column join ID or was not in proper syntax. Has anyone done something similar?