Re: [Axapta-Knowledge-Village] Where is the dataarea table?

2008-01-08 Thread Arijit Basu
SSMS is SQL Server Management Studio (SQL 2005). If you are using SQL 2000,
use the Query Analyzer to view the table.

Cheers

Arijit

On Jan 8, 2008 2:39 PM, Tarek Saleh [EMAIL PROTECTED] wrote:

   Thanks my friend,

 But where i can find the SSMS?

 Regards,
 Tarek


 Arijit Basu [EMAIL PROTECTED] arijit.basu%40gmail.com wrote:
 Hi,
 That is a system table and you will NOT find in the AOT. You can open SSMS
 and see the table but its better if you dont try to modify it.

 Regards,

 Arijit

 On Jan 8, 2008 12:18 PM, Tarek Saleh [EMAIL 
 PROTECTED]tarekegy4%40yahoo.com
 wrote:

  Dear All,
 
  can we customize in the dataarea table,by adding new field represent the
  company group.
 
  So far i was not able to find the table under the AOT table anybody
 knowes
  were i can find the table? and is it possible to add in new field in it.
 
  Thanks a lot
  Tarek
 
  -
  Looking for last minute shopping deals? Find them fast with Yahoo!
 Search.
 
  [Non-text portions of this message have been removed]
 
 
 

 --

 Arijit Basu

 [Non-text portions of this message have been removed]

 -
 Never miss a thing. Make Yahoo your homepage.

 [Non-text portions of this message have been removed]

 




-- 


Arijit Basu


[Non-text portions of this message have been removed]



Re: [Axapta-Knowledge-Village] Where is the dataarea table?

2008-01-08 Thread Tarek Saleh
Thanks again,

Arijit Basu [EMAIL PROTECTED] wrote:
  SSMS is SQL Server Management Studio (SQL 2005). If you are using SQL 
2000,
use the Query Analyzer to view the table.

Cheers

Arijit

On Jan 8, 2008 2:39 PM, Tarek Saleh [EMAIL PROTECTED] wrote:

 Thanks my friend,

 But where i can find the SSMS?

 Regards,
 Tarek


 Arijit Basu [EMAIL PROTECTED] arijit.basu%40gmail.com wrote:
 Hi,
 That is a system table and you will NOT find in the AOT. You can open SSMS
 and see the table but its better if you dont try to modify it.

 Regards,

 Arijit

 On Jan 8, 2008 12:18 PM, Tarek Saleh [EMAIL 
 PROTECTED]tarekegy4%40yahoo.com
 wrote:

  Dear All,
 
  can we customize in the dataarea table,by adding new field represent the
  company group.
 
  So far i was not able to find the table under the AOT table anybody
 knowes
  were i can find the table? and is it possible to add in new field in it.
 
  Thanks a lot
  Tarek
 
  -
  Looking for last minute shopping deals? Find them fast with Yahoo!
 Search.
 
  [Non-text portions of this message have been removed]
 
 
 

 --

 Arijit Basu

 [Non-text portions of this message have been removed]

 -
 Never miss a thing. Make Yahoo your homepage.

 [Non-text portions of this message have been removed]

 


-- 

Arijit Basu

[Non-text portions of this message have been removed]



 


 

   
-
Be a better friend, newshound, and know-it-all with Yahoo! Mobile.  Try it now.

[Non-text portions of this message have been removed]



Re: [Axapta-Knowledge-Village] Where is the dataarea table?

2008-01-08 Thread Tarek Saleh
Thanks my friend,
   
  But where i can find the SSMS?

  Regards,
  Tarek
   
  
Arijit Basu [EMAIL PROTECTED] wrote:
  Hi,
That is a system table and you will NOT find in the AOT. You can open SSMS
and see the table but its better if you dont try to modify it.

Regards,

Arijit

On Jan 8, 2008 12:18 PM, Tarek Saleh [EMAIL PROTECTED] wrote:

 Dear All,

 can we customize in the dataarea table,by adding new field represent the
 company group.

 So far i was not able to find the table under the AOT table anybody knowes
 were i can find the table? and is it possible to add in new field in it.

 Thanks a lot
 Tarek

 -
 Looking for last minute shopping deals? Find them fast with Yahoo! Search.

 [Non-text portions of this message have been removed]

 


