Gihan,
Sorry I didn’t realise you were on AX 3. If I recall correctly about the only thing that you have the option of doing is to extract the records using the changeCompany function and saving them in a temporary table, Then process all the records in the sort order that you require. Thanks, Danny Band Power IT Consulting Ltd. Phone: (780) 446-9087 Email: db...@powerit. ca cid:1.2496282066@web113112.mail.gq1.yahoo.com From: Axapta-Knowledge-Village@yahoogroups.com [mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of gihan_ax Sent: December-16-09 7:16 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: Re: [Axapta-Knowledge-Village] Company Settings Danny, I am using axapta 3.0. Think crossCompany key word will not support for this version. It works in ax 2009. Is there any method which I can use in the axapta 3.0? Anyway thank you very much for your assistance. Hope you will reply me. Gihan _____ From: Danny Band <db...@planet.eon.net> To: Axapta-Knowledge-Village@yahoogroups.com Sent: Wed, December 16, 2009 8:34:25 PM Subject: [Axapta-Knowledge-Village] Company Settings Gihan, You have a few choices to get the company records, first you can use a select statement with the crosscompany keyword such as select crosscompany * from ledgerjournaltrans. ... or you can use the DAX query with allowCrossCompany set like _newQuery.allowCros sCompany( true) or if you are using a query from the AOT you can set the property on the query property sheet for AllowCrossCompany to ‘Yes’. If you are creating a report, you can also set the properties on the Query datasource to AllowCrossCompany to ‘Yes’. Please also take into consideration that there can be performance issues if you are dealing with a large number of companies and records. These are mostly due to security verifications as you switch company boundries. I hope this helps. Danny Band Power IT Consulting Ltd. Phone: (780) 446-9087 Email: db...@powerit. ca
<<image001.png>>