Resources for IT Professionals >
Dynamics Forums
>
GP
>
Great Plains is creating duplicate keys....can we avoid this?
Great Plains is creating duplicate keys....can we avoid this?
- We have 4 companies defined in GP, which means we have 4 unique databases with unique key generation routines.
The key generation routine builds the key as the first 5 characters of the company name and a 4 digit sequence.
We have two companies in two different companies of ours with the same 5 characters in the company name. Since the companies are in different databases the keygen is coming up with duplicate keys. With our synchronization back to CRM this cause the first company to have it's name changed to the second company name. (not good.)
We would like to alter the key generation so that the company prefix is added to the end of the key. Thus in the previous example we'd get compa0001phx and compa0001sct which would avoid the duplicate key issue.
My questions:
1) Can I do this and how do I change the keygen algorithm?
2) Would there be an impact for existing accounts to change the keygen algorithm?
I'd appreciate any assistance someone can give me....I'm walking into this as a noobie taking over the companies system work in GP.
Thanks.
BTW -- when I selected Dynamics to post my question I could only post to CRM forums...NOT GP.- Moved byDonna EdwardsMVPFriday, October 09, 2009 11:08 PM (From:CRM)
