how to automaatically update the sequence of the document numbers if we have duplicate JE number without reversing the JEs without script

AI generated answer (using internal Slack threads):

Based on the conversations, it seems that there is no direct way to automatically update the sequence of the document numbers if you have duplicate JE numbers without reversing the JEs and without using a script. However, there are a few workarounds that you can consider: 1. You can turn off automatic numbering and create a script that will generate the transaction numbers in the way you want it. However, this approach might not be feasible if you need auto-generated numbers for other transaction types. 2. You can use the 'allow override' feature for the document numbers and create a script to generate these. However, this could be a complex task and might lead to issues if you have lots of concurrent transaction creation. A safer alternative could be to use your script to populate a custom field. 3. You can tweak the setup to manually update the 'suffix' at the end of every accounting period and reset the 'initial number' at the same time. This approach would require manual intervention at the end of every accounting period. Please note that these are workarounds and might not be the perfect solution for your use case. You might need to consider the pros and cons of each approach and choose the one that best fits your requirements. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******