Empty database table, but counting previously deleted things

Hello bubblers,

I tried to debug my issue and look on this forum + google search for more than 1 hour.

I’ll get right to the point, when I create a new invoice (thing), my workflow is supposed to generate an invoice number (ie : 000001) by counting the invoices (things) and add +1.

My issue is that the app is seeing deleted invoices. I mean, there is litteraly zero invoice (thing) in my table “Invoices”, but the app counts what has been deleted.

I can visually see, when I load the page the count of previously deleted invoices for a fraction of a second (ie : 4), then it changes back to the real amount.

So It will create the invoice number 000001 then change it to 000005. If I delete this invoice, it will do the same but write the invoice number 000006 and on and on…

Here some screenshots :





I really have no idea how this is possible, I checked my workflows, my database and deleted everything multiple times, but it is still an issue.

It doesn’t seem to replicate the issue for other Data Types. Only for invoices.

I would appreciate yor help. It’s a mistery to me…

Cheers and thank you in advance.

Benjamin

This topic was automatically closed after 14 days. New replies are no longer allowed.