Marty Zigman

Conversations with Marty Zigman

Certified Administrator • ERP • SuiteCloud

Marty Zigman LinkedIn

Marty Zigman

Holding all three official certifications, Marty is regarded as the top NetSuite expert and leads a team of senior professionals at Prolecto Resources, Inc.. He is a former Deloitte & Touche CPA and has held CTO roles. For over 30 years, Marty has produced leadership in ERP, CRM, and eCommerce business systems. Contact Marty to set up a conversation.

BiographyYouTubeLinkedInX (Twitter)

54 thoughts on “Showing NetSuite Internal IDs and Field Names

  1. Marty Zigman says:

    I find that using internal IDs is much more reliable. I tend to think in these database terms all the time and I am generally nervous when we don’t have internal IDs in CSV imports (that’s just me). I suspect you are doing this but are you careful to change the options to make sure the name is being used for reference in the upload?

  2. Santosh says:

    Thanks Marty for the reply. The team is currently using Name so the upload has ‘Name’ reference selected. We discussed about using internal ID and accounting pushed back on the idea as there is more room for error without seeing the actual name of the customer/vendor being used. For the short term we decided to rename some of the vendor names that are similar to customer names with a ‘(vendor)’ prefix at the end.

  3. Nora Leinen says:

    How can I show the internal ID of the component line in the BOM revisions when using advanced BOMs? I’m not talking about the internal ID of the component item. I’m talking about the internal ID of the component line itself. I need to show the internal ID on the form so I can do one line component substitutions/replacements easily by mapping to that particular component line.

  4. Marty Zigman says:

    Hi Nora,

    It doesn’t appear you can do this out of the box. But our Query Renderer Tool can get this going for you. See this article:
    https://blog.prolecto.com/2022/08/13/get-license-free-tools-to-link-netsuite-saved-search-sql-to-extend-data-reach/

    We effectively can create another tab that will render the BOM revision with any data you need.

    Marty

Leave a Reply

Your email address will not be published. Required fields are marked *