Re: [Axapta-Knowledge-Village]

[sri ram]

hi girish,
 
Sorry to say I tried the same with Axapta 3.0 installed on my AOS and as a 3 tier sp4 thin client tried to acess the same. Its giving me an error.
 
Please suggest if any cheanges are to be made during client installation.
 
Thanking you.
 
Regards
Sri Ram 
On 10/20/05, Girish Bhatkal <[EMAIL PROTECTED]> wrote:
its alright for you to use the SP4 client to run Sp3or lower level applications/servers. But you should
not connect Sp3 client to Sp4 application.--- Alessandro Ghidini <[EMAIL PROTECTED]
> wrote:> Hi group.. I'd like to install two different Axapta> service packs on the> same computer.. Basically i need an sp3 client for a> 3 level connection to> an sp3 server and an sp4 installation on my pc for
> testing purposes.> >  > > If i try to make a new Axapta client installation on> my pc, installer> recognizes the old installation and tries to use> that for repairing or
> changing.. So i can install a new client..> >  > > Any suggestion? Thanks in advance.> >  > > Alessandro> >  > >  > >  
> > Ghidini Ing. Alessandro> > Kibuz SRL> > Galleria Ludovico Mortara, 2 - 46100 - Mantova> > Telefono: +39 0376 220605> > Fax: +39 0376 367439> 
> Email:  [EMAIL PROTECTED]> 
[EMAIL PROTECTED]> >  > >         ___ Yahoo! Messenger - NEW crystal clear PC to PC calling worldwide with voicemail 
http://uk.messenger.yahoo.comSharing the knowledge on Axapta. 

SPONSORED LINKS 




Business finance course 

Business to business finance 

Small business finance 


Business finance consultant 

Business finance magazine 

Business finance schools 



YAHOO! GROUPS LINKS 

 Visit your group "Axapta-Knowledge-Village" on the web.
  
 To unsubscribe from this group, send an email to: 
[EMAIL PROTECTED]  
 Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. 










Sharing the knowledge on Axapta.








  
  
SPONSORED LINKS
  
  
  

Business finance course
  
  
Business to business finance
  
  
Small business finance
  
  


Business finance consultant
  
  
Business finance magazine
  
  
Business finance schools
  
  

   
  







  
  
  YAHOO! GROUPS LINKS



   Visit your group "Axapta-Knowledge-Village" on the web. 
   To unsubscribe from this group, send an email to: [EMAIL PROTECTED] 
   Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



  

[Axapta-Knowledge-Village] 2 line Subtotal

[James Flavell]

Hi 

I want to have a subtotal that has 2 lines when using the autogenerated
reports.

So I want something like

ItemQty
Amount
AAA 10
30

BBB  3
20

Total   13
50

Now I tried using the TOP property in the body and that works fine for the
body lines but the subtotal always comes out as one line (i.e. the 50
overwrites the 13 (see below)

ItemQty
Amount
AAA 10
30

BBB  3
20

Total   50

I understand I could change to generated design to control the subtotal but
I want to keep the nice subtotalling options the user can select in the
query when they run the report (from what I understand once I use generated
design this option of group totals and headings is gone)?

Any ideas how to do it?

Thanks
James



 Yahoo! Groups Sponsor ~--> 
Get fast access to your favorite Yahoo! Groups. Make Yahoo! your home page
http://us.click.yahoo.com/dpRU5A/wUILAA/yQLSAA/kGEolB/TM
~-> 

Sharing the knowledge on Axapta. 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/Axapta-Knowledge-Village/

<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
 

RE: [Axapta-Knowledge-Village] Security rights not effective!

[James Flavell]

Hi everyone,

Okay Steve, yes basically items with no security right can be accessed by a
user that is not linked to ANY user group so I am not sure is it in the best
practices of Axapta that they say must set security right on any menu
item???  If it is not to those not sure whether to set I recommend you set
one for every menu item element you create this will be default mean the
element has to be set with permissions in at least one group in order to be
accessed.

I am not 100% sure about the next bit but would like to share to see if
anyone else can agree:

The problem I found was that I could set the USER GROUP 'main menu' point
(e.g. a form like sales order) to no acess BUT I COULD NOT SEE THE SUB
ELEMENTS OF THIS (I just assumed they were also no access).  But when I
looked via the user's permission screen they have access to the element AND
I can see the sub elements!!!  It seemed this was because inside the main
menu element there are sub elements (buttons etc) that were set with Full
control (even though I had set the parent element as no access!!!).  So in
summary the problem: USER GROUP screen did not show or allow setting of sub
elements and also when setting the parent as no access this was not passed
down to the sub elements!

Anyway later in the day I tried some more testing and selected in the
permission the whole 'Main menu' list and pressed the 'Cascade'.  Now after
this the sub elements could be seen and set (before this I didn't check
hence so cannot be 100% sure what I tried in the morning actually happened -
i.e. only have my memory from morning testing to rely on so only 95% sure).
So it seems to me the cascade 'reset' everything and with this the
subelements began to appear correctly in the USERGROUPS screen and so could
be set

Has anyone had similar experience?
Is it maybe because the VAR layer has been replaced several times?

Thanks
James



I cannot be 100% sure of this but I think we can all keep an eye out for
this possible sub element no access problem (maybe it is when new VAR/USR
layer is mixed I am not sure)

-Original Message-
From: Axapta-Knowledge-Village@yahoogroups.com
[mailto:[EMAIL PROTECTED] On Behalf Of lukas nugroho
Sent: 20 October 2005 17:34
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: RE: [Axapta-Knowledge-Village] Security rights not effective!


Dear James,

I have a same problem sometimes ago, and our solution
that time, we import security setting again and it
works.

lukas nugroho

--- James Flavell <[EMAIL PROTECTED]> wrote:

> Thanks Harry and Steve,
>  
> Reboot not help...I think I have stumbled across
> something and will report
> back when can make sense of it
>  
> Has noone had problems of a new VAR layer being put
> in causing loss or
> corruption of permission settings?
>  
> THanks
> James
> 
> -Original Message-
> From: Axapta-Knowledge-Village@yahoogroups.com
> [mailto:[EMAIL PROTECTED] On
> Behalf Of Harry
> (Harshawardhan Deshpande
> Sent: 20 October 2005 16:12
> To: Axapta-Knowledge-Village@yahoogroups.com
> Subject: Re: [Axapta-Knowledge-Village] Security
> rights not effective!
> 
> 
> hi James
>  
> reboot your server and check if it has the desired
> effect.
>  
> regards
>  
> harry
> 
> James Flavell <[EMAIL PROTECTED]> wrote:
> 
> Hi
>  
> Can anyone tell me have you had problems with
> security settings being set
> but when the user login they can do things that in
> security are disabled?
>  
> A few things I think might be causing this:
> 1) Change of VAR layer after security rights set
> 2) Bug in Axapta with security on elements in VAR or
> USR layer
>  
> BTW I am using domains...
>  
> The security settings are stored in the DB or one of
> the axapta appl files?
> How come I can only see std Axapta elemnts in the
> 'Security' lookup inside
> permissions (i.e. have to select 'Main menu' in
> order to see and set
> security rights for new elements I have created)?
>  
> Thanks
> James
>  
> 
> 
> 
>   _
> 
> Yahoo!
>
 om/unlimited/> Music Unlimited - Access over 1
> million songs. Try it free.
> 
> Sharing the knowledge on Axapta.
> 
> 
> 
>   _
> 
> YAHOO! GROUPS LINKS
> 
> 
>   
> *  Visit your group "Axapta-Knowledge-Village
>

> " on the web.
>   
> 
> *  To unsubscribe from this group, send an email to:
> 
> [EMAIL PROTECTED]
>
 ribe> 
>   
> 
> *  Your use of Yahoo! Groups is subject to the
> Yahoo! Terms of Service
>  .
> 
> 
>   _
> 
> 
> 




__ 
Yahoo! Music Unlimited 
Access over 1 million songs. Try it free. http://music.yahoo.com/unlimited/



Sharing the knowledge on Axapta. 
Yahoo! Groups Links



 






 Yahoo! Groups Sponsor ~--> 
Get fast access to your favo

Re: [Axapta-Knowledge-Village] Re: BOM Journal and Master Planning

[Vaibhav Pednekar]

Hi 
 
No need of Production License, as far as i know, microsoft as already fixed this, so whithout the production license you can use the BOM journals,
 
Wise to check with microsoft again.
 
Regards
Vaibhav Pednekar
Microsoft Business Solutions - Axapta Application Certified Master
 
On 10/17/05, Kuni <[EMAIL PROTECTED]> wrote:

I think you can manage that only with BOM journal.

- Original Message - 
From: Gokhan Can
 
To: Axapta-Knowledge-Village@yahoogroups.com
 

Sent: Friday, October 14, 2005 1:09 PM
Subject: BOM Journal and Master Planning
 

Hi all;
 
We are planning to offer a license model to a customer.
the price is increase if we add Production I module therefore I am looking
some kinf of oppurtunities to solve customer's requirements.
 
The situation;
 
Customer does master planing just for purchase items, and produces 
cooked food.
The Bom's are known.Customer does not report work hours therefore we do not need to make 
route planning.
 
At the end of month the route consumption will be adjusted at closing process.
 
Do you think do we need to make production license ???
 

Gökhan CAN
Software Engineer /
Mic. Cert. Axapta Professional ( Pro - PB )
Cep: +90 532 701 17 39


Kimden: Axapta-Knowledge-Village@yahoogroups.com bu kişinin yerine: Gert D'Hollander
Gönderilmiş: Cum 14.10.2005 12:41Kime: 'Axapta-Knowledge-Village@yahoogroups.com
'Konu: RE: [Axapta-Knowledge-Village] Any Idea abou this? 


or put the spaces there yourselve


-Oorspronkelijk bericht-Van: 
Axapta-Knowledge-Village@yahoogroups.com [mailto:Axapta-Knowledge-Village@yahoogroups.com
]Namens DIEGO MARIANO GAGLIANOVerzonden: woensdag 31 augustus 2005 11:03Aan: 
Axapta-Knowledge-Village@yahoogroups.comOnderwerp: RE: [Axapta-Knowledge-Village] Any Idea abou this?
Hi Hennie
When you change the Right to Left aligment, you lost all existing Account.
When Axapta have a Right aligment add blank space front at the Account Number (AccountNum: ' 1125'). Axapta put blank space to complete the size of the field.
Now with left aligment Axapta looking for (AccountNum:'1125').
If you see for the above examples you never find old accounts.
My suggestion  is change back to right aligment, previouse delete the account that you generated with the left aligment.
Hennie Potgieter <[EMAIL PROTECTED]> wrote:


Hi,
 
I changed the alignment of this EDT once (by accident).  It caused quite a bit of chaos since Axapta could not find any of its GL accounts and as a result posted all transactions to the "System Error Account" account.

 
Hennie



-Original Message-From: 
Axapta-Knowledge-Village@yahoogroups.com [mailto:Axapta-Knowledge-Village@yahoogroups.com
] On Behalf Of ANIL OZAYSent: Wednesday, 31 August 2005 08:59 AMTo: 
Axapta-Knowledge-Village@yahoogroups.comSubject: RE: [Axapta-Knowledge-Village] Any Idea abou this?


Hi Subbu,
 
Yes, you can check EDT, or anybody has changed it from 'Adjust Global Types'  on "Administration/Setup/System/Adjust Global Types".

 
Regards,
 
Anil Ozay
 




From:
 Axapta-Knowledge-Village@yahoogroups.com [mailto:
Axapta-Knowledge-Village@yahoogroups.com] On Behalf Of Harry (Harshawardhan DeshpandeSent: Wednesday, August 31, 2005 9:26 AM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: Re: [Axapta-Knowledge-Village] Any Idea abou this?
 

hi subbu

 

check the property on the extended data type

 

regards

 

harry

 

"Subrahmanyam, Mamidi" <
[EMAIL PROTECTED]> wrote:



Hi,

 

I am wondering if you guys know of this. Why is the field 'AccountNum' is right aligned  and why not 'Left aligned'?.

 

 

Does what factor judge alignment property?. Because this has significant effect  in 'select' statements if I use AccountNum as Index.


 

Any help is highly appreciated,

 

Thanks & Regards,

subbu



Start your day with Yahoo! - make it your home page 





Start your day with Yahoo! - make it your home page Bu e-posta ve muhtemel eklerinde verilen bilgiler kisiye ozel ve gizlidir. Anadolu Bilisim Hizmetleri A.S. bu mesajin icerigi ve ekleri ile ilgili hicbir hukuki sorumluluk kabul etmez. Yetkili alicilardan degilseniz, bu mesajin herhangi bir sekilde ifsa edilmesi, kullanilmasi, kopyalanmasi, yayilmasi veya mesajda yer alan hususlarla ilgili olarak herhangi bir islem yapilmasi kesinlikle yasaktir. Bu durumda hemen mesajin gondericisini bilgilendiriniz ve mesaji sisteminizden siliniz. Elektronik mesajlar uzerinde yapilmis herhangi bir degisiklik veya sonuclari uzerinde Anadolu Bilisim Hizmetleri 
A.S.'nin sorumlulugu yoktur. Ayrica, e-posta mesajlarindaki hata ve/veya eksiklikten, virus icermesinden ve bilgisayar sistemin ize verebilecegi herhangi bir zarardan Sirket olarak sorumluluk kabul etmeyecegimizi de bildiririz.
This e-mail and any information included within any attached document are private and confidential and intended solely for the addressee. Anadolu Bilisim Hizmetleri A.S. does not accept any legal responsibility for the contents of this message and any attached 

RE: RE : [Axapta-Knowledge-Village] Performance analysis

[Bayliss, Barry]

Steeve,

 

 

There are several tools which I regularly use to speed up performance
without upgrading hardware:

 


 Tools > option
 > SQL
 
  Select the SQL trace
  option.
  Enter in the
  threshold value for your query
  Select the
  appropriate options
 
 Tools > option
 > General
 
  Set the infolog
  option to ALL
 
 Tools >
 Development tools > System monitoring  
 Tools >
 Development tools > code profiler


 

Do you know which tables are causing the blocking?  Is it
standard Axapta code or customised code?

 

Are the slow objects forms, classes or reports?

 

 

 

Barry.

 

 

 

 

 









From:
Axapta-Knowledge-Village@yahoogroups.com
[mailto:[EMAIL PROTECTED] On Behalf Of Steeve Gilbert
Sent: Friday, 21 October 2005
12:49 AM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: RE :
[Axapta-Knowledge-Village] Performance analysis



 

Hi Harry and Brandon,

 

Here's our setup for a
60 users environment: 

 

1 AOS

Dual 1.3 Ghz

1 gig RAM

 

1 DB Server

Dual 1.3 Ghz

3 gig RAM

DB : 4 SCSI disks Raid
10

Log : 2 SCSI disks
Mirror

OS : 2 SCSI disks Mirror

 

Brandon : 

We're already did a review
from the ground up and added some RAM to our DB server and now the sqlserver
uses 1.7 gig and there's always 1gig available.  The real bottleneck we've
found is the Read on our DB disks.  When looking at the windows
performance tool we can see "Avg. Disk Read Queue Length" hitting
real high for long period of time.  I'm guessing some querys uses Table
Scan.  That's why I wanted to reduce read by reviewing bad queries in the
code.  Our DB disk setup with pretty much the best we can do before going
on a SAN.  Our AOS seems at ease with the work load.  That's why I'm
now arrived at step 4, looking at the code.

 

Harry : 

No specific place in
Axapta.  What I want to do is reduced Table Scan globally and minimize
blocking.  For blocking I will start to look at custom process that does a
lot of inventory transfer in 1 long transaction and try to split it up. 
Blocking here is a major pain.  It can happen 3 times a day
sometimes.  They usually resolve themselves out but the more it takes time,
the more people get blocked.

 

Finally, I'm using the
SQL Profiler to check query with long duration.  Sometimes, when I see
lines like : 

exec sp_cursorexecute
241, @P1 output, @P2 output, @P3 output, @P4 output, 'boa', 0, 0, 'boa',
'596965'

How can I know the query
that is executed?

 

Thanks for reading thru,

Regards,







Steeve... 







 

-Message d'origine-
De :
Axapta-Knowledge-Village@yahoogroups.com
[mailto:[EMAIL PROTECTED] De la part de Brandon George
Envoyé : 20 octobre 2005
07:54
À : Axapta-Knowledge-Village@yahoogroups.com
Objet : RE:
[Axapta-Knowledge-Village] Performance analysis

 

Steve,

 

 The improvement of performance, for
any system, starts always at the bottom level. So I would do the following:

 

(1) Can you improve your system through
hardware? (ex: increase RAM, CPU, Speed of Hard Drives, etc.)

(2) Can you increase performance at the
Database level? (ex: RAM of SQL server, SQL server AWE configuration, Multiple
Processors, un-needed performance drags by Non-Axapta Queries., clustering.)

(3) Can you increase performance at the
Business level? (ex: have two AOS server for load balance, etc.)

(4) Can you increase performance through
code? (ex: making sure Axapta-SQL statements make use of Indices, review large
chunks of code and break them down into more efficient functional blocks of
code, etc.)

 

This is how I would approach it... from the
ground up, not the other way around.

 

-Brandon

 







From:
Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED]
On Behalf Of Steeve Gilbert
Sent: Wednesday, October 19, 2005
9:15 AM
To:
Axapta-Knowledge-Village@yahoogroups.com
Subject:
[Axapta-Knowledge-Village] Performance analysis

Hi everyone,

 

  I'm currently looking at ways to improve
performance of our installation.  When looking thru menus I stumble upon
"Performance analysis" in Administration -> Performance test
wizard.  I've run it in our Dev environment to see what it does and the
result was just an info box with the name of some forms.  What does it do
and where are the result of that analysis?

 

  Btw, if you have any hints at where to look
to improve performance/minimize blocking (software way) besides maximizing the
use of index, let me know.

 

Have a nice day,





Steeve... 





 









Sharing the knowledge on Axapta.








  
  
SPONSORED LINKS
  
  
  

Business finance course
  
  
Business to business finance
  
  
Small business finance
  
  


Business finance consultant
  
  
Business finance magazine
  
  
Business finance schoo

[Axapta-Knowledge-Village] Re: Axapta Trade and Logistics Certification Exam V 3.0

[bbgregory123]

hi, 
the same problem - could you help me - send me some example -
or tell me where can i find it? - please, thanks



--- In Axapta-Knowledge-Village@yahoogroups.com, "saddasadda" 
<[EMAIL PROTECTED]> wrote:
>
> Hi,
> 
> This is Sadda Shrivastava. 
> 
> I am preparing for Axapta Trade and Logistics Certification Exam.
> 
> If any of u guys have already given the Certification Exam,Please 
> provide me with possile questions that are expected in the Exam.
> 
> It will be extremely helpful if anyone of u can share some of the 
> questions that are expected.
> 
> Thanx and Regards,
> 
> Sadda Shrivastava,
> Associate Consultant,
> MBS Practice.
> 
> PS- If solutions are provided, that will be amazing..
>








 Yahoo! Groups Sponsor ~--> 
Get fast access to your favorite Yahoo! Groups. Make Yahoo! your home page
http://us.click.yahoo.com/dpRU5A/wUILAA/yQLSAA/kGEolB/TM
~-> 

Sharing the knowledge on Axapta. 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/Axapta-Knowledge-Village/

<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
 

RE: [Axapta-Knowledge-Village] Performance analysis

[Brandon George]

There is a great how-to on SQL Server performance 
monitoring on www.sql-server-performance.com:
 
http://www.sql-server-performance.com/performance_montior_counters_sql_server.asp
 
Follow these for doing performance analysis, and it has 
some great solutions and thresholds. So you will know exactly where and how you 
can tune and increase SQL performance.
 
-Brandon


From: Axapta-Knowledge-Village@yahoogroups.com 
[mailto:[EMAIL PROTECTED] On Behalf Of Steeve 
GilbertSent: Thursday, October 20, 2005 1:40 PMTo: 
Axapta-Knowledge-Village@yahoogroups.comSubject: RE : 
[Axapta-Knowledge-Village] Performance analysis


I'll transfert that to 
my sysadmin and my manager to let them know what to do if they want a kick ass 
server. J
 
To tell you the truth, 
I didn't know what AWE was until this week.  So I've looked for 
information:
http://www.sql-server-performance.com/awe_memory.asp
Since we have Windows 
2000 Server and SQL Server 2000 Standard Edition, If I enable AWE, can I expect 
my SQL Server to go up to 2G?  How do I know If SQL Server really needs 
more RAM?



Steeve... 

 
-Message 
d'origine-De : 
Axapta-Knowledge-Village@yahoogroups.com 
[mailto:[EMAIL PROTECTED] De la part de Brandon GeorgeEnvoyé : 20 octobre 2005 
12:40À : 
Axapta-Knowledge-Village@yahoogroups.comObjet : RE: [Axapta-Knowledge-Village] 
Performance analysis
 
I have to say Steve, we are on an HP San, 
Fiber Channels, and all, and it kicks major butt! I recommend it to anyone, MSA 
1000 (Now the MSA 1500).
 
We have the SQL Server clustered for Fail 
over, and we have some issues when we first started. Of course using SQL 
Profiler showed us that we had Non Axapta Queries taking a while. We analyzed 
them, improved them, then we also upped out RAM to 3 Gig. You must also realize 
that SQL server will not go beyond the 1.7 you are at unless AWE is enabled, and 
the 3 Gig. Switch is used (you can search MSDN for how to do this). This will 
allow SQL server more room to use in RAM. 
 
As for knowing what Query that is... I wish 
I knew of a way because then you could really do some fine tunning within 
Axapta. If you find that out please let me know!
 
-Brandon
 
 
 



From: 
Axapta-Knowledge-Village@yahoogroups.com 
[mailto:[EMAIL PROTECTED] On Behalf Of Steeve GilbertSent: Thursday, October 20, 2005 10:49 
AMTo: 
Axapta-Knowledge-Village@yahoogroups.comSubject: RE : [Axapta-Knowledge-Village] 
Performance analysis
Hi Harry and 
Brandon,
 
Here's our setup for a 
60 users environment: 
 
1 
AOS
Dual 1.3 
Ghz
1 gig 
RAM
 
1 DB 
Server
Dual 1.3 
Ghz
3 gig 
RAM
DB : 4 SCSI disks Raid 
10
Log : 2 SCSI disks 
Mirror
OS : 2 SCSI disks 
Mirror
 
Brandon : 

We're already did a 
review from the ground up and added some RAM to our DB server and now the 
sqlserver uses 1.7 gig and there's always 1gig available.  The real 
bottleneck we've found is the Read on our DB disks.  When looking at the 
windows performance tool we can see "Avg. Disk Read Queue Length" hitting real 
high for long period of time.  I'm guessing some querys uses Table 
Scan.  That's why I wanted to reduce read by reviewing bad queries in the 
code.  Our DB disk setup with pretty much the best we can do before going 
on a SAN.  Our AOS seems at ease with the work load.  That's why I'm 
now arrived at step 4, looking at the code.
 
Harry : 

No specific place in 
Axapta.  What I want to do is reduced Table Scan globally and minimize 
blocking.  For blocking I will start to look at custom process that does a 
lot of inventory transfer in 1 long transaction and try to split it up.  
Blocking here is a major pain.  It can happen 3 times a day 
sometimes.  They usually resolve themselves out but the more it takes time, 
the more people get blocked.
 
Finally, I'm using the 
SQL Profiler to check query with long duration.  Sometimes, when I see 
lines like : 
exec sp_cursorexecute 
241, @P1 output, @P2 output, @P3 output, @P4 output, 'boa', 0, 0, 'boa', 
'596965'
How can I know the 
query that is executed?
 
Thanks for reading 
thru,
Regards,



Steeve... 

 
-Message 
d'origine-De : 
Axapta-Knowledge-Village@yahoogroups.com 
[mailto:[EMAIL PROTECTED] De la part de Brandon GeorgeEnvoyé : 20 octobre 2005 
07:54À : 
Axapta-Knowledge-Village@yahoogroups.comObjet : RE: [Axapta-Knowledge-Village] 
Performance analysis
 
Steve,
 
 The improvement of performance, for 
any system, starts always at the bottom level. So I would do the 
following:
 
(1) Can you improve your system through 
hardware? (ex: increase RAM, CPU, Speed of Hard Drives, etc.)
(2) Can you increase performance at the 
Database level? (ex: RAM of SQL server, SQL server AWE configuration, Multiple 
Processors, un-needed performance drags by Non-Axapta Queries., 
clustering.)
(3) Can you increase performance at the 
Business level? (ex: have two AOS server for load balance, 
etc.)
(4) Can you increase performance through 
code? (ex: making sure Axapta-SQL statements make use of Indices, review l

RE : [Axapta-Knowledge-Village] Performance analysis

[Steeve Gilbert]

I'll transfert that to
my sysadmin and my manager to let them know what to do if they want a kick ass
server. J

 

To tell you the truth, I
didn't know what AWE was until this week.  So I've looked for information:

http://www.sql-server-performance.com/awe_memory.asp

Since we have Windows 2000
Server and SQL Server 2000 Standard Edition, If I enable AWE, can I expect my
SQL Server to go up to 2G?  How do I know If SQL Server really needs more RAM?







Steeve... 







 

-Message d'origine-
De :
Axapta-Knowledge-Village@yahoogroups.com
[mailto:[EMAIL PROTECTED] De la part de Brandon George
Envoyé : 20 octobre 2005
12:40
À :
Axapta-Knowledge-Village@yahoogroups.com
Objet : RE:
[Axapta-Knowledge-Village] Performance analysis

 

I have to say Steve, we are on an HP San, Fiber Channels, and
all, and it kicks major butt! I recommend it to anyone, MSA 1000 (Now the MSA
1500).

 

We have the SQL Server clustered for Fail over, and we have
some issues when we first started. Of course using SQL Profiler showed us that
we had Non Axapta Queries taking a while. We analyzed them, improved them, then
we also upped out RAM to 3 Gig. You must also realize that SQL server will not
go beyond the 1.7 you are at unless AWE is enabled, and the 3 Gig. Switch is
used (you can search MSDN for how to do this). This will allow SQL server more
room to use in RAM. 

 

As for knowing what Query that is... I wish I knew of a way
because then you could really do some fine tunning within Axapta. If you find
that out please let me know!

 

-Brandon

 

 

 







From:
Axapta-Knowledge-Village@yahoogroups.com
[mailto:[EMAIL PROTECTED] On Behalf Of Steeve Gilbert
Sent: Thursday, October 20, 2005
10:49 AM
To:
Axapta-Knowledge-Village@yahoogroups.com
Subject: RE :
[Axapta-Knowledge-Village] Performance analysis

Hi Harry and Brandon,

 

Here's our setup for a
60 users environment: 

 

1 AOS

Dual 1.3 Ghz

1 gig RAM

 

1 DB Server

Dual 1.3 Ghz

3 gig RAM

DB : 4 SCSI disks Raid
10

Log : 2 SCSI disks
Mirror

OS : 2 SCSI disks Mirror

 

Brandon : 

We're already did a review
from the ground up and added some RAM to our DB server and now the sqlserver
uses 1.7 gig and there's always 1gig available.  The real bottleneck we've
found is the Read on our DB disks.  When looking at the windows
performance tool we can see "Avg. Disk Read Queue Length" hitting
real high for long period of time.  I'm guessing some querys uses Table
Scan.  That's why I wanted to reduce read by reviewing bad queries in the
code.  Our DB disk setup with pretty much the best we can do before going
on a SAN.  Our AOS seems at ease with the work load.  That's why I'm
now arrived at step 4, looking at the code.

 

Harry : 

No specific place in
Axapta.  What I want to do is reduced Table Scan globally and minimize
blocking.  For blocking I will start to look at custom process that does a
lot of inventory transfer in 1 long transaction and try to split it up. 
Blocking here is a major pain.  It can happen 3 times a day
sometimes.  They usually resolve themselves out but the more it takes time,
the more people get blocked.

 

Finally, I'm using the
SQL Profiler to check query with long duration.  Sometimes, when I see
lines like : 

exec sp_cursorexecute
241, @P1 output, @P2 output, @P3 output, @P4 output, 'boa', 0, 0, 'boa',
'596965'

How can I know the query
that is executed?

 

Thanks for reading thru,

Regards,







Steeve... 







 

-Message d'origine-
De :
Axapta-Knowledge-Village@yahoogroups.com
[mailto:[EMAIL PROTECTED] De la part de Brandon George
Envoyé : 20 octobre 2005
07:54
À : Axapta-Knowledge-Village@yahoogroups.com
Objet : RE:
[Axapta-Knowledge-Village] Performance analysis

 

Steve,

 

 The improvement of performance, for any system, starts
always at the bottom level. So I would do the following:

 

(1) Can you improve your system through hardware? (ex:
increase RAM, CPU, Speed of Hard Drives, etc.)

(2) Can you increase performance at the Database level? (ex:
RAM of SQL server, SQL server AWE configuration, Multiple Processors, un-needed
performance drags by Non-Axapta Queries., clustering.)

(3) Can you increase performance at the Business level? (ex:
have two AOS server for load balance, etc.)

(4) Can you increase performance through code? (ex: making
sure Axapta-SQL statements make use of Indices, review large chunks of code and
break them down into more efficient functional blocks of code, etc.)

 

This is how I would approach it... from the ground up, not
the other way around.

 

-Brandon

 







From:
Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED]
On Behalf Of Steeve Gilbert
Sent: Wednesday, October 19, 2005
9:15 AM
To:
Axapta-Knowledge-Village@yahoogroups.com
Subject:
[Axapta-Knowledge-Village] Performance analysis

Hi everyone,

 

  I'm currently looking at ways to improve
performance of our installation.  When looking thru menus I stumble upon
"Performance analysis" in Ad

RE: [Axapta-Knowledge-Village] Performance analysis

[Brandon George]

I have to say Steve, we are on an HP San, Fiber Channels, 
and all, and it kicks major butt! I recommend it to anyone, MSA 1000 (Now the 
MSA 1500).
 
We have the SQL Server clustered for Fail over, and we have 
some issues when we first started. Of course using SQL Profiler showed us that 
we had Non Axapta Queries taking a while. We analyzed them, improved them, then 
we also upped out RAM to 3 Gig. You must also realize that SQL server will not 
go beyond the 1.7 you are at unless AWE is enabled, and the 3 Gig. Switch is 
used (you can search MSDN for how to do this). This will allow SQL server more 
room to use in RAM. 
 
As for knowing what Query that is... I wish I knew of a way 
because then you could really do some fine tunning within Axapta. If you find 
that out please let me know!
 
-Brandon
 
 


From: Axapta-Knowledge-Village@yahoogroups.com 
[mailto:[EMAIL PROTECTED] On Behalf Of Steeve 
GilbertSent: Thursday, October 20, 2005 10:49 AMTo: 
Axapta-Knowledge-Village@yahoogroups.comSubject: RE : 
[Axapta-Knowledge-Village] Performance analysis


Hi Harry and 
Brandon,
 
Here's our setup for a 
60 users environment: 
 
1 
AOS
Dual 1.3 
Ghz
1 gig 
RAM
 
1 DB 
Server
Dual 1.3 
Ghz
3 gig 
RAM
DB : 4 SCSI disks Raid 
10
Log : 2 SCSI disks 
Mirror
OS : 2 SCSI disks 
Mirror
 
Brandon : 
We're already did a 
review from the ground up and added some RAM to our DB server and now the 
sqlserver uses 1.7 gig and there's always 1gig available.  The real 
bottleneck we've found is the Read on our DB disks.  When looking at the 
windows performance tool we can see "Avg. Disk Read Queue Length" hitting real 
high for long period of time.  I'm guessing some querys uses Table 
Scan.  That's why I wanted to reduce read by reviewing bad queries in the 
code.  Our DB disk setup with pretty much the best we can do before going 
on a SAN.  Our AOS seems at ease with the work load.  That's why I'm 
now arrived at step 4, looking at the code.
 
Harry : 

No specific place in 
Axapta.  What I want to do is reduced Table Scan globally and minimize 
blocking.  For blocking I will start to look at custom process that does a 
lot of inventory transfer in 1 long transaction and try to split it up.  
Blocking here is a major pain.  It can happen 3 times a day 
sometimes.  They usually resolve themselves out but the more it takes time, 
the more people get blocked.
 
Finally, I'm using the 
SQL Profiler to check query with long duration.  Sometimes, when I see 
lines like : 
exec sp_cursorexecute 
241, @P1 output, @P2 output, @P3 output, @P4 output, 'boa', 0, 0, 'boa', 
'596965'
How can I know the 
query that is executed?
 
Thanks for reading 
thru,
Regards,



Steeve... 

 
-Message 
d'origine-De : 
Axapta-Knowledge-Village@yahoogroups.com 
[mailto:[EMAIL PROTECTED] De la part de Brandon GeorgeEnvoyé : 20 octobre 2005 
07:54À : 
Axapta-Knowledge-Village@yahoogroups.comObjet : RE: [Axapta-Knowledge-Village] 
Performance analysis
 
Steve,
 
 The improvement of performance, for 
any system, starts always at the bottom level. So I would do the 
following:
 
(1) Can you improve your system through 
hardware? (ex: increase RAM, CPU, Speed of Hard Drives, etc.)
(2) Can you increase performance at the 
Database level? (ex: RAM of SQL server, SQL server AWE configuration, Multiple 
Processors, un-needed performance drags by Non-Axapta Queries., 
clustering.)
(3) Can you increase performance at the 
Business level? (ex: have two AOS server for load balance, 
etc.)
(4) Can you increase performance through 
code? (ex: making sure Axapta-SQL statements make use of Indices, review large 
chunks of code and break them down into more efficient functional blocks of 
code, etc.)
 
This is how I would approach it... from the 
ground up, not the other way around.
 
-Brandon
 



From: 
Axapta-Knowledge-Village@yahoogroups.com 
[mailto:[EMAIL PROTECTED] On Behalf Of Steeve GilbertSent: Wednesday, 
October 19, 2005 9:15 
AMTo: 
Axapta-Knowledge-Village@yahoogroups.comSubject: [Axapta-Knowledge-Village] 
Performance analysis
Hi everyone,
 
  I'm currently looking at 
ways to improve performance of our installation.  When looking thru menus I 
stumble upon "Performance analysis" in Administration -> Performance test 
wizard.  I've run it in our Dev environment to see what it does and the 
result was just an info box with the name of some forms.  What does it do 
and where are the result of that analysis?
 
  Btw, if you have any hints 
at where to look to improve performance/minimize blocking (software way) besides 
maximizing the use of index, let me know.
 
Have a nice day,


Steeve... 

 





Sharing the knowledge on Axapta.








  
  
SPONSORED LINKS
  
  
  

Business finance course
  
  
Business to business finance
  
  
Small business finance
  
  


Bu

Re: [Axapta-Knowledge-Village] Creating Report 2 pages in a page ( Urgent )

[DIEGO MARIANO GAGLIANO]

 
Hi
 
I think the easy way to do this is create 2 variables, and update one to other when you change the record. When you fill both send to display (use programmableSection).
Gokhan Can <[EMAIL PROTECTED]> wrote:









 
Hi ;
 
I am trying to create a report which break sone page into two and 
Writes lines into first half page and then the rest into second 
Half page.
 
Is there any way to do this in Axapta ?
 
 1 st line    N+1 st line
 2 nd line   N+2 nd line
 3 rd line   …
 …    …
 …    …
 N th line 
 
 
 
Can anybody give an idea about this?
 
Gokhan CAN






Best regards,
 
    Diego Gagliano__Do You Yahoo!?Tired of spam?  Yahoo! Mail has the best spam protection around http://mail.yahoo.com 





Sharing the knowledge on Axapta.








  
  
SPONSORED LINKS
  
  
  

Business finance course
  
  
Business to business finance
  
  
Small business finance
  
  


Business finance consultant
  
  
Business finance magazine
  
  
Business finance schools
  
  

   
  







  
  
  YAHOO! GROUPS LINKS



   Visit your group "Axapta-Knowledge-Village" on the web. 
   To unsubscribe from this group, send an email to: [EMAIL PROTECTED] 
   Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



  









gifbWx1Du8Vit.gif
Description: GIF image


gifUiV5IC94Qi.gif
Description: GIF image

[Axapta-Knowledge-Village] Creating Report 2 pages in a page ( Urgent )

[Gokhan Can]

 

Hi ;

 

I am trying to create a report which break
sone page into two and 

Writes lines into first half page and then
the rest into second 

Half page.

 

Is there any way to do this in Axapta ?




 
  
  
  
  
  
  
 
 
  
  
  
  
  
  
 


 



 1 st line    N+1 st line

 2 nd line   N+2 nd line

 3 rd line   …

 …    …

 …    …

 N th line 

 

 

 

Can anybody give an idea about this?

 

Gokhan CAN










Sharing the knowledge on Axapta.








  
  
SPONSORED LINKS
  
  
  

Business finance course
  
  
Business to business finance
  
  
Small business finance
  
  


Business finance consultant
  
  
Business finance magazine
  
  
Business finance schools
  
  

   
  







  
  
  YAHOO! GROUPS LINKS



   Visit your group "Axapta-Knowledge-Village" on the web. 
   To unsubscribe from this group, send an email to: [EMAIL PROTECTED] 
   Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



  

RE : [Axapta-Knowledge-Village] Performance analysis

[Steeve Gilbert]

Hi Harry and Brandon,

 

Here's our setup for a
60 users environment: 

 

1 AOS

Dual 1.3 Ghz

1 gig RAM

 

1 DB Server

Dual 1.3 Ghz

3 gig RAM

DB : 4 SCSI disks Raid
10

Log : 2 SCSI disks
Mirror

OS : 2 SCSI disks Mirror

 

Brandon : 

We're already did a
review from the ground up and added some RAM to our DB server and now the sqlserver
uses 1.7 gig and there's always 1gig available.  The real bottleneck we've
found is the Read on our DB disks.  When looking at the windows performance
tool we can see "Avg. Disk Read Queue Length" hitting real high for
long period of time.  I'm guessing some querys uses Table Scan.  That's why I
wanted to reduce read by reviewing bad queries in the code.  Our DB disk setup
with pretty much the best we can do before going on a SAN.  Our AOS seems at
ease with the work load.  That's why I'm now arrived at step 4, looking at the
code.

 

Harry : 

No specific place in
Axapta.  What I want to do is reduced Table Scan globally and minimize
blocking.  For blocking I will start to look at custom process that does a lot
of inventory transfer in 1 long transaction and try to split it up.  Blocking
here is a major pain.  It can happen 3 times a day sometimes.  They usually
resolve themselves out but the more it takes time, the more people get blocked.

 

Finally, I'm using the SQL
Profiler to check query with long duration.  Sometimes, when I see lines like :


exec sp_cursorexecute 241,
@P1 output, @P2 output, @P3 output, @P4 output, 'boa', 0, 0, 'boa', '596965'

How can I know the query
that is executed?

 

Thanks for reading thru,

Regards,







Steeve... 







 

-Message d'origine-
De :
Axapta-Knowledge-Village@yahoogroups.com
[mailto:[EMAIL PROTECTED] De la part de Brandon George
Envoyé : 20 octobre 2005
07:54
À :
Axapta-Knowledge-Village@yahoogroups.com
Objet : RE:
[Axapta-Knowledge-Village] Performance analysis

 

Steve,

 

 The improvement of performance, for any system, starts
always at the bottom level. So I would do the following:

 

(1) Can you improve your system through hardware? (ex:
increase RAM, CPU, Speed of Hard Drives, etc.)

(2) Can you increase performance at the Database level? (ex:
RAM of SQL server, SQL server AWE configuration, Multiple Processors, un-needed
performance drags by Non-Axapta Queries., clustering.)

(3) Can you increase performance at the Business level? (ex:
have two AOS server for load balance, etc.)

(4) Can you increase performance through code? (ex: making
sure Axapta-SQL statements make use of Indices, review large chunks of code and
break them down into more efficient functional blocks of code, etc.)

 

This is how I would approach it... from the ground up, not
the other way around.

 

-Brandon

 







From:
Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED]
On Behalf Of Steeve Gilbert
Sent: Wednesday,
 October 19, 2005 9:15
 AM
To:
Axapta-Knowledge-Village@yahoogroups.com
Subject:
[Axapta-Knowledge-Village] Performance analysis

Hi everyone,

 

  I'm currently looking at ways to improve
performance of our installation.  When looking thru menus I stumble upon
"Performance analysis" in Administration -> Performance test
wizard.  I've run it in our Dev environment to see what it does and the
result was just an info box with the name of some forms.  What does it do
and where are the result of that analysis?

 

  Btw, if you have any hints at where to look
to improve performance/minimize blocking (software way) besides maximizing the
use of index, let me know.

 

Have a nice day,





Steeve... 





 









Sharing the knowledge on Axapta.





  




  
  
  YAHOO! GROUPS LINKS



   Visit your group "Axapta-Knowledge-Village" on the web. 
   To unsubscribe from this group, send an email to: [EMAIL PROTECTED] 
   Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



  

[Axapta-Knowledge-Village] Import / Export of XPO files

[mohit rajvanshy]

Hi All,

In Axapta 3.0 is there any way to import the .xpo and
.cfg files without login into the axapta. Will it be
possible through command line?

I know that it is possible in axapta 4.0

Thanks in advance
Mohit



Regards
Mohit Rajvanshy





__ 
Yahoo! Mail - PC Magazine Editors' Choice 2005 
http://mail.yahoo.com


 Yahoo! Groups Sponsor ~--> 
Get fast access to your favorite Yahoo! Groups. Make Yahoo! your home page
http://us.click.yahoo.com/dpRU5A/wUILAA/yQLSAA/kGEolB/TM
~-> 

Sharing the knowledge on Axapta. 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/Axapta-Knowledge-Village/

<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
 

Re: [Axapta-Knowledge-Village]

[Girish Bhatkal]

its alright for you to use the SP4 client to run Sp3
or lower level applications/servers. But you should
not connect Sp3 client to Sp4 application.

--- Alessandro Ghidini <[EMAIL PROTECTED]> wrote:

> Hi group.. I'd like to install two different Axapta
> service packs on the
> same computer.. Basically i need an sp3 client for a
> 3 level connection to
> an sp3 server and an sp4 installation on my pc for
> testing purposes.
> 
>  
> 
> If i try to make a new Axapta client installation on
> my pc, installer
> recognizes the old installation and tries to use
> that for repairing or
> changing.. So i can install a new client..
> 
>  
> 
> Any suggestion? Thanks in advance.
> 
>  
> 
> Alessandro
> 
>  
> 
>  
> 
>  
> 
> Ghidini Ing. Alessandro
> 
> Kibuz SRL
> 
> Galleria Ludovico Mortara, 2 - 46100 - Mantova
> 
> Telefono: +39 0376 220605
> 
> Fax: +39 0376 367439
> 
> Email:   [EMAIL PROTECTED]
> 
>  
> 
> 






___ 
Yahoo! Messenger - NEW crystal clear PC to PC calling worldwide with voicemail 
http://uk.messenger.yahoo.com


 Yahoo! Groups Sponsor ~--> 
Get fast access to your favorite Yahoo! Groups. Make Yahoo! your home page
http://us.click.yahoo.com/dpRU5A/wUILAA/yQLSAA/kGEolB/TM
~-> 

Sharing the knowledge on Axapta. 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/Axapta-Knowledge-Village/

<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
 

RE : [Axapta-Knowledge-Village] Re: X++ Control Manipulation (Processing)

[Steeve Gilbert]

Maybe my question is too simple but...  Are the control's AutoDeclaration 
property set to Yes?

Steeve... 


-Message d'origine-
De : Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] De la 
part de rashwannewsletters
Envoyé : 20 octobre 2005 03:32
À : Axapta-Knowledge-Village@yahoogroups.com
Objet : [Axapta-Knowledge-Village] Re: X++ Control Manipulation (Processing)

Actually yes. Z is a control of type real and so are x and Y but the 
compiler refuses to use funcation realvalue with any control x, y and 
Z. 
e.g.I say print print x.realvalue() it gives error field is not part of 
table, when I say print x it gives error undefined variable x.






Sharing the knowledge on Axapta. 
Yahoo! Groups Links



 






 Yahoo! Groups Sponsor ~--> 
Get fast access to your favorite Yahoo! Groups. Make Yahoo! your home page
http://us.click.yahoo.com/dpRU5A/wUILAA/yQLSAA/kGEolB/TM
~-> 

Sharing the knowledge on Axapta. 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/Axapta-Knowledge-Village/

<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
 

AW: [Axapta-Knowledge-Village] report looks fine on screen, but last line missing from paper

[Jim Dickie]

Title: Papier mit Absender










Did
you view on screen using the same printer as for printing to paper?  Changing the printer between
viewing and printing kann cause problems.  

 



Mit freundlichen Grüssen / kind regards,
Jim Dickie, 
Circon Circle Consulting GmbH,
Färbergasse 13, A-6850 DORNBIRN
e-mail: [EMAIL PROTECTED]
phone: +43 (0)664 2337785 



-Ursprüngliche Nachricht-
Von:
Axapta-Knowledge-Village@yahoogroups.com
[mailto:[EMAIL PROTECTED] Im Auftrag von nabilwilson
Gesendet: Mittwoch, 19. Oktober
2005 15:09
An: Axapta-Knowledge-Village@yahoogroups.com
Betreff:
[Axapta-Knowledge-Village] report looks fine on screen, but last line missing
from paper

 

Hello,

I have a bit stranger problem with printing.
Problem "appeared" a month ago, only for
few
reports (e.g. invoice). Printout look fine
on the screen, but when I print it to printer,
the last line is missing. 

I think the problem is not with margins, because
if I change the layout from portrait to landscape,
the last row of the report is still missing. 

I have tested this with two different printers,
but
problem still exists.

Has anyone experienced the same problem?












Sharing the knowledge on Axapta.








  
  
SPONSORED LINKS
  
  
  

Business finance course
  
  
Business to business finance
  
  
Small business finance
  
  


Business finance consultant
  
  
Business finance magazine
  
  
Business finance schools
  
  

   
  







  
  
  YAHOO! GROUPS LINKS



   Visit your group "Axapta-Knowledge-Village" on the web. 
   To unsubscribe from this group, send an email to: [EMAIL PROTECTED] 
   Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



  

















 








 
  
   
  
 

RE: [Axapta-Knowledge-Village] Performance analysis

[Brandon George]

Steve,
 
 The improvement of performance, for any system, 
starts always at the bottom level. So I would do the 
following:
 
(1) Can you improve your system through hardware? (ex: 
increase RAM, CPU, Speed of Hard Drives, etc.)
(2) Can you increase performance at the Database level? 
(ex: RAM of SQL server, SQL server AWE configuration, Multiple Processors, 
un-needed performance drags by Non-Axapta Queries., 
clustering.)
(3) Can you increase performance at the Business level? 
(ex: have two AOS server for load balance, etc.)
(4) Can you increase performance through code? (ex: making 
sure Axapta-SQL statements make use of Indices, review large chunks of code and 
break them down into more efficient functional blocks of code, 
etc.)
 
This is how I would approach it... from the ground up, not 
the other way around.
 
-Brandon


From: Axapta-Knowledge-Village@yahoogroups.com 
[mailto:[EMAIL PROTECTED] On Behalf Of Steeve 
GilbertSent: Wednesday, October 19, 2005 9:15 AMTo: 
Axapta-Knowledge-Village@yahoogroups.comSubject: 
[Axapta-Knowledge-Village] Performance analysis


Hi everyone,
 
  I'm currently looking at 
ways to improve performance of our installation.  When looking thru menus I 
stumble upon "Performance analysis" in Administration -> Performance test 
wizard.  I've run it in our Dev environment to see what it does and the 
result was just an info box with the name of some forms.  What does it do 
and where are the result of that analysis?
 
  Btw, if you have any hints 
at where to look to improve performance/minimize blocking (software way) besides 
maximizing the use of index, let me know.
 
Have a nice day,


Steeve... 

 





Sharing the knowledge on Axapta.








  
  
SPONSORED LINKS
  
  
  

Business finance course
  
  
Business to business finance
  
  
Small business finance
  
  


Business finance consultant
  
  
Business finance magazine
  
  
Business finance schools
  
  

   
  







  
  
  YAHOO! GROUPS LINKS



   Visit your group "Axapta-Knowledge-Village" on the web. 
   To unsubscribe from this group, send an email to: [EMAIL PROTECTED] 
   Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



  

[Axapta-Knowledge-Village]

[Alessandro Ghidini]

Hi group.. I’d like to install two different Axapta service
packs on the same computer.. Basically i need an sp3 client for a 3 level
connection to an sp3 server and an sp4 installation on my pc for testing
purposes.

 

If i try to make a new Axapta client installation on my pc,
installer recognizes the old installation and tries to use that for repairing
or changing.. So i can install a new client..

 

Any suggestion? Thanks in advance.

 

Alessandro

 

 

 

Ghidini Ing. Alessandro

Kibuz SRL

Galleria Ludovico Mortara, 2 - 46100 - Mantova

Telefono: +39 0376 220605

Fax: +39 0376 367439

Email: [EMAIL PROTECTED]

 









Sharing the knowledge on Axapta.





  




  
  
  YAHOO! GROUPS LINKS



   Visit your group "Axapta-Knowledge-Village" on the web. 
   To unsubscribe from this group, send an email to: [EMAIL PROTECTED] 
   Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



  

Re: [Axapta-Knowledge-Village] How to create blanket purch order from master planning planned orders

[lukas nugroho]

dear Hardi,

if you want to generate Blanket order from master
planning, i think you can't because the default for
firming from Master Planning is Purchase order. If you
want to firm planned Purchase order become Blanket
Order, you must do it from Purchase Order. First, you
create Blanket Order then you chose Setup --> Planned
Purchase Order than you firm it

lukas nugroho putro


--- Hardi <[EMAIL PROTECTED]> wrote:

> Dear all
> I want to create blanket purchase order from
> "firming" function in the 
> planned orders.
> I thried to set up via AP parameter and set the
> default Purchase Order 
> type = Blanket Order, but it doesn't affect the PO
> generated from 
> firming Planned Orders.
> 
> The reason for doing that is because I want to send
> a "big" qty 
> purchase order to the vendor and then later on I
> want to release the 
> qty by certain period i.e weekly.
> 
> How to do it?
> 
> Thanks & regards
> 
> Hardi T
> 
> 
> 
> 




__ 
Yahoo! Music Unlimited 
Access over 1 million songs. Try it free.
http://music.yahoo.com/unlimited/


 Yahoo! Groups Sponsor ~--> 
Get fast access to your favorite Yahoo! Groups. Make Yahoo! your home page
http://us.click.yahoo.com/dpRU5A/wUILAA/yQLSAA/kGEolB/TM
~-> 

Sharing the knowledge on Axapta. 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/Axapta-Knowledge-Village/

<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
 

RE: [Axapta-Knowledge-Village] Financial Statement Setup

[Tany, Yuliana]

The solution is whether you have to use
the Insert Account Button or create the line, insert the account and save it.

When you save, system will bring the
Total from the Ledger Account.

You don't have to redefine it
again.

 

Yuliana

 

-Original Message-
From: Axapta-Knowledge-Village@yahoogroups.com
[mailto:[EMAIL PROTECTED] On Behalf Of Axa Cons
Sent: Thursday, October 20, 2005
3:48 PM
To:
Axapta-Knowledge-Village@yahoogroups.com
Subject: Re:
[Axapta-Knowledge-Village] Financial Statement Setup

 



Hi Yuliana,





 





I checked your problem you are right. The solution is
to use "Insert Accounts" button. If you insert accounts with this,
the total setup comes with the accounts.





 





Otherwise you have to redefine the totals .





Best Regards,







"Tany,
Yuliana" <[EMAIL PROTECTED]> wrote:





Hi All

 

Just want to have a quick check J

 

For example:

We have an account 100 in Ledger
Account, with Account type total (101-103)

When we create the Financial
Statement Row and insert this account (100), Axapta won't automatically take
the total from the Ledger Account.

So we need to define the Total
again in Financial Statement Row Setup.

Is there any way to copy
automatically (the Total) from the Ledger Account.

 

Thanks,

Yuliana

 









Yahoo!
Music Unlimited - Access over 1 million songs. Try it free. 







Sharing the knowledge on Axapta.








  
  
SPONSORED LINKS
  
  
  

Business finance course
  
  
Business to business finance
  
  
Small business finance
  
  


Business finance consultant
  
  
Business finance magazine
  
  
Business finance schools
  
  

   
  







  
  
  YAHOO! GROUPS LINKS



   Visit your group "Axapta-Knowledge-Village" on the web. 
   To unsubscribe from this group, send an email to: [EMAIL PROTECTED] 
   Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



  

Re: [Axapta-Knowledge-Village] Urgent : How to upload data to generate Sales orders

[lukas nugroho]

Dear preety,

to create sales order form excel, you need to use
SalesTable and SalesLines only. You ought to fill the
requirement field (yellow field). do not change or
delete some field on excel regenerated from axapta.
hope it helps

--- Priyank Krishna <[EMAIL PROTECTED]> wrote:

> Thanks for reponse !
>  
> I have used existing Excel template Import
> functionality for creating sales orders but could
> not succeed.
>  
> you please tell me correct format.I used
> SalesTable,SalesLine,InventDim what else is
> remaining into it.
>  
> Your response is waited
> 
> Hemant Kumthekar <[EMAIL PROTECTED]> wrote:
> Hi,
>  
> You may like to create the Excel spreadsheet from
> Axapta  Administration>>Periodic>>Data export/Import
> >> Excel Spreadsheet.  I have upload sales orders &
> Lines using the same technique, quite simple. If you
> need the format let me know.
>  
> Hemant
> 
> Priyank Krishna <[EMAIL PROTECTED]> wrote:
> Can anyone please tell me the way to upload data in
> SalesTable & SalesLine with the purpose of creating
> Sales orders.
>  
> Any responses are welcome.
>  
> Cheers,
> Preety
> 
> 
> -
> Yahoo! India Matrimony: Find your partner now. 
> 
> -
> Yahoo! Music Unlimited - Access over 1 million
> songs. Try it free. 
> 
> Sharing the knowledge on Axapta. 
> 
> 
> 
> -
> YAHOO! GROUPS LINKS 
> 
> 
> Visit your group "Axapta-Knowledge-Village" on
> the web.
>   
> To unsubscribe from this group, send an email
> to:
> 
> [EMAIL PROTECTED]
>   
> Your use of Yahoo! Groups is subject to the
> Yahoo! Terms of Service. 
> 
> 
> -
> 
> 
> 
>   
> -
>  Yahoo! India Matrimony: Find your partner now.





__ 
Yahoo! Mail - PC Magazine Editors' Choice 2005 
http://mail.yahoo.com


 Yahoo! Groups Sponsor ~--> 
Help tsunami villages rebuild at GlobalGiving. The real work starts now.
http://us.click.yahoo.com/njNroD/KbOLAA/cosFAA/kGEolB/TM
~-> 

Sharing the knowledge on Axapta. 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/Axapta-Knowledge-Village/

<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
 

RE: [Axapta-Knowledge-Village] Security rights not effective!

[lukas nugroho]

Dear James,

I have a same problem sometimes ago, and our solution
that time, we import security setting again and it
works.

lukas nugroho

--- James Flavell <[EMAIL PROTECTED]> wrote:

> Thanks Harry and Steve,
>  
> Reboot not help...I think I have stumbled across
> something and will report
> back when can make sense of it
>  
> Has noone had problems of a new VAR layer being put
> in causing loss or
> corruption of permission settings?
>  
> THanks
> James
> 
> -Original Message-
> From: Axapta-Knowledge-Village@yahoogroups.com
> [mailto:[EMAIL PROTECTED] On
> Behalf Of Harry
> (Harshawardhan Deshpande
> Sent: 20 October 2005 16:12
> To: Axapta-Knowledge-Village@yahoogroups.com
> Subject: Re: [Axapta-Knowledge-Village] Security
> rights not effective!
> 
> 
> hi James
>  
> reboot your server and check if it has the desired
> effect.
>  
> regards
>  
> harry
> 
> James Flavell <[EMAIL PROTECTED]> wrote:
> 
> Hi
>  
> Can anyone tell me have you had problems with
> security settings being set
> but when the user login they can do things that in
> security are disabled?
>  
> A few things I think might be causing this:
> 1) Change of VAR layer after security rights set
> 2) Bug in Axapta with security on elements in VAR or
> USR layer
>  
> BTW I am using domains...
>  
> The security settings are stored in the DB or one of
> the axapta appl files?
> How come I can only see std Axapta elemnts in the
> 'Security' lookup inside
> permissions (i.e. have to select 'Main menu' in
> order to see and set
> security rights for new elements I have created)?
>  
> Thanks
> James
>  
> 
> 
> 
>   _  
> 
> Yahoo!
>
 om/unlimited/> Music Unlimited - Access over 1
> million songs. Try it free. 
> 
> Sharing the knowledge on Axapta. 
> 
> 
> 
>   _  
> 
> YAHOO! GROUPS LINKS 
> 
> 
>   
> *  Visit your group "Axapta-Knowledge-Village
>

> " on the web.
>   
> 
> *  To unsubscribe from this group, send an email to:
> 
> [EMAIL PROTECTED]
>
 ribe> 
>   
> 
> *  Your use of Yahoo! Groups is subject to the
> Yahoo! Terms of Service
>  . 
> 
> 
>   _  
> 
> 
> 




__ 
Yahoo! Music Unlimited 
Access over 1 million songs. Try it free.
http://music.yahoo.com/unlimited/


 Yahoo! Groups Sponsor ~--> 
Put more honey in your pocket. (money matters made easy).
http://us.click.yahoo.com/r7D80C/dlQLAA/cosFAA/kGEolB/TM
~-> 

Sharing the knowledge on Axapta. 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/Axapta-Knowledge-Village/

<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
 

Re: [Axapta-Knowledge-Village] Financial Statement Setup

[Axa Cons]

Hi Yuliana,
 
I checked your problem you are right. The solution is to use "Insert Accounts" button. If you insert accounts with this, the total setup comes with the accounts.
 
Otherwise you have to redefine the totals .
Best Regards,
"Tany, Yuliana" <[EMAIL PROTECTED]> wrote:







Hi All
 
Just want to have a quick check J
 
For example:
We have an account 100 in Ledger Account, with Account type total (101-103)
When we create the Financial Statement Row and insert this account (100), Axapta won't automatically take the total from the Ledger Account.
So we need to define the Total again in Financial Statement Row Setup.
Is there any way to copy automatically (the Total) from the Ledger Account.
 
Thanks,
Yuliana
 
		 Yahoo! Music Unlimited - Access over 1 million songs. Try it free.





Sharing the knowledge on Axapta.








  
  
SPONSORED LINKS
  
  
  

Business finance course
  
  
Business to business finance
  
  
Small business finance
  
  


Business finance consultant
  
  
Business finance magazine
  
  
Business finance schools
  
  

   
  







  
  
  YAHOO! GROUPS LINKS



   Visit your group "Axapta-Knowledge-Village" on the web. 
   To unsubscribe from this group, send an email to: [EMAIL PROTECTED] 
   Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



  

[Axapta-Knowledge-Village] Re: X++ Control Manipulation (Processing)

[rashwannewsletters]

Actually yes. Z is a control of type real and so are x and Y but the 
compiler refuses to use funcation realvalue with any control x, y and 
Z. 
e.g.I say print print x.realvalue() it gives error field is not part of 
table, when I say print x it gives error undefined variable x.





 Yahoo! Groups Sponsor ~--> 
Put more honey in your pocket. (money matters made easy).
http://us.click.yahoo.com/r7D80C/dlQLAA/cosFAA/kGEolB/TM
~-> 

Sharing the knowledge on Axapta. 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/Axapta-Knowledge-Village/

<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
 

[Axapta-Knowledge-Village] How to create blanket purch order from master planning planned orders

[Hardi]

Dear all
I want to create blanket purchase order from "firming" function in the 
planned orders.
I thried to set up via AP parameter and set the default Purchase Order 
type = Blanket Order, but it doesn't affect the PO generated from 
firming Planned Orders.

The reason for doing that is because I want to send a "big" qty 
purchase order to the vendor and then later on I want to release the 
qty by certain period i.e weekly.

How to do it?

Thanks & regards

Hardi T





 Yahoo! Groups Sponsor ~--> 
Help Sudanese refugees rebuild their lives through GlobalGiving.
http://us.click.yahoo.com/hjNroD/EbOLAA/cosFAA/kGEolB/TM
~-> 

Sharing the knowledge on Axapta. 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/Axapta-Knowledge-Village/

<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
 

RE: [Axapta-Knowledge-Village] Security rights not effective!

[James Flavell]

Title: Message





Thanks 
Harry and Steve,
 
Reboot 
not help...I think I have stumbled across something and will report back when 
can make sense of it
 
Has 
noone had problems of a new VAR layer being put in causing loss or corruption of 
permission settings?
 
THanks
James

  
  -Original Message-From: 
  Axapta-Knowledge-Village@yahoogroups.com 
  [mailto:[EMAIL PROTECTED] On Behalf Of Harry 
  (Harshawardhan DeshpandeSent: 20 October 2005 16:12To: 
  Axapta-Knowledge-Village@yahoogroups.comSubject: Re: 
  [Axapta-Knowledge-Village] Security rights not effective!
  hi James
   
  reboot your server and check if it has the desired effect.
   
  regards
   
  harryJames Flavell <[EMAIL PROTECTED]> 
  wrote:
  

Hi
 
Can anyone tell me have you had problems with security settings 
being set but when the user login they can do things that in security 
are disabled?
 
A 
few things I think might be causing this:
1) 
Change of VAR layer after security rights set
2) 
Bug in Axapta with security on elements in VAR or USR 
layer
 
BTW I am using domains...
 
The security settings are stored in the DB or one of the axapta appl 
files?
How come I can only see std Axapta elemnts in the 'Security' lookup 
inside permissions (i.e. have to select 'Main menu' in order to see and set 
security rights for new elements I have created)?
 
Thanks
James
 

  
  
  
  Yahoo! 
  Music Unlimited - Access over 1 million songs. Try it free. 





Sharing the knowledge on Axapta.





  




  
  
  YAHOO! GROUPS LINKS



   Visit your group "Axapta-Knowledge-Village" on the web. 
   To unsubscribe from this group, send an email to: [EMAIL PROTECTED] 
   Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



  

Re: [Axapta-Knowledge-Village] Urgent : How to upload data to generate Sales orders

[Priyank Krishna]

Thanks for reponse !
 
I have used existing Excel template Import functionality for creating sales orders but could not succeed.
 
you please tell me correct format.I used SalesTable,SalesLine,InventDim what else is remaining into it.
 
Your response is waitedHemant Kumthekar <[EMAIL PROTECTED]> wrote:

Hi,
 
You may like to create the Excel spreadsheet from Axapta  Administration>>Periodic>>Data export/Import >> Excel Spreadsheet.  I have upload sales orders & Lines using the same technique, quite simple. If you need the format let me know.
 
HemantPriyank Krishna <[EMAIL PROTECTED]> wrote:

Can anyone please tell me the way to upload data in SalesTable & SalesLine with the purpose of creating Sales orders.
 
Any responses are welcome.
 
Cheers,
Preety


Yahoo! India Matrimony: Find your partner now. 


Yahoo! Music Unlimited - Access over 1 million songs. Try it free. 
		 
Yahoo! India Matrimony: Find your partner now.





Sharing the knowledge on Axapta.








  
  
SPONSORED LINKS
  
  
  

Business finance course
  
  
Business to business finance
  
  
Small business finance
  
  


Business finance consultant
  
  
Business finance magazine
  
  
Business finance schools
  
  

   
  







  
  
  YAHOO! GROUPS LINKS



   Visit your group "Axapta-Knowledge-Village" on the web. 
   To unsubscribe from this group, send an email to: [EMAIL PROTECTED] 
   Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



  

[Axapta-Knowledge-Village] Re: report looks fine on screen, but last line missing from paper

[nabilwilson]

Hello,

I have tried A4, Letter and Executive, but unfortunately
it did not help. 

/Nabil


--- In Axapta-Knowledge-Village@yahoogroups.com, Lalith Jayantha 
<[EMAIL PROTECTED]> wrote:
>
> Hi
> 
> are  your printing with letter format ? change it to 
> A4 format and print.
> 
> Lalith
> 
> 
> --- nabilwilson <[EMAIL PROTECTED]> wrote:
> 
> > Hello,
> > 
> > I have a bit stranger problem with printing.
> > Problem "appeared" a month ago, only for few
> > reports (e.g. invoice). Printout look fine
> > on the screen, but when I print it to printer,
> > the last line is missing. 
> > 
> > I think the problem is not with margins, because
> > if I change the layout from portrait to landscape,
> > the last row of the report is still missing. 
> > 
> > I have tested this with two different printers, but
> > problem still exists.
> > 
> > Has anyone experienced the same problem?
> > 
> > 
> > 
> > 
> > 
> 
> 
> 
>   
> __ 
> Yahoo! Music Unlimited 
> Access over 1 million songs. Try it free.
> http://music.yahoo.com/unlimited/
>






 Yahoo! Groups Sponsor ~--> 
Get fast access to your favorite Yahoo! Groups. Make Yahoo! your home page
http://us.click.yahoo.com/dpRU5A/wUILAA/yQLSAA/kGEolB/TM
~-> 

Sharing the knowledge on Axapta. 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/Axapta-Knowledge-Village/

<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
 

Re: [Axapta-Knowledge-Village] Security rights not effective!

[Harry \(Harshawardhan Deshpande]

hi James
 
reboot your server and check if it has the desired effect.
 
regards
 
harryJames Flavell <[EMAIL PROTECTED]> wrote:


Hi
 
Can anyone tell me have you had problems with security settings being set but when the user login they can do things that in security are disabled?
 
A few things I think might be causing this:
1) Change of VAR layer after security rights set
2) Bug in Axapta with security on elements in VAR or USR layer
 
BTW I am using domains...
 
The security settings are stored in the DB or one of the axapta appl files?
How come I can only see std Axapta elemnts in the 'Security' lookup inside permissions (i.e. have to select 'Main menu' in order to see and set security rights for new elements I have created)?
 
Thanks
James
 


		 Yahoo! Music Unlimited - Access over 1 million songs. Try it free.





Sharing the knowledge on Axapta.





  




  
  
  YAHOO! GROUPS LINKS



   Visit your group "Axapta-Knowledge-Village" on the web. 
   To unsubscribe from this group, send an email to: [EMAIL PROTECTED] 
   Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



  

Re: [Axapta-Knowledge-Village] Performance analysis

[Harry \(Harshawardhan Deshpande]

hi Steve
 
is there any specific place where you are looking to improve your peformance?
 
regards
 
harrySteeve Gilbert <[EMAIL PROTECTED]> wrote:





Hi everyone,
 
  I'm currently looking at ways to improve performance of our installation.  When looking thru menus I stumble upon "Performance analysis" in Administration -> Performance test wizard.  I've run it in our Dev environment to see what it does and the result was just an info box with the name of some forms.  What does it do and where are the result of that analysis?
 
  Btw, if you have any hints at where to look to improve performance/minimize blocking (software way) besides maximizing the use of index, let me know.
 
Have a nice day,


Steeve... 
 
		 Yahoo! Music Unlimited - Access over 1 million songs. Try it free.





Sharing the knowledge on Axapta.





  




  
  
  YAHOO! GROUPS LINKS



   Visit your group "Axapta-Knowledge-Village" on the web. 
   To unsubscribe from this group, send an email to: [EMAIL PROTECTED] 
   Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



  

Re: [Axapta-Knowledge-Village] Hi Pals,

[Harry \(Harshawardhan Deshpande]

hi Siva
 
1. in the create method of datasource salestable on form sales table declare the following
 
    FormButtonControl   fcb = element.design().controlName("ButtonLineQuickQuote");
 
2. in the same method paste the following code
 
    tabLineOverview.setFocus(); ** this is existing line    fcb.clicked(); ** paste this line.
 
and you are almost there.
 
cheers
 
harrySiva kumar <[EMAIL PROTECTED]> wrote:

Hi Pals,
 
  I Need to create a salesordercreation wizard with 2 screens. In First screen, It should get the SalesTable information and in the second wizard SalesLine information.if we click the finish button, it should insert records in SalesTable and SalesLine. If anybody come across this type, Please let me know how.
 
 
Thanks & Regards,
Siva

  We Born to Win...


Yahoo! Music Unlimited - Access over 1 million songs. Try it free. 
		 Yahoo! Music Unlimited - Access over 1 million songs. Try it free.





Sharing the knowledge on Axapta.





  




  
  
  YAHOO! GROUPS LINKS



   Visit your group "Axapta-Knowledge-Village" on the web. 
   To unsubscribe from this group, send an email to: [EMAIL PROTECTED] 
   Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.