Anisha,
This must be done via SQL Statement. The dataareaid can not be changed from within Dynamics AX. Be careful though, because what you will have to do is make sure you don't try to have duplicate data in the same company. For example if you have: CustomerA, CustName, DA1 CustomerA, Cust Name, DA2 CustomerA, C U S T Name, DA3 And now you want all of these shared with a virtual company of vc1. Then you need to decided out of these 3 records which one is the correct one and share it only. Remove the others. So there is some data clean up as part of this if duplicate data exists. -Brandon ________________________________ From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Anisha Fakir Sent: Tuesday, June 05, 2007 7:41 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: Re: [Axapta-Knowledge-Village] Virtual companies query Hi Mohit, Thanks for the information. For the changing of the area Id's in the virtual company must a SQL update be done to achieve this? or can a AX job be sufficient? Regards Anisha ----- Original Message ---- From: mohit rajvanshy <[EMAIL PROTECTED] <mailto:mohit_rajvanshy%40yahoo.com> > To: Axapta-Knowledge-Village@yahoogroups.com <mailto:Axapta-Knowledge-Village%40yahoogroups.com> Sent: Tuesday, June 5, 2007 12:07:39 PM Subject: Re: [Axapta-Knowledge-Village] Virtual companies query Hi Anish, If data is already there in the tables which you want to add in the virtual companies then after adding those tables in virtual comapnies you will not be able to see the data in ax untill you will change the data area id for the tables added in the virtual companies to the virtual company data area id. Rgrds Mohit --- anishafakir1 <anishafakir1@ yahoo.com> wrote: > Hi, We need to implement virtual companies at one of > our clients. The > client has gone live with AX and has decided to > share certain tables > in the system. Is there any complications in > implementing virtual > companies after the client has gone live with the > system? > > Thanking you in advance. > > Regards, > Anisha > > > > Regards Mohit Rajvanshy ____________ _________ _________ _________ _________ _________ _ Choose the right car based on your needs. Check out Yahoo! Autos new Car Finder tool. http://autos. yahoo.com/ carfinder/ __________________________________________________________ Now that's room service! Choose from over 150,000 hotels in 45,000 destinations on Yahoo! Travel to find your fit. http://farechase.yahoo.com/promo-generic-14795097 <http://farechase.yahoo.com/promo-generic-14795097> [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]