tag:blogger.com,1999:blog-2974482147905584746.comments2023-08-25T11:10:13.478+05:30Microsoft Dynamics AXArijit Basuhttp://www.blogger.com/profile/01185979527817805880noreply@blogger.comBlogger202125tag:blogger.com,1999:blog-2974482147905584746.post-12220426588919370282011-08-09T11:29:57.678+05:302011-08-09T11:29:57.678+05:30Hi Arijit,
Nice and very useful article, Please s...Hi Arijit,<br /><br />Nice and very useful article, Please share post, Best method of Importing data into AX. Since there are many ways to insert data through writing Jobs, Classes, Built-in Excel Import functionality etc.<br /><br />Based on your experience bulk data import and multiple tables which one you suggest.Mohammed Arif Hussainhttps://www.blogger.com/profile/18041664674867504511noreply@blogger.comtag:blogger.com,1999:blog-2974482147905584746.post-33794115510425810052011-07-17T11:47:18.298+05:302011-07-17T11:47:18.298+05:30Nice Post. This enter helped me in my university a...Nice Post. This enter helped me in my university assignment. Thanks AlotAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-2974482147905584746.post-55845248261290154012010-11-07T04:42:19.410+05:302010-11-07T04:42:19.410+05:30Just as an information to people who read this, yo...Just as an information to people who read this, you don't actually have to know the integer combinations for all the color codes. Just use a method like WinAPI::RGB2Int() in order to get the int value for an RGB color.<br />For example, WinAPI::RGB2Int(255, 255, 0) will give you the color yellow.Ivan (Vanya) Kashperukhttps://www.blogger.com/profile/10348419620302833791noreply@blogger.comtag:blogger.com,1999:blog-2974482147905584746.post-15784052633788932062010-08-18T21:56:45.832+05:302010-08-18T21:56:45.832+05:30Hi Arijit,
How are you doing my friend?
I'm u...Hi Arijit,<br />How are you doing my friend?<br /><br />I'm using your tweak, but I've got some problems involving lookup forms. Some employees in diferent machines has a strange behavior when they try to use a lookup form (e.g. change Invoice Account from one customer), the problem is that you need to select the record above that you want to this works.<br /><br />I've solved the problem using:<br />if(this.design().windowType() == FormWindowType::Standard)<br /> workflowControls.initControls();<br /><br />If I wasn't clear, please, let my know in the msn!<br /><br />Thanks for all and best regards.Ricardo Pichlerhttps://www.blogger.com/profile/10370251801023890016noreply@blogger.comtag:blogger.com,1999:blog-2974482147905584746.post-78773109732453195102010-07-25T18:33:36.703+05:302010-07-25T18:33:36.703+05:30nice one :)nice one :)Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2974482147905584746.post-8320252815147715562010-06-18T00:10:31.466+05:302010-06-18T00:10:31.466+05:30Great hint to start with, but even easier with you...Great hint to start with, but even easier with your job Karel.<br /><br />ThanksKeivn Mckennahttp://www.sqlhook.comnoreply@blogger.comtag:blogger.com,1999:blog-2974482147905584746.post-70933330719226730362010-05-14T18:49:22.262+05:302010-05-14T18:49:22.262+05:30Thx, that did the job for me :-)Thx, that did the job for me :-)Unknownhttps://www.blogger.com/profile/16518295379051614355noreply@blogger.comtag:blogger.com,1999:blog-2974482147905584746.post-42840818995292952392010-05-03T11:42:12.285+05:302010-05-03T11:42:12.285+05:30Hi Arijit,
We are trying to run IDM for our clien...Hi Arijit,<br /><br />We are trying to run IDM for our client. But facing problem in post installation checklist during snapshot analysis. It is failing every time with the error "Package InsIndexcaptureStats" failed. We are trying it on Win server 2003, Ax 4.0 and SQL server 2005. Any suggestion would be highly helpful.<br /><br />Regards,<br />BharaniBharanihttps://www.blogger.com/profile/16712981891508277095noreply@blogger.comtag:blogger.com,1999:blog-2974482147905584746.post-72014899500257136052010-04-19T23:40:55.368+05:302010-04-19T23:40:55.368+05:30Hello,
Thinks for the article. I would like to kn...Hello,<br /><br />Thinks for the article. I would like to know how can I insert the '%' character into the Workflow Email?<br /><br />Thinks in advance,Mohamed Amine HAMDAOUIhttps://www.blogger.com/profile/02391860893850553517noreply@blogger.comtag:blogger.com,1999:blog-2974482147905584746.post-56639263882403728752010-04-15T07:50:05.319+05:302010-04-15T07:50:05.319+05:30Hi Arijit!
Thank you for this post. This is somet...Hi Arijit!<br /><br />Thank you for this post. This is something I was looking for. Have you seen/tried/known about some more visually intensive modifications in AX forms? Something like a watermark on Content Panel and all forms? All I could accomplish before your post was changing background color for all forms through SysFormRunSetup class.<br /><br />Any ideas?<br /><br />Thanks again!<br />FernandoBatonihttps://www.blogger.com/profile/13020406266403002481noreply@blogger.comtag:blogger.com,1999:blog-2974482147905584746.post-36512993673670370522010-03-21T23:45:28.405+05:302010-03-21T23:45:28.405+05:30"To to the job right you need the right tools..."To to the job right you need the right tools."<br /><br />Apparently they need a keyboard with one more letter 'd' :)<br />But sounds interesting, I will be following that blog also.Tomhttps://www.blogger.com/profile/17169300033108668868noreply@blogger.comtag:blogger.com,1999:blog-2974482147905584746.post-56553418093095186202010-03-17T12:22:31.952+05:302010-03-17T12:22:31.952+05:30Ever since I started working on AX 2 years ago, I ...Ever since I started working on AX 2 years ago, I fell head over heals in love with it. This love was nourished by the power of sharing that you and others generously and constantly provide. Thanks for a great post and a great blog.Fatohttps://www.blogger.com/profile/08669094150359322369noreply@blogger.comtag:blogger.com,1999:blog-2974482147905584746.post-81348897448944232202010-03-14T22:58:31.711+05:302010-03-14T22:58:31.711+05:30Thank you so much Arijit! I owe you one!!Thank you so much Arijit! I owe you one!!Antonio Gilaberthttp://elrincondynamics.esnoreply@blogger.comtag:blogger.com,1999:blog-2974482147905584746.post-56546003016837492552010-03-12T19:03:24.683+05:302010-03-12T19:03:24.683+05:30I am currently implementing Dynamics AX 2009 as co...I am currently implementing Dynamics AX 2009 as complete replacement solution for every application used in every area of in a manufacturing environment. Financials, PDM, EDI, WMS, MRP, Trade & Logistics, CRM.....and we are including Lean Manufacturing in the mix as an add-on to the capex. <br /><br />I bought this book, and it is worth the money. We are replacing a web-based replenishment Kanban system, Ultriva, and a falsely termed Kanban inventory movement system that was coded in an AS/400 Mapics system. <br /><br />We have many scenarios, Engineer-to-Order, Make-to-Order, Make-to-Stock and have over 57,000 active bills (FG's, Purchased, Sub-Assemblies and Phantoms). The system is full of garbage now, duplicate records, etc...and no way to net inventory. It's really a mess.<br /><br />We are using the book as a guideline to model all scenarios in a design environment right now and it has helped tremendously. <br /><br />Kutos on the book. We are working with eBecs as well, a'la carte style for guidance in some of the finer points and key criteria for utilizing the Lean Manufacturing module to the max. capacity.<br /><br />Randy Granger<br />Independant AX ConsultantAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-2974482147905584746.post-74068029792972008682010-03-12T13:42:47.113+05:302010-03-12T13:42:47.113+05:30Hi,
the link is not working.
Where can I see ho...Hi, <br />the link is not working. <br /><br />Where can I see how task recorder works, or where can I find a guide ?Karlnoreply@blogger.comtag:blogger.com,1999:blog-2974482147905584746.post-86302498508301180702010-03-09T13:51:16.303+05:302010-03-09T13:51:16.303+05:30Thanks for this tutorial, look into it.
I've ...Thanks for this tutorial, look into it.<br /><br />I've figured out a fast way to import data in MS Dynamics as well. It uses almost only sql statements:<br /><br />First let's create a table (classroom) in dynamics. It has two collumn: RoomNumber and LocationDescription (both String).<br /><br />Now you want to load 1.500.000 (exact!) classrooms via a CSV file. It has the following sturcture:<br /><br />A01;Teachers Room<br />A02;Green Room<br />C2002;Gymn<br />....<br /><br />If you want to add lines in a table without using AX you should fill in the RECIDs properly: AX allows you to reserve X number of recids for a certain table. Use the following code:<br /><br />static void reserve_classRooms(Args _args)<br />{<br /> SystemSequence seq;<br /> ;<br /> seq = new SystemSequence();<br /> if(seq){<br /> Seq.suspendRecIds(tablenum(classroom));<br /> //In the next commando you reserve 1.500.000 recids. The system will not use these!<br /> print seq.reserveValues(1500000,tablenum(classroom));<br /><br /> // Remove the recId suspension.<br /> Seq.removeRecIdSuspension(tablenum(classroom));<br /> pause;<br /> }<br /> }<br /><br />The system will print a number to your screen. e.g: 3.000.000.000 Now you know you can use 3.000.000.000 until 3.001.500.000.<br /><br />Your work in dynamics is now done.<br />In sql you recreate your table. Only you have to default your Dataareaid and you create an identity on your recid (starting with the value of previous job)<br /><br />e.g.<br /><br />create table tmp_classroom (<br />RoomNumber varchar(20),<br />LocationDescription varchar (50),<br />DataAreaId varchar(4) default 'dat',<br />Recid, bigint identity(3000000000,1)<br />)<br /><br />Next you create a view on this table. This view represents the format of the csv file (in case extra collumns are not in the csv or the order is different)<br />e.g.<br /><br />create view w<br />as<br />select roomnumber,locationdescription from classroom<br /><br />Now you use the bulkinsert commando to load your csv in your view (or in your tmp_Classroom table)<br />e.g.<br /><br />bulk insert w from '\\networklocation\classrooms.csv' with (FIELDTERMINATOR = ';')<br /><br />everything is now correct in your tmp_table (you can do checks on it)<br /><br />last thing you need to do is copy everything from the tmp_ table in the real table.<br /><br />insert into classroom(roomnumber,locationdescription,dataareaid, recid) select roomnumber,locationdescription,dataareaid,recid from tmp_classroom<br /><br /><br />this is it. You can insert 4.500.000lines in less than 2 minutes. Because you're using powerfull sql server functionsKarelnoreply@blogger.comtag:blogger.com,1999:blog-2974482147905584746.post-17207650777525669642010-02-19T18:59:29.906+05:302010-02-19T18:59:29.906+05:30Your blog keeps getting better and better! Your ol...Your blog keeps getting better and better! Your older articles are not as good as newer ones you have a lot more creativity and originality now. Keep it up! <br />And according to this article, I totally agree with your opinion, but only this time! :)Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2974482147905584746.post-11852776405013302692010-02-15T18:48:24.091+05:302010-02-15T18:48:24.091+05:30nice article. I would love to follow you on twitte...nice article. I would love to follow you on twitter.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2974482147905584746.post-89663994032215193552010-02-11T23:03:03.452+05:302010-02-11T23:03:03.452+05:30Great story you got here. I'd like to read mor...Great story you got here. I'd like to read more about that topic. Thank you for posting that info.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2974482147905584746.post-57581668909039274022010-02-02T05:07:52.661+05:302010-02-02T05:07:52.661+05:30Nice brief and this mail helped me alot in my coll...Nice brief and this mail helped me alot in my college assignement. Say thank you you on your information.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2974482147905584746.post-357179419051293822010-01-22T23:16:02.864+05:302010-01-22T23:16:02.864+05:30Don't stop posting such themes. I love to read...Don't stop posting such themes. I love to read articles like that. BTW add some pics :)Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2974482147905584746.post-65800703661209094172010-01-20T13:38:55.122+05:302010-01-20T13:38:55.122+05:30What a great resource!What a great resource!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2974482147905584746.post-77756375381834777422010-01-19T20:16:33.210+05:302010-01-19T20:16:33.210+05:30I just want too take time too thank the active mem...I just want too take time too thank the active members for doing what you do and make this community great im a long time reader and first time poster so i just wanted to say thanks.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2974482147905584746.post-18232432833796956732010-01-18T21:00:35.010+05:302010-01-18T21:00:35.010+05:30Great article you got here. It would be great to r...Great article you got here. It would be great to read a bit more concerning this topic. Thank you for sharing this data.<br />Joan Stepsen<br /><a href="http://altgeek.org/" rel="nofollow">Wise geek</a>Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2974482147905584746.post-70322995016672161752010-01-18T19:02:12.190+05:302010-01-18T19:02:12.190+05:30It was certainly interesting for me to read this b...It was certainly interesting for me to read this blog. Thanx for it. I like such topics and anything that is connected to them. BTW, try to add some pics :).Anonymousnoreply@blogger.com