[Axapta-Knowledge-Village] Temp tables
Hi everyone once again Can someone tell me for temp tables in AX2009 are they for sure always created/stored and processed on the AOS server? Supposedly http://www.axaptapedia.com/Temporary_tables says the temp table is put on the hard disk of server or client based on where the first record is inserted. In AX2009 I assume all code is executed on the server but am not 100% . I am thinking the code in a form might well be executed on the client and hence my temp table end up on the client!??? My specific situation is to do with Arrival Overview form that populates some temp tables. Is there any way I can check or test where the temp table is being created? Thanks as ever James
[Axapta-Knowledge-Village] RE: Temp tables
Sorry I also meant to ask if I have a temp table and use SQL commands like sum and count is there still any benefits or actually this is the same as using a while select? Thanks J From: James Flavell [mailto:djf1...@gmail.com] Sent: 31 July 2010 13:05 To: 'Axapta-Knowledge-Village@yahoogroups.com' Subject: Temp tables Hi everyone once again Can someone tell me for temp tables in AX2009 are they for sure always created/stored and processed on the AOS server? Supposedly http://www.axaptapedia.com/Temporary_tables says the temp table is put on the hard disk of server or client based on where the first record is inserted. In AX2009 I assume all code is executed on the server but am not 100% . I am thinking the code in a form might well be executed on the client and hence my temp table end up on the client!??? My specific situation is to do with Arrival Overview form that populates some temp tables. Is there any way I can check or test where the temp table is being created? Thanks as ever James
RE: [Axapta-Knowledge-Village] Temp tables
Hi and thanks Harry for that, never thought to try it that way J Thanks and good to hear from you after so long, hope things are well with you and your family J From: Axapta-Knowledge-Village@yahoogroups.com [mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of Harry Deshpande Sent: 31 July 2010 13:14 To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] Temp tables The easiest way I can think of is, Write a method on the table, put a breakpoint. On the AOS configuration disable breakpoints running on server. Now execute the method, if it hits the break point then it is running on client otherwise on server. Regards Harry From: Axapta-Knowledge-Village@yahoogroups.com [mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of James Flavell Sent: Friday, July 30, 2010 10:05 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Temp tables Hi everyone once again Can someone tell me for temp tables in AX2009 are they for sure always created/stored and processed on the AOS server? Supposedly http://www.axaptapedia.com/Temporary_tables says the temp table is put on the hard disk of server or client based on where the first record is inserted. In AX2009 I assume all code is executed on the server but am not 100% . I am thinking the code in a form might well be executed on the client and hence my temp table end up on the client!??? My specific situation is to do with Arrival Overview form that populates some temp tables. Is there any way I can check or test where the temp table is being created? Thanks as ever James
RE: [Axapta-Knowledge-Village] Re: AX2009 is approved by the Chinese government?
Thanks George I have been in discussions with one of your colleagues in China already thanks J From: Axapta-Knowledge-Village@yahoogroups.com [mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of g4ernev Sent: 21 July 2010 19:22 To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Re: AX2009 is approved by the Chinese government? Hi James, The company I work for (Microsoft partner for AX) has a division in China. Below is the info provided by my colleagues there: Microsoft certified AX 2009 for its China Localization for all the accounting rules requirements, in fact AX was certified since it was AX 4.0 back in 2006. MS China has a division sales organization developing extra localization pack through out the year and their price and value offering is very competitive in China. There is no need to integrate AX with local system other than POS. There are many successful installations in China for a number of years already including some large and small implementations. The best approach is to find a local China Partner to handle the local implementation due Language and culture issues. Our company NMB China is a division of NMB Solutions and it was established in 2006 and has a number of successful implementations. I can send you the contact details of my colleagues there if you want to give them a call. George --- In Axapta-Knowledge-Village@yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com , James Flavell djf1...@... wrote: Hi everyone Can anyone clarify is AX2009 with the China localization approved by the Chinese government? Or must it go thru the approval process for each instance and if so has anyone had experience with doing this with std Ax2009? For a multinational company that needs group accounts plus meeting China local legal requirements what do you feel is the best approach? AX integrated to another local system? Thanks James image001.jpgimage002.jpg
[Axapta-Knowledge-Village] AX2009 is approved by the Chinese government?
Hi everyone Can anyone clarify is AX2009 with the China localization approved by the Chinese government? Or must it go thru the approval process for each instance and if so has anyone had experience with doing this with std Ax2009? For a multinational company that needs group accounts plus meeting China local legal requirements what do you feel is the best approach? AX integrated to another local system? Thanks James
[Axapta-Knowledge-Village] AX2009 windows left not responding
Hi everyone we have strange behaviour in AX2009 SP1 + GLS + RU3 Sometimes it seems users get AX windows that stop responding. In the list of the available windows inside AX these windows no longer appear in the list but in the OS taskbar they are there and can be selected but nothing can be done with them (including moving them around) I can open new windows in AX and they appear and act normal Does anyone know any ideas why this is? If seems like these windows have been lost by the AOS and so not considered as part of the users AX client session anymore It seems like it happens more with users who are working on inventory journals but cannot confirm anything about that Has anyone else had this or have any ideas what to check on? Thanks James
[Axapta-Knowledge-Village] Return Order type and RMA pains!!!!
Dear fellow AX suffers ;) I am writing to see if anyone else has struggled with the Return Order type and RMA in Sales and Purchase for AX2009. We have a customer with intercompany and found interco transactions using Return Order type has problems like Misc charges are not included on invoices I talked to someone else who also uses AX2009 and interco and they said they stopped using the Return Order type due to all the half done code/functions So we also decided to stop using Return Orders but it seems there is still some issues we face as follows: 1) Why does AX2009 fill in the RMA number on ALL sales orders it creates via interco!!!??? a. Even if the sales order is not a negative sales order it fills in the RMA! b. When a sales order is type 'Sales Order' (rather than 'Return Order') but RMA is filled in then: i. The sales order will NOT appear in Arrival Overview ii. Manual Arrival journal cannot be created for the sales order So just hoping to get anyone's experience and advice about changing the code so that: . RMA number on interco Sales Order is only filled in if we used the Return Order type Does anyone know of any good reason not to blank the RMA number on non 'Return Order' type sales orders? Thanks James
RE: [Axapta-Knowledge-Village] Creating alert rule for two Diff Forms Having Same Data Source.
Are you sure I thought it was table level! From: Axapta-Knowledge-Village@yahoogroups.com [mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of Anitha Santosh Sent: 09 April 2010 17:11 To: Axapta-Knowledge-Village@yahoogroups.com Subject: Re: [Axapta-Knowledge-Village] Creating alert rule for two Diff Forms Having Same Data Source. Hi , Alerts are specific to a form. They are no way related to tables. regards, anithasantosh On Fri, Apr 9, 2010 at 2:37 PM, kishore jyothi kishore_jy...@yahoo.co.in wrote: Hai thanks, My dought is That creating a new alerts for a new form having datasource( ex: purchtable) . I have created alerts for purchase order form( having datasource purchtable) earlier working fine. regards kishore _ From: Anitha Santosh mail2eani...@gmail.com To: Axapta-Knowledge-Village@yahoogroups.com Sent: Fri, 9 April, 2010 12:11:44 PM Subject: Re: [Axapta-Knowledge-Village] Creating alert rule for two Diff Forms Having Same Data Source. Hi .. Right click on the field in the form where you need to create alert and give the conditions. Run the batch job. (Basic-Periodic-Alerts-Change Based Alerts) When the condition is met, alert will ge generated automatically in Ax window. It is also possible to generate email alert. The process is different for this. Let me know if there are any issues. Regards, Anitha On Fri, Apr 9, 2010 at 11:57 AM, kishore kishore_jyoth@ mailto:kishore_jy...@yahoo.co.in yahoo.co. in wrote: Hai All, very Urgent!!! please Is It Possible That Creating a Alert Rules For Two different Forms Have the same datasource. If it Possible How to Implement it please help me from. Cheers kishore _ Your Mail works best with the New Yahoo Optimized IE8. Get it NOW! http://in.rd.yahoo.com/tagline_ie8_new/*http:/downloads.yahoo.com/in/intern etexplorer/ . image001.jpgimage002.jpg
[Axapta-Knowledge-Village] Misc charges in intercompany
Hi everyone I wanted to check if I setup intercompany and put misc charges on the original document (e.g. Sales Order) then does AX require/force the misc charge to be created the same on the corresponding document? I wanted to do: 1) SO price 10 with misc charge of 10% (so 10.10) 2) PO created via intercompany with price of 10.10 (no misc charge) I thought this would be possible since I can control the price on both SO and PO does not have to be the same but it seems no matter what I try the misc charge on the original SO is ALWAYS created on the PO Thanks James
[Axapta-Knowledge-Village] RE: Misc charges in intercompany
Also can anyone explain what is the ‘Intercompany Percent’ option in the misc code setup? Thanks once again James From: James Flavell [mailto:djf1...@gmail.com] Sent: 25 March 2010 00:10 To: 'Axapta-Knowledge-Village@yahoogroups.com' Subject: Misc charges in intercompany Hi everyone I wanted to check if I setup intercompany and put misc charges on the original document (e.g. Sales Order) then does AX require/force the misc charge to be created the same on the corresponding document? I wanted to do: 1) SO price 10 with misc charge of 10% (so 10.10) 2) PO created via intercompany with price of 10.10 (no misc charge) I thought this would be possible since I can control the price on both SO and PO does not have to be the same but it seems no matter what I try the misc charge on the original SO is ALWAYS created on the PO Thanks James
RE: [Axapta-Knowledge-Village] New Fields on Purchase Tab of Inventory Posting Profiles
I think the bottom ones are referring to the 'revenue' side of the Purchase order. I did ask someone to test for me and they could not get the revenue ones to be any different to the top ones (stock ones)..even if did things like std cost, misc charge that is charged to vendor but not item. One I did not try is whether on the model group if you set the new field about making the incoming purchase to be as per std cost (but it is not std cost model) so maybe want to test it out with that So not sure if these are of use only in certain countries/configuration or just added to make it consistent with Sales order side (whereby maybe some finance ppl want 4 entries at purchase packing slip posting for some reason) and for sure I would like to know too Thanks James From: Axapta-Knowledge-Village@yahoogroups.com [mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of george_spl Sent: 18 February 2010 12:31 To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] New Fields on Purchase Tab of Inventory Posting Profiles Has anyone started to use new Fields on Purchase Tab of Inventory Posting Profiles : * Packing Slip Purchase * Packing Slip Purchase Offset * Packing Slip Tax Not to be confused with the other two fields at the top, * Packing Slip * Packing Slip Offset TIA George image001.jpgimage002.jpg
[Axapta-Knowledge-Village] AX access rights permission is done by object ID?
Hi everyone just wanted to check is the AX permissions having functionality linked to the AOT object ID? Example: Live appl report A has object ID 500 Test appl report A has object ID 600 If I take a copy of the live Db and put it into test will the permissions for report A be all correct? The reason I ask is it seems there are differences between the Live and Test permissions setup in our environment for some reason This is for Ax3.0 (although I don't think there has been any change in this area even in AX2009) Thanks James
RE: [Axapta-Knowledge-Village] Axapta gets hanged !!!
There can be many issues so you need to provide as much detail as possible (server and SQL DB specs plus idea of the CPU/disk load when things hang. Also AX kernel and application versions). It might be a certain operation a user does starts a large SQL and that then slows everybody else down. Do you have a partner who can help check the MS knowledge base and advise on possible issues, this is the normally the best way to solve this kind of problem as it can be very hard or even impossible to trouble shoot remotely But do take note from what I can remember there was one hotfix by MS dealing with slow down when many users are login to AX at the same time (sorry I cannot remember much more than that but believe it was for AX2009) From: Axapta-Knowledge-Village@yahoogroups.com [mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of Anitha S Sent: 21 January 2010 16:02 To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Axapta gets hanged !!! Hi, We are facing this critical problem. We have implemeted Ax2009 and almost 40 users are accessing the AOS simulataneously from various locations. The problem here is Axapta application is getting hanged when user sessions increases. Even opening a form hangs the application.This creates lot of issues and inconvenience for the users as they are unable to proceed with their day to day activities. This is happening even when the objects are accessed from the server directly. We stopped and started the service. Still no use. Is this because of bulk data or concurrent users or other issue?? It would be a great help if someone can help us in this regard. Regards, Anitha. image001.jpgimage002.jpg
RE: [Axapta-Knowledge-Village] Axapta gets hanged !!!
Sorry just to clarify You mean when you compile a single AOT object then every goes slow (even if say there are only 2 users on the system)? Are there other situations where the it goes slow not related to doing anything in the AOT? The hotfix I vaguely remember seeing was slowness caused when lots of ax user were logging in so nothing related to specific AOT or compile (I believe it was pre RU3 so it is most likely included in this) Thanks James From: Axapta-Knowledge-Village@yahoogroups.com [mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of Anitha S Sent: 21 January 2010 17:59 To: Axapta-Knowledge-Village@yahoogroups.com Subject: Re: [Axapta-Knowledge-Village] Axapta gets hanged !!! Hi James, Here are the details. Kernel Version : 5.0.1000.52 Application Version : 5.0.1001.96 We are using SQL server 2005 SP2. AOS and SQL server are in different machines. Even when any of the AOT object iscompiled, the application goes to Not Responding Status. And I guess,it is affecting AIF also . Because when I import XML , I am getting message the There is no schema for this parameter. Please configure the data policies first .When i click the Data Policies button in End Points form, the system again goes to Not Responding mode. And this settles down when the service is restarted. Is this related to the above mentioned issue? As you had mentioned, I dont think a large SQL operation could have caused this because Compiling an AOT object does not make a database call. We are trying with RU3 pack which is related to Performance/Application Crash. Kindly mail me your suggestions. Regards, Anitha. On Thu, Jan 21, 2010 at 1:56 PM, James Flavell djf1...@gmail.com wrote: There can be many issues so you need to provide as much detail as possible (server and SQL DB specs plus idea of the CPU/disk load when things hang. Also AX kernel and application versions). It might be a certain operation a user does starts a large SQL and that then slows everybody else down. Do you have a partner who can help check the MS knowledge base and advise on possible issues, this is the normally the best way to solve this kind of problem as it can be very hard or even impossible to trouble shoot remotely But do take note from what I can remember there was one hotfix by MS dealing with slow down when many users are login to AX at the same time (sorry I cannot remember much more than that but believe it was for AX2009) From: Axapta-Knowledge-Village@yahoogroups.com [mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of Anitha S Sent: 21 January 2010 16:02 To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Axapta gets hanged !!! Hi, We are facing this critical problem. We have implemeted Ax2009 and almost 40 users are accessing the AOS simulataneously from various locations. The problem here is Axapta application is getting hanged when user sessions increases. Even opening a form hangs the application.This creates lot of issues and inconvenience for the users as they are unable to proceed with their day to day activities. This is happening even when the objects are accessed from the server directly. We stopped and started the service. Still no use. Is this because of bulk data or concurrent users or other issue?? It would be a great help if someone can help us in this regard. Regards, Anitha. image001.jpgimage002.jpg
RE: [Axapta-Knowledge-Village] Axapta gets hanged !!!
Still not clear the issue happens only when you are doing things in the AOT or also when nothing at all is done in the AOT (regardless of the instance)? Example: 2 users login and begin to do their daily work of oopen customer forma nd sales order etc. Does the system slow down? Is there anything in the event logs of the OS at all? From: Axapta-Knowledge-Village@yahoogroups.com [mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of Anitha S Sent: 21 January 2010 19:31 To: Axapta-Knowledge-Village@yahoogroups.com Subject: Re: [Axapta-Knowledge-Village] Axapta gets hanged !!! James, We are using 2 Instances. One is Test and Production. Amount of Data in test Instance is same like in Prod.(might be around less15% of data than prod). Test instance is used by limited number of users. But after we started using Production instance , we see the Test instance has also slowed down.Be it compilation or posting an invoice ., nothing works.System goes to Not Responding mode. Coming to your question: I had a doubt that our customization could be a reason for hanging problem. To confirm that, I compiled few objets in AOT. Now I m clear that customization is no way related to this issue. Whatever operation we do in Ax, it goes hanging mode. As Mahmoud said, it might be because of SQL Server dynamic memory management problem since both test and production instances are using same the SQL server machine with different DBs and our OS is also x64.We are working on that. Meanwhile any other ideas or suggestion will be appreciated. Regards, Anitha. On Thu, Jan 21, 2010 at 4:11 PM, James Flavell djf1...@gmail.com wrote: Sorry just to clarify You mean when you compile a single AOT object then every goes slow (even if say there are only 2 users on the system)? Are there other situations where the it goes slow not related to doing anything in the AOT? The hotfix I vaguely remember seeing was slowness caused when lots of ax user were logging in so nothing related to specific AOT or compile (I believe it was pre RU3 so it is most likely included in this) Thanks James From: Axapta-Knowledge-Village@yahoogroups.com [mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of Anitha S Sent: 21 January 2010 17:59 To: Axapta-Knowledge-Village@yahoogroups.com Subject: Re: [Axapta-Knowledge-Village] Axapta gets hanged !!! Hi James, Here are the details. Kernel Version : 5.0.1000.52 Application Version : 5.0.1001.96 We are using SQL server 2005 SP2. AOS and SQL server are in different machines. Even when any of the AOT object iscompiled, the application goes to Not Responding Status. And I guess,it is affecting AIF also . Because when I import XML , I am getting message the There is no schema for this parameter. Please configure the data policies first .When i click the Data Policies button in End Points form, the system again goes to Not Responding mode. And this settles down when the service is restarted. Is this related to the above mentioned issue? As you had mentioned, I dont think a large SQL operation could have caused this because Compiling an AOT object does not make a database call. We are trying with RU3 pack which is related to Performance/Application Crash. Kindly mail me your suggestions. Regards, Anitha. On Thu, Jan 21, 2010 at 1:56 PM, James Flavell djf1...@gmail.com wrote: There can be many issues so you need to provide as much detail as possible (server and SQL DB specs plus idea of the CPU/disk load when things hang. Also AX kernel and application versions). It might be a certain operation a user does starts a large SQL and that then slows everybody else down. Do you have a partner who can help check the MS knowledge base and advise on possible issues, this is the normally the best way to solve this kind of problem as it can be very hard or even impossible to trouble shoot remotely But do take note from what I can remember there was one hotfix by MS dealing with slow down when many users are login to AX at the same time (sorry I cannot remember much more than that but believe it was for AX2009) From: Axapta-Knowledge-Village@yahoogroups.com [mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of Anitha S Sent: 21 January 2010 16:02 To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Axapta gets hanged !!! Hi, We are facing this critical problem. We have implemeted Ax2009 and almost 40 users are accessing the AOS simulataneously from various locations. The problem here is Axapta application is getting hanged when user sessions increases. Even opening a form hangs the application.This creates lot of issues and inconvenience for the users as they are unable to proceed with their day to day activities. This is happening even when the objects are accessed from the server directly. We
RE: [Axapta-Knowledge-Village] Re: Axapta gets hanged !!!
I think this SysUtilElementsLog was related to the hotfix I saw and the fix about switching to temp table was mentioned (disclaimer: this is all from my memory banks which are getting older and more prone to errors!) I would give what Navid says a try since it is easy to make the change (although not sure you have catch 22 that when you try to change system already hang ;) ) Sorry I cannot look for the hotfix now as its 10pm and I am trying to clear 101 things before I then pack my bag to go travel overseas to a customer site tmr From: Axapta-Knowledge-Village@yahoogroups.com [mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of Navid Sent: 21 January 2010 21:19 To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Re: Axapta gets hanged !!! Hi Anitha, We also had a similar issue when we migrated to Dynamics AX 2009. Our problem was caused by Dynamics logging every item(Form/Report/Table) that is being used by any user. The table SysUtilElementsLog was having locks So we made the table SysUtilElementsLog as temporary and this solved the problem. Please have a look at the SQL Acticity and if this is the case try making the table as temporary. This will stop logging the usage in database and any existing data will also be wiped out. Please try this in your test system before doing it in Production. Hope this will help Navid --- In Axapta-Knowledge-Village@yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com , Anitha S mail2eani...@... wrote: Yes James.. System gets hanged when the user access the forms also : like posting an invoice, payment etc., I could see only this message in event log : Terminating the session . When the system goes to Not Responding mode, we forcibly close the application. Regards, Anitha On Thu, Jan 21, 2010 at 5:05 PM, James Flavell djf1...@... wrote: Still not clear the issue happens only when you are doing things in the AOT or also when nothing at all is done in the AOT (regardless of the instance)? Example: 2 users login and begin to do their daily work of oopen customer forma nd sales order etc. Does the system slow down? Is there anything in the event logs of the OS at all? *From:* Axapta-Knowledge-Village@yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com [mailto: Axapta-Knowledge-Village@yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com ] *On Behalf Of *Anitha S *Sent:* 21 January 2010 19:31 *To:* Axapta-Knowledge-Village@yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com *Subject:* Re: [Axapta-Knowledge-Village] Axapta gets hanged !!! James, We are using 2 Instances. One is Test and Production. Amount of Data in test Instance is same like in Prod.(might be around * less15*% of data than prod). Test instance is used by limited number of users. But after we started using Production instance , we see the Test instance has also slowed down.Be it compilation or posting an invoice ., nothing works.System goes to Not Responding mode. Coming to your question: I had a doubt that our customization could be a reason for hanging problem. To confirm that, I compiled few objets in AOT. Now I m clear that customization is no way related to this issue. Whatever operation we do in Ax, it goes hanging mode. As Mahmoud said, it might be because of SQL Server dynamic memory management problem since both test and production instances are using same the SQL server machine with different DBs and our OS is also x64.We are working on that. Meanwhile any other ideas or suggestion will be appreciated. Regards, Anitha. On Thu, Jan 21, 2010 at 4:11 PM, James Flavell djf1...@... wrote: Sorry just to clarify You mean when you compile a single AOT object then every goes slow (even if say there are only 2 users on the system)? Are there other situations where the it goes slow not related to doing anything in the AOT? The hotfix I vaguely remember seeing was slowness caused when lots of ax user were logging in so nothing related to specific AOT or compile (I believe it was pre RU3 so it is most likely included in this) Thanks James *From:* Axapta-Knowledge-Village@yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com [mailto: Axapta-Knowledge-Village@yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com ] *On Behalf Of *Anitha S *Sent:* 21 January 2010 17:59 *To:* Axapta-Knowledge-Village@yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com *Subject:* Re: [Axapta-Knowledge-Village] Axapta gets hanged !!! Hi James, Here are the details. *Kernel Version* : 5.0.1000.52 *Application Version* : 5.0.1001.96 We are using *SQL server 2005 SP2*. AOS and SQL server are in *different
RE: [Axapta-Knowledge-Village] Re: Axapta gets hanged !!!
Just to update that what Navid talked about is KB 959598 and this is the one I was also referring to. Are you a partner? If so go get the article: https://mbs.microsoft.com/knowledgebase/kbdisplay.aspx?wtntzsmnwukntmmyxupyz qpouxnxspsymmtyvwnzmxqlwyxs If you are a customer go ask your partner to look it up and talk to you (sorry its confidential and so I cannot just give it to you or I may get in trouble with MS). Basically the solution is as per Navid said to change to temp table (AOT object usage is not logged any more - this usage data in theory is useful in an upgrade to help you know objects that have a conflict whether they are ever used by users - that's at least how I understand what it is used for) or apply a hotfix MS issued (is included in RU2) Let us know how things turn out Thanks James From: Axapta-Knowledge-Village@yahoogroups.com [mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of Navid Sent: 21 January 2010 21:19 To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Re: Axapta gets hanged !!! Hi Anitha, We also had a similar issue when we migrated to Dynamics AX 2009. Our problem was caused by Dynamics logging every item(Form/Report/Table) that is being used by any user. The table SysUtilElementsLog was having locks So we made the table SysUtilElementsLog as temporary and this solved the problem. Please have a look at the SQL Acticity and if this is the case try making the table as temporary. This will stop logging the usage in database and any existing data will also be wiped out. Please try this in your test system before doing it in Production. Hope this will help Navid --- In Axapta-Knowledge-Village@yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com , Anitha S mail2eani...@... wrote: Yes James.. System gets hanged when the user access the forms also : like posting an invoice, payment etc., I could see only this message in event log : Terminating the session . When the system goes to Not Responding mode, we forcibly close the application. Regards, Anitha On Thu, Jan 21, 2010 at 5:05 PM, James Flavell djf1...@... wrote: Still not clear the issue happens only when you are doing things in the AOT or also when nothing at all is done in the AOT (regardless of the instance)? Example: 2 users login and begin to do their daily work of oopen customer forma nd sales order etc. Does the system slow down? Is there anything in the event logs of the OS at all? *From:* Axapta-Knowledge-Village@yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com [mailto: Axapta-Knowledge-Village@yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com ] *On Behalf Of *Anitha S *Sent:* 21 January 2010 19:31 *To:* Axapta-Knowledge-Village@yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com *Subject:* Re: [Axapta-Knowledge-Village] Axapta gets hanged !!! James, We are using 2 Instances. One is Test and Production. Amount of Data in test Instance is same like in Prod.(might be around * less15*% of data than prod). Test instance is used by limited number of users. But after we started using Production instance , we see the Test instance has also slowed down.Be it compilation or posting an invoice ., nothing works.System goes to Not Responding mode. Coming to your question: I had a doubt that our customization could be a reason for hanging problem. To confirm that, I compiled few objets in AOT. Now I m clear that customization is no way related to this issue. Whatever operation we do in Ax, it goes hanging mode. As Mahmoud said, it might be because of SQL Server dynamic memory management problem since both test and production instances are using same the SQL server machine with different DBs and our OS is also x64.We are working on that. Meanwhile any other ideas or suggestion will be appreciated. Regards, Anitha. On Thu, Jan 21, 2010 at 4:11 PM, James Flavell djf1...@... wrote: Sorry just to clarify You mean when you compile a single AOT object then every goes slow (even if say there are only 2 users on the system)? Are there other situations where the it goes slow not related to doing anything in the AOT? The hotfix I vaguely remember seeing was slowness caused when lots of ax user were logging in so nothing related to specific AOT or compile (I believe it was pre RU3 so it is most likely included in this) Thanks James *From:* Axapta-Knowledge-Village@yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com [mailto: Axapta-Knowledge-Village@yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com ] *On Behalf Of *Anitha S *Sent:* 21 January 2010 17:59 *To:* Axapta-Knowledge-Village@yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com
RE: [Axapta-Knowledge-Village] AOD modified date
Thanks all Just to update you MS came back and said in AX3.0 a aoi regenerate causes modified date on aod files to change . but in AX4.0 and Ax2009 it does not. Thanks James From: Axapta-Knowledge-Village@yahoogroups.com [mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of Mike Matta Sent: 17 December 2009 22:25 To: axapta-knowledge-village@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] AOD modified date We have noticed that the .aod file date modified gets changed when restarting the AOS's - after having modified label files. _ To: Axapta-Knowledge-Village@yahoogroups.com From: djf1...@gmail.com Date: Thu, 17 Dec 2009 21:27:53 +0800 Subject: Re: [Axapta-Knowledge-Village] AOD modified date Thanks Jens Your info is very helpful :) The environment I got this on was AX3.0 SP2 2 Tier so I think I will try a few more tests to see if I can reproduce it Also I usually do not delete udb so maybe I will try with and without deleting this file also One final thing is your 2T client on a Terminal Server box or a stand alone PC? Just another factor that might somehow have an influence Thanks again and will let you know James On Dec 17, 2009, at 7:44 PM, j...@strandbergs.dk wrote: James, Very strange. When I shut down our AOS'es (2 of them), I would afterwards delete the .aoi file and also the .udb file. Then, after restart of Ax in 2 tier mode the .aoi file gets rebuild, as you know. In my installations (live, test and dev) the .aod files are getting re-dated... I actually thought this was the normal behaviour, although it seems strange that a file has it's date changed just by reading it. /Jens Sorry Jens but I tested and cannot get the aod file date or time to change with an aoi rebuild Can you explain how you can get it to affect the aod file Thanks James From: mailto:Axapta-Knowledge-Village@yahoogroups.com Axapta-Knowledge-Village@yahoogroups.com [mailto: mailto:Axapta-Knowledge-Village@yahoogroups.com axapta-knowledge-vill...@yahoogroups.com] On Behalf Of mailto:j...@strandbergs.dk j...@strandbergs.dk Sent: 15 December 2009 18:53 To: mailto:Axapta-Knowledge-Village@yahoogroups.com Axapta-Knowledge-Village@yahoogroups.com Subject: Re: [Axapta-Knowledge-Village] AOD modified date James, When you delete the .aoi file, this will be rebuilt - and all .aod files will have a new date. /Jens Our auditor requires to know when are the AOD files updated by AX. Is it only when a change is made in the corresponding layer in an AOT object or are there other situations? If an object exists in both VAR and USR, if it is modified in USR can the VAR aod file in anyway be affected? If aoi is rebuilt can this affect? If cross reference is updated can this affect? The reason is the VAR aod file has strange dates that cannot be explained (since we did not do any changes in the VAR layer since a certain date) and so the auditor wants to know the situations of how AX can modify it Is there any way we can filter or see if there is any object in the VAR layer that has a created or modified date after a certain date? Thanks James image001.jpgimage002.jpg
RE: [Axapta-Knowledge-Village] AOD modified date
Sorry Jens but I tested and cannot get the aod file date or time to change with an aoi rebuild Can you explain how you can get it to affect the aod file Thanks James From: Axapta-Knowledge-Village@yahoogroups.com [mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of j...@strandbergs.dk Sent: 15 December 2009 18:53 To: Axapta-Knowledge-Village@yahoogroups.com Subject: Re: [Axapta-Knowledge-Village] AOD modified date James, When you delete the .aoi file, this will be rebuilt - and all .aod files will have a new date. /Jens Our auditor requires to know when are the AOD files updated by AX. Is it only when a change is made in the corresponding layer in an AOT object or are there other situations? If an object exists in both VAR and USR, if it is modified in USR can the VAR aod file in anyway be affected? If aoi is rebuilt can this affect? If cross reference is updated can this affect? The reason is the VAR aod file has strange dates that cannot be explained (since we did not do any changes in the VAR layer since a certain date) and so the auditor wants to know the situations of how AX can modify it Is there any way we can filter or see if there is any object in the VAR layer that has a created or modified date after a certain date? Thanks James image001.jpgimage002.jpg
Re: [Axapta-Knowledge-Village] AOD modified date
Thanks Jens Your info is very helpful :) The environment I got this on was AX3.0 SP2 2 Tier so I think I will try a few more tests to see if I can reproduce it Also I usually do not delete udb so maybe I will try with and without deleting this file also One final thing is your 2T client on a Terminal Server box or a stand alone PC? Just another factor that might somehow have an influence Thanks again and will let you know James On Dec 17, 2009, at 7:44 PM, j...@strandbergs.dk wrote: James, Very strange. When I shut down our AOS'es (2 of them), I would afterwards delete the .aoi file and also the .udb file. Then, after restart of Ax in 2 tier mode the .aoi file gets rebuild, as you know. In my installations (live, test and dev) the .aod files are getting re-dated... I actually thought this was the normal behaviour, although it seems strange that a file has it's date changed just by reading it. /Jens Sorry Jens but I tested and cannot get the aod file date or time to change with an aoi rebuild Can you explain how you can get it to affect the aod file Thanks James From: Axapta-Knowledge-Village@yahoogroups.com [mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of j...@strandbergs.dk Sent: 15 December 2009 18:53 To: Axapta-Knowledge-Village@yahoogroups.com Subject: Re: [Axapta-Knowledge-Village] AOD modified date James, When you delete the .aoi file, this will be rebuilt - and all .aod files will have a new date. /Jens Our auditor requires to know when are the AOD files updated by AX. Is it only when a change is made in the corresponding layer in an AOT object or are there other situations? If an object exists in both VAR and USR, if it is modified in USR can the VAR aod file in anyway be affected? If aoi is rebuilt can this affect? If cross reference is updated can this affect? The reason is the VAR aod file has strange dates that cannot be explained (since we did not do any changes in the VAR layer since a certain date) and so the auditor wants to know the situations of how AX can modify it Is there any way we can filter or see if there is any object in the VAR layer that has a created or modified date after a certain date? Thanks James
RE: [Axapta-Knowledge-Village] AOD modified date
Thanks Mike Just to clarify when you say modify is that from within AX label editor or direct to the ald file? Thanks again Jens and Mike for your invaluable input J From: Axapta-Knowledge-Village@yahoogroups.com [mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of Mike Matta Sent: 17 December 2009 22:25 To: axapta-knowledge-village@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] AOD modified date We have noticed that the .aod file date modified gets changed when restarting the AOS's - after having modified label files. _ To: Axapta-Knowledge-Village@yahoogroups.com From: djf1...@gmail.com Date: Thu, 17 Dec 2009 21:27:53 +0800 Subject: Re: [Axapta-Knowledge-Village] AOD modified date Thanks Jens Your info is very helpful :) The environment I got this on was AX3.0 SP2 2 Tier so I think I will try a few more tests to see if I can reproduce it Also I usually do not delete udb so maybe I will try with and without deleting this file also One final thing is your 2T client on a Terminal Server box or a stand alone PC? Just another factor that might somehow have an influence Thanks again and will let you know James On Dec 17, 2009, at 7:44 PM, j...@strandbergs.dk wrote: James, Very strange. When I shut down our AOS'es (2 of them), I would afterwards delete the .aoi file and also the .udb file. Then, after restart of Ax in 2 tier mode the .aoi file gets rebuild, as you know. In my installations (live, test and dev) the .aod files are getting re-dated... I actually thought this was the normal behaviour, although it seems strange that a file has it's date changed just by reading it. /Jens Sorry Jens but I tested and cannot get the aod file date or time to change with an aoi rebuild Can you explain how you can get it to affect the aod file Thanks James From: mailto:Axapta-Knowledge-Village@yahoogroups.com Axapta-Knowledge-Village@yahoogroups.com [mailto: mailto:Axapta-Knowledge-Village@yahoogroups.com axapta-knowledge-vill...@yahoogroups.com] On Behalf Of mailto:j...@strandbergs.dk j...@strandbergs.dk Sent: 15 December 2009 18:53 To: mailto:Axapta-Knowledge-Village@yahoogroups.com Axapta-Knowledge-Village@yahoogroups.com Subject: Re: [Axapta-Knowledge-Village] AOD modified date James, When you delete the .aoi file, this will be rebuilt - and all .aod files will have a new date. /Jens Our auditor requires to know when are the AOD files updated by AX. Is it only when a change is made in the corresponding layer in an AOT object or are there other situations? If an object exists in both VAR and USR, if it is modified in USR can the VAR aod file in anyway be affected? If aoi is rebuilt can this affect? If cross reference is updated can this affect? The reason is the VAR aod file has strange dates that cannot be explained (since we did not do any changes in the VAR layer since a certain date) and so the auditor wants to know the situations of how AX can modify it Is there any way we can filter or see if there is any object in the VAR layer that has a created or modified date after a certain date? Thanks James image001.jpgimage002.jpg
RE: [Axapta-Knowledge-Village] Regarding Quarantine orders
I h ave seen errors in Q order linked to Return Orders and Arrivals Please test on the return order set the imventdims as you want (e.g. batch and location) so that you do not need to change any of them in the arrival journal or Q order. The error I had is because in at least 2 places the code uses the inventdim values on the return order line to search for inventtrans (my problem was in the split function but your error sounds like it might come from the same mistake) Maybe you can give the example (paying very close attention to the inventdim values on all the inventtrans involved as well as on inventdim on all the source lines - return order line, arrival journa, Q order) I have submitted error report to MS on this but as of yet they have not responded. Thanks James From: Axapta-Knowledge-Village@yahoogroups.com [mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of Sanam Khan Sent: 14 December 2009 16:12 To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Regarding Quarantine orders Dear All I am facing problem in quarantine orders. From sales return order the quality order has been created and we have updated its status to Report as Finished but when I try to End it then it generates the Error insufficient inventory Transaction with status Received Any help would be highly appreciated. Regards, Sanam Khan __ Information from ESET NOD32 Antivirus, version of virus signature database 4684 (20091213) __ The message was checked by ESET NOD32 Antivirus. http://www.eset.com __ Information from ESET NOD32 Antivirus, version of virus signature database 4684 (20091213) __ The message was checked by ESET NOD32 Antivirus. http://www.eset.com image001.jpgimage002.jpg
[Axapta-Knowledge-Village] AOD modified date
Our auditor requires to know when are the AOD files updated by AX. Is it only when a change is made in the corresponding layer in an AOT object or are there other situations? If an object exists in both VAR and USR, if it is modified in USR can the VAR aod file in anyway be affected? If aoi is rebuilt can this affect? If cross reference is updated can this affect? The reason is the VAR aod file has strange dates that cannot be explained (since we did not do any changes in the VAR layer since a certain date) and so the auditor wants to know the situations of how AX can modify it Is there any way we can filter or see if there is any object in the VAR layer that has a created or modified date after a certain date? Thanks James
[Axapta-Knowledge-Village] Logic for put away of items to locations
Can anyone help answer some WMS queries to save me basing my head on the wall. Using arrival journal if I want AX to pick the location to store an item what is the logic used when no Pallet transports are used. My understanding: 'Checking picking locations' field on arrival journal means check the picking location on the item's warehouse setup first. If there is space there then use that and put away logic considered complete. If not enough space then continue with the put away logic (see below). Enough space is calculated how (again bearing in mind not using pallets)? 'Check bulk locations' on arrival journal can only be used with pallet transports otherwise I get an error message. Does that mean put away to bulk locations can only be done when using pallet transports (what if I have a bulk location in my store zone will it be ignored when not using pallet?) Store zones - order of locations in warehouse to search (but does put away logic care about the type of location or just will take any location that is in the store zone?) So logic for put away is to search through all locations in store zone of the item and find first location that has enough space. If not enough space in one single location will AX suggest to split into 2 locations? If all locations in store zones full what will happen, will AX look in the items picking location? Look forward to some clarification Thanks James
[Axapta-Knowledge-Village] Go through projects and export created date of obecjts
Has anybody done coding to go through all the projects in an AOT and print a report of the objects in the project with their created and modified date and user info? Something like an audit log on objects done by project basis? If so would appreciate some points as to how to do such coding Thanks James
RE: [Axapta-Knowledge-Village] Go through projects and export created date of obecjts
Thanks, Not being a true programmer I cannot really follow the code you have put. Is this code going through the complete AOT or maybe can explain so I can better understand. Is there any tutorial jobs/classes or std objects in AX for this kind of thing that I can learn more from? Thanks James From: Axapta-Knowledge-Village@yahoogroups.com [mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of pradeep itnal Sent: 30 November 2009 15:16 To: Axapta-Knowledge-Village@yahoogroups.com Subject: Re: [Axapta-Knowledge-Village] Go through projects and export created date of obecjts hi James there are many system clasees available .. from which you can access the objects in aot For example TreeNode classnode = TreeNode::findNode(#SystemClassesPath+'\\'+classstr(xRecord)); TreeNode childnode = classnode.AOTfirstChild(); DictMethod dictMethod; setprefix(classnode.treeNodeName()); while (childnode) { setprefix(childnode.treeNodeName()); dictMethod = new DictMethod(UtilElementType::ClassInstanceMethod,classnum(xRecord),childnode.treeNodeName()); info(strfmt('%1', dictMethod.runMode())); childnode = childnode.AOTnextSibling(); } 1. You can develop a recursive program, which will iterate thru each of Private and sheraed projects. 2.copy the details of objects user modified date and time of the user into a temporary table. 3. create a report and print them Basically u need a class where u put ur business logic which will list the objects in your project, 2nd u need a temporary table to store intermediate info and a report to show up the results. hope it helps. Thanks Regards Pradeep S.Itnal mob:+91-9886529409 --- On Mon, 30/11/09, James Flavell djf1...@gmail.com wrote: From: James Flavell djf1...@gmail.com Subject: [Axapta-Knowledge-Village] Go through projects and export created date of obecjts To: Axapta-Knowledge-Village@yahoogroups.com Date: Monday, 30 November, 2009, 10:16 AM Has anybody done coding to go through all the projects in an AOT and print a report of the objects in the project with their created and modified date and user info? Something like an audit log on objects done by project basis? If so would appreciate some points as to how to do such coding Thanks James _ The INTERNET now has a personality. YOURS! See http://in.rd.yahoo.com/tagline_yyi_1/*http:/in.yahoo.com/ your Yahoo! Homepage.
[Axapta-Knowledge-Village] AX data purge/archive
I think someone asked a while ago about purge/archive tools for AX. At the time I was not able to find the info but now have the info except I cannot find the original email with the query. So to whoever asked the only attempt I know is: http://www.ignify.com/DynamicsAXData.asp I have not looked into the product (and can imagine a few limitations from reading the web site info) but hope this is of use Thanks James
[Axapta-Knowledge-Village] Cross reference in Shipment templates not always working
Has anyone had experience of trying to use cross reference in shipment templates and it does not work properly? I am trying to setup a template criteria with cross reference to customer master but the it is not working the way it should (i.e. output orders with criteria that do not match are including in the shipment) This is happening in both AX2009 and Ax3.0 Thanks James
RE: [Axapta-Knowledge-Village] Re: Inter company does not work for Config/Size/Color?
Thanks everyone SO/PO is working with dimensions Item creation (with dimensions) in multiple companies I think will need some modification Thanks again J James From: Axapta-Knowledge-Village@yahoogroups.com [mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of First L Sent: 14 November 2009 15:22 To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Re: Inter company does not work for Config/Size/Color? Hi Enter the relevant description in the Name field in the item dimension combination form in the respective company. Hope this will solve your problem. Regards CTV --- In Axapta-Knowledge-Village@yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com , dipankar pauldipanka...@... wrote: Hi James Yes there is no value mapping for the invetory dimission. Bcoz the description of the item may be differnet in nature of treatment in different compnay. In stander Ax there is no future in Inventory Dimenstion like Config/Size/Color. Like u i am also facing similer problem TR DP --- In Axapta-Knowledge-Village@yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com , James Flavell djf1994@ wrote: Hi everyone just wanted to double double check It seems Config/Size/Color does not work with intercompany functionality can anyone confirm this and anyone attempted to 'fix' this? Thanks James
RE: [Axapta-Knowledge-Village] Intercompany
Hi BayaNet Can I ask what is the importance of 'credit correction' in this situation. If I do not tick it what is the difference? Thanks James From: Axapta-Knowledge-Village@yahoogroups.com [mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of abdelrhman elkady Sent: 17 November 2009 14:00 To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Intercompany you can make a credit note for the sales order and make sure to mark the check box credit correction while posting the credit note, now the order is open order you can delet it or update it with the right values and reprocess it try to make virtiual company tables for the common tables between the two companis, also use the defult item setting for the units of messures, this will lead to minimize those issues. Regards, BayaNet Abdelrhman El-Kady, Professional Services Specialist 13 Ahmed Orabi St., Mohandessin 002 012 181 5675 arah...@bayanet.net http://www.bayanet.net Please consider your environmental responsibility before printing this e-mail
[Axapta-Knowledge-Village] Ax3.0 SP6 Physical Value error
Hi everyone I have another urgent problem that I hope someone might be able to shine some light on We have AX3.0 SP6 with DIS/DIP for Norway The Inventory physical report that has a column showing Physical Posted is giving wrong values if we back date the report. Things we found: 1) If we run it on today's date the values are correct but if we run with a date in the past then the values are wrong. 2) If we have not run any closing (i.e. no settlements) then back dated report seems to be okay so it seems it is related to the settlements Has anyone had similar problem or know of any fix that might exist? Or does anyone have Ax3.0 SP6 and this column is working fine? Appreciate any help can get on this before the auditors turn up. Thanks James
[Axapta-Knowledge-Village] Inter company does not work for Config/Size/Color?
Hi everyone just wanted to double double check It seems Config/Size/Color does not work with intercompany functionality can anyone confirm this and anyone attempted to 'fix' this? Thanks James
[Axapta-Knowledge-Village] AX2009 does not like W2008 x64
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 ..!!!??? Thanks James
RE: [Axapta-Knowledge-Village] Re: Find a record in the Report
Mmm how about they print to Text or PDF and then do a 'Find' in notepad or PDf reader? Correct me if I am wrong but the global search will just tell you which record it finds that matches in the raw data but is in no way related/referencing the report that has been printed. So VG you might have to clarify they are looking for where in a report a particular reference appears or they just wanted to find if a certain reference exists in certain data? From: Axapta-Knowledge-Village@yahoogroups.com [mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of r_ssh Sent: 29 October 2009 17:57 To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Re: Find a record in the Report Hi VG, May be you can use the global search feature in Dynamics AX. In this you can configure the table name(In the report datasource find the tables which are used.) Setup only these tables for Global Search. In case you dont have idea on How to setup Global Search in AX please refer my blog entry http://sangi1983.spaces.live.com/blog/cns!264A0056CBCBB1D3!198.entry Thanks Santosh.R --- In Axapta-Knowledge-Village@yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com , V G learnaxa...@... wrote: Hi All I wanted to know if there is a functionality in AX wherein we can search a entry in a Axapta report What client wants is to search a entry in report as the report is usually too long 20-30 pages. All ideas welcome. Thanks in advance Thanks VG image001.jpgimage002.jpg
[Axapta-Knowledge-Village] GLS or RU3 cahnges SYS or other system layers?
Good afternoon Can anyone advise if the GLS or Hotfix RU3 install exe files update the SYS layer? I read on the web site for SP1 (and also I thought for GLS or RU3 but cannot seem to find now) that it updates the SYS but not sure if that is just some incorrect information on the web site..see: https://mbs.microsoft.com/customersource/downloads/servicepacks/dynamicsax20 09sp1 Other key highlights in this service pack release include: * The SP1 installer updates both the SYS and GLS layers of the product. This means, for example, that if you already have GLS-TR installed on your system, SP1 will update this layer during the installation process. I assumed the above meant SYP or GLP was updated but now I am a little unsure because I always thought SYS was off limits to everyone and only a new version made changes but a binary file compare of a SYS aod from the install DVD compared to after GLS and RU3 being applied shows a different file size and content. Can this change in SYS aod be due to a full compile of the AX application? Would appreciate any help on being sure whether SYS aod file is the same even though the compare shows a difference Thanks James
[Axapta-Knowledge-Village] RE: GLS or RU3 cahnges SYS or other system layers?
Sorry slight correction/edit to my earlier post. I found the original web page that got me really concerned (sorry it was not the SP1 web page but search partner source or customer source for Hotfix rollup 3 (974407) is available for Microsoft Dynamics AX 2009) The below statement is what got me concerned: The rollup package contains both a cumulative kernel update and a cumulative application update. Although there is no dependency between these two updates, we recommend that you install both of the updates together. The rollup will be installed on the SYP layer and the GLP layer. Additionally, this rollup will update the SYS layer and the GLS layer that are installed on the system It clearly says here SYS and GLS will be updated!!! Any ideas why/what? So I think SP1 does not touch SYS or GLS (sorry for scaring anyone) but it would seem the RU3 does (I really don't understand why since XXP layers are supposed to be exactly for the reason of patching so why is there a need to change the original layer) Thanks James From: James Flavell [mailto:djf1...@gmail.com] Sent: 27 October 2009 16:36 To: 'Axapta-Knowledge-Village@yahoogroups.com' Subject: GLS or RU3 cahnges SYS or other system layers? Good afternoon Can anyone advise if the GLS or Hotfix RU3 install exe files update the SYS layer? I read on the web site for SP1 (and also I thought for GLS or RU3 but cannot seem to find now) that it updates the SYS but not sure if that is just some incorrect information on the web site..see: https://mbs.microsoft.com/customersource/downloads/servicepacks/dynamicsax20 09sp1 Other key highlights in this service pack release include: * The SP1 installer updates both the SYS and GLS layers of the product. This means, for example, that if you already have GLS-TR installed on your system, SP1 will update this layer during the installation process. I assumed the above meant SYP or GLP was updated but now I am a little unsure because I always thought SYS was off limits to everyone and only a new version made changes but a binary file compare of a SYS aod from the install DVD compared to after GLS and RU3 being applied shows a different file size and content. Can this change in SYS aod be due to a full compile of the AX application? Would appreciate any help on being sure whether SYS aod file is the same even though the compare shows a difference Thanks James
Re: [Axapta-Knowledge-Village] Re: Inventory Costing in AX 2009
I think you should uncheck the FINANCIAL rather than the physical in the dimensions group setup!!! :) On Oct 24, 2009, at 5:37 PM, rayd wrote: uncheck the physical inventory across all dimension groups for 'warehouse' dimension. there will be no average inventory warehouse wise after this setup On Wed, Oct 21, 2009 at 6:15 PM, patelhani786 patelhani...@yahoo.co.in wrote: Dear Yadhav, you have to change item Dimention Group settings Regards Patel Hani --- In Axapta-Knowledge-Village@yahoogroups.com, Yadhav Krishnan k.yad...@... wrote: Hi ALL, I want to maintain Weighted Average Cost of an Item. In AX 2009, is the Inventory Costing done at a Warehouse Level or globally across the company. If it is done at the Warehouse Level i.e, if the Average Cost of the Item is calculated each Warehouse -wise. Can it be done across the company only not taking into account the Warehouse. I have purchased an Item X at WH 1 @ Rs.100 Assuming there is already an Item X at WH 2 @ Rs.200) Now after the purchase of the Item 1 @ WH 1, the Cost of the Item should be (Rs.1000 + Rs.200)/2 = Rs.150. But in AX 2009, it shows the Cost of Item @ WH 1 = Rs.100 and Cost of Item @ WH 2 = Rs.200 calculating the cost for each Warehouse. Can it be done across the company as a single way. Please Update. Thanks Yadhav
[Axapta-Knowledge-Village] Withholding tax for Thailand in GLS layer
Hi, anybody out there managed to get the withholding tax for Thailand in the AX2009 Sp1 + GLS layer to work (or even the non Thai Withholding tax to work)? The GLS document does not give any clear example as to how to get it to calculate withholding tax and seems we cannot get it to do anything even with parameters set and item master setup etc Would appreciate anyone can give any quick advice or example . or tell me it does not work and I need some hotfix . before I scream loud enough MS hears me in Redmond (since that seems to be the only way I will get them to listen to me ;) ) Thanks and buckets of appreciation in advance J James
[Axapta-Knowledge-Village] RE: Withholding tax for Thailand in GLS layer
Just to add the Non Thailand withholding tax can now get to work J But still the Thailand one has no result.does anyone know what supposedly is the difference for the Thailand one? Is it just that withholding tax is calculated per item rather than total invoice (hence can mix items that have or do not have withholding tax on same invoice)? Or is it that the withholding tax is supposed to be realized at time of invoice rather than payment for thailand? Thanks again James From: James Flavell [mailto:djf1...@gmail.com] Sent: 22 September 2009 17:45 To: 'Axapta-Knowledge-Village@yahoogroups.com' Subject: Withholding tax for Thailand in GLS layer Hi, anybody out there managed to get the withholding tax for Thailand in the AX2009 Sp1 + GLS layer to work (or even the non Thai Withholding tax to work)? The GLS document does not give any clear example as to how to get it to calculate withholding tax and seems we cannot get it to do anything even with parameters set and item master setup etc Would appreciate anyone can give any quick advice or example . or tell me it does not work and I need some hotfix . before I scream loud enough MS hears me in Redmond (since that seems to be the only way I will get them to listen to me ;) ) Thanks and buckets of appreciation in advance J James
[Axapta-Knowledge-Village] Auto bank recon
Hi everyone, I thought there was some function for auto bank reconciliation by importing of bank statement into AX but I cannot find anything for this? Am I mistaken or is it only appearing if certain country functionality is enabled? Thanks James
[Axapta-Knowledge-Village] ANyway to consolidate intercompany sales invoices
Hi everyone, Has anyone played with attempting to get intercompany sales orders to be consolidated? In real life this is maybe one of the number one chances to use consolidation of orders into one invoice but it seems AX does not allow it (set as invoice account but never combines and when set as order then get error message that intercompany cannot be combined) ! I am guessing it is for technical reason as the linkage between the intercompany orders seems to be pretty tight and therefore consolidating would confuse the matter but I am still keen to know if there is any way this might be possible with some code change or work around of some kind Thanks James
RE: [Axapta-Knowledge-Village] Client to AOS
Thanks Martin That is interesting to know about AX3.0 compared to AX4.0 Given the need for RDP can anyone shed any light on is W2008 TS/RDP comparable to Citrix (in terms of bandwidth and admin etc).I mean what is the benefit of Citrix now for say a less than 100 user AX system? Thanks James From: Axapta-Knowledge-Village@yahoogroups.com [mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of Malcolm Burtt Sent: 07 September 2009 18:24 To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] Client to AOS Hi James Connecting to object servers over a WAN worked okay in version 3 but since AX 4 it's a complete no-no. Your only option from AX 4 onwards is one of the many remote desktop solutions (e.g. RDP, Citrix, etc). Regards Malcolm Burtt Touchstone Group People - Partnership - Solutions From: Axapta-Knowledge-Village@yahoogroups.com [mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of James Flavell Sent: 06 September 2009 03:18 To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Client to AOS Hi everyone Just wondering if anyone has attempted to run AX client to AOS over a WAN and if so what kind of numbers for latency and bandwidth are needed/recommended The WAN I am referring to is something like a 1Mbs that has latency of maybe 30ms (so I am not really referring to public internet WAN) Thanks James image001.jpgimage002.jpg
RE: [Axapta-Knowledge-Village] Re: Client to AOS
Okay thanks for the feedback From: Axapta-Knowledge-Village@yahoogroups.com [mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of girac127 Sent: 07 September 2009 07:31 To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Re: Client to AOS James, I would recommend using an RDP connection to a terminal server or a desktop workstation. We have tried running over a multiple bonded MPLS WAN but the clients were just too slow on responding, especially when running multiple clients. G --- In Axapta-Knowledge-Village@yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com , James Flavell djf1...@... wrote: Hi everyone Just wondering if anyone has attempted to run AX client to AOS over a WAN and if so what kind of numbers for latency and bandwidth are needed/recommended The WAN I am referring to is something like a 1Mbs that has latency of maybe 30ms (so I am not really referring to public internet WAN) Thanks James image001.jpgimage002.jpg
[Axapta-Knowledge-Village] Client to AOS
Hi everyone Just wondering if anyone has attempted to run AX client to AOS over a WAN and if so what kind of numbers for latency and bandwidth are needed/recommended The WAN I am referring to is something like a 1Mbs that has latency of maybe 30ms (so I am not really referring to public internet WAN) Thanks James
[Axapta-Knowledge-Village] Split AR on a single Sales invoice posting
Hi everyone, Just wondering has anyone done a mod to split the AR transaction for a sales order invoice posting? I have the case whereby a sales order has several lines and each line might have a different salesrep and I would like to get separate AR transactions (CustTrans) for each sales rep so easy to compile a AR aging or statement per salesrep. I could make a customer account for each salesrep but this would then mean the SO has to be spilt into one per salesrep so this is not an ideal solution Wondering if it is fairly straight forward or not to do this kind of split (considering Dimensions can split the revenue part of the posting was wondering if something similiar can be done on the AR part) Look forward to hearing from anyone who has managed or attempted it Thanks James
RE: [Axapta-Knowledge-Village] Re: Slow performance on Misc Charges on Purchase Orders
Yes this is the property but I cannot remember the different values sorry so you will have to search MSDN etc Also check on the users options setup on the PreLoad whether the Markup trans is ticked (this is per user and the same as having FullTable cache) Just to check does the slow performance happen everytime or just the first time a specific user 'loads' the MarkupTrans? Also it might be that the SQL index is clustered or something (I have yet to fully understand when a clustered index is a good or not good idea but it seems a common advice to check on this and potentially change it - I think there is a setting in AOT for it...) Thanks James _ From: Axapta-Knowledge-Village@yahoogroups.com [mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of edwardjosling Sent: 06 August 2009 22:36 To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Re: Slow performance on Misc Charges on Purchase Orders Hi James We use Ax2009. In the table properties I see the CacheLookup value is set to NotInTTS. Are you refering to this value? --- In Axapta-Knowledge- mailto:Axapta-Knowledge-Village%40yahoogroups.com vill...@yahoogroups.com, James Flavell djf1...@... wrote: Check if the table is set as Tablecache FULL (meaning all records will be loaded into the users session when the user first accesses the table). If it is change it to NONE _ From: Axapta-Knowledge- mailto:Axapta-Knowledge-Village%40yahoogroups.com vill...@yahoogroups.com [mailto:Axapta-Knowledge- mailto:Axapta-Knowledge-Village%40yahoogroups.com vill...@yahoogroups.com] On Behalf Of edwardjosling Sent: 06 August 2009 20:38 To: Axapta-Knowledge- mailto:Axapta-Knowledge-Village%40yahoogroups.com vill...@yahoogroups.com Subject: [Axapta-Knowledge-Village] Slow performance on Misc Charges on Purchase Orders Hi All We are experiencing very slow performance (about 10minutes to load!) when trying to load misc charges on purchase order header. I have noticed that the MarkupTrans table contains some 870 000 records (this is due to auto misc postings on sales order lines). Will this be the cause of the slow performance and if so how do one go about to improve? Regards Eddie
RE: [Axapta-Knowledge-Village] Slow performance on Misc Charges on Purchase Orders
Check if the table is set as Tablecache FULL (meaning all records will be loaded into the users session when the user first accesses the table). If it is change it to NONE _ From: Axapta-Knowledge-Village@yahoogroups.com [mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of edwardjosling Sent: 06 August 2009 20:38 To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Slow performance on Misc Charges on Purchase Orders Hi All We are experiencing very slow performance (about 10minutes to load!) when trying to load misc charges on purchase order header. I have noticed that the MarkupTrans table contains some 870 000 records (this is due to auto misc postings on sales order lines). Will this be the cause of the slow performance and if so how do one go about to improve? Regards Eddie
RE: [Axapta-Knowledge-Village] On hand inventory adjustment - Date
Onhand adjustment is base don the last closing. You cannot change this. If you want as at 30/3 then you need to cancell all closing and recalcs back to that date _ From: Axapta-Knowledge-Village@yahoogroups.com [mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of edwardjosling Sent: 21 July 2009 14:57 To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] On hand inventory adjustment - Date Hi all We need to do a on-hand adjustment to revalue inventory as of a certain closing date. The date which wee need to do adjustments are on the 31/3. Closings have been done until 30/6. When doing a on-hand adjustment selection from the 31/3 closing, the posted quantities and values of the items are that of 30/6. This means that we need to reverse all the closings after 31/3 in order to an accurate adjustment. Is this normal behavior and if so, what would the reason be? We run Ax2009 Sp1. Thanks in advance Eddie
RE: [Axapta-Knowledge-Village] Re: AX versioning solution
Thanks Anil, I am looking for a full revision solution whereby the user has to submit the revision and have it approved etc before it impacts the system. I have some ideas of how to do it via the user creating new sales orders and these impact existing sales orders once approved. The main issue I have is the prospect is project based so trying to lock down all the possible ways of changing things on a project is far more challenging than just locking down a sales order :) Thanks James _ From: Axapta-Knowledge-Village@yahoogroups.com [mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of Anil Kumar Sinha Sent: 21 July 2009 13:18 To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Re: AX versioning solution Hi James, Sales and Purchase keeps history of all confirmation against a sales or Purchase order. But ass far as I know there is nothing like revision order. I did one such modification, if user modify Price or Quantity on a SO or PO he/she has to enter reason for that. We maintained a Log for this activity. Regards Anil Sinha --- In Axapta-Knowledge- mailto:Axapta-Knowledge-Village%40yahoogroups.com vill...@yahoogroups.com, Rahul Mohta rahulmoht...@... wrote: Hi You might want to have a customization to have a filter at the repective transaction screens for user wherein the from automatically filters the user records based upon the login. Rahul --- In Axapta-Knowledge- mailto:Axapta-Knowledge-Village%40yahoogroups.com vill...@yahoogroups.com, James Flavell djf1994@ wrote: Hi everyone I am looking for an AX revision history solution whereby the users must submit revision orders in order to change the quantity or price on alrady confirmed sales orders. Has anyone come across anything or attempted anything before? Thanks James
RE: [Axapta-Knowledge-Village] Re: Dual AOS on same server
Thanks Rahul, Yes the reason for 2 AOS I understand but I am talking about AX2009 allowing 2 AOS to use the same appl folder or someting like that (actually that is what my email is for to try to clear my confusion about whatever new functionality AX2009 and 2 AOS that I SUPPOSEDLY remember hearing/seeing somewhere) I could be just going mad and no such thing ever existsed but would appreciate someone helping to confirm I am going mad or not ;) Thanks James _ From: Axapta-Knowledge-Village@yahoogroups.com [mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of Rahul Mohta Sent: 20 July 2009 17:27 To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Re: Dual AOS on same server Hi 2AOS or more are usefull if the load is to be distributed. Rahul --- In Axapta-Knowledge- mailto:Axapta-Knowledge-Village%40yahoogroups.com vill...@yahoogroups.com, James Flavell djf1...@... wrote: Sorry everyone this one is more due to my memory failing me I remember in some MS seminar they said AX2009 allows us to run 2 AOS from the same appl folder or 2 AOS on the same server sharing the same appl folder (or somethign like that) So can anyone point me to what the '2 AOS' thing is rather than me confuse myself and also what situation it might be of use in (I was reading in the benchmark white paper about 'logical AOS instances' and wondered is this 2 AOS instances on the same server because 1 AOS would not make full/best use of teh hardware (it was I think in total a 16 core CPU...) Thanks again everyone and sorry for the poor memory James
[Axapta-Knowledge-Village] Dual AOS on same server
Sorry everyone this one is more due to my memory failing me I remember in some MS seminar they said AX2009 allows us to run 2 AOS from the same appl folder or 2 AOS on the same server sharing the same appl folder (or somethign like that) So can anyone point me to what the '2 AOS' thing is rather than me confuse myself and also what situation it might be of use in (I was reading in the benchmark white paper about 'logical AOS instances' and wondered is this 2 AOS instances on the same server because 1 AOS would not make full/best use of teh hardware (it was I think in total a 16 core CPU...) Thanks again everyone and sorry for the poor memory James
[Axapta-Knowledge-Village] AX versioning solution
Hi everyone I am looking for an AX revision history solution whereby the users must submit revision orders in order to change the quantity or price on alrady confirmed sales orders. Has anyone come across anything or attempted anything before? Thanks James
[Axapta-Knowledge-Village] Record Level Security for Financial Dimension in AX2009
Hi everyone just wanted to double check if anyone has managed to stop the financial statement and COA Balance by dimension form from showing dimensions that are supposedly not available for a user I have set RLS on ledtrans, ledgerbalancedim etc and even tried to set on the TmpAccountSum table but it seems there is no way to stop the user from seeing? So before I keep trying further just wondered has anyone had any success in these areas? I guess I could remove access to the standard forms for balance by dimension and make a new form that I can control it but for financial statement report its something I dont think I can easily replace (unless I do some OLAP or external report that can achieve the same matrix style formating as FS). Both of these are far from ideal :( Also anyone come across other places teh RLS will not work for inventory dimension or financial dimension since the plan would be to use it to filter data for a particular site? Thanks James
RE: [Axapta-Knowledge-Village] Re:Inventory closing adjusting already closed transactions
Okay sounds like maybe the cancels and reclose (if done several times and onthe same dates) might be the cause But sorry I dont have any way to confirm this is the case _ From: Axapta-Knowledge-Village@yahoogroups.com [mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of edwardjosling Sent: 07 July 2009 16:00 To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Re:Inventory closing adjusting already closed transactions Hi James Using version 3.0 SP6. Closing was done on the 30/04/2009. The next closing was done on the 31/5/2009. Various cancellations/re-closings happened on both these dates. When investigating cost of sales, I reconciled the difference to the closing adjustments (which is normal). By looking at the specific item transactions in question, I discovered that although some issues (sales order) was financially closed on 30/4/2009, settlements (adjustments) still was done on these transactions on the 31/5/2009. To me this do not make sense? Eddie --- In Axapta-Knowledge- mailto:Axapta-Knowledge-Village%40yahoogroups.com vill...@yahoogroups.com, James Flavell djf1...@... wrote: So Edward what version are you using, what have you done (e.g. canceling close) and what do you see happening? I have not seen the problems I have heard about canceling closing but to be honest I have managed to now have to do too many cancels On Jul 5, 2009, at 2:19 PM, edwardjosling wrote: Closed in this instance refer to the the particular inventory transaction (receipt and issue) to be financially closed, i.e. is has been fully settled. Thus the transaction will be date stamped with the particular closing date. I must concur that there should be no ways that such a transaction can be further adjusted. I have read that some problems have occurred in Ax 3.0 when closings have been cancelled. I wonder if this could be my problem... --- In Axapta-Knowledge- mailto:Axapta-Knowledge-Village%40yahoogroups.com vill...@yahoogroups.com, James Flavell djf1994@ wrote: Sorry to add but please define what you mean by closed? If you close inventory does not mean that the inventory trans in that period are all closed (the field on the inventrans called Open becomes No). If the inventtrans is not closed then of course you can do adjustment and end up affecting it. If the inventtrans is closed then there should be no way for you to touch that transactions (unless you cancel closing and then of course it is no longer closed) _ From: Axapta-Knowledge- mailto:Axapta-Knowledge-Village%40yahoogroups.com vill...@yahoogroups.com [mailto:Axapta-Knowledge- mailto:Axapta-Knowledge-Village%40yahoogroups.com vill...@yahoogroups.com] On Behalf Of George Burrell Sent: 03 July 2009 05:11 To: Axapta-Knowledge- mailto:Axapta-Knowledge-Village%40yahoogroups.com vill...@yahoogroups.com Subject: [Axapta-Knowledge-Village] Re:Inventory closing adjusting already closed transactions This is normal. Even in a closed period, if a Purchase Price is adjusted (e.g. through Close/Adjust Adjustments etc), the impact of that has to flow onto issues of stock if they are linked to that Purchase transaction. Don't confuse this with the GL impact, which of course be felt on the current date. Look at it another way - what do you think should happen if you close a period 5 days into a new month, and you realise that a Purchase Price in the closed period is wrong? George
RE: [Axapta-Knowledge-Village] Re:Inventory closing adjusting already closed transactions
You cannot adjust a fully settled reciept its as simple as that :) If its partially settled you can only adjust the open portion (if you do onhand adjustment you will see partial transactions get split into fully settled trans and the open trans which clearly shows adjustment cannot be done on settled part of any transaction) Closed means clsoed to any adjustment does not matter if it comes through onhand/trans adjustment or the recalc/closing Settled means settled so I hope we are settled on this ;) _ From: Axapta-Knowledge-Village@yahoogroups.com [mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of George Burrell Sent: 08 July 2009 05:20 To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Re:Inventory closing adjusting already closed transactions Even though you have a fully settled receipt transaction, what happens if you want to adjust a purchase price on a fully settled receipt transaction. What happens if it is linked to a fully settled issue transaction. In my mind, being fully or partially settled is not relevant for the question we are considering. If you adjust a receipt of inventory, it passes those adjustments on to issues of inventory. I think fully settled transactions become relevant when the close/recalc algorithm is setting up new links - any fully settled transactions would not be considered according to a flag. I am thinking of FIFO mainly as I think of this because it is simple, but the rationale can be extended to WEIGHTED AVERAGE as well. George
Re: [Axapta-Knowledge-Village] Re:Inventory closing adjusting already closed transactions
So Edward what version are you using, what have you done (e.g. canceling close) and what do you see happening? I have not seen the problems I have heard about canceling closing but to be honest I have managed to now have to do too many cancels On Jul 5, 2009, at 2:19 PM, edwardjosling wrote: Closed in this instance refer to the the particular inventory transaction (receipt and issue) to be financially closed, i.e. is has been fully settled. Thus the transaction will be date stamped with the particular closing date. I must concur that there should be no ways that such a transaction can be further adjusted. I have read that some problems have occurred in Ax 3.0 when closings have been cancelled. I wonder if this could be my problem... --- In Axapta-Knowledge-Village@yahoogroups.com, James Flavell djf1...@... wrote: Sorry to add but please define what you mean by closed? If you close inventory does not mean that the inventory trans in that period are all closed (the field on the inventrans called Open becomes No). If the inventtrans is not closed then of course you can do adjustment and end up affecting it. If the inventtrans is closed then there should be no way for you to touch that transactions (unless you cancel closing and then of course it is no longer closed) _ From: Axapta-Knowledge-Village@yahoogroups.com [mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of George Burrell Sent: 03 July 2009 05:11 To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Re:Inventory closing adjusting already closed transactions This is normal. Even in a closed period, if a Purchase Price is adjusted (e.g. through Close/Adjust Adjustments etc), the impact of that has to flow onto issues of stock if they are linked to that Purchase transaction. Don't confuse this with the GL impact, which of course be felt on the current date. Look at it another way - what do you think should happen if you close a period 5 days into a new month, and you realise that a Purchase Price in the closed period is wrong? George
RE: [Axapta-Knowledge-Village] Re:Inventory closing adjusting already closed transactions
Sorry to add but please define what you mean by closed? If you close inventory does not mean that the inventory trans in that period are all closed (the field on the inventrans called Open becomes No). If the inventtrans is not closed then of course you can do adjustment and end up affecting it. If the inventtrans is closed then there should be no way for you to touch that transactions (unless you cancel closing and then of course it is no longer closed) _ From: Axapta-Knowledge-Village@yahoogroups.com [mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of George Burrell Sent: 03 July 2009 05:11 To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Re:Inventory closing adjusting already closed transactions This is normal. Even in a closed period, if a Purchase Price is adjusted (e.g. through Close/Adjust Adjustments etc), the impact of that has to flow onto issues of stock if they are linked to that Purchase transaction. Don't confuse this with the GL impact, which of course be felt on the current date. Look at it another way - what do you think should happen if you close a period 5 days into a new month, and you realise that a Purchase Price in the closed period is wrong? George
[Axapta-Knowledge-Village] Reservation sequence in AX2009 shipments
Hi everyone, I was looking at the reservation sequence on shipments in Ax2009 (which I think is an improvement) but I was wondering if I am using batch number reservation (not date controlled) then how does this sequence work. I assume it will just find any available stock within the locations on the first sequence and therefore may well be not doing at all a good job of making sure oldest expiry date stock goes out first. Can anyone advise if they have looked into this new feature and if my concern is correct (and if there is any easy way to improve it or minmise the risk :) ) Thanks James
[Axapta-Knowledge-Village] RE: Error running export to file as batch but no problem when run normally by the user
Hi everyone I have a strange problem that I have a class that basically creates a text file of the item onhand information. The class works fine when run by the user but when I set it to run in batch it gives an error when the following code is called by the batch client: new FileIOPermission(FileName, 'w').assert(); File= new AsciiIO(FileName, 'w'); The error says about ASCIIIO is not initialised. I get the error even if I start the batch client in the same logged in AX session that works if the user runs the export directly so I am a little lost Also I took the export and put it on a dev server and it worked okay using the batch client! So I am wondering when the batch client is running what user id is it running as? The user id that logged into AX and started teh batch client or the user id that is in the AOS service start up or soemthing like that? Does anyone have any idea why the batch running would give this error since the export works fine when run directly by the user? This is AX4.0 SP1 or SP2 I cannot remember right now Thanks James
[Axapta-Knowledge-Village] AX3.0 copy and paste Chinese double byte into MS Excel problem
Hi everyone..more duoble byte woes ;) Now I have my customer's Ax3.0 up and running with Chinese GUI and Chinese data but the next problem is that if the user copies and pastes Chinese data from AX into Excel it is not working If say the user copies a customer master record that has the customer name showing in chinese in AX when this is pasted into Excel it seems excel assumes the characters are Unicode rather than duoble byte and so shows Unicode characters (garbage characters) Is there some way to get Excel to assume characters pasted are not always unicode? Or some 'widget'/middleware that can convert, with little or no user input during the copy and paste, from double byte to unicode? Look forward to someone being able to help before the users get their hands on me ;) Thanks James
RE: [Axapta-Knowledge-Village] Error posting the PO SO after using the duplicate company account in AX 2009
Or go to AP or AR / Inquires / History / Sales order update (sorry cannot remember the exact naming) and delete all the records there (dont worry these are records of posting and so not required to be kept...usually used if do batch psoting and some records dont post you can come here and repost with the original posting settings - which is what PurchParmUpdate tables are - being remembered etc) Not quite sure why duplicate would ahve a problem but guess maybe the recid is different and maybe that is kept somehwere so the old record cannot be deleted during new posting or something like that Let us know if that solves it Thanks James _ From: Axapta-Knowledge-Village@yahoogroups.com [mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of Anitha S Sent: 28 May 2009 14:31 To: Axapta-Knowledge-Village@yahoogroups.com Subject: Re: [Axapta-Knowledge-Village] Error posting the PO SO after using the duplicate company account in AX 2009 Hi.. Try this.. Go to Tools-Options - Usage Data - Reset. Regards, Anitha. On Tue, Apr 7, 2009 at 10:11 AM, andrianchan msbaxa...@gmail. mailto:msbaxa...@gmail.com com wrote: Hi All, Anyone facing the same problem after using the duplicate company account in AX 2009 then the system will not allow the posting for PO SO in the duplicated company account? The error appear Cannot create a record in Purchase Order - Update (PurchParmUpdate). Insert operations are not allowed accross companies. Please use change company keyword to change the current company before inserting the record Please help. Rgds CM
[Axapta-Knowledge-Village] Intercompany and AXSalesTable/AXPurchTable
Hi everyone Was wondering is anyone has come across the following pain in AX intercompany in AX2009 (or maybe earlier versions too) Orig SO (A) PO (B) created via direct delivery for (A) Intercompany SO (C) created for (B) When it is all created the address on all 3 is the sames as (A) BUT if I change the delivery term field (or other fields that are sync'd) on (C) then (A) and (B) have their delivery address 'reset' to the company info address!!! I can see code in AxSalesTable and AxPurchTable regarding setDeliveryAddress etc and it looking up companyinfo address but cannot quite fully understand how to fix such that the address should not change if I update something like Del Term (I have a feeling I need to trick AX into thinking the delviery address fields have changed and then these will be sync'd back rather than copnay info address being used but again this is only a educated guess and where exactly to put such code is another matter) Would apprecaite anyone who can give me some advice or ideas Thanks James
RE: [Axapta-Knowledge-Village] 3-Tier Error on Certain PCs
Can you do a DNS lookup or ping from their PCs and get a response? Is their firewall blokcing somehow? _ From: Axapta-Knowledge-Village@yahoogroups.com [mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of Anthony Sent: 13 May 2009 01:03 To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] 3-Tier Error on Certain PCs I have 2 computers in our environment that produces an error when the user attempts to start 3 tier mode. We are on AX 3.0 SP 5. The error message says that No Microsoft Axapta Object Servers could be located using the current client configuration. We have 25 computers that are working fine using 3-Tier. I have reimported the configuration from the server, uninstalled and reinstalled the AX client, and had our installation partner review the error with me. We have been unable to resolve the problem on these two PCs. Both PCs belong to salesmen who are not usually hooked up to our network and access AX through the VPN, but both have brought their laptops to me onsite and produced the same results. Does anyone have any suggestions to get their 3-Tier functioning again?
[Axapta-Knowledge-Village] AX2009 RTM includes full Australia localisation?
Hi everyone, I am trying to understand whether AX2009 RTM includes the full Australia localisation so would apprecaite anyone who can advise. The AX2009 roadmap has GA wave 1 to 4 and Australia is GA 4 but I cannot figure out is GA 4 realted to RTM or SP1. I assume AX2009 was not made available in Australia in the first wave for some reason so am a little lost and my customer is running RTM and want to incude their Australia office now Once I get past this query my others are more in detail as to whether AX2009 handles the Fringe Tax Benefits in Australia or that has to all be done outside of the system? Thanks James
RE: [Axapta-Knowledge-Village] need help in upgrade
mmm you should do code upgrade and a test data upgrade and then when this is all okay then you just do a data upgrade when the customer is ready to switch over We have a case of having done code and test data upgrade and now the customer is taking a good 6 months to test everything (are are doing some changes in AOT during this time also so we are having to update both 3.0 and 2009 ...no problem so long as you factor in effort for 2 data upgrades in your cost (FYI it took us about 40 hours to get the first data upgrade to work and completed for an Ax3.0 SP2) _ From: Axapta-Knowledge-Village@yahoogroups.com [mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of nanukuttan rinish Sent: 27 April 2009 15:51 To: Axapta Subject: [Axapta-Knowledge-Village] need help in upgrade Hi all, I have a doubt during the upgrade, please considered a scenario where we are taking an upgrade project from client xyz to upgrade from Ax3.0 to Ax2009. Say if we are taking the client's Ax3.0 environment and database and we are successfully upgrading it. We will imagine that the upgrade takes 2 months to complete.In the meanwhile the customer would have made lot of transaction in his Ax3.0 environment. Now how do we update the records which are added in the 2 months period in Ax2009 environment. Regards Rinish.N _ Explore your hobbies and interests. Click http://in.rd.yahoo.com/tagline_groups_6/*http://in.promos.yahoo.com/groups/ here to begin.
RE: [Axapta-Knowledge-Village] Quantities and decimal places
You have to change the EDT to be 3 decimals otherwise user entry will get rounded _ From: Axapta-Knowledge-Village@yahoogroups.com [mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of anishafakir Sent: 29 April 2009 22:45 To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Quantities and decimal places Hi, I want a certain unit of measure to have 3 decimal places. However when I create a purchase order for this unit of measure, the qty value is rounded to 2 decimal places. How can I show the qty in 3 decimal places? I did set the decimal value on the Units form to 3 decimals for this unit but it doesn't seem to work. Please advise Thanking you in advance Regards, Anisha
[Axapta-Knowledge-Village] AX3.0 MRP strange result
Hi everyone We have a strange result with AX3.0 Sp5 MRP using Period coverage. When it is run 3 planned purchase orders are created but the first planned PO qty covers requirements way beyond 90 days, which should be in the later planned POs!!!. The second and third planned purchase orders only cover requirements within 90 day period (but do not contina the error requirements that somehow got put in the first planned PO) The strange thing is if after running the master planning if we go to the item / net req / update / master scheduling this updates the planned purchase orders to be correct (i.e. each planned PO only covers the requirements for 90 days) Has anyone come across anything similiar before...I vaguely remember Harry mentioning there are a number of bugs in master planning long ago but dont remember any specifics The settings for this item are: Leadtime 60 days Coverage: Period Coverage Period 90 days Neg days: 720 Postitive days: 720 Timefence: 720 days Thanks James
RE: [Axapta-Knowledge-Village] Tax Regulation error in IND LOC 4.0SP2
You get this if you are combining several orders (in version Ax3.0 you can also get this if you do adjustment and post only 1 PO but thats another story so I wont explain the work around for that since you are obivously not on that version) You should remove the tax adjustment on the PO and do posting, then in the posting screen do the adjustment there (I cannot remember but expect you need to press the Arrange button first before you do the tax adjustment) Not to sure why MS will not pick from each PO but guess maybe because you are combining several PO they want you to be sure and make the adjustment according to the final invoice amount rather than individual Thanks James _ From: Axapta-Knowledge-Village@yahoogroups.com [mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of Tushar Joshi Sent: 18 April 2009 15:26 To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Tax Regulation error in IND LOC 4.0SP2 All, We are facing a problem at client's place while doing the invoicing for the Purchase orders. The scenario is as follows I have 2 Purchase orders for 2 different items but they are of 1 common Vendor. I have applied taxes as Excise and VAT to both the PO's but before doing the invoice i have done the Sales Tax adjustment for one of the PO. The Vendor has sent me 1 Invoice against both the PO's. While doing the invoice for both the PO's i can select the PO's and and at the time of posting invoice i am doing the summary update for invoice account which would allow me to post a single invoice aganist both the PO's. But as i have done the tax adjsutment for one of the PO's, Axapta doesn't allow me to post it and throws an error of Tax regulation Screenshot is attached for the reference. Can anyone across the group guide to overcome this problem -Tushar _ Add more friends to your messenger and enjoy! Invite http://in.rd.yahoo.com/tagline_messenger_6/*http://messenger.yahoo.com/invi te/ them now.
RE: [Axapta-Knowledge-Village] Contact Person Name in SO Packing Slip.
Yes I was going to say the best way to get people to write code for you is to pay them ;) _ From: Axapta-Knowledge-Village@yahoogroups.com [mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of kristanto surjadi Sent: 15 April 2009 15:59 To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] Contact Person Name in SO Packing Slip. Or a more simple solution, is to hire an ax developer http://mail.yimg.com/us.yimg.com/i/mesg/tsmileys2/04.gif --- On Wed, 4/15/09, James Flavell djf1...@gmail.com wrote: From: James Flavell djf1...@gmail.com Subject: RE: [Axapta-Knowledge-Village] Contact Person Name in SO Packing Slip. To: Axapta-Knowledge-Village@yahoogroups.com Date: Wednesday, April 15, 2009, 12:41 PM take a look in the Salespackingslip table methods. look in the initFromSalesTable and that should give you a place to start from (of course you will need to add the salesperson field to the salespackingslip table etc). you probably need to use the salestable.contactp erson() method in this initFrom method because only the contactpersonid is stored on the salestable _ From: Axapta-Knowledge- vill...@yahoogro ups.com [mailto:Axapta- Knowledge- vill...@yahoogro ups.com] On Behalf Of Khalil Rehman Sent: 15 April 2009 13:23 To: Knowlege Village; Development Group Subject: [Axapta-Knowledge- Village] Contact Person Name in SO Packing Slip. Dear All, i want ot have contact person name on Salespackingslip Report. how can i can some body write for me the code for this. regards. http://graphics.hotmail.com/i.p.emrose.gif KHALIL UR REHMAN http://graphics.hotmail.com/i.p.emrose.gif _ What can you do with the new Windows Live? Find out http://www.microsoft.com/windows/windowslive/default.aspx
RE: [Axapta-Knowledge-Village] AX and 2 DBs reat-time update??
mmm I think you have to look into doing it as 1 AX appl and having real time SQL mirroring/redunancy/clustering (plus a backup Appl/AOS ready to go but this is the easy part I guess) If the point is to safe guard against failure at a physical site then you would have to see how well SQL/Oracle can do the mirroring/redunacy/clustering over WAN etc (I have no real idea but guess if possible then it aint pretty and for sure probably aint real 'realtime' unless you can get a true ethernet or higher connection between the two sites) AX provides no way to do 1 site realtime update like what you are saying Thanks James _ From: Axapta-Knowledge-Village@yahoogroups.com [mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of kardo_ax Sent: 14 April 2009 14:42 To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] AX and 2 DBs reat-time update?? What is the best solution for such a scenario: company that has two locations where they want each location to have its own AX and its own Database.Location1 is the head-office and location2 is the factory. The requirement is to have both databases real-time updated so that they have the same data and in case one site failed users of that site log-in to the second and continue their tasks. first location: HQ with AX1, Sql DB1 and HQ users Second location: F1 with AX2, Sql Db2 and F1 users. Db1 and Bd2 must have the same data on real time bases.In case of a failure users can use the running application and its DB. How can we setup such a scenario, I know one DB is the best solution but what is described above is the must.
RE: [Axapta-Knowledge-Village] Re: Loading Legacy History (Sales Invoices Vendor Invoices) to standard AX 2009
just to add to my original posting... the idea of loading historical invoices into the tables is just 2 tables custinvoicejour and custinvoicetrans. If you want info in any other tables then potentially direct load is maybe not what you want these 2 tables are enough to give you historical sales reports (which I assume is the main reason for having such data) but as mentioned wihtout cost unless you do a modification like I mentioned. To add I think the mod I suggested about the cost will work fine also in the std AX olap cubes (as they use the costvalue method) but of course for any OLAP cubes done outside of AX you would need to follow the same logic of checkign if inventtrans records or a value in the new historicalcost field _ From: Axapta-Knowledge-Village@yahoogroups.com [mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of Subbu Sent: 15 April 2009 06:56 To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Re: Loading Legacy History (Sales Invoices Vendor Invoices) to standard AX 2009 Hi Varden, He can use DoInsert() method absolutely no problem. but, how can he create SalesIds that link between SalesInvouceJour/SalesInvoiceLines tables. Trans tables have inventTransId which links to SalesLine And also, the story does not stop at just these tables. If the vendor has non po invoices, then he has to post in LedgerJournalTable/LedgerJournalTrans. Remebember, if his customer wants to view the report by customer num, discounts , tax ,surcharges, tax on surcharges, tax exempt on surchares oh yeah, its just not those two tables. He has also look into ledgerJournalTable/Trans tables for Non PO/SO invoices and make sure that he has properly taken care of GL side postings. I am not sure if his customer would consider to maintain his whole SO/PO invoice history in a seperate company rather than the existing transactional company. Some people would prefer to maintain the history in a seperate company or ask them to use TARGIT or something similar. Just a thought. Wanted to say that its just not two tables when the orders have discounts,Sales taxes ( each state has its own tax ) and surcharges. My 2 US cents. Kind regards, Subbu Sr. Application Developer. Certified double master in functional as well as technical. Sunny Delight Beverages company --- In Axapta-Knowledge- mailto:Axapta-Knowledge-Village%40yahoogroups.com vill...@yahoogroups.com, Varden Morris vard...@... wrote: Usually in these kinds of data imports we assume that the data is clean and valid. So we would use the doInsert() method on the table buffer as oppose to the insert method. This method skips all validation and enhances performance. Varden Morris Varalth Solutions Inc. 693 Abbottsfield Road NW Edmonton, Alberta T5W 4R4 Canada (780) 752-0406 www.varalth.com CONFIDENTIALITY NOTICE This message and any attachments are confidential. If you have received this transmission in error, please be advised that any disclosure, copying, distribution or action taken in reliance upon this communication is strictly prohibited. If you have received this communication in error, please contact the sender immediately. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company. Finally, the recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. From: Michael Franchino michael.franch...@... To: Axapta-Knowledge- mailto:Axapta-Knowledge-Village%40yahoogroups.com vill...@yahoogroups.com Axapta-Knowledge- mailto:Axapta-Knowledge-Village%40yahoogroups.com vill...@yahoogroups.com Sent: Tuesday, April 14, 2009 1:44:09 PM Subject: RE: [Axapta-Knowledge-Village] Loading Legacy History (Sales Invoices Vendor Invoices) to standard AX 2009 James, Did you have to remove the relationship validations on the tables to bring the data in? Specifically, how did you get around the fact that the salesOrder in the salesId did not exist in the SalesTable? mcaConnect Michael Franchino Office: 973-726-8809 X214 Mobile: 201-213-6079 Fax: 973-726-4552 www.mcaconnect. net Gold Certified Partner-Inner Circle Member Microsoft Dynamics AX--People Ready Software From:Axapta-Knowledge- vill...@yahoogro ups.com [mailto:Axapta- Knowledge- vill...@yahoogro ups.com] On Behalf Of James Flavell Sent: Monday, April 13, 2009 9:37 PM To: Axapta-Knowledge- vill...@yahoogro ups.com Subject: RE: [Axapta-Knowledge- Village] Loading Legacy History (Sales Invoices Vendor Invoices) to standard AX 2009 Hi Michael, I have loaded sales and purchase invoice directly into the cust/vendinvoicejou r and lines. The one thing to note is the cost is not available since this comes from inventtrans (which I did
RE: [Axapta-Knowledge-Village] Contact Person Name in SO Packing Slip.
take a look in the Salespackingslip table methods. look in the initFromSalesTable and that should give you a place to start from (of course you will need to add the salesperson field to the salespackingslip table etc). you probably need to use the salestable.contactperson() method in this initFrom method because only the contactpersonid is stored on the salestable _ From: Axapta-Knowledge-Village@yahoogroups.com [mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of Khalil Rehman Sent: 15 April 2009 13:23 To: Knowlege Village; Development Group Subject: [Axapta-Knowledge-Village] Contact Person Name in SO Packing Slip. Dear All, i want ot have contact person name on Salespackingslip Report. how can i can some body write for me the code for this. regards. http://graphics.hotmail.com/i.p.emrose.gif KHALIL UR REHMAN http://graphics.hotmail.com/i.p.emrose.gif _ What can you do with the new Windows Live? Find out http://www.microsoft.com/windows/windowslive/default.aspx
RE: [Axapta-Knowledge-Village] Loading Legacy History (Sales Invoices Vendor Invoices) to standard AX 2009
Hi Michael, I have loaded sales and purchase invoice directly into the cust/vendinvoicejour and lines. The one thing to note is the cost is not available since this comes from inventtrans (which I did not bother to create). If the customer wants the cost (usually they will be willing to accept without if you tell them how much more it will cost) then either you have to create inventtrans records (possible either via code or via import data as SO and post invoices) or just modify so that there is a new field on the invoice lines called 'historical cost' and then modify the cost method on the lines such that if there is zero cost returned from inventtrans search then return the value in the historical cost (I have not done this but looked at doing it and it should be a nice and clean mod from what I saw of the code) All the best Let us know what you decide on Thanks James _ From: Axapta-Knowledge-Village@yahoogroups.com [mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of Michael Franchino Sent: 14 April 2009 02:34 To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Loading Legacy History (Sales Invoices Vendor Invoices) to standard AX 2009 I have 2 customers that wish to take their legacy history and load it into AX. They don't want to have us create separate tables to view/report on this data. They would like to be able to run standard AX reports for Customer Invoices/Vendor Invoices. Has anyone successfully loaded this type of history into AX from a legacy system?
[Axapta-Knowledge-Village] Re: Customer orders via Enterprise portal for projects
Thanks Khaled I look forward to exploring possible ways with you and the rest :) I just messed up my VPC's IIS trying to get the new customer sign up to work for EP :( So will only be able to get back to playing around with this on Monday when I get to the office and I get the original VPC image restored on the Hyper-V server (for those considering using Hyper-V I can highly recommend it in terms of minimal hassle getting any MS released VPC's up and running ... and at pretty much normal speed : ) Thanks James --- In Axapta-Knowledge-Village@yahoogroups.com, Khaled Moustafa khaled_...@... wrote: Dear James, That's me again, Khaled :-) Very good topic James to start talking about and to start this kind of process. Let me start to work with this process, and I'll contact with you later. See you later :-) Best Regards, Khaled From: James Flavell djf1...@... To: Axapta-Knowledge-Village@yahoogroups.com Sent: Saturday, April 4, 2009 7:24:50 AM Subject: [Axapta-Knowledge-Village] Customer orders via Enterprise portal for projects Hi everyone again  Have any of you developed or thought about how it could be possible for a customer to enter an order (mainly for stock) via the enterprise portal and have the order associated to a project? We dont want to have to create a complete EP site for project orders but rather prefer to stick to the std customer role EP as much as possible  The reason is the customers busniess is made up of both installation projects and service agreements (both created in project module from within AX windows client) but also spare parts sales (which the customer hopes to have their customers do via EP). If we use the std EP which makes only a normal sales order then total reporting of sales etc will require to run reports in both project and AR modules (please correct me if I am wrong). I can get total values from ledger etc but I am referring more to users who would normally be running sales reports from the sub ledger etc  From what I can see we only need to assign a project id on the sales order header and thats it AX will take care of the rest as if it was a sales order created from project.  So the best solution would be during EP order entry to assign a project id to the order via some modification.  A manual way I thought of to get the proj id on a EP order is that once an order is placed on the std EP the internal user can make a project, make a sales order from the project and then use the 'Copy From' function to copy the lines from the orginal EP order. Anyone see any problems with doing that (apart from the extra work...which could be automated farily easily I guess)?  Also I think I could insert a project id on to the original EP order and then do 'Copy From' function within this sales order then everything should also be okay (just make sure to tick 'Delete original lines') and I get to keep the original sales order number :)  Does anyone see any problems with using this kind of approach? The only things that seem to be related to project on the sales order is the project id and the project transaction id (on the sales lines...anyone knows exactly what this project trans id is for please do let me know..I have a rough idea but not 100%).  If you got this far thanks for taking the time and I hope we might be able to share some ideas on a solution :) Thanks James Â
RE: [Axapta-Knowledge-Village] Customer self service
Thanks Khaled, I followed your steps and I can get a little further now :) I get an EP site that is more like what I expect (there are a lot of links such as 'Sales orders' but I get the HTTP 404 error on these so for now I will take it access is denied to these since I am just anonymous user ... although really such links should not be shown if am am anonymous user right?) and basically I can only view the product catalogue and sign up pages but the Submit button on the sign up page is greyed out so I dont know how can I get myself signed up as an external customer?! I played around with assigning EP_Ext (External user) and EP_Cust user groups to the guest or just the EP_Guest group but it didnt seem to make any difference in getting the submit button to be available... I put the site in my trusted and set the lowest security setting but also no luck I noticed in the top right corner of the browser it still shows as 'Welcome CONTOSO\Administrator' which means I am not recognised as guest but admin??? What is the 'External web users' option in Setup needed for? Is this something I need to worry about at this early stage or only if I actually implement EP customer role in production environment? Would appreciate some further help for anyone out there who can spare a few mins so I can get to trying out adding items to sales basket and follow the flow of this into AX :) Thanks again Khaled and hope someone can help get me sorted James _ From: Axapta-Knowledge-Village@yahoogroups.com [mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of Khaled Moustafa Sent: 21 March 2009 14:38 To: Axapta-Knowledge-Village@yahoogroups.com Subject: Re: [Axapta-Knowledge-Village] Customer self service Hello James, First Of all, to enable the guest user and also what i really understand from you that you are using the RTM VPC from Microsoft and i know in this VPC there is NO EP Groups at all, So, for that you can 1st run the Configuration Wizard, after you finished all the EP groups it'll come and the EP_Guest is one of them, also it's better if you can understand and check all the default EP Groups and what is the useful for each groups. then, to enable the guest user in AX Client you just go to the User form in AX Client and check the enable button, you don't need to create or assign any user or groups in AD. Now, You need to create a new EP Site and use the MS Dynamics Public Template for this site (this is the one used for the Guest users and Internet sites), and this can be done from the SharePoint Central Administration Website. after you successfully create the new EP Site when you hit the URL from AX Client under the Website form or even from the SharePoint Central Administration Site, you'll see that the site already logged in with the guest user this actually for the Internet uses. I hope if this information is help you. Best Regards, Khaled _ From: James Flavell djf1...@gmail.com To: Axapta-Knowledge-Village@yahoogroups.com Sent: Thursday, March 19, 2009 10:19:40 AM Subject: RE: [Axapta-Knowledge-Village] Customer self service Thank you very much Can you help direct me how to enable the guest login? Do I need to run the EP config wizard? The user groups EP_* dont exist in the user groups but I can run the Role Center (I am currently using the VPCC AX2009 RTM) Do I have to assign some EP_ user gorup to the guest Active Directory account in the AX users? Do I need to allow anonymous access? And does this need something setup on the IIS? How do I go to the web page as guest? Since this is VPC I am logged in as administrator and it seems to take that as the default and so maps it to an AX internal user Thanks and sorry for all the questions... just that I can't quite make enough sense of it so am sure its just some small thing(s) I need James _ From: Axapta-Knowledge- vill...@yahoogro ups.com http://ups.com/ [mailto:Axapta- Knowledge- vill...@yahoogro ups.com] On Behalf Of Khaled Moustafa Sent: 19 March 2009 14:05 To: Axapta-Knowledge- vill...@yahoogro ups.com Subject: Re: [Axapta-Knowledge- Village] Customer self service Hello James, The way that you can work with the Customer Self Services is to login in EP with the Guest user, and to login with the Guest user you need to enable this guest user in AX Client, After that when you login to the EP with Guest user all you can see by default is the Products Catalog and a Request page to be a Customer. after you finish the request in the EP site you can see this request and all the requests under the customer self services then sing up form you can find this in enterprise portal in administration. then after that you can complete the full cycle for your customer and send for him/her the user name and password for the request. Hope if this information is help. Best Regards, Khaled _ From: James Flavell djf1...@gmail. com To: Axapta-Knowledge- vill...@yahoogro ups.com
[Axapta-Knowledge-Village] various common project module problems
Hi everyone, I think these are fairly common requests from customers who use the project module so wondering if anyone has already programmed something? 1) The user wants to invoice a deposit to the customer at the start of the project and then on the final invoice show total invoice amount minus deposit gives the final invoice amount. Using fee or onaccount usually we suggest to create a negative line for the deposit invoice on the same date as the final invoice but customers often want this to be automatic because if they are having to change or add deposit invoice amounts as the project progresses etc they must always remember to make such changes in the reverse transaction. Maybe someone has done a solution where the original deposit line is ticked as 'Reverse on final invoice' or something like that? 1B) If the deposit invoice is in foreign currency then the customer wants the reverse invoice to be at the same rate as the original deposit invoice. The customer does not want to use fixed rate on the whole project, rather only on the lines that are reversed. Can anyone tell me where is the code that sets the exchange rate for a project invoice? 2) Auto create fees or onaccount line based on percentage split of complete project amount The customer has fixed project terms such as 50% upon signing, 20% after 30 days, and then 20% on completion etc and wants to just apply these to the total project amount for the system to know how much to bill at each stage etc rather than the user manually calculate and possibly make mistakes. Look forward to seeing what you might have done or considered doing Thanks James
[Axapta-Knowledge-Village] Customer orders via Enterprise portal for projects
Hi everyone again Have any of you developed or thought about how it could be possible for a customer to enter an order (mainly for stock) via the enterprise portal and have the order associated to a project? We dont want to have to create a complete EP site for project orders but rather prefer to stick to the std customer role EP as much as possible The reason is the customers busniess is made up of both installation projects and service agreements (both created in project module from within AX windows client) but also spare parts sales (which the customer hopes to have their customers do via EP). If we use the std EP which makes only a normal sales order then total reporting of sales etc will require to run reports in both project and AR modules (please correct me if I am wrong). I can get total values from ledger etc but I am referring more to users who would normally be running sales reports from the sub ledger etc From what I can see we only need to assign a project id on the sales order header and thats it AX will take care of the rest as if it was a sales order created from project. So the best solution would be during EP order entry to assign a project id to the order via some modification. A manual way I thought of to get the proj id on a EP order is that once an order is placed on the std EP the internal user can make a project, make a sales order from the project and then use the 'Copy From' function to copy the lines from the orginal EP order. Anyone see any problems with doing that (apart from the extra work...which could be automated farily easily I guess)? Also I think I could insert a project id on to the original EP order and then do 'Copy From' function within this sales order then everything should also be okay (just make sure to tick 'Delete original lines') and I get to keep the original sales order number :) Does anyone see any problems with using this kind of approach? The only things that seem to be related to project on the sales order is the project id and the project transaction id (on the sales lines...anyone knows exactly what this project trans id is for please do let me know..I have a rough idea but not 100%). If you got this far thanks for taking the time and I hope we might be able to share some ideas on a solution :) Thanks James
RE: [Axapta-Knowledge-Village] Inventory recalculation
mmm I assume you mean unticking the last option on the closing to do recalcuation after closing? If this is not what you mena I think you have misunderstood the reason for about inventory closing...in which case if you dont wnat your inventory value change then dont run inventory closing or recalc... Will wait to hear what you really are trying to do or avoid :) _ From: Axapta-Knowledge-Village@yahoogroups.com [mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of sudeep s gopalkrishnan Sent: 31 March 2009 15:03 To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Inventory recalculation Hi, Can we stop inventory recalculation during Inventory closing process?? Currently in Ax Inventory gets revalued during Inventory closing process -- Warm Regards Sudeep.G
RE: [Axapta-Knowledge-Village] Re: Replacing label file in AX3.0
Thanks Karen, I had the same idea as you to play with the fonts on the buttons but so far no luck :( If it is a font problem I will be stuck with the main menu tabs as there is no font property so not sure how would fix that :(( Thanks again for you help and I will keep trying Anyone else have any ideas for me to explore on why main menu tabs and buttons wont show correctly? I have seen various print screens of AX3.0 with Chinese so it most be possible I just had a thought now as I type this reply ... maybe there is some windows OS font setting that needs to be changed??? Thanks James _ From: Axapta-Knowledge-Village@yahoogroups.com [mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of Karen Sent: 31 March 2009 23:39 To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Re: Replacing label file in AX3.0 i never did manage to resolve the issue with the menu captions and button texts in v3.0. you might want to try experimenting with the font setting on individual menu/button control properties to see if that works as i believe the font settings in the tools options doesn't flow through to all UI elements within the 3.0 application. you're welcome James ;) --- In Axapta-Knowledge- mailto:Axapta-Knowledge-Village%40yahoogroups.com vill...@yahoogroups.com, James Flavell djf1...@... wrote: Thanks Karen once again :) Okay your hint about Tahoma font help solved one problem :) Now the column headings on grids show correctly thanks a lot for that. (Reports seemed to be okay even without Tahoma font set but I of course I have not checked in great detail) But the main menu tabs and buttons still do not show Chinese. Are you saying it is not possible to get these to show in Chinese in AX3.0? Thanks James _ From: Axapta-Knowledge- mailto:Axapta-Knowledge-Village%40yahoogroups.com vill...@yahoogroups.com [mailto:Axapta-Knowledge- mailto:Axapta-Knowledge-Village%40yahoogroups.com vill...@yahoogroups.com] On Behalf Of Karen Sent: 28 March 2009 16:46 To: Axapta-Knowledge- mailto:Axapta-Knowledge-Village%40yahoogroups.com vill...@yahoogroups.com Subject: [Axapta-Knowledge-Village] Re: Replacing label file in AX3.0 hi James AX3.0 uses double-byte and you will not be able to make the labels show up proper characters on the menu items and tab captions and menu item buttons etc, though some of the labels will be ok on the forms and as for data, you need to set the database collation and code page in control panel regional settings and install the ime pack for Chinese. when running the ime, in some cases, the input editor doesn't appear where the mouse focus is so it can be quite annoying to the user. you will also need to change the font in the options to use Tahoma, if i remember correctly, for your reports. after doing all this, i believe some elements of the UI will still show traces of gibberish. i would recommend an upgrade to 4.0 SP1 at the very least in order for your CN application to work as designed.. regards,Karen --- In Axapta-Knowledge- mailto:Axapta-Knowledge-Village%40yahoogroups.com vill...@yahoogroups mailto:Village%40yahoogroups.com .com, James Flavell djf1994@ wrote: Thanks Malcom I did a quick test and seem to be able to move an AX4.0 label file to AX3.0 by deleting the first few characters in the ald file. All seems well :) BUT I realised maybe there is a major flaw in my plan :( ... because the Chinese label file in AX4.0 is I think unicode but I dont think AX3.0 can support this right? If I open the AX4.0 chinese ald file with notepad on my windows xp (which has the east asia fonts installed) I see chinese but when I start up AX3.0 with the same file its just the individual ASCII characters I see :( Is there some startup parameter for AX3.0 I need? Or is it really that Ax4.0 chinese label file is no use to me? Thanks again Malcolm and everyone else for your help I hope I can repay it in the near future James _ From: Axapta-Knowledge- mailto:Axapta-Knowledge-Village%40yahoogroups.com vill...@yahoogroups mailto:Village%40yahoogroups.com .com [mailto:Axapta-Knowledge- mailto:Axapta-Knowledge-Village%40yahoogroups.com vill...@yahoogroups mailto:Village%40yahoogroups.com .com] On Behalf Of Malcolm Burtt Sent: 26 March 2009 21:28 To: Axapta-Knowledge- mailto:Axapta-Knowledge-Village%40yahoogroups.com vill...@yahoogroups mailto:Village%40yahoogroups.com .com Subject: RE: [Axapta-Knowledge-Village] Replacing label file in AX3.0 It's been some time since we looked at this but I'm pretty sure that we exhausted all obvious and easy solutions before resorting to writing the export feature. From: Axapta-Knowledge- mailto:Axapta-Knowledge-Village%40yahoogroups.com vill...@yahoogroups mailto:Village%40yahoogroups.com .com [mailto:Axapta-Knowledge- mailto:Axapta-Knowledge-Village
RE: [Axapta-Knowledge-Village] Re: Replacing label file in AX3.0
Thanks Karen once again :) Okay your hint about Tahoma font help solved one problem :) Now the column headings on grids show correctly thanks a lot for that. (Reports seemed to be okay even without Tahoma font set but I of course I have not checked in great detail) But the main menu tabs and buttons still do not show Chinese. Are you saying it is not possible to get these to show in Chinese in AX3.0? Thanks James _ From: Axapta-Knowledge-Village@yahoogroups.com [mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of Karen Sent: 28 March 2009 16:46 To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Re: Replacing label file in AX3.0 hi James AX3.0 uses double-byte and you will not be able to make the labels show up proper characters on the menu items and tab captions and menu item buttons etc, though some of the labels will be ok on the forms and as for data, you need to set the database collation and code page in control panel regional settings and install the ime pack for Chinese. when running the ime, in some cases, the input editor doesn't appear where the mouse focus is so it can be quite annoying to the user. you will also need to change the font in the options to use Tahoma, if i remember correctly, for your reports. after doing all this, i believe some elements of the UI will still show traces of gibberish. i would recommend an upgrade to 4.0 SP1 at the very least in order for your CN application to work as designed.. regards,Karen --- In Axapta-Knowledge- mailto:Axapta-Knowledge-Village%40yahoogroups.com vill...@yahoogroups.com, James Flavell djf1...@... wrote: Thanks Malcom I did a quick test and seem to be able to move an AX4.0 label file to AX3.0 by deleting the first few characters in the ald file. All seems well :) BUT I realised maybe there is a major flaw in my plan :( ... because the Chinese label file in AX4.0 is I think unicode but I dont think AX3.0 can support this right? If I open the AX4.0 chinese ald file with notepad on my windows xp (which has the east asia fonts installed) I see chinese but when I start up AX3.0 with the same file its just the individual ASCII characters I see :( Is there some startup parameter for AX3.0 I need? Or is it really that Ax4.0 chinese label file is no use to me? Thanks again Malcolm and everyone else for your help I hope I can repay it in the near future James _ From: Axapta-Knowledge- mailto:Axapta-Knowledge-Village%40yahoogroups.com vill...@yahoogroups.com [mailto:Axapta-Knowledge- mailto:Axapta-Knowledge-Village%40yahoogroups.com vill...@yahoogroups.com] On Behalf Of Malcolm Burtt Sent: 26 March 2009 21:28 To: Axapta-Knowledge- mailto:Axapta-Knowledge-Village%40yahoogroups.com vill...@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] Replacing label file in AX3.0 It's been some time since we looked at this but I'm pretty sure that we exhausted all obvious and easy solutions before resorting to writing the export feature. From: Axapta-Knowledge- mailto:Axapta-Knowledge-Village%40yahoogroups.com vill...@yahoogroups.com [mailto:Axapta-Knowledge- mailto:Axapta-Knowledge-Village%40yahoogroups.com vill...@yahoogroups.com] On Behalf Of James Flavell Sent: 26 March 2009 11:54 To: Axapta-Knowledge- mailto:Axapta-Knowledge-Village%40yahoogroups.com vill...@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] Replacing label file in AX3.0 Thanks Malcom I was not aware of the extra characters in the AX4.0 so thanks for that. Could you not just copy and paste from line 2 to the end of teh AX4.0 into a AX3.0 file? Your solution to export and import is something I had not considered and I will for sure email you directly to follow up on that thanks Thank you very much James James Flavell CITP Singapore Pte Ltd Mobile: +65 97582281 Email: d...@... mailto:d...@... COM _ From: Axapta-Knowledge- mailto:Axapta-Knowledge-Village%40yahoogroups.com vill...@yahoogroups.com [mailto:Axapta-Knowledge- mailto:Axapta-Knowledge-Village%40yahoogroups.com vill...@yahoogroups.com] On Behalf Of Malcolm Burtt Sent: 26 March 2009 19:35 To: Axapta-Knowledge- mailto:Axapta-Knowledge-Village%40yahoogroups.com vill...@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] Replacing label file in AX3.0 Hi James I've not done much with the help files but, given the fact that the help format changed between versions 3 and 4 I suspect that there's no chance that you can back port the files between versions. You don't need to worry about the ALT file - so long as you stop all object servers before you start messing with label files then the ALT file will be empty. Sadly, you can't copy the AX 4 label file back to AX 3 (I've tried) as Microsoft have added some extra characters in at the beginning of the file that makes it non-portable (I even tried removing them with no joy). Have you thought about
RE: [Axapta-Knowledge-Village] Re: Error while upgrading
Just to correct you can upgrade any AX3.0 version to AX2009 :) We did an AX3.0 SP2 ... still being checked by the customer but seems pretty decent _ From: Axapta-Knowledge-Village@yahoogroups.com [mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of andras.agocs Sent: 27 March 2009 13:12 To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Re: Error while upgrading Hi, If you have the list of these tables, than you can create an AX export Dat-Def file from AX30, and import it into DAX2009. However, this can work only, if your AX30 is SP6 version. But if Im not wrong, than you can only upgrdae AX30 SP6 only to DAX2009. Best regards, Andras --- In Axapta-Knowledge- mailto:Axapta-Knowledge-Village%40yahoogroups.com vill...@yahoogroups.com, nanukuttan rinish rin_...@... wrote: Hi All, I have a boubt in the AxDbUpgrade tool ... I have upgraded the database...but I have a problem now. I am not able to view any tables in Ax2009 which is upgraded from Ax3.0. The tabels are created in user layer in AX 3.0. But i can view all the other default tabels which ware in AX3.0. Please can anyone suggest me how i can bring those tables into Ax2009. Regards Rinish.N --- On Tue, 24/3/09, nanukuttan rinish rin_...@... wrote: From: nanukuttan rinish rin_...@... Subject: [Axapta-Knowledge-Village] Error while upgrading To: Axapta Axapta-Knowledge- mailto:Axapta-Knowledge-Village%40yahoogroups.com vill...@yahoogroups.com Date: Tuesday, 24 March, 2009, 7:46 PM Hi All, I am trying to upgrade from Ax 3.0 to Ax2009.As a first step I was running the AxDbUpgrade. exe file..But while doing this I got the following errors. SqlState 24000, NativeError 0: [Microsoft][ ODBC SQL Server Driver]Invalid cursor state SqlState 24000, NativeError 0: [Microsoft][ ODBC SQL Server Driver]Invalid cursor state SqlState S0002, NativeError 208: [Microsoft][ ODBC SQL Server Driver][SQL Server]Invalid object name 'UpgradeColumns' . SqlState 37000, NativeError 8180: [Microsoft][ ODBC SQL Server Driver][SQL Server]Statement( s) could not be prepared. Cannot read the list of columns to be upgraded. I am using win2003 server in both the computer where Ax3.0 and Ax2009 are installed. Both AX DataBase are in SQL2005, hosted in two different system inside the n/w and the DB names are AxDB3.0 and AXDB2009. I hope someone would have come across this problem and hoping that you would have fixed it .If so please let me know how to overcome this one ...please help me... Regards Rinish.N Add more friends to your messenger and enjoy! Invite them now. Add more friends to your messenger and enjoy! Go to http://messenger. http://messenger.yahoo.com/invite/ yahoo.com/invite/
RE: [Axapta-Knowledge-Village] Re: Error while upgrading
Hi Jens, I dont think we had any Virutal companies (it was 2 live companies plus 1 or 2 compies of these) and also not sure how much any address info apart from on the customer and vendor master records was setup. Seems to be several have mentioned issues on the address book part in such upgrades. There was only one bug in the upgrade script we had: Update class/job CustConsistencyCheck_LinkTable on method checkCustInvoiceSalesLink, switch line 82 with 83 and assign InvoiceDate to CustTrans.InvoiceDate at line 84. We were getting error of cannot insert record due to record already existing Thanks James _ From: Axapta-Knowledge-Village@yahoogroups.com [mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of Jens Strandberg Sent: 27 March 2009 23:36 To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] Re: Error while upgrading Hello James, Did you encounter any issues with the Upgrade List in Ax2009 ? We are upgrading from Ax3SP4. We are using 10 different virtual companies, and once you do a Validate Address Book, X++ will throw an error saying that a certain DictTable is not initialized. Anyone using vc's that have had similar problems ? Thanks. /Jens _ From: Axapta-Knowledge-Village@yahoogroups.com [mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of James Flavell Sent: Friday, March 27, 2009 2:47 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] Re: Error while upgrading Just to correct you can upgrade any AX3.0 version to AX2009 :) We did an AX3.0 SP2 ... still being checked by the customer but seems pretty decent _ From: Axapta-Knowledge-Village@yahoogroups.com [mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of andras.agocs Sent: 27 March 2009 13:12 To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Re: Error while upgrading Hi, If you have the list of these tables, than you can create an AX export Dat-Def file from AX30, and import it into DAX2009. However, this can work only, if your AX30 is SP6 version. But if Im not wrong, than you can only upgrdae AX30 SP6 only to DAX2009. Best regards, Andras --- In Axapta-Knowledge- mailto:Axapta-Knowledge-Village%40yahoogroups.com vill...@yahoogroups.com, nanukuttan rinish rin_...@... wrote: Hi All, I have a boubt in the AxDbUpgrade tool ... I have upgraded the database...but I have a problem now. I am not able to view any tables in Ax2009 which is upgraded from Ax3.0. The tabels are created in user layer in AX 3.0. But i can view all the other default tabels which ware in AX3.0. Please can anyone suggest me how i can bring those tables into Ax2009. Regards Rinish.N --- On Tue, 24/3/09, nanukuttan rinish rin_...@... wrote: From: nanukuttan rinish rin_...@... Subject: [Axapta-Knowledge-Village] Error while upgrading To: Axapta Axapta-Knowledge- mailto:Axapta-Knowledge-Village%40yahoogroups.com vill...@yahoogroups.com Date: Tuesday, 24 March, 2009, 7:46 PM Hi All, I am trying to upgrade from Ax 3.0 to Ax2009.As a first step I was running the AxDbUpgrade. exe file..But while doing this I got the following errors. SqlState 24000, NativeError 0: [Microsoft][ ODBC SQL Server Driver]Invalid cursor state SqlState 24000, NativeError 0: [Microsoft][ ODBC SQL Server Driver]Invalid cursor state SqlState S0002, NativeError 208: [Microsoft][ ODBC SQL Server Driver][SQL Server]Invalid object name 'UpgradeColumns' . SqlState 37000, NativeError 8180: [Microsoft][ ODBC SQL Server Driver][SQL Server]Statement( s) could not be prepared. Cannot read the list of columns to be upgraded. I am using win2003 server in both the computer where Ax3.0 and Ax2009 are installed. Both AX DataBase are in SQL2005, hosted in two different system inside the n/w and the DB names are AxDB3.0 and AXDB2009. I hope someone would have come across this problem and hoping that you would have fixed it .If so please let me know how to overcome this one ...please help me... Regards Rinish.N Add more friends to your messenger and enjoy! Invite them now. Add more friends to your messenger and enjoy! Go to http://messenger. http://messenger.yahoo.com/invite/ yahoo.com/invite/
RE: [Axapta-Knowledge-Village] Consolidated Sales Orders
You can use the cross reference in the shipment template filter I believe _ From: Axapta-Knowledge-Village@yahoogroups.com [mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of edwardjosling Sent: 26 March 2009 16:49 To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Consolidated Sales Orders Hi All We have the following requirement: We need to consolidate the pick, pack and delivery functions for sales orders with the same delivery address. We are looking at the shipment functionality, to group orders together, but it is obvious that this does not cater for this specific scenario, i.e. we need some modification to the shipment template to use the delivery name on the sales header/line for automatic addition to the shipment. Has anyone encounter a similar requirement? We want to use standard Ax as much as possible. We use AX2009. Thanks Eddie
RE: [Axapta-Knowledge-Village] Replacing label file in AX3.0
Thanks Malcom I was not aware of the extra characters in the AX4.0 so thanks for that. Could you not just copy and paste from line 2 to the end of teh AX4.0 into a AX3.0 file? Your solution to export and import is something I had not considered and I will for sure email you directly to follow up on that thanks Thank you very much James James Flavell CITP Singapore Pte Ltd Mobile: +65 97582281 Email: d...@sg.columbusit.com _ From: Axapta-Knowledge-Village@yahoogroups.com [mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of Malcolm Burtt Sent: 26 March 2009 19:35 To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] Replacing label file in AX3.0 Hi James I've not done much with the help files but, given the fact that the help format changed between versions 3 and 4 I suspect that there's no chance that you can back port the files between versions. You don't need to worry about the ALT file - so long as you stop all object servers before you start messing with label files then the ALT file will be empty. Sadly, you can't copy the AX 4 label file back to AX 3 (I've tried) as Microsoft have added some extra characters in at the beginning of the file that makes it non-portable (I even tried removing them with no joy). Have you thought about creating a version 3 format XPO from AX 4 containing all the labels instead and then importing that into version 3? You'll need to write some code to generate that (or email me direct as I have already done this) but it's a relatively simple process and makes moving labels from AX 4 to AX 3 really easy. Malcolm Burtt Touchstone Group People - Partnership - Solutions Malcolm From: Axapta-Knowledge-Village@yahoogroups.com [mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of James Flavell Sent: 26 March 2009 02:33 To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Replacing label file in AX3.0 Hi everyone I want to setup a Chinese label file and use in AX3.0 My understanding is I can take one of the existing label files that I dont use and put Chinese words in it and then just rename the label file to a spare language I have in my license Example: Copy en-us ald file Translate Rename translated ald to en-gb (en-gb is my spare language in my license) Start AX with en-gb as the language Apart from the ald is there other files that need translation? I can see there are other files but believe I do not need to do anything to them: ALT - Temp labels AHD - Online Help Data File KHD - Kernel Help Data File. This one I am not sure...if this is not translated it means kernel errors etc will still be in English is it? ADD - Developer Help File Has anyone tried taking the AX4/2009 chinese label files and rename and put in AX3.0. Is it possible? Is there a lot of rework required due to different label ids etc? Could the same be done for the AHD,KHD and ADD files from AX4/2009? Thanks again everyone James
[Axapta-Knowledge-Village] Fixed rate for onaccount lines in project invoicing
Hi everyone once again I have query as to whether anyone has done the following before: On Project OnAccount lines to have a field to specify the excahnge rate to use when posting invoice for that line. The reason is because we want to invoice a deposit invoice at a certain rate and then later at the final billing reverse this invoice. The problem is if it is foreign currency and in different months then the base amount reversed will not match the original. We do not want to set a fixed rate for all the onaccount lines just certain ones and when we do invocing we will only be invoicing one line at a time so there is no issue of mixed exchange rates on the same invoice I am guessing this might be easily done but not familiar with the project invoice posting so not sure where to start Thanks for any help or hints where to start looking James
RE: [Axapta-Knowledge-Village] Replacing label file in AX3.0
Thanks Malcom I did a quick test and seem to be able to move an AX4.0 label file to AX3.0 by deleting the first few characters in the ald file. All seems well :) BUT I realised maybe there is a major flaw in my plan :( ... because the Chinese label file in AX4.0 is I think unicode but I dont think AX3.0 can support this right? If I open the AX4.0 chinese ald file with notepad on my windows xp (which has the east asia fonts installed) I see chinese but when I start up AX3.0 with the same file its just the individual ASCII characters I see :( Is there some startup parameter for AX3.0 I need? Or is it really that Ax4.0 chinese label file is no use to me? Thanks again Malcolm and everyone else for your help I hope I can repay it in the near future James _ From: Axapta-Knowledge-Village@yahoogroups.com [mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of Malcolm Burtt Sent: 26 March 2009 21:28 To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] Replacing label file in AX3.0 It's been some time since we looked at this but I'm pretty sure that we exhausted all obvious and easy solutions before resorting to writing the export feature. From: Axapta-Knowledge-Village@yahoogroups.com [mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of James Flavell Sent: 26 March 2009 11:54 To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] Replacing label file in AX3.0 Thanks Malcom I was not aware of the extra characters in the AX4.0 so thanks for that. Could you not just copy and paste from line 2 to the end of teh AX4.0 into a AX3.0 file? Your solution to export and import is something I had not considered and I will for sure email you directly to follow up on that thanks Thank you very much James James Flavell CITP Singapore Pte Ltd Mobile: +65 97582281 Email: d...@sg.columbusit. mailto:d...@sg.columbusit.com COM _ From: Axapta-Knowledge-Village@yahoogroups.com [mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of Malcolm Burtt Sent: 26 March 2009 19:35 To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] Replacing label file in AX3.0 Hi James I've not done much with the help files but, given the fact that the help format changed between versions 3 and 4 I suspect that there's no chance that you can back port the files between versions. You don't need to worry about the ALT file - so long as you stop all object servers before you start messing with label files then the ALT file will be empty. Sadly, you can't copy the AX 4 label file back to AX 3 (I've tried) as Microsoft have added some extra characters in at the beginning of the file that makes it non-portable (I even tried removing them with no joy). Have you thought about creating a version 3 format XPO from AX 4 containing all the labels instead and then importing that into version 3? You'll need to write some code to generate that (or email me direct as I have already done this) but it's a relatively simple process and makes moving labels from AX 4 to AX 3 really easy. Malcolm Burtt Touchstone Group People - Partnership - Solutions Malcolm From: Axapta-Knowledge-Village@yahoogroups.com [mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of James Flavell Sent: 26 March 2009 02:33 To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Replacing label file in AX3.0 Hi everyone I want to setup a Chinese label file and use in AX3.0 My understanding is I can take one of the existing label files that I dont use and put Chinese words in it and then just rename the label file to a spare language I have in my license Example: Copy en-us ald file Translate Rename translated ald to en-gb (en-gb is my spare language in my license) Start AX with en-gb as the language Apart from the ald is there other files that need translation? I can see there are other files but believe I do not need to do anything to them: ALT - Temp labels AHD - Online Help Data File KHD - Kernel Help Data File. This one I am not sure...if this is not translated it means kernel errors etc will still be in English is it? ADD - Developer Help File Has anyone tried taking the AX4/2009 chinese label files and rename and put in AX3.0. Is it possible? Is there a lot of rework required due to different label ids etc? Could the same be done for the AHD,KHD and ADD files from AX4/2009? Thanks again everyone James
[Axapta-Knowledge-Village] Replacing label file in AX3.0
Hi everyone I want to setup a Chinese label file and use in AX3.0 My understanding is I can take one of the existing label files that I dont use and put Chinese words in it and then just rename the label file to a spare language I have in my license Example: Copy en-us ald file Translate Rename translated ald to en-gb (en-gb is my spare language in my license) Start AX with en-gb as the language Apart from the ald is there other files that need translation? I can see there are other files but believe I do not need to do anything to them: ALT - Temp labels AHD - Online Help Data File KHD - Kernel Help Data File. This one I am not sure...if this is not translated it means kernel errors etc will still be in English is it? ADD - Developer Help File Has anyone tried taking the AX4/2009 chinese label files and rename and put in AX3.0. Is it possible? Is there a lot of rework required due to different label ids etc? Could the same be done for the AHD,KHD and ADD files from AX4/2009? Thanks again everyone James
RE: [Axapta-Knowledge-Village] Microsoft Support Question
Hi Subbu, To be honest I have to agree on the direct MS support/consultanting services...they really know nuts about AX (i.e. still a long way from being a mature AX team). In terms of the front line dev I think that is a different story but I dont believe you will get direct access to them unless your case ends up being very serious and potentially damaging to MS As for fixes in AOD file I agree it can be a nightmare getting specific objects but I can understand from MS point of view why they do it that way rather than individual xpos per hotfix. If you push MS they will attempt to get you the specific objects but it can take a long time and can be quite frustrating. The KB search function also is not great which does not help your own attempts. I would suggest for 60k USD per annum you can get a very good support agreement with a partner, its just a matter of finding the right one. Not sure why you dropped your partner but I believe you can get good value if you find the right partner Of course the partner will probably make use of MS in certain situations (kernel bugs etc) but for sure they should be able to respond much faster and with better understanding and detail in the majority of cases and have other avenues/contacts to use in searching for solutions for you From my experience with supporting customers (including remote support) a serious support agreement between customer and partner should be able to satisfy what you need but the focus of the agreement needs to be clear to both sides (e.g. is it to included technical as well as application and data etc) Since being a partner I am on the other side of the fence if you would like to chat on this topic feel free to look me up on skype djf1994 or send to my gmail Thanks James _ From: Axapta-Knowledge-Village@yahoogroups.com [mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of Subbu Sent: 25 March 2009 06:11 To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Microsoft Support Question Hi, I work for an end client who are using AX3.0. We were trying to get rid of partner and went direct with MS for AX support. For 'Customer' support, they are asking about 60K+USD/annum for 30 hours. Here are my thoughts. 1. MS is always tier1 support. I feel they are one of the dumbest people i ever come across...For example, vendor aging report. Pathetic.. 2. MS support sucks for AX4.0 because of DIS.AOD file. They will not tell us the objects in question for the fix rather they will give the whole AOD file which will have every fix. It takes ages to extract the fix for some of the critical issues 3. Honestly, they are bugs in the system. They should be not charging us for fixing their bugs... 4. Documentation on the issue sucks 5. KB article information on some of the bugs are horrible. 4. I know/dealt with almost all each and every object in axapta... Do you know if we really need to pay 60K for support from MS? It feels to me that a lot of money for the services we get from them. Are there any companies out there that they dont use MS support? I am interested to know... Appreciate any help. Kind regards, Subbu
RE: [Axapta-Knowledge-Village] AX2009 on xp a good idea?
Thanks Malcom, I had not really thought about using VPC for that (had considered running VPC for all the AX bits but concerned with performance etc). Will think about this thanks :) Thanks James _ From: Axapta-Knowledge-Village@yahoogroups.com [mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of Malcolm Burtt Sent: 18 March 2009 18:26 To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] AX2009 on xp a good idea? Hi James I'm pretty sure that SharePoint isn't going to run on XP and you might struggle to get the workflow engine running there too but. .how about installing everything that you can get working directly on XP and then running all the stuff that will only work on a server OS (like SharePoint) within a VPC running on the laptop. You ought to be able to get the stuff installed on the VPC to talk to the AX instance that's running directly on the laptop. Malcolm From: Axapta-Knowledge-Village@yahoogroups.com [mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of James Flavell Sent: 18 March 2009 03:10 To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] AX2009 on xp a good idea? Just wondering if I want the full works of AX2009 (workflow, SSRS, EP etc) is it possible or wise to do it all on an XP machine or should I run W2003 as my OS? This is for a notebook I am guessing getting all the rest of the MS stack such as share point and workflow server etc to run on XP might well be problematic but interested to hear how far can get with just XP Thanks James
RE: [Axapta-Knowledge-Village] Customer self service
Thanks Khaled, Somehow (not really sure how) I managed to get to the product catalogu and Sign up screen but the submit button is not active What I wanted to know was what exact functions are in the customer self service. When I login the roler center I can see in the Sales tab things like quick entry etc is it just whatever is in this section is customer self service? Thanks James _ From: Axapta-Knowledge-Village@yahoogroups.com [mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of Khaled Moustafa Sent: 19 March 2009 14:05 To: Axapta-Knowledge-Village@yahoogroups.com Subject: Re: [Axapta-Knowledge-Village] Customer self service Hello James, The way that you can work with the Customer Self Services is to login in EP with the Guest user, and to login with the Guest user you need to enable this guest user in AX Client, After that when you login to the EP with Guest user all you can see by default is the Products Catalog and a Request page to be a Customer. after you finish the request in the EP site you can see this request and all the requests under the customer self services then sing up form you can find this in enterprise portal in administration. then after that you can complete the full cycle for your customer and send for him/her the user name and password for the request. Hope if this information is help. Best Regards, Khaled _ From: James Flavell djf1...@gmail.com To: Axapta-Knowledge-Village@yahoogroups.com Sent: Wednesday, March 18, 2009 12:48:44 PM Subject: [Axapta-Knowledge-Village] Customer self service Hi everyone, I am wanting to setup the customer self service on the AX2009 RTM VPC. Can anyone guide me or direct me to what setup I need to do as I dont seem to be able to find anything specific to customer self service (plenty of Enterprise portal info but not specific Customer Self Service) Thanks James
[Axapta-Knowledge-Village] Customer self service
Hi everyone, I am wanting to setup the customer self service on the AX2009 RTM VPC. Can anyone guide me or direct me to what setup I need to do as I dont seem to be able to find anything specific to customer self service (plenty of Enterprise portal info but not specific Customer Self Service) Thanks James
RE: [Axapta-Knowledge-Village] Damn TopMargin property has a mind of its own!!!
Thanks Mary Ann, Your idea makes some kind of sense if you look at the report object like a word doc although the part about it automatically changing the value when I look at the object is not like what happens in word. I did notice that if I look at the object using PC with no printer setup I can see the original margin value (such as 0.00mm) but then when I look at it with the PC with printer it is 6.27mm if I go back and look with the PC with no printer then it is back at 0.00mm ... so there is not an actual saved changed happening (hence why there was no USR layer getting created)! The thing to be careful of is that if the object is exported then in the XPO file it takes the value at the time of export!!! So it could be 0.00mm or 6.27mm depending on the client used for the export. Of course when this xpo is imported to another system the value in the file is used and hence a 'saved' change occurs (this was part of the problem as teh dev work was done on a PC with no printer but then the export from dev was being done by a client with printers setup) Still have yet to get to the bottom of the problem so anyone else with any info or ideas please do let me know Thanks James _ From: Axapta-Knowledge-Village@yahoogroups.com [mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of MaryAnn Hand Sent: 16 March 2009 19:21 To: Axapta-Knowledge-Village@yahoogroups.com Subject: Re: [Axapta-Knowledge-Village] Damn TopMargin property has a mind of its own!!! James, I would guess that it is feedback from the printer itself that forces margin settings. For example, in Word, if you set the margins to zero and then try to print to a printer than cannot print close to the paper edge, you get a pop up that says margins are being changed to some non-zero value. As mentioned, this is a guess on my part based on what I have observed in Word. So do not place a lot of confidence in my response. I am an AX developer and I do not see any hard-coding in AX that could be responsible for this behavior. Mary Ann On Mon, Mar 16, 2009 at 4:18 AM, James Flavell djf1...@gmail. mailto:djf1994%40gmail.com com wrote: Hi everyone Just spent most of the day with a strange problem regarding the top margin property on a design section of a report. The situation is: Client PC has no windows printers installed Using this client set the top margin to 4.2mm in an AX4.0 SP2 report Install a pritner on this client PC Log back into AX and when look at the property it is now 6.27mm and cannot be changed to be less (this change happens without any edit of the report object!!!) I am guessing that somehow AX tries to be smart and says the minimum top margin is 6.27mm Is this some kind of hard coded size? Or does AX AOT reports somehow check teh default windows printer?!!! Look forward to hearing from you Thanks James
RE: [Axapta-Knowledge-Village] Damn TopMargin property has a mind of its own!!!
Thanks Malcom Tomorrow I plan to get to the bottom of this (at least know exactly when and what is changing...) Just to point out the margin is not being kept the same as the object in the orginal system AOT. If I export or import with a client PC that has a printer then the margin is going to end up getting set as a different value in the AOT object compared to the original AOT object. I feel the margin should not change because even if I setup a margin that is too small for the printer attached to the client doing the export/import this does not mean this will be the printer the user runs the actual report on and that is the exact problem I have whereby the user tested printing the report with no problem in a test system and then the customer exported and imported into the live and then all of a sudden the report no longer prints correct and of course the customer gets confused and frustrated because the only thing done is export and import etc Thanks James _ From: Axapta-Knowledge-Village@yahoogroups.com [mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of Malcolm Burtt Sent: 17 March 2009 18:03 To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] Damn TopMargin property has a mind of its own!!! Hi James My guess is that AX is picking up the limits of the printable area that your printer supports and enforcing them in your design so that your report doesn't try and render data into a space that your printer can't actually print. Pretty much all printers have some degree of unprintable space on the page but its larger on some than on others. The fact that AX pulls this setting into the design in such a way that, when exported and imported into a system where the default printer has a smaller unprintable area, the margin from your printer is transferred just suggests to me that the assumption is that the report layout worked with that margin and that you'd want to keep that to ensure that the report matched what you saw on the original system. Something of a rambling answer, I know, but hopefully I got the point across. J Regards Malcolm Burtt Touchstone Group People - Partnership - Solutions From: Axapta-Knowledge-Village@yahoogroups.com [mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of James Flavell Sent: 16 March 2009 10:18 To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Damn TopMargin property has a mind of its own!!! Hi everyone Just spent most of the day with a strange problem regarding the top margin property on a design section of a report. The situation is: Client PC has no windows printers installed Using this client set the top margin to 4.2mm in an AX4.0 SP2 report Install a pritner on this client PC Log back into AX and when look at the property it is now 6.27mm and cannot be changed to be less (this change happens without any edit of the report object!!!) I am guessing that somehow AX tries to be smart and says the minimum top margin is 6.27mm Is this some kind of hard coded size? Or does AX AOT reports somehow check teh default windows printer?!!! Look forward to hearing from you Thanks James
RE: [Axapta-Knowledge-Village] Base currency Change
There is a currency conversion script in AX... tried it once in AX3.0 but not a success at all as had some bugs in the code (in the end the customer did not go ahead with teh conversion) Another customer we made a new company of just the master data and then did export of the still open transactions (onhand, AR/AP, ledger balances, sales and purchase orders) etc. Of course any MST field or exchange rate field we had to convert (I think we did in the export so user could check the data in excel before we reimported it) and posted them back into a new company using the journals. This is fairly clean but of course you dont keep the full history of the system and need to program such scripts for the export and import _ From: Axapta-Knowledge-Village@yahoogroups.com [mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of kkthadishetty Sent: 17 March 2009 15:31 To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Base currency Change Hi Everybody, Is any body changed the companies base currency in DAX after having posted transactions and client dealing with multi currencies and updates the exchange rates monthly is it possible? if possible what are all the measure to take care for the posted transactions and open transactions... the best practices from microsoft say not to change the base currency after having transactionsin any quick ideas and suggestions... thanks in advance.. regards
[Axapta-Knowledge-Village] AX2009 on xp a good idea?
Just wondering if I want the full works of AX2009 (workflow, SSRS, EP etc) is it possible or wise to do it all on an XP machine or should I run W2003 as my OS? This is for a notebook I am guessing getting all the rest of the MS stack such as share point and workflow server etc to run on XP might well be problematic but interested to hear how far can get with just XP Thanks James
[Axapta-Knowledge-Village] Damn TopMargin property has a mind of its own!!!
Hi everyone Just spent most of the day with a strange problem regarding the top margin property on a design section of a report. The situation is: Client PC has no windows printers installed Using this client set the top margin to 4.2mm in an AX4.0 SP2 report Install a pritner on this client PC Log back into AX and when look at the property it is now 6.27mm and cannot be changed to be less (this change happens without any edit of the report object!!!) I am guessing that somehow AX tries to be smart and says the minimum top margin is 6.27mm Is this some kind of hard coded size? Or does AX AOT reports somehow check teh default windows printer?!!! Look forward to hearing from you Thanks James
RE: [Axapta-Knowledge-Village] AX 2009 SP1 Project Server Integration Issue
I heard from my colleague who tried to help MS get it working for a demo to partners that they could not so if anyone out there managed to get it to work do let us know _ From: Axapta-Knowledge-Village@yahoogroups.com [mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of mohit rajvanshy Sent: 14 March 2009 08:05 To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] AX 2009 SP1 Project Server Integration Issue Hi All, I'm trying to use the project server and AX integration on MS AX 2009 VPC Image. The prerequisite for integration is already setup at image there is one project which was available with OOB image and had integration with project server. But I'm not able to synchronize any new items on image even not able to refresh the already integrated project to project server. The changes we performed on the OOB image are: 1.Installed the AX 2009 SP1 2.Installed .Net Framework 3.5 SP1 3.Removed the Payroll module (SL2.AOD) 4.Deployed Timesheet module (SL1.AOD) Apart from these changes I have not done any specific installation. The synchronization proxy account is setup synchronization service is also running. I'm able to see the items in synchronization service queue manager, but the transaction status is not changing from waiting to completed and nothing is happening after this step. I'm also running an empty batch job in AX before starting the transaction. I tried downloading the AX 2009 SP1 MS image and doing the same at there but not able to succeed there as well. The integration transaction is not completing getting the authorization error when I checked the windows application event viewer. Could anyone guide me on the same? Thanks in advance!! Regards,Mohit Regards Mohit Rajvanshy
RE: [Axapta-Knowledge-Village] InventTrans
These are all linked to inventory closing (or adjustment) They get updated after closing has been run. Since your inventrtrans got split this usually happens when you do onhand (and also probably transction) adjustment. The system has to close of the qty it knows is settled to issues and then the rest it can apply the adjustment too. There is no issue with split inventtrrans in AX Play around with before and after recalc and closing to see. Its fairly stright forward once you realise what AX does in the closing James _ From: Axapta-Knowledge-Village@yahoogroups.com [mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of anton_tjiptadi Sent: 10 March 2009 23:45 To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] InventTrans Hello, need more info on InventTrans table. There are fields : - QtySettled - CostAmountSettled - ValueOpen What are exactly those fields for? On what actions does these fields usually updated? I have one weird transaction, my PO already invoiced and it has only 1 item for qty 376.50 (stated in PO lines and invoice), postin ginvoice one time only, not partial. But when I check to InventTrans there are 2 transaction (2 records) each with qty, 143.9 and 1026.1, the first one with those above fields updated and the second record with those above fields empty. Both status are Purchased. I don't know where this transaction come from and how to fixed it? and is it related to those field, which is one is filled, one empty? Thanks in advance, Anton
RE: [Axapta-Knowledge-Village] Re: Inventory Items Price Settlements.
There is methods to adjust cost price: Inventory / Periodic / Closing and adjustment. Do either on hand adjustment or transaction adjustment Just be aware onhand adjustment is done based on your last closing date and not on the current date _ From: Axapta-Knowledge-Village@yahoogroups.com [mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of Khalil Rehman Sent: 11 March 2009 13:23 To: Knowlege Village Subject: RE: [Axapta-Knowledge-Village] Re: Inventory Items Price Settlements. Dear Tim, this idea can work. i was thinking may be there is some other method to adjust the cost price. thanks for your support. regards http://graphics.hotmail.com/i.p.emrose.gif KHALIL UR REHMAN http://graphics.hotmail.com/i.p.emrose.gif _ To: Axapta-Knowledge-Village@yahoogroups.com From: timothy.r...@sbcglobal.net Date: Tue, 10 Mar 2009 11:50:27 + Subject: [Axapta-Knowledge-Village] Re: Inventory Items Price Settlements. Khalil, I don't see wy you can't use the IMJ. Just adjest 1 out at $10.00 and adjust one back in at $11.00. The results are cost has changed but quantity remains the same. Tim --- In Axapta-Knowledge- mailto:Axapta-Knowledge-Village@yahoogroups.com vill...@yahoogroups.com, Naeem Sarwar mnaeemsar...@... wrote: Khalil, The situation is you have been closing your financial periods but not inventories. now at the year end you are in this situation that you need to adjust the cost prices. which i don't understand why? I think closing inventory using FIFO must solve your problem or open month one by one and close inventory monthly basis to get the correct figures... Any input would be highly appreciated. BR NS On Mon, Mar 9, 2009 at 5:06 PM, Khalil Rehman khalilrehm...@...wrote: Dear Deepak, thanks for your reply, but in IMJ we can adjust the price with increase/decrease the quantity. but i need, only adjust the Cost Price of Items physically available. can you give me idea about this. how to handle. thanks regards. *KHALIL UR REHMAN * -- To: Axapta-Knowledge- mailto:Axapta-Knowledge-Village@yahoogroups.com vill...@yahoogroups.com From: deep19762...@... Date: Mon, 9 Mar 2009 16:40:55 +0530 Subject: Re: [Axapta-Knowledge-Village] Inventory Items Price Settlements. It can be done through Inventory Movement Journal wherein you can give details about item based on item dimensions. -- *From:* Khalil Rehman khalilrehm...@... *To:* Knowlege Village axapta-knowledge- mailto:axapta-knowledge-village@yahoogroups.com vill...@yahoogroups.com *Sent:* Monday, 9 March, 2009 11:36:18 AM *Subject:* [Axapta-Knowledge-Village] Inventory Items Price Settlements. Dear All, if i want to adjust Cost Price Per Dimension manually. so how can i increase or decrease the Cost Price. thanks regards. *KHALIL UR REHMAN * -- Get news, entertainment and everything you care about at Live.com. Check it out! http://www.live. http://www.live.com/getstarted.aspx com/getstarted.aspx -- Add more friends to your messenger and enjoy! Invite them now.http://in.rd. http://in.rd.yahoo.com/tagline_messenger_6/*http://messenger.yahoo.com/invi te/ yahoo.com/tagline_messenger_6/*http://messenger.yahoo.com/invite/ -- Extend your network, join the Microsoft Dynamics AX Knowledge Village at LINKEDIN ! http://www.linkedin http://www.linkedin.com/e/gis/165338 .com/e/gis/165338 -- -- Get news, entertainment and everything you care about at Live.com. Check it out! http://www.live. http://www.live.com/getstarted.aspx com/getstarted.aspx _ check out the rest of the Windows LiveT. More than mail-Windows LiveT goes way beyond your inbox. More than messages http://www.microsoft.com/windows/windowslive/
RE: [Axapta-Knowledge-Village] Create index with first column not dataareaid
I would double check why is recalc/closing looking at custpackingslipjour. As far as I am aware the std closing should not look at this table table so I would be a little careful...although I guess you can add the index and see but to me I would not expect any improvement in the recalc or closing _ From: Axapta-Knowledge-Village@yahoogroups.com [mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of Agus Riyadi Sent: 05 March 2009 11:33 To: Axapta-Knowledge-Village@yahoogroups.com Subject: Re: [Axapta-Knowledge-Village] Create index with first column not dataareaid Hi Varden, Thanks for input. This comes from the profiler file during inventory recalculation process, so less likely that I will change the standard code. I will only add index from the DTA's recommendation. I think we need to concern the column order as suggested by DTA because otherwise the index will not be used and only makes additional write overhead. So we can't do anything for this kind of suggestion, can we? Just FYI, I have a client who runs recalculation for long hours (20 + hours). The only possibility is to tune the index because disk configuration (RAID etc.) will not be change in the near future. Thanks and best regards, Agus On Thu, Mar 5, 2009 at 12:04 AM, Varden Morris vard...@yahoo. mailto:vard...@yahoo.com com wrote: You are right about the DataAreaId being added to the index by the kernel. I am not sure that you need to concern yourself about the order of the fields as suggested in the backend but you need to ensure that any query coming from AX should have the fields listed in the WHERE clause in the order in which they are listed in the index. In the case below, if there is an index with the SalesId and RecId listed in that order then you should ensure that all queries sent to the database, that will possible use this index, have the fields in the WHERE clause listed in the same order. CustPackingSlipJour : salesid asc, dataareaid asc, recid asc. Varden Morris Varalth Solutions Inc. 693 Abbottsfield Road NW Edmonton, Alberta T5W 4R4 Canada (780) 752-0406 www.varalth. http://www.varalth.com/ com CONFIDENTIALITY NOTICE This message and any attachments are confidential. If you have received this transmission in error, please be advised that any disclosure, copying, distribution or action taken in reliance upon this communication is strictly prohibited. If you have received this communication in error, please contact the sender immediately. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company. Finally, the recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. _ From: Agus Riyadi agusa...@gmail. mailto:agusa...@gmail.com com To: axapta-knowledge-village Axapta-Knowledge- mailto:Axapta-Knowledge-Village@yahoogroups.com vill...@yahoogroups.com Sent: Wednesday, March 4, 2009 12:27:29 AM Subject: [Axapta-Knowledge-Village] Create index with first column not dataareaid Dear all, Using sql server database engine tuning advisor, I got a recommendation to add new index with the following scheme : CustPackingSlipJour : salesid asc, dataareaid asc, recid asc. Is it possible to achieve that in Ax ? As far as I know Ax always add dataareaid column as the first column of any index created from AOT. Thanks and best regards, Agus