Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Please note that on Saturday, April 11, 2026, at 8:00 PM Pacific time, our Case Management System will undergo a scheduled maintenance for approximately 30 minutes. During this time, case creation via SuiteAnswers will be unavailable and inbound calls will be routed to Customer Service.
Shipto link in Purchase Order
Does anyone know what table shipto links to in order to get the Customer Name when searching for purchaseorder records. If I search the Purchase Order table and use shipto, it returns what looks like the Customer ID. However, when I try to use a join it to the Customer table to pull the lastname or anything from the Customer table, it just shows up blank. Also tried to join to the Entity table but no luck there either.
list.addColumn('shipto','text', 'Customer', 'left');
returncols[x] = new nlobjSearchColumn('shipto'); //returns the customerid or customer table internalid
list.addColumn('lastname_customer','text', 'Customer', 'left');
0