Scenario:
The user noticed that there are several journals which has the same document numbers.
Duplicate Journal Entry numbers can occur if two users create entries simultaneously and don’t change the pre-filled number. To replicate:
- Open two Journal Entry forms (e.g., right-click twice from Transactions > Financial > Make Journal Entries)
- Both forms will have the same Entry No. (e.g., JOURNAL-001)
- Fill out both forms
- Save the first – it will save as JOURNAL-001
- Save the second – a Duplicate Number warning appears
- Clicking Leave allows saving with the same number (not recommended)
To check if manual override of Journal Entry numbers is enabled:
- Go to Setup > Company > Auto-Generated Numbers
- Open the Document Numbers tab
- Locate Journal and check if Allow Override is checked
When Allow Override is enabled, the Entry No. field is editable during Journal Entry creation.
To confirm:
- Go to Transactions > Financial > Make Journal Entries
- Observe that the Entry No. field is editable
If Allow Override is unchecked, the field displays To Be Generated and cannot be edited
Solution:
Option 1: Disable Manual Override
- Go to Setup > Company > Auto-Generated Numbers
- Open the Document Numbers tab
- Find Journal, uncheck Allow Override, and click Save
Option 2: Enable Duplicate Number Warnings
- Navigate to Setup > Accounting > Accounting Preferences
- Open the Items/Transactions tab
- Set Duplicate Number Warnings to Warn and Block
- Click Save
This setting forces users to enter a unique number before saving a record with a duplicate.
Hope this helped!