ANS-0476 · CUSTOM FIELDS, RECORDS & FORMS
Can NetSuite Transactions Share Identical Reference Numbers?
Understand how NetSuite handles duplicate values for transaction ID and other reference numbers across various records.
Short answer
Yes, NetSuite transactions can have identical 'otherrefnumber' field values, as it is a free-form field. However, while 'tranid' values are generally unique, duplicate transaction IDs can occur under specific circumstances, such as when 'Allow Override' is enabled for auto-generated numbering or during concurrent transaction creation. Best practices recommend ensuring uniqueness for critical identifiers.
Scenario
Users often inquire about the uniqueness constraints of transaction identification fields within NetSuite. Specifically, there is a common question regarding whether the 'otherrefnumber' and 'tranid' fields can contain identical values across different transactions, which impacts data integrity and reporting.
Solution
NetSuite allows transactions to share identical values in the 'otherrefnumber' field. This field is designed as a free-form reference and does not enforce uniqueness by default, making it suitable for external reference numbers that may not always be unique across different systems or transactions.
However, the 'tranid' field, which represents the primary transaction ID, generally aims for uniqueness. While NetSuite typically prevents duplicate 'tranid' values, it is important to note that duplicate transaction IDs can occur under specific circumstances. These situations may include:n* When the 'Allow Override' option is enabled for auto-generated numbering sequences.n* During concurrent transaction creation processes where system timing might lead to temporary overlaps before final assignment.
To maintain data integrity and ensure reliable identification, it is recommended to implement proper controls and configurations to prevent duplicate 'tranid' values, especially for critical business processes.
Expert NetSuite Support
Need help with this NetSuite issue?
Custom Fields, Records & Forms consulting and configuration support