Re: [development-axapta] Terminal Services and Ms Office Excel & Emailing
Hi.. I'm Pooja ! very new to Axapta .. Please can any body help me ..,I'm looking for "Inside Axpata "Book ... Please send me to [EMAIL PROTECTED] if you have this thanx Pooja India. - Original Message From: olivier_johan <[EMAIL PROTECTED]> To: development-axapta@yahoogroups.com Sent: Monday, 14 January, 2008 7:14:01 PM Subject: [development-axapta] Terminal Services and Ms Office Excel & Emailing Hi All, Please excuse the ignorance or if a similiar question has already been posted. I am fairly new to Dynamics AX and Networking and am busy looking at a proposed architecture for one of our clients. Their network latency is between 13ms and 29ms so according to Microsoft documentation for Dynamics AX we are considering using terminal services. We want to install the Dynamics AX client software on the terminal server and connect to the AOS from there. I am concerned about fact that we also need to develop x++ code to auto email reports from within Dynamic AX as well as to export data to Excel for further user analysis. We might also implement Atlas XL. Do you know if the above scenario will work over terminal services ? I am worried that the Ms Office files will not be usefull unless the users can get it back onto their physical computers and that emailing from the terminal server will not work appropriately. Please shout if you need more detailed information. Any feedback will be greatly appreciated as I have never worked with terminal services and need to advice the client. Thanks a million !! Johan Chat on a cool, new interface. No download required. Go to http://in.messenger.yahoo.com/webmessengerpromo.php [Non-text portions of this message have been removed]
Re: [development-axapta] Re: Clsiter indexes yes or no?
Have you reade this http://msdn2.microsoft.com/en-us/library/aa623224.aspx On 1/14/08, gollywogman <[EMAIL PROTECTED]> wrote: > Hi there > As far as I know, (I could be mistaken) > the best thing to do is to have a cluster index only if a table has > one index, otherwise a table shouldn't have a cluster index. > > --- In development-axapta@yahoogroups.com, James Flavell > <[EMAIL PROTECTED]> wrote: > > > > Should be disable cluster indexes or not in Ax4.0? > > > > I know the pros and cons but my impression is for AX at least we > should turn > > them of until someone in MS takes a good look and think slong and > hard about > > which index is the best as a clsuter index. > > > > Anyone agree/disagree? > > > > Thanks > > James > > > > > > > > [Non-text portions of this message have been removed] > > > > > > > > Yahoo! Groups Links > > > > -- Max Belugin, http://belugin.info , ICQ:9406811, MSN: [EMAIL PROTECTED]
RE: [development-axapta] Bad response time on the CUSTINVOICEJOUR form
Hi If you send a text representation of the query plan that you're getting from this statement and details of any non-standard indexes that are defined on either table I'll see if an obvious solution springs to mind. Regards Malcolm Burtt Touchstone People, Partnerships, Solutions From: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of pkpeterson652 Sent: 09 January 2008 16:32 To: development-axapta@yahoogroups.com Subject: [development-axapta] Bad response time on the CUSTINVOICEJOUR form I have a response time problem with the CUSTINVOICEJOUR form. Accounts receivable \ Sales Orders \ Inquiries \ Invoices This form only has some minor modifications to it and when the mods are removed the same results are given. We are running Dynamics AX 4.0 at SP1, SQL Server 2005, and one AOS. The first time this option is selected it takes anywhere from 1 1/2 to 2 1/2 minutes to come up. Once the form has been opened up this form will come up in 1 to 2 seconds. I understand this because the necessary infomation is probably in the cache for the subsequent queries. I have run SQL trace and have isolated the offending query. I have taken the SQL statement shown in the SQL Trace log into the Database Engine tuning advisor, built and updated the recommended Statistics and built the recommend indexes. There are 166,506 records in the CUSINVOICEJOUR table across all companies and 108,388 records in the CUSTINOICESALESLINK table accross all companies. Any suggestions of what I should look at next? SQL Statement is as follows: SELECT A.CUSTGROUP,A.REFNUM,A.SALESID,A.ORDERACCOUNT,A.INVOICEACCOUNT, A.INVOICEDATE,A.DUEDATE,A.CASHDISC,A.CASHDISCDATE,A.QTY,A.VOLUME, A.WEIGHT,A.SUMLINEDISC,A.SALESBALANCE,A.ENDDISC,A.INVOICEAMOUNT, A.CURRENCYCODE,A.EXCHRATE,A.SALESADMINISTRATOR,A.INVOICEID,A.LEDGERVOU CHER,A.UPDATED,A.DIMENSION,A.DIMENSION2_,A.DIMENSION3_, A.ONACCOUNTAMOUNT,A.TAXPRINTONINVOICE,A.LISTCODE,A.DEL_PRINTED, A.DOCUMENTNUM,A.DOCUMENTDATE,A.INTRASTATDISPATCH,A.DELIVERYNAME, A.DELIVERYADDRESS,A.PURCHASEORDER,A.DLVTERM,A.DLVMODE,A.PAYMENT, A.CASHDISCCODE,A.INVOICEROUNDOFF,A.SUMMARKUP,A.COVSTATUS, A.RETURNITEMNUM,A.POSTINGPROFILE,A.BACKORDER,A.PREPAYMENT, A.DLVZIPCODE,A.DLVCOUNTY,A.DLVCOUNTRYREGIONID,A.DLVSTATE,A.TAXGROUP, A.TAXITEMGROUP,A.DEL_TAXSPECIFYTOTAL,A.TAXSPECIFYBYLINE, A.EINVOICELINESPECIFIC,A.DEL_CORRECTEDINVOICEID,A.ONETIMECUSTOMER, A.PAYMENTSCHED,A.SUMTAX,A.SALESTYPE,A.EINVOICEACCOUNTCODE,A.PARMID,A.E USALESLIST,A.EXCHRATESECONDARY,A.TRIANGULATION,A.CUSTOMERREF, A.VATNUM,A.NUMBERSEQUENCEGROUP,A.LANGUAGEID,A.INCLTAX,A.LOG, A.PAYMDAYID,A.INVOICINGNAME,A.INVOICINGADDRESS,A.INVZIPCODE, A.INVCOUNTY,A.INVCOUNTRYREGIONID,A.INVSTATE,A.GIROTYPE, A.CONTACTPERSONID,A.SALESORIGINID,A.BILLOFLADINGID,A.INVENTLOCATIONID, A.FIXEDDUEDATE,A.DELIVERYCITY,A.DELIVERYSTREET,A.INVOICECITY, A.INVOICESTREET,A.PRINTORIGINALS,A.PRINTCOPIES,A.INVOICEAMOUNTMST, A.INVOICEROUNDOFFMST,A.SUMMARKUPMST,A.SUMLINEDISCMST,A.ENDDISCMST, A.SALESBALANCEMST,A.SUMTAXMST,A.DEL_REFDLVZIPCODE,A.DEL_REFINVZIPCODE, A.INTERCOMPANYCOMPANYID,A.INTERCOMPANYPURCHID,A.PROFORMA, A.MILCHECKNUM,A.MILPAYMENTMETHOD,A.MILPAYMENTAMOUNT,A.CREATEDDATE, A.CREATEDTIME,A.CREATEDBY,A.RECVERSION,A.RECID, B.INVOICEID,B.INVOICEDATE,B.SALESID,B.ORIGSALESID,B.INVOICEACCOUNT, B.ORDERACCOUNT,B.DELIVERYNAME,B.DELIVERYADDRESS,B.PARMID, B.INVOICINGADDRESS,B.INVOICINGNAME,B.PURCHASEORDER,B.CUSTOMERREF, B.RECVERSION,B.RECID,A.DEL_CORRECTIVEREASON FROM CUSTINVOICEJOUR A,CUSTINVOICESALESLINK B WHERE ((A.DATAAREAID='100') AND (A.REFNUM=0)) AND ((B.DATAAREAID='100') AND A.SALESID=B.SALESID) AND (A.INVOICEID=B.INVOICEID)) AND (A.INVOICEDATE=B.INVOICEDATE)) AND (B.ORIGSALESID='CSO144702'))) ORDER BY A.DATAAREAID,A.INVOICEACCOUNT,A.INVOICEDATE OPTION(FAST 1) Thanks Paul [Non-text portions of this message have been removed]
[development-axapta] How do I raise the indent from production department to inventory department
Hi all Can any one give me brief on how to raise indent the scenario is say( I want to produce 1 tone of finished product in 3 months for this I need raw material for this raw material I need to raise the indent to inventory so that inventory people can allocate the raw material for this indent ) Thanks for any help.
[development-axapta] Select the Printer
Hi Guys, Clinet may have installed with any number of printers. 1. I need to select one specific printer in setup parameter. 2. I need to print one report in that specified printer while user prints that report. How can i achive this? Any inputs greatly apriciated. Thanks in Advance, Logu
RE: [development-axapta] Bad response time on the CUSTINVOICEJOUR form
Hi Paul any news on any progress for this? We just found the problem came back for us so i dont think its a compile problem. I think for us because we created a new index SQL had cached data so when we deleted the index it was still okay due to the cached data being there but now after a while the cached data is not there so its back to being a problem. So for now we have created a new index (just on invoicedate of custinvoicejour) and things are working okay One thing I was wondering and might be worth testing is does the probem exist on the customer / inquiries? Just wondering about the sort order in the SQL statement is InvoiceAccount. In theory SQL should handle this no problem I think but maybe somethign to check Also what about the Find First Fast option? This maybe causes/forces the SQL to start on CustInvoiceJour...maybe try turnign it off and see if any immedaite change Thanks James _ From: James Flavell [mailto:[EMAIL PROTECTED] Sent: Thursday, January 10, 2008 4:06 PM To: 'development-axapta@yahoogroups.com' Subject: RE: [development-axapta] Bad response time on the CUSTINVOICEJOUR form Snap!!! Same probem here We have the same kind of number of records in the tables (FYI we have about 5 diff AX companies...do you have multi companies, not sure this has anything to do with the problem?) Also we found users who killed there AX session (thinking it was not responding) it actaully left the process in the SQL and it would not stop and took 100%!!! Look in your event viewer for things like AOS saying SPID xxx should be killed (i.e. AOS cannot kill it and you have to go into SQL yourself to do) We seemed to have fixed (just like 5 mins ago) for now but not sure, these are the steps we did for your info: 1) We added an index with invoicedate to custinvoicejour 2) Opened the form again and this time data appeared fine 3) We deleted the index and still the form is fine (this might be SQL caching of some kind I am not sure) Maybe you can first just test a compile of the form and then a full compile Still problem: Check in SQL do indexes exist on this table? (wondering if somehow the AOT indexes did not get to SQL) Do a sync from AOT for this table If these do not work then try creating an index on this table Anyone else having this problem? We thought it might be a AX system file corruption as we had some server problems a while back but it seems maybe it is more of a Standard AX problem since someone else has the problem Also I suggest you try putting the SQL statement in the SQL profiler to see what query path the SQL plans to use (maybe before you try any of the fixes) Looking forward to hearing from you Thanks James _ From: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of pkpeterson652 Sent: Wednesday, January 09, 2008 8:32 PM To: development-axapta@yahoogroups.com Subject: [development-axapta] Bad response time on the CUSTINVOICEJOUR form I have a response time problem with the CUSTINVOICEJOUR form. Accounts receivable \ Sales Orders \ Inquiries \ Invoices This form only has some minor modifications to it and when the mods are removed the same results are given. We are running Dynamics AX 4.0 at SP1, SQL Server 2005, and one AOS. The first time this option is selected it takes anywhere from 1 1/2 to 2 1/2 minutes to come up. Once the form has been opened up this form will come up in 1 to 2 seconds. I understand this because the necessary infomation is probably in the cache for the subsequent queries. I have run SQL trace and have isolated the offending query. I have taken the SQL statement shown in the SQL Trace log into the Database Engine tuning advisor, built and updated the recommended Statistics and built the recommend indexes. There are 166,506 records in the CUSINVOICEJOUR table across all companies and 108,388 records in the CUSTINOICESALESLINK table accross all companies. Any suggestions of what I should look at next? SQL Statement is as follows: SELECT A.CUSTGROUP,A.REFNUM,A.SALESID,A.ORDERACCOUNT,A.INVOICEACCOUNT, A.INVOICEDATE,A.DUEDATE,A.CASHDISC,A.CASHDISCDATE,A.QTY,A.VOLUME, A.WEIGHT,A.SUMLINEDISC,A.SALESBALANCE,A.ENDDISC,A.INVOICEAMOUNT, A.CURRENCYCODE,A.EXCHRATE,A.SALESADMINISTRATOR,A.INVOICEID,A.LEDGERVOU CHER,A.UPDATED,A.DIMENSION,A.DIMENSION2_,A.DIMENSION3_, A.ONACCOUNTAMOUNT,A.TAXPRINTONINVOICE,A.LISTCODE,A.DEL_PRINTED, A.DOCUMENTNUM,A.DOCUMENTDATE,A.INTRASTATDISPATCH,A.DELIVERYNAME, A.DELIVERYADDRESS,A.PURCHASEORDER,A.DLVTERM,A.DLVMODE,A.PAYMENT, A.CASHDISCCODE,A.INVOICEROUNDOFF,A.SUMMARKUP,A.COVSTATUS, A.RETURNITEMNUM,A.POSTINGPROFILE,A.BACKORDER,A.PREPAYMENT, A.DLVZIPCODE,A.DLVCOUNTY,A.DLVCOUNTRYREGIONID,A.DLVSTATE,A.TAXGROUP, A.TAXITEMGROUP,A.DEL_TAXSPECIFYTOTAL,A.TAXSPECIFYBYLINE, A.EINVOICELINESPECIFIC,A.DEL_CORRECTEDINVOICEID,A.ONETIMECUSTOMER, A.PAYMENTSCHED,A.SUMTAX,A.SALESTYPE,A.EINVOICEACCOUNTCODE,A.PARMID,A.E USALESLIST,A.EXCHRATESECONDARY,A.TRIANGULATION,A.CUST
[development-axapta] Axapta 3 Code Editor
Hi, I'm running Axapta 3.0 SP2. We don't have support for it from anybody. Currently, there is a...class that I want to edit the code for. I can see the code in Code Explorer in Axapta, but I have no idea how to edit the code. What program do I use? Is there a certain file I need or can I edit the system directly? From what I understand, everything should be in the system for me to edit/change. Please help. :( Thanks in advance. Howard
[development-axapta] Terminal Services and Ms Office Excel & Emailing
Hi All, Please excuse the ignorance or if a similiar question has already been posted. I am fairly new to Dynamics AX and Networking and am busy looking at a proposed architecture for one of our clients. Their network latency is between 13ms and 29ms so according to Microsoft documentation for Dynamics AX we are considering using terminal services. We want to install the Dynamics AX client software on the terminal server and connect to the AOS from there. I am concerned about fact that we also need to develop x++ code to auto email reports from within Dynamic AX as well as to export data to Excel for further user analysis. We might also implement Atlas XL. Do you know if the above scenario will work over terminal services ? I am worried that the Ms Office files will not be usefull unless the users can get it back onto their physical computers and that emailing from the terminal server will not work appropriately. Please shout if you need more detailed information. Any feedback will be greatly appreciated as I have never worked with terminal services and need to advice the client. Thanks a million !! Johan
[development-axapta] Re: Clsiter indexes yes or no?
Hi there As far as I know, (I could be mistaken) the best thing to do is to have a cluster index only if a table has one index, otherwise a table shouldn't have a cluster index. --- In development-axapta@yahoogroups.com, James Flavell <[EMAIL PROTECTED]> wrote: > > Should be disable cluster indexes or not in Ax4.0? > > I know the pros and cons but my impression is for AX at least we should turn > them of until someone in MS takes a good look and think slong and hard about > which index is the best as a clsuter index. > > Anyone agree/disagree? > > Thanks > James > > > > [Non-text portions of this message have been removed] >
[development-axapta] SmartStart 3000 for Axapta/Dynamics AX - New Version
I'm just finished the new version for SmartStart3000. What is it useful for? Organizer and direct Access to the different Dynamics AX configurations between Version 2.5 up to 4.0. It's still Freeware and you can get it from here: http://www.luegisdorf.ch/SmartStart3000.exe The new version has fixed several bugs. And additionally you have now support for the following languages: German, English, Norwegian, Danish and French. Please tell me questions to patrick at luegisdorf dot ch And of course - I'm happy about feedback. Best regards Patrick
[development-axapta] Is possible? print a box in the whole page
Hi!: I have an issue. I need to print a box in the border of the whole page in SalesInvoice report before everything be printed (I suppose that I need to use a Shape control in order to draw a big box). ¡¢ ¤£ How I can to do that if the pager header, page sections, etc. have it's own specific height?. Regards.
[development-axapta] Items that cannot be closed
Hi does anyone have any ideas why the following item cannot be closed in AX 4.0 SP1. Pasted below is the ValueOpen=Yes transactions (can cut and paste the text into excel I believe to get nicely formated). No dimensions are ticked for financial inventory and warehouse is ticked as physical To me there is enough Qty that can be settled I am thinking maybe AX does some kind of rounding in the closing such that there is 0.01 short of qty and so it decides cannot close. I am little concerned that the SQL data is not rounded on the QtySettled field (I assume thsi is the filed AX uses during closing to work out the open qty of a transaction) Or maybe it is something to do with a Transfer being the last transaction? Thanks James Warehouse Physical date Financial date Reference Receipt Issue QuantityAX Settled quantity AX OpenQty SQL QtySettled SQLOpenQty 43701 10/9/2007 10/9/2007 TransferPurchased 1 0.930.070.93330 0.06670 415610/10/2007 10/10/2007 TransferPurchased 1 0.750.250.75000 0.25000 45201 11/7/2007 11/7/2007 Sales order Purchased 1 0.830.170.83340 0.16660 45201 11/7/2007 11/7/2007 Sales order Purchased 1 0.5 0.500.5 0.5 45201 11/7/2007 11/7/2007 TransferSold-2 45211 11/7/2007 11/7/2007 TransferPurchased 2 0.981.020.98330 1.01670 4 3.992.01 4.0 2.0