Re: [Axapta-Knowledge-Village] Weird Exception in AX3
Hi, Can you please tell me where you are facing that exception? what is the form of the exception? like is it coming as an infolog/warning/error or a dialogbox? Can you put a screenshot of the incident? There is certain internal script errors in the AX product, both in AX 3.0 and 4.0. If you face this kind of errors, you simply have nothing to do other than trying some alternative path for that. You cannot catch the reason by putting breakpoint in Add method of info class or putting a try catch block. As for example, there is a class Sysmailer, which is used to send emails from AX thru a SMTP/DNS server. When we have tried this class to send auto-generated emails, it gives some internal script error in form of a dialogbox. We have reported it to Microsoft and they told this was already reported to them and they are working with it, so there was no solution for that. We have finally opted for an alternative solution for that. Barunava - Original Message From: Earl Rey Lacsina [EMAIL PROTECTED] To: Axapta-Knowledge-Village Axapta-Knowledge-Village@yahoogroups.com Sent: Wednesday, 19 December, 2007 7:36:09 AM Subject: [Axapta-Knowledge-Village] Weird Exception in AX3 I'm encountering an exception in AX3 but my problem is that this exception have no description in the infolog. I have put a breakpoint in ADD METHOD of the INFO CLASS but the exception doesn't pass there. I thought all exception pass in that class? try { //do something } catch { //exception catched with no description. } If I try the code below, exception is not catched. try { } catch(exception: :error) { } catch(exception: :break) { } catch(exception: :sequence) { } catch(exception: :ddeerror) { } catch(exception: :deadlock) { } catch(exception: :info) { } catch(exception: :internal) { } catch(exception: :numeric) { } catch(exception: :warning) { } How can I see the description of this exception? Anyone encounter this problem? Internal Virus Database is out-of-date. Checked by AVG Free Edition. Version: 7.5..476 / Virus Database: 269.9.6/865 - Release Date: 6/24/2007 8:33 AM [Non-text portions of this message have been removed] Share files, take polls, and discuss your passions - all under one roof. Go to http://in.promos.yahoo.com/groups [Non-text portions of this message have been removed]
Re: [Axapta-Knowledge-Village] Copy Record on Form
Hi, you cannot just ctrl+c and ctrl+v some record to another line. There is copy functionality in various places in the system, specially in journals. You can do this in this way. You can put a button called Copy and when the user clicks on the button, a reference will be asked (like Sales Order number, Item Number). After putting this, create a new record where you populate all the fields from the selected record (use data() method, it copies all the fields at once). Barunava - Original Message From: ricardodegouveia [EMAIL PROTECTED] To: Axapta-Knowledge-Village@yahoogroups.com Sent: Friday, 14 December, 2007 11:56:56 AM Subject: [Axapta-Knowledge-Village] Copy Record on Form Hi is there a way to copy a whole record in a form and paste it under it in the form? ie. I have SalesOrder line which is basically the same all the time except only one field changes each time. so want to copy previous one and paste and only have to change the one field?. Is this possible? How then? Thanking you in advance Ricardo Explore your hobbies and interests. Go to http://in.promos.yahoo.com/groups [Non-text portions of this message have been removed]
[Axapta-Knowledge-Village] Re: CLOSING INVENTORY PROBLEM
Pak Lukas temennya maria zf ? in my place production job was never been closed untill the production is done. --- In Axapta-Knowledge-Village@yahoogroups.com, Lukas Nugroho Putro [EMAIL PROTECTED] wrote: Hi, have you checked : 1. there is no abnormal transaction on purchasing (large amount caused by currency) 2. all production on that month should be closed IRWAN [EMAIL PROTECTED] wrote: Hi, i'm new on axapta. We had run inventory closing for several times and its goes without any trouble. This month we ran it first with maximum throughputs 10.000 and it didnt finish until the next day, cause we got alot to do (such as entry data, run MRP, and so on) on that day we had to terminate it and let other user do their job. On weekend we started it again with maximum troughputs 100 and for two days until now and its still running. What should we do and what could cause this problem? does anyone willing to help ? thx - Expecting? Get great news right away with email Auto-Check. Try the Yahoo! Mail Beta. [Non-text portions of this message have been removed]
[Axapta-Knowledge-Village] Re: Loading masters
See the Data Export/Import functionality under Administration--Periodic
Re: [Axapta-Knowledge-Village] Loading masters
Maharaja, Are you alone working in AX in your org and there was no person who have worked in this before? This is quite a good effort and should be learnt from your predecessors (as you might have learnt how to import data thru dataport in NAV). Anyway, find the help of Administration Module as data import/export is located in this module (Administration- Periodic- Data export/import) Barunava - Original Message From: Maharaja g [EMAIL PROTECTED] To: Axapta-Knowledge-Village@yahoogroups.com Sent: Wednesday, 19 December, 2007 9:13:35 AM Subject: [Axapta-Knowledge-Village] Loading masters Hi Friends, I am a newbee in Ax.I am a consultant in Navision and came into Ax last month.In Navision to load Chart of accounts,vendor master ,customer master and item master into a fresh database (new company) we use dataports to import data from external source(excel ).How to do this in Ax?Any documents or detailed procedures would be very useful for me.Thanks in advance. Maharaja - - --- Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. [Non-text portions of this message have been removed] Unlimited freedom, unlimited storage. Get it now, on http://help.yahoo.com/l/in/yahoo/mail/yahoomail/tools/tools-08.html/ [Non-text portions of this message have been removed]
Re: [Axapta-Knowledge-Village] A Query
Naeem, This is a huge requirement, and we have done it for one of our project. We have introduced a dual UOM for any item and used this dual UOM in every possible transaction of the item. It affects all the related inventory and ledger transaction in intended way. But, again, I'm telling you this is huge, and will take a great amount of time even for an experienced and excellent technical person. Barunava - Original Message From: [EMAIL PROTECTED] [EMAIL PROTECTED] To: Axapta-Knowledge-Village@yahoogroups.com Sent: Tuesday, 18 December, 2007 8:49:28 PM Subject: RE: [Axapta-Knowledge-Village] A Query Naeem, The work you need to do will go up incrementally if you need to keep track of multiple length/size pieces in one item number. Then if you need to price by weight and/or piece you will also need to modify the price calc routines. We’ve done those modifications for a Steel company and it can get complex. Danny Band Power IT Consulting Ltd. [EMAIL PROTECTED] ca www.powerit. ca - - - - - - From: Axapta-Knowledge- [EMAIL PROTECTED] ups.com [mailto:Axapta- Knowledge- [EMAIL PROTECTED] .com] On Behalf Of [EMAIL PROTECTED] dk Sent: Tuesday, December 18, 2007 3:41 AM To: Axapta-Knowledge- [EMAIL PROTECTED] ups.com Subject: Re: [Axapta-Knowledge- Village] A Query Check out unit conversion on the Item Master table. /Jens Hi Allz, I came to know that AXAPTA can only manage one unit of measure per item, either it is Tons, Pcs, length or etc etc.. but I've a scenario that we are in steel trading and we need to keep the inventory by Weight (Tons) and by Pcs (roles/Bars) as well but the coasting is being done by Weight (Tons). it means when ever you print item master report it must show that how much Weight (tons) and quantity by Pcs (roles/bars) left in stock by item. Obviously needed to included this info on SO/PO as well. any idea how Axapta can/will handle it? Thanks Naeem Sarwar [Non-text portions of this message have been removed] Chat on a cool, new interface. No download required. Go to http://in.messenger.yahoo.com/webmessengerpromo.php [Non-text portions of this message have been removed]
Re: [Axapta-Knowledge-Village] Square character on string fields
Agus, which fields are populated with this square value? It generally happens if there was some unrecognised characters. I think you are getting this in Address field. The address field shows the concatenation of all the address parts and in the table you can see the squares in place of the delimiter. Have you checked the field showing this square in forms? If yes, does this field is showing the squares in there also?? Barunava - Original Message From: Agus Riyadi [EMAIL PROTECTED] To: Axapta-Knowledge-Village@yahoogroups.com Sent: Wednesday, 12 December, 2007 4:49:41 PM Subject: Re: [Axapta-Knowledge-Village] Square character on string fields Hi, Thanks for your response but that doesn't work. I have compile my whole AOT 3 times (include during upgrade checklist) but I still get the square character. Regards, Agus On Dec 12, 2007 1:27 PM, nakul barai [EMAIL PROTECTED] com wrote: I think you have to compile AOT again. Thanks, Agus Riyadi [EMAIL PROTECTED] com agusacil%40gmail. com wrote: Hi, I experienced strange behavior after upgrade axapta from 3.0 SP1 to 4.0SP2. When creating new record in purchase order, many string fields got square character (hexa 02) value after I selected vendor account. This does not happen to other tables. Any suggestions ? Thanks and best regards, Agus [Non-text portions of this message have been removed] - - --- Never miss a thing. Make Yahoo your homepage. [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] 5, 50, 500, 5000 - Store N number of mails in your inbox. Go to http://help.yahoo.com/l/in/yahoo/mail/yahoomail/tools/tools-08.html [Non-text portions of this message have been removed]
Re: [Axapta-Knowledge-Village] Virtual company - ProjCategory
Hi, I have done this in one of my project. Whether it is ProjCategory or any other table, putting it in virtual company is a crucial decision. Be sure that you need the same categories for all the companies attached to that virtual company. All the best. Barunava - Original Message From: shaakera_b [EMAIL PROTECTED] To: Axapta-Knowledge-Village@yahoogroups.com Sent: Thursday, 6 December, 2007 4:44:20 PM Subject: [Axapta-Knowledge-Village] Virtual company - ProjCategory HI All, Has anyone had any experiences with the ProjCategory being part of a virtual company? We are wanting to add this table to the collection, however I feel a bit nervous about this move as there is so much transactional data dependant on this? Any recommendations ? Why delete messages? Unlimited storage is just a click away. Go to http://help.yahoo.com/l/in/yahoo/mail/yahoomail/tools/tools-08.html [Non-text portions of this message have been removed]
Re: [Axapta-Knowledge-Village] Re: Print Reort in Exel
Hi, Sorry for the delay, I havn't checked the mails in this grp for quite a long time. Though it seems you have got a solution and it is working also, you can try this simpler one to print your report directly to excel. this.printJobSettings().setTarget(PrintMedium::File); this.printJobSettings().format(PrintFormat::ASCII); this.printJobSettings().fileName(fileName); Put this in the init method of your report. Put a proper file name (e.g. C:\1.xls). Barunava - Original Message From: Chirani [EMAIL PROTECTED] To: Axapta-Knowledge-Village@yahoogroups.com Sent: Monday, 10 December, 2007 8:09:11 AM Subject: [Axapta-Knowledge-Village] Re: Print Reort in Exel Barunava, Can you explain how to do this by code. Many Thanks, Chirani. --- In Axapta-Knowledge- [EMAIL PROTECTED] ups.com, Barunava Pal [EMAIL PROTECTED] . wrote: Hi Febin, Do you want to print the report in excel instead of viewing it in screen or print it in some printer? You can do that through code but in that case every time that report will be printed in excel you can not view it in screen or printer. Tell specifically about the requirement. Barunava - Original Message From: febinpc [EMAIL PROTECTED] To: Axapta-Knowledge- [EMAIL PROTECTED] ups.com Sent: Monday, 3 December, 2007 12:54:19 PM Subject: [Axapta-Knowledge- Village] Print Reort in Exel hi friends i want to print one report daily basis. and i want that data in excel. not all columns but some specified columns.for calculation purpose. how can i make it in Axapta.when i run report this excel sheet also should come up directly just like wxcel export. Thanks and Regards Febin Chiramel Mumbai !-- #ygrp-mkp{ border:1px solid #d8d8d8;font- family:Arial; margin:14px 0px;padding: 0px 14px;} #ygrp-mkp hr{ border:1px solid #d8d8d8;} #ygrp-mkp #hd{ color:#628c2a; font-size: 85%;font- weight:bold; line- height:122%; margin:10px 0px;} #ygrp-mkp #ads{ margin-bottom: 10px;} #ygrp-mkp .ad{ padding:0 0;} #ygrp-mkp .ad a{ color:#ff; text-decoration: none;} -- !-- #ygrp-sponsor #ygrp-lc{ font-family: Arial;} #ygrp-sponsor #ygrp-lc #hd{ margin:10px 0px;font-weight: bold;font- size:78%; line-height: 122%;} #ygrp-sponsor #ygrp-lc .ad{ margin-bottom: 10px;padding: 0 0;} -- !-- #ygrp-mlmsg {font-size:13px; font-family: arial, helvetica, clean, sans-serif;} #ygrp-mlmsg table {font-size:inherit; font:100% ;} #ygrp-mlmsg select, input, textarea {font:99% arial, helvetica, clean, sans-serif;} #ygrp-mlmsg pre, code {font:115% monospace;} #ygrp-mlmsg * {line-height: 1.22em;} #ygrp-text{ font-family: Georgia; } #ygrp-text p{ margin:0 0 1em 0;} #ygrp-tpmsgs{ font-family: Arial; clear:both;} #ygrp-vitnav{ padding-top: 10px;font- family:Verdana; font-size: 77%;margin: 0;} #ygrp-vitnav a{ padding:0 1px;} #ygrp-actbar{ clear:both;margin: 25px 0;white-space: nowrap;color: #666;text- align:right; } #ygrp-actbar .left{ float:left;white- space:nowrap; } .bld{font-weight: bold;} #ygrp-grft{ font-family: Verdana;font- size:77%; padding:15px 0;} #ygrp-ft{ font-family: verdana;font- size:77%; border-top: 1px solid #666; padding:5px 0; } #ygrp-mlmsg #logo{ padding-bottom: 10px;} #ygrp-vital{ background-color: #e0ecee;margin- bottom:20px; padding:2px 0 8px 8px;} #ygrp-vital #vithd{ font-size:77% ;font-family: Verdana;font- weight:bold; color:#333; text- transform:uppercase ;} #ygrp-vital ul{ padding:0;margin: 2px 0;} #ygrp-vital ul li{ list-style-type: none;clear: both;border: 1px solid #e0ecee; } #ygrp-vital ul li .ct{ font-weight: bold;color: #ff7900;float: right;width: 2em;text- align:right; padding-right: .5em;} #ygrp-vital ul li .cat{ font-weight: bold;} #ygrp-vital a{ text-decoration: none;} #ygrp-vital a:hover{ text-decoration: underline; } #ygrp-sponsor #hd{ color:#999;font- size:77%; } #ygrp-sponsor #ov{ padding:6px 13px;background- color:#e0ecee; margin-bottom: 20px;} #ygrp-sponsor #ov ul{ padding:0 0 0 8px;margin:0; } #ygrp-sponsor #ov li{ list-style-type: square;padding: 6px 0;font-size: 77%;} #ygrp-sponsor #ov li a{ text-decoration: none;font- size:130% ;} #ygrp-sponsor #nc{ background-color: #eee;margin- bottom:20px; padding:0 8px;} #ygrp-sponsor .ad{ padding:8px 0;} #ygrp-sponsor .ad #hd1{ font-family: Arial;font- weight:bold; color:#628c2a; font- size:100%;line- height:122% ;} #ygrp-sponsor .ad a{ text-decoration: none;} #ygrp-sponsor .ad a:hover{ text-decoration: underline; } #ygrp-sponsor .ad p{ margin:0;} o{font-size: 0;} .MsoNormal{ margin:0 0 0 0;} #ygrp-text tt{ font-size:120% ;} blockquote{margin: 0 0 0 4px;} .replbq{margin: 4;} -- Share files, take polls, and discuss your passions - all under one roof. Go to http://in.promos. yahoo.com/ groups [Non-text portions of this message have been removed] 5, 50,
[Axapta-Knowledge-Village] Re: Axapta slower on SQL Server 2005 then SQL Server 2000?
Hi Harry, 1 - Is there documentation explaining MS recommendations about SQL Server setup you're talking about? 2 - Wow, never heard of those disc-alignment issue. Seems to cause quite of a performance problem. It's surprising people don't talk about that much. I'll need a bit more reading to understand the problem better and check if our SAN could suffer from this. I hope not! 3, 4 - Cluster Index and compatibility mode : Note inserted in my upgrade plan. :) Thanks for the tips! Steeve... --- In Axapta-Knowledge-Village@yahoogroups.com, Harry Deshpande [EMAIL PROTECTED] wrote: Hi As per my experience SQL Server 2005 performance is much better than '2000'. 1. Please check whether the SQL Server setup is in line with Microsoft recommendations. 2. Go further and check things like disc-alignment. Take a look at http://sqlblogcasts.com/blogs/christian/archive/2007/10/09/disk- sector-alignment.aspx 3. SQL Server 2005 engine is heavily optimized towards cluster indexes. You will see a lot of cluster indexes introduced from V4.0 onwards. Please back-port them. However, please note that there is a small chance that the cluster indexes for some tables in standard Ax may not be appropriate with your data usage pattern. In this case you will have to figure out the best fit cluster index yourself. 4. Last but not the least make sure you are running the database with compatibility mode 90. (It is easy to forget this). I must say I am a very happy camper since I started using SQL Server 2005. Regards Harry This posting is provided AS IS with no warranties, and confers no rights. Use of included script samples are subject to the terms specified at http://www.microsoft.com/info/cpyright.htm; The code provided (if any) may be written from the point of view of a third party and the programming style/development standards may suit such a point of view. From: Axapta-Knowledge-Village@yahoogroups.com [mailto:Axapta- [EMAIL PROTECTED] On Behalf Of Steeve Gilbert Sent: Tuesday, December 18, 2007 10:51 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Axapta slower on SQL Server 2005 then SQL Server 2000? I read a couple of post here and there about Axapta being slower on SQL Server 2005 then 2000. I thought that people that have problem post messages and those who don't stays quiet. That's why I was only seeing post about SQL 2005 being slower. But then I stubble on a post on MBS forum (http://www.microsoft.com/Businesssolutions/Community/Newsgroups/dgbro ws er/en-us/default.mspx? query=sql+2005dg=microsoft.public.axapta.databasecat=lang=encr=US pt =catlist=8d3f188d-a0E9-40e4-86e2- 46508a35c759dglist=ptlist=exp=sloc=en-us). And the quote is : First of all Ax database runing on same hardware with SQL2005 is ~20% slower than SQL200 database (tested). I can't find something clearer that this. So, does my friends of the Axapta Knowledge Village acknowledge this statement? I'm gonna test this in our dev environment and if it turns out true, then it's gonna be the end of our SQL Server 2005 migration I guess. Btw, we are staying at Ax3.0 SP3 even if we migrate to SQL 2005. [Non-text portions of this message have been removed]
RE: [Axapta-Knowledge-Village] Re: Axapta slower on SQL Server 2005 then SQL Server 2000?
Hi There are a lot of considerations regarding SQL server setup and I am no expert in this stuff. Some examples are : Default schema for all users should be set to DBO, Tempb should be configured with multiple, equal -sized files. Number of files should match the number of processors, There are also special recommendations as to where to keep the tempDB file. There should be some documentation regarding SQL server setup on msdn or technet microsoft. Or try placing a request thru partner channel. Please also take into account my comment about concurrency. i.e. if you are going to do bench-marking then do bench-marking for x number of concurrent user and not a single user. Regards Harry This posting is provided AS IS with no warranties, and confers no rights. Use of included script samples are subject to the terms specified at http://www.microsoft.com/info/cpyright.htm; The code provided (if any) may be written from the point of view of a third party and the programming style/development standards may suit such a point of view. From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Steeve Gilbert Sent: Wednesday, December 19, 2007 1:08 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Re: Axapta slower on SQL Server 2005 then SQL Server 2000? Hi Harry, 1 - Is there documentation explaining MS recommendations about SQL Server setup you're talking about? 2 - Wow, never heard of those disc-alignment issue. Seems to cause quite of a performance problem. It's surprising people don't talk about that much. I'll need a bit more reading to understand the problem better and check if our SAN could suffer from this. I hope not! 3, 4 - Cluster Index and compatibility mode : Note inserted in my upgrade plan. :) Thanks for the tips! Steeve... --- In Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com, Harry Deshpande [EMAIL PROTECTED] wrote: Hi As per my experience SQL Server 2005 performance is much better than '2000'. 1. Please check whether the SQL Server setup is in line with Microsoft recommendations. 2. Go further and check things like disc-alignment. Take a look at http://sqlblogcasts.com/blogs/christian/archive/2007/10/09/disk- sector-alignment.aspx 3. SQL Server 2005 engine is heavily optimized towards cluster indexes. You will see a lot of cluster indexes introduced from V4.0 onwards. Please back-port them. However, please note that there is a small chance that the cluster indexes for some tables in standard Ax may not be appropriate with your data usage pattern. In this case you will have to figure out the best fit cluster index yourself. 4. Last but not the least make sure you are running the database with compatibility mode 90. (It is easy to forget this). I must say I am a very happy camper since I started using SQL Server 2005. Regards Harry This posting is provided AS IS with no warranties, and confers no rights. Use of included script samples are subject to the terms specified at http://www.microsoft.com/info/cpyright.htm; The code provided (if any) may be written from the point of view of a third party and the programming style/development standards may suit such a point of view. From: Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com [mailto:Axapta- [EMAIL PROTECTED]mailto:Knowledge-Village%40yahoogroups.com] On Behalf Of Steeve Gilbert Sent: Tuesday, December 18, 2007 10:51 AM To: Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com Subject: [Axapta-Knowledge-Village] Axapta slower on SQL Server 2005 then SQL Server 2000? I read a couple of post here and there about Axapta being slower on SQL Server 2005 then 2000. I thought that people that have problem post messages and those who don't stays quiet. That's why I was only seeing post about SQL 2005 being slower. But then I stubble on a post on MBS forum (http://www.microsoft.com/Businesssolutions/Community/Newsgroups/dgbro ws er/en-us/default.mspx? query=sql+2005dg=microsoft.public.axapta.databasecat=lang=encr=US pt =catlist=8d3f188d-a0E9-40e4-86e2- 46508a35c759dglist=ptlist=exp=sloc=en-us). And the quote is : First of all Ax database runing on same hardware with SQL2005 is ~20% slower than SQL200 database (tested). I can't find something clearer that this. So, does my friends of the Axapta Knowledge Village acknowledge this statement? I'm gonna test this in our dev environment and if it turns out true, then it's gonna be the end of our SQL Server 2005 migration I guess. Btw, we are staying at Ax3.0 SP3 even if we migrate to SQL 2005. [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
RE: [Axapta-Knowledge-Village] Re: Axapta slower on SQL Server 2005 then SQL Server 2000?
Remembered something else...the DB server I was investigating had 1 system disk + 2 physical hard disk. The machine also had 2 hard-disk controllers. I kept the mdf and ldf file on separate physical drives and was very happy. No difference in the performance though. It took me some time to figure out that the same controller serviced both data hard disks and the other controller was for system disk. Regards Harry This posting is provided AS IS with no warranties, and confers no rights. Use of included script samples are subject to the terms specified at http://www.microsoft.com/info/cpyright.htm; The code provided (if any) may be written from the point of view of a third party and the programming style/development standards may suit such a point of view. From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Harry Deshpande Sent: Wednesday, December 19, 2007 1:24 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] Re: Axapta slower on SQL Server 2005 then SQL Server 2000? Hi There are a lot of considerations regarding SQL server setup and I am no expert in this stuff. Some examples are : Default schema for all users should be set to DBO, Tempb should be configured with multiple, equal -sized files. Number of files should match the number of processors, There are also special recommendations as to where to keep the tempDB file. There should be some documentation regarding SQL server setup on msdn or technet microsoft. Or try placing a request thru partner channel. Please also take into account my comment about concurrency. i.e. if you are going to do bench-marking then do bench-marking for x number of concurrent user and not a single user. Regards Harry This posting is provided AS IS with no warranties, and confers no rights. Use of included script samples are subject to the terms specified at http://www.microsoft.com/info/cpyright.htm; The code provided (if any) may be written from the point of view of a third party and the programming style/development standards may suit such a point of view. From: Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com [mailto:Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com] On Behalf Of Steeve Gilbert Sent: Wednesday, December 19, 2007 1:08 PM To: Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com Subject: [Axapta-Knowledge-Village] Re: Axapta slower on SQL Server 2005 then SQL Server 2000? Hi Harry, 1 - Is there documentation explaining MS recommendations about SQL Server setup you're talking about? 2 - Wow, never heard of those disc-alignment issue. Seems to cause quite of a performance problem. It's surprising people don't talk about that much. I'll need a bit more reading to understand the problem better and check if our SAN could suffer from this. I hope not! 3, 4 - Cluster Index and compatibility mode : Note inserted in my upgrade plan. :) Thanks for the tips! Steeve... --- In Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com, Harry Deshpande [EMAIL PROTECTED] wrote: Hi As per my experience SQL Server 2005 performance is much better than '2000'. 1. Please check whether the SQL Server setup is in line with Microsoft recommendations. 2. Go further and check things like disc-alignment. Take a look at http://sqlblogcasts.com/blogs/christian/archive/2007/10/09/disk- sector-alignment.aspx 3. SQL Server 2005 engine is heavily optimized towards cluster indexes. You will see a lot of cluster indexes introduced from V4.0 onwards. Please back-port them. However, please note that there is a small chance that the cluster indexes for some tables in standard Ax may not be appropriate with your data usage pattern. In this case you will have to figure out the best fit cluster index yourself. 4. Last but not the least make sure you are running the database with compatibility mode 90. (It is easy to forget this). I must say I am a very happy camper since I started using SQL Server 2005. Regards Harry This posting is provided AS IS with no warranties, and confers no rights. Use of included script samples are subject to the terms specified at http://www.microsoft.com/info/cpyright.htm; The code provided (if any) may be written from the point of view of a third party and the programming style/development standards may suit such a point of view. From: Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com [mailto:Axapta- [EMAIL PROTECTED]mailto:Knowledge-Village%40yahoogroups.commailto:Knowledge-Village%40yahoogroups.com] On Behalf Of Steeve Gilbert Sent: Tuesday, December 18, 2007 10:51 AM To:
RE: [Axapta-Knowledge-Village] Weird Exception in AX3
Actually its all X++ code. Error occurs when I'm posting inventory transfer journal. What I'm doing is inserting records in the inventory transfer journal using X++ and posting using InventJournalCheckPost class. I can successfully post when the InventJournalType is Movement but having an error when InventJournalType is Transfer. Any ideas? See below code: try { ttsbegin; inventJournalName = CustomProcess::FindCreateJournalName(STK13, InventJournalType::Transfer); //method tested and working inventJournalTable.clear(); inventJournalTable.initValue(); inventJournalTable.NumOfLines = lineNum; //from text file inventJournalTable.JournalNameId = inventJournalName.JournalNameId; inventJournalTable.VoucherSeqId = inventJournalName.VoucherSeqId; inventJournalTable.JournalType = InventJournalType::Transfer; //if change to movement, can successfully post. inventJournalTable.LedgerAccountIdOffset = inventJournalName.LedgerAccountIdOffset; inventJournalTable.insert(); fromInventDim.clear(); fromInventDim.initValue(); fromInventDim.InventLocationId = fromWhs; //from text file fromInventDim.InventColorId = fromColor; //from text file fromInventDim.inventBatchId = fromBatch; //from text file tempInventDimFrom.clear(); tempInventDimFrom = InventDim::findOrCreate(fromInventDim); toInventDim.clear(); toInventDim.initValue(); toInventDim.InventLocationId = toWhs; //from text file toInventDim.InventColorId = toColor; //from text file toInventDim.inventBatchId = toBatch; //from text file tempInventDimTo.clear(); tempInventDimTo = InventDim::findOrCreate(toInventDim); inventJournalTrans.clear(); inventJournalTrans.initValue(); inventJournalTrans.JournalId = inventJournalTable.JournalId; inventJournalTrans.InventDimId = tempInventDimFrom.inventDimId; inventJournalTrans.ToInventDimId = tempInventDimTo.inventDimId; inventJournalTrans.LedgerAccountIdOffset = inventJournalName.LedgerAccountIdOffset; inventJournalTrans.Voucher = inventJournalTable.VoucherSeqId; inventJournalTrans.ItemId = itemNum; //from text file inventJournalTrans.Qty = str2int(qty); //from text file inventJournalTrans.TransDate = SystemDateGet(); inventJournalTrans.insert(); checkPost = InventJournalCheckPost::newJournalCheckPost(JournalCheckPostType::Post, inventJournalTable); checkPost.parmAutoBlock(true); checkPost.run(); ttscommit; } catch {//breakpoint here that's why I know an exception occurs //create log } From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Barunava Pal Sent: Wednesday, December 19, 2007 3:43 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: Re: [Axapta-Knowledge-Village] Weird Exception in AX3 Hi, Can you please tell me where you are facing that exception? what is the form of the exception? like is it coming as an infolog/warning/error or a dialogbox? Can you put a screenshot of the incident? There is certain internal script errors in the AX product, both in AX 3.0 and 4.0. If you face this kind of errors, you simply have nothing to do other than trying some alternative path for that. You cannot catch the reason by putting breakpoint in Add method of info class or putting a try catch block. As for example, there is a class Sysmailer, which is used to send emails from AX thru a SMTP/DNS server. When we have tried this class to send auto-generated emails, it gives some internal script error in form of a dialogbox. We have reported it to Microsoft and they told this was already reported to them and they are working with it, so there was no solution for that. We have finally opted for an alternative solution for that. Barunava - Original Message From: Earl Rey Lacsina HYPERLINK mailto:elacsina%40gurango.com[EMAIL PROTECTED] To: Axapta-Knowledge-Village HYPERLINK mailto:Axapta-Knowledge-Village%40yahoogroups.comAxapta-Knowledge-Village@ yahoogroups.com Sent: Wednesday, 19 December, 2007 7:36:09 AM Subject: [Axapta-Knowledge-Village] Weird Exception in AX3 I'm encountering an exception in AX3 but my problem is that this exception have no description in the infolog. I have put a breakpoint in ADD METHOD of the INFO CLASS but the exception doesn't pass there. I thought all exception pass in that class? try { //do something } catch { //exception catched with no description. } If I try the code below, exception is not catched. try { } catch(exception: :error) { } catch(exception: :break) { } catch(exception: :sequence) { } catch(exception: :ddeerror) { } catch(exception: :deadlock) { } catch(exception: :info) { } catch(exception: :internal) { } catch(exception: :numeric) { } catch(exception: :warning) { } How can I see the description of this exception? Anyone encounter this problem? Internal Virus Database is out-of-date. Checked by AVG Free Edition. Version: 7.5..476 / Virus Database: 269.9.6/865 - Release Date: 6/24/2007 8:33 AM [Non-text
[Axapta-Knowledge-Village] Re: Latest Cost Price
Hi Mr.Manoj Mr.James, Thanks for your replies. In our company, so for we have been transacting without check marking the Latest cost price check box. We have implemented phase 1 of Production module. We are experiencing problems with respect to short booking of COGS and incorrect valuation of Inventories of Finished goods. On exploring, we have found that, at the time of carrying Production order Report As Finish activity, only quantity of the finished items gets updated without any physical cost (no General Ledger entries too). Financial cost is getting updated at the time of costing. In our business scenario, we used to sell the finished goods to customers even before carrying production order costing activity. This results in short/NIL booking of COGS as there are No/less value available in the on-hand inventory. If we check mark the latest cost price functionality, system posts physical cost for the FG item at the time of Production RAF. This we believe will resolve the gap and post the correct/approximate value at the time of COGS posting. Adjustments if any after production order costing would be posted by the system at the time of 'Recalculation'. Request you enlighten me your views as to whether our understanding is correct. Further, we understand from the white paper on Inventory closing published by Microsoft, that the bug in respect to Latest cost price with quarantine orders were fixed in Ax 3.0 - SP 3. Thanks regards, Rajamani --- In Axapta-Knowledge-Village@yahoogroups.com, James Flavell [EMAIL PROTECTED] wrote: The 'Latest cost price' means the cost price field on the item master will be updated every time you have an inventory transaction (I think its only reciepts) I assume you know what happens when 'Latest Purcahse price' is enabled. It is very much the same for 'latest cost price' except it is not just on purchase orders but other incoming transactions (excluding transfers in AX 4.0 I beleive, see below). As you probably know when you come to do something like a stock count or profit journal AX will use the item master cost price. If you have been updating regularly in theory you have a more accurate cost price to use on any gain of stock. In AX 3.0 I vaguely remember in earlier service packs the update latest cost price incldued transfer reciepts and this potentially could put a a very wrong cost price on the item master. I believe it was fixed at least in Ax 4.0 but you should test and simulate to be safe. In my customers case they could not understand why their inventory value went so high after a stock count and it was because of this bug (also they were doing corrects of stock locations via the stock count and so this was compounding the problem) If your cost price does not change very much then I would not bother to enable this but if you cost price is changing dramatically then you may want to try using it (or make sure before inventory counting or profit/loss that you have checked and set an accurate cost price on the item master) Also maybe there is some reason in production environment to have it ticked but i dont have the time to stop and think through sorry so maybe some one else can comment on it Thanks James _ From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of manoj manoharan Sent: 18 December 2007 13:37 To: Axapta-Knowledge-Village@yahoogroups.com Subject: Re: [Axapta-Knowledge-Village] Latest Cost Price Cost price in inventory works as following. Go to items form--general tab--inventory model group--Click go to main table 1)From there Click setup --Under inventory model group, there is a field Standard cost prie If you check it the cost price what you mentioned initem form--price/discount tab --cost price will be taken when you invoice the order. NOTE: Whatever order you invoice with this field checked will affect only inventory Cost price, It wont affect the general ledger account (the price you give in SO lines will be affected in finance GL ) 2) If you dont check that standard cost field , Then the average of price when you post a purchase order( price in PO lines) will be taken These details you can see in AR--Inventory--onhand --cost price. (So the price entered in SO lines wont be same compared to Cost price.) Then go to Inventory button--tyransactions-- transactions in physical/financial voucher See the the amount will be Cost price * qty. this will be posted in Inventory GL account Again if you check Included hysical value , Then cost price calculation will be Avg.CP= phy.value+finance value /Phy qty+fin qty) Thnaks Manoj - Original Message From: neyvelisrinivasan neyvelisrinivasan@ mailto:neyvelisrinivasan%40yahoo.co.in yahoo.co.in To: Axapta-Knowledge- mailto:Axapta-Knowledge-Village%40yahoogroups..com [EMAIL PROTECTED] Sent: Tuesday, 18 December, 2007 7:03:36 AM
[Axapta-Knowledge-Village] Missing Overload in InventMov_Journal
Im having an error when posting a inventory transfer journal. When I trace the error, it leads me to this Class : InventMov_Journal Method: parmUpdCostAmountphysical further trace leads to Class: Error Method: missingOverload How can I tell what overload is missing in the class InventMov_Journal? Can someone send me an export of InventMov_Journal for AX3 SP5 so I can compare mine? Internal Virus Database is out-of-date. Checked by AVG Free Edition. Version: 7.5.476 / Virus Database: 269.9.6/865 - Release Date: 6/24/2007 8:33 AM [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Come and choose your preferred name for Microsoft Dynamics AX on the Axapta Knowledge Village, Visit www.axapta-knowledge-village.tk Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ * Your email settings: Individual Email | Traditional * To change settings online go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/join (Yahoo! ID required) * To change settings via email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] * 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/