Re: [Axapta-Knowledge-Village] Company Settings
You are welcome.
Regards
Ashish Singh
On Tue, Dec 22, 2009 at 7:06 AM, gihan_ax wrote:
>
>
> Ashish,
>
> Thank you very much. I got that right.
>
> Gihan
>
> --
> *From:* Ashish Singh
> *To:* Axapta-Knowledge-Village@yahoogroups.com
> *Sent:* Mon, December 21, 2009 7:46:55 PM
> *Subject:* Re: [Axapta-Knowledge-Village] Company Settings
>
>
>
> 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 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 <http://www.bayanet.net/>*
>>
>>
>>
>> --
>> *From:* gihan_ax >
>> *To:* Axapta > ups.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
>>
>>
>>
>
>
>
Re: [Axapta-Knowledge-Village] Company Settings
Ashish,
Thank you very much. I got that right.
Gihan
From: Ashish Singh
To: Axapta-Knowledge-Village@yahoogroups.com
Sent: Mon, December 21, 2009 7:46:55 PM
Subject: Re: [Axapta-Knowledge-Village] Company Settings
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
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
>To: Axapta
>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
>
>
>
Re: [Axapta-Knowledge-Village] Company Settings
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 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
> *To:* Axapta
> *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
>
>
>
>
Re: [Axapta-Knowledge-Village] Company Settings
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.GihanFrom: Danny Band To: Axapta-Knowledge-Village@yahoogroups.comSent: Thu, December 17, 2009 9:18:51 PMSubject: 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 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
Re: [Axapta-Knowledge-Village] Company Settings
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 To: Axapta 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
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 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 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 <>
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 To: Axapta-Knowledge-Village@yahoogroups.comSent: Wed, December 16, 2009 8:34:25 PMSubject: [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
