Handling Duplicate Invoices with Identical Reference Numbers in Zoho

I've recently encountered an unexpected behavior within Zoho that allows the creation of multiple invoices with identical reference numbers and order numbers. This situation is quite surprising, as it could potentially lead to significant confusion in financial tracking and reporting. The ability to create duplicate invoices without any system alerts or validation checks against existing reference numbers raises concerns about data integrity and accuracy in financial records.

In the last two months, we've encountered an issue where, out of 123 orders, one specific order has been duplicated thrice, while the remaining orders have each been duplicated twice.

Has anyone else experienced this issue within their Zoho account? Are there any recommended practices or settings within Zoho that can help prevent the creation of such duplicate entries? Insights or solutions to ensure each invoice maintains a unique identifier would be highly appreciated. This would not only aid in maintaining cleaner records but also in enforcing stricter data validation within the platform.

Looking forward to the community's advice and suggestions on this matter.