Seeking Assistance to Prevent Duplicate Values in Numbering

Need help Database
1

Hello fellow forum members,

We are facing a challenge in our multi-tenant SaaS application and are hoping for your expertise to find a solution. In our system, we use sequential numbering for entities such as debtors and invoices. It is crucial that no gaps or duplicate values occur in this numbering.

We have already tried various approaches, including creating a custom queue and freezing the list when generating a new number. However, we continue to encounter the issue that, when users from the same company press the save button simultaneously, duplicate values occur in the numbering.

Has anyone experienced a similar issue or do you have any ideas on how to address this? We are open to suggestions and valuable insights to tackle this challenge.

Thank you in advance for your assistance!

Best regards,
Danny & Jeroen

2
3

Hi cmarchan,

Just wanted to give you a shout-out for the awesome help. Good news – we nailed the issue with those pesky duplicate values in our numbering.

Cheers,
Danny & Jeroen

1 Like