Record already exists, Transaction stopped error when creating Sales credit note

Issue: When creating Sales credit note, you get the error below:

2 3 (Error) : Table : CPTANALIN [CAL] Key : SID 0 SINNABXXXXXXXXXXXXXX Record already exists Transaction stopped 3 3 (Error) : 3Table : CPTANALIN [CAL] Key : SID 0 SINNABXXXXXXXXXXX

Solution Steps:

Increase the next value by 1 on Sequence number values:

  1. Go to Setup, General Parameters, sequence number definition, Assignment GESTCA ,
  2. Select Sales, make a note of the Seq.Counter for credit note (INSC)
  3. Go to Development, Utilities, Miscellaneous, Sequence number values (MODCPT),
  4. Enter the Sequence counter from the previous step (INSC)
  5. Increase the Next value by 1, save changes and try creating the sales credit note.