I am about to replace the employee nos. with a new number.
I plan to rename the present employee nos. as old employee nos. and have the new as employee nos. and map the old nos. with the new nos and the new nos. become the primary key.
but i have this present nos which are going to be changed to old referenced in some tables like the absence registration table, employee relative. I know when the primary key is changed, it will also change in all tables its referencing to. It this true?
How will this affect those table?
Any advice on how to go about with this?
Thanks
0
Comments
Check out the RENAME function in the Help.
AP Commerce, Inc. = where I work
Getting Started with Dynamics NAV 2013 Application Development = my book
Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book
Am still seeking for advices
Thanks
For a quick respone, try the chat function on Mibuso.com.
Maybe there is an developer online and its free!
Bart van Beek
Boltrics Professionals B.V. | www.boltrics.nl
Nekovri Dynamics | 3PL Dynamics
You'll need to find a cut off point where you can do this transition. Either that or you will need to create 2 sets of numbers and manually merge the ledger entries together.
AP Commerce, Inc. = where I work
Getting Started with Dynamics NAV 2013 Application Development = my book
Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book
Somewhere in the code for payments (I suppose T81), you can create a new field that is used instead of the old one. This new field checks if the number exists and then it just transfers to the original field. If it doesn't exist, it must check the old numbers and if it finds it, transfer the new number for that old number in the original field.
I have done that ones for the customer-nos that were renamed, and it works without problems.
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!
May i see the code please?
Thanks
"New Employee No. Field"-OnValidate-trigger
This new field ("New Employee No. Field"), you should put on the form and hide the old one. The users must use the new field.
If you have some procedure that imports the employee no., you need to validate the new field and NOT the original one in the table.
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!
Thanks
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!
What is the problem?
Thanks
Another possibility is that by renaming the employee number, Navision also renames the field in other tables and in one of those other tables (one in which employee-number is in the primary key) this creates a double.
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!