Modify Item No.

RobbieX
RobbieX Member Posts: 66
edited 2007-03-24 in NAV/Navision Classic Client
Navision 4.1
When we modify an Item No., Navision seems to update all mentions of the same Item No. throughout the whole database. This is what one would expect :)
However, I have just noticed that one table (at least) is not updated with the new Item No., even though the field's Table Relation is the Item table.
Can anyone explain why?
Is there a simple way of making sure it is included in the global update?
Robbiex

Comments

  • ara3n
    ara3n Member Posts: 9,258
    If the table's property DataPerCompany is set to NO, rename will not change those tables.
    You have to add code to the onrename to modify those tables manually.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • RobbieX
    RobbieX Member Posts: 66
    Thanks Rashed!
    That is very useful to know!
    Robbiex
  • RobbieX
    RobbieX Member Posts: 66
    Hello again Rashed....
    I just checked other shared tables such as the Item Variant table and the Item Cross Reference table, and another non standard table we use.
    The Item Nos. which I tested actually changed in these tables.
    The first 2 tables have Item No. in the primary key but the 3rd does not.
    Have you any idea why all 3 of these tables would be updated with the new Item No.?
    There is definitely no extra code in the Item table onrename trigger.
    Robbiex
  • DenSter
    DenSter Member Posts: 8,307
    Those tables are not shared in the standard database, so that has been customized for the customer. This is one of the things you have to be sure to handle when you modify standard NAV.
    Daniel Rimmelzwaan
    RIS Plus, LLC

Categories