[Axapta-Knowledge-Village] Re: Printing to PDF Printer
I don't know what version of Ax you're using but in 3.0, the PDF engine is just awfully bad. 450k for a simple 1 page report (with no picture of course) is not what I would call optimized PDF. If you can, avoid using the built-in PDF generator and use a 3rd party one. Steeve --- In Axapta-Knowledge-Village@yahoogroups.com, George Burrell george.burr...@... wrote: Printing documents such as Sales Confirmations, Delivery Notes, Invoices etc is causing some issues .. Seems that the documents DO print if certain Terminal Services users are logged in. But for others, there are obstacles. I would have thought that messages below would not be so particular to individual user running on individual server or work station but here it is. Can anyone interpret the kind of Stack Trace we are seeing here? Error executing code: Division by zero. Stack trace (C)\Classes\PDFViewer\writeAutoLabel - line 54 (C)\Classes\ReportOutputUser\writeField (C)\Classes\ReportOutputUser\printViaClass (C)\Classes\ReportViewer\printPDF (C)\Classes\ReportViewer\printToTarget (S)\Classes\ReportRun\print (S)\Classes\ReportRun\run (S)\Classes\SysReportRun\run - line 26 (S)\Classes\MenuFunction\run (S)\Data Dictionary\Tables\CustConfirmJour\Methods\printJournal - line 21 (S)\Classes\SalesFormLetter_Confirm\printJournal - line 6 (S)\Classes\SalesFormLetter\insertProforma - line 43 (S)\Classes\SalesFormLetter\createJournal - line 43 (S)\Classes\SalesFormLetter\run - line 73 (S)\Classes\SalesFormLetter\main - line 78 (C)\Classes\FormFunctionButtonControl\Clicked (C)\Classes\FormMenuButtonControl\Clicked (C)\Classes\FormMenuButtonControl\Clicked Error executing code: Division by zero. Error executing code: Call to TTSCOMMIT without first calling TTSBEGIN. Stack trace (S)\Classes\SalesFormLetter\insertProforma - line 45 (S)\Classes\SalesFormLetter\createJournal - line 43 (S)\Classes\SalesFormLetter\run - line 73 (S)\Classes\SalesFormLetter\main - line 78 (C)\Classes\FormFunctionButtonControl\Clicked (C)\Classes\FormMenuButtonControl\Clicked (C)\Classes\FormMenuButtonControl\Clicked TIA George
[Axapta-Knowledge-Village] Re: Axapta CRM vs Dynamics CRM
Thanks for the info Dan! So you either use AX CRM or MS CRM but not both, right? Can you synchronize data between Ax and MS CRM? If so, how and is it working smoothly? --- In Axapta-Knowledge-Village@yahoogroups.com, danfine d...@... wrote: Hi Steeve, We have implemented both AX CRM and MS CRM linked to AX. There is one key advantage of MS CRM, and that is you can use it disconnected. So, Sales folks can place orders remotely, not connected to the system. Also, MS CRM is prettier, and works better with Outlook/Exchange. However, AX CRM is totally integrated, which has its advantages. Dan F Fine Solutions Gold Certified Dynamics AX Partner 877.777.FINE eng...@... --- In Axapta-Knowledge-Village@yahoogroups.com, Steeve Gilbert steeve.gilbert@ wrote: Hi, Anyone know where I could find a comparative information about Axapta's CRM vs Dynamics CRM. I know Axapta CRM well but I don't know anything (yet) about Dynamics CRM. What would be the major point positive and negative of using Axapta without it's own CRM and using Dynamics CRM instead. Thanks for your info! Steeve
[Axapta-Knowledge-Village] Axapta CRM vs Dynamics CRM
Hi, Anyone know where I could find a comparative information about Axapta's CRM vs Dynamics CRM. I know Axapta CRM well but I don't know anything (yet) about Dynamics CRM. What would be the major point positive and negative of using Axapta without it's own CRM and using Dynamics CRM instead. Thanks for your info! Steeve
[Axapta-Knowledge-Village] Re: Another X++ question
You mean in the range? Try adding range like this : Dimension[1]. this will only show dimension 1. Hope that helps. --- In Axapta-Knowledge-Village@yahoogroups.com, kardo_ax [EMAIL PROTECTED] wrote: Hi All, In a report I want to show in the Dialog just one of the Dimension (Dep,Costcenter,...). How can I do this ? I dont want all the dimensions to appear for the user, Just one to select from/ thanks
[Axapta-Knowledge-Village] Re: bilingual in axapta ?
You know Axapta IS multi-language right? If so then you just need to buy the licence for the required language. --- In Axapta-Knowledge-Village@yahoogroups.com, Alok Kumar Mishra [EMAIL PROTECTED] wrote: Dear all I am customising my form and reports in which i want to display data in two different lanuages(i.e. Hindi and English) how this is possible ? thanx regards alok
[Axapta-Knowledge-Village] Re: Axapta 3: Moving of XPO files from 2 Tier to 3 Tier (same layers)
Hi, There's no problem with moving XPO from 2-Tier to 3-Tier or the other way around. _BUT_, you should still have your dev environment in 3-Tier if your Production one is in 3-Tier. Otherwise you will encounter situation where your code doesn't act the same way in 3-Tier as it does in 2-Tier (for example, client/server code). Save yourself trouble and go with 3-Tier. Hope that helps! Steeve --- In Axapta-Knowledge-Village@yahoogroups.com, sanju_kori [EMAIL PROTECTED] wrote: Hi [Group], I have one doubt related to Axapta 3 installation... I need to create a Development environment on one of the server. Since the number of users for this Dev Instance is only one... i am going for a 2 Tier Installation i have a doubt here Since the production environment on the main server is a 3 Tier installation will der be any problem while moving XPO files from 2 Tier Dev environment to 3 Tier Production environment??? or is it better to install a 3 Tier Development environment only??? so tat der wont be any problem while shipping of XPO files form deve env to production env,,, Thanx in Advance. Sanjivkumar
[Axapta-Knowledge-Village] Re: Cross Reference Tool
I think you can do an incremental update, but reference that do not exist anymore won't be removed I think. It's better if you rebuild everything every night. It takes us 3 hours. It can be automated, just create a schedule task that launch a .axc file. In the axc Startup Command put compileAll +. good luck! Steeve --- In Axapta-Knowledge-Village@yahoogroups.com, eravuna_akora [EMAIL PROTECTED] wrote: Hello, * Is it possible the make an incremental update? (instead of rebuilding the whole cross reference index) * And, is it possible to schedule this task? Elyo Ravuna --- In Axapta-Knowledge-Village@yahoogroups.com, Anders Sorensen anderso@ wrote: Hi, To generate cross references just right-click on the first node in the AOT and select Add-ins - Cross Reference - Update. This will take quite a long time (possibly hours) but it will give you the wanted ability to see all places the method is referenced so it is definitely worth the wait. Regards, Anders Sorensen From: Axapta-Knowledge-Village@yahoogroups.com [mailto:Axapta- [EMAIL PROTECTED] On Behalf Of syed baber Sent: 12. september 2008 22:09 To: [EMAIL PROTECTED]; axapta-knowledge- [EMAIL PROTECTED] Subject: [Axapta-Knowledge-Village] Cross Reference Tool Hi , I have made some changes to couple of methods of class and tables. Now I want to know from which forms these methods are referenced. Can cross reference tool provide me the name of forms from which these methods are referenced or there is some other way to do this. Please let me know as early as possible. Thanks, Syed Baber.
[Axapta-Knowledge-Village] Re: AX User group?
We are also member here and I say it does worth the membership if you participate to the webinars. Steeve --- In Axapta-Knowledge-Village@yahoogroups.com, Sumit Loya [EMAIL PROTECTED] wrote: Hi Lew, Our company is a part of AXUG group and its a nice place to be in. You can find many end users of AX as well as many partners in this group. According to me its worth enough to be part of this group as you can come accross many end users share your experiences know how each one of them uses AX, meet the service providers of AX and MS partners who work on AX and so on and so forth. I would say its worth enough to be a part of it. Regards, Sumit On Sun, Sep 14, 2008 at 12:42 AM, Lew Volk [EMAIL PROTECTED] wrote: Is any one a member of the AX User group http://www.axug.com/ ? If so is worth the membership fees?
[Axapta-Knowledge-Village] Re: excel
In excel, create a macro that change borders then analyse the code. You will then be able to mimic that in Axapta with COM object extracted from SysExcel* classes. --- In Axapta-Knowledge-Village@yahoogroups.com, Rodrigo Hentz [EMAIL PROTECTED] wrote: How i can apply borders in cells of excel by x++?
[Axapta-Knowledge-Village] (unknown)
element.design().orientation() ? Depends on what you mean by layout. --- In Axapta-Knowledge-Village@yahoogroups.com, madhan_ece55 [EMAIL PROTECTED] wrote: How to change the report layout dynamically?
[Axapta-Knowledge-Village] Re: How to add a calculated integer in a field programmaticaly without user input
Add your code to set SeqNo in insert() method of your table. Steeve... --- In Axapta-Knowledge-Village@yahoogroups.com, jazib.abdulah [EMAIL PROTECTED] wrote: Hi everybody I have a table named EmployeeDocuments with two fields EmployeeID (it is actually a ForeignKey to another table Employees). SeqNo (It is an integer) Both these fields collectively will make Primarykey for this table. What I want to do is whenever a new Row is added into EmployeeDocuments table by the user. User should select only EmployeeID and I should add a SeqNo programitically by counting total no of rows already present in EmployeeDocuments table with the selected EmployeeID, Increment it with one and put it in SeqNo field. How can I do it? Thanks for the help in advance.
[Axapta-Knowledge-Village] Re: RunBaseBatch
In the dialog, uncheck Batch processing in Batch tab. OR Run your queued batch (Basic / Periodic / Batch / Processing). Select the parameter under which you added your report to the batch list. Steeve... --- In Axapta-Knowledge-Village@yahoogroups.com, pranam mukher [EMAIL PROTECTED] wrote: hi all i have create a class which extends runbaseBatch class, this class will print all customers where customer transactions are posted after a specified date, when i run that class it will open dialog there i will specify the date , when i press ok it says Job is added to Batch Queue, what i have to do if i want to see the output regards Pranam. - Best Jokes, Best Friends, Best Food. Get all this and more on Best of Yahoo! Groups.
[Axapta-Knowledge-Village] Re: Doubt in RecordSortedList
Check output menuItem : salesRankingReport. This is report that does just that. Steeve... --- In Axapta-Knowledge-Village@yahoogroups.com, Anjali Kanna [EMAIL PROTECTED] wrote: Hi to all, I have a doubt in RecordSortedList. I want to print the top 50 Customer in customer report.I used one temp table. Using record sorted list values are insertd in to temp table in ascending order,but requirement is to print the top values only .so i need to store the values into the temp table in desc order.I don't know how to do that .if anyone know this concept immediately reply me . it's very urgent Thanks for your help Unlimited freedom, unlimited storage. Get it now, on 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: Top most Group Header not printing
- Does your section group have a dataField? - Is your query sorted by that field as first sorted field? If you corrected one of those 2, make sure to reset your query parameter when you launch the report so that the intended sort order is restored. Steeve... --- In Axapta-Knowledge-Village@yahoogroups.com, rmrallistan [EMAIL PROTECTED] wrote: Hi, I'm doing report which have two groups. The top most group is not printing. What could be wrong? This is what I'm expecting to happen... Group1 Sub Group 1 . . Sub Group n Group2 Sub Group 1 . . Sub Group n but this is the output... Sub Group 1 . . Sub Group n Please help. Thanks. Yna AX Newbie
[Axapta-Knowledge-Village] Re: USe of super
To understand what super() does, you need to know about the basic of Object Oriented Programming, which is : inheritence. For exemple, class SalesFormLetter_Invoice extends (inherits) class SalesFormLetter. SalesFormLetter has a method init() and so does SalesFormLetter_Invoice. If you instanciate SalesFormLetter_Invoice and call it's init(), when it gets to super() it will call it's parent method (SalesFormLetter.init()). If you comment the call the super(), SalesFormLetter.init() will never be called. Putting code before or after super() depends on if you want your action to happen before or after SalesFormLetter.init(). In Axapta it's not always clear what is the parent, but you don't always need to know either. Another exemple, in the lookup() method, super() call the generic lookup construction. If you want to create your own lookup you have to comment super() ortherwise 2 lookup will pop-up. I know it's a bit confusing but I don't know how to explain it further. It's really in the basics of OO. Steeve... --- In Axapta-Knowledge-Village@yahoogroups.com, pradeep itnal [EMAIL PROTECTED] wrote: Hi all i have some confusion with respect to USe of super() in different methods: can anyone help me out clearyfing this doubt?? i want to what difference it makes when i write my code before super() and what happens if i write my code after Super(). for example in fetch() method on reports we override super(); and same in Lookup() method also pls help me out... thanks in advance... 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
[Axapta-Knowledge-Village] Re: click method on button control
Is that checkbox linked to a field of a dataSource? If so, you should change the value on the field itself instead and afterward, do something like control.refresh(). Steeve... --- In Axapta-Knowledge-Village@yahoogroups.com, findrajon [EMAIL PROTECTED] wrote: hi everybody there is a checkbox on a form.i ant it to get automatically checked when i click a button.plz tell me how to do it.i tried control.checked(true) but its not working
[Axapta-Knowledge-Village] Print report on server (aos)
I'm trying to run a report on the server (AOS) and make it print to a printer on the server itself. Even if the code is running on the server, the report always end up printing on the client side. If MyPrinter doesn't exist on the client (it exist on the server) it's using the default client printer. I've also enabled Allow clients to use printers on the server on the AOS but with no luck. Inspired from EPSendDocument class, here's what I've got so far. static server void serverPrintTest(){ PrintJobSettingspjs; Argsargs; ReportRun rr; Report rb; ; args = new Args(reportStr(Report1)); rr = new ReportRun(args); rb = rr.report(); rr.suppressReportIsEmptyMessage(true); pjs = rr.printJobSettings(); pjs.virtualPageHeight(0); pjs.fitToPage(true); rb.interactive(false); rr.query().interactive(false); pjs.setTarget(PrintMedium::Printer); pjs.deviceName(MyPrinter, ClassRunMode::Server); rr.init(); pjs.setTarget(PrintMedium::Printer); pjs.deviceName(MyPrinter, ClassRunMode::Server); rr.run(); } Any help would be appreciated. I'm running Ax 3.0 SP3 KR3
[Axapta-Knowledge-Village] SalesInvoice report problem with KR3
Hi everyone, I'm still gathering info about KR3 (kernel rollup 3) upgrade and found a problem in SalesInvoice report on MBS forum. Go to http://www.microsoft.com/Businesssolutions/Community/Newsgroups/dgbrow ser/en-us/default.mspx? dg=microsoft.public.axapta.programminglang=encr=US Search for kernel rollup 3 salesinvoice Shortly, CustInvoiceTrans.RecId becomes empty after this.send (custInvoiceTrans); line in fetch() method. And that happends only the first time of the loop, next iterations are ok. I've confirmed the problem on my KR3 test environement. No answer found on MSB forum. I don't have any more info on this. I know it could be easily fixed in SalesInvoice but does it hide a uglier and more wide spread bug? Any hint would are welcomed. Btw I have SP3. Steeve...
[Axapta-Knowledge-Village] Re: Select the Printer
Hi, You can do that in the prompt() method of your report : element.printJobSettings().DeviceName (\\SomePrintServer\SomePrinter); Steeve G. --- In Axapta-Knowledge-Village@yahoogroups.com, sivlogu [EMAIL PROTECTED] wrote: 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
[Axapta-Knowledge-Village] Re: Axapta slower on SQL Server 2005 then SQL Server 2000?
Hi Harry, It's ok, I didn't need any disclamer. :) For sure, I'll run different task on each workstation. Thanks for the tip. Steeve... --- In Axapta-Knowledge-Village@yahoogroups.com, Harry Deshpande [EMAIL PROTECTED] wrote: 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:Axapta- [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 harryd@ 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
[Axapta-Knowledge-Village] Re: Two Dimesional Grid
I don't know if it still exist in 4.0 but in 3.0 you can use Table (check Form/tutorial_Form_Table). That should work if you keep it simple but if you want to push it, it becomes buggy. So for advanced table management I would suggest you go with a 3rd party ActiveX but I don't know which one. You could always use the Excel like component of Office Web Component. --- In Axapta-Knowledge-Village@yahoogroups.com, mahesh_axapta [EMAIL PROTECTED] wrote: Hello, Can Anyone tell me how 2 create 2 dimensional grid on the form?? that is designing of grid in row and column manner?? I m sure that Axapta 4.0 has this functionality.can anyone suggest necessary steps for this thank you in advance
[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.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]
[Axapta-Knowledge-Village] Re: Use .Net output parameters
You are in Ax 4.0 right? If so, can you Add System as a References in the AOT? regards, Steeve... --- In Axapta-Knowledge-Village@yahoogroups.com, Jérôme Piquot [EMAIL PROTECTED] wrote: Hi, I would like to call the static TryParse method (public static bool TryParse(string s, out double result); in System.Double .Net class) from X++. How can i use num as a .Net output parameter? { str strNum = 123,25; real num; ; System.Double::TryParse(nstr, num); } Cordialement, __ Jérôme Piquot Gédimat Wolff-Catenne 6, rue de la Gare 67120 Ernolsheim sur Bruche France Tél : +33 3 88 59 50 60 Fax: +33 1 41 30 17 34 Blog : http://piquot.spaces.live.com/ __
[Axapta-Knowledge-Village] Re: need a method to auto fit the Excel rows
Try creating a macro in Excel that do it. Then check the code generated by the macro recorder and that should help you. Steeve --- In Axapta-Knowledge-Village@yahoogroups.com, jyothi bandari [EMAIL PROTECTED] wrote: Hi, I need a method to auto fit the Excel rows. I am able to autofit the columns by Example - sysExcelWorksheet.columns().item(#ColumnName8).autoFit(); but I couldn't able to do the rows autofit. If anyone is having any idea please come back. It would be more appreciate if autofit for entire Excelsheet is available instead of writing separately for columns and rows. Thanks in advance. Thanks, Jyothi. 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
[Axapta-Knowledge-Village] Re: Axapta slower on SQL Server 2005 then SQL Server 2000?
Hi Harry, 1 - Is there documentation explaining MS recommendations about SQL Server setup you're talking about? 2 - Wow, never heard of those disc-alignment issue. Seems to cause quite of a performance problem. It's surprising people don't talk about that much. I'll need a bit more reading to understand the problem better and check if our SAN could suffer from this. I hope not! 3, 4 - Cluster Index and compatibility mode : Note inserted in my upgrade plan. :) Thanks for the tips! Steeve... --- In Axapta-Knowledge-Village@yahoogroups.com, Harry Deshpande [EMAIL PROTECTED] wrote: 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]
[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/dgbrows er/en-us/default.mspx? query=sql+2005dg=microsoft.public.axapta.databasecat=lang=encr=USpt =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.
[Axapta-Knowledge-Village] Re: Document grouping conditions
I should have mentionned that I'm running Ax3.0 SP3 and that's why it's different I guess. --- In Axapta-Knowledge- [EMAIL PROTECTED], Subrahmanyam,Mamidi [EMAIL PROTECTED] wrote: Actually, AX4.0/SP1, the display menu item for this is SalesFormLetterSortingParameters and the form name is SalesFormLetterSortingParameters and actually it has security key custsetup... AOT path = Cust - Setup - Form - Sort Probably I might be looking differently from what you are looking??? Steeve Gilbert [EMAIL PROTECTED] wrote: I still don't know where this is hidden in the main menu but I've found the form. What I was looking for is : SalesSummaryParameters. Steeve... --- In Axapta-Knowledge-Village@yahoogroups.com, Jens Strandberg jens@ wrote: Steeve, I believe that you are looking for Sales Ledger + Setup + Forms; Form sorting ... /Jens _ From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Steeve Gilbert Sent: Monday, December 03, 2007 11:11 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Document grouping conditions I'm looking for the form where you can setup the criteria that decide how a customer document (Picking list, packing slip, invoice) is grouped. By this I mean : If I select 100 orders and try to validate the PackingSlip, Axapta will group them by customer id, shipping address, etc... I'm looking for the form where I setup those condition (customer id, shipping address). If I remember correctly, the form has a tab for each document and in each of them you find 2 list with arrow between them so you can activate a condition or not. I can never manage to remember where this is hidden. If anyone can tell me where I could find that form, that'd be nice. Thanks! [Non-text portions of this message have been removed] - Be a better pen pal. Text or chat with friends inside Yahoo! Mail. See how. [Non-text portions of this message have been removed]
[Axapta-Knowledge-Village] Re: Document grouping conditions
I still don't know where this is hidden in the main menu but I've found the form. What I was looking for is : SalesSummaryParameters. Steeve... --- In Axapta-Knowledge-Village@yahoogroups.com, Jens Strandberg [EMAIL PROTECTED] wrote: Steeve, I believe that you are looking for Sales Ledger + Setup + Forms; Form sorting ... /Jens _ From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Steeve Gilbert Sent: Monday, December 03, 2007 11:11 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Document grouping conditions I'm looking for the form where you can setup the criteria that decide how a customer document (Picking list, packing slip, invoice) is grouped. By this I mean : If I select 100 orders and try to validate the PackingSlip, Axapta will group them by customer id, shipping address, etc... I'm looking for the form where I setup those condition (customer id, shipping address). If I remember correctly, the form has a tab for each document and in each of them you find 2 list with arrow between them so you can activate a condition or not. I can never manage to remember where this is hidden. If anyone can tell me where I could find that form, that'd be nice. Thanks! [Non-text portions of this message have been removed]
[Axapta-Knowledge-Village] Re: Tab Page Problem crazy one
Maybe it would be easier if you don't use a temp table and use 2 datasource of the same table. the 2nd dataSource as a !(not) filter on the currently selected RecId of the first dataSource. Change the filter and refresh the second dataSource each time the 1 dataSource selection change. Good luck! --- In Axapta-Knowledge-Village@yahoogroups.com, Rajkumar [EMAIL PROTECTED] wrote: Hi There are two tabpages containing the same records in grid. The datasource for tabpage 1 is regular table and for tabpage 2 is temp table. I have to display all the records in tabpage 2 except the record to which cursor is placed in tab page 1. Similalry when i change the record up or down in tabpage 1 grid, the records in tabpage 2 also needs to changed based on the cursor in tabpage 1. Since I use Temptable and I insert the records from regular table to temp table in init method of the temp table datasource, changing the display of records in tabpage 2 seems to be difficult. It might be a simple issue, but its making me crazy. Any help on this is highly valued. Regards,
[Axapta-Knowledge-Village] Re: Printing to PDF from Axapta
I can see that even in 4.0 SP2 the PDF engine is still buggy. That's sad. --- In Axapta-Knowledge-Village@yahoogroups.com, vuzhe [EMAIL PROTECTED] wrote: Hi All, Has anyone ever had a problem that Axapta hangs when trying to print the BOM Journal in PDF? We've also tested with creating a BOM Journal with two lines but still the application hangs. Printing to HTML is fast with no problems. Printing any other journal, like the transfer journal to PDF does not generate this situation. We are using Ax 4.0 SP2, SQL Server 2005, Windows Server 2003. We've cleaned the usage data, deleted the auc file on the local machine and also restarted the AOS's to no avail. Thanks in advance for your help.
[Axapta-Knowledge-Village] Re: Add an additional datasource to forms query
Combining CustTable? Do you mean SalesTable? Why do you want the dataSource to be add dynamically instead of design it in the form? --- In Axapta-Knowledge-Village@yahoogroups.com, Syner P [EMAIL PROTECTED] wrote: Hi, Is it possible to add an additional datasource to the forms query and filter the form without joining them in the form.For example filtering the form ProdTable with CustAccount via SalesId without combining CustTable. I tried the following code in form ProdTable but it didn't work. this.query().addDataSource(tableNum(SalesTable)); qbr=this.query().dataSourceNo(2).addRange(fieldNum (SalesTable,CustAccount)); this.query().dataSourceNo(2).addDynalink(fieldNum (SalesTable,SalesId),fieldNum(ProdTable,InventRefId)); Any help appreciated. Syner __ __ Never miss a thing. Make Yahoo your home page. http://www.yahoo.com/r/hs [Non-text portions of this message have been removed]
[Axapta-Knowledge-Village] Re: Different data same datasource
Have you tried adding a new dataSource that points to MarkupAutoLine (you can have multiple dataSource pointing to the same table). Make sure that the dataSource have no JoinSource. Then link the grid to that new dataSource. That should do the trick. Good luck! Steeve... --- In Axapta-Knowledge-Village@yahoogroups.com, lakshmisatheesh_bba [EMAIL PROTECTED] wrote: Hi, I want to display two grids in MarkupAutoSetup form. One grid is standard one which shows the lines for that heading, but i want to add one more grid and show all the lines in MarkupAutoLine table.how to do that. i tried using setTmpdata also but was not able to succeed. it would be help ful if u have a sample code for the same. thanx, lakshmi
[Axapta-Knowledge-Village] Re: Release COM object
I tried both of your idea guys, but without success. Thanks for your input anyway! I'll just leave it the way it is. Steeve... --- In Axapta-Knowledge-Village@yahoogroups.com, Subbu [EMAIL PROTECTED] wrote: or WinAPI::closeHandle(_hwd) kind regards, Subbu --- In Axapta-Knowledge- [EMAIL PROTECTED], Subrahmanyam,Mamidi subbu_oh@ wrote: Hi Steeve, I am not a C# developer. But I am not sure if you have used as i used to do in C++ if(MyCom) { myCom.Close(); myCom = NULL; } the bove code should decrement the pointer to the object's handle. good luck, Subbu Steeve Gilbert steeve.gilbert@ wrote: Hi guys, I would like to know how to release a COM (as in Component Object Model) correctly. I've created a .NET COM dll with VS2005 that I use in Ax3.0 SP3. When I use the COM in Axapta, it doesn't release reference to the COM until I close Axapta. So when I make modification to my dll and rebuild it, VS can't recreate the dll stating that the file is in use. To release the COM, so far i've tried : myCom.finalize(); myCom.detach(); myCom = null; But no success. Any idea? __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com [Non-text portions of this message have been removed]
[Axapta-Knowledge-Village] Re: Starting AX 3.0 on Win Vista
Are you sure you have the connection info in your registry? I'm talking about the info you can edit from the Axapta Configuration Utility. Steeve... --- In Axapta-Knowledge-Village@yahoogroups.com, Baciulis Darius [EMAIL PROTECTED] wrote: HI, Maybe someone already had this problem and will be able to give a bit of insight :) when running Ax 3.0 on XP it is enough to have shortcut to AX client and configuration on a server ar run everything from there without installing client on a machine. Though when you try to run such setup option on Vista - it gives error saying that AOS cannot be located with such configuration, though all other users are using exactly same configuration. Do you know what security or any other feature may be causing this ? darius [Non-text portions of this message have been removed]
[Axapta-Knowledge-Village] Re: Popup Menu
You can add this code to the showContextMenu() of a control : public int showContextMenu(int _menuHandle) { int ret; PopupMenu contMenu = PopupMenu::create(_menuHandle); int pouetteValue; pouetteValue = contMenu.insertItem(pouette); ret = super(_menuHandle); if (ret == pouetteValue) { info(Pouette was selected!); } return ret; } Problem is, you can't really do that to all the form (if that's what you want). You have to do it for every control. Good luck! Steeve... --- In Axapta-Knowledge-Village@yahoogroups.com, mohit rajvanshy [EMAIL PROTECTED] wrote: Hi All, Need to know that can we add a new entry in standard popup menu which will appear when we will right click on a form. For ex: Similiar to Create Alert rule. Please suggest if you have an idea. Thanks in advance. Regards Mohit Regards Mohit Rajvanshy __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
[Axapta-Knowledge-Village] Release COM object
Hi guys, I would like to know how to release a COM (as in Component Object Model) correctly. I've created a .NET COM dll with VS2005 that I use in Ax3.0 SP3. When I use the COM in Axapta, it doesn't release reference to the COM until I close Axapta. So when I make modification to my dll and rebuild it, VS can't recreate the dll stating that the file is in use. To release the COM, so far i've tried : myCom.finalize(); myCom.detach(); myCom = null; But no success. Any idea?
[Axapta-Knowledge-Village] Re: How to create http request?
I'm actually trying something close to what you need. I'm using a COM to do the request. Here's some sample code : COM xmlhttp = new COM(MSXML2.ServerXMLHTTP); COM xmlResponse; xmlhttp.Open(POST,http://somewebsite/somepage.asp,false); xmlhttp.setRequestHeader(Content-Type, application/x-www-form- urlencoded); xmlhttp.send(); xmlResponse = xmlhttp.responsexml(); info(xmlResponse.xml()); --- In Axapta-Knowledge-Village@yahoogroups.com, Marko Kull [EMAIL PROTECTED] wrote: Hi. I consider mysqlf quite experienced in axapta, but now I'm faceing a simple problem. How can I create a simple http request? I mean something like adding a comment to some article? In HTML it looks something like this: FORM Target=MyTarget textarea name=requestparams Here goes a big XML text, actually includes needed request parameters /textarea input type=submit /FORM How can I create such request in Axapta using X++? Thank You. [Non-text portions of this message have been removed]
[Axapta-Knowledge-Village] Re: How to get the application path in the code
Use : xInfo::directory(DirectoryType::Appl) Steeve... --- In Axapta-Knowledge-Village@yahoogroups.com, Marwa Elsawah [EMAIL PROTECTED] wrote: Hi all, I wanna ask about how to get the application folder path in the code to be dynamic wherever it is the application folder, may anyone help me ASAP? Thanks. [Non-text portions of this message have been removed]
[Axapta-Knowledge-Village] Re: How to compare two dates in Axapta 3.0
It should be simple or I'm not understanding your problem correctly. Can you send us a sample of the code you're trying to run? (complete modifiedField() method if possible) That'll be easier for us. --- In Axapta-Knowledge-Village@yahoogroups.com, Vasanthi [EMAIL PROTECTED] wrote: Hi Steeve, Thanks for ur reply. But when I use this statement in if-else condition in Table ModifiedField method to compare two dates I am getting error that they are not compatible types. How can we compare a date with system date in a modified field method. I am working in Ax - 3.0. [Non-text portions of this message have been removed]
[Axapta-Knowledge-Village] Re: Third party PDF generator
Thanks Michael, that trick with the caption of the report worked great! Steeve... --- In Axapta-Knowledge-Village@yahoogroups.com, [EMAIL PROTECTED] wrote: Hi, we are using pdffactory. Here you can setup a printer-driver with a directory where the pd-files automatic saved (without user dialog). The filname of the pdf-file comes from the caption of the report in additon with a sequential number. If you need could overwrite the caption by code, and got a specific filename. Best regards Michael - Original Message - From: Steeve Gilbert To: Axapta-Knowledge-Village@yahoogroups.com Sent: Thursday, September 27, 2007 9:39 PM Subject: [Axapta-Knowledge-Village] Third party PDF generator Hi, Anyone have been able to implement the use of a third party PDF generation software? My biggest problem is being able to specify the filename of the PDF without user interaction. Feel free to provide any idea towards this. Thanks. Steeve... [Non-text portions of this message have been removed]
[Axapta-Knowledge-Village] Re: Report Display
What we usually do here is that we keep, for example, the recId of the last Production Order Line (in your case) printed. Then when we get to print information about a Production Order Line we compare it with the latest one printed. If they are the same then we don't have to print info it. Make the field visible false or use display methode that have a value to return empty string or the value. regards, Steeve --- In Axapta-Knowledge-Village@yahoogroups.com, Rajkumar [EMAIL PROTECTED] wrote: Hi all, I have a problem in displaying the report. I want to select report from Prodtable,Prodroute and ProdBom tables. Now the trick is I have selected all the records which is showing in the report. But I want to display the first line record and if the production order line has more records in prodbom table..then most of the fields should be hidden on the next line. The report should look like this. WrkCntr frmdate itemid(Prodbom) itmnme(prodBom) Opr# itemid (prodtable) 30012 12/3/2007 DAP-42DA2343 10 234242 -- -- DAS-34DA5432 -- -- -- -- FRG-64FG2456 -- -- I think the above format is clear. Any help on the same. How to hide the data for the next few lines in report dynamically. Regards
[Axapta-Knowledge-Village] Print to file
Hi, Anyone know a way to create a .prn file from a report? By .prn file I mean the file outputed when you print to a print to file printer in windows. I've found \Classes\ClassFactory\createViewer where the format is checked to determine what class will create the output. If I knew How to generate a .prn file, that's where I would launch my class. But first, how do I create a valid .prn using parameters passed to creatViewer()? regards, Steeve
[Axapta-Knowledge-Village] Third party PDF generator
Hi, Anyone have been able to implement the use of a third party PDF generation software? My biggest problem is being able to specify the filename of the PDF without user interaction. Feel free to provide any idea towards this. Thanks. Steeve...
[Axapta-Knowledge-Village] Re: How we can call Images though X++ code in Form Field???
I don't quite understand what is the precise goal here but you could take a look at form tutorial_Form_DisplayOptions to change color of a line on a grid. Steeve... --- In Axapta-Knowledge-Village@yahoogroups.com, Alok Kumar Mishra [EMAIL PROTECTED] wrote: Hi I want to develop a functionality on the form there are certain check box on the form as i check on the check box that has assign red color, another check box that assign green color .. and similarly many others ..and when i click on check box then in form that color display on corresponding color should display? any suggestion is Welcome
[Axapta-Knowledge-Village] Re: Continous running object in Ax
Check class Info or Application that can be reach thru the code with infolog. or appl.. If you want to store value you can use appl.globalCache(). Those will stay on until the session is closed (or the value is remove) and will only be available for the current session. Steeve... --- In Axapta-Knowledge-Village@yahoogroups.com, abhijit raje [EMAIL PROTECTED] wrote: Hi friends i wanna know which object is continously running in Ax so tat i can customize it to meet my requirements. Choose the right car based on your needs. Check out Yahoo! Autos new Car Finder tool. http://autos.yahoo.com/carfinder/
[Axapta-Knowledge-Village] Re: How to change and get a criteria value in RunBaseBatch
How do you set a criteria on a table method? --- In Axapta-Knowledge-Village@yahoogroups.com, chuiringo [EMAIL PROTECTED] wrote: Thank you for your reply.. One more question in (1). If the query field(virtual field) is get from the table method. How to do it. Thanks --- In Axapta-Knowledge-Village@yahoogroups.com, Steeve Gilbert steeve.gilbert@ wrote: Hi, 1. You can get range value with this if you set range on InventTable.ItemId : element.query().dataSourceTable(tableNum(InventTable)).rangeField (fieldNum(InventTable, ItemId)) 2. I don't think that is possible. But if it is, I don't know how. regards, Steeve... --- In Axapta-Knowledge-Village@yahoogroups.com, chuiringo chuiringo@ wrote: Sorry, I am a beginner of axapter developer. I wrote some report and used ¡§qureyrun.get¡¨ function to get some needed recode to output to *.tsv files. I want to now if somebody can help me 1. How to get a criteria value and write it to report header in output report file. 2. How to change date format in the criteria field that is not in windows regional setting.
[Axapta-Knowledge-Village] Re: Using SalesFormLetter to post multiple invoices at one time
If that can help you, I have done something similar to this but for PackingSlip. It is not posting the packingslip automatically, it just brings the validation form with some sales order selected. You could push it further and automatically click Ok on the form to post them automatically. Here's what I've come up with : QueryBuildRange range; Args args = new Args(this); SalesTable salesTabToSelect; // SalesTable_ds is a FormDataSource linked to an invisible grid on my form. QueryBuildDataSource salesQBDS = SalesTable_ds.query().dataSourceNo (1); salesQBDS.addRange(fieldNum(SalesTable, CustAccount)).value (custAccountRange); SalesTable_ds.executeQuery(); // Select all lines of the grid salesTabToSelect = SalesTable_ds.getFirst(); while (salesTabToSelect) { SalesTable_ds.markRecord(salesTabToSelect, true); salesTabToSelect = SalesTable_ds.getNext(); } args.parmEnumType(typeId(DocumentStatus)); args.parmEnum(DocumentStatus::PackingSlip); args.record(SalesTable); SalesFormLetter::main(args); Good luck! Steeve... --- In Axapta-Knowledge-Village@yahoogroups.com, mstrillian [EMAIL PROTECTED] wrote: Hi everyone, I want to use a string of customer accounts to create a query to post multiple invoices at one time. Here is my code: Query query = new Query(); QueryRunqueryRun; SalesTable salesTable; SalesLine salesLine; SalesFormLetter salesFormLetter; ; // strCustAcct has multiple customer accounts in it, separated by commas query.addDataSource(tableNum(SalesTable)).addRange(fieldNum (SalesTable,CustAccount)).value(strCustAcct); salesFormLetter = SalesFormLetter::construct (DocumentStatus::Invoice); salesFormLetter.queryChooseLines().query(query); ttsbegin; salesFormLetter.update(salesTable, systemDateGet(), SalesUpdate::All, AccountOrder::None, false, false); ttscommit; I'm getting an error on the queryChooseLines method that tells me that SysQueryRun object not initialized. I tried putting a queryRun = new QueryRun(query); before constructing the SalesFormLetter, but still got the same error. I don't even know if I'm doing the SalesFormLetter part correctly. How do I tell SalesFormLetter what query I want it to use to post my sales orders? Also, is the update enough to post the invoices or do I have to call SalesFormLetter.run() as well? Or instead? Any help would be appreciated. Thanks!
[Axapta-Knowledge-Village] Re: Last Page in Report
Use the Footer section. That will execute only when the report is finished. Steeve... --- In Axapta-Knowledge-Village@yahoogroups.com, Andreas Rudischhauser [EMAIL PROTECTED] wrote: Hi, i need to know in a executesection of a report footer if I am on the last page (to print a sum). How can I achieve this. I found that totalPages() is always 0 so I have to use another way. I do not have a fetch method so I can't use the trick to check if the current record is the last in the query. Does anyone have another idea? [Non-text portions of this message have been removed]
[Axapta-Knowledge-Village] Re: Run Error - Excel sheet Template
Does all the fields have an EDT? That is required if you want to create excel template. Steeve... --- In Axapta-Knowledge-Village@yahoogroups.com, G Radhakrishnan [EMAIL PROTECTED] wrote: Dear all, I have created 1 table through data dictionary and while making Excel sheet template for this, getting the following error.. DictEnum Object not initialized class /Dictnum/label class /SysExcelTemplateWizard/Format cell -24 class /SysExcelTemplateWizard/Format type -21 class /SysExcelTemplateWizard/Format column - 37 class /SysExcelTemplateWizard/Create template - 17 class /SysExcelTemplateWizard/run - 21 class /SysExcelTemplateWizard/main - 11 Labels are defined for table which is created.. Regards, GR. __ __ Building a website is a piece of cake. Yahoo! Small Business gives you all the tools to get online. http://smallbusiness.yahoo.com/webhosting
[Axapta-Knowledge-Village] DeleteAction : Cascade
Anyone ever tried having a cascade delete (DeleteAction) that involves 3 tables? For example : I have those 3 tables : TestTable 1 to many TestLine 1 to many TestTrans TestTable cascade delete to TestLine TestLine cascade delete to TestTrans If I try to delete TestTable, I get the error : --- Cannot edit a record in (TestLine). The record has never been selected. --- Seems like when it tries to delete TestTrans related to TestLine, TestLine is already deleted and that's what is causing the error. The work around was to code the delete of TestTrans record in TestLine.delete() BEFORE the super(). If I code it after the super() I end up with the same error since TestLine is already deleted. Since I already have a work around I'm not looking for a answer but just wanted to know if anyone encountered the problem and found a better solution to make use of the DeleteAction feature.
[Axapta-Knowledge-Village] Re: Sort by invoice account and cust account on salestable
Create a view with CustTable and SalesTable linked with SalesTable.InvoiceAccount, add the fields you need plus CustTable.Name to sort with it. Go into you report, add CustTable sort it with CustTable.Name then add your view and link it to custTable with CustAccount. That should do the trick. regards, Steeve... --- In Axapta-Knowledge-Village@yahoogroups.com, V G [EMAIL PROTECTED] wrote: HI All I am creating a report using salestable. Have to sort the report by invoice customer name i.e. custtable::find( salestable.invoiceaccount).name and than by ship to customer name i.e. custTable::find(salesTable.CustAccount).name Is there a way to solve this problem. Thanks VG [Non-text portions of this message have been removed]
[Axapta-Knowledge-Village] Re: Relationship between custPackingslipjour and custpicklistjour
There's no unique relationship between CustPackingSlipJour and CustPickingListJour. The relationship between the 2 is Many to Many. Since PickingList can be partially delivered you can have the same PickingList on many PackingSlip, and of course many PickingList for a single PackingSlip. I don't exactly know the relation but you can search in SalesParmTable/SalesParmLine and other tables that are use during PackingSlip validation to find the relation, look for ParmId field. BEGIN rant I wish that part was documented... like many part of Axapta. END rant Good luck. Steeve... --- In Axapta-Knowledge-Village@yahoogroups.com, rueibin88 [EMAIL PROTECTED] wrote: Dear All: I try to write a program ti locate packing slip ID through picking list ID, but it seems there no unique relationship between these two tables. There's inventTransID that can find on both table through inventTrans table, but if this order has partial shippment the inventTransID will be the same for all shippement, which will not allow me to find the unique packing slip ID. Does anyone has solution for this case. Thanks a lot Jeffery
[Axapta-Knowledge-Village] Re: Email in Batch with AX3
You could probably replace the outlook code with the code you found. Put some breakpoint in SysOutlook_* classes to find where it is trigger and maybe from there you can make the customization. Good luck. Steeve... --- In Axapta-Knowledge-Village@yahoogroups.com, Andrew Bartley [EMAIL PROTECTED] wrote: Hello, Im having issues with emails, im trying to get Axapta to email us when a job completes. Unfortunatly using standard axapta emailing (tick the box on the batch tab) it uses the Outlook client on the machine. As we run a batch server and run jobs at 2 - 3 am, and with Outlook 2000 SP2 and above it now asks users if they want to confirm an external program is trying to access their address book, and click yes and yes. I would like to change the way this works so that it uses our SMTP settings. As far as i can find there is in Administration - Setup - Email parameters a place for putting this info. However the batch job doesnt seem to use or recognise this? Is there any way of turning on this functionality to work with the batch job please? Ive also found the below code which works for sending data from a client which i thought i may be able to manipulate to run with the batch job: static void ARB_EmailJob(Args _args) { // regsvr32.exe C:\Axapta\Axapta_Client\Bin\dsmailer.dll // need to register dsmailer on client for this to work. SysEMailBatch mailer; Sysuserinfo Sysuserinfo; userinfouserinfo; str userid; str username; str emailadd; ; userid = curUserId(); // Sets the username to the users current id emailadd = sysuserinfo::find(userid).Email; // Finds the users (senders) email address while(!emailadd) { info(emailadd); emailadd = Axapta; info(emailadd); } select userInfo where userInfo.id == curUserId(); // Selects User details username = userinfo.name; mailer = SysEmailBatch::construct(); mailer.parmEmailAddr([EMAIL PROTECTED]); mailer.parmMessageBody(This is a test message; Please disregard); mailer.parmPriority(emailPriority::Normal); mailer.parmSenderAddr(emailadd); mailer.parmSubject(Message from Axapta: + Username); mailer.run(); }
[Axapta-Knowledge-Village] Re: Stop GL posting using X++ Code
I'm not quite sure what you want to acheive here. Can you simple add throw error(posting stopped) code? Or do you want a multi- threading window that let you cancel the posting WHILE it is running? The last is quite a challenge in Axapta. regards, Steeve... --- In Axapta-Knowledge-Village@yahoogroups.com, Rajkumar [EMAIL PROTECTED] wrote: Hi All, Can anybody tell me how to Stop GL posting using X++ Code. There is a way to comment the code in post method of LedgerVoucher Class. But I need that to be done in x++ code. Anybody suggest?? Regards, Rajkumar
[Axapta-Knowledge-Village] Re: Manipulating files to import into document handling.
Hmm... yes? Just like a local file to my knowledge, only the path changes. Steeve... --- In Axapta-Knowledge-Village@yahoogroups.com, Myrl Satdnick [EMAIL PROTECTED] wrote: Can a file stored on a fileshare be manipulated and imported into axapta by code? If so how? Myrl
[Axapta-Knowledge-Village] Re: How to Create a Info Form
info(test); warning(sadjf); error(sfk); ??? Steeve... --- In Axapta-Knowledge-Village@yahoogroups.com, somanna gl [EMAIL PROTECTED] wrote: Hi All Please Help Me How to create a info Form. after creating a contact person. Thank You. with regards -somanna __ Yahoo! India Answers: Share what you know. Learn something new http://in.answers.yahoo.com/
[Axapta-Knowledge-Village] Re: Refresh form
You probably need to refresh the dataSource you just updated. Try one of these method on your dataSource : (reread() or refresh() is probably what you are looking for) .refresh() will not reread the record from the database. It basically just refreshes the screen with whatever is stored in the form cache. .reread() will only re-read the CURRENT record from the DB so you should not use it to refresh the form data if you have added/removed records. It's often used if you change some values in the current record in some code, and commit them to the database using .update() on the table, instead of through the form datasource. In this case .reread() will make those changes appear on the form. .research() is probably what you want. This will rerun the existing form query against the datasource, therefore updating the list with new/removed records as well as updating existing ones. This will honour any existing filters and sorting on the form. .executeQuery() is another useful one. It should be used if you have modified the query in your code and need to refresh the form. It's like .research() except it takes query changes into account. regards, Steeve... --- In Axapta-Knowledge-Village@yahoogroups.com, G Radhakrishnan [EMAIL PROTECTED] wrote: Hi all, We are also facing the problem. In our case, we take voucher number from lines to header. What we are doing is closing and opening the form; then it gets displayed. This is the way we are doing.. expecting some good replys from gurus... Regards, GR. --- abhijit raje [EMAIL PROTECTED] wrote: Hi friends can any one tell me how to refresh form when i add any new value on it. i.e. i have afield in header and its dependent on the line value so after entering in the line the header should be updated automatically can u tell me where to place refresh function for this to happen __ _ You snooze, you lose. Get messages ASAP with AutoCheck in the all-new Yahoo! Mail Beta. http://advision.webevents.yahoo.com/mailbeta/newmail_html.html __ __ Moody friends. Drama queens. Your life? Nope! - their life, your story. Play Sims Stories at Yahoo! Games. http://sims.yahoo.com/
[Axapta-Knowledge-Village] Re: Change on SQL Server 2005
Unless there was a big change in AX40 that i'm not aware, sychronization in only done one way which is : Axapta push table structure to SQL Server and not the other way around. So no, you wouldn't be able to do what you're explaining. Why not adding the field in Axapta? Steeve... --- In Axapta-Knowledge-Village@yahoogroups.com, pabundes [EMAIL PROTECTED] wrote: Could I make a Change on a table on AXDB directly on SQL Server and (running the sincronize tables job) see the changes on AX? for example.. Add a field on a table Tnks
[Axapta-Knowledge-Village] Re: Fax in axapta 3 SP3
Hi Bryan, Here we use RightFax. To send a fax we just have to print to a specific printer (RightFax virtual printer). Fax number is embedded in the document. Maybe there's a similar virtual printer in genifax. Steeve... --- In Axapta-Knowledge-Village@yahoogroups.com, bryanevil [EMAIL PROTECTED] wrote: Hi experts, Do you guys know any way to send out fax in axapta 3? we are trying to use genifax at our mail server to send out fax,the format it accept is [fax:[EMAIL PROTECTED], FAXNUMBER]. We tried to use SysMailer, but it doesnt work. We also tried to use Outlook,it pop out security dialog everytime and we dont want that. Regards, Bryan
[Axapta-Knowledge-Village] Re: Form with 2 grids and same datasource
I don't know if it works but you can try this : Create 2 dataSources that points to the same table. Let's say the table name is YourTable. Create YourTable_Header and YourTable_Detail datasources. Like you probably already did, add filter on YourTable_Header to show only header. Then add a join relation between YourTable_Header and YourTable_Detail on the field that link the header to the detail. Good luck! Steeve... --- In Axapta-Knowledge-Village@yahoogroups.com, Dimitri Dejonghe [EMAIL PROTECTED] wrote: Hi, I try to make a form with 2 grids (Heading grid an Detail grid) that have the same datasource but with other fields of the table used. The table contains header records and detail records and are marked in a field that contains the number 1 or 2. This field is related with a field called DocuNumber. Now, On my form the heading record works correctly but I don't find it how I can show the details in the detail grid. I Know that I have to use the active method in the heading grid to change data in de detail grid when select an onther record. But I don't know what code I could use so that I get the correct data in the detail grid. Thans on advance.
[Axapta-Knowledge-Village] Re: New field on InventBatch
If you have inserted your field in a group (in the form), check the group property DataGroup. If a DataGroup is set and your field is not in that group (on the table field group) then your field will not appear on the form. Hope it helps Steeve... --- In Axapta-Knowledge-Village@yahoogroups.com, pabundes [EMAIL PROTECTED] wrote: Hello!! I Inserted a new field on InventBatch table, this field is named LoteProveedor, and I modified InventBatch Form to modify this field, but when I run that form, it doesn't work, I can't see that field, but in my design, it appears there!, What can I do? thanks
[Axapta-Knowledge-Village] Re: How can we call multiple reports
You should be able to do that with ReportRun class. Steeve... --- In Axapta-Knowledge-Village@yahoogroups.com, contact2ajit2006 [EMAIL PROTECTED] wrote: Dear Frnds, Can any one tell me, how can we call multiple reports from single click.. plz help me out. Thanks and Regards Ajit
[Axapta-Knowledge-Village] Re: Regarding Extended Data Type
I'm not sure to understand what you want exactly but take a look at the EDT DimensionCode or Enum Type SysDimension. Steeve... --- In Axapta-Knowledge-Village@yahoogroups.com, kgage_ax4 [EMAIL PROTECTED] wrote: i am still new to the axapta developing and i have a problem with above subject. there is an inbuilt extended data type called Dimension and this has two array elements also.(Department/Cost center/Purpose) i want to call them one by one as Enum types can i do with this axapta? please help me. i don't know this is a question or but but please help me. i am still 20 years ald and no one to ask inside the company. thanx best regards
[Axapta-Knowledge-Village] Re: PDF
If you're talking about Ax 3.0 then there's 1 fix in SP4 and many fixes in SP5 about PDF (haven't checked SP6 yet, just find out it was out). I don't know if it can help you but here's the link to SP4, 5 and 6 on customerSource : https://mbs.microsoft.com/customersource/downloads/servicepacks/ax30sp 4_eng.htm?printpage=false https://mbs.microsoft.com/customersource/support/downloads/servicepack s/dynax30sp5.htm?printpage=false https://mbs.microsoft.com/customersource/support/downloads/servicepack s/dynax30_sp6.htm?printpage=false regards, Steeve... --- In Axapta-Knowledge-Village@yahoogroups.com, Craig Fidler [EMAIL PROTECTED] wrote: Hi All, There is a hotfix out for the printing to PDF. Can anyone supply me with the hotfix as I am unable to locate the download files on partnersource. Thanks Craig [Non-text portions of this message have been removed]
[Axapta-Knowledge-Village] Re: How to change and get a criteria value in RunBaseBatch
Hi, 1. You can get range value with this if you set range on InventTable.ItemId : element.query().dataSourceTable(tableNum(InventTable)).rangeField (fieldNum(InventTable, ItemId)) 2. I don't think that is possible. But if it is, I don't know how. regards, Steeve... --- In Axapta-Knowledge-Village@yahoogroups.com, chuiringo [EMAIL PROTECTED] wrote: Sorry, I am a beginner of axapter developer. I wrote some report and used ¡§qureyrun.get¡¨ function to get some needed recode to output to *.tsv files. I want to now if somebody can help me 1. How to get a criteria value and write it to report header in output report file. 2. How to change date format in the criteria field that is not in windows regional setting.
[Axapta-Knowledge-Village] Re: Failed to create file axapden-us.ahi
Hi Tobias, I've deleted the file, it recreated itself and now there's no more error. Thanks for your help! Steeve... --- In Axapta-Knowledge-Village@yahoogroups.com, Andrae, Tobias [EMAIL PROTECTED] wrote: Hi Steeve, error code 5 is the good old access denied from MS DOS. As the *.ahi files are the help index, someone (or something) seems to try to rebuild the index for the en-us help file but is not allowed to. Just log on in en-us to your AX client and rebuild the help index for yourself, then everything should be ok. br Tobias Von: Axapta-Knowledge-Village@yahoogroups.com im Auftrag von Steeve Gilbert Gesendet: Mo 23.04.2007 15:42 An: Axapta-Knowledge-Village@yahoogroups.com Betreff: [Axapta-Knowledge-Village] Failed to create file axapden- us.ahi It's been a week now that we are getting this error message in the AOS Event Log and I really don't know what is the cause or how i can resolve it. Axapta COM Connector Session 65534. Failed to create file axapden-us.ahi. Error code was 5 The Session Id always seems to relate to a web user. Anybody can throw some light on this for me? Any clue will be appreciated. regards, Steeve... [Non-text portions of this message have been removed]
[Axapta-Knowledge-Village] Failed to create file axapden-us.ahi
It's been a week now that we are getting this error message in the AOS Event Log and I really don't know what is the cause or how i can resolve it. Axapta COM Connector Session 65534. Failed to create file axapden-us.ahi. Error code was 5 The Session Id always seems to relate to a web user. Anybody can throw some light on this for me? Any clue will be appreciated. regards, Steeve...
[Axapta-Knowledge-Village] Re: Temp table and Grid
You can populate after super() in init() method. Maybe you'll have to run executeQuery() on your temp table. Steeve... --- In Axapta-Knowledge-Village@yahoogroups.com, Marco Donna [EMAIL PROTECTED] wrote: I want to have a grid use a temp table and the temp table will be populated at runtime. Where do I populate my temp table in order for it to appear on the grid? Thanks in advance. - Everyone is raving about the all-new Yahoo! Mail beta. [Non-text portions of this message have been removed]
[Axapta-Knowledge-Village] Axapta vs DST
Anyone expect any problem with Axapta 3.0 and SQL 2000 for DST 2007 if the windows OS is patched? Steeve...
[Axapta-Knowledge-Village] Re: Email from PDF viewer
From the fixlist info, it seems that the problem was fixed in PrOutCls.cpp, so it's in the kernel. No chance of an XPO here. I don't know what EXE, DLL, etc... relates to PrOutCls.cpp, maybe your VAR can help you with this. But I wouldn't recommend changing only one binary file unless it's _only_ related to PDF printing. regards, Steeve... --- In Axapta-Knowledge-Village@yahoogroups.com, Stephanie Johnson [EMAIL PROTECTED] wrote: Thanks Steve. Is there a possibility to fix it without upgrading it to sp5? does anybody know what were the actual changes? Steeve Gilbert [EMAIL PROTECTED] wrote: This seems to be fixed in SP5 : #7106 The page range selection was not taken into account for PDF printing. Steeve... --- In Axapta-Knowledge-Village@yahoogroups.com, steph1977j steph1977j@ wrote: Hi All, I have a requirement where I have to email a part of the report in the PDF format from the PDF viewer. To be more clear, I have to generate the report first to the pdf viewer and then email selected pages of the report from the pdf viewer. Right now when I choose the file format anything other than PDF I am able to email with pages I selected. I don't understand whats wrong with the PDF selection and its considering the entire report to be sent as email. did anybody have the same issue ? is there any solution? Regards, Stephanie - Everyone is raving about the all-new Yahoo! Mail beta. [Non-text portions of this message have been removed]
[Axapta-Knowledge-Village] Re: Can't Open Dynamics AX 4.0 AOT Project.
You need atleast MorphX licence to be able to open the AOT. You shoud also check the user security to make sure it has Developement security key enabled. Steeve... --- In Axapta-Knowledge-Village@yahoogroups.com, Andrae, Tobias [EMAIL PROTECTED] wrote: Of course there is a separate license for develoment - or even two: one for MorphX and one for X++ sorce code. So if your customer didn't buy them, there is no development with this license ;-) Tobias Von: Axapta-Knowledge-Village@yahoogroups.com im Auftrag von Imthiyaz Ahamed Gesendet: So 11.02.2007 14:52 An: Axapta-Knowledge-Village@yahoogroups.com Betreff: [Axapta-Knowledge-Village] Can't Open Dynamics AX 4.0 AOT Project. Hi Group, I have got one of my Client's License. I have uploaded into Dynamics AX 4.0 then Synchronize the Tables. But still AOT Project are grayed out. Not accessible. Is there any seperate License code for Development. Please Let me know. Regards, A.Imthiyaz Ahamed __ Do you Yahoo!? Everyone is raving about the all-new Yahoo! Mail beta. http://new.mail.yahoo.com http://new.mail.yahoo.com [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
[Axapta-Knowledge-Village] Re: printing multiple invoices
You're not a developper Wendy, are you? :) I'm guess that you haven't modified your invoice report yet. If so, go into the AOT report nodes and select SalesInvoice. Open that node and the Methods node. Double-click the fetch method. At the end of that method, there's 2 line element.reset(), comment them (put // at the beginning of the line) and add element.newPage() after those commented line. If you have a hard time finding the code line, use CRTL-F to find them. Are you ok with that? Like Khue mentionned, double check the invoices to make sure data is ok. I've checked a bit and amounts seems fine but I've noticed that Page X of Y includes all pages of all invoices printed. regards, Steeve... --- In Axapta-Knowledge-Village@yahoogroups.com, Wendy Hormann [EMAIL PROTECTED] wrote: Could you explain how to change the code step by step? =) Steeve Gilbert [EMAIL PROTECTED] wrote: In Main menu Accounts receivable Inquiries Journals Invoice, you can select multiple invoices and show them. Problem is they appear in different window but that can be modified. Find line of code element.reset() and replace it with element.newPage(). That way, instead of displaying a new windows for the next invoice, it will only create a new page to put the next invoice on. Regards, Steeve... --- In Axapta-Knowledge-Village@yahoogroups.com, whormann wendyhormann@ wrote: Is there a way to print multiple invoices for one account? I would like to re-print all of my open/past due invoices for an account, there are so many, and it seems that I can only do it one by one. Thanks, Wendy [Non-text portions of this message have been removed]
[Axapta-Knowledge-Village] Re: printing multiple invoices
Not much different than the invoice : By just looking at the code, I think that the same trick can be applied to SalesPackingSlip. Give it a try. Then go Main menu Accounts receivable Inquiries Journals PACKING SLIP Filter on the desired date, select all, show button, etc... regards, Steeve... --- In Axapta-Knowledge-Village@yahoogroups.com, Jens Strandberg [EMAIL PROTECTED] wrote: Steeve, That's an excellent suggestion. Now, do you have a similar, excellent suggestion as to how to allow printing of, let's say copies of packing slips for a certain date ? :-) I can't seem to find any clues in standard Ax, and before we do some in-house coding, I thought I would ask... Thanks in advance. Best Regards, Jens _ From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Steeve Gilbert Sent: Thursday, February 08, 2007 2:23 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Re: printing multiple invoices In Main menu Accounts receivable Inquiries Journals Invoice, you can select multiple invoices and show them. Problem is they appear in different window but that can be modified. Find line of code element.reset() and replace it with element.newPage(). That way, instead of displaying a new windows for the next invoice, it will only create a new page to put the next invoice on. Regards, Steeve... --- In Axapta-Knowledge- mailto:Axapta-Knowledge-Village% 40yahoogroups.com [EMAIL PROTECTED], whormann wendyhormann@ wrote: Is there a way to print multiple invoices for one account? I would like to re-print all of my open/past due invoices for an account, there are so many, and it seems that I can only do it one by one. Thanks, Wendy [Non-text portions of this message have been removed]
[Axapta-Knowledge-Village] Re: printing multiple invoices
In Main menu Accounts receivable Inquiries Journals Invoice, you can select multiple invoices and show them. Problem is they appear in different window but that can be modified. Find line of code element.reset() and replace it with element.newPage(). That way, instead of displaying a new windows for the next invoice, it will only create a new page to put the next invoice on. Regards, Steeve... --- In Axapta-Knowledge-Village@yahoogroups.com, whormann [EMAIL PROTECTED] wrote: Is there a way to print multiple invoices for one account? I would like to re-print all of my open/past due invoices for an account, there are so many, and it seems that I can only do it one by one. Thanks, Wendy
[Axapta-Knowledge-Village] Re: Problem for assigning cursor
Hi, I don't think you can set this automatically but try detecting what qr.next() returns and when it does return false (indicating no more record) call qr.reset() and then qr.next() and that should put you at the beginning of the query. regards, Steeve... --- In Axapta-Knowledge-Village@yahoogroups.com, abhijit raje [EMAIL PROTECTED] wrote: Hi friends, I have a problem in assigning the cursor to a particular position if i use (qr.next())and the whole loop finishes i want the cursor tobe pointing to first record again . plz give me the soln for this.
[Axapta-Knowledge-Village] Re: Getting the current database of the active application
You can also try sysSQLSystemInfo::construct().getloginDatabase() and other methods on that object. regards, Steeve... --- In Axapta-Knowledge-Village@yahoogroups.com, roland_poletti [EMAIL PROTECTED] wrote: Hello Patrick play around with the code below. For you the LoginConnect String will give you the needed informations. -- static void Job2(Args _args) { str strappl; str strTestProd; str str1; str str2; strappl = xInfo::directory(DirectoryType::Appl); str2 = new SqlSystem().loginConnectString(); info(strfmt(Application-Path: %1,strAppl)); info(strfmt(LoginConnectString: %1,str2)); } -- I hope that helps. Best regards Roland --- In Axapta-Knowledge-Village@yahoogroups.com, chuapatrickd chuapatrickd@ wrote: Hi to all, Is there a function or class in AX which gives the current database , server, user id to connect to the database and the password. In particular, I want to get what is stored in the AX config. I will use this info to call the stored procedures I build in that database. THis way I don't have to create same info for user to fill-up just for this purpose. THanks, Patrick
[Axapta-Knowledge-Village] Re: Using Axapta Screens Pocket PC and Integration with MES Systems
It's pretty simple actually, you should try it and see how far you can get. First, install a TS client on your pocketPC device. Then access a TS session and start Axapta. Afterwards you can create new forms that are suited for smaller screen. Start those screen in SysStartupCmd class after you detected (customization) that it's a pocketpc session. Let me know if you need more explaination on those steps. Have more precise questions and that'll be easier for me. :) Regards, Steeve... --- In Axapta-Knowledge-Village@yahoogroups.com, Hema [EMAIL PROTECTED] wrote: Hi, can u explain how to do that? regs, Hema. S - Original Message - From: Steeve Gilbert To: Axapta-Knowledge-Village@yahoogroups.com Sent: Thursday, December 14, 2006 7:22 PM Subject: [Axapta-Knowledge-Village] Re: Using Axapta Screens Pocket PC and Integration with MES Systems Hi Gökhan, Here we use Axapta thru Terminal Services on Pocket PC and it's working fine. We created new forms that are adapted for Pocket PC (fewer option, bigger button, etc.). I don't know anything about MES system. Regards, Steeve... --- In Axapta-Knowledge-Village@yahoogroups.com, Gökhan CAN gokhanc@ wrote: Hi All Has anyone used Axapta Screens on Pocket PC ?? And also I wanted to know that If anyone made integration with MES system in different locations ?? We have 3 different locations which has different MES systems and Axapta on different location. We are trying to decide what kind of integration to use ?? - COM Connector - Database Integration - Any new Idea ?? Thank You Gökhan CAN [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
[Axapta-Knowledge-Village] Re: Object looks different in TerminalServer session
Hi Karsten, I'll take a look at that. Thanks for the tip! Steeve... --- In Axapta-Knowledge-Village@yahoogroups.com, Karsten Krabbes [EMAIL PROTECTED] wrote: Hi Steeve, I think AX finds a different printer as default in the TS session. Report designs get their info about margins from the printer driver. br Karsten --- In Axapta-Knowledge-Village@yahoogroups.com, Steeve Gilbert steeve.gilbert@ wrote: Hi everyone, Yes the subject sounds weird but that's what we get here. I look at a report design margin from my desktop thru 3-Tier connection and I see 15 mm. If I open a TS session and connect thru 3-Tier I see 112.01 mm. Yes I've cleared Axapta client cache file on both side and nobody else is modifying the report. Can anybody tell me what's going on here? :) regards, Steeve...
[Axapta-Knowledge-Village] Re: Using Axapta Screens Pocket PC and Integration with MES Systems
Hi Gökhan, Here we use Axapta thru Terminal Services on Pocket PC and it's working fine. We created new forms that are adapted for Pocket PC (fewer option, bigger button, etc.). I don't know anything about MES system. Regards, Steeve... --- In Axapta-Knowledge-Village@yahoogroups.com, Gökhan CAN [EMAIL PROTECTED] wrote: Hi All Has anyone used Axapta Screens on Pocket PC ?? And also I wanted to know that If anyone made integration with MES system in different locations ?? We have 3 different locations which has different MES systems and Axapta on different location. We are trying to decide what kind of integration to use ?? - COM Connector - Database Integration - Any new Idea ?? Thank You Gökhan CAN [Non-text portions of this message have been removed]
[Axapta-Knowledge-Village] Object looks different in TerminalServer session
Hi everyone, Yes the subject sounds weird but that's what we get here. I look at a report design margin from my desktop thru 3-Tier connection and I see 15 mm. If I open a TS session and connect thru 3-Tier I see 112.01 mm. Yes I've cleared Axapta client cache file on both side and nobody else is modifying the report. Can anybody tell me what's going on here? :) regards, Steeve...
[Axapta-Knowledge-Village] Re: Another user changed one or more fields in the record
Hi, I don't really know what is the problem here but you should keep salesLine.doInsert(); salesLine.calcCreditEstimate(); in that order. Atleast here, they are in that order and there's no problem. Plus, in Ax 3.0 SP0 it was salesLine.calcCreditEstimate(); salesLine.doInsert(); and then in some Service Pack between 1 and 3 they changed it to salesLine.doInsert(); salesLine.calcCreditEstimate(); So that must be the correct order. Is your Sales module pretty plain or you've made some modification? Maybe 2 users really modify the same line (will happen a lot i guess if many users can work on the same sales order) or there's a batch process that modify sales line of an order that the user is already in. Those a bit tricky to catch. Good luck! Steeve... --- In Axapta-Knowledge-Village@yahoogroups.com, Learning Ax [EMAIL PROTECTED] wrote: Hey All, Many times we get the following error message while saving the salesline record Cannot edit a record in Order lines (SalesLine). Another user changed one or more fields in the record, or the Form has not selected all fields. Use Restore on the Command menu to get the new value. Do anyone have idea why we get this error? I have read in one post this is the error bcoz of following lines in the Insert method of SaleLineType class: salesLine.doInsert(); salesLine.calcCreditEstimate(); We get this error bcoz this is updating some fields after inserting the record. And this error will not be there if we change the sequence of the statement i.e. salesLine.calcCreditEstimate(); salesLine.doInsert(); Please let me know if anybody has any idea abt this. -- Cheers! Learning Ax
[Axapta-Knowledge-Village] Re: Web Grid
Hi, As for adding grid page number, a simple modification in WebFormHtml.layoutGrid() would do the trick, but you need to know the basics of HTML. As for modified event, that's another story. Either you refresh the page for every modification (with added HTML code) or you dive into Ajax and such. But I am still in Ax30 so maybe it's easier in Ax40 with SharePoint. Regards, Steeve... --- In Axapta-Knowledge-Village@yahoogroups.com, Sahin Sivaslioglu [EMAIL PROTECTED] wrote: Hi, I'd like to use a third party (or custom) webgrid instead of the standard one in Enterprise Portal. I need to do this in order to have some client side events (like modified) and to add to be able to display the total number of grid pages to the user? I can either use a third party product, or custom developped grid, but I need some samples / links to start from. Thanks for the help, Sahin - Everyone is raving about the all-new Yahoo! Mail beta. [Non-text portions of this message have been removed]
[Axapta-Knowledge-Village] Re: dll in Axapta
It is not possible to create a DLL with Axapta. You can use DLL but not create them. regards, Steeve... --- In Axapta-Knowledge-Village@yahoogroups.com, Kumar [EMAIL PROTECTED] wrote: Dear All, Is it possible to create dll in Axapta? If it is possible then how? Please help me in this regards. with regards Kumar - Find out what India is talking about on - Yahoo! Answers India Send FREE SMS to your friend's mobile from Yahoo! Messenger Version 8. Get it NOW [Non-text portions of this message have been removed]
RE : [Suspected Spam] [Axapta-Knowledge-Village] Low end Ax4.0 server spec
Isn't Axapta a bit pricy for 8 users? :-) Anyway, I would put some more RAM in there (maybe like 2 or 3 gig) and you should be good. Regards, Steeve... -Message d'origine- De : Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] De la part de James Flavell Envoyé : 6 décembre 2006 08:16 À : Axapta-Knowledge-Village@yahoogroups.com Objet : [Suspected Spam] [Axapta-Knowledge-Village] Low end Ax4.0 server spec Hi can anyone give some feedback on the server spec planned for a customer. It is only an 8 concurrent user license for normal trade (no production) and all is across the LAN. The server will be the AOS and SQL server. Planned: IBM x3400 64bit Intel Xeon 5110 Dual Core Processor, 4MB Level2 cache, 2 x 512MB DDR2. 73GB SAS HDD (mirrored) The company is only about 20 people so I was wondering is it a good idea to take the small business server rather than individual W2003 and SQL 2005 license? Is there any thing to be aware of in such a configuration? Thanks James [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
RE : [Axapta-Knowledge-Village] REGARDING SERVICE PACKS
If you have access to CustomerSource, you can download these service packs. Inside those you'll find the list of bug fix and changes for each service pack. Regards, Steeve... -Message d'origine- De : Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] De la part de Dipankar Paul Envoyé : 29 novembre 2006 01:48 À : Axapta-Knowledge-Village@yahoogroups.com Objet : [Axapta-Knowledge-Village] REGARDING SERVICE PACKS Dear Friends, I would be thankful to you if you can help me and devote few time to share a little of your knowledge with over a issue.I would like to know about the differences between different Service Packs in Microsoft Dynamics Ax ( Axapta) as SP1 , SP2 SP3 in Axapta. With Kind Regards, Dipankar, Send instant messages to your online friends http://uk.messenger.yahoo.com http://uk.messenger.yahoo.com [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
RE : [Axapta-Knowledge-Village] Re: Remote Axapta client software?
Malcom, Just link your remote office with a VPN tunnel and get the TS session to go thru that and that should be safe enough. Steeve... -Message d'origine- De : Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] De la part de Brandon George Envoyé : 2 juin 2006 13:14 À : Axapta-Knowledge-Village@yahoogroups.com Objet : RE: [Axapta-Knowledge-Village] Re: Remote Axapta client software? Terminal Server is the best option for you, and very secure. I have Several clients that already use it. It also gives you the ability to setup printers so when they log on to Term Server they can have their printers, access to their C:\ drive, and also other network mappings from within the TS session. Trust me most secure and best way you will find, other than the web approach. -Brandon -Original Message- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Philip R. Freimann Sent: Friday, June 02, 2006 1:05 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Re: Remote Axapta client software? Hi Malcom, My network administrator had some security concern using Windows Terminal Services - not sure what. Would that be similar to a PC Anywhere connection where they are actually working on a session that is here at headquarters? If so, can they print their paper work at their site? Phil --- In Axapta-Knowledge-Village@yahoogroups.com, Malcolm Burtt [EMAIL PROTECTED] wrote: Hi Philip Have you considered running Axapta from within a Windows Terminal Services session to solve your problem. You should find that WTS is able to cope with the network latency that you would experience over that kind of distance. Your users simply connect to the remote WTS machine over DSL and the WTS connects to Axapta. If you need to go over greater distances still than you can look at Citrix as this is better able to cope with the latency. Regards Malcolm Burtt Touchstone People, Partnership, Solutions _ From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Philip R. Freimann Sent: 02 June 2006 17:10 To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Remote Axapta client software? We have a remote location - 2500 miles. They need to enter customer orders, pick, pack, ship and invoice as well as online queries. The Axapta client is inefficient for this type of connection over a DSL line. Does anyone have a better experience? Does anyone know of a client specifically written for Axapta - perhaps an ASP? Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. SPONSORED LINKS Business finance course http://groups.yahoo.com/gads? t=msk=Business+finance+coursew1=Business +finance+coursew2=Business+to+business+financew3=Small+business+fina nc ew4=Business+finance+consultantw5=Business+finance+magazinew6=Busin es s+finance+schoolsc=6s=185.sig=I8jDsORmsaYn0BeqghcJ2w Business to business finance http://groups.yahoo.com/gads? t=msk=Business+to+business+financew1=Bus iness+finance+coursew2=Business+to+business+financew3=Small+business +f inancew4=Business+finance+consultantw5=Business+finance+magazinew6= Bu siness+finance+schoolsc=6s=185.sig=fCzze7cxm1K7TVKkzAaOrA Small business finance http://groups.yahoo.com/gads? t=msk=Small+business+financew1=Business+ finance+coursew2=Business+to+business+financew3=Small+business+finan ce w4=Business+finance+consultantw5=Business+finance+magazinew6=Busine ss +finance+schoolsc=6s=185.sig=v9sWAno7Kz4WuL8Tadcdhw Business finance consultant http://groups.yahoo.com/gads? t=msk=Business+finance+consultantw1=Busi ness+finance+coursew2=Business+to+business+financew3=Small+business+ fi nancew4=Business+finance+consultantw5=Business+finance+magazinew6=B us iness+finance+schoolsc=6s=185.sig=d1xwT3WL0E6XBf6cAV5BXA Business finance magazine http://groups.yahoo.com/gads? t=msk=Business+finance+magazinew1=Busine ss+finance+coursew2=Business+to+business+financew3=Small+business+fi na ncew4=Business+finance+consultantw5=Business+finance+magazinew6=Bus in ess+finance+schoolsc=6s=185.sig=qphRINaNuVm_6bwoQxgUmg Business finance schools http://groups.yahoo.com/gads? t=msk=Business+finance+schoolsw1=Busines s+finance+coursew2=Business+to+business+financew3=Small+business+fin an cew4=Business+finance+consultantw5=Business+finance+magazinew6=Busi ne ss+finance+schoolsc=6s=185.sig=1RfnhYZpV99RKWRZzSH4gA _ YAHOO! GROUPS LINKS * Visit your group Axapta-Knowledge-Village http://groups.yahoo.com/group/Axapta-Knowledge-Village on the web. * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] subject=Uns ubscribe * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service http://docs.yahoo.com/info/terms/ .
RE : [Axapta-Knowledge-Village] Re: dbo to bmssa
Thanks to Mikael and Mike, I've resolved the issue by changing the db user on the AOS. Steeve... -Message d'origine- De : Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] De la part de Mikael Sorensen Envoyé : 25 mai 2006 05:05 À : Axapta-Knowledge-Village@yahoogroups.com Objet : [Axapta-Knowledge-Village] Re: dbo to bmssa You can use the SQL procedure below to change the object owner of tables and views. However, I would recommend changing the owner FROM bmmssa TO dbo. Use this stored procedure to change the owner of the database: sp_changedbowner 'bmssa'. Now, all new objects are created with dbo as object owner. When moving the database between two servers you should probably also use that stored procedure to re-map the login user bmssa to the database user dbo. Regards, Mikael if exists (select * from sysobjects where id = object_id(N'[dbo]. [chObjOwner]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[chObjOwner] GO SET QUOTED_IDENTIFIER OFF SET ANSI_NULLS ON GO CREATE proc chObjOwner( @usrName varchar(20), @newUsrName varchar (50)) as -- @usrName is the current user -- @newUsrName is the new user set nocount on declare @uid int -- UID of the user declare @objName varchar(50) -- Object name owned by user declare @currObjName varchar(50) -- Checks for existing object owned by new user declare @outStr varchar(256) -- SQL command with 'sp_changeobjectowner' set @uid = user_id(@usrName) declare chObjOwnerCur cursor static for select name from sysobjects where uid = @uid open chObjOwnerCur if @@cursor_rows = 0 begin print 'Error: No objects owned by ' + @usrName close chObjOwnerCur deallocate chObjOwnerCur return 1 end fetch next from chObjOwnerCur into @objName while @@fetch_status = 0 begin set @currObjName = @newUsrName + . + @objName if (object_id(@currObjName) 0) print 'WARNING *** ' + @currObjName + ' already exists ***' set @outStr = sp_changeobjectowner ' + @usrName + . + @objName + ',' + @newUsrName + ' print @outStr print 'go' fetch next from chObjOwnerCur into @objName end close chObjOwnerCur deallocate chObjOwnerCur set nocount off return 0 GO SET QUOTED_IDENTIFIER OFF SET ANSI_NULLS ON GO --- In Axapta-Knowledge-Village@yahoogroups.com, Steeve Gilbert [EMAIL PROTECTED] wrote: Hi group, I just want to know if there's something to cure us from the modified objects that keep on changing owner from dbo to bmssa. It's not like its causing any real trouble in production, but sometimes I restore live data in our test environment and sychronique, I end up with 2 tables with the same name under 2 owner different (dbo and bmssa). If you have any clue, please send them my way. Thanks, Steeve... [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Yahoo! Groups Links Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. 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 : RE : [Axapta-Knowledge-Village] How to call multiple report designs?
In the init() method after super(). Steeve... -Message d'origine- De : Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] De la part de sherin francis Envoyé : 27 mai 2006 02:19 À : Axapta-Knowledge-Village@yahoogroups.com Objet : Re: RE : [Axapta-Knowledge-Village] How to call multiple report designs? Hi Steeve, Thanks for the reply... Where would be the best place i can place this code in the report... Steeve Gilbert [EMAIL PROTECTED] wrote: After you have decided which design to use, set it that way : element.design(YourDesign); regards, Steeve... -Message d'origine- De : Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] De la part de sherin francis Envoyé : 22 mai 2006 05:19 À : axapta axapta Objet : [Axapta-Knowledge-Village] How to call multiple report designs? Hi All, I have created multiple designs in the Sales Quotation report. But facing a problem as to how to call them? If the item number is of a particular range a particular design has to be printed else the standard. Can anyone shed some light, as to which method to make this modification and how to call that particular report Thanks in advance... - Be a chatter box. Enjoy free PC-to-PC calls with Yahoo! Messenger with Voice. [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Yahoo! Groups Links Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. 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. - - Yahoo! Messenger with Voice. Make PC-to-Phone Calls to the US (and 30+ countries) for 2¢/min or less. [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Yahoo! Groups Links Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. 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] How to call multiple report designs?
After you have decided which design to use, set it that way : element.design(YourDesign); regards, Steeve... -Message d'origine- De : Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] De la part de sherin francis Envoyé : 22 mai 2006 05:19 À : axapta axapta Objet : [Axapta-Knowledge-Village] How to call multiple report designs? Hi All, I have created multiple designs in the Sales Quotation report. But facing a problem as to how to call them? If the item number is of a particular range a particular design has to be printed else the standard. Can anyone shed some light, as to which method to make this modification and how to call that particular report Thanks in advance... - Be a chatter box. Enjoy free PC-to-PC calls with Yahoo! Messenger with Voice. [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Yahoo! Groups Links Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. 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] Date validation
Check that page (http://www.systomatics.biz/proj18.htm) from Harry. Regards, Steeve... -Message d'origine- De : Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] De la part de hany abodoma Envoyé : 23 mai 2006 05:50 À : Axapta-Knowledge-Village@yahoogroups.com Objet : [Axapta-Knowledge-Village] Date validation dear all i have field of type Date and enumeration field has value from 1 to 12 i need when the user select the date if i select from the enumeration 3 then he can't select all dayes in (mars) month (3) thanks and best regards Hany Abodoma [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Yahoo! Groups Links Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. 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] Reread and refresh problem
I don't know what could be the problem you're facing but here's an explanation of refresh and reread taken from a post on axapta-dev forum. Regards, Steeve... Just to clarify a few points... .refresh() will not reread the record from the database. It basically just refreshes the screen with whatever is stored in the form cache. .reread() will only re-read the CURRENT record from the DB so you should not use it to refresh the form data if you have added/removed records. It's often used if you change some values in the current record in some code, and commit them to the database using .update() on the table, instead of through the form datasource. In this case .reread() will make those changes appear on the form. .research() will rerun the existing form query against the datasource, therefore updating the list with new/removed records as well as updating existing ones. This will honour any existing filters and sorting on the form. .executeQuery() is another useful one. It should be used if you have modified the query in your code and need to refresh the form. It's like .research() except it takes query changes into account. In general, you only need to use one of these in any specific circumstance. Hope that helps clear it up Andrew Jones HGH Business Consultancy -Message d'origine- De : Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] De la part de James Flavell Envoyé : 26 mai 2006 12:26 À : Axapta-Knowledge-Village@yahoogroups.com Objet : [Axapta-Knowledge-Village] Reread and refresh problem Hi, I hope someone can share some understanding on something a little technical: What are the difference of reread and refresh in the context of a form? I have a modified form that has a problem whereby the user edits a field value and then press the down arrow key to go to the next record but after about 20 lines the cursor jumps back up to the first record and the lines get doubled or tripled. When I close the form and go back in then again I see only one set of all the records!!! I tested and found if I maximize the screen then if I edit any record that is more than 22 down the list then this result happens but if I make the screen smaller (i.e. less records displayed in the form) then it happens after about 19 lines. I tested sorting and filtering the records and it's the same once I scroll down the X number of records from the top and edit then the samething happens so it is not specific records but how many records down! Also I know in the field that gets modified there is a load of reread and refreshes that someone has put (too many I am sure but I am not really technical enough to say what it should be hence this email). So putting it all together I assume it is something about how many records the form reads into its 'display' memory combined with all these reread and refreshes. I hope someone can share the technical side of the reread and refresh or even better what might be the problem. Thanks James [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Yahoo! Groups Links Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. 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] dbo to bmssa
Hi group, I just want to know if there's something to cure us from the modified objects that keep on changing owner from dbo to bmssa. It's not like its causing any real trouble in production, but sometimes I restore live data in our test environment and sychronique, I end up with 2 tables with the same name under 2 owner different (dbo and bmssa). If you have any clue, please send them my way. Thanks, Steeve... [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. 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] Layman's Spec questions
Hi everyone, I just finished reading Layman's Spec for AX40 and I have a couple of questions: * It says AX40 will use Active directory logon. Should I understand by that, that we won't be able to enter a different login to have access to Axapta? So we won't be able to login with 2 different users on the same instance on the same machine? * In the upgrade path it says that client CAN run on WinXP. Why do they specify WinXP since it already runs on XP. Is Win2000 still supported for AX40? * Does AX40 require SQL Server 2005? I know I won't be able to use Reporting Services if I don't have SQL Server 2005. * Earlier I was told that Ax40 included a Version Control system. But now I read that Ax40 will support Visual Source Safe. So will I need to buy MS Visual SourceSafe to have a version control system? If you can answer anyone of those, that would be of great help. Regards, Steeve... [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. 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] Ax 4.0 with SQL Reporting Services
Hi Brandon, Sorry for late reply. Yes, I do have a more specific question. Our requirement will be to put charts on some our reports and since we can't do that built-in Axapta, I want to wait for AX40 to use RS to do that. But I'm concerned about the user experience. What are the differences between an Axapta report and an RS report from a user point of view? Can you still set ranges the way Ax does like PFC0100, PFE*, !PFE0100? If a user click on a menu Item that is link to an RS report (if you can do that), will it prompt the user (ranges, sort, etc...) in a similar way as Axapta report does? I know that I'll probably have to reprogram reports in RS to put charts on them and I'm ok with that. But will I lose some of the functionalities provided by Axapta report system? Thanks for your help, Steeve... -Message d'origine- De : Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] De la part de Brandon George Envoyé : 15 mai 2006 16:16 À : Axapta-Knowledge-Village@yahoogroups.com; development-axapta@yahoogroups.com Objet : RE: [Axapta-Knowledge-Village] Ax 4.0 with SQL Reporting Services Well if you went to Conv. This year this you could have gotten the Beta, which has all of this setup. Anyway it's very well integrated, and as far as I can tell works great. Do you have any specific questions? Any issues you are running into? Thanks, Brandon -Original Message- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Steeve Gilbert Sent: Monday, May 15, 2006 4:10 PM To: Axapta-Knowledge-Village@yahoogroups.com; development-axapta@yahoogroups.com Subject: [Axapta-Knowledge-Village] Ax 4.0 with SQL Reporting Services Hi everyone, Can someone tell us about SQL Reporting Services integration in Ax 4.0? How well is it integrated? How is it to create a report that will use SQL Reporting Services in Ax 4.0? Any kind of info would be appreciated. Regards, Steeve... [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Yahoo! Groups Links Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Yahoo! Groups Links Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. 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] Ax 4.0 with SQL Reporting Services
Oh and btw, as a small customer I don't get a chance to go to events like Convergence. :) Regards, Steeve... -Message d'origine- De : Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] De la part de Brandon George Envoyé : 15 mai 2006 16:16 À : Axapta-Knowledge-Village@yahoogroups.com; development-axapta@yahoogroups.com Objet : RE: [Axapta-Knowledge-Village] Ax 4.0 with SQL Reporting Services Well if you went to Conv. This year this you could have gotten the Beta, which has all of this setup. Anyway it's very well integrated, and as far as I can tell works great. Do you have any specific questions? Any issues you are running into? Thanks, Brandon -Original Message- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Steeve Gilbert Sent: Monday, May 15, 2006 4:10 PM To: Axapta-Knowledge-Village@yahoogroups.com; development-axapta@yahoogroups.com Subject: [Axapta-Knowledge-Village] Ax 4.0 with SQL Reporting Services Hi everyone, Can someone tell us about SQL Reporting Services integration in Ax 4.0? How well is it integrated? How is it to create a report that will use SQL Reporting Services in Ax 4.0? Any kind of info would be appreciated. Regards, Steeve... [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Yahoo! Groups Links Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Yahoo! Groups Links Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. 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] Ax 4.0 with SQL Reporting Services
Hi everyone, Can someone tell us about SQL Reporting Services integration in Ax 4.0? How well is it integrated? How is it to create a report that will use SQL Reporting Services in Ax 4.0? Any kind of info would be appreciated. Regards, Steeve... [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. 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] Is Triggers and Stored Procedures are available in Axapta.
Hi Prem, You just can't handle triggers in Axapta. Axapta won't know there's triggers and the same goes for Stored Procedures. But you can call stored procedures using UserConnection to execute SQL the pure SQL way. Regards, Steeve... -Message d'origine- De : Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] De la part de [EMAIL PROTECTED] Envoyé : 9 mai 2006 00:32 À : Axapta-Knowledge-Village@yahoogroups.com Objet : RE: [Axapta-Knowledge-Village] Is Triggers and Stored Procedures are available in Axapta. Hi, I know how to create Triggers and Procedures in SQL Server, but my doubt is how to handle this in Axapta.(back end SQL Server) with regards, Prem Harry Deshpande [EMAIL PROTECTED] To: Axapta-Knowledge-Village@yahoogroups.com Sent by: cc: [EMAIL PROTECTED] Subject: RE: [Axapta-Knowledge-Village] Is Triggers and Stored groups.com Procedures are available in Axapta. 08/05/2006 08:50 PM Please respond to Axapta-Knowledge-Village hi I guess you will have to post in SQL server forum regards harry From: Axapta-Knowledge-Village@yahoogroups.com on behalf of [EMAIL PROTECTED] Sent: Mon 5/8/2006 1:44 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Is Triggers and Stored Procedures are available in Axapta. Hi Friends, I want to add Triggers and Stored Procedures in back end.(SQL Server). Please help me in this regard. with regards, M.Premkumar Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Yahoo! Groups Links [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Yahoo! Groups Links Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Yahoo! Groups Links Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. 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] Users at logon
Hi! Anyone have a trick to resolve the problem where a user is at the logon screen and is using a user licence but you can't see him in the Online users form? Something like a timeout when you're idling at the logon screen. Regards, Steeve... [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. 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] Purchase Delivery Date - onSave
Hi Shaz, Put a break point in method Box::okCancel() and then with a look a the call stack you should be good. Regards, Steeve... -Message d'origine- De : Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] De la part de Shahzad Butt Envoyé : 27 avril 2006 14:31 À : Axapta-Knowledge-Village@yahoogroups.com Objet : [Axapta-Knowledge-Village] Purchase Delivery Date - onSave Hi all, on changing the Purchase Order Delivery Date (at header) and saving, an infolog box opens to update the Delivery Date for lines with an OK and CANCEL button (for one of our customer). I want to get rid of this message as customer doesn't need it. But struggling to find where it is called from? Any ideas how to trace this?? I've found the label for it and tried searching AOT for that label ID but couldn't find anything Regards, Shaz [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Yahoo! Groups Links Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. 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 find the data type of the field
Hi VG, The closest I could get was this : SysDictField sdf = new SysDictField(tableNum(InventTable), fieldNum(InventTable, ItemId)); ; info(strfmt(%1, sdf.type())); But it always returns me UserType, but don't ask me why... :) Steeve... -Message d'origine- De : Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] De la part de V G Envoyé : 25 avril 2006 07:16 À : Axapta-Knowledge-Village@yahoogroups.com Objet : Re: [Axapta-Knowledge-Village] How to find the data type of the field Thanks But I will know the table name and the fieldname at run time so i cannot use tablename.fieldname as i will have to declare the table for this and i dont know till run time what table it will be Regards VG On 4/25/06, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Hi, use typeof function. ex: typeof(tablename.fieldname) - returns the datatype of specified field regs, Hema. S V G [EMAIL PROTECTED] Sent by: To: development-axapta@yahoogroups.com [EMAIL PROTECTED] cc: Axapta-Knowledge-Village@yahoogroups.com groups.com Subject: [Axapta-Knowledge-Village] How to find the data type of the field 04/25/2006 11:44 AM Please respond to Axapta-Knowledge-Village Hello Can anyone help me find the datatype of the field if I have table Id and FieldId. Thanks VG [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. 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. Visit www.frappr.com/axapta for axapta friends. Yahoo! Groups Links [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Yahoo! Groups Links Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. 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.