Modify Item No.

RobbieX

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?

ara3n

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.

RobbieX

Thanks Rashed!
That is very useful to know!

RobbieX

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.

DenSter

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.