Re: SV: SV: SV: [development-axapta] SQL Server 2000: since some weeks DB-size grows
Title: Melding Mit freundlichen Grüßen / Best regards / Med venlig Hilsen Jesper J¢rgensenConsulting mailto: [EMAIL PROTECTED] Aston Business SolutionsGmbHKettelerstr. 3-11D-97222 Würzburg-RimparGermany Tel.+49-9365-8075-0Fax+49-9365-8075-300 Work with a Winner. Aston Business Solutions--Microsoft Global Partner of The Year 2003No one is more committed to your success than Aston Business Solutions. As the world's leading Microsoft Business Solutions partner, we maintain a 92% customer retention rate and count more than 5,000 distribution, manufacturing, healthcare, and service-based companies among our loyal clients. Learn how we can help you achieve your potential. http://www.astongroup.deThe information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. Original Message processed by Tobit InfoCenter Subject: SV: SV: SV: [development-axapta] SQL Server 2000: since some weeks DB-size grows (19-Jan-2004 21:28) From: [EMAIL PROTECTED] To: [EMAIL PROTECTED](and 1 other) HiAccording to your answer on tadorna regarding SP on MSSQL server that you recomend SP3a you should upgrade the info on Technet. The matrix below is cut and paste from Technet this afternoon.it states that Axapta 3.0 only can use SP2. Axapta 2.5 introduces support for SQL Server 7.0 Service Pack 2 and SQL Server 2000. Below are the SQL Server ODBC Driver requirements for Axapta 2.5: Axapta Version Target Database Required ODBC component versions Axapta 2.5 SQL Server 7.0 SP1/SP2 ODBC components tested are: 3.70.06.90, 3.70.08.20 Axapta 2.5 SQL Server 2000 ODBC components tested are: 2000.80.19.4 Axapta 3.0 requires SQL Server 2000. Below are the SQL Server ODBC Driver requirements for Axapta 3.0: Axapta Version Target Database Required ODBC component versions Axapta 3.0 SQL Server 2000 SP2 ODBC components tested are: 2000.80.194, 2000.80.528 Med vennlig hilsenTorgeir TomsSystemkonsulent Teknisk IT==Good Judgment Comes From Experience. Experiences Comes From Bad Judgment.=-Opprinnelig melding-Fra: Kim Truelsen (MICROSOFT BUSINESS SOLUTIONS) [mailto:[EMAIL PROTECTED]]Sendt: 19. januar 2004 10:04Til: [EMAIL PROTECTED]Emne: RE: SV: SV: [development-axapta] SQL Server 2000: since some weeks DB-size growsOkay. Nice to know, but our recommendation is also SP3a. The problem seems not to be related to Axapta then, but my described scenarios could also cause similar problems.Have a nice day.Med venlig hilsen / Best regardsKim TruelsenMicrosoft DenmarkTuborg Boulevard 12DK-2900 HellerupPhone + 45 44 89 01 00Mobile + 45 29 49 99 58mailto:[EMAIL PROTECTED]From: juepeterberlin [mailto:[EMAIL PROTECTED]]Sent: 19. januar 2004 09:58To: [EMAIL PROTECTED]Subject: Re: SV: SV: [development-axapta] SQL Server 2000: since some weeks DB-size growsHi Kim,installing SP3a for SQL-Server solved the problem.I don't believe it was one of the reasons below, because page-densitydropped continually and not in leaps. One table (salesparmline) didneed 800 MB and 600 MB from this was "unused" (looked with sp_spaceused).At the end 1,5 new records (statistically) in salesparmline led to thecreation of a new page for salesparmline though 20 maxsize-recordsshould need less than one page.re 1. no "leaps"re 2. that would 1 GB more and no exponentially growth, in fact we had3,6 GB and a growth of 400-600 MB per day at last.re 3. indexes, that doens't explain the "unused" for salesparmlinere 4. that didn't happen, user data input was "normal" and no externaldata import took place.regardsJürgen Peter(CAM Berlin)--- In [EMAIL PROTECTED], "Kim Truelsen \(MICROSOFTBUSINESS SOLUTIONS\)" [EMAIL PROTECTED] wrote: Hi all I can maybe give you some explanation why your database size is growing 1. Sometimes changes in the data model are leading thesynchronization mechanism to create a shadow "X897" table. All datafrom the original table is copied to this table and the old onedropped and recreated. The behaviour was very normal in 2.5, butdoesn't show up that much in
Re: SV: [development-axapta] Regarding Labels
Title: Meddelelse Hi Mikael, try deleting the .ali (index file) for the label file, start the application on the Server in 2-tier mode. Then restart the AOS. /Jesper Original Message processed by Tobit InfoCenter Subject: SV: [development-axapta] Regarding Labels (22-Jan-2004 16:25) From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Hi Thomas I tried that a several times - and still got the same problem. Br. Mikael -Oprindelig meddelelse-Fra: Thomas Jensen [mailto:[EMAIL PROTECTED] Sendt: 22. januar 2004 16:16Til: '[EMAIL PROTECTED]'Emne: SV: [development-axapta] Regarding Labels Hi Mikael Stop the AOS, copy the labelfiles to the server and start the AOS again. That should work. Regards Thomas -Oprindelig meddelelse-Fra: Mikael Dalgård [mailto:[EMAIL PROTECTED] Sendt: 22. januar 2004 16:05Til: [EMAIL PROTECTED]Emne: [development-axapta] Regarding Labels Hi all I got a BIG (label problem), when I try to import a project from my developer laptop intoour AOS Test Server, I don't get all ofthe labels during the import (only some of them). I try to set all of the labels to (be overwritten, but that doesn't't work either). I tried to copy all of the labels files manually into the AOS server - but without any further luck (by using copy axmid*.* etc.) I still got the same @MIDnumber something instead of the label text. Does anybody have a hint for me about this. best regards Mikael Dalgård Yahoo! Groups Links · To visit your group on the web, go to:http://groups..yahoo.com/group/development-axapta/ · 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! Groups Links To visit your group on the web, go to:http://groups..yahoo.com/group/development-axapta/ 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! Groups Links To visit your group on the web, go to:http://groups..yahoo.com/group/development-axapta/ 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! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ 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: [development-axapta] sum
As you need to return a real not a record. static real MyTotal(Date _dd, Code _cc) { MyTable myTable; ; return (select sum (realfield) from myTable where myTable.Date == _dd myTable.Code == _cc).realfield; } /Jesper Original Message Subject: [development-axapta] sum (26-Jan-2004 16:57) From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Hi all, A question on how to use simple database functions ;-) Suppose I have the next new static function: static real MyTotal(Date _dd, Code _cc) { MyTable myTable; ; return select sum (realfield) from myTable where myTable.Date == _dd myTable.Code == _cc; } How do I get the retrieved value? Yahoo! Groups Links To visit your group on the web, go to: http://groups.yahoo.com/group/development-axapta/ To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/ To: [EMAIL PROTECTED] Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ 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-2: [development-axapta] How to change the filegroups of all the indexes of all tables
Title: How to change the filegroups of all the indexes of all tables Hidden in the development menu you will find a form "SYSSQLSetup" Use this to change the settings for the filegroups. Then Axapta will also use the settings doing the synchronization. /Jesper Original Message processed by Tobit InfoCenter Subject: RE: [development-axapta] How to change the filegroups of all the indexes of all tables (29-Jan-2004 11:58) From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Hi Herbert! Thanks for your suggestion. I think your reason is right. I will save my man/days by not to do it :D. Maybe I will try it some other time. I'll let you know the result (IA). Thank you, Arief -Original Message-From: Mister L [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 28, 2004 9:36 PMTo: [EMAIL PROTECTED]Subject: AW: [development-axapta] How to change the filegroups of all the indexes of all tables Hi Arief! I don't think, it's a good idea changing the filegroups. I think, that after your first synchronize you will lose your settings. But if you have success, I would be very interested :-) regards Herbert -Ursprüngliche Nachricht-Von: Arief Tarmizi [mailto:[EMAIL PROTECTED]Gesendet: Dienstag, 27. Jänner 2004 13:07An: '[EMAIL PROTECTED]'Betreff: [development-axapta] How to change the filegroups of all the indexes of all tables Hi All, I need your suggestions. I want to tune up my axapta sql server database. I want to separate the indexes and the data into different filegroups. Currently, in SQL Server Enterprise Manager, i have to change all the indexes in each table, which means i have to click one by one of each table and change the index in order to change the filegroups. Is there anyway to change all of the indexes in simpler way e.g. script or something, or tools etc. Or maybe you can tell me which index of tables should I move ? so I don't need to change all the table's indexes. Or maybe is there any way to set the filegroups of the indexes when we install axapta in the first place ? Thank's Yahoo! Groups Links · To visit your group on the web, go to:http://groups..yahoo.com/group/development-axapta/ · 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! Groups Links · To visit your group on the web, go to:http://groups..yahoo.com/group/development-axapta/ · 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! Groups Links To visit your group on the web, go to:http://groups..yahoo.com/group/development-axapta/ 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! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ 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: [development-axapta] Label with special user
Hi, check that the two users are both starting in the same language. If so try this: 1. Shut down the AOS. 2. Delete the file ax122lang.ali 3. Start axapta client on server in 2 tier mode searche any label, Axapta should now recreate the file *.ali if not existing. 4. Start the AOS again. /Jesper Original Message Subject: [development-axapta] Label with special user (02-Feb-2004 13:22) From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Hi, Axapta 3.0 SP2 - 3 tier environment. When starting application with user admin/usergroup admin - customerspecial labels are only shown with number e.g. @122XXX. When opening application with e.g. user test/usergroup admin - all labels are shown in correct way. When user admin tries to open label-editor via AOT axapta crashes? Restarting AOS or client, opening and saving of labelfile. does not solve the problem. Any hints appreciated. Best regards, Elia Yahoo! Groups Links To visit your group on the web, go to: http://groups.yahoo.com/group/development-axapta/ To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/ To: [EMAIL PROTECTED] Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ 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-2: [development-axapta] Transactions with multiple forms
HI, It is no Problem having interaction before the transaction. I use the class RecordInsertList to avoid using temp tables. /Jesper Original Message Subject: RE: [development-axapta] Transactions with multiple forms (05-Feb-2004 12:06) From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] You cannot have user interaction in the course of a long running transaction. If you really want to do it in one transaction, you should do the mass insert all at the end. If necessary, you can in the meantime store the records temporary (see eg. the old item wizard) Gert Neetesonne From: flygirltweety [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: [development-axapta] Transactions with multiple forms Date: Thu, 05 Feb 2004 09:50:41 - Hi, I want to write a procedure where I want to call 2-3 forms, in a certain order. When a user closes the first form, I should open a second, after that a third, The inserts of all these records should be done in 1 transaction. Does anyone has a clue if this is possible to do this in 1 transactions. And how do I know when a user has closed the first form, so I can open the second form ... Thanks! Greets Vanessa. _ Online gamen ? http://www.msn.be/games/online/ Yahoo! Groups Links To: [EMAIL PROTECTED] Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ 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: [development-axapta] Regarding AOS
Title: Meddelelse Hi. have you restarted your AOS after updating (and stopping)the Oracle server? /Jesper Original Message processed by Tobit InfoCenter Subject: [development-axapta] Regarding AOS (19-Feb-2004 15:54) From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Hi there Does anybody have an answer to why !!! does my clients come up with this error messages, when we try to connect to our AOS solution: - There is no object servers ? Nothing should have been changed - but our Oracle DB serverwas updated witha newer SPyesterday and after thatthe error above has shown. br: Mikael Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ 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: [development-axapta] Re: 45 GB Datebase with SQL2000
The SP3a should only be used with Axapta 3.0 SP2. Check the release notes. /Jesper Original Message Subject: [development-axapta] Re: 45 GB Datebase with SQL2000 (03-Mrz-2004 17:05) From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] I think they work still with SP2. To use SP3a is not off. recommended by MBS!? --- In [EMAIL PROTECTED], Marco Avena [EMAIL PROTECTED] wrote: Hi, have you already loaded any ServicePacks for SQL2000 ? We made the experience of very fast growing DataBase after we moved to Axapta Version-3 ServicePack-2. With SQL2000 ServicePack 3a we solved the problem. Avena obaur_2004 schrieb: We have bad Performance with a 45GB Database running on SQL2000. What are your experiences? Do you think we should use Oracle? Thanks for any informations. Yahoo! Groups Links Yahoo! Groups Links To: [EMAIL PROTECTED] Yahoo! Groups Sponsor ADVERTISEMENT Click Here Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ 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-2: [development-axapta] want to understand how to create a record in the table (SQL) by writ
Hi Girish, could you not use the a batch job? /Jesper Original Message processed by Tobit InfoCenter Subject: RE: [development-axapta] want to understand how to create a record in the table (SQL) by writti (03-Mrz-2004 19:23) From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Hi Jesper, thanks for the reply. the problem in this solution is that axapta is event driven and we have to run a job to import the data from the new table (created by external software). But the requirement is that as soon as the request is entered by Filemaker axapta has to pick the same. we need the same for some other functions also (to import /update the records created by file maker). if this has to work then there should be something which could triger the job (from Filemaker) which could then run the job of importing the records. If there are any work arounds in your knowledge which could help to solve this problem please do let me know. thanks again. cheers, Girish -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: 03 March 2004 16:49To: [EMAIL PROTECTED]Subject: Re: [development-axapta] want to understand how to create a record in the table (SQL) by writtiHi Girish,I do not like external software writing in the Axapta tables. The reasons for that you describe yourself (problems with Recid).Whar I like to do on integrations is to create an table that Axapta cann't se. (Other User, and/or other Database). I then use the ODBC class to access this table and pull the data into Axapta. Using Axapta to pull the Data solves the problem with Recid, gives you controle over tha datavalidation within Axapta. Try something like this: LoginProperty lp; OdbcConnection _odbc; Statement _sql; ResultSet _records; ; lp = new LoginProperty(); lp.setDatabase('MyDB'); lp.setDSN('MyDNS'); lp.setUsername('MyUser'); lp.setPassword('MyPassword'); try { _odbc = new ODBCConnection(lp); } catch { info("Not loged in."); } _sql = _odbc.createStatement(); _records = _sql.executeQuery('SELECT ItemId, Qty FROM ExchengeTable'); while (_records.next()) { print _records.getString(1); print _records.getReal(2); }/Jesper Original Message Subject: [development-axapta] want to understand how to create a record in the table (SQL) by writting p (03-Mrz-2004 17:29)From: [EMAIL PROTECTED]To: [EMAIL PROTECTED] Hi Guys, our client was earlier using a different application (File maker) before we went live with axapta. some part of the business process is still done on the earlier application which we intend to slowly move to axapta. our client is in computer repair business and the users are still using the old system to request for Items. we could manage to insert the request directly in the SQL table and axapta pickedup the records from that table. 1. This application has to run a sequence to update the recId field in the table (which some times gives duplicates and the request is lost). is it in some way possible to write some code in SQL table itself to populate the recId. 2. also is there any code which could be written on this table (with 3 fields : Item, Qty requested). At start the first record would have just the ItemId populated and when the Filmaker updates the record with the Qty (quantity) field. Now at this stage is it possible that when the Qty field is updated some code on the sql table would automatically create a new record with the same Item but Qty field blank so that the Filemaker would require only to populate the Qty field. i would appreciate if anyone would let me know if we can achieve this and how to run the code if we can achieve. i don't have much knowledge of running the codes on SQL directly. thanks in advance. cheers, Girish Yahoo! Groups Links To: [EMAIL PROTECTED] Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ 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: [development-axapta] Startup Menu
the class is xinfo method runStartupMenu(). Original Message Subject: [development-axapta] Startup Menu (18-Mrz-2004 14:36) From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Hi, Is there someone that knows which class is responsible for composing the startupmenu. I am investigating whether it is possible to attach startup menus to groups of users instead of one as it works now. regards, Danny Gaethofs Yahoo! Groups Links To: [EMAIL PROTECTED] Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ 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-2: [development-axapta] Sending Fax using COM
Title: Message You get a error form the faxserver that Axapta can not resolve to a errormessage. Check if you get an object of FaxDoc. /Jesper Original Message processed by Tobit InfoCenter Subject: RE: [development-axapta] Sending Fax using COM (31-Mrz-2004 14:48) From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Why? It is not the Axapta COM object that I'm using, it's the FaxCom.dll. Eva Aksnes -Original Message-From: Carsten M. Horlacher [mailto:[EMAIL PROTECTED] Sent: 31. mars 2004 14:39To: [EMAIL PROTECTED]Subject: RE: [development-axapta] Sending Fax using COMCould you successful pass the com connector test within Axapta. If nottry re-registering the AxCom component.Carsten-Original Message-From: eva_aksnes [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 31, 2004 1:22 PMTo: [EMAIL PROTECTED]Subject: [development-axapta] Sending Fax using COMI am using Microsoft Shared Fax to send a fax from Axapta without opening the faxwizard. This is my code:static void SendFax(Args _args){ COM FaxServer; COM FaxDoc; FaxServer = new COM('FaxServer.FaxServer'); FaxServer.Connect('Server'); FaxDoc = COM::createFromVariant(FaxServer.CreateDocument(C:\\Temp\\Test.txt')); FaxDoc.FaxNumber('055784585'); FaxDoc.RecipientName('Ann'); FaxDoc.Send(); //LINE 15 FaxServer.Disconnect();}But I get an error at the line 15. Error translated from norwegian: Method 'Send' in COM-object in class 'IFaxDoc' returns the errorcode 0x80070002(unknown), which means; unknown.Is there anyone that can give me a clue what's wrong here?Yahoo! Groups Links***This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secured or error-free as information could be intercepted, corrupted, lost, destroyed, received late or incomplete, or could contain viruses. The sender therefore does not accept liability for any error or omission in the contents of this message, which arises as a result of e-mail transmission.*** Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ 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-2: [development-axapta] SQL error when log into Axapta - Invalid Object Name 'SQLSYSTEMVARIA
HI, Do you have Axapta tables in the database? If so the Axapta tables should be user tables. If all your tables are system tables you need to change the properties of the table. If the ownership on the tables is wrong you can eigther use the allready mailed solution to fix it. (sp_change_users_login AUTO_FIX,'bmssa') If the you want to move the tables to a new user you need to change the table ownership like this: (declare @name varchar(250) declare @olduser varchar(250) declare @newuser varchar(250) declare @sp_str varchar(250) set @olduser = 'bmssa.' set @newuser = 'xxx' declare cursor1 cursor for select name from sysobjects where xtype = 'u' and uid == 1 -- (1 = dbo) open cursor1 fetch cursor1 into @name while begin transaction begin set @sp_str = @olduser + @name exec sp_changeObjectOwner @sp_str,@newuser fetch cursor1 into @name end commit transaction close cursor1 deallocate cursor1) /Jesper Original Message Subject: RE: [development-axapta] SQL error when log into Axapta - Invalid Object Name 'SQLSYSTEMVARIABL (23-Mai-2004 18:40) From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] I've tried your method but it still can't work. The table owner is `dbo' and the tables are all system tables. Hence there is no way I can change the owner of the system tables. Any solution I can resolve it? Thanks in advance. - Do you Yahoo!? Yahoo! Domains - Claim yours for only $14.70/year [Non-text portions of this message have been removed] Yahoo! Groups Links To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ 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-2: [development-axapta] Moving code between layers
Hi Stefan, you need to clean up the system table SQLDictionary to avoid loosing data when moving objects to a lower ID. You need to create a class that scan the data dictionary in Axapta and match that to the SQLDictionary on name not on id as the standard. You can browse the SQLdictionary using the enterprise manager. A table s identified by the table id and field id = zero. A normal field is identified by the table id and field id, should you have an array (dimensions) you need the array as well to identify the field. You might find the SQLScan classes useful to se how Microsoft maintains the dictionary. You might of course export the data and import them into the new system. Be sure to test it before you start this. If your Recid is not unique in the company you will not be able to re-import the company. /Jesper Original Message Subject: RE: [development-axapta] Moving code between layers (14-Jun-2004 6:50) From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Hi 'in the database. I would like to avoid exporting and importing with IDs.' I guess then you will have export and import data along with the code. Regards Harry _ From: Stefan Osterburg [mailto:[EMAIL PROTECTED] Sent: Saturday, 12 June 2004 1:01 a.m. To: [EMAIL PROTECTED] Subject: [development-axapta] Moving code between layers Hi, I am attempting to move my code from the var to the bus layer. While this is no problem with an empty database I have not been able to do this keeping the data in the database. I would like to avoid exporting and importing with IDs. Stefan Yahoo! Groups Sponsor ADVERTISEMENT click here http://rd.yahoo.com/SIG=129qtu2i4/M=298184.5022502.6152625.3001176/D=gr oups/S=1705006764:HM/EXP=1087045464/A=2164339/R=0/SIG=11e2d64in/*http:/w ww.netflix.com/Default?mqso=60183348 http://us.adserver.yahoo.com/l?M=298184.5022502.6152625.3001176/D=group s/S=:HM/A=2164339/rand=190594746 _ Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/development-axapta/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] be * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service http://docs.yahoo.com/info/terms/ . [Non-text portions of this message have been removed] Yahoo! Groups Links To: [EMAIL PROTECTED] Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ 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: [development-axapta] Speedup my Insert Records Process
Hi Jay, take a look at the update_recordset statement. /Jesper Original Message Subject: [development-axapta] Speedup my Insert Records Process (22-Jun-2004 6:52) From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Hi Guys, I am try to Update like 5000 or more records and I am using ttsbegin; Select forupdate tablename tablename.Field1 = ; tablename.Field2 = sdfsdf; tablename.insert(); ttscommit; My problem is it's taking more time but I am thinking to use storeprocedure in Oracal Database but I want's to know how to execute (Passing Parrameter) from Axapta. Please let me know ASAP. Best Regards Jay - Do you Yahoo!? Yahoo! Mail is new and improved - Check it out! [Non-text portions of this message have been removed] Yahoo! Groups Links To: [EMAIL PROTECTED] Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ 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: [development-axapta] Error when Creating Document in CRM Quotation
Hi Akash, Take a look at the template in word. The statement tries to fetch the first table in the template. Does the template have a table (for quotation lines), and is it the the first table in the template? // Jesper Original Message Subject: [development-axapta] Error when Creating Document in CRM Quotation (28-Jun-2004 11:26) From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] hi everybody, I just running in an problem on an Ax 3.0 SP1 environment - maybe some of you have similar experiences and could assist: I try to create a quotation in CRM using the standard docuhandling functionality. the document to create is based on an document type with job description Create CRM quotation document. When creating the document, MS-Word will be started, some (bookmark- related) field will be filled in the word-document...then an axapta errorlog mesage occours: Method 'Item' in COM object of class 'Tables' returned error code 0x800A1735 (unknown) which means: The requested member of the collection does not exist. the error is always thrown in class smmDocuActionCOM_Word_Quotation, method insertQuotationLines(), line 27 COMTable = COMdocument.Tables(); COMTable = COMTable.Item(1); // HERE COMRows = COMTable.Rows(); COMRow = COMRows.Add(); COMCells = COMRow.Cells(); thanks for helping in advance Regards Akash ___ALL-NEW Yahoo! Messenger - so many all-new ways to express yourself http://uk. messenger.yahoo.com Yahoo! Groups Links To: [EMAIL PROTECTED] Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ 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: [development-axapta] Tmp-data in Grid
Hi Morten, cteate a datasource of the table you want to display. If the form is linked you must overwrite the linkActive method. In the Method you add datasource.tmpdata(YourTable). Not the cursor of the datasource points to the tmpData. Take a look at the form LedgerTransBase in standard for an exampel. /Jesper Original Message Subject: [development-axapta] Tmp-data in Grid (28-Jun-2004 11:38) From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Hi How can I present data in grid from a tmp-table? (windows/web) Thanks! Morten [Non-text portions of this message have been removed] Yahoo! Groups Links To: [EMAIL PROTECTED] Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ 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-2: [development-axapta] Error when Creating Document in CRM Quotation
Hi Akash, The COM Object ComTable in an object in Word (ActiveDocument.Tables). The COM object in Axapta expects to find a table in your template. If not it throws an error unknown. Axapta tries to output the quatation lines in a table. Take a look at the templete in Axapta\Share\Include\smm, the template is called Quotation.dot. The template is expected to have the structure given by the template. If not you get in trouble. /Jesper Original Message Subject: Re: [development-axapta] Error when Creating Document in CRM Quotation (28-Jun-2004 15:03) From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Hi jesper, thanks for the reply. I didnt get what u mean by the statement tries to fetch the first table in the template. As i know, i just put some bookmarks in the Word DOC template for the Quotationtable. can u elaborate little more looking forward to you... Regards Akash --- [EMAIL PROTECTED] wrote: Hi Akash, Take a look at the template in word. The statement tries to fetch the first table in the template. Does the template have a table (for quotation lines), and is it the the first table in the template? // Jesper Original Message Subject: [development-axapta] Error when Creating Document in CRM Quotation (28-Jun-2004 11:26) From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] hi everybody, I just running in an problem on an Ax 3.0 SP1 environment - maybe some of you have similar experiences and could assist: I try to create a quotation in CRM using the standard docuhandling functionality. the document to create is based on an document type with job description Create CRM quotation document. When creating the document, MS-Word will be started, some (bookmark- related) field will be filled in the word-document...then an axapta errorlog mesage occours: Method 'Item' in COM object of class 'Tables' returned error code 0x800A1735 (unknown) which means: The requested member of the collection does not exist. the error is always thrown in class smmDocuActionCOM_Word_Quotation, method insertQuotationLines(), line 27 COMTable = COMdocument.Tables(); COMTable = COMTable.Item(1); // HERE COMRows = COMTable.Rows(); COMRow = COMRows.Add(); COMCells = COMRow.Cells(); thanks for helping in advance Regards Akash ___ALL-NEW Yahoo! Messenger - so many all-new ways to express yourself http://uk. messenger.yahoo.com Yahoo! Groups Links To: [EMAIL PROTECTED] Yahoo! Groups Sponsor ~-- Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar. Now with Pop-Up Blocker. Get it for free! http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/saFolB/TM ~- Yahoo! Groups Links http://groups.yahoo.com/group/development-axapta/ [EMAIL PROTECTED] ___ALL-NEW Yahoo! Messenger - so many all-new ways to express yourself http://uk. messenger.yahoo.com Yahoo! Groups Links To: [EMAIL PROTECTED] Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ 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: [development-axapta] element and this
Hi, element would be the father object. This is the current control element. If you are in a datasource in a form, this would be the datasource, to address an mothod from the form, you need to address it using element. /Jesper Original Message Subject: [development-axapta] element and this (29-Jun-2004 22:05) From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] hi guys, I'm a newbie and i need some pointer from experts.What is the difference between element. and this. .Why sometimes it use element and othertime this Thanx in advanced Yahoo! Groups Links To: [EMAIL PROTECTED] Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[development-axapta] SQL case statements
Hi all. Does anybody know a possibility to the SQL case statements in queries? /Jesper Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ 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: [development-axapta] Catch SQL-Exceptions from CONNECTION Class
Hi Bodo, Take a look the ODBCConnection. I think Claudia Göries wrote an answer last week. The class conenction always creates an connection to the current Axapta database. /Jesper Original Message Subject: [development-axapta] Catch SQL-Exceptions from CONNECTION Class (15-Okt-2004 14:22) From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Hi Everyone, I have to make some SQL-Statement to an remote database (Oracle9i Database). For this I use the CONNECTION-Class of axapta. Now I have the problem to catch SQL-/Oracle exceptions, because the standard X++-Exception cover these exceptions. Is there a way to catch the exceptions caused by the SQL-Statement in AXAPTA. Thanks Bodo __ Dr. Ing. Dipl. Inf. (Univ.) Dr. Ing. Bodo Vormann Project Consultant amball business-software Nordostpark 12-14 90411 Nürnberg Phone: +49 (0)9 11 / 5 27 97 -0 Fax: +49 (0)9 11 / 5 27 97 -50 E-Mail: mailto:[EMAIL PROTECTED] Internet: http://www.amball.de SYSTEMS in München Internationale Fachmesse für Informationstechnik, Telekommunikation und Neue Medien Unter dem Motto Komplettlösungen für den Mittelstand präsentiert amball sein umfangreiches Angebotsspektrum vom 18.- 22. Oktober 2004 auf der SYSTEMS in München, Halle A1, Stand 303. Erleben Sie innovative Produkte und interessante Vorträge. Das amball-Team freut sich auf ein Gespräch mit Ihnen. BRAU Beviale vom 10. bis 12. November 2004 Wir stellen vor: amBrau - die Branchenlösung für die Getränkebranche. Wir laden Sie herzlich zur BRAU Beviale in Nürnberg, Halle 1, Stand 320 ein. Erleben Sie innovative Produkte und interessante Vorträge. Das amball-Team freut sich auf das Gespräch mit Ihnen. [Non-text portions of this message have been removed] Yahoo! Groups Links To: [EMAIL PROTECTED] Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ 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: [development-axapta] Re: LabelId's from Enum Values
Hi Ben, you get the result correct, but you change the language temporay for the session. I have solved the problem in the following manner: add this method to the class SysDictEnum: LabelId Value2LabelLabel(int value) { #Properties SysDictEnum SysDictEnum; TreeNode treeNode; ; return findProperty(this.treeNode().AOTfindChild(this.value2Symbol(value)).AOTgetProperties(),#PropertyLabel); } You can test it with this job: static void Job2(Args _args) { sysDictEnum sysDictEnum = new SysDictEnum(EnumNum(LedgerAccountType)); LabelId labelId; ; LabelId = sysDictEnum.Value2LabelLabel(LedgerAccountType::AccountCost); info(labelId); info(SysLabel::labelId2String2(labelId, 'en-us')); info(SysLabel::labelId2String2(labelId, 'nl')); info(SysLabel::labelId2String2(labelId, 'fr')); } yf /Jesper Original Message Subject: [development-axapta] Re: LabelId's from Enum Values (04-Nov-2004 15:12) From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] original i want to get the labelid in format @SYS to translate it into an other language. with LanguageId orglanguageId = infolog.language(); senum = new SysDictEnum( 53 ); infolog.language('en-us'); lid = senum.value2Label(1); infolog.language(orglanguageId); i get the labeltext in the correct language without using the labelid. But thanx for support :-) Ben --- In [EMAIL PROTECTED], onnobid [EMAIL PROTECTED] wrote: ??? in previous post you asked for label id in format @SYSxxx. Value2Label() returns the label but not the id of the label. What do you really mean now? Yahoo! Groups Links To: [EMAIL PROTECTED] Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ 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: [development-axapta] return sqlstatement to user
You get a resultset(Class) from a statement. You extract a string with the method getstring. /Jesper Original Message Subject: [development-axapta] return sqlstatement to user (12-Nov-2004 13:33) From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Im using the command S.executeQuery(Here should the SQL statement be); is it possible to return the value from the statement fx. a select statement to a string ? something like this: str RV; RV = S.executeQuery(Here should the SQL statement be); If i write this i get the error message Operand types are not compatible with the operator I suppose it's necessary to do some data conversion ? thank you in advance Yahoo! Groups Links To: [EMAIL PROTECTED] Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ 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: [development-axapta] Re: return sqlstatement to user
HI try this static void SQLStmt_Demo(Args _args) { Connection Connection; Statement Statement; ResultSet ResultSet; str myString; ; // Create a new connection to the Axapta database connection = new Connection(); // Create a statement for the new connection Statement = connection.createStatement(); // Execute a select statement in the new connection Resultset = statement.executeQuery(select AccountNum from vendtable); // retrive a string from the first collumn in the resultset while (ResultSet.next()) info(ResultSet.getString(1)); } /Jesper Original Message Subject: [development-axapta] Re: return sqlstatement to user (15-Nov-2004 12:54) From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] I can't find the getstring command i can only find one called tostring I can't figure out how to use that one when i use it something like this S.executeQuery( select ... ); S.toString() If i get axapta to print the s.toString it only says: Class Statement Could u give a exampel of how to do it ? --- In [EMAIL PROTECTED], [EMAIL PROTECTED] wrote: You get a resultset(Class) from a statement. You extract a string with the method getstring. /Jesper Original Message Subject: [development-axapta] return sqlstatement to user (12-Nov- 2004 13:33) From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Im using the command S.executeQuery(Here should the SQL statement be); is it possible to return the value from the statement fx. a select statement to a string ? something like this: str RV; RV = S.executeQuery(Here should the SQL statement be); If i write this i get the error message Operand types are not compatible with the operator I suppose it's necessary to do some data conversion ? thank you in advance Yahoo! Groups Links To: [EMAIL PROTECTED] Yahoo! Groups Links To: [EMAIL PROTECTED] Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
AW: [development-axapta] Error when calling WINGDI method..!
Hi, You need a handle to the windows process id. The example below gets the ID of Axapta. DLL user = new DLL('USER32'); DLLFunction getActiveWindow = new DLLFunction(user,'GetActiveWindow'); WINGDI Absi; ; GetActiveWindow.returns(EXTTYPES::DWORD); Absi=new WINGDI(getActiveWindow.call()); Absi.setBKMode(1); Mit freundlichen Grüßen / Best regards / Med venlig hilsen Jesper Jørgensen NMS - Entwicklung Axapta arvato systems Technologies GmbH An der Autobahn 18 33311 Gütersloh http://www.arvato-systems.de BLOCKED::http://www.arvato-systems.de/ E-Mail: [EMAIL PROTECTED] Phone: 05242 / 40 80 54 Fax: 05242 / 40 80 40 Mobile: 0172 / 571 03 34 Der Inhalt dieser Nachricht oder eventueller Anlagen ist vertraulich und ausschließlich für den bezeichneten Adressaten bestimmt. Bitte stellen Sie sicher, dass die Information in dieser Nachricht ausschließlich an die adressierten Personen gelangt. Sollte diese Nachricht versehentlich an Sie gesendet worden sein, dann informieren Sie bitte umgehend den Absender und löschen Sie die Nachricht. Vielen Dank. The information in this e-mail and any attachments is confidential. The information must only be held in areas that have controlled and limited access to the addressed persons. If this e-mail has been sent to you in error, please immediately notify the sender and delete the e-mail. Thanks. _ Von: abdulabsi [mailto:[EMAIL PROTECTED] Gesendet: Freitag, 18. Februar 2005 15:38 An: development-axapta@yahoogroups.com Betreff: [development-axapta] Error when calling WINGDI method..! Hi guys, I am facing a probelm in calling one of the Axapta WINGDI class methods called setBKMode(int i). I am call it from a testing job:- static void Job5(Args _args) { WINGDI Absi; ; Absi=new WINGDI(1); Absi.setBKMode(1); } When I run this job I got DLL funtion was not found,Can not creat DLL function Error. Any advises..! Regards, Absi _ Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/development-axapta/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to the Yahoo! http://docs.yahoo.com/info/terms/ Terms of Service. [Non-text portions of this message have been removed] Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
AW: [development-axapta] Add dynalinks programatically
Hi Lars, try this Table_q.dataSourceNo(1).addDynalink(fieldNum(Table, Field), element.args().record(), fieldnum(callerTable, RelationField) ); Mit freundlichen Grüßen / Best regards / Med venlig hilsen Jesper Jørgensen NMS - Entwicklung Axapta arvato systems Technologies GmbH An der Autobahn 18 33311 Gütersloh http://www.arvato-systems.de BLOCKED::http://www.arvato-systems.de/ E-Mail: [EMAIL PROTECTED] Phone: 05242 / 40 80 54 Fax: 05242 / 40 80 40 Mobile: 0172 / 571 03 34 Der Inhalt dieser Nachricht oder eventueller Anlagen ist vertraulich und ausschließlich für den bezeichneten Adressaten bestimmt. Bitte stellen Sie sicher, dass die Information in dieser Nachricht ausschließlich an die adressierten Personen gelangt. Sollte diese Nachricht versehentlich an Sie gesendet worden sein, dann informieren Sie bitte umgehend den Absender und löschen Sie die Nachricht. Vielen Dank. The information in this e-mail and any attachments is confidential. The information must only be held in areas that have controlled and limited access to the addressed persons. If this e-mail has been sent to you in error, please immediately notify the sender and delete the e-mail. Thanks. _ Von: Lars Holm [mailto:[EMAIL PROTECTED] Gesendet: Freitag, 11. März 2005 10:57 An: development-axapta@yahoogroups.com Betreff: [development-axapta] Add dynalinks programatically Hi all, Is it possible somehow to add dynalinks programatically? Example: Form 1 calls Form2. Between those, there's a dynalink which is maintained by the kernel (I think). When I change a record in form1, the corresponding record is shown in Form2. Which record depends on the relations between the tables of course. But if I would like to open Form2 from code - e.g. from a class, how can I make that form establish a dynalink to a certain record in my class - is it possible? I do not want to fiddle with doubtful code like creating a Form from code etc. Thanks. Best regards, Lars [Non-text portions of this message have been removed] Yahoo! Groups Sponsor ADVERTISEMENT http://us.ard.yahoo.com/SIG=12997081k/M=298184.6018725.7038619.3001176/D=groups/S=1705006764:HM/EXP=1110624080/A=2593423/R=0/SIG=11el9gslf/*http:/www.netflix.com/Default?mqso=60190075 click here http://us.adserver.yahoo.com/l?M=298184.6018725.7038619.3001176/D=groups/S=:HM/A=2593423/rand=967415569 _ Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/development-axapta/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to the Yahoo! http://docs.yahoo.com/info/terms/ Terms of Service. [Non-text portions of this message have been removed] Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
AW: [development-axapta] Select where with a filter
Hi, You need to use * in Aaapra. If you are selecting with wildcards you need to use the keyword like not ==. /Jesper Von: Padmaja Iyingar [mailto:[EMAIL PROTECTED] Gesendet: Montag, 14. März 2005 05:06 An: development-axapta@yahoogroups.com; Axapta-Knowledge-Village@yahoogroups.com Betreff: [development-axapta] Select where with a filter Hi , I am trying to select Sum of accounts's AmoustMST for that particular Voucher series. ///For example I want to sum up all accounts only for the voucher F111*. I can not do a substr in the select WHERE clause as its a database field. 'select LedgerTrans where LedgerTrans.Accountnum = 1000 LedgerTrans.AccountNUm =2000 LedgerTrans.TrandsDate= 1\1\2004 LedgerTrans.Voucher == 'F111%' is not working.. I thought F111% is equal to F111*. How can I selectively select this one?. Can some one help please? Thanks, Padmaja Iyer. __ 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] Yahoo! Groups Sponsor ADVERTISEMENT http://us.ard.yahoo.com/SIG=129cv5dhj/M=298184.6018725.7038619.3001176/D=groups/S=1705006764:HM/EXP=1110873160/A=2593423/R=0/SIG=11el9gslf/*http:/www.netflix.com/Default?mqso=60190075 click here http://us.adserver.yahoo.com/l?M=298184.6018725.7038619.3001176/D=groups/S=:HM/A=2593423/rand=420965999 _ Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/development-axapta/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to the Yahoo! http://docs.yahoo.com/info/terms/ Terms of Service. [Non-text portions of this message have been removed] Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
AW: [development-axapta] operation from combination of enum
Hi You can loop over an enum like this static void EnumTest(Args _args) { SysDictenum dictEnum; Counter counter; ; dictEnum = new SysDictEnum(EnumNum(ABC)); for (counter = 0; counter dictEnum.values(); counter++) { print dictEnum.index2Name(counter); } pause; } Yf jesper Von: Hans-Walter Bous [mailto:[EMAIL PROTECTED] Gesendet: Donnerstag, 17. März 2005 09:21 An: development-axapta@yahoogroups.com Betreff: Re: [development-axapta] operation from combination of enum Hi, you can do something like this: switch (enumA) { case(enumA::TypeA) : switch (enumB) { case(enumB::TypeA) : do something; break; } } John daniellim_yh [EMAIL PROTECTED] wrote: hi all, i have 2 enum type, 4 elements each, i wonder wat is the best way for me to do like this in axapta. if (enum1::typeA enum2::typeW) Do something1 else if (enum1::typeA enum2::typeX) Do something 2 else if (enum1::typeA enum2::typeY) do something 3 . . . . if (enum1::typeD enum2::Z) do something 16 with 2 combinations of 2 enums i will have 16 combinations, any better way of it?using enum element position to do looping may be?but as i know i cannot get enum position like container. pls provide any idea. thx in advance. rgds, daniel Yahoo! Groups SponsorADVERTISEMENT - Yahoo! Groups Links To visit your group on the web, go to: http://groups.yahoo.com/group/development-axapta/ To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. - Gesendet von Yahoo! Mail - Jetzt mit 250MB kostenlosem Speicher [Non-text portions of this message have been removed] Yahoo! Groups Sponsor ADVERTISEMENT http://us.ard.yahoo.com/SIG=129t0i8t6/M=298184.6191685.7192823.3001176/D=groups/S=1705006764:HM/EXP=134767/A=2593423/R=0/SIG=11el9gslf/*http:/www.netflix.com/Default?mqso=60190075 click here http://us.adserver.yahoo.com/l?M=298184.6191685.7192823.3001176/D=groups/S=:HM/A=2593423/rand=238787453 _ Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/development-axapta/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to the Yahoo! http://docs.yahoo.com/info/terms/ Terms of Service. [Non-text portions of this message have been removed] Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[development-axapta] Fielproperties
Hi all. Can I set a field (in a primary index) to case insensitive from within Axapta? I need to build hold the components a as well as A in the index. My database is set to Latin1_genarel_CP1_CI_AS. /Jesper Mit freundlichen Grüßen / Best regards / Med venlig hilsen Jesper Jørgensen NMS - Entwicklung Axapta arvato systems Technologies GmbH An der Autobahn 18 33311 Gütersloh http://www.arvato-systems.de BLOCKED::http://www.arvato-systems.de/ E-Mail: [EMAIL PROTECTED] Phone: 05242 / 40 80 54 Fax: 05242 / 40 80 40 Mobile: 0172 / 571 03 34 Der Inhalt dieser Nachricht oder eventueller Anlagen ist vertraulich und ausschließlich für den bezeichneten Adressaten bestimmt. Bitte stellen Sie sicher, dass die Information in dieser Nachricht ausschließlich an die adressierten Personen gelangt. Sollte diese Nachricht versehentlich an Sie gesendet worden sein, dann informieren Sie bitte umgehend den Absender und löschen Sie die Nachricht. Vielen Dank. The information in this e-mail and any attachments is confidential. The information must only be held in areas that have controlled and limited access to the addressed persons. If this e-mail has been sent to you in error, please immediately notify the sender and delete the e-mail. Thanks. [Non-text portions of this message have been removed] Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
AW: [development-axapta] Fielproperties
Hi Herbert, I know, but in the SQL Server I can set a single row to use a different collation. I an looking for a possibility to control this row property on the SQL server from Axapta. Mit freundlichen Grüßen / Best regards / Med venlig hilsen Jesper Jørgensen NMS - Entwicklung Axapta arvato systems Technologies GmbH An der Autobahn 18 33311 Gütersloh http://www.arvato-systems.de BLOCKED::http://www.arvato-systems.de/ E-Mail: [EMAIL PROTECTED] Phone: 05242 / 40 80 54 Fax: 05242 / 40 80 40 Mobile: 0172 / 571 03 34 Der Inhalt dieser Nachricht oder eventueller Anlagen ist vertraulich und ausschließlich für den bezeichneten Adressaten bestimmt. Bitte stellen Sie sicher, dass die Information in dieser Nachricht ausschließlich an die adressierten Personen gelangt. Sollte diese Nachricht versehentlich an Sie gesendet worden sein, dann informieren Sie bitte umgehend den Absender und löschen Sie die Nachricht. Vielen Dank. The information in this e-mail and any attachments is confidential. The information must only be held in areas that have controlled and limited access to the addressed persons. If this e-mail has been sent to you in error, please immediately notify the sender and delete the e-mail. Thanks. _ Von: Leberbauer, Herbert - News [mailto:[EMAIL PROTECTED] Gesendet: Dienstag, 29. März 2005 11:24 An: development-axapta@yahoogroups.com Betreff: AW: [development-axapta] Fielproperties Hi Jesper! Your database is already caseINsensitive (the ..._CI_... in Latin1_genarel_CP1_CI_AS means CaseInsensitive). HTH Herbert | -Ursprüngliche Nachricht- | Von: [EMAIL PROTECTED] | [mailto:[EMAIL PROTECTED] | Gesendet: Dienstag, 29. März 2005 10:45 | An: development-axapta@yahoogroups.com | Betreff: [development-axapta] Fielproperties | | | | | | Hi all. | | | | Can I set a field (in a primary index) to case insensitive | from within Axapta? I need to build hold the components a | as well as A in the index. | | My database is set to Latin1_genarel_CP1_CI_AS. | | | | /Jesper | | | | Mit freundlichen Grüßen / Best regards / Med venlig hilsen | | | | Jesper Jørgensen | | NMS - Entwicklung Axapta | | arvato systems Technologies GmbH | | An der Autobahn 18 | | 33311 Gütersloh | | http://www.arvato-systems.de BLOCKED::http://www.arvato-systems.de/ | | E-Mail: [EMAIL PROTECTED] | | Phone: 05242 / 40 80 54 | | Fax: 05242 / 40 80 40 | | Mobile: 0172 / 571 03 34 | | __ | __ | | Der Inhalt dieser Nachricht oder eventueller Anlagen ist | vertraulich und ausschließlich für den bezeichneten | Adressaten bestimmt. Bitte stellen Sie sicher, dass die | Information in dieser Nachricht ausschließlich an die | adressierten Personen gelangt. Sollte diese Nachricht | versehentlich an Sie gesendet worden sein, dann informieren | Sie bitte umgehend den Absender und löschen Sie die | Nachricht. Vielen Dank. | | The information in this e-mail and any attachments is | confidential. The information must only be held in areas that | have controlled and limited access to the addressed persons. | If this e-mail has been sent to you in error, please | immediately notify the sender and delete the e-mail. Thanks. | | | | | | [Non-text portions of this message have been removed] | | | | | | | | Yahoo! Groups Links | | | | | | | Yahoo! Groups Sponsor ADVERTISEMENT http://us.ard.yahoo.com/SIG=129lf5e97/M=298184.6191685.7192823.3001176/D=groups/S=1705006764:HM/EXP=1112175054/A=2593423/R=0/SIG=11el9gslf/*http:/www.netflix.com/Default?mqso=60190075 click here http://us.adserver.yahoo.com/l?M=298184.6191685.7192823.3001176/D=groups/S=:HM/A=2593423/rand=509036438 _ Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/development-axapta/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to the Yahoo! http://docs.yahoo.com/info/terms/ Terms of Service. [Non-text portions of this message have been removed] Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
AW: [development-axapta] Open a excelfile
HI, use SysExcelWorkbooks Open to open an existing file. Workbooks add will always add a new workbook to the existing instance of excel. Mit freundlichen Grüßen / Best regards / Med venlig hilsen Jesper Jørgensen NMS - Entwicklung Axapta arvato systems Technologies GmbH An der Autobahn 18 33311 Gütersloh http://www.arvato-systems.de BLOCKED::http://www.arvato-systems.de/ E-Mail: [EMAIL PROTECTED] Phone: 05242 / 40 80 54 Fax: 05242 / 40 80 40 Mobile: 0172 / 571 03 34 Der Inhalt dieser Nachricht oder eventueller Anlagen ist vertraulich und ausschließlich für den bezeichneten Adressaten bestimmt. Bitte stellen Sie sicher, dass die Information in dieser Nachricht ausschließlich an die adressierten Personen gelangt. Sollte diese Nachricht versehentlich an Sie gesendet worden sein, dann informieren Sie bitte umgehend den Absender und löschen Sie die Nachricht. Vielen Dank. The information in this e-mail and any attachments is confidential. The information must only be held in areas that have controlled and limited access to the addressed persons. If this e-mail has been sent to you in error, please immediately notify the sender and delete the e-mail. Thanks. _ Von: anettemalmberg [mailto:[EMAIL PROTECTED] Gesendet: Dienstag, 29. März 2005 13:48 An: development-axapta@yahoogroups.com Betreff: [development-axapta] Open a excelfile Hi, I try to open an excel-document from a table ProdRoute via menuItem (Display) atached to a form but I've only got a copy of the Excelfile and not the original file. I think the reason for that is codestring sysExcelWorkbook = sysExcelWorkbooks.add (COMVariant);, but I am not sure. This is my init() method on a form void init() { Args callerArgs; ProdRoute ProdRoute; FileNameOpen File2Display; COMVariant COMVariant; SysExcelApplication sysExcelApplication; SysExcelWorkbooks sysExcelWorkbooks; SysExcelWorkbook sysExcelWorkbook; SysExcelWorksheet sysExcelWorksheet; super(); COMVariant = new COMVariant(); if (element.args()) { callerArgs = element.args(); if (callerArgs.dataset() == tablenum(ProdRoute)) { ProdRoute = callerArgs.record(); File2Display = ProdRoute.File2display(); } } sysExcelApplication = SysExcelApplication::construct(); sysExcelApplication.visible(true); sysExcelWorkbooks = sysExcelApplication.workbooks(); COMVariant.bStr(File2Display); sysExcelWorkbook = sysExcelWorkbooks.add(COMVariant); sysExcelWorkbook.saved(true); element.close(); } } Thanks! Yahoo! Groups Sponsor ADVERTISEMENT http://us.ard.yahoo.com/SIG=129a8epd8/M=298184.6018725.7038619.3001176/D=groups/S=1705006764:HM/EXP=1112183554/A=2593423/R=0/SIG=11el9gslf/*http:/www.netflix.com/Default?mqso=60190075 click here http://us.adserver.yahoo.com/l?M=298184.6018725.7038619.3001176/D=groups/S=:HM/A=2593423/rand=791956484 _ Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/development-axapta/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to the Yahoo! http://docs.yahoo.com/info/terms/ Terms of Service. [Non-text portions of this message have been removed] Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
AW: [development-axapta] Fielproperties
Hi Herbert We are working on a module to dynamically convert charters upon import or export from Axapta. You need to substitute an Germany ö to #246; and a Ö to #214; in a XML format (Other scenarios are EBCDICT, ASCII etc.). It would have been nice if I could just change the collation sequence on one single row from within Axapta (it works fine if I change the setting on the SQl table, BUT Axapta modifies it right back). I guess I need to save the ANSI value for the Index to make it work, not nice! Regards Jesper Von: Leberbauer, Herbert - News [mailto:[EMAIL PROTECTED] Gesendet: Dienstag, 29. März 2005 16:06 An: development-axapta@yahoogroups.com Betreff: AW: [development-axapta] Fielproperties Hi Jesper, the problem is, that Axapta does not support this kind of operations on the SQL-Server (Oracle either). So, if you find a way to do what you want, which is possible, Microsoft will not give any support, to what you are doing. So I would try to find another solution for your problem. Why do you want to change the sensitivity? Regards Herbert | -Ursprüngliche Nachricht- | Von: [EMAIL PROTECTED] | [mailto:[EMAIL PROTECTED] | Gesendet: Dienstag, 29. März 2005 14:36 | An: development-axapta@yahoogroups.com | Betreff: AW: [development-axapta] Fielproperties | | | | Hi Herbert, | | | | I know, but in the SQL Server I can set a single row to use a | different collation. I an looking for a possibility to | control this row property on the SQL server from Axapta. | | | | | | Mit freundlichen Grüßen / Best regards / Med venlig hilsen | | | | Jesper Jørgensen | | NMS - Entwicklung Axapta | | arvato systems Technologies GmbH | | An der Autobahn 18 | | 33311 Gütersloh | | http://www.arvato-systems.de BLOCKED::http://www.arvato-systems.de/ | | E-Mail: [EMAIL PROTECTED] | | Phone: 05242 / 40 80 54 | | Fax: 05242 / 40 80 40 | | Mobile: 0172 / 571 03 34 | | __ | __ | | Der Inhalt dieser Nachricht oder eventueller Anlagen ist | vertraulich und ausschließlich für den bezeichneten | Adressaten bestimmt. Bitte stellen Sie sicher, dass die | Information in dieser Nachricht ausschließlich an die | adressierten Personen gelangt. Sollte diese Nachricht | versehentlich an Sie gesendet worden sein, dann informieren | Sie bitte umgehend den Absender und löschen Sie die | Nachricht. Vielen Dank. | | The information in this e-mail and any attachments is | confidential. The information must only be held in areas that | have controlled and limited access to the addressed persons. | If this e-mail has been sent to you in error, please | immediately notify the sender and delete the e-mail. Thanks. | | _ | | Von: Leberbauer, Herbert - News [mailto:[EMAIL PROTECTED] | Gesendet: Dienstag, 29. März 2005 11:24 | An: development-axapta@yahoogroups.com | Betreff: AW: [development-axapta] Fielproperties | | | | | Hi Jesper! | | Your database is already caseINsensitive (the ..._CI_... in | Latin1_genarel_CP1_CI_AS means CaseInsensitive). | | HTH | Herbert | | | -Ursprüngliche Nachricht- | | Von: [EMAIL PROTECTED] | | [mailto:[EMAIL PROTECTED] | | Gesendet: Dienstag, 29. März 2005 10:45 | | An: development-axapta@yahoogroups.com | | Betreff: [development-axapta] Fielproperties | | | | | | | | | | | | Hi all. | | | | | | | | Can I set a field (in a primary index) to case insensitive | from within | | Axapta? I need to build hold the components a | | as well as A in the index. | | | | My database is set to Latin1_genarel_CP1_CI_AS. | | | | | | | | /Jesper | | | | | | | | Mit freundlichen Grüßen / Best regards / Med venlig hilsen | | | | | | | | Jesper Jørgensen | | | | NMS - Entwicklung Axapta | | | | arvato systems Technologies GmbH | | | | An der Autobahn 18 | | | | 33311 Gütersloh | | | | http://www.arvato-systems.de | BLOCKED::http://www.arvato-systems.de/ | | | | E-Mail: [EMAIL PROTECTED] | | | | Phone: 05242 / 40 80 54 | | | | Fax: 05242 / 40 80 40 | | | | Mobile: 0172 / 571 03 34 | | | | __ | | __ | | | | Der Inhalt dieser Nachricht oder eventueller Anlagen ist | vertraulich | | und ausschließlich für den bezeichneten Adressaten bestimmt. Bitte | | stellen Sie sicher, dass die Information in dieser Nachricht | | ausschließlich an die adressierten Personen gelangt. Sollte diese | | Nachricht versehentlich an Sie gesendet worden sein, dann | informieren | | Sie bitte umgehend den Absender und löschen Sie die | Nachricht. Vielen | | Dank. | | | | The information in this e-mail and any attachments is | confidential. | | The information must only be held in areas that have controlled and | | limited access to the addressed persons. | | If this e-mail has been sent to you in error, please immediately | | notify the sender
AW: [development-axapta] Re: Formbuilddatasource - adding a datasource runtime to an already running form
HI Lars, Take a look at the form SysRecordInfo, The form generates a new form and uses FormBuildDatasource. I am having problems attaching a new data source to an existing form at runtime. You can add a new data source, but you can not attach a table to the data source. /Jesper Von: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] Gesendet: Montag, 18. April 2005 11:47 An: development-axapta@yahoogroups.com Betreff: RE: [development-axapta] Re: Formbuilddatasource - adding a datasource runtime to an already running form Hi Harry, Okay, I will try to describe what I want to do. The user should be able to setup which forms should display some additional information in the grid or other control. E.g. in the salestable form, some additional fields would be displayed in the grid if the form is setup for this. This additional data is stored in a 1:1 related table with refrecid and reftableid relation. Then, in the syssetupformrun I will add the datasource to the particular form and add the display controls etc. too, thus it must be done at runtime. I can not modify all the forms in the AOT in Axapta just for this reason. I hope this described it in a sensible and informative way. If not, please let me know. Looking forward to hearing your suggestions. Thanks. Best regards, Lars Holm Senior Technical Consultant -Original Message- From: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Harry (Harshawardhan Deshpande Sent: 17. april 2005 10:16 To: development-axapta@yahoogroups.com Subject: Re: [development-axapta] Re: Formbuilddatasource - adding a datasource runtime to an already running form hi I am not sure how to add a datasource @run time but if you could let know exactly what you are trying to achieve then perhaps I could be of some help. regards harry --- In development-axapta@yahoogroups.com, Lars Holm [EMAIL PROTECTED] wrote: Hi Manfred, Thanks for your reply. Do you know how to add a formdatasource at runtime? I can't find any ways to do it myself. However, I still think it must be a formbuilddatasource because e.g. formbuildcontrol's can be added at runtime - but not a formbuilddatasource. I suspect it's a bug in Axapta. Best regards, Lars Holm Senior Technical Consultant -Original Message- - Do you Yahoo!? Yahoo! Mail - You care about security. So do we. [Non-text portions of this message have been removed] Yahoo! Groups Links _ Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/development-axapta/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] be * Your use of Yahoo! Groups is subject to the Yahoo! http://docs.yahoo.com/info/terms/ Terms of Service. [Non-text portions of this message have been removed] Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
AW: [development-axapta] statement where not and not like
Hi Lars, Sorry but I need to correct you concerning the support of like in Axapta. Axapta does support like. Try this out. static void TestLike(Args _args) { InventTable it; ; while select it where !(it.ItemId like '1*') { info(it.ItemId); } } /Jesper Von: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] Gesendet: Sonntag, 24. April 2005 22:09 An: development-axapta@yahoogroups.com Betreff: RE: [development-axapta] statement where not and not like Where not = Where != Axapta does not support the like syntax. Best regards, Lars Holm Senior Technical Consultant T O I N C R E A S E - Y O U R B U S I N E S S -Original Message- From: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of jaiver avila Sent: 22. april 2005 22:47 To: development-axapta@yahoogroups.com Subject: [development-axapta] statement where not and not like What statement replace the where not not like of sql in axapta _ Do You Yahoo!? Información de Estados Unidos y América Latina, en Yahoo! Noticias. Visítanos en http://noticias.espanol.yahoo.com Yahoo! Groups Links _ Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/development-axapta/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to the Yahoo! http://docs.yahoo.com/info/terms/ Terms of Service. [Non-text portions of this message have been removed] Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
AW: [development-axapta] How to connect to Axapta Installations for Data-Exchange
Hi Herbert, You can programme the inter company using COM, or use the commerce gateway and BizTalk in Standard. If you want the full inter company you need to implement it using COM, sorry. /Jesper _ Von: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] Gesendet: Montag, 8. August 2005 15:06 An: development-axapta@yahoogroups.com Betreff: [development-axapta] How to connect to Axapta Installations for Data-Exchange Hello! Is there someone out there who has ever made a connection between two different Axapta-Installations (yes, 2 DBs and 2 Appl-Folders), to establish some kind of data exchange. We want to do the following: We have two installations (different DB-Server, different AOS, different Applications). Those two installations are identical in regards of the Application. Only the data on the DB-Server is different. Now we would like to establish intercompany functionality between those two Axaptas. We already thought of batch-processing, we thougt of using Axapta.ComConnector - but I think, there must be a more easier way, mustn't it? Or is there a way, an Axapta-Clients connects to two different AOS-Instances in one session? So could you help me and tell me, what you thought of, or what you did? Thank you! Herbert SPONSORED LINKS Computer http://groups.yahoo.com/gads?t=msk=Computer+partw1=Computer+partw2=P rogramming+languagesw3=Microsoft+axaptaw4=Support+exchangec=4s=90.s ig=yLpvcLTIDJ5FTkRJGsO11w part Programming http://groups.yahoo.com/gads?t=msk=Programming+languagesw1=Computer+p artw2=Programming+languagesw3=Microsoft+axaptaw4=Support+exchangec=4 s=90.sig=cuhEClK4dU4wapXFmKisbQ languages Microsoft http://groups.yahoo.com/gads?t=msk=Microsoft+axaptaw1=Computer+partw 2=Programming+languagesw3=Microsoft+axaptaw4=Support+exchangec=4s=90 .sig=yfeG_U6QaLfPOZZIud02Fg axapta Support http://groups.yahoo.com/gads?t=msk=Support+exchangew1=Computer+partw 2=Programming+languagesw3=Microsoft+axaptaw4=Support+exchangec=4s=90 .sig=hy8yRGMzrmxdphyITTUeqA exchange _ YAHOO! GROUPS LINKS * Visit your group development-axapta http://groups.yahoo.com/group/development-axapta on the web. * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] be * Your use of Yahoo! Groups is subject to the Yahoo! http://docs.yahoo.com/info/terms/ Terms of Service. _ [Non-text portions of this message have been removed] SPONSORED LINKS Computer part Programming languages Microsoft axapta Support exchange YAHOO! GROUPS LINKS Visit your group "development-axapta" 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.
AW: [development-axapta] Urgent : How to upload data to generate Sales orders
Hi Preety, You should use the class SalesAutoCreate, or create an extension of it to meet your demands. Cheers Jesper Von: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] Im Auftrag von Priyank Krishna Gesendet: Mittwoch, 19. Oktober 2005 17:43 An: development-axapta@yahoogroups.com; Axapta-Knowledge-Village@yahoogroups.com Betreff: [development-axapta] Urgent : How to upload data to generate Sales orders Can anyone please tell me the way to upload data in SalesTable SalesLine with the purpose of creating Sales orders. Any responses are welcome. Cheers, Preety - Yahoo! India Matrimony: Find your partner now. [Non-text portions of this message have been removed] YAHOO! GROUPS LINKS * Visit your group development-axapta http://groups.yahoo.com/group/development-axapta on the web. * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] be * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service http://docs.yahoo.com/info/terms/ . [Non-text portions of this message have been removed] SPONSORED LINKS Computer part Programming languages Microsoft axapta Support exchange YAHOO! GROUPS LINKS Visit your group "development-axapta" 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.
AW: [development-axapta] Creating a class from class name
Hi Try this XUtilIdElements::find(UtilElementType::Class, 'ABCBase').id; Mit freundlichen Grüßen / Best regards / Med venlig hilsen Jesper Jørgensen / Abt. NMT-XD Entwicklung Axapta arvato systems | Technologies GmbH An der Autobahn 18 33311 Gütersloh [EMAIL PROTECTED] blocked::mailto:[EMAIL PROTECTED] http://www.arvato-systems.de blocked::BLOCKED::http://www.arvato-systems.de/ Phone: +49 5242 / 40 80 54 Fax: +49 5242 / 40 80 40 Mobile: +49 172 / 571 03 34 Der Inhalt dieser Nachricht oder eventueller Anlagen ist vertraulich und ausschließlich für den bezeichneten Adressaten bestimmt. Bitte stellen Sie sicher, dass die Information in dieser Nachricht ausschließlich an die adressierten Personen gelangt. Sollte diese Nachricht versehentlich an Sie gesendet worden sein, dann informieren Sie bitte umgehend den Absender und löschen Sie die Nachricht. Vielen Dank. The information in this e-mail and any attachments is confidential. The information must only be held in areas that have controlled and limited access to the addressed persons. If this e-mail has been sent to you in error, please immediately notify the sender and delete the e-mail. Thanks. Von: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] Im Auftrag von massimoiuri Gesendet: Mittwoch, 1. Februar 2006 11:01 An: development-axapta@yahoogroups.com Betreff: [development-axapta] Creating a class from class name Can I create an instance of a class giving only the class name (a string parameter) ? I am looking for a method similar to ClassFactory.createClass(classnum(MyClass)); but I want to pass the string containing the class name. Is there any method to get the class number giving only the class name in string ? thanks in advance SPONSORED LINKS Computer part http://groups.yahoo.com/gads?t=msk=Computer+partw1=Computer+partw2=Programming+languagesw3=Microsoft+axaptaw4=Support+exchangec=4s=90.sig=yLpvcLTIDJ5FTkRJGsO11w Programming languages http://groups.yahoo.com/gads?t=msk=Programming+languagesw1=Computer+partw2=Programming+languagesw3=Microsoft+axaptaw4=Support+exchangec=4s=90.sig=cuhEClK4dU4wapXFmKisbQ Microsoft axapta http://groups.yahoo.com/gads?t=msk=Microsoft+axaptaw1=Computer+partw2=Programming+languagesw3=Microsoft+axaptaw4=Support+exchangec=4s=90.sig=yfeG_U6QaLfPOZZIud02Fg Support exchange http://groups.yahoo.com/gads?t=msk=Support+exchangew1=Computer+partw2=Programming+languagesw3=Microsoft+axaptaw4=Support+exchangec=4s=90.sig=hy8yRGMzrmxdphyITTUeqA YAHOO! GROUPS LINKS * Visit your group development-axapta http://groups.yahoo.com/group/development-axapta on the web. * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service http://docs.yahoo.com/info/terms/ . [Non-text portions of this message have been removed] YAHOO! GROUPS LINKS Visit your group "development-axapta" 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.
AW: [development-axapta] Re: Determine if a module is included
U can use the configurationkey to determin is a function is active, if you want to query on the licensecode try this. static void Job2(Args _args) { Dictionary dictionary = new Dictionary(); SysConfig sysConfigTemp; select sysConfigTemp where sysConfigTemp.id == LicensecodeNum(projadvanced); print dictionary.testCode(sysConfigTemp.id, strUpr(sysConfigTemp.value), xSysConfig::find(ConfigType::LicensName,0).value, xSysConfig::find(ConfigType::SerialNo,0).value, str2date(xSysConfig::find(ConfigType::LicensName,1).value, 321)); pause; } Mit freundlichen Grüßen / Best regards / Med venlig hilsen Jesper Jørgensen / Abt. NMT-XD Entwicklung Axapta arvato systems | Technologies GmbH An der Autobahn 18 33311 Gütersloh [EMAIL PROTECTED] blocked::mailto:[EMAIL PROTECTED] http://www.arvato-systems.de blocked::BLOCKED::http://www.arvato-systems.de/ Phone: +49 5242 / 40 80 54 Fax: +49 5242 / 40 80 40 Mobile: +49 172 / 571 03 34 Der Inhalt dieser Nachricht oder eventueller Anlagen ist vertraulich und ausschließlich für den bezeichneten Adressaten bestimmt. Bitte stellen Sie sicher, dass die Information in dieser Nachricht ausschließlich an die adressierten Personen gelangt. Sollte diese Nachricht versehentlich an Sie gesendet worden sein, dann informieren Sie bitte umgehend den Absender und löschen Sie die Nachricht. Vielen Dank. The information in this e-mail and any attachments is confidential. The information must only be held in areas that have controlled and limited access to the addressed persons. If this e-mail has been sent to you in error, please immediately notify the sender and delete the e-mail. Thanks. Von: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] Im Auftrag von kwc_thydev Gesendet: Mittwoch, 1. Februar 2006 13:57 An: development-axapta@yahoogroups.com Betreff: [development-axapta] Re: Determine if a module is included Hi, Try this function. isConfigurationKeyEnabled(configurationKeyNum(ProjAdvanced)) Best regards, thy:development Karsten Wollesen Clausen System Developer --- In development-axapta@yahoogroups.com, Andre Klopper [EMAIL PROTECTED] wrote: Hi I want do check by code if Projects II has been installed (licensed). How can I determine this? Regards, Andre Klopper SPONSORED LINKS Computer part http://groups.yahoo.com/gads?t=msk=Computer+partw1=Computer+partw2=Programming+languagesw3=Microsoft+axaptaw4=Support+exchangec=4s=90.sig=yLpvcLTIDJ5FTkRJGsO11w Programming languages http://groups.yahoo.com/gads?t=msk=Programming+languagesw1=Computer+partw2=Programming+languagesw3=Microsoft+axaptaw4=Support+exchangec=4s=90.sig=cuhEClK4dU4wapXFmKisbQ Microsoft axapta http://groups.yahoo.com/gads?t=msk=Microsoft+axaptaw1=Computer+partw2=Programming+languagesw3=Microsoft+axaptaw4=Support+exchangec=4s=90.sig=yfeG_U6QaLfPOZZIud02Fg Support exchange http://groups.yahoo.com/gads?t=msk=Support+exchangew1=Computer+partw2=Programming+languagesw3=Microsoft+axaptaw4=Support+exchangec=4s=90.sig=hy8yRGMzrmxdphyITTUeqA YAHOO! GROUPS LINKS * Visit your group development-axapta http://groups.yahoo.com/group/development-axapta on the web. * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service http://docs.yahoo.com/info/terms/ . [Non-text portions of this message have been removed] YAHOO! GROUPS LINKS Visit your group "development-axapta" 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.
AW: [development-axapta] How to find the data type of the field
Hi Try this: static void Job1(Args _args) { SysDictTable dictTable; SysDictField dictField; SysDictType dictType; SysDictEnum dictEnum; str baseType; Counter fieldCounter; Counter arrayCounter; ; dictTable = new SysDictTable(TableNum(CustTable)); for (fieldCounter = 1; fieldCounter = dictTable.fieldCnt(); fieldCounter++) { dictField = new SysDictField(dictTable.id(), dictTable.fieldCnt2Id(fieldCounter)); for (arrayCounter = 1; arrayCounter = dictField.arraySize(); arrayCounter++) { dictField = new SysDictField(dictTable.id(), dictTable.fieldCnt2Id(fieldCounter), arrayCounter); if (dictField.typeId()) { dictType = new SysDictType(dictField.typeId()); info(strfmt(EDT %1,dictType.name())); } if (dictField.enumId()) { dictEnum = new SysDictEnum(dictField.enumId()); info(strfmt(Enumname %1, dictEnum.name())); } info(strfmt(Basa Data Type %1, dictField.baseType())); } } } Mit freundlichen Grüßen / Best regards / Med venlig hilsen Jesper Jørgensen / Abt. NMT-XD Entwicklung Axapta arvato systems | Technologies GmbH An der Autobahn 18 33311 Gütersloh [EMAIL PROTECTED] blocked::mailto:[EMAIL PROTECTED] http://www.arvato-systems.de blocked::BLOCKED::http://www.arvato-systems.de/ Phone: +49 5242 / 40 80 54 Fax: +49 5242 / 40 80 40 Mobile: +49 172 / 571 03 34 Der Inhalt dieser Nachricht oder eventueller Anlagen ist vertraulich und ausschließlich für den bezeichneten Adressaten bestimmt. Bitte stellen Sie sicher, dass die Information in dieser Nachricht ausschließlich an die adressierten Personen gelangt. Sollte diese Nachricht versehentlich an Sie gesendet worden sein, dann informieren Sie bitte umgehend den Absender und löschen Sie die Nachricht. Vielen Dank. The information in this e-mail and any attachments is confidential. The information must only be held in areas that have controlled and limited access to the addressed persons. If this e-mail has been sent to you in error, please immediately notify the sender and delete the e-mail. Thanks. Von: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] Im Auftrag von V G Gesendet: Dienstag, 25. April 2006 08:15 An: development-axapta@yahoogroups.com Cc: Axapta-Knowledge-Village@yahoogroups.com Betreff: [development-axapta] How to find the data type of the field 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] YAHOO! GROUPS LINKS * Visit your group development-axapta http://groups.yahoo.com/group/development-axapta on the web. * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service http://docs.yahoo.com/info/terms/ . [Non-text portions of this message have been removed] SPONSORED LINKS Computer part Programming languages Microsoft axapta Support exchange YAHOO! GROUPS LINKS Visit your group "development-axapta" 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.
AW: [development-axapta] Update field with switch-case
Hi there I have solved it a bit different, but you would be able to construct your scenario based on my code. I got a XML document with the table name or an alias for the table as XML element, as child elements I got the fields and needs to create a record in Axapta based on this. void A() { FileNamefileName = 'File Name goes hier'; XMLDocument importData; XMLNode xmlNode; XMLNode node; XMLNodeListIterator XMLNodeListIterator; Counter XMLNodeCounter; SysDictTabledictTable; Common record; boolean valueFound; fieldId field; ; // Open XML Document importData = new XMLDocument(); importData.Async(true); importData.load(filename); if (importData.readyState() == 4) { // get first Node xmlNode = importData.documentElement(); XMLNodeListIterator = new XMLNodeListIterator(xmlNode.childNodes()); ttsbegin; // get child Nodes while (XMLNodeListIterator.moreValues()) { node = XMLNodeListIterator.value(); if (TableName2Id(Node.attributes().nextNode().text()) 0) { // First Element holds the table dictTable = new SysDictTable(tableName2Id(Node.attributes().nextNode().text())); valueFound = false; record = dictTable.makeRecord(); // child elements holds the fields with values for (XMLNodeCounter = 0; XMLNodeCounter node.childNodes().length(); XMLNodeCounter++) { // Node name = FIeld Name field = dictTable.fieldName2Id(node.childNodes().item(XMLNodeCounter).attributes().nextNode().text()); if (field !isSysID(field)) { // get the node value record.(field) = node.childNodes().item(XMLNodeCounter).getNodeValue(); valueFound = true; } } if (valueFound) { record.insert(); } } XMLNodeListIterator.nextValue(); } ttscommit; } } Mit freundlichen Grüßen / Best regards / Med venlig hilsen Jesper Jørgensen / Abt. NMT-XD Entwicklung Axapta arvato systems | Technologies GmbH An der Autobahn 18 33311 Gütersloh [EMAIL PROTECTED] blocked::mailto:[EMAIL PROTECTED] http://www.as-T.biz Phone: +49 5242 / 40 80 54 Fax: +49 5242 / 40 80 40 Mobile: +49 172 / 571 03 34 Der Inhalt dieser Nachricht oder eventueller Anlagen ist vertraulich und ausschließlich für den bezeichneten Adressaten bestimmt. Bitte stellen Sie sicher, dass die Information in dieser Nachricht ausschließlich an die adressierten Personen gelangt. Sollte diese Nachricht versehentlich an Sie gesendet worden sein, dann informieren Sie bitte umgehend den Absender und löschen Sie die Nachricht. Vielen Dank. The information in this e-mail and any attachments is confidential. The information must only be held in areas that have controlled and limited access to the addressed persons. If this e-mail has been sent to you in error, please immediately notify the sender and delete the e-mail. Thanks. Von: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] Im Auftrag von surfing2alien Gesendet: Mittwoch, 3. Januar 2007 23:53 An: development-axapta@yahoogroups.com Betreff: [development-axapta] Update field with switch-case I'm looking for an example where I can find the way to achieve the following. Can somebody tell me , or point to an example in Axapta 3.0, what to fill in in the dots in method B , and how method A should look like: I receive a fieldid from a message in method A. This fieldid is validated by another method B, and there is a switch-case which tells what the fieldtype is. Depending on the type of field in method B, 1 of the fields in my Table in method A has to be updated. method A() XMLmessage XMLmessage; Table Table; ; receives a XMLmessage. In this XML message the fieldtype is extracted call method B method B() switch fieldtype { case MName : return. ; break; case MAge : return. ; break; case MAdress : return. ; break; case MCity : return. ; break; . . . default : return...; break; } (back in method A) depending on the fieldtype, one of the fields in the Table has to be inserted with the value which is extracted after the fieldtype in the message. Thanks /B [Non-text portions of this message have been removed]
AW: [development-axapta] Excel API
Hi, You could use the COM class wrapper wizard to implement all objects from a COM application in Dynamics Ax. You need to review a couple of objects after wrapping them. The wizard has problems with polymorph objects. The automatic implementation of e.g. the Range and the selection object within Dynamics Ax will allow you to perform COM calls that are not legal from an Excel point of view. If you want to fix that you need to implement the two objects for every excel object (chart, cell, etc.). Hope this helps. Mit freundlichen Grüßen / Best regards / Med venlig hilsen Jesper Jørgensen / Abt. NMT-XD Senior Product Manager arvato systems | Technologies GmbH An der Autobahn 18 33311 Gütersloh [EMAIL PROTECTED] blocked::blocked::blocked::mailto:[EMAIL PROTECTED] Phone: +49 5242 / 40 80 54 Fax: +49 5242 / 40 80 40 Mobile: +49 172 / 571 03 34 http://www.as-T.biz blocked::blocked::http://www.as-t.biz/ arvato systems | Technologies GmbH Joachim-Jungius-Str. 9, 18059 Rostock Geschäftsführung: Erwin Pietz, Matthias Moeller Amtsgericht Rostock - HRB 7497 Der Inhalt dieser Nachricht oder eventueller Anlagen ist vertraulich und ausschließlich für den bezeichneten Adressaten bestimmt. Bitte stellen Sie sicher, dass die Information in dieser Nachricht ausschließlich an die adressierten Personen gelangt. Sollte diese Nachricht versehentlich an Sie gesendet worden sein, dann informieren Sie bitte umgehend den Absender und löschen Sie die Nachricht. Vielen Dank. The information in this e-mail and any attachments is confidential. The information must only be held in areas that have controlled and limited access to the addressed persons. If this e-mail has been sent to you in error, please immediately notify the sender and delete the e-mail. Thanks. Von: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] Im Auftrag von gollywogman Gesendet: Donnerstag, 13. September 2007 16:44 An: development-axapta@yahoogroups.com Betreff: [development-axapta] Excel API Greetings everyone Does anyone know how to access an excel api or COM api for excel. The SysExcelApplication classes in Axapta don't have all of the functionality that I need. I need to build some more in. Does any one know how. I really need to insert new rows into a spreadsheet via Axapta for example, as well as many other things. Any help would be appreciated. Thanks a lot! B [Non-text portions of this message have been removed]
AW: [development-axapta] Pass temporary table data from form to report
Hi, just to make sure you does not get a stack trace at runtime you should check if the Method exists on the caller object. Object fr ; Table tt; // fr = element.caller(); If (formHasMethod(fr,identifierstr(updateControls)) // formHasMethod is implemented in Global. tt = fr.retmethod(); Mit freundlichen Grüßen / Best regards / Med venlig hilsen Jesper Jørgensen / Abt. NMT-XD Senior Product Manager arvato systems | Technologies GmbH An der Autobahn 18 33311 Gütersloh [EMAIL PROTECTED] blocked::blocked::blocked::mailto:[EMAIL PROTECTED] Phone: +49 5242 / 40 80 54 Fax: +49 5242 / 40 80 40 Mobile: +49 172 / 571 03 34 http://www.as-T.biz blocked::blocked::http://www.as-t.biz/ arvato systems | Technologies GmbH Joachim-Jungius-Str. 9, 18059 Rostock Geschäftsführung: Erwin Pietz, Matthias Moeller Amtsgericht Rostock - HRB 7497 Der Inhalt dieser Nachricht oder eventueller Anlagen ist vertraulich und ausschließlich für den bezeichneten Adressaten bestimmt. Bitte stellen Sie sicher, dass die Information in dieser Nachricht ausschließlich an die adressierten Personen gelangt. Sollte diese Nachricht versehentlich an Sie gesendet worden sein, dann informieren Sie bitte umgehend den Absender und löschen Sie die Nachricht. Vielen Dank. The information in this e-mail and any attachments is confidential. The information must only be held in areas that have controlled and limited access to the addressed persons. If this e-mail has been sent to you in error, please immediately notify the sender and delete the e-mail. Thanks. Von: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] Im Auftrag von naushad basha Gesendet: Mittwoch, 9. Januar 2008 05:53 An: development-axapta@yahoogroups.com Betreff: Re: [development-axapta] Pass temporary table data from form to report Hi, steps are as follows 1- write a method which returns the temp table, at the form level(of the calling form) say the name of the method is retmethod() 2- in the report, access the caller form object with the following code. Object fr ; Table tt; // fr = element.caller(); // this will return the formrun object of the caller form. tt = fr.retmethod(); // this line will call the method (retmethod) on the form(Dont worry about the intellisence becz the intellisense will not show the method retmethod() as the object fr is of type Object and not formrun that it will validate. so in tt you will get the whole of the temptable. this code is tested and should work :) Hope this helps buddy regards Naushad. V G [EMAIL PROTECTED] mailto:learnaxapta%40gmail.com wrote: Hi I have a form where I insert data in a temporary table. From the form a report is called on the click of a menuitembutton. Is there a way that I can retreive the data of the temporary table(which is created in the form) in the report. Thanks in advance VG [Non-text portions of this message have been removed] - Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
AW: [development-axapta] Bad response time on the CUSTINVOICEJOUR form
Hi Try using the code profiler to identify the problem. Mit freundlichen Grüßen / Best regards / Med venlig hilsen Jesper Jørgensen / Abt. NMT-XD Senior Product Manager Der Inhalt dieser Nachricht oder eventueller Anlagen ist vertraulich und ausschließlich für den bezeichneten Adressaten bestimmt. Bitte stellen Sie sicher, dass die Information in dieser Nachricht ausschließlich an die adressierten Personen gelangt. Sollte diese Nachricht versehentlich an Sie gesendet worden sein, dann informieren Sie bitte umgehend den Absender und löschen Sie die Nachricht. Vielen Dank. The information in this e-mail and any attachments is confidential. The information must only be held in areas that have controlled and limited access to the addressed persons. If this e-mail has been sent to you in error, please immediately notify the sender and delete the e-mail. Thanks. Von: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] Im Auftrag von James Flavell Gesendet: Donnerstag, 10. Januar 2008 09:06 An: development-axapta@yahoogroups.com Betreff: RE: [development-axapta] Bad response time on the CUSTINVOICEJOUR form Snap!!! Same probem here We have the same kind of number of records in the tables (FYI we have about 5 diff AX companies...do you have multi companies, not sure this has anything to do with the problem?) Also we found users who killed there AX session (thinking it was not responding) it actaully left the process in the SQL and it would not stop and took 100%!!! Look in your event viewer for things like AOS saying SPID xxx should be killed (i.e. AOS cannot kill it and you have to go into SQL yourself to do) We seemed to have fixed (just like 5 mins ago) for now but not sure, these are the steps we did for your info: 1) We added an index with invoicedate to custinvoicejour 2) Opened the form again and this time data appeared fine 3) We deleted the index and still the form is fine (this might be SQL caching of some kind I am not sure) Maybe you can first just test a compile of the form and then a full compile Still problem: Check in SQL do indexes exist on this table? (wondering if somehow the AOT indexes did not get to SQL) Do a sync from AOT for this table If these do not work then try creating an index on this table Anyone else having this problem? We thought it might be a AX system file corruption as we had some server problems a while back but it seems maybe it is more of a Standard AX problem since someone else has the problem Also I suggest you try putting the SQL statement in the SQL profiler to see what query path the SQL plans to use (maybe before you try any of the fixes) Looking forward to hearing from you Thanks James _ From: development-axapta@yahoogroups.com mailto:development-axapta%40yahoogroups.com [mailto:development-axapta@yahoogroups.com mailto:development-axapta%40yahoogroups.com ] On Behalf Of pkpeterson652 Sent: Wednesday, January 09, 2008 8:32 PM To: development-axapta@yahoogroups.com mailto:development-axapta%40yahoogroups.com Subject: [development-axapta] Bad response time on the CUSTINVOICEJOUR form I have a response time problem with the CUSTINVOICEJOUR form. Accounts receivable \ Sales Orders \ Inquiries \ Invoices This form only has some minor modifications to it and when the mods are removed the same results are given. We are running Dynamics AX 4.0 at SP1, SQL Server 2005, and one AOS. The first time this option is selected it takes anywhere from 1 1/2 to 2 1/2 minutes to come up. Once the form has been opened up this form will come up in 1 to 2 seconds. I understand this because the necessary infomation is probably in the cache for the subsequent queries. I have run SQL trace and have isolated the offending query. I have taken the SQL statement shown in the SQL Trace log into the Database Engine tuning advisor, built and updated the recommended Statistics and built the recommend indexes. There are 166,506 records in the CUSINVOICEJOUR table across all companies and 108,388 records in the CUSTINOICESALESLINK table accross all companies. Any suggestions of what I should look at next? SQL Statement is as follows: SELECT A.CUSTGROUP,A.REFNUM,A.SALESID,A.ORDERACCOUNT,A.INVOICEACCOUNT, A.INVOICEDATE,A.DUEDATE,A.CASHDISC,A.CASHDISCDATE,A.QTY,A.VOLUME, A.WEIGHT,A.SUMLINEDISC,A.SALESBALANCE,A.ENDDISC,A.INVOICEAMOUNT, A.CURRENCYCODE,A.EXCHRATE,A.SALESADMINISTRATOR,A.INVOICEID,A.LEDGERVOU CHER,A.UPDATED,A.DIMENSION,A.DIMENSION2_,A.DIMENSION3_, A.ONACCOUNTAMOUNT,A.TAXPRINTONINVOICE,A.LISTCODE,A.DEL_PRINTED, A.DOCUMENTNUM,A.DOCUMENTDATE,A.INTRASTATDISPATCH,A.DELIVERYNAME, A.DELIVERYADDRESS,A.PURCHASEORDER,A.DLVTERM,A.DLVMODE,A.PAYMENT, A.CASHDISCCODE,A.INVOICEROUNDOFF,A.SUMMARKUP,A.COVSTATUS, A.RETURNITEMNUM,A.POSTINGPROFILE,A.BACKORDER,A.PREPAYMENT,
AW: [development-axapta] Select records dinamically on form
HI, I have crated a form (Quick and Dirty) in 4.0 SP2 based on CustTable that shows U how to do that. Mit freundlichen Grüßen / Best regards / Med venlig hilsen Jesper Jørgensen / Abt. NMT-XD Senior Product Manager arvato systems | Technologies GmbH An der Autobahn 18 33311 Gütersloh [EMAIL PROTECTED] blocked::blocked::blocked::mailto:[EMAIL PROTECTED] Phone: +49 5242 / 40 80 54 Fax: +49 5242 / 40 80 40 Mobile: +49 172 / 571 03 34 http://www.as-T.biz blocked::blocked::http://www.as-t.biz/ arvato systems | Technologies GmbH Joachim-Jungius-Str. 9, 18059 Rostock Geschäftsführung: Erwin Pietz, Matthias Moeller Amtsgericht Rostock - HRB 7497 Der Inhalt dieser Nachricht oder eventueller Anlagen ist vertraulich und ausschließlich für den bezeichneten Adressaten bestimmt. Bitte stellen Sie sicher, dass die Information in dieser Nachricht ausschließlich an die adressierten Personen gelangt. Sollte diese Nachricht versehentlich an Sie gesendet worden sein, dann informieren Sie bitte umgehend den Absender und löschen Sie die Nachricht. Vielen Dank. The information in this e-mail and any attachments is confidential. The information must only be held in areas that have controlled and limited access to the addressed persons. If this e-mail has been sent to you in error, please immediately notify the sender and delete the e-mail. Thanks. Von: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] Im Auftrag von daniele.selvi Gesendet: Donnerstag, 17. Januar 2008 10:02 An: development-axapta@yahoogroups.com Betreff: [development-axapta] Select records dinamically on form Hi all, When I open my form, the first record is selected. what can I do, after clicking a button, to focus the next record on the form ? Thanks in advance.. Byez. Daniele. [Non-text portions of this message have been removed]
AW: [development-axapta] Who locks the table?
In the online User Form U see the SPID for an Ax user. Mit freundlichen Grüßen / Best regards / Med venlig hilsen Jesper Jørgensen / Abt. NMT-XD Senior Product Manager arvato systems | Technologies GmbH An der Autobahn 18 33311 Gütersloh [EMAIL PROTECTED] blocked::blocked::blocked::mailto:[EMAIL PROTECTED] Phone: +49 5242 / 40 80 54 Fax: +49 5242 / 40 80 40 Mobile: +49 172 / 571 03 34 http://www.as-T.biz blocked::blocked::http://www.as-t.biz/ arvato systems | Technologies GmbH Joachim-Jungius-Str. 9, 18059 Rostock Geschäftsführung: Erwin Pietz, Matthias Moeller Amtsgericht Rostock - HRB 7497 Der Inhalt dieser Nachricht oder eventueller Anlagen ist vertraulich und ausschließlich für den bezeichneten Adressaten bestimmt. Bitte stellen Sie sicher, dass die Information in dieser Nachricht ausschließlich an die adressierten Personen gelangt. Sollte diese Nachricht versehentlich an Sie gesendet worden sein, dann informieren Sie bitte umgehend den Absender und löschen Sie die Nachricht. Vielen Dank. The information in this e-mail and any attachments is confidential. The information must only be held in areas that have controlled and limited access to the addressed persons. If this e-mail has been sent to you in error, please immediately notify the sender and delete the e-mail. Thanks. Von: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] Im Auftrag von jquinteroz Gesendet: Mittwoch, 23. Januar 2008 02:56 An: development-axapta@yahoogroups.com Betreff: [development-axapta] Who locks the table? Hi: We recently had had some issues with record blocking (lock). We can see the SPID of locked tables...but how we can know which user is doing that (locking the table). Regards. [Non-text portions of this message have been removed]
AW: [development-axapta] Using Two localizations in One Application
Hallo Trinadh, this can not work. You will have two applications with differences in the data model. You need a database for each application. The US version is part of the sys layer in 4.0. Mit freundlichen Grüßen / Best regards / Med venlig hilsen Jesper Jørgensen / Abt. NMT-XD Senior Product Manager arvato systems | Technologies GmbH Von: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] Im Auftrag von trinadh sura Gesendet: Donnerstag, 24. Januar 2008 12:46 An: [EMAIL PROTECTED]; Axapta Betreff: [development-axapta] Using Two localizations in One Application Dear all, 1.We need to work on two companies ,one company should have Indian localization files , data and another company should have US localization files and data.Can we put two localization fiels into one application Or we need to configuare Two Servers on One database,one for Indian and another for US. 2.Where we can get Us localization files. Regards, Trinadh Sura. __ Post free property ads on Yello Classifieds now! www.yello.in http://ss1.richmedia.in/recurl.asp?pid=220 http://ss1.richmedia.in/recurl.asp?pid=220 [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
AW: [development-axapta] Enum values in SQL database
Hi, I have made a solution for the problem. You need to extract the labels from the enums in the AOT. Goes something like this: public void run() { EDAViewWizardEnum viewWizardEnumTable; EDAViewWizardLanguage viewWizardLanguageTable; Dictionary dictionary; DictEnumdictEnum; EnumId enumId; xInfo xInfo; int i, idx; RunBaseProgress progress; LanguageId currentLanguageId; ; Dictionary = new Dictionary(); xInfo = new xInfo(); select count(RecId) from viewWizardLanguageTable; progress = new RunBaseProgress(2); progress.setCaption(@EDA23); progress.setAnimation(#AviUpdate); progress.setTotal(viewWizardLanguageTable.RecId, #second); progress.setTotal(dictionary.enumCnt(), #first); progress.setText(@SYS4195, #first); delete_from viewWizardEnumTable; startLengthyOperation(); while select viewWizardLanguageTable { Progress.setText(viewWizardLanguageTable.LanguageId, #second); currentLanguageId = xInfo.language(); xInfo.language(viewWizardLanguageTable.LanguageId); for (i = 1; i = dictionary.enumCnt(); i++) { enumId = dictionary.enumCnt2Id(i); dictEnum = new DictEnum(enumId); if(dictEnum) { Progress.setText(dictEnum.name(), #first); idx = 0; for (idx = 0; idx dictEnum.values(); idx++) { viewWizardEnumTable.LanguageId = viewWizardLanguageTable.LanguageId; viewWizardEnumTable.BaseEnumId = enumId; viewWizardEnumTable.BaseEnumName = dictEnum.name(); viewWizardEnumTable.BaseEnumLabel = dictEnum.label(); viewWizardEnumTable.BaseEnumValueName = dictEnum.index2Symbol(idx); viewWizardEnumTable.BaseEnumValueLabel = dictEnum.index2Label(idx); viewWizardEnumTable.BaseEnumValue = dictEnum.index2Value(idx); viewWizardEnumTable.insert(); } } Progress.incCount(1, #first); } Progress.incCount(1, #second); } xInfo.language(currentLanguageId); EndLengthyOperation(); } Then you need to make a table also from within Ax storing the fields that uses Enums and the Enum Id it uses. (As I create a view from within AX I did not need this table). You need to loop over the data dictionary (SysDictionary, sysDictTable, SysDictField). Here you will find the Property Enum and SQLName, remember the tableName (DBBackend). Now You can Join the Enumvalue with this table: Select custAccount, Name from CustTable LEFT OUTER JOIN BaseEnumValueLabel from viewWizardEnumTable Where languageId = 'en-us' And BASEENUMID = 53 (CustVendBlocked) ID of the enum the field uses And BASEENUMVALUE = CustTable.Blocked Mit freundlichen Grüßen / Best regards / Med venlig hilsen Jesper Jørgensen / Abt. NMT-XD Senior Product Manager arvato systems | Technologies GmbH An der Autobahn 18 33311 Gütersloh [EMAIL PROTECTED] Phone: +49 5242 / 40 80 54 Fax: +49 5242 / 40 80 40 Mobile: +49 172 / 571 03 34 http://www.as-T.biz arvato systems | Technologies GmbH Joachim-Jungius-Str. 9, 18059 Rostock Geschäftsführung: Erwin Pietz, Matthias Moeller Amtsgericht Rostock - HRB 7497 Der Inhalt dieser Nachricht oder eventueller Anlagen ist vertraulich und ausschließlich für den bezeichneten Adressaten bestimmt. Bitte stellen Sie sicher, dass die Information in dieser Nachricht ausschließlich an die adressierten Personen gelangt. Sollte diese Nachricht versehentlich an Sie gesendet worden sein, dann informieren Sie bitte umgehend den Absender und löschen Sie die Nachricht. Vielen Dank. The information in this e-mail and any attachments is confidential. The information must only be held in areas that have controlled and limited access to the addressed persons. If this e-mail has been sent to you in error, please immediately notify the sender and delete the e-mail. Thanks. -Ursprüngliche Nachricht- Von: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] Im Auftrag von Ozanhan Anaç Gesendet: Mittwoch, 12. März 2008 15:47 An: development-axapta@yahoogroups.com Betreff: RE: [development-axapta] Enum values in SQL database Hi Anýl, As enum types stored in the application (not in SQL), there shouldn't be a flexible way to show that values. Instead, you can use HARDCODED switch cases in your views. For example : Create view vw_blabla As
AW: [development-axapta] User Groups
Hi Ricardo, The User Groups are stored in UserGroupInfo. The User Groups for a specific user are stored in UserGroupList. Be aware that the access rights in AX can be setup depending on the domain of the company account. Mit freundlichen Grüßen / Best regards / Med venlig hilsen Jesper Jørgensen / Abt. NMT-XD Senior Product Manager arvato systems | Technologies GmbH An der Autobahn 18 33311 Gütersloh [EMAIL PROTECTED] blocked::blocked::blocked::mailto:[EMAIL PROTECTED] Phone: +49 5242 / 40 80 54 Fax: +49 5242 / 40 80 40 Mobile: +49 172 / 571 03 34 http://www.as-T.biz blocked::blocked::http://www.as-t.biz/ arvato systems | Technologies GmbH Joachim-Jungius-Str. 9, 18059 Rostock Geschäftsführung: Erwin Pietz, Matthias Moeller Amtsgericht Rostock - HRB 7497 Der Inhalt dieser Nachricht oder eventueller Anlagen ist vertraulich und ausschließlich für den bezeichneten Adressaten bestimmt. Bitte stellen Sie sicher, dass die Information in dieser Nachricht ausschließlich an die adressierten Personen gelangt. Sollte diese Nachricht versehentlich an Sie gesendet worden sein, dann informieren Sie bitte umgehend den Absender und löschen Sie die Nachricht. Vielen Dank. The information in this e-mail and any attachments is confidential. The information must only be held in areas that have controlled and limited access to the addressed persons. If this e-mail has been sent to you in error, please immediately notify the sender and delete the e-mail. Thanks. Von: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] Im Auftrag von ricardodegouveia Gesendet: Donnerstag, 17. April 2008 16:11 An: development-axapta@yahoogroups.com Betreff: [development-axapta] User Groups Hi all, How do i find out which user groups the current user? And how do i loop through the user groups to see if the user is a part of a specific group? Which tables does it use? Thanking you in advance Ricardo [Non-text portions of this message have been removed]
AW: [development-axapta] How do I know which field is sorted at, and the sortorder in a grid?
Hi Tore, You need to add the menuitem to the form CustTable. Exportfile for AOT version 1.0 or later Formatversion: 1 ***Element: FTM ; Microsoft Dynamics MENUITEM : CustSort unloaded ; VERSION 1 MENUITEM #CustSort Type: 2 PROPERTIES Name#CustSort ObjectType #Report Object #CustSort ENDPROPERTIES ENDMENUITEM ***Element: RG ; Microsoft Dynamics Report: CustSort nicht geladen ; VERSION 1 REPORT #CustSort PROPERTIES Name#CustSort ENDPROPERTIES METHODS Version: 3 SOURCE #fetch #public boolean fetch() #{ #boolean ret; #custTable ct; #; #ct = fds.getFirst(1); #while (ct) #{ #this.send(ct); #ct = fds.getNext(); #ret = true; #} # #return ret; #} ENDSOURCE SOURCE #init #public void init() #{ #FormRun fr; # #super(); #fr = element.args().caller(); #fds = fr.dataSource(); #} ENDSOURCE SOURCE #classDeclaration #public class ReportRun extends ObjectRun #{ #FormDataSource fds; #} ENDSOURCE ENDMETHODS QUERY #Query PROPERTIES Name#Query Version #3 NextUniqueId#1001 ENDPROPERTIES METHODS Version: 3 SOURCE #classDeclaration #public class QueryRun extends ObjectRun #{ #} ENDSOURCE ENDMETHODS BLOCKS BLOCK #CustTable PROPERTIES Name#CustTable Table #CustTable UniqueId#1000 ENDPROPERTIES FIELDLIST PROPERTIES ENDPROPERTIES ENDFIELDLIST SORTING ENDSORTING LINES ENDLINES BLOCKS ENDBLOCKS ENDBLOCK ENDBLOCKS ENDQUERY DESIGNS DESIGN PROPERTIES Name#ReportDesign1 ReportTemplate #InternalList ENDPROPERTIES AUTOBODIES PROPERTIES ENDPROPERTIES AUTOBODY #CustTable PROPERTIES Name#CustTable_1 ENDPROPERTIES STRFIELD PROPERTIES Name#CustTable_AccountNum Table #CustTable DataField #AccountNum ENDPROPERTIES ENDSTRFIELD STRFIELD PROPERTIES Name#CustTable_Name Table #CustTable DataField #Name ENDPROPERTIES ENDSTRFIELD STRFIELD PROPERTIES Name#CustTable_NameAlias Table #CustTable DataField #NameAlias ENDPROPERTIES ENDSTRFIELD STRFIELD PROPERTIES Name#CustTable_Phone Table #CustTable DataField #Phone ENDPROPERTIES ENDSTRFIELD ENDAUTOBODY ENDAUTOBODIES ENDDESIGN ENDDESIGNS ENDREPORT ***Element: PRN ; Microsoft Dynamics Project : SortFromForm unloaded ; PROJECTVERSION 2 PROJECT #SortFromForm SHARED PROPERTIES Name#SortFromForm ENDPROPERTIES GROUP #Object1 PROPERTIES Name#Object1 ProjectGroupType#All GroupMask # PreventEditProperties #No ENDPROPERTIES BEGINNODE FILETYPE 0 UTILTYPE 2 UTILOBJECTID 0 NODETYPE 296 NAME #CustSort ENDNODE ENDGROUP BEGINNODE FILETYPE 0 UTILTYPE 18 UTILOBJECTID 0 NODETYPE 202 NAME #CustSort ENDNODE ENDPROJECT ***Element: END ,, Mit freundlichen Grüßen / Best regards / Med venlig hilsen Jesper Jørgensen / Abt. NMT-XD Senior Product Manager arvato systems | Technologies GmbH An der Autobahn 18 33311 Gütersloh [EMAIL PROTECTED] blocked::blocked::blocked::mailto:[EMAIL PROTECTED] Phone: +49 5242 / 40 80 54 Fax: +49 5242 / 40 80 40 Mobile: +49 172 / 571 03 34 http://www.as-T.biz
AW: [development-axapta] Axapta Backup Data
HI, SQL Backup. The export from Ax only exports one company account. If you mess up the recid's you are not able to restore the export. If you need a company based restore you restore your database with a new db name. In the company accounts you can restore one company from an external database. Mit freundlichen Grüßen / Best regards / Med venlig hilsen Jesper Jørgensen / Abt. NMT-XD Senior Product Manager arvato systems | Technologies GmbH An der Autobahn 18 33311 Gütersloh [EMAIL PROTECTED] blocked::blocked::blocked::mailto:[EMAIL PROTECTED] Phone: +49 5242 / 40 80 54 Fax: +49 5242 / 40 80 40 Mobile: +49 172 / 571 03 34 http://www.as-T.biz blocked::blocked::http://www.as-t.biz/ arvato systems | Technologies GmbH Joachim-Jungius-Str. 9, 18059 Rostock Geschäftsführung: Erwin Pietz, Matthias Moeller Amtsgericht Rostock - HRB 7497 Der Inhalt dieser Nachricht oder eventueller Anlagen ist vertraulich und ausschließlich für den bezeichneten Adressaten bestimmt. Bitte stellen Sie sicher, dass die Information in dieser Nachricht ausschließlich an die adressierten Personen gelangt. Sollte diese Nachricht versehentlich an Sie gesendet worden sein, dann informieren Sie bitte umgehend den Absender und löschen Sie die Nachricht. Vielen Dank. The information in this e-mail and any attachments is confidential. The information must only be held in areas that have controlled and limited access to the addressed persons. If this e-mail has been sent to you in error, please immediately notify the sender and delete the e-mail. Thanks. Von: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] Im Auftrag von febinpc Gesendet: Freitag, 16. Mai 2008 15:06 An: development-axapta@yahoogroups.com Betreff: [development-axapta] Axapta Backup Data Hi friends Which Backup is most useful in the case of Axapta application 1, Data Backup from Axapta AdministrationData Export import 2, Data Backup from SQL server. [Non-text portions of this message have been removed]
AW: [development-axapta] CryptoAPI in 4.0 not available
HI Morten, Use cryptoblob2binary and cryptoblob2str from Global. If you want to protect your data using the WinApi_Server Class (cryptUnProtectData and cryptProtectData), be aware that the crypt / decrypt from Windows use a checksum from the machine doing the crypt, you need this machine to decrypt the data(In addition, the encryption and decryption usually must be done on the same computer.) http://msdn.microsoft.com/en-us/library/aa380261(VS.85).aspx Mit freundlichen Grüßen / Best regards / Med venlig hilsen Jesper Jørgensen / Abt. NMT-XD Senior Product Manager arvato systems | Technologies GmbH An der Autobahn 18 33311 Gütersloh [EMAIL PROTECTED] blocked::blocked::blocked::mailto:[EMAIL PROTECTED] Phone: +49 5242 / 40 80 54 Fax: +49 5242 / 40 80 40 Mobile: +49 172 / 571 03 34 http://www.as-T.biz blocked::blocked::http://www.as-t.biz/ arvato systems | Technologies GmbH Joachim-Jungius-Str. 9, 18059 Rostock Geschäftsführung: Erwin Pietz, Matthias Moeller Amtsgericht Rostock - HRB 7497 Der Inhalt dieser Nachricht oder eventueller Anlagen ist vertraulich und ausschließlich für den bezeichneten Adressaten bestimmt. Bitte stellen Sie sicher, dass die Information in dieser Nachricht ausschließlich an die adressierten Personen gelangt. Sollte diese Nachricht versehentlich an Sie gesendet worden sein, dann informieren Sie bitte umgehend den Absender und löschen Sie die Nachricht. Vielen Dank. The information in this e-mail and any attachments is confidential. The information must only be held in areas that have controlled and limited access to the addressed persons. If this e-mail has been sent to you in error, please immediately notify the sender and delete the e-mail. Thanks. Von: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] Im Auftrag von Morten Aasheim Gesendet: Montag, 2. Juni 2008 10:59 An: development-axapta@yahoogroups.com Betreff: [development-axapta] CryptoAPI in 4.0 not available Hi everyone. In Ax 3.0, I used Textbuffer to encrypt and decrypt. However in Ax 4.0, this feature is removed, and as far as I can understand, replaced by CryptoAPI. CryptoAPI is used by class\WebSession. The problem is can't use it myself. Testjob: CryptoAPI crypto; str s; container data; ContainerClass blob; ; s = 'This text will be encrypted'; blob = new ContainerClass([s]); crypto = new CryptoAPI(1234567890); data = crypto.encrypt(blob.toBlob()); info('Decrypted: '+ any2str([crypto.decrypt(data)])); Unfortunately this doesn't work. I get the error CryptoAPI not available. Please help! I really need some encryption ASAP J Best regards, Morten Aasheim Peritus [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
AW: [development-axapta] How to select distinct records from a column
No, select distinct is not implemented in Ax. You can achieve the same with: Select Field1, Field2 from Table Group by Field1, Field2 Mit freundlichen Grüßen / Best regards / Med venlig hilsen Jesper Jørgensen / Abt. NMT-XD Senior Product Manager Von: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] Im Auftrag von syed baber Gesendet: Montag, 2. Juni 2008 18:05 An: development-axapta@yahoogroups.com Betreff: [development-axapta] How to select distinct records from a column Hi All, I want to select distinct records from a column. Plz let me know is there any keyword available in Axapta for selecting distinct records like there in Oracle. Regards Syed Baber. [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
AW: [development-axapta] Newbie Question - Range Syntax
Hi Letron, first of all, use SysQuery::findOrCreateRange to get your range. Use Global:QueryRangeConcat to create your reange value. The syntax is xx1, xx2, xx3. Mit freundlichen Grüßen / Best regards / Med venlig hilsen Jesper Jørgensen / Abt. NMT-XD Senior Product Manager arvato systems | Technologies GmbH An der Autobahn 18 33311 Gütersloh [EMAIL PROTECTED] blocked::blocked::blocked::mailto:[EMAIL PROTECTED] Phone: +49 5242 / 40 80 54 Fax: +49 5242 / 40 80 40 Mobile: +49 172 / 571 03 34 http://www.as-T.biz blocked::blocked::http://www.as-t.biz/ arvato systems | Technologies GmbH Joachim-Jungius-Str. 9, 18059 Rostock Geschäftsführung: Erwin Pietz, Matthias Moeller Amtsgericht Rostock - HRB 7497 Der Inhalt dieser Nachricht oder eventueller Anlagen ist vertraulich und ausschließlich für den bezeichneten Adressaten bestimmt. Bitte stellen Sie sicher, dass die Information in dieser Nachricht ausschließlich an die adressierten Personen gelangt. Sollte diese Nachricht versehentlich an Sie gesendet worden sein, dann informieren Sie bitte umgehend den Absender und löschen Sie die Nachricht. Vielen Dank. The information in this e-mail and any attachments is confidential. The information must only be held in areas that have controlled and limited access to the addressed persons. If this e-mail has been sent to you in error, please immediately notify the sender and delete the e-mail. Thanks. Von: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] Im Auftrag von letron_brantley Gesendet: Freitag, 6. Juni 2008 15:50 An: development-axapta@yahoogroups.com Betreff: [development-axapta] Newbie Question - Range Syntax Hello everyone, My company is going through an implementation of Dynamics AX 4 and I have been tasked with writing some reports. It's coming along pretty well, but I am running into little things that are blocking me. One question that I have has to do with Ranges in the AOT. When I create a new range based on a date field, what syntax do I use in the properties pane when I want to say ExpDate Today + 192? Also how do I create a range that says = xx1 or xx2 or xx3? In SQL I can do ProdType in ('XX1', 'XX2', 'XX3'). Thanks Letron [Non-text portions of this message have been removed]
AW: [development-axapta] Problem with try catch
Try this catch(Exception::Error) { Info(Failed); } Mit freundlichen Grüßen / Best regards / Med venlig hilsen Jesper Jørgensen / Abt. NMT-XD Senior Product Manager arvato systems | Technologies GmbH An der Autobahn 18 33311 Gütersloh [EMAIL PROTECTED] blocked::blocked::blocked::mailto:[EMAIL PROTECTED] Phone: +49 5242 / 40 80 54 Fax: +49 5242 / 40 80 40 Mobile: +49 172 / 571 03 34 http://www.as-T.biz blocked::blocked::http://www.as-t.biz/ arvato systems | Technologies GmbH Joachim-Jungius-Str. 9, 18059 Rostock Geschäftsführung: Erwin Pietz, Matthias Moeller Amtsgericht Rostock - HRB 7497 Der Inhalt dieser Nachricht oder eventueller Anlagen ist vertraulich und ausschließlich für den bezeichneten Adressaten bestimmt. Bitte stellen Sie sicher, dass die Information in dieser Nachricht ausschließlich an die adressierten Personen gelangt. Sollte diese Nachricht versehentlich an Sie gesendet worden sein, dann informieren Sie bitte umgehend den Absender und löschen Sie die Nachricht. Vielen Dank. The information in this e-mail and any attachments is confidential. The information must only be held in areas that have controlled and limited access to the addressed persons. If this e-mail has been sent to you in error, please immediately notify the sender and delete the e-mail. Thanks. Von: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] Im Auftrag von jazib.abdulah Gesendet: Mittwoch, 11. Juni 2008 10:39 An: development-axapta@yahoogroups.com Betreff: [development-axapta] Problem with try catch Hi everybody I am using the following code in my program. try { ret = runBuf(myJob); Info(Ok); } catch { Info(Failed); } The problem is when runBuf fails to compile. It's Error message still shows while the purpose of putting this inside try catch was, I wanted to display my own message. What could be wrong here Thanks everybody in advance. [Non-text portions of this message have been removed]
AW: [development-axapta] Problem with simple report.
Hi Try using the AX Standard way of getting an query for inventory on hand. You will find that on the table InventDim. Query query; QueryRunqueryRun; inventDimParm inventDimParmCriteria; inventDimParm inventDimParmGroupby; InventDim inventDim; InventSum inventSum; ; inventDimParmCriteria.ClosedFlag= NoYes::Yes; inventDimParmCriteria.InventBatchIdFlag = NoYes::Yes; inventDimParmGroupby.ItemIdFlag = NoYes::Yes; inventDimParmGroupby.InventBatchIdFlag = NoYes::Yes; query = InventSum::newQuery(query,'',null,inventDimParmCriteria,inventDimParmGroupby); queryRun = new QueryRun(query); while (queryRun.next()) { inventSum = queryRun.get(tableNum(InventSum)); inventDim = queryRun.get(tableNum(InventDim)); } Mit freundlichen Grüßen / Best regards / Med venlig hilsen Jesper Jørgensen / Abt. NMT-XD Senior Product Manager arvato systems | Technologies GmbH An der Autobahn 18 33311 Gütersloh [EMAIL PROTECTED] blocked::blocked::blocked::mailto:[EMAIL PROTECTED] Phone: +49 5242 / 40 80 54 Fax: +49 5242 / 40 80 40 Mobile: +49 172 / 571 03 34 http://www.as-T.biz blocked::blocked::http://www.as-t.biz/ arvato systems | Technologies GmbH Joachim-Jungius-Str. 9, 18059 Rostock Geschäftsführung: Erwin Pietz, Matthias Moeller Amtsgericht Rostock - HRB 7497 Der Inhalt dieser Nachricht oder eventueller Anlagen ist vertraulich und ausschließlich für den bezeichneten Adressaten bestimmt. Bitte stellen Sie sicher, dass die Information in dieser Nachricht ausschließlich an die adressierten Personen gelangt. Sollte diese Nachricht versehentlich an Sie gesendet worden sein, dann informieren Sie bitte umgehend den Absender und löschen Sie die Nachricht. Vielen Dank. The information in this e-mail and any attachments is confidential. The information must only be held in areas that have controlled and limited access to the addressed persons. If this e-mail has been sent to you in error, please immediately notify the sender and delete the e-mail. Thanks. Von: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] Im Auftrag von letron_brantley Gesendet: Montag, 16. Juni 2008 15:49 An: development-axapta@yahoogroups.com Betreff: [development-axapta] Problem with simple report. I'm trying to create a simple report that shows: Item, Description, Batch, and Qty OnHand. In the query element of my report I have the following datasources: InventSum (ordermode==orderby) | |--InventDim (ordermode==groupby)(fetchmode==1:1) (joinmode==innerjoin) | (relation: inventdim.inventdimid==inventsum.inventdimid) | |--InventBatch (ordermode==groupby)(fetchmode==1:1) (joinmode==innerjoin) | (relation: inventbatch.inventbatchid==inventdim.inventbatchid) | |--InventTable (ordermode==groupby) (fetchmode==1:1)(joinmode==innerjoin) (relation: inventtable.itemid==inventbatch.itemid) My result should look something similar to this: __ | | | Item | Description | Lot | On Hand | __ | | 100 | BMX Bike - Girl's Edit. | BMX003 | 56 | | BMX004 | 73 | __ | Total | 129 | | | __ | 102 | Skate Board | SKT002 | 104 | __ | 167 | Basket Ball | BBL002 | 200 | __ etc... Can anyone offer some insight at to settings to make this happen. I am able to get the data but I'm having a problem with grouping. Thanks, Ltrain [Non-text portions of this message have been removed]
AW: [development-axapta] Importing data into Invent table.
HI, is your InventDim there? (InventItemLocation.InventDimId = InventDim::findOrCreate(inventDim)? Mit freundlichen Grüßen / Best regards / Med venlig hilsen Jesper Jørgensen / Abt. NMT-XD Senior Product Manager arvato systems | Technologies GmbH An der Autobahn 18 33311 Gütersloh [EMAIL PROTECTED] blocked::blocked::blocked::mailto:[EMAIL PROTECTED] Phone: +49 5242 / 40 80 54 Fax: +49 5242 / 40 80 40 Mobile: +49 172 / 571 03 34 http://www.as-T.biz blocked::blocked::http://www.as-t.biz/ arvato systems | Technologies GmbH Joachim-Jungius-Str. 9, 18059 Rostock Geschäftsführung: Erwin Pietz, Matthias Moeller Amtsgericht Rostock - HRB 7497 Der Inhalt dieser Nachricht oder eventueller Anlagen ist vertraulich und ausschließlich für den bezeichneten Adressaten bestimmt. Bitte stellen Sie sicher, dass die Information in dieser Nachricht ausschließlich an die adressierten Personen gelangt. Sollte diese Nachricht versehentlich an Sie gesendet worden sein, dann informieren Sie bitte umgehend den Absender und löschen Sie die Nachricht. Vielen Dank. The information in this e-mail and any attachments is confidential. The information must only be held in areas that have controlled and limited access to the addressed persons. If this e-mail has been sent to you in error, please immediately notify the sender and delete the e-mail. Thanks. Von: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] Im Auftrag von Trinadh C Gesendet: Dienstag, 1. Juli 2008 06:18 An: [EMAIL PROTECTED] Cc: development-axapta@yahoogroups.com Betreff: [development-axapta] Importing data into Invent table. Dear Ali, We populated the tables (InventTableModule and InventItemLocation) and tried to import the data in Ax4.0 Sp2. But still the data could be seen only in the table level. Could you please suggest the process of importing the data. Reply to this mail asap is highly appreciated. -- Regard's.., Trinadh. -- THIS E-MAIL IS CONFIDENTIAL and intended solely for the use of the individual to whom it is addressed. [Non-text portions of this message have been removed]
AW: [development-axapta] Printing BarCode Vertically in Report. Urgent!!!
HI, Have fun. You can not print Vertical and horizontal on the same report within Ax. I solved the problem by writing on a plain text printer, sending the native printer codes to a barcode printer. Not a nice solution, but it worked. The best solution is to look for a barcode printing software or a output management system. Mit freundlichen Grüßen / Best regards / Med venlig hilsen Jesper Jørgensen / Abt. NMT-XD Senior Product Manager arvato systems | Technologies GmbH An der Autobahn 18 33311 Gütersloh [EMAIL PROTECTED] blocked::blocked::blocked::mailto:[EMAIL PROTECTED] Phone: +49 5242 / 40 80 54 Fax: +49 5242 / 40 80 40 Mobile: +49 172 / 571 03 34 http://www.as-T.biz blocked::blocked::http://www.as-t.biz/ arvato systems | Technologies GmbH Joachim-Jungius-Str. 9, 18059 Rostock Geschäftsführung: Erwin Pietz, Matthias Moeller Amtsgericht Rostock - HRB 7497 Der Inhalt dieser Nachricht oder eventueller Anlagen ist vertraulich und ausschließlich für den bezeichneten Adressaten bestimmt. Bitte stellen Sie sicher, dass die Information in dieser Nachricht ausschließlich an die adressierten Personen gelangt. Sollte diese Nachricht versehentlich an Sie gesendet worden sein, dann informieren Sie bitte umgehend den Absender und löschen Sie die Nachricht. Vielen Dank. The information in this e-mail and any attachments is confidential. The information must only be held in areas that have controlled and limited access to the addressed persons. If this e-mail has been sent to you in error, please immediately notify the sender and delete the e-mail. Thanks. Von: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] Im Auftrag von tkbsmanian Gesendet: Dienstag, 1. Juli 2008 09:56 An: development-axapta@yahoogroups.com Betreff: [development-axapta] Printing BarCode Vertically in Report. Urgent!!! Hi, i've an requirement to ptint the bar code vertically (rotating to 90 degree against default) in reports. Since barcode is a string and there is no rotating properties available, the idea is capture the barcode as image and rotate that into 90 degrees in report. But, struck with capturing the image of the barcode. are any methods there in Axapta to capture the particular field as image? Any other ideas to print barcode vertically should also be appreciated. Thanks in Advance. [Non-text portions of this message have been removed]
AW: [development-axapta] List of tables which are Savedataprcompany == false
HI You are close to the result. You can't assume, that the counter has the same value as the table id... Try this. I have excluded the maps, views, tmptables, and the system tables as well. static void findGlobalTables(Args _args) { Dictionary Dictionary; sysDictTabledictTable; Counter tableCounter; ; Dictionary = new Dictionary(); for (tableCounter = 1; tableCounter = Dictionary.tableCnt(); tableCounter++) { dictTable = new SysDictTable(Dictionary.tableCnt2Id(tableCounter)); if (dictTable.dataPrCompany() == false !dictTable.isView() !dictTable.isMap() !dictTable.isSystemTable() !dictTable.isTmp()) info(dictTable.name()); } } Mit freundlichen Grüßen / Best regards / Med venlig hilsen Jesper Jørgensen / Abt. NMT-XD Senior Product Manager arvato systems | Technologies GmbH An der Autobahn 18 33311 Gütersloh [EMAIL PROTECTED] blocked::blocked::blocked::mailto:[EMAIL PROTECTED] Phone: +49 5242 / 40 80 54 Fax: +49 5242 / 40 80 40 Mobile: +49 172 / 571 03 34 http://www.as-T.biz blocked::blocked::http://www.as-t.biz/ arvato systems | Technologies GmbH Joachim-Jungius-Str. 9, 18059 Rostock Geschäftsführung: Erwin Pietz, Matthias Moeller Amtsgericht Rostock - HRB 7497 Der Inhalt dieser Nachricht oder eventueller Anlagen ist vertraulich und ausschließlich für den bezeichneten Adressaten bestimmt. Bitte stellen Sie sicher, dass die Information in dieser Nachricht ausschließlich an die adressierten Personen gelangt. Sollte diese Nachricht versehentlich an Sie gesendet worden sein, dann informieren Sie bitte umgehend den Absender und löschen Sie die Nachricht. Vielen Dank. The information in this e-mail and any attachments is confidential. The information must only be held in areas that have controlled and limited access to the addressed persons. If this e-mail has been sent to you in error, please immediately notify the sender and delete the e-mail. Thanks. Von: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] Im Auftrag von steffendenize Gesendet: Freitag, 29. August 2008 15:09 An: development-axapta@yahoogroups.com Betreff: [development-axapta] List of tables which are Savedataprcompany == false Hi all I need a list of all table which have the property - savedataprcompany to no. What is the easiest way of doing this? I've tried the noob-way: DictTable dictTable; int i; ; for(i = 1; i 500; i++) { dictTable = new Dicttable(i); if(dictTable.dataPrCompany() == noyes::No) { // print tableid2name(i); info(strfmt(%1,tableid2name(i)); } } pause; which fails (the 500 is just for testing). How do I get the result I need. Regards, Steffen [Non-text portions of this message have been removed]
AW: [development-axapta] HOW TO SENT FILE SFTP?
HI, you need an .net SFTP component you can add within Dynamics Ax. (Or an API as OCX / DLL / Com+ prior to 4.0). There are several providers for SFTP components. One of them is Eldos SecureBlackBox. http://www.eldos.com/sbb/sftp-net.php?referer1=googlereferer2=adwords_kw_net_sftp_apigclid=CL6ckODxupYCFQpUtAod9UIUMA You need to wrap the components up with an external development tool (Microsoft Visual Studio or Borland Delphi). If you do not need an audit within Ax you could consider using an external executable (Bitwise http://www.bitvise.com/tunnelier?gclid=CI_AitLyupYCFQxOtAodFD1-Kw) to fetch the file, but be aware that during ftp.get () the file is not locked by the operating system, in that case you would read the file only partial. Mit freundlichen Grüßen / Best regards / Med venlig hilsen Jesper Jørgensen / Abt. NMT-XD Senior Product Manager arvato systems | Technologies GmbH An der Autobahn 18 33311 Gütersloh [EMAIL PROTECTED] blocked::blocked::blocked::mailto:[EMAIL PROTECTED] Phone: +49 5242 / 40 80 54 Fax: +49 5242 / 40 80 40 Mobile: +49 172 / 571 03 34 http://www.as-T.biz blocked::blocked::http://www.as-t.biz/ arvato systems | Technologies GmbH Joachim-Jungius-Str. 9, 18059 Rostock Geschäftsführung: Erwin Pietz, Matthias Moeller Amtsgericht Rostock - HRB 7497 Der Inhalt dieser Nachricht oder eventueller Anlagen ist vertraulich und ausschließlich für den bezeichneten Adressaten bestimmt. Bitte stellen Sie sicher, dass die Information in dieser Nachricht ausschließlich an die adressierten Personen gelangt. Sollte diese Nachricht versehentlich an Sie gesendet worden sein, dann informieren Sie bitte umgehend den Absender und löschen Sie die Nachricht. Vielen Dank. The information in this e-mail and any attachments is confidential. The information must only be held in areas that have controlled and limited access to the addressed persons. If this e-mail has been sent to you in error, please immediately notify the sender and delete the e-mail. Thanks. Von: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] Im Auftrag von volkan turgut Gesendet: Mittwoch, 22. Oktober 2008 13:51 An: development-axapta@yahoogroups.com Betreff: [development-axapta] HOW TO SENT FILE SFTP? Hi.. I want to sent a file(txt) from ax4.0 to SFTP server.if I should add referance to axapta which referance I should add?. However I need get file fromSFTP to Axapta.any idea? thanks. Volkan [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
AW: [development-axapta] Borders in Excel with x++
Hi, Using the excel COM object you can select an range. In the range you can return the collector Borders and from there the object border. Mit freundlichen Grüßen / Best regards / Med venlig hilsen Jesper Jørgensen / Abt. NMT-XD Senior Product Manager arvato systems | Technologies GmbH An der Autobahn 18 33311 Gütersloh jesper.joergen...@bertelsmann.de blocked::blocked::blocked::mailto:jesper.joergen...@bertelsmann.de Phone: +49 5242 / 40 80 54 Fax: +49 5242 / 40 80 40 Mobile: +49 172 / 571 03 34 http://www.as-T.de blocked::blocked::http://www.as-t.biz/ arvato systems | Technologies GmbH Joachim-Jungius-Str. 9, 18059 Rostock Geschäftsführung: Erwin Pietz, Matthias Moeller Amtsgericht Rostock - HRB 7497 Der Inhalt dieser Nachricht oder eventueller Anlagen ist vertraulich und ausschließlich für den bezeichneten Adressaten bestimmt. Bitte stellen Sie sicher, dass die Information in dieser Nachricht ausschließlich an die adressierten Personen gelangt. Sollte diese Nachricht versehentlich an Sie gesendet worden sein, dann informieren Sie bitte umgehend den Absender und löschen Sie die Nachricht. Vielen Dank. The information in this e-mail and any attachments is confidential. The information must only be held in areas that have controlled and limited access to the addressed persons. If this e-mail has been sent to you in error, please immediately notify the sender and delete the e-mail. Thanks. Von: development-axapta@yahoogroups.com [mailto:development-axa...@yahoogroups.com] Im Auftrag von gollywogman Gesendet: Freitag, 9. Januar 2009 09:56 An: development-axapta@yahoogroups.com Betreff: [development-axapta] Borders in Excel with x++ Hi there everyone Does anyone know how to put borders around a cell in Excel using Axapta? Any help would be highly appreciated. Thank you [Non-text portions of this message have been removed]
AW: [development-axapta] Re: Integration with Axapta
Hi, if you are post 4.0 you should take a look at the AIF components. Mit freundlichen Grüßen / Best regards / Med venlig hilsen Jesper Jørgensen / Abt. NMT-XD Senior Product Manager arvato systems | Technologies GmbH An der Autobahn 18 33311 Gütersloh jesper.joergen...@bertelsmann.de blocked::blocked::blocked::mailto:jesper.joergen...@bertelsmann.de Phone: +49 5242 / 40 80 54 Fax: +49 5242 / 40 80 40 Mobile: +49 172 / 571 03 34 http://www.as-T.de blocked::blocked::http://www.as-t.biz/ arvato systems | Technologies GmbH Joachim-Jungius-Str. 9, 18059 Rostock Geschäftsführung: Erwin Pietz, Matthias Moeller Amtsgericht Rostock - HRB 7497 Der Inhalt dieser Nachricht oder eventueller Anlagen ist vertraulich und ausschließlich für den bezeichneten Adressaten bestimmt. Bitte stellen Sie sicher, dass die Information in dieser Nachricht ausschließlich an die adressierten Personen gelangt. Sollte diese Nachricht versehentlich an Sie gesendet worden sein, dann informieren Sie bitte umgehend den Absender und löschen Sie die Nachricht. Vielen Dank. The information in this e-mail and any attachments is confidential. The information must only be held in areas that have controlled and limited access to the addressed persons. If this e-mail has been sent to you in error, please immediately notify the sender and delete the e-mail. Thanks. Von: development-axapta@yahoogroups.com [mailto:development-axa...@yahoogroups.com] Im Auftrag von Florian Dittgen Gesendet: Freitag, 30. Januar 2009 15:23 An: development-axapta@yahoogroups.com Betreff: [development-axapta] Re: Integration with Axapta --- In development-axapta@yahoogroups.com mailto:development-axapta%40yahoogroups.com , Trinadh Sura trin...@... wrote: Dear All,    what are the different types of method  can be  used for Integration with Axapta like ODBC.Can any one help me.it is urgent for client. Regards Trinadh [Non-text portions of this message have been removed] ADO and ODBC. Have a look at http://blogs.msdn.com/floditt/archive/2008/11/04/axapta-3-ado-instead- of-odbc-or-install-the-sp6.aspx for an exsample. [Non-text portions of this message have been removed]
AW: [development-axapta] Run an EXE from AX 2009 - Code Example
HI Use the WinApi Class. WinApi::shellExecute('Notepad.exe'); Mit freundlichen Grüßen / Best regards / Med venlig hilsen Jesper Jørgensen / Abt. NMT-XD Senior Product Manager arvato systems | Technologies GmbH An der Autobahn 18 33311 Gütersloh jesper.joergen...@bertelsmann.deblocked::blocked::blocked::mailto:jesper.joergen...@bertelsmann.de Phone: +49 5242 / 40 80 54 Fax: +49 5242 / 40 80 40 Mobile: +49 172 / 571 03 34 http://www.as-T.deblocked::blocked::http://www.as-t.biz/ arvato systems | Technologies GmbH Joachim-Jungius-Str. 9, 18059 Rostock Geschäftsführung: Erwin Pietz, Matthias Moeller Amtsgericht Rostock - HRB 7497 Der Inhalt dieser Nachricht oder eventueller Anlagen ist vertraulich und ausschließlich für den bezeichneten Adressaten bestimmt. Bitte stellen Sie sicher, dass die Information in dieser Nachricht ausschließlich an die adressierten Personen gelangt. Sollte diese Nachricht versehentlich an Sie gesendet worden sein, dann informieren Sie bitte umgehend den Absender und löschen Sie die Nachricht. Vielen Dank. The information in this e-mail and any attachments is confidential. The information must only be held in areas that have controlled and limited access to the addressed persons. If this e-mail has been sent to you in error, please immediately notify the sender and delete the e-mail. Thanks. Von: development-axapta@yahoogroups.com [mailto:development-axa...@yahoogroups.com] Im Auftrag von MvT Gesendet: Freitag, 29. Mai 2009 14:41 An: development-axapta@yahoogroups.com Betreff: [development-axapta] Run an EXE from AX 2009 - Code Example Hi there, Can someone please show me how to open another EXE within AX 2009 Job. Kind regards. [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
AW: [development-axapta] How to call a form method from method of other form
HI, the class Global has a method formHasMethod, to avoid a stack trace at runtime you might want to check if the caller has the method before you executes it using object. Object cannot validate the existence of the method during compilation. Best regards Jesper Von: development-axapta@yahoogroups.com [mailto:development-axa...@yahoogroups.com] Im Auftrag von Malcolm Burtt Gesendet: Mittwoch, 2. September 2009 17:24 An: development-axapta@yahoogroups.com Betreff: RE: [development-axapta] How to call a form method from method of other form Hi Assuming that form B has been called from form A you can say... void B() { Object formAobj = element.args().caller(); ; // Check that this form was opened from FormA If ( formAobj formAobj.name() == formstr(FormA) ) { // Call method A on FormA formAobj.A() } Return; } Regards Malcolm Burtt Touchstone Group People - Partnership - Solutions From: development-axapta@yahoogroups.commailto:development-axapta%40yahoogroups.com [mailto:development-axapta@yahoogroups.commailto:development-axapta%40yahoogroups.com] On Behalf Of shamikask Sent: 21 August 2009 17:39 To: development-axapta@yahoogroups.commailto:development-axapta%40yahoogroups.com Subject: [development-axapta] How to call a form method from method of other form Hello All, During the AX 4.0 development, I got stuck up at a point - Basically situation is like - Form A is having method A Form B is having method B Now I want to call method A in method B, How can I do it? Anybody help me out, please. Thanks, Shamika [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
AW: [development-axapta] Re: How to show a webpage in Ax 3.0
HI Take a look at the form DocuView. Microsoft uses an ActiveX control Microsoft Web Browser. Mit freundlichen Grüßen / Best regards / Med venlig hilsen Jesper Jørgensen / Abt. NMT-XD Senior Product Manager arvato systems | Technologies GmbH An der Autobahn 18 33311 Gütersloh jesper.joergen...@bertelsmann.deblocked::blocked::blocked::mailto:jesper.joergen...@bertelsmann.de Phone: +49 5242 / 40 80 54 Fax: +49 5242 / 40 80 40 Mobile: +49 172 / 571 03 34 http://www.as-T.deblocked::blocked::http://www.as-t.biz/ arvato systems | Technologies GmbH Joachim-Jungius-Str. 9, 18059 Rostock Geschäftsführung: Erwin Pietz, Matthias Moeller Amtsgericht Rostock - HRB 7497 Der Inhalt dieser Nachricht oder eventueller Anlagen ist vertraulich und ausschließlich für den bezeichneten Adressaten bestimmt. Bitte stellen Sie sicher, dass die Information in dieser Nachricht ausschließlich an die adressierten Personen gelangt. Sollte diese Nachricht versehentlich an Sie gesendet worden sein, dann informieren Sie bitte umgehend den Absender und löschen Sie die Nachricht. Vielen Dank. The information in this e-mail and any attachments is confidential. The information must only be held in areas that have controlled and limited access to the addressed persons. If this e-mail has been sent to you in error, please immediately notify the sender and delete the e-mail. Thanks. Von: development-axapta@yahoogroups.com [mailto:development-axa...@yahoogroups.com] Im Auftrag von surfing2alien Gesendet: Mittwoch, 2. September 2009 19:20 An: development-axapta@yahoogroups.com Betreff: [development-axapta] Re: How to show a webpage in Ax 3.0 Thanks Michael this sure is an easy way. However I see I asked the wrong question. I need to show it in a form I cannot see yet how to display the infolog in a form Any help with that please? S. --- In development-axapta@yahoogroups.commailto:development-axapta%40yahoogroups.com, mni_...@... wrote: Hi, perhaps infolog.helpGenerator().showURL(http://www.yahoo.com;) can help. Regards Michael From: surfing2alien Sent: Thursday, August 27, 2009 9:53 AM To: development-axapta@yahoogroups.commailto:development-axapta%40yahoogroups.com Subject: [development-axapta] How to show a webpage in Ax 3.0 Hi, can somebody show me the way how to show a webpage in Ax 3.0? For example: In a form I need to show a page like: http://ichart.finance.yahoo.com/instrument/1.0/%5EDJI/chart;range=1d/image;size=239x110; Thanks! S. [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
AW: [development-axapta] Select statement is easy but I have trouble making the QueryBuildDataSource
Hi, You are adding the join condition twice qHeader.addRange(fieldnum(ALPurchReqTable, PurchReqId)) .value(strfmt(' (%1.%2 == %3.%4) ', purchReqLine_ds.query().dataSourceNo(1).name(), fieldStr(ALPurchReqLine, PurchReqId), purchReqLine_ds.query().dataSourceNo(2).name(), fieldStr(ALPurchReqTable, PurchReqId))); qHeader.addLink(fieldnum(ALPurchReqLine, PurchReqId),fieldnum(ALPurchReqTable, PurchReqId)); I cannot see your table relations, I assume you have any. I clear the dynalinks in the example. public void init() { QueryBuildDataSource qPurchReqLine, qHeader, qApproval; ; super(); qPurchReqLine = purchReqLine_ds.query().dataSourceTable(tablenum(ALPurchReqLine)); qPurchReqLine.addRange(fieldnum(ALPurchReqLine, PurchLineCreated)).value(SysQuery::value(NoYes::No)); // Add Header qHeader = qPurchReqLine.addDataSource(tablenum(ALPurchReqTable)); qHeader.ClearDynaLinks(); qHeader.joinMode(JoinMode::OuterJoin); qHeader.addLink(fieldnum(ALPurchReqLine, PurchReqId),fieldnum(ALPurchReqTable, PurchReqId)); qApproval = qHeader.addDataSource(tablenum(ALApprovalStatus)); qApproval.ClearDynaLinks(); qApproval.joinMode(JoinMode::OuterJoin); qApproval.addRange(fieldnum(ALApprovalStatus, AppStatusType)).value(queryValue(ALAppStatus::Approved)); qApproval.addLink(fieldnum(ALPurchReqTable, RecId),fieldnum(ALApprovalStatus, RefRecId)); qApproval.addLink(fieldnum(ALPurchReqTable, TableId),fieldnum(ALApprovalStatus, RefTableId)); } Mit freundlichen Grüßen / Best regards / Med venlig hilsen Jesper Jørgensen / Abt. NMT-XD Senior Product Manager arvato systems | Technologies GmbH An der Autobahn 18 33311 Gütersloh jesper.joergen...@bertelsmann.deblocked::blocked::blocked::mailto:jesper.joergen...@bertelsmann.de Phone: +49 5242 / 40 80 54 Fax: +49 5242 / 40 80 40 Mobile: +49 172 / 571 03 34 http://www.as-T.deblocked::blocked::http://www.as-t.biz/ arvato systems | Technologies GmbH Joachim-Jungius-Str. 9, 18059 Rostock Geschäftsführung: Erwin Pietz, Matthias Moeller Amtsgericht Rostock - HRB 7497 Der Inhalt dieser Nachricht oder eventueller Anlagen ist vertraulich und ausschließlich für den bezeichneten Adressaten bestimmt. Bitte stellen Sie sicher, dass die Information in dieser Nachricht ausschließlich an die adressierten Personen gelangt. Sollte diese Nachricht versehentlich an Sie gesendet worden sein, dann informieren Sie bitte umgehend den Absender und löschen Sie die Nachricht. Vielen Dank. The information in this e-mail and any attachments is confidential. The information must only be held in areas that have controlled and limited access to the addressed persons. If this e-mail has been sent to you in error, please immediately notify the sender and delete the e-mail. Thanks. Von: development-axapta@yahoogroups.com [mailto:development-axa...@yahoogroups.com] Im Auftrag von benoit.billington Gesendet: Freitag, 4. September 2009 17:28 An: development-axapta@yahoogroups.com Betreff: [development-axapta] Select statement is easy but I have trouble making the QueryBuildDataSource I first created a job to see what I needed to do in 30sec it was done... easy query with multiple joins static void test(Args _args) { ALPurchReqLine line; ALPurchReqTable table; ALApprovalStatus status; ; while select line join table where line.PurchReqId == table.PurchReqId join status where status.RefRecId == table.RecId status.RefTableId == table.TableId { info(strfmt(%1, line.ItemId)); } } but then when trying with the query object I have trouble :( public void init() { QueryBuildDataSource qPurchReqLine, qHeader, qApproval; ; super(); qPurchReqLine = purchReqLine_ds.query().dataSourceTable(tablenum(ALPurchReqLine)); qPurchReqLine.addRange(fieldnum(ALPurchReqLine, PurchLineCreated)).value(SysQuery::value(NoYes::No)); //TODO purchReqLine_ds.query().dataSourceTable(tablenum(ALPurchReqLine)).addRange(fieldnum(ALPurchReqLine, Status)).value(SysQuery::value(PurchReqStatus::Approved)); qHeader = qPurchReqLine.addDataSource(tablenum(ALPurchReqTable), tableStr(ALPurchReqTable)); qHeader.joinMode(JoinMode::OuterJoin); qHeader.addRange(fieldnum(ALPurchReqTable, PurchReqId)) .value(strfmt(' (%1.%2 == %3.%4) ', purchReqLine_ds.query().dataSourceNo(1).name(), fieldStr(ALPurchReqLine, PurchReqId), purchReqLine_ds.query().dataSourceNo(2).name(), fieldStr(ALPurchReqTable, PurchReqId))); qHeader.addLink(fieldnum(ALPurchReqLine, PurchReqId),fieldnum(ALPurchReqTable, PurchReqId)); qApproval = qHeader.addDataSource(tablenum(ALApprovalStatus), tableStr(ALApprovalStatus)); qApproval.joinMode(JoinMode::OuterJoin); qApproval.addRange(fieldnum(ALApprovalStatus, AppStatusType)).value(queryValue(ALAppStatus::Approved)); qApproval.addRange(fieldnum(ALApprovalStatus, RefTableId)).value(queryValue(tablenum(ALPurchReqTable))); qApproval.addRange(fieldnum(ALApprovalStatus, RefRecId)) .value(strfmt('(%3.%4 == %1.%2) ',
AW: [development-axapta] Hide Button Based on User Permissions
Hi, Load the macro #Admin Implement this Method in the class Global static boolean IsUserInGroup (UserGroupId _GroupId = '', UserId _userId = CurUserId()) { #Admin UserGroupList info; ; if (!prmisdefault(_groupId)) _groupId = #AdminUserGroup; return (select recid from UserGroupList where UserGroupList.userId == _userId UserGroupList.groupId == _GroupId).recid !=0; } You can now use the function isUserIngroup to determine if a user is in a given group. The function returns true if the user is in the group otherwise false. Mit freundlichen Grüßen / Best regards / Med venlig hilsen Jesper Jørgensen / Abt. NMT-XD Senior Product Manager arvato systems | Technologies GmbH An der Autobahn 18 33311 Gütersloh jesper.joergen...@bertelsmann.deblocked::blocked::blocked::mailto:jesper.joergen...@bertelsmann.de Phone: +49 5242 / 40 80 54 Fax: +49 5242 / 40 80 40 Mobile: +49 172 / 571 03 34 http://www.as-T.deblocked::blocked::http://www.as-t.biz/ arvato systems | Technologies GmbH Joachim-Jungius-Str. 9, 18059 Rostock Geschäftsführung: Erwin Pietz, Matthias Moeller Amtsgericht Rostock - HRB 7497 Der Inhalt dieser Nachricht oder eventueller Anlagen ist vertraulich und ausschließlich für den bezeichneten Adressaten bestimmt. Bitte stellen Sie sicher, dass die Information in dieser Nachricht ausschließlich an die adressierten Personen gelangt. Sollte diese Nachricht versehentlich an Sie gesendet worden sein, dann informieren Sie bitte umgehend den Absender und löschen Sie die Nachricht. Vielen Dank. The information in this e-mail and any attachments is confidential. The information must only be held in areas that have controlled and limited access to the addressed persons. If this e-mail has been sent to you in error, please immediately notify the sender and delete the e-mail. Thanks. Von: development-axapta@yahoogroups.com [mailto:development-axa...@yahoogroups.com] Im Auftrag von branjema Gesendet: Donnerstag, 17. September 2009 19:48 An: development-axapta@yahoogroups.com Betreff: [development-axapta] Hide Button Based on User Permissions I want to make button visible to users if a salesorder is not confirmed. I have done this. But now I want to make the button visible to admins all the time. What's the best way to do this? Thanks in advance [Non-text portions of this message have been removed]
AW: [development-axapta] Disabling warming for number of companies licence
Hi, yes. You have exceeded your license you are missing the license key for unlimited Company accounts. Mit freundlichen Grüßen / Best regards / Med venlig hilsen Jesper Jørgensen / Abt. NMT-XD Senior Product Manager arvato systems | Technologies GmbH An der Autobahn 18 33311 Gütersloh jesper.joergen...@bertelsmann.deblocked::blocked::blocked::mailto:jesper.joergen...@bertelsmann.de Phone: +49 5242 / 40 80 54 Fax: +49 5242 / 40 80 40 Mobile: +49 172 / 571 03 34 http://www.as-T.deblocked::blocked::http://www.as-t.biz/ arvato systems | Technologies GmbH Joachim-Jungius-Str. 9, 18059 Rostock Geschäftsführung: Erwin Pietz, Matthias Moeller Amtsgericht Rostock - HRB 7497 Der Inhalt dieser Nachricht oder eventueller Anlagen ist vertraulich und ausschließlich für den bezeichneten Adressaten bestimmt. Bitte stellen Sie sicher, dass die Information in dieser Nachricht ausschließlich an die adressierten Personen gelangt. Sollte diese Nachricht versehentlich an Sie gesendet worden sein, dann informieren Sie bitte umgehend den Absender und löschen Sie die Nachricht. Vielen Dank. The information in this e-mail and any attachments is confidential. The information must only be held in areas that have controlled and limited access to the addressed persons. If this e-mail has been sent to you in error, please immediately notify the sender and delete the e-mail. Thanks. Von: development-axapta@yahoogroups.com [mailto:development-axa...@yahoogroups.com] Im Auftrag von daniele.selvi Gesendet: Dienstag, 13. Oktober 2009 14:51 An: development-axapta@yahoogroups.com Betreff: [development-axapta] Disabling warming for number of companies licence Hi all, I have to start a batch automatically, but having 4 test companies in my DB, everytime it logs in automatically it stops getting the warning message company number exceeds 3, and obviously the batch job doesnt start until the user presses the button ok. My question is the following: Is there a way for disabling this annoying warning message? Thanks, Daniele. [Non-text portions of this message have been removed]
RE: [development-axapta] Ax2009 and W2008
Hallo James, check the entries in the event log proir to your termination log entry. Jesper From: development-axapta@yahoogroups.com [mailto:development-axa...@yahoogroups.com] On Behalf Of James Flavell Sent: Dienstag, 3. November 2009 11:53 To: development-axapta@yahoogroups.com Subject: [development-axapta] Ax2009 and W2008 Hi everyone I know it is officially supported but has anyone had issue with W2008 (x64) and AX2009? Am getting event log: The Dynamics AX Object Server 5.0$01- service terminated unexpectedly. It has done this 1 time(s). And the log also says it says is running on a OS that is not supported and says W2003 SP1 is the supported os ..!!!??? I am running AX2009 SP1 with GLS and RU3 Thanks James [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
AW: [development-axapta] Using Ledger Purchase Invoice AIF Service
Hi, You can take a look at the standard documents (AX 4.0 and 2009). Inventory Journals AxdProfitLossJournal Ledger Journals AxdCustPaymJournal. Mit freundlichen Grüßen / Best regards / Med venlig hilsen Jesper Jørgensen / Abt. NMT-XD Senior Product Manager arvato systems | Technologies GmbH An der Autobahn 18 33311 Gütersloh jesper.joergen...@bertelsmann.deblocked::blocked::blocked::mailto:jesper.joergen...@bertelsmann.de Phone: +49 5242 / 40 80 54 Fax: +49 5242 / 40 80 40 Mobile: +49 172 / 571 03 34 http://www.as-T.deblocked::blocked::http://www.as-t.biz/ arvato systems | Technologies GmbH Joachim-Jungius-Str. 9, 18059 Rostock Geschäftsführung: Erwin Pietz, Matthias Moeller Amtsgericht Rostock - HRB 7497 Der Inhalt dieser Nachricht oder eventueller Anlagen ist vertraulich und ausschließlich für den bezeichneten Adressaten bestimmt. Bitte stellen Sie sicher, dass die Information in dieser Nachricht ausschließlich an die adressierten Personen gelangt. Sollte diese Nachricht versehentlich an Sie gesendet worden sein, dann informieren Sie bitte umgehend den Absender und löschen Sie die Nachricht. Vielen Dank. The information in this e-mail and any attachments is confidential. The information must only be held in areas that have controlled and limited access to the addressed persons. If this e-mail has been sent to you in error, please immediately notify the sender and delete the e-mail. Thanks. Von: development-axapta@yahoogroups.com [mailto:development-axa...@yahoogroups.com] Im Auftrag von aziz.tahir Gesendet: Mittwoch, 18. November 2009 03:04 An: development-axapta@yahoogroups.com Betreff: [development-axapta] Using Ledger Purchase Invoice AIF Service Can we use one journal and create several invoice lines using the subject AIF service? Thanks, Tahir Aziz [Non-text portions of this message have been removed]
AW: [development-axapta] How To manipulate InventTable between companies
HI Why do you not create a table collection containing your table. You can setup an Virtual company account containing your table collection. Attach your two companies to your virtual company account. Your solution shares the table to all company accounts in the installation. Mit freundlichen Grüßen / Best regards / Med venlig hilsen Jesper Jørgensen / Abt. NMT-XD Senior Product Manager arvato systems | Technologies GmbH An der Autobahn 18 33311 Gütersloh jesper.joergen...@bertelsmann.deblocked::blocked::blocked::mailto:jesper.joergen...@bertelsmann.de Phone: +49 5242 / 40 80 54 Fax: +49 5242 / 40 80 40 Mobile: +49 172 / 571 03 34 http://www.as-T.deblocked::blocked::http://www.as-t.biz/ arvato systems | Technologies GmbH Joachim-Jungius-Str. 9, 18059 Rostock Geschäftsführung: Erwin Pietz, Matthias Moeller Amtsgericht Rostock - HRB 7497 Der Inhalt dieser Nachricht oder eventueller Anlagen ist vertraulich und ausschließlich für den bezeichneten Adressaten bestimmt. Bitte stellen Sie sicher, dass die Information in dieser Nachricht ausschließlich an die adressierten Personen gelangt. Sollte diese Nachricht versehentlich an Sie gesendet worden sein, dann informieren Sie bitte umgehend den Absender und löschen Sie die Nachricht. Vielen Dank. The information in this e-mail and any attachments is confidential. The information must only be held in areas that have controlled and limited access to the addressed persons. If this e-mail has been sent to you in error, please immediately notify the sender and delete the e-mail. Thanks. Von: development-axapta@yahoogroups.com [mailto:development-axa...@yahoogroups.com] Im Auftrag von Melinda Nagy Gesendet: Dienstag, 24. November 2009 15:03 An: development-axapta@yahoogroups.com Betreff: Re: [development-axapta] How To manipulate InventTable between companies Hello! When I wanted to share data between 2 companies, I created a table with the specific fields, and I've changed the table SaveDataPerCompany property to No. Hope it helps! Regards, Melinda --- On Tue, 10/13/09, João Melo joaorockass...@gmail.commailto:joaorockassete%40gmail.com wrote: From: João Melo joaorockass...@gmail.commailto:joaorockassete%40gmail.com Subject: [development-axapta] How To manipulate InventTable between companies To: development-axapta@yahoogroups.commailto:development-axapta%40yahoogroups.com Date: Tuesday, October 13, 2009, 2:13 PM Hi, I’m Brazilian, so sorry about my English! I’m experiencing virtual company accounts. And I need to share all information about Items between two companies. Do somebody know what tables I need to include in the Table Collection to make all items visible for the two company accounts in my virtual company account? Thank’s. João Melo MCBMSS Microsoft Dynamics AX 2009 - Development Introduction [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
AW: [development-axapta] Help - AIF
Hi, Hope this helps. Generally we prefer using the Biztalk, but it is always an budget issue. a) pros cons of using BizTalk v/s File adapter v/s MSMQ? The BizTalk server is often mistaken for being a batch engine, if you plan to use the Biztalk server like that, save your money and use server executed batch jobs within AX 2009. Biztalk supplies a lot of functions in Process Monitoring and Business rules. The answer is hard to give, without knowing the use case. (b) Are all of them able to handle fail over scenarios? We need to ensure no XML should be missed. The functionality is basically the same and enforced my AIF. With Biztalk the technical failures are passed back to Biztalk and not thrown within AX. All Logical errors are kept in the exception log within AX, That is also the place where you need to fix it. (c) There should be a mechanism for acknowledgement timer for example, if acknowledgement is not received from external systems in 60 minutes, alert. (email) should be thrown. You should implement this using long running transactions within Biztalk. (d) Performance benchmark. Check the homepage from Microsoft. If performance is an issue, you should select Biztalk, this would move part of the Interface execution to another infrastructure. Mit freundlichen Grüßen / Best regards / Med venlig hilsen Jesper Jørgensen / Abt. NMT-XD Senior Product Manager arvato systems | Technologies GmbH An der Autobahn 18 33311 Gütersloh jesper.joergen...@bertelsmann.deblocked::blocked::blocked::mailto:jesper.joergen...@bertelsmann.de Phone: +49 5242 / 40 80 54 Fax: +49 5242 / 40 80 40 Mobile: +49 172 / 571 03 34 http://www.as-T.deblocked::blocked::http://www.as-t.biz/ arvato systems | Technologies GmbH Joachim-Jungius-Str. 9, 18059 Rostock Geschäftsführung: Erwin Pietz, Matthias Moeller Amtsgericht Rostock - HRB 7497 Der Inhalt dieser Nachricht oder eventueller Anlagen ist vertraulich und ausschließlich für den bezeichneten Adressaten bestimmt. Bitte stellen Sie sicher, dass die Information in dieser Nachricht ausschließlich an die adressierten Personen gelangt. Sollte diese Nachricht versehentlich an Sie gesendet worden sein, dann informieren Sie bitte umgehend den Absender und löschen Sie die Nachricht. Vielen Dank. The information in this e-mail and any attachments is confidential. The information must only be held in areas that have controlled and limited access to the addressed persons. If this e-mail has been sent to you in error, please immediately notify the sender and delete the e-mail. Thanks. Von: development-axapta@yahoogroups.com [mailto:development-axa...@yahoogroups.com] Im Auftrag von Ax Dev Gesendet: Dienstag, 26. Januar 2010 18:24 An: axapta-knowledge-vill...@yahoogroups.com; development-axapta@yahoogroups.com Betreff: [development-axapta] Help - AIF Hi Friends, I need your help to evaluate the best solution to integrate various external systems with Dynamics AX 2009 by using AIF functionality (BizTalk/File adaper/MSMQ). Can anyone please help to direct me to: (a) pros cons of using BizTalk v/s File adapter v/s MSMQ? (b) Are all of them able to handle fail over scenarios? We need to ensure no XML should be missed. (c) There should be a mechanism for acknowledgement timer for example, if acknowledgement is not received from external systems in 60 minutes, alert (email) should be thrown. (d) Performance benchmark. Can you please help me in this regard? Thanks a lot in advance. Best Regards, PS [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
AW: [development-axapta] AIF outbound acknowledgments
Hi, I only know the Return Order Acknowledgement Document within Dynamics AX 2009. I guess that is not what you are looking for, as Dynamics AX 2009 sends this. The process you describe we never solve within Dynamics AX, we prefer using the Biztalk server for that. The process monitoring within Dynamics AX is not that good. If an document is not delivered, you need to do a lot of coding to create a workflow that can be operated by an super user. Defining a long running transaction within Biztalk, will give you an easy access to integration process monitoring and a high flexibility in designing what should happen. You are absolutely right, that the Message ID in Unique. It is stored in the table AIFCorralation, the document is stored in AIFMessageLog. Mit freundlichen Grüßen / Best regards / Med venlig hilsen Jesper Jørgensen / Abt. NMT-XD Senior Product Manager arvato systems | Technologies GmbH An der Autobahn 18 33311 Gütersloh jesper.joergen...@bertelsmann.de Phone: +49 5242 / 40 80 54 Fax: +49 5242 / 40 80 40 Mobile: +49 172 / 571 03 34 http://www.as-T.de arvato systems | Technologies GmbH Joachim-Jungius-Str. 9, 18059 Rostock Geschäftsführung: Erwin Pietz, Matthias Moeller Amtsgericht Rostock - HRB 7497 Der Inhalt dieser Nachricht oder eventueller Anlagen ist vertraulich und ausschließlich für den bezeichneten Adressaten bestimmt. Bitte stellen Sie sicher, dass die Information in dieser Nachricht ausschließlich an die adressierten Personen gelangt. Sollte diese Nachricht versehentlich an Sie gesendet worden sein, dann informieren Sie bitte umgehend den Absender und löschen Sie die Nachricht. Vielen Dank. The information in this e-mail and any attachments is confidential. The information must only be held in areas that have controlled and limited access to the addressed persons. If this e-mail has been sent to you in error, please immediately notify the sender and delete the e-mail. Thanks. -Ursprüngliche Nachricht- Von: development-axapta@yahoogroups.com [mailto:development-axa...@yahoogroups.com] Im Auftrag von Ax Dev Gesendet: Samstag, 30. Januar 2010 20:25 An: development-axapta@yahoogroups.com Betreff: [development-axapta] AIF outbound acknowledgments Hi Friends, It's regarding outbound acknowledgements. I am trying to understand if I send some XML (let's say COA outbound- send electronically) to external system (let's say using file adapter), AIF framework will create XML with unique message id. I need the receive the acknowledgement for this message to ensure proper delivery. How-ever, if I develop new service to receive acknowledgement (new inbound service) from external system, how the AX AIF will be able to understand that this XML is related to what I sent? I can think of getting the same message id as request message id in acknowledgment but where these message ids are being stored in AX to correlate? It would be great if you can let me know the standard AX example that gives acknowledgment for outbound process so that I can look into it for better understanding. Thank you! Regards, HB [Non-text portions of this message have been removed] Yahoo! Groups Links
AW: [development-axapta] Launching AX forms and creating records in the form through .Net
Hi, the short answer is no. The .net connector from ax does not support forms or reports. You would have to start the ax client to open the form. You need to modify ax to launch a form during startup. Or you can consider building a .net form and utilize the application integration framework to interact with ax. Mit freundlichen Grüßen / Best regards / Med venlig hilsen Jesper Jørgensen / Abt. NMT-XD Senior Product Manager arvato systems | Technologies GmbH An der Autobahn 18 33311 Gütersloh jesper.joergen...@bertelsmann.deblocked::blocked::blocked::mailto:jesper.joergen...@bertelsmann.de Phone: +49 5242 / 40 80 54 Fax: +49 5242 / 40 80 40 Mobile: +49 172 / 571 03 34 http://www.as-T.deblocked::blocked::http://www.as-t.biz/ arvato systems | Technologies GmbH Joachim-Jungius-Str. 9, 18059 Rostock Geschäftsführung: Erwin Pietz, Matthias Moeller Amtsgericht Rostock - HRB 7497 Der Inhalt dieser Nachricht oder eventueller Anlagen ist vertraulich und ausschließlich für den bezeichneten Adressaten bestimmt. Bitte stellen Sie sicher, dass die Information in dieser Nachricht ausschließlich an die adressierten Personen gelangt. Sollte diese Nachricht versehentlich an Sie gesendet worden sein, dann informieren Sie bitte umgehend den Absender und löschen Sie die Nachricht. Vielen Dank. The information in this e-mail and any attachments is confidential. The information must only be held in areas that have controlled and limited access to the addressed persons. If this e-mail has been sent to you in error, please immediately notify the sender and delete the e-mail. Thanks. Von: development-axapta@yahoogroups.com [mailto:development-axa...@yahoogroups.com] Im Auftrag von srinath s Gesendet: Dienstag, 4. Mai 2010 06:41 An: development-axapta@yahoogroups.com Betreff: [development-axapta] Launching AX forms and creating records in the form through .Net Hello Folks, From .Net whether is it possible to Launch the Ax forms and create records with some mandatory data in it. From .net when we click ok button from the windows form it should launch the AX form (for example customer form) , create a record in this form and set the values in the fields(filling the Customer account, customer group). Appreciate a response. Thanks and Regards, Srinath. S [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
AW: [development-axapta] AX4.0 how to know batch process is running
Hi James, We are solving that problem for a customer at the moment. You could check if the batch user is logged on to the SQL server, only that will not give you the answer you are looking for. The user can be logged on, and the batch process has crashed, or the user is not logged on, but the batch process is running - but Idle. We decided to introduce a heartbeat to the batch process. After execution on the batch process we write a XML file with an execution log. The heartbeat is monitored a BizTalk server starting a workflow if the batch process has not been executed the last 10 minutes. Mit freundlichen Grüßen / Best regards / Med venlig hilsen Jesper Jørgensen / Abt. NMT-XD Senior Product Manager arvato systems | Technologies GmbH An der Autobahn 18 33311 Gütersloh jesper.joergen...@bertelsmann.deblocked::blocked::blocked::mailto:jesper.joergen...@bertelsmann.de Phone: +49 5242 / 40 80 54 Fax: +49 5242 / 40 80 40 Mobile: +49 172 / 571 03 34 http://www.as-T.deblocked::blocked::http://www.as-t.biz/ arvato systems | Technologies GmbH Joachim-Jungius-Str. 9, 18059 Rostock Geschäftsführung: Erwin Pietz, Matthias Moeller Amtsgericht Rostock - HRB 7497 Der Inhalt dieser Nachricht oder eventueller Anlagen ist vertraulich und ausschließlich für den bezeichneten Adressaten bestimmt. Bitte stellen Sie sicher, dass die Information in dieser Nachricht ausschließlich an die adressierten Personen gelangt. Sollte diese Nachricht versehentlich an Sie gesendet worden sein, dann informieren Sie bitte umgehend den Absender und löschen Sie die Nachricht. Vielen Dank. The information in this e-mail and any attachments is confidential. The information must only be held in areas that have controlled and limited access to the addressed persons. If this e-mail has been sent to you in error, please immediately notify the sender and delete the e-mail. Thanks. Von: development-axapta@yahoogroups.com [mailto:development-axa...@yahoogroups.com] Im Auftrag von James Flavell Gesendet: Donnerstag, 13. Mai 2010 10:24 An: development-axapta@yahoogroups.com Betreff: [development-axapta] AX4.0 how to know batch process is running Hi everyone, I am not sure if this has been asked in the group before but if yes please help direct me to the posting I want to setup some way to alert me if the batch process (or batch user login) has failed or not been started in AX4.0. Basically I have several companies and about 5 batch groups in each so that is 10 batch processes that need to be running. I just want a simple way to get an email notification if the batch process is not running Usually the problem is the batch user session is terminated for various reason such as hardware problem So I was thinking is there some SQL script I can make to check the batch user is logged in or somehow from outside AX query what batch groups or processes are currently running in AX? Thanks in advance for your help James [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
AW: [development-axapta] Inbound Create Purchase Order AIF service
Hi Jennifer, there is no standard service to create purchase orders. The service you found is the purchase requisition that requires a purchase order to work. You will need to create a new service to be able for create purchase orders. For a complete listing of the AX standard services please referee to http://msdn.microsoft.com/en-US/library/aa859008%28v=AX.50%29.aspx Mit freundlichen Grüßen / Best regards / Med venlig hilsen Jesper Jørgensen / Abt. NMT-XD Senior Product Manager arvato systems | Technologies GmbH An der Autobahn 18 33311 Gütersloh jesper.joergen...@bertelsmann.deblocked::blocked::blocked::mailto:jesper.joergen...@bertelsmann.de Phone: +49 5242 / 40 80 54 Fax: +49 5242 / 40 80 40 Mobile: +49 172 / 571 03 34 http://www.as-T.deblocked::blocked::http://www.as-t.biz/ arvato systems | Technologies GmbH Joachim-Jungius-Str. 9, 18059 Rostock Geschäftsführung: Erwin Pietz, Matthias Moeller Amtsgericht Rostock - HRB 7497 Der Inhalt dieser Nachricht oder eventueller Anlagen ist vertraulich und ausschließlich für den bezeichneten Adressaten bestimmt. Bitte stellen Sie sicher, dass die Information in dieser Nachricht ausschließlich an die adressierten Personen gelangt. Sollte diese Nachricht versehentlich an Sie gesendet worden sein, dann informieren Sie bitte umgehend den Absender und löschen Sie die Nachricht. Vielen Dank. The information in this e-mail and any attachments is confidential. The information must only be held in areas that have controlled and limited access to the addressed persons. If this e-mail has been sent to you in error, please immediately notify the sender and delete the e-mail. Thanks. Von: development-axapta@yahoogroups.com [mailto:development-axa...@yahoogroups.com] Im Auftrag von JS Gesendet: Freitag, 11. Juni 2010 07:52 An: development-axapta@yahoogroups.com Betreff: [development-axapta] Inbound Create Purchase Order AIF service Hi, I was looking at the list of standard AIF services and I could not find one to create a purchase order (inbound). Has anyone experienced interfacing new purchase orders using AIF? How did you do it? Is there any standard AIF service somewhere for creating purchase orders? There is a Purchpurchreqservice (Find, Findkeys, Read) but there is not Create function. Many thanks, Jennifer From: Trinadh Sura trinadh_s...@iicindia.commailto:trinadh_sura%40iicindia.com To: axapta-knowledge-vill...@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com Cc: development-axapta@yahoogroups.commailto:development-axapta%40yahoogroups.com Sent: Mon, 7 June, 2010 7:33:42 PM Subject: [development-axapta] Reg FedEx Integration Hi all, How to integrate Axapta with FedEx ? What is the right process to test with live FedEx Account ? Thanks Regards Trinadh Sura [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
AW: [development-axapta] Inbound Create Purchase Order AIF service
Hi Jennifer, yes I do – I did ☺. What version are you implementing? Mit freundlichen Grüßen / Best regards / Med venlig hilsen Jesper Jørgensen / Abt. NMT-XD Senior Product Manager arvato systems | Technologies GmbH An der Autobahn 18 33311 Gütersloh jesper.joergen...@bertelsmann.deblocked::blocked::blocked::mailto:jesper.joergen...@bertelsmann.de Phone: +49 5242 / 40 80 54 Fax: +49 5242 / 40 80 40 Mobile: +49 172 / 571 03 34 http://www.as-T.deblocked::blocked::http://www.as-t.biz/ arvato systems | Technologies GmbH Joachim-Jungius-Str. 9, 18059 Rostock Geschäftsführung: Erwin Pietz, Matthias Moeller Amtsgericht Rostock - HRB 7497 Der Inhalt dieser Nachricht oder eventueller Anlagen ist vertraulich und ausschließlich für den bezeichneten Adressaten bestimmt. Bitte stellen Sie sicher, dass die Information in dieser Nachricht ausschließlich an die adressierten Personen gelangt. Sollte diese Nachricht versehentlich an Sie gesendet worden sein, dann informieren Sie bitte umgehend den Absender und löschen Sie die Nachricht. Vielen Dank. The information in this e-mail and any attachments is confidential. The information must only be held in areas that have controlled and limited access to the addressed persons. If this e-mail has been sent to you in error, please immediately notify the sender and delete the e-mail. Thanks. Von: development-axapta@yahoogroups.com [mailto:development-axa...@yahoogroups.com] Im Auftrag von JS Gesendet: Sonntag, 13. Juni 2010 23:16 An: development-axapta@yahoogroups.com Betreff: Re: [development-axapta] Inbound Create Purchase Order AIF service Hi Jesper, Thanks for the information. We are currently in a very tight timeline. Do you know if anyone has already done this before? Thanks, Jennifer -- Hi Jennifer, there is no standard service to create purchase orders. The service you found is the purchase requisition that requires a purchase order to work. You will need to create a new service to be able for create purchase orders. For a complete listing of the AX standard services please referee to http://msdn.microsoft.com/en-US/library/aa859008%28v=AX.50%29.aspx Mit freundlichen Grüßen / Best regards / Med venlig hilsen Jesper Jørgensen / Abt. NMT-XD Senior Product Manager arvato systems | Technologies GmbH An der Autobahn 18 33311 Gütersloh jesper.joergen...@bertelsmann.demailto:jesper.joergen...%40bertelsmann.deblocked::blocked::blocked::mailto:jesper.joergen...@bertelsmann.demailto:jesper.joergen...%40bertelsmann.de From: JS jdsal...@yahoo.commailto:jdsaldua%40yahoo.com To: development-axapta@yahoogroups.commailto:development-axapta%40yahoogroups.com Sent: Fri, 11 June, 2010 5:51:57 PM Subject: [development-axapta] Inbound Create Purchase Order AIF service Hi, I was looking at the list of standard AIF services and I could not find one to create a purchase order (inbound). Has anyone experienced interfacing new purchase orders using AIF? How did you do it? Is there any standard AIF service somewhere for creating purchase orders? There is a Purchpurchreqservice (Find, Findkeys, Read) but there is not Create function. Many thanks, Jennifer From: Trinadh Sura trinadh_s...@iicindia.commailto:trinadh_sura%40iicindia.com To: axapta-knowledge-vill...@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com Cc: development-axapta@yahoogroups.commailto:development-axapta%40yahoogroups.com Sent: Mon, 7 June, 2010 7:33:42 PM Subject: [development-axapta] Reg FedEx Integration Hi all, How to integrate Axapta with FedEx ? What is the right process to test with live FedEx Account ? Thanks Regards Trinadh Sura [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
AW: [development-axapta] Vendor Invoice Journal from Business Connector
The number Sequence uses two sessions (two concurrent users?) to allocate a new number. Check the eventlogs on the server to see if you have problems with your license. Mit freundlichen Grüßen / Best regards / Med venlig hilsen Jesper Jørgensen / Abt. NMT-XD Senior Product Manager arvato systems | Technologies GmbH An der Autobahn 18 33311 Gütersloh jesper.joergen...@bertelsmann.deblocked::blocked::blocked::mailto:jesper.joergen...@bertelsmann.de Phone: +49 5242 / 40 80 54 Fax: +49 5242 / 40 80 40 Mobile: +49 172 / 571 03 34 http://www.as-T.deblocked::blocked::http://www.as-t.biz/ arvato systems | Technologies GmbH Joachim-Jungius-Str. 9, 18059 Rostock Geschäftsführung: Erwin Pietz, Matthias Moeller Amtsgericht Rostock - HRB 7497 Der Inhalt dieser Nachricht oder eventueller Anlagen ist vertraulich und ausschließlich für den bezeichneten Adressaten bestimmt. Bitte stellen Sie sicher, dass die Information in dieser Nachricht ausschließlich an die adressierten Personen gelangt. Sollte diese Nachricht versehentlich an Sie gesendet worden sein, dann informieren Sie bitte umgehend den Absender und löschen Sie die Nachricht. Vielen Dank. The information in this e-mail and any attachments is confidential. The information must only be held in areas that have controlled and limited access to the addressed persons. If this e-mail has been sent to you in error, please immediately notify the sender and delete the e-mail. Thanks. Von: development-axapta@yahoogroups.com [mailto:development-axa...@yahoogroups.com] Im Auftrag von Roberto Ukmar Gesendet: Donnerstag, 30. September 2010 10:18 An: development-axapta@yahoogroups.com Betreff: R: [development-axapta] Vendor Invoice Journal from Business Connector Hi, Is the business connector logged on the right company? (or is on the dat company)? Da: development-axapta@yahoogroups.commailto:development-axapta%40yahoogroups.com [mailto:development-axapta@yahoogroups.commailto:development-axapta%40yahoogroups.com] Per conto di Adam Gregory Inviato: mercoledì 29 settembre 2010 16:03 A: development-axapta@yahoogroups.commailto:development-axapta%40yahoogroups.com Oggetto: [development-axapta] Vendor Invoice Journal from Business Connector I have a static method in X++ that creates a Vendor Invoice Journal. When I run this method from a job inside of AX the journal is created without a problem. When I try to run the method from the business connector I get exception: Additional information: Number sequence for the reference Journal number in parameters in the General ledger module has not been set up. The number sequence is set up and works fine from inside AX. Does anyone know what would cause this? Thank you, Adam . http://geo.yahoo.com/serv?s=97359714/grpId=514494/grpspId=1705006764/msgId= 18157/stime=1285830681/nc1=3848644/nc2=5741393/nc3=4507179 [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
AW: [development-axapta] How to get the used Table id in Ax 2009
Hi, why do you want to do that? The table ID is used internally in Dynamics AX to link objects in the development environment. It is also used to synchronize the data dictionary from Dynamics AX on the SQL Server. If you change the ID a table synchronizing the database will give you problems. If you are running out of ID's for your application you should setup the Dynamics AX Team Server. Using the team server and vss you can assign more ID's to the USR Layer. You can only change the ID by exporting the table, deleting the table and importing it again. Be aware that deploying this application to your next stage will lead to data being deleted. Best regards Jesper Jørgensen Von: development-axapta@yahoogroups.com [mailto:development-axa...@yahoogroups.com] Im Auftrag von roshannuvvula Gesendet: Dienstag, 23. November 2010 11:58 An: development-axapta@yahoogroups.com Betreff: [development-axapta] How to get the used Table id in Ax 2009 Hi, when ever i am creating a table it gives a unique id. let us assume that i create table TABLE1 for testing it gives the id 500010 after i created another table TABLE2 with id 500011. Now deleted the table which is having the id 500010. Now what i want is how to assign the table id 500010(Deleted table id) to TABLE2 ? [Non-text portions of this message have been removed]