mibuso.com
Home› NAV/Navision Classic Client
Options

rename item code

mike@bcinc.netmike@bcinc.net Member Posts: 2
edited 2005-04-28 in NAV/Navision Classic Client
a client of ours need to change the inventory codes.
Doing manually for 500 items will be time consuming.

is there a way to rename the item code through through the C/side code

Comments

  • Options
    SbhatSbhat Member Posts: 301
    Create a new temporary table with 2 fields, old item no. and new item no., populate the records in this new table with your existing item no. in old item no. field and the corresponding new item no. in the new item no. field. Create a report which will run through this temporary table till end and setrange for the old item no. field and rename the item table no. field with the new item no. field using the RENAME function. I am not sure how long it would take, it all depends on the volume of data you have in all the subsidiary tables like Item ledger entry and other tables where item no. is being used.

    Regards
    SB.
Sign In or Register to comment.