-- 

Arijit Basu

[Non-text portions of this message have been removed]



 


 

   
-
Never miss a thing.   Make Yahoo your homepage.

[Non-text portions of this message have been removed]



[Axapta-Knowledge-Village] Re: Credit Note Misc. charges

2008-01-08 Thread yifath1
hi hi
thank you for your response.
However, i am still confused, should the whole amount be reversed or 
not?
The misc. charge is put on the hearder and allocated to the lines. 
it appears that that whole charge is reversed, not just the one 
applicable to the item returned.

Thanks
Yifat


--- In Axapta-Knowledge-Village@yahoogroups.com, Hemant Kumthekar 
[EMAIL PROTECTED] wrote:

 Hi,
 
 Just check if the misc. charges were allocated to each line using 
allocation method. It should happen that the whole charge amount 
gets reversed. Check what modifications were done to the object. It 
should not happen.
 
 
 Hemant K
 
 
 - Original Message 
 From: yifath1 [EMAIL PROTECTED]
 To: Axapta-Knowledge-Village@yahoogroups.com
 Sent: Saturday, January 5, 2008 4:52:34 AM
 Subject: [Axapta-Knowledge-Village] Credit Note  Misc. charges
 
 hi all,
 
 I just want to verify something. My client applies a misc. charge 
on 
 the purchase order, let say $100 for 5 items, therefore, the misc. 
 charge per item is $20. 
 Then the client returns 1 item to the supplier. i have tested this 
and 
 it appears that the whole misc. charge is reversed... $100 is this 
 correct?
 
 I think some modification has been done on this version of Axapta 
3. 
 Please can some one just verify and tell me what should happen 
when 
 credit note is created and posted.
 
 we are using misc. charge as landed cost - whereby it is debiting 
the 
 item and crediting a different account. 
 
 Thanks
 Yifat
 
 
 
 
 
   
_
___
 Be a better friend, newshound, and 
 know-it-all with Yahoo! Mobile.  Try it now.  
http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ 
 
 
 [Non-text portions of this message have been removed]





Re: [Axapta-Knowledge-Village] Re: Credit Note Misc. charges

2008-01-08 Thread prasanna govindan
Hi,

Ask the user to use only the charges in the lines. 
As you have to reverse only the amount related to the particular item, ask the 
suer to enter the charges propotionate to the item in the lines alone.
The charges should not be defined at header level.

Regards
Prasanna


- Original Message 
From: yifath1 [EMAIL PROTECTED]
To: Axapta-Knowledge-Village@yahoogroups.com
Sent: Tuesday, 8 January, 2008 3:21:32 PM
Subject: [Axapta-Knowledge-Village] Re: Credit Note  Misc. charges

hi hi
thank you for your response.
However, i am still confused, should the whole amount be reversed or 
not?
The misc. charge is put on the hearder and allocated to the lines. 
it appears that that whole charge is reversed, not just the one 
applicable to the item returned.

Thanks
Yifat

--- In Axapta-Knowledge- [EMAIL PROTECTED] ups.com, Hemant Kumthekar 
hemantdk66@ ... wrote:

 Hi,
 
 Just check if the misc. charges were allocated to each line using 
allocation method. It should happen that the whole charge amount 
gets reversed. Check what modifications were done to the object. It 
should not happen.
 
 
 Hemant K
 
 
 - Original Message 
 From: yifath1 [EMAIL PROTECTED] 
 To: Axapta-Knowledge- [EMAIL PROTECTED] ups.com
 Sent: Saturday, January 5, 2008 4:52:34 AM
 Subject: [Axapta-Knowledge- Village] Credit Note  Misc. charges
 
 hi all,
 
 I just want to verify something. My client applies a misc. charge 
on 
 the purchase order, let say $100 for 5 items, therefore, the misc. 
 charge per item is $20. 
 Then the client returns 1 item to the supplier. i have tested this 
and 
 it appears that the whole misc. charge is reversed... $100 is this 
 correct?
 
 I think some modification has been done on this version of Axapta 
3. 
 Please can some one just verify and tell me what should happen 
when 
 credit note is created and posted.
 
 we are using misc. charge as landed cost - whereby it is debiting 
the 
 item and crediting a different account. 
 
 Thanks
 Yifat
 
 
 
 
 
 
 _ _ _ _ _ _
 ___
 Be a better friend, newshound, and 
 know-it-all with Yahoo! Mobile. Try it now. 
http://mobile. yahoo.com/ ;_ylt=Ahu06i62sR 8HDtDypao8Wcj9tA cJ 
 
 
 [Non-text portions of this message have been removed]






  5, 50, 500, 5000 - Store N number of mails in your inbox. Go to 
http://help.yahoo.com/l/in/yahoo/mail/yahoomail/tools/tools-08.html

[Non-text portions of this message have been removed]



[Axapta-Knowledge-Village] Re: Axapta slower on SQL Server 2005 then SQL Server 2000?

2008-01-08 Thread Steeve Gilbert
Hi Harry,

Can you give me tips on how to build a good multi-user benchmark?  I 
have a few long running db intensive task in Axapta that I was 
thinking of running.  I can probably test it with 4 or maybe 5 client 
at time, do you think that will be multi-user enough?

regards,

Steeve...

--- In Axapta-Knowledge-Village@yahoogroups.com, Harry Deshpande 
[EMAIL PROTECTED] wrote:

 Hi
 
 Another thing to note is if you are running benchmarks then please 
run the benchmarks in multi-user environment. SQL Server 2005 is much 
better than '2000' in handling multi-user environment. (After all 
your live system works multi-user)
 
 You will get 100% advantage once you upgrade to 4.0+ version since 
concurrency has even been introduced in the AX application.
 
 Regards
 
 Harry
 
 
 This posting is provided AS IS with no warranties, and confers no
 rights. Use of included script samples are subject to the terms
 specified at http://www.microsoft.com/info/cpyright.htm;
 The code provided (if any) may be written from the point of view of 
a
 third party and the programming style/development standards may suit
 such a point of view.
 
 From: Harry Deshpande
 Sent: Tuesday, December 18, 2007 11:15 AM
 To: Axapta-Knowledge-Village@yahoogroups.com
 Subject: RE: [Axapta-Knowledge-Village] Axapta slower on SQL Server 
2005 then SQL Server 2000?
 
 Hi
 
 As per my experience SQL Server 2005 performance is much better 
than '2000'.
 
 
 1.   Please check whether the SQL Server setup is in line with 
Microsoft recommendations.
 
 2.   Go further and check things like disc-alignment. Take a 
look at 
http://sqlblogcasts.com/blogs/christian/archive/2007/10/09/disk-
sector-alignment.aspx
 
 3.   SQL Server 2005 engine is heavily optimized towards 
cluster indexes. You will see a lot of cluster indexes introduced 
from V4.0 onwards. Please back-port them. However, please note that 
there is a small chance that the cluster indexes for some tables in 
standard Ax may not be appropriate with your data usage pattern. In 
this case you will have to figure out the best fit cluster index 
yourself.
 
 4.   Last but not the least make sure you are running the 
database with compatibility mode 90. (It is easy to forget this).
 
 I must say I am a very happy camper since I started using SQL 
Server 2005.
 
 Regards
 
 Harry
 
 
 
 This posting is provided AS IS with no warranties, and confers no
 rights. Use of included script samples are subject to the terms
 specified at http://www.microsoft.com/info/cpyright.htm;
 The code provided (if any) may be written from the point of view of 
a
 third party and the programming style/development standards may suit
 such a point of view.
 
 From: Axapta-Knowledge-Village@yahoogroups.com [mailto:Axapta-
[EMAIL PROTECTED] On Behalf Of Steeve Gilbert
 Sent: Tuesday, December 18, 2007 10:51 AM
 To: Axapta-Knowledge-Village@yahoogroups.com
 Subject: [Axapta-Knowledge-Village] Axapta slower on SQL Server 
2005 then SQL Server 2000?
 
 
 I read a couple of post here and there about Axapta being slower on 
SQL
 Server 2005 then 2000. I thought that people that have problem post
 messages and those who don't stays quiet. That's why I was only 
seeing
 post about SQL 2005 being slower. But then I stubble on a post on 
MBS
 forum
 
(http://www.microsoft.com/Businesssolutions/Community/Newsgroups/dgbro
ws
 er/en-us/default.mspx?
 
query=sql+2005dg=microsoft.public.axapta.databasecat=lang=encr=US
pt
 =catlist=8d3f188d-a0E9-40e4-86e2-
 46508a35c759dglist=ptlist=exp=sloc=en-us). And the quote is :
 First of all Ax database runing on same hardware with SQL2005 is 
~20%
 slower than SQL200 database (tested).
 
 I can't find something clearer that this. So, does my friends of the
 Axapta Knowledge Village acknowledge this statement?
 
 I'm gonna test this in our dev environment and if it turns out true,
 then it's gonna be the end of our SQL Server 2005 migration I guess.
 Btw, we are staying at Ax3.0 SP3 even if we migrate to SQL 2005.
 
 
 
 [Non-text portions of this message have been removed]





Re: [Axapta-Knowledge-Village] Where is the dataarea table?

2008-01-08 Thread Varden Morris
You can look at system tables in the AOT under System Documentation - Tables. 
You can browse them from there like any other table but you will not be able to 
change the definition.

Regards,
 
Varden Morris 

276 Taralake Terrace N.E. 
Calgary, Alberta T3J 0A1 
Canada 

(403) 366-8434 (H) 
(403) 615-1604 (C)
[EMAIL PROTECTED]
 
 



- Original Message 
From: Tarek Saleh [EMAIL PROTECTED]
To: Axapta-Knowledge-Village@yahoogroups.com
Sent: Tuesday, January 8, 2008 2:24:03 AM
Subject: Re: [Axapta-Knowledge-Village] Where is the dataarea table?

Thanks again,

Arijit Basu arijit.basu@ gmail.com wrote:
SSMS is SQL Server Management Studio (SQL 2005). If you are using SQL 2000,
use the Query Analyzer to view the table.

Cheers

Arijit

On Jan 8, 2008 2:39 PM, Tarek Saleh [EMAIL PROTECTED] com wrote:

 Thanks my friend,

 But where i can find the SSMS?

 Regards,
 Tarek


 Arijit Basu arijit.basu@ gmail.com arijit.basu% 40gmail.com  wrote:
 Hi,
 That is a system table and you will NOT find in the AOT. You can open SSMS
 and see the table but its better if you dont try to modify it.

 Regards,

 Arijit

 On Jan 8, 2008 12:18 PM, Tarek Saleh [EMAIL PROTECTED] 
 comtarekegy4%40yahoo. com
 wrote:

  Dear All,
 
  can we customize in the dataarea table,by adding new field represent the
  company group.
 
  So far i was not able to find the table under the AOT table anybody
 knowes
  were i can find the table? and is it possible to add in new field in it.
 
  Thanks a lot
  Tarek
 
   - - ---
  Looking for last minute shopping deals? Find them fast with Yahoo!
 Search.
 
  [Non-text portions of this message have been removed]
 
 
 

 --

 Arijit Basu

 [Non-text portions of this message have been removed]

  - - ---
 Never miss a thing. Make Yahoo your homepage.

 [Non-text portions of this message have been removed]

 


-- 

Arijit Basu

[Non-text portions of this message have been removed]

 - - ---
Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now.

[Non-text portions of this message have been removed]





  

Be a better friend, newshound, and 
know-it-all with Yahoo! Mobile.  Try it now.  
http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ 


[Non-text portions of this message have been removed]



RE: [Axapta-Knowledge-Village] Re: Axapta slower on SQL Server 2005 then SQL Server 2000?

2008-01-08 Thread Harry Deshpande
However, I must tell you that I am not an expert on bench-marking

Regards

Harry
Ps: and I forgot to include the disclaimer in my last email*s*

This posting is provided AS IS with no warranties, and confers no
rights. Use of included script samples are subject to the terms
specified at http://www.microsoft.com/info/cpyright.htm;
The code provided (if any) may be written from the point of view of a
third party and the programming style/development standards may suit
such a point of view.

From: Harry Deshpande
Sent: Tuesday, January 08, 2008 9:13 AM
To: 'Axapta-Knowledge-Village@yahoogroups.com'
Subject: RE: [Axapta-Knowledge-Village] Re: Axapta slower on SQL Server 2005 
then SQL Server 2000?

Hi

Are you planning to use the same task for all the clients? May be that is not a 
good idea since they will end up locking each other.

I would say one client can do sales order, another can do gl posting, another 
can do something in projects and so on.

Regards

harry


From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On 
Behalf Of Steeve Gilbert
Sent: Tuesday, January 08, 2008 7:15 AM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: [Axapta-Knowledge-Village] Re: Axapta slower on SQL Server 2005 then 
SQL Server 2000?


Hi Harry,

Can you give me tips on how to build a good multi-user benchmark? I
have a few long running db intensive task in Axapta that I was
thinking of running. I can probably test it with 4 or maybe 5 client
at time, do you think that will be multi-user enough?

regards,

Steeve...

--- In 
Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com,
 Harry Deshpande
[EMAIL PROTECTED] wrote:

 Hi

 Another thing to note is if you are running benchmarks then please
run the benchmarks in multi-user environment. SQL Server 2005 is much
better than '2000' in handling multi-user environment. (After all
your live system works multi-user)

 You will get 100% advantage once you upgrade to 4.0+ version since
concurrency has even been introduced in the AX application.

 Regards

 Harry


 This posting is provided AS IS with no warranties, and confers no
 rights. Use of included script samples are subject to the terms
 specified at http://www.microsoft.com/info/cpyright.htm;
 The code provided (if any) may be written from the point of view of
a
 third party and the programming style/development standards may suit
 such a point of view.

 From: Harry Deshpande
 Sent: Tuesday, December 18, 2007 11:15 AM
 To: 
 Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com
 Subject: RE: [Axapta-Knowledge-Village] Axapta slower on SQL Server
2005 then SQL Server 2000?

 Hi

 As per my experience SQL Server 2005 performance is much better
than '2000'.


 1. Please check whether the SQL Server setup is in line with
Microsoft recommendations.

 2. Go further and check things like disc-alignment. Take a
look at
http://sqlblogcasts.com/blogs/christian/archive/2007/10/09/disk-
sector-alignment.aspx

 3. SQL Server 2005 engine is heavily optimized towards
cluster indexes. You will see a lot of cluster indexes introduced
from V4.0 onwards. Please back-port them. However, please note that
there is a small chance that the cluster indexes for some tables in
standard Ax may not be appropriate with your data usage pattern. In
this case you will have to figure out the best fit cluster index
yourself.

 4. Last but not the least make sure you are running the
database with compatibility mode 90. (It is easy to forget this).

 I must say I am a very happy camper since I started using SQL
Server 2005.

 Regards

 Harry



 This posting is provided AS IS with no warranties, and confers no
 rights. Use of included script samples are subject to the terms
 specified at http://www.microsoft.com/info/cpyright.htm;
 The code provided (if any) may be written from the point of view of
a
 third party and the programming style/development standards may suit
 such a point of view.

 From: 
 Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com
  [mailto:Axapta-
[EMAIL PROTECTED]mailto:Knowledge-Village%40yahoogroups.com] On Behalf Of 
Steeve Gilbert
 Sent: Tuesday, December 18, 2007 10:51 AM
 To: 
 Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com
 Subject: [Axapta-Knowledge-Village] Axapta slower on SQL Server
2005 then SQL Server 2000?


 I read a couple of post here and there about Axapta being slower on
SQL
 Server 2005 then 2000. I thought that people that have problem post
 messages and those who don't stays quiet. That's why I was only
seeing
 post about SQL 2005 being slower. But then I stubble on a post on
MBS
 forum

(http://www.microsoft.com/Businesssolutions/Community/Newsgroups/dgbro
ws
 er/en-us/default.mspx?

query=sql+2005dg=microsoft.public.axapta.databasecat=lang=encr=US
pt
 =catlist=8d3f188d-a0E9-40e4-86e2-
 46508a35c759dglist=ptlist=exp=sloc=en-us). And 

RE: [Axapta-Knowledge-Village] Re: Axapta slower on SQL Server 2005 then SQL Server 2000?

2008-01-08 Thread Harry Deshpande
Hi

Are you planning to use the same task for all the clients? May be that is not a 
good idea since they will end up locking each other.

I would say one client can do sales order, another can do gl posting, another 
can do something in projects and so on.

Regards

harry


From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On 
Behalf Of Steeve Gilbert
Sent: Tuesday, January 08, 2008 7:15 AM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: [Axapta-Knowledge-Village] Re: Axapta slower on SQL Server 2005 then 
SQL Server 2000?


Hi Harry,

Can you give me tips on how to build a good multi-user benchmark? I
have a few long running db intensive task in Axapta that I was
thinking of running. I can probably test it with 4 or maybe 5 client
at time, do you think that will be multi-user enough?

regards,

Steeve...

--- In 
Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com,
 Harry Deshpande
[EMAIL PROTECTED] wrote:

 Hi

 Another thing to note is if you are running benchmarks then please
run the benchmarks in multi-user environment. SQL Server 2005 is much
better than '2000' in handling multi-user environment. (After all
your live system works multi-user)

 You will get 100% advantage once you upgrade to 4.0+ version since
concurrency has even been introduced in the AX application.

 Regards

 Harry


 This posting is provided AS IS with no warranties, and confers no
 rights. Use of included script samples are subject to the terms
 specified at http://www.microsoft.com/info/cpyright.htm;
 The code provided (if any) may be written from the point of view of
a
 third party and the programming style/development standards may suit
 such a point of view.

 From: Harry Deshpande
 Sent: Tuesday, December 18, 2007 11:15 AM
 To: 
 Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com
 Subject: RE: [Axapta-Knowledge-Village] Axapta slower on SQL Server
2005 then SQL Server 2000?

 Hi

 As per my experience SQL Server 2005 performance is much better
than '2000'.


 1. Please check whether the SQL Server setup is in line with
Microsoft recommendations.

 2. Go further and check things like disc-alignment. Take a
look at
http://sqlblogcasts.com/blogs/christian/archive/2007/10/09/disk-
sector-alignment.aspx

 3. SQL Server 2005 engine is heavily optimized towards
cluster indexes. You will see a lot of cluster indexes introduced
from V4.0 onwards. Please back-port them. However, please note that
there is a small chance that the cluster indexes for some tables in
standard Ax may not be appropriate with your data usage pattern. In
this case you will have to figure out the best fit cluster index
yourself.

 4. Last but not the least make sure you are running the
database with compatibility mode 90. (It is easy to forget this).

 I must say I am a very happy camper since I started using SQL
Server 2005.

 Regards

 Harry



 This posting is provided AS IS with no warranties, and confers no
 rights. Use of included script samples are subject to the terms
 specified at http://www.microsoft.com/info/cpyright.htm;
 The code provided (if any) may be written from the point of view of
a
 third party and the programming style/development standards may suit
 such a point of view.

 From: 
 Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com
  [mailto:Axapta-
[EMAIL PROTECTED]mailto:Knowledge-Village%40yahoogroups.com] On Behalf Of 
Steeve Gilbert
 Sent: Tuesday, December 18, 2007 10:51 AM
 To: 
 Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com
 Subject: [Axapta-Knowledge-Village] Axapta slower on SQL Server
2005 then SQL Server 2000?


 I read a couple of post here and there about Axapta being slower on
SQL
 Server 2005 then 2000. I thought that people that have problem post
 messages and those who don't stays quiet. That's why I was only
seeing
 post about SQL 2005 being slower. But then I stubble on a post on
MBS
 forum

(http://www.microsoft.com/Businesssolutions/Community/Newsgroups/dgbro
ws
 er/en-us/default.mspx?

query=sql+2005dg=microsoft.public.axapta.databasecat=lang=encr=US
pt
 =catlist=8d3f188d-a0E9-40e4-86e2-
 46508a35c759dglist=ptlist=exp=sloc=en-us). And the quote is :
 First of all Ax database runing on same hardware with SQL2005 is
~20%
 slower than SQL200 database (tested).

 I can't find something clearer that this. So, does my friends of the
 Axapta Knowledge Village acknowledge this statement?

 I'm gonna test this in our dev environment and if it turns out true,
 then it's gonna be the end of our SQL Server 2005 migration I guess.
 Btw, we are staying at Ax3.0 SP3 even if we migrate to SQL 2005.



 [Non-text portions of this message have been removed]




[Non-text portions of this message have been removed]



[Axapta-Knowledge-Village] Financial year closing problem

2008-01-08 Thread Mukesh Kumar
Hi All,

 we are facing some problems regarding GL closing. we have some
transactions open for the financial year 2005. and by mistake we closed 2006
without closing year 2005. so those entries left open at that time. it is
showing some balances regarding those entries during balance. please suggest
how to close those entries so that it will not effect the current year
closing.
waiting for reply..its urgent.

Regards,
-- 
Mukesh


[Non-text portions of this message have been removed]



RE: [Axapta-Knowledge-Village] Covergare Group

2008-01-08 Thread Alaa Assem
Dear all,

Am using Ax.40,I have noticed that there is option named coverage group in
the general tap of the items form, what is this option for??

It has a list as follow:

Group   default

Min/Max Min/Max

Period 365   Period 365

Requ Requirement

 

Plz all, anybody knows What are these option and does it have any effect?
And when to choose these options??

Thnx a lot ALL,

Alaa



[Non-text portions of this message have been removed]



RE: [Axapta-Knowledge-Village] What are InventSumDateTable and InventSumDateTrans used for?

2008-01-08 Thread Jim Hummer

Are you sure that these are DAX 4.0 tables?I couldn't find them in any DAX 
4.0 db that I have.
 
 


To: [EMAIL PROTECTED]: [EMAIL PROTECTED]: Mon, 7 Jan 2008 18:52:03 
+0400Subject: [Axapta-Knowledge-Village] What are InventSumDateTable and 
InventSumDateTrans used for?




Sorry i am not sure whether I asked this before (but i guess even if I didthen 
there was no answer so its worth asking again)Can someone please tell me or 
give me any idea what the InventSumDateTableand InventSumDateTrans tables are 
used for in AX4.0?I looked at them and thought they were for the function of 
'Posting periodicphysical' but even though I dont use that function they are 
gettingpopulated and i would like to be sure as anything around InventSum 
issomething that should be very clear about :)ThanksJames[Non-text portions of 
this message have been removed] 







[Non-text portions of this message have been removed]



Re: [Axapta-Knowledge-Village] Loading opening balances

2008-01-08 Thread Maharaja g
Hi Akshay,
  I found another way to do it without using offset account ..While 
defining excel template use the Offset company account (Define offset company 
acc as any acc).
  While importing and posting no need to define offset accounts of each and 
every line in G/L journal.
  Thanks
  Maharaja

Akshay [EMAIL PROTECTED] wrote:
  Use the General Journal and offset just a single a/c called opening
balances. At the end of all opening balances being imported the net balnce
on this a/c should be 0. As far as the inventory is concerned offset the
same account in the movement journal. Note that you shouldn't post the
inventory accounts through Gen Journal, as it gets done through the Movement
Journal.

On Jan 3, 2008 10:41 AM, Maharaja g [EMAIL PROTECTED] wrote:

 Hi Friends,
 I would like to know how to load the opening financial and item stock
 balances in Axapta?Any document would be very usefulIdeas also would be
 very much valued...

 Thanks in advance
 Maharaja

 -
 Never miss a thing. Make Yahoo your homepage.

 [Non-text portions of this message have been removed]

 


[Non-text portions of this message have been removed]



 

   
-
Looking for last minute shopping deals?  Find them fast with Yahoo! Search.

[Non-text portions of this message have been removed]



[Axapta-Knowledge-Village] Re: FRX report

2008-01-08 Thread Chirani
Kumar, 
Have you installed FRX?

You have to run the script files on your databese. 

Then run the dimension Wizard. 

All the step by step information are available in Readme document. 

Chirani




[Axapta-Knowledge-Village] SysUserSecurity Report

2008-01-08 Thread sofer71
Hi,

I want to modify the sysusersecurity report and send an attached email
to a list of persons. Can someone with experience in this area please
assist.

Thanks
Sophie.