Asset # - changing them

rj5570
rj5570 Member Posts: 157
edited 2007-07-13 in Navision Attain
right now we have a prefix like MU- or C20- and then our asset number.

i really want to blow those out of there. I was thinking of importing the table into access, remove the prefix and then load the table back into the database.

my question is, will this mess up any linkage from other tables? it looks to me that this wont work, so does anyone else have any other suggestions in how i can remove the prefix.
- So it Goes.

Comments

  • nunomaia
    nunomaia Member Posts: 1,153
    If you follow your process you will corrupt database. You must write a report or a codeunit to process that.

    Triggers must run to apply your renaming in other tables.
    Nuno Maia

    Freelance Dynamics AX
    Blog : http://axnmaia.wordpress.com/
  • rj5570
    rj5570 Member Posts: 157
    thats what i thought

    im not really sure how to do that.......to write a code unit that will populate ALL fields and tables
    - So it Goes.

Categories