Skip to main content
Solved

Duplicate Reference Number

  • April 28, 2026
  • 5 replies
  • 39 views

zenith59
Freshman I
Forum|alt.badge.img
 

The AR numbering sequence is currently set up to use a single sequence for invoices, credit memos, and debit memos as below;

 

However, upon review, duplicate reference numbers were identified as outlined below:

 

Could you please advise what may be causing these duplicates?

Best answer by Naveen Boga

@zenith59   The shared sequence itself is not the cause, shared sequence simply cannot issue the same number twice under normal operation. The duplicate numbers almost certainly resulted from either manual number entry, data import/migration, or an API integration that bypassed the numbering sequence entirely. Investigating the audit trail and creation method of those specific duplicate documents will reveal the exact cause

5 replies

Naveen Boga
Captain II
Forum|alt.badge.img+20
  • Captain II
  • Answer
  • April 28, 2026

@zenith59   The shared sequence itself is not the cause, shared sequence simply cannot issue the same number twice under normal operation. The duplicate numbers almost certainly resulted from either manual number entry, data import/migration, or an API integration that bypassed the numbering sequence entirely. Investigating the audit trail and creation method of those specific duplicate documents will reveal the exact cause


zenith59
Freshman I
Forum|alt.badge.img
  • Author
  • Freshman I
  • April 28, 2026

Hi ​@Naveen Boga, interesting point. The transactions are created manually, but the reference numbers aren’t, these are generated automatically using a numbering sequence. There’s no API integration or import involved.


Naveen Boga
Captain II
Forum|alt.badge.img+20
  • Captain II
  • April 28, 2026

@zenith59   Could you please confirm whether the duplicate reference numbers are appearing on newly created documents as well, or if this issue is isolated to existing/historical records?

Additionally, it would be helpful if you could review the Audit History for both documents that share the duplicate reference number. Specifically, could you check and confirm the following details for each document:

  • Created By — which user account created the document
  • Created On — the exact date and time of creation
  • Method of Creation — whether it was created manually on screen, via import, or through an API/integration process

This information will help us determine the root cause of the duplication and identify whether it is a systemic issue or an isolated incident tied to a specific creation method or user action.


zenith59
Freshman I
Forum|alt.badge.img
  • Author
  • Freshman I
  • April 28, 2026

@Naveen Boga, yes it happens just last month but this screenshots i provided is way back 2023

 


Naveen Boga
Captain II
Forum|alt.badge.img+20
  • Captain II
  • April 28, 2026

Invoice:         10/07/2023  10:53:04 AM  (But Invoice Doc Date is different 7/07/2023, is this manually updated after creation of Invoice?)  
Credit Memo: 10/07/2023  10:53:16 AM

= 12 SECONDS apart difference between both documents

The most likely cause now is either a return order processed through the Shipments screen or a background automation that triggered Credit Memo creation in that context.  

 

Can you please check the 12/03/2026 orders, is it same scenario?