Any user with the Accounting Preferences permission can set up an account so that all users are alerted or blocked from proceeding when they attempt to save transaction records with duplicate document numbers.
If you import transactions and use the Advanced Numbering feature, NetSuite responds to duplicates according to these settings. If you import transactions and use the Advanced Numbering feature, NetSuite responds to duplicates according to these settings. When you import a transaction, NetSuite determines which advanced numbering rule applies to it using your rules' criteria. It then checks if a transaction with the same document numbers already exist for the same rule. If a duplicate is detected, NetSuite uses your Duplicate Number Warnings preference as described below.
To enable these warnings, go to Setup > Accounting > Preferences > Accounting Preferences. On the Items/Transactions subtab in the Other Transaction Preferences section, select one of the following Duplicate Number Warnings from the list:
-
No Warnings – Users are not warned when the transaction they are saving will create a duplicate document number.
If you import transactions and use Advanced Numbering, NetSuite does not warn you when the imported transactions use duplicate document numbers and imports all transactions.
-
Warn (UI only) – Users receive a message when attempting to save a transaction record with the same document number as another record of the same type. When the warning is displayed, a user can enter a different number before attempting to save again.
If you import transactions and use Advanced Numbering, NetSuite does not warn you when the imported transactions use duplicate document numbers and imports all transactions.
-
Warn and Block - Users receive a message when attempting to save a transaction record with the same number as another record of the same type. When the warning is displayed, the user must click Cancel and change the document number in the record. This option affects the following transaction types:
-
Vendor bills
-
Vendor credits
-
Card charges
-
Card refunds
-
Custom purchase transactions
If you import transactions and use Advanced Numbering, NetSuite warns you when imported transactions create duplicate document numbers, and does not import these transactions.
-
Important: On a transaction, use caution when you click the Submit button. If you click Submit more than one time, multiple transactions may be created.