Re: [Axapta-Knowledge-Village] Dynamic x++ query problem
Hi Srinath, Seems that dynamically generated query is having some issue and its not gettting exected. Can u share the customization related to query generation logic, this will help getting upto exect issue. Regards, Nitesh Ranjan --- On Mon, 5/10/10, srinath s s_shreen...@yahoo.co.in wrote: From: srinath s s_shreen...@yahoo.co.in Subject: [Axapta-Knowledge-Village] Dynamic x++ query problem To: development-axa...@yahoogroups.com, Axapta-Knowledge-Village@yahoogroups.com Date: Monday, May 10, 2010, 10:20 AM Hi folks, I have done some customization in which doing dynamic query generation. Now i am getting the following error message. Stack trace: The operation that you are performing generates a SQL statement that contains too many nested statements. Break the operation into multiple parts, and try again. (C)\Classes\ QueryRun\ next Could anybody help on this. Otherthan changing the existing code for generating the dynamic query, Is it possible to fix with other way. Waiting for a response. Regards, Srinath. S
Re: [Axapta-Knowledge-Village] How to Increase decimals of purchprice and line amount to 5 places
This is handled using Desimal field in Unit Form. You need to set the desimals on Units to - Specify the number of decimals for the stock-keeping unit to display. Please check and let me know, if it works for your issue. Regards, Nitesh Ranjan --- On Wed, 5/5/10, nahid nahidan...@yahoo.co.in wrote: From: nahid nahidan...@yahoo.co.in Subject: [Axapta-Knowledge-Village] How to Increase decimals of purchprice and line amount to 5 places To: Axapta-Knowledge-Village@yahoogroups.com Date: Wednesday, May 5, 2010, 5:34 PM Hi All, For the Purchase module we need to increse the purchprice and line amount feilds decimals to 5 decimals. I know we can change the EDT's noof decimals property to 5. But how can we ensure the calculations will happen correctly. I know there are many classes and methods involved here. Is there any other way to handle this. Your help is much appreciated. Thanks Farheen
Re: [Axapta-Knowledge-Village] On hand
Invent OnHand is having InventDim as its datasource Create a display method at InventDim table level and show this display method on the form. Regards, Nitesh Ranjan --- On Wed, 5/5/10, axaeffect axaeff...@yahoo.com.sg wrote: From: axaeffect axaeff...@yahoo.com.sg Subject: [Axapta-Knowledge-Village] On hand To: Axapta-Knowledge-Village@yahoogroups.com Date: Wednesday, May 5, 2010, 2:30 PM Hi all, I've modified table InventBatch to add new column. You know the information in Inventory On hand (Path : Inventory management/Item, button Onhand). Lets say I choose to display inventory dimension batch number and want to display also the new column that I added. I've add some display method in Form InventOnHandItem but not getting the correct info. What step should I do? Thanks, Axl
Re: [Axapta-Knowledge-Village] Query regarding company and user rights
Create User Group Create Domain for group of compnaies and assign Domain to User Group Regards, Nitesh Ranjan --- On Thu, 4/22/10, ROHIT JOSHI azurear...@yahoo.co.in wrote: From: ROHIT JOSHI azurear...@yahoo.co.in Subject: [Axapta-Knowledge-Village] Query regarding company and user rights To: Axapta-Knowledge-Village@yahoogroups.com, axapta knowledge village Axapta-Knowledge-Village@yahoogroups.com Date: Thursday, April 22, 2010, 11:02 PM Hi all, i have a query, my company is having multiple company in Microsoft Dynamics AX, and we have to give fe company rights to few user and few other company rights to remaining user; for e.g: we have three company c1, c2, c3. and 3 users u1, u2, u3. how can i give rights in following way, u1 - rights for c1, c2, c3. u2 rights for just c1. and u3 rights for c2, c3. and i want, even at the bottom right of the AX 2009 screen where select company account is there, there also it should show only relevant company eg: for u2 its should show only company c1, and no athore company to select for. -- With Regards Rohit Joshi 00 968 92321969 (@ OMAN)
Re: [Axapta-Knowledge-Village] Ax2009 Upgrade Issue
Hi Pankaj, My take on this issue. Stop the Presynch process and restart AX AOS and restart the Presynch process. Let me know if it works. Regards, Nitesh Ranjan --- On Wed, 2/24/10, Pankaj Kant pankaj_k...@infosys.com wrote: From: Pankaj Kant pankaj_k...@infosys.com Subject: [Axapta-Knowledge-Village] Ax2009 Upgrade Issue To: Axapta-Knowledge-Village@yahoogroups.com Axapta-Knowledge-Village@yahoogroups.com Date: Wednesday, February 24, 2010, 6:33 PM Hi Every One We are upgrading Ax4.0 Sp1 instance to Ax 2009.I completed Application upgrade. Now I am stuck in DB upgrade ,presynch step(After 11 % completion ,its not proceeding further), I don’t Have any idea why it is not going ahead Please find below the steps which I had done so far : 1)Installed Ax 2009 (Pointed to Ax 4.0 DB ,service is not started at this point). 2)Installed Ax 2009 Sp1(service is not started at this point) 3)Copied the upgraded aods 4)Started the service 5)Completed the steps in Upgrade Check list till Presynch... There are around 214 jobs in Presynch ,but after the 25th job its not proceeding and its not showing any error also..remaining jobs are moving to 'Waiting' status. I request the group members to throw some light on this issue Thanks in Advance Pankaj
[Axapta-Knowledge-Village] List od Warehouse on Alt - Address form when opened POLine - Setup - Alt Address
Hi All, I have an observation in AX 2009 Std. 1)Log in to AX 2009 2)Go to AP 3)Create a PO Header 4)Create a PO Line (enter Item, Qty, Warehouse (Inventory Dimension)) 5)Click PO Line - Setup (button) - Alt Address (option) 6)Alt Address form open up 7)Verify the data in Warehouse Tab Grid My observation is that, this Alt Address form is not showing all Warehouse, whereas it shows Warehouse in PO Line and all Warehouses created after that.. I need to know, what is the significance of this functionality. Such behaviour is not there in AX 40. Any light to understand this functional requirement of this feature will help me lot. Please accept Thanks in advance for your any replies. Regards, Nitesh Ranjan
Re: [Axapta-Knowledge-Village] AX4.01 -AX2009 Data Upgrade
Thanks for the information... Its working now!! :D --- On Thu, 6/18/09, Nitesh niteshs...@gmail.com wrote: From: Nitesh niteshs...@gmail.com Subject: Re: [Axapta-Knowledge-Village] AX4.01 -AX2009 Data Upgrade To: Axapta-Knowledge-Village@yahoogroups.com Date: Thursday, June 18, 2009, 12:29 AM Hi Nitesh R Possible cause #1: The batch server defined for running the upgrade job is not running. Solution: Open the Server configuration form (Administration Setup Server configuration) . Verify that Is Batch Server is marked for the AOS instance that is running the upgrade. Possible cause #2: The DataUpgrade batch group is not a selected group for the AOS instance that is running the ugprade. Solution: Open the Server configuration form (Administration Setup Server configuration) . On the Batch server groups tab, verify that DataUpdate batch group is listed in the Selected groups list. Regards Nitesh S On Wed, Jun 17, 2009 at 11:24 PM, Nitesh Ranjan niteshranjan007@ yahoo.com wrote: Hi All, Hope many of us have completed Data upgrades fron AX 4.01 to AX 2009. It will appreciated to we share the total time taken to complete the Data upgrade. We are doing Data upgrade from AX 4.01 to AX 2009. Our data size is 1GB We are having Vista Machine with 2GB RAM Pre synchronization is running and it is running since 100Hrs and yet not complete, is it normal or its abnormal behavior of the system?. Please share views. Regards, Nitesh Ranjan
[Axapta-Knowledge-Village] AX4.01 -AX2009 Data Upgrade
Hi All, Hope many of us have completed Data upgrades fron AX 4.01 to AX 2009. It will appreciated to we share the total time taken to complete the Data upgrade. We are doing Data upgrade from AX 4.01 to AX 2009. Our data size is 1GB We are having Vista Machine with 2GB RAM Pre synchronization is running and it is running since 100Hrs and yet not complete, is it normal or its abnormal behavior of the system?. Please share views. Regards, Nitesh Ranjan
[Axapta-Knowledge-Village] Grid on EP WebForm not working
Hi All, I have one issue with my EP WebForm: My scenario is: 1) I have created a Web form 2) with Sales Line and InventDim as Data source 3) and displayed following fields in the Grid SalesLine.SalesId SalesLine.ItemId SalesLine.SalesQty InventDim.InventSizeId inventDim.InventColorId And SalesLine.LineAmount 4) My Sales line is having 20 lines So what happens.. 10 Lines are shown on the first display page 5) Using Grid Navigator when I go to next page for next 10 records then there is a issue 6) I find 11th record is having same InventColorId and InventSizeId as first record Please let me know if any of us have seen this issue and possible solution will be appreciated. Regards, Nitesh Ranjan
Re: [Axapta-Knowledge-Village] Report error
Whenever u create a report and run it on report dialog box u get two tabs General and Batch. Use Batch tab to setup the automatic execution of report as per frequency u want. Regards Nitesh Ranjan --- On Tue, 7/1/08, asit nayak [EMAIL PROTECTED] wrote: From: asit nayak [EMAIL PROTECTED] Subject: [Axapta-Knowledge-Village] Report error To: [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED], axapta-knowledge-village@yahoogroups.com Date: Tuesday, July 1, 2008, 5:12 PM Hi All, I have a report where i need to run this report automatically on everyday on a specific time. Please let me know how can i run the report automatically on every day. Thanks Asit
Re: [Axapta-Knowledge-Village] Product Builder
For this you need to create PBA Variable for second field and use first variable to create Query for second variable. Hope this idea will work! Craig Fidler [EMAIL PROTECTED] wrote: Hi All, I need a helping hand with regards to Product Builder. I am running Ax4 Sp1,. How do I restrict a user to a selection of records based in a prior selection. E.g. I choose a textile lamp shade the I can only choose red blue or green for the colours. Regards, Craig [Non-text portions of this message have been removed] - Yahoo! oneSearch: Finally, mobile search that gives answers, not web links. [Non-text portions of this message have been removed]
Re: [Axapta-Knowledge-Village] Error in SSRS configuration in Dynamics Ax 4.0: Report folder does not exist.
Hi, Yes it is required to create 'Dynamics' folder in http://localhost/reports . It is very ok what http://localhost/ReportServer is displaying for you. As u have not mentioned what the new error your are getting, if I can anticipate what error you getting, is it realted to Dynamics DataSource not found, like?? if yes then you need to create a new datasource within Dyanamics folder. you know it all gets created automatically if u may have set the reporting services up before installing Dynamics Ax Reproting services component. Hope all this help you Regards Abdul Kadar [EMAIL PROTECTED] wrote: Hi Nitesh, Thanks for your reply. But still I am facing the same problem. I created a new folder called 'Dynamics' in http://localhost/Reports portal. Is this the one you mentioned? I tried the other portal too, http://localhost/ReportServer portal, but i dint get any links or buttons other than the version information. Any other configuration do we need to alter? Thanks in advance Abdul Nitesh Ranjan [EMAIL PROTECTED] wrote: You need to create 'Dynamics' folder in Reporting Services Report Manager Portal... Abdul Kadar [EMAIL PROTECTED] wrote: Hi, I am using Dynamics Axapta 4.01 with SQL Server 2005 (all components) installed. When I am configuring Ax for Reporting Services, in the Advanced tab of the Reporting Servers main form, we have to enter the folder name to store SSRS reports and configuration. By default, the folder 'Dynamics' is coming, where do we need to create this folder in the system. I created in the IIS - ReportServers - Virtual directory as Dynamics, but I am getting the following error: The supplied report folder does not exist. Can anyone help me, where to create this folder and how to configure this folder for ReportServers? I am using Win XP and referring a domain. I have installed the database server in the same XP system for testing purpose. Any help would be greatly appreciated. Thanks in advance. Abdul - Looking for a deal? Find great prices on flights and hotels with Yahoo! FareChase. [Non-text portions of this message have been removed] - Choose the right car based on your needs. Check out Yahoo! Autos new Car Finder tool. [Non-text portions of this message have been removed] - Take the Internet to Go: Yahoo!Go puts the Internet in your pocket: mail, news, photos more. [Non-text portions of this message have been removed] - Be a better Globetrotter. Get better travel answers from someone who knows. Yahoo! Answers - Check it out. [Non-text portions of this message have been removed]
Re: [Axapta-Knowledge-Village] Error in SSRS configuration in Dynamics Ax 4.0: Report folder does not exist.
You need to create 'Dynamics' folder in Reporting Services Report Manager Portal... Abdul Kadar [EMAIL PROTECTED] wrote: Hi, I am using Dynamics Axapta 4.01 with SQL Server 2005 (all components) installed. When I am configuring Ax for Reporting Services, in the Advanced tab of the Reporting Servers main form, we have to enter the folder name to store SSRS reports and configuration. By default, the folder 'Dynamics' is coming, where do we need to create this folder in the system. I created in the IIS - ReportServers - Virtual directory as Dynamics, but I am getting the following error: The supplied report folder does not exist. Can anyone help me, where to create this folder and how to configure this folder for ReportServers? I am using Win XP and referring a domain. I have installed the database server in the same XP system for testing purpose. Any help would be greatly appreciated. Thanks in advance. Abdul - Looking for a deal? Find great prices on flights and hotels with Yahoo! FareChase. [Non-text portions of this message have been removed] - Choose the right car based on your needs. Check out Yahoo! Autos new Car Finder tool. [Non-text portions of this message have been removed]
Re: [Axapta-Knowledge-Village] Pop ups on Alert Rule
maan, replying for your second query... you need to be technical to delete the Financial dimension. try consulting any technical.. One thing you can do... Compile whole AOT, and synchronize table... may help you if you realy have deleted all related data in the tables and Enums... Regards Kapil Khanna [EMAIL PROTECTED] wrote: Hi everybody can somebody please explain me how to get pop ups using alert rule. I have created Alert rule for example on change of shipment date on SO and i have activated on alert options Pop Up but after chnaging i dont get the same. My second query is just imagine in Ax 4.0 i created a new financial dimension using wizard then how can i delete it. I deleted it from data dictionary and base enum sysdim still i can see all the newly created dimensions on form. Not being a technical, this is bugging me a lot. Thanks and Regards Kapil Khanna - Be a better Globetrotter. Get better travel answers from someone who knows. Yahoo! Answers - Check it out. [Non-text portions of this message have been removed] - Shape Yahoo! in your own image. Join our Network Research Panel today! [Non-text portions of this message have been removed]
Re: [Axapta-Knowledge-Village] Delete alerts
Hi Siva, Try Deleting Data in table using following option Administration - Periodic - SQL Administration - Table action - Truncate In SQL Administration form select the table whose data you need to delete, and then use this option. This option is much more faster then any other option you apply. I suspect you may be using while loop to delete the data in the table. This Truncate option uses the MSSQL Truncate command internally to delete all records form any table. On the other hand deleting this much of recods will always takes time. To implement Alert functionality, Dynamics AX uses following tables EventParameters EventCompanyRule EventCUD EventInbox | |- EventInboxData |- EventRule | |-EventRuleData |-EventRuleField |-EventRuleIgnore |-EventRuleIgnoreAggregation |-EventRuleRel | |-EventRuleRelData Tables are related as explained above. If you need to delete data from all the tables related to Alert then start deleting data in table from bottom to up. Hope you understand what I wnated to explain. Hey, you u right We Born to Win Regards Nitesh Siva kumar [EMAIL PROTECTED] wrote: Hi, I am having sround 9 lacs alerts in the eventInBox table. I tried to delete it, It took 4 hrs to delete 1 records. To complete 9 lacs It will take an week. Is there any easy way to delete quickly. Even I tried to delete the alert in manahe alert tule form. Same thing happening. Thanks, Siva We Born to Win... - Be a better Heartthrob. Get better relationship answers from someone who knows. Yahoo! Answers - Check it out. [Non-text portions of this message have been removed] - Moody friends. Drama queens. Your life? Nope! - their life, your story. Play Sims Stories at Yahoo! Games. [Non-text portions of this message have been removed]
Re: [Axapta-Knowledge-Village] sysQueryForm
I think it is easy to check. just check the final query created, as when you check or uncheck the sort and groupby checkbox on sysQueryForm it gets reflected in the final SQL Query created. Hope you understand. if you ned any further clarification, let me know. Regards Siva kumar [EMAIL PROTECTED] wrote: Hi Guys, I want to check the condition from the report that whether the sort and groupby checkbox is checked/not in the sysQueryForm sort tab. Suggestion will be appreciated. Thankx, kumar We Born to Win... - Ahhh...imagining that irresistible new car smell? Check outnew cars at Yahoo! Autos. [Non-text portions of this message have been removed] - Ahhh...imagining that irresistible new car smell? Check outnew cars at Yahoo! Autos. [Non-text portions of this message have been removed]
Re: [Axapta-Knowledge-Village] Refresh Or Execute of Data Source?
It is same as caller of the current form. u need to have a object (O) of the form to be refreshed on the form from where u need to execute the refresh method. now create method (M) on the third form with code to refresh the datasourse. Call this method M from Object O. Hope u understand. If you need any further clarification let me know. Regards . pankaj_dbc [EMAIL PROTECTED] wrote: I have a requirement where I have to refresh or Execute (Execute Query) the datasource of a third form which is NOT a CALLER of my current form..Can any body suugest me a way? Pankaj. - Ahhh...imagining that irresistible new car smell? Check outnew cars at Yahoo! Autos. [Non-text portions of this message have been removed]
Re: [Axapta-Knowledge-Village] Multi line Error
extend the table field with EDT addressing kumar_ax4 [EMAIL PROTECTED] wrote: Hii Plz help me to sort out this probleb I have entered some text to a multiline StringEditText by using enter key and inserted into table field. But when im displaing this field data through the report it is not display correct way.bcz it display with enter key code Im a new developer and still use Ax3 Thanx Best Regards Vipul Kumar - Ahhh...imagining that irresistible new car smell? Check outnew cars at Yahoo! Autos. [Non-text portions of this message have been removed]
[Axapta-Knowledge-Village] Attention MUDIT: Dynamics Ax 4.0 certification exams
Hi Mudit, I need information realted Dynamics Ax 4.0 Certification exams for development/ Progaramming. It will be of great help if u provide information realted to different sections of questions for this certification exam. Regards Nitesh Ranjan Get your own web address. Have a HUGE year through Yahoo! Small Business. http://smallbusiness.yahoo.com/domains/?p=BESTDEAL [Non-text portions of this message have been removed]