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:
- Go to Setup, General Parameters, sequence number definition, Assignment GESTCA ,
- Select Sales, make a note of the Seq.Counter for credit note (INSC)
- Go to Development, Utilities, Miscellaneous, Sequence number values (MODCPT),
- Enter the Sequence counter from the previous step (INSC)
- Increase the Next value by 1, save changes and try creating the sales credit note.