I'm encountering a challenge in our NetSuite setup regarding how vendor names are captured across different transaction types, specifically between invoices and journal entries (JEs). In our current configuration, invoice transactions capture vendor names in the "Name" field, while JEs record them in the "Entity" field. This inconsistency has led to complications with external integrations, where a unified approach to vendor name data would significantly streamline reporting and analysis. I'm curious about how others approach this issue. Is it feasible or advisable to configure NetSuite so that all vendor-related transactions populate the "Name" field consistently, regardless of whether it's a JE or an invoice? I'm conscious that overriding native field behaviors might not be best practice. Would creating a custom field, or perhaps reworking our reporting methodology, be a better approach? Any insights, best practices, or advice on how to navigate this for improved consistency and efficiency in reporting would be greatly appreciated. How do you ensure consistency in vendor data across different transaction types in your setup?

Note that in JE line level "Entity" field is there by design - it encompasses all the entity type not limited to just vendor; also customer, partner, contact, employee etc. Also all the P2P transaction's "Vendor" field is actually "Entity" field - just lookup the field ID by clicking the field help link. See below

What type of report do you use ? If it’s saved search use formula like case when {type} = ‘journal’ then {entity} else {name} end

Thank you @Sam-I-Am, and @Marc - much appreciated. Super helpful 🙂