Notifications
Announcements
No record found.
*This post is locked for comments
Hi Ekaterina,
I'd recommend a plug-in that runs on create of new opportunities. The plug-in can get the current year, month. The plug-in will also have to query and count then number of opportunities created 'this month' or better yet, count opportunities that have an ID like 'yy-mm-%'. Then increment by one and you have your next one.
Recently it become more popular to use SQL update approach http://blogs.msdn.com/crm/archive/2008/05/13/auto-numbers-in-microsoft-dynamics-crm.aspx
But as for me - it's not the best way cause it's unsupported...
In our company we have used approach that make use of separate custom entity that holds values http://weblogs.asp.net/gayanperera/archive/2008/10/23/crm-4-incremental-numbering-for-any-entity.aspx
We have used it for auto-numbering of a custom entity similar to "Invoice", hence we had to have UNIQUE numbers (that is possible only within the second approach)
Hope this helps.
Vigo Vorasvigo(dot)voras(at)gmail(dot)comCRM MCP"I can still remember how it was with 1.2 ..."
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 Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
SA-08121319-0 4
Calum MacFarlane 4
Alex Fun Wei Jie 2
