My Stuff
Nominate Your Peers for NetSuite Support Community's Choice of the Quarter! Submit your nomination today.
Intelligent Payment Automation version 1.0.3 is now available in the SuiteApp Marketplace. The SuiteApp, powered by BILL, lets you automate payments, manage vendor details, and bank account information within NetSuite. Learn more
No Limits. Just possibilities.
Join us for complimentary one-day events around the world and step into a future fueled by AI and limitless potential. Explore new breakthroughs, sharpen your skills, and connect with experts who are shaping what’s next. Experience bold keynotes, interactive learning, and connections that span the global NetSuite community. Discover what's next at SuiteConnect Tour 2026.
Join us for complimentary one-day events around the world and step into a future fueled by AI and limitless potential. Explore new breakthroughs, sharpen your skills, and connect with experts who are shaping what’s next. Experience bold keynotes, interactive learning, and connections that span the global NetSuite community. Discover what's next at SuiteConnect Tour 2026.
Comments
-
HI - thanks for the reply, at least I know the bug (enhancement!) is being tracked. Attendee isn't a field in that table, and response seems to be the only field that is has differences between duplicates. I'll use select distinct over all columns except response for now - I need all fields and I need to remove duplicates.
-
Thanks for the reply, listing just the IDs isn't what I want. I'm happy with my own findings - that entityStatus is equivalent to COMPANY_STATUS If this is categorically not the case, please do let me know.
-
There's no opportunity entity, but there is an entity opportunitiesAndEstimates which has the relevant fields denormalized for transaction of type Estimate / Opprtnty. Right now I'm just trying to create a set of views that look enough like netsuite.com to provide continuity on our reporting - so I think I've got what I…
-
It's TRANSACTIONS.COMPANY_STATUS_ID field, which used to be the FK to COMPANY_STATUS record on COMPANY_STATUS_ID in netsuite.com - as per the spreadsheet row I pasted. It looks like the notation in the spreadsheet "opportunity^transaction.entitystatus" is trying to say transaction.entitystatus → entitystatus.key for…