Danny,
I got it your suggestion. So think it is the only think what can i do. Thank you very much for your kind co-operation. Keep in touch.
Gihan
From: Danny Band <db...@planet.eon.net>
To: Axapta-Knowledge-Village@yahoogroups.com
Sent: Thu, December 17, 2009 9:18:51 PM
Subject: RE: [Axapta-Knowledge-Village] Company Settings
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
From: Axapta-Knowledge- vill...@yahoogro ups.com
[mailto:Axapta- Knowledge- vill...@yahoogro ups.com] On Behalf Of gihan_ax
Sent: December-16- 09 7:16 PM
To: Axapta-Knowledge- vill...@yahoogro ups.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- vill...@yahoogro ups.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
