Hello,
Does anybody has experience to generate the next number from number sequence which is set as "Manual".
I'm using this approach: https://community.dynamics.com/365/financeandoperations/b/axaptavsme/posts/generate-next-number-sequence-by-x-code
But, it returns empty number if number sequence is Manual.
We need it to be manual, but at the same time, we have some csv upload process, during which the number must be generated from number sequence.
Thanks.
Correct.
Hi,
Manul number sequence is as good as not having a number sequence. so you will not get the next number if it is set to Manual.
As suggested by Nikolaos, you can set up a new number sequence which is automatic and use that.
Another approach might be to update the current number sequence to automatic from Manual, then import and set it back to Manual again using code. I have not tried it myself but you can think about it.
Thanks for suggestion. In that case we would need also a parameter field pointed to the new number sequence to select it from the code right?
Just define a number sequence which is not linked to the id / data type of your table field. And set it to automatic. This way you can fetch numbers from that sequence in code, but it doesn't impact the process where users create records in this table.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Andrés Arias as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
CA Neeraj Kumar 895
Sohaib Cheema 811 User Group Leader
André Arnaud de Cal... 787 Super User 2025 Season 2