Hi, If you want it done in DAX 2009 below job will helped you :
static void showCompanyInfo(Args _args) { CompanyInfo companyInfo; container refCompany; ; refCompany = ['999','110'];//You can add more companies here from where you want to fetch the data. while select crossCompany:refCompany companyInfo { changeCompany(companyInfo.dataAreaId) { info(strfmt('Company Data Area Id :%1',companyInfo.dataAreaId)); } } } On Fri, Dec 18, 2009 at 3:42 AM, abdelrhman elkady <abdelrhma...@yahoo.co.uk > wrote: > > > Hi, > > if i understand you correctly you can use virtual company accounts to share > tables between companies > > Regards, > > *BayaNet* > *Abdelrhman El-Kady, Professional Services* *Specialist* > *13 Ahmed Orabi St., Mohandessin* > *002 012 181 5675* > *arah...@bayanet.net* > *http://www.bayanet.net* > > > > ------------------------------ > *From:* gihan_ax <gihan...@yahoo.com> > *To:* Axapta <Axapta-Knowledge-Village@yahoogroups.com> > *Sent:* Wed, 16 December, 2009 11:46:34 > *Subject:* [Axapta-Knowledge-Village] Company Settings > > > > > Dear all, > > I am having a small issue in getting records from all companies. > Lets say like this, I am having two companies as "A" and "B". > There are recodes in both companies. Lets say that company "A" is having > records 1,2 and 3. > And company "B" is having records 4,5 and 6. > > When I am working on company "A" I want to display the all records relating > to both companies. > (It should display record 1,2,3,4,5 and 6) > I tried on chnageCompany( ) method. But its working for one company. I need > both information. > > Can anyone help me to solve out this matter? Its a great help for me. > > Thanks, > Gihan > > > >