Avoiding Duplicate Numbering on allowing override of Auto generated Document numbers.

Overriding preferences in NetSuite:

we can allow overriding the auto-generated transaction number on Setup > Company > Auto-Generated Numbers > Document Numbers > Allow Override.

The main issue raised on overriding the document number is Duplicate Numbering.

Scenario:

Duplicate numbering happens on the following scenarios:

a. When users creates a same transaction (e.g. Invoice), and the Duplicate Number Warnings preferencefrom Home > Set Preferences > Transactions > Warnings > Duplicate Number Warnings checkbox is set to No Warnings.

b.When users creates a same transaction (e.g. Invoice), and the Duplicate Number Warnings preferencefrom Home > Set Preferences > Transactions > Warnings > Duplicate Number Warnings checkbox is set to Warn but the user had previously marked and saved the Do not Show This Warning Again checkbox on Duplicate Number warning message page.

Solution

As a solution to avoid generating duplicate auto-generated numbers on transactions when Allow Override on Auto-Generated Numbers preference is True, follow the steps below:

1. Administrator Role: Navigate to Setup > Accounting > Accounting Preferences > Items/Transactions > Other Transaction Preferences
   
2. Duplicate Number Warnings:Set the Duplicate Number Warnings field to Warn 
   
3. Click Save
   
4. Administrator role: Navigate to Setup > Company > General Preferences > Overriding Preferences tab 
   
5. Duplicate Number Warnings:Unmark Allow Override column for Duplicate Number Warnings
   
6. Click Save