Cannot add any invoice anymore after created a Crédit Note

[Cirillo007]

Bug

After having created a crédit note for a invoice (or also for a supplier invoice), the System bugs whioe creating new invoice
While doing UPDATE llx_facture SET ref = 'FC000001', fk_statut = 1, fk_user_valid = 20, date_valid = '2024-05-13 20:09:35' WHERE rowid = 236
Il says Duplicate entry 'FC000001-1' for key 'uk_facture_ref'
It has loosen the numering séquence and started again from My beginning #1 invoice that already exists.

Dolibarr Version

19.0.2

Environment PHP

8.0.3

Environment Database

Mysqli

Steps to reproduce the behavior and expected behavior

Creating a credit note will reproduce the error.

Attached files

No response

[Cirillo007]

Dolibarr loses the invoice numbering after inserting credit note or advanced paiement invoice also.

After having given this number for my advanced paiement FCAv001, then Dolibarr loses the last invoice (193) and tries to insert an new invoice with number FC000001 that is already present.

Date: 20240528094003
Dolibarr: 19.0.2 - https://www.dolibarr.org
Niveau de fonctionnalités: 1
PHP: 8.0.30
Server: Apache
OS: Linux s24671886 4.19.0-17-amd64 #1 SMP Debian 4.19.194-2 (2021-06-21) x86_64
User Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/17.5 Safari/605.1.15

Url sollicitée: /compta/facture/card.php?facid=278&action=confirm_valid&confirm=yes&token=2a40f65226c5af39596cdeeeb6f79347
Referer: https://totoestbeau.vif-group.com/
Gestionnaire de menu: eldy_menu.php

Modules/Applications: syslog, user, twofactorauth, memcached, multicompany, removeconf, fastupload, accounting, agenda, bom, banque, barcode, cron, commande, ecm, blockedlog, facture, fournisseur, margin, loan, mrp, service, societe, stripe, propal, export, import, fckeditor, expedition, prelevement, supplier_proposal, workstation, autoupgrade, reception, advancedictionaries, paymentbybanktransfer, sirene, product, ficheinter, multicurrency, tax, stock, kanprospects, productbatch, salaries, emailcollector, mailing, projet, bookmark, notification, ship2bill, webhook, geoipmaxmind, categorie, contrat, contacttracking, workflow, invoicetracking
Type gestionnaire de base de données: mysqli
Requête dernier accès en base en erreur: UPDATE llx_facture SET ref = 'FC000001', fk_statut = 1, fk_user_valid = 20, date_valid = '2024-05-28 09:40:03' WHERE rowid = 278
Code retour dernier accès en base en erreur: DB_ERROR_RECORD_ALREADY_EXISTS
Information sur le dernier accès en base en erreur: Duplicate entry 'FC000001-1' for key 'uk_facture_ref'