How to record Common Item codes in 3 companies???

Dear All, We have implemented Navision Axapta 3.0 in 3 of our company sites. we have a separate database in each site. Now the problem being faced by our purchase manager is : different sites record item codes and vendor codes differently through Navision Axapta. So the same physical item is identified by different codes in each site. e.g. ITEM A = ITEM B = ITEM C i.e. all these three items are physically the same, but recorded as ITEM A,ITEM B and ITEM C respectively in the three sites. So, if the purchase manager wants to see a consolidated view of the common items across the sites, in the current scenario it is very difficult. Can anyone please suggest me if in Axapta, is there any way to get a consolidated view or if there is any way to identify the items are already present in another site before purchasing??? I have gone through some documents about intercompany and virtual company accounts but bit confused between the two and also quite not sure whether it will really help me. Request you to please help me with this!! Thanks in advance for your time. Thanks and Regards, Dilip

Hi all, This is another multi-post thread. Hence I am locking this. Those who want to follow this thread, please visit - http://www.mbsonline.org/forum/topic.asp?TOPIC_ID=12540 Harish Mohanbabu PS - If some one wants this thread to be unlocked, please PM me…