Hi Brendon & Mohit, Thank you for your advice. It will be off great help to me.
Regards, Anisha ----- Original Message ---- From: Brandon George <[EMAIL PROTECTED]> To: Axapta-Knowledge-Village@yahoogroups.com Sent: Tuesday, June 5, 2007 3:04:37 PM Subject: RE: [Axapta-Knowledge-Village] Virtual companies query 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- [EMAIL PROTECTED] ups.com [mailto:Axapta-Knowledge- [EMAIL PROTECTED] ups.com] On Behalf Of Anisha Fakir Sent: Tuesday, June 05, 2007 7:41 AM To: Axapta-Knowledge- [EMAIL PROTECTED] ups.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 <mohit_rajvanshy@ yahoo.com <mailto:mohit_ rajvanshy% 40yahoo.com> > To: Axapta-Knowledge- [EMAIL PROTECTED] ups.com <mailto:Axapta- Knowledge- Village%40yahoog roups.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] ____________________________________________________________________________________ Get the Yahoo! toolbar and be alerted to new email wherever you're surfing. http://new.toolbar.yahoo.com/toolbar/features/mail/index.php [Non-text portions of this message have been removed]
