[Axapta-Knowledge-Village] Display Method Troubles
Hello all, I have some troubles with display methods, some work and some do not. Are there resources available that can assist with development of display methods?
[Axapta-Knowledge-Village] Re: How to import Employee data into Ax 2009
Sunell, Have you updated the relating tables, this data must also exist in the DirPartyTable and Dir PartyView. --- In Axapta-Knowledge-Village@yahoogroups.com, SUNEEL BABU suneel...@... wrote: HI., I am trying to importing Empl data from excel template. It imported successfully, but no data in form . I see the data in Empl table. Please any one can send any solution for that. How to import employee data in to Ax 2009 Regards., Suneel _ Live Search extreme As India feels the heat of poll season, get all the info you need on the MSN News Aggregator http://news.in.msn.com/National/indiaelections2009/aggregator/default.aspx
[Axapta-Knowledge-Village] Hpw to Post HTTP Form Data in Ax
Hi guys, On my form I have a button that when clicked it will post form data to an external website, how can I do this in AX? I have looked at the webSession class, but if someone can provide example that will be great Here is what I want to post: FormData: form action=someDomain.com/formprocessor.do method=post custName = `custTable.name' idNum = `custtable.accountnum' submit best regards,
[Axapta-Knowledge-Village] Filtering on a diaplay method on a grid question
Hello all, I have a display method on my grid to return data but I am noticing I can not filter when I am using this to get data. How can I filter, right click, filter by..., when using display methods?
[Axapta-Knowledge-Village] Re: How can I pass parameter from a form to a class?
Thank you all for bearing with me, as someone new to development I get overwhelmed at times but just need a little pointing in the right direction. Cheers --- In Axapta-Knowledge-Village@yahoogroups.com, manish saxena senior_ga...@... wrote: Hi Girac, if i understand correctly, in the menuitem(which is pointing to your class), properties datasource, pass the table, purchtable. And on the main method of your class, catch that object of PurchTable(using PurchTable purchTable = args.record()). From that object of PurchTable, u can use the value of PurchId for filter. So, from menuItem, whatever be your current record on form for PurchTable, it will pass that record to class. I hope, it will help you.. Manish --- On Fri, 11/9/09, Anitha S mail2eani...@... wrote: From: Anitha S mail2eani...@... Subject: Re: [Axapta-Knowledge-Village] Re: How can I pass parameter from a form to a class? To: Axapta-Knowledge-Village@yahoogroups.com Date: Friday, 11 September, 2009, 10:10 AM Giriac, Try this. In the Active method of the datasource, u can get the value of the current record. If your requirement is fetching the value for the selected record, this will work. Try with infolog/print in the above method to check the value of the result. Hope this helps!!! Regards, Anitha On Fri, Sep 11, 2009 at 1:00 AM, girac127 girac...@yahoo. com wrote: Anitha, Thank you for your reply, On my form I have a grid with the PurchID as one value. On this form I added a MenuAction to point my my class. In my class I have the query while select PurchTable where PurchTable.PurchId == 'PurchIDValueFromFor m' this create my text file as I expect. but I need to change the PurchIDValueFromFor m for each selected record that I create file from. What is the way to accomplish this I have tried your suggestion however it is not pulling the right data related to the selected record. Regards G --- In Axapta-Knowledge- vill...@yahoogro ups.com, Anitha S mail2eanitha@ wrote: I could not get the clear picture of ur query. I understood the first part of it. Try this. From your question , i understud PURCHID is in the datasource. So you can directly use it as *datasourcename. PurchID or FormControName. text()* and pass it as parameter to the class method. Else you can pass the Table as parameter. Hope it helps!!! Regards, Anitha On Thu, Sep 10, 2009 at 6:34 AM, girac127 girac127@ wrote: Hello all, I have created a job to query and create file. I will drag that into a class. Now I need to to pass a parameter from my form (the PurchTable.PurchID field of the record that is selected) to the class and use that as my parameter in my query. How can I accomplish this? Best regards G Try the new Yahoo! India Homepage. Click here. http://in.yahoo.com/trynew
[Axapta-Knowledge-Village] Re: How can I pass parameter from a form to a class?
Anitha, Thank you for your reply, On my form I have a grid with the PurchID as one value. On this form I added a MenuAction to point my my class. In my class I have the query while select PurchTable where PurchTable.PurchId == 'PurchIDValueFromForm' this create my text file as I expect. but I need to change the PurchIDValueFromForm for each selected record that I create file from. What is the way to accomplish this I have tried your suggestion however it is not pulling the right data related to the selected record. Regards G --- In Axapta-Knowledge-Village@yahoogroups.com, Anitha S mail2eani...@... wrote: I could not get the clear picture of ur query. I understood the first part of it. Try this. From your question , i understud PURCHID is in the datasource. So you can directly use it as *datasourcename.PurchID or FormControName.text()* and pass it as parameter to the class method. Else you can pass the Table as parameter. Hope it helps!!! Regards, Anitha On Thu, Sep 10, 2009 at 6:34 AM, girac127 girac...@... wrote: Hello all, I have created a job to query and create file. I will drag that into a class. Now I need to to pass a parameter from my form (the PurchTable.PurchID field of the record that is selected) to the class and use that as my parameter in my query. How can I accomplish this? Best regards G
[Axapta-Knowledge-Village] Re: How can I pass parameter from a form to a class?
I had my datasource on my menuitem set and the table was decleard, so I was 1/2 way there. However when I added the code to my main method i received a syntax error for the throw error... The PurchTable is being passed passed. regards, G --- In Axapta-Knowledge-Village@yahoogroups.com, Varden Morris vard...@... wrote: Set the datasource property of the menuitem on the form to the required datasource on the form. In the main method of the class there is an Args parameter. Declare the table in the main method and set it to the record property of the Args parameter. Something like this: static void main(Args _args) { PurchTable purchTable; ; if (_args.dataset() != tablenum(PurchTable) throw error(strfmt(Method %1 was called with an invalid record, funcname())); purchTable = _args().record(); } I assume that PurchTable is the table buffer being passed from the form datasource. Regards, Varden Morris Varalth Solutions Inc. 693 Abbottsfield Road NW Edmonton, Alberta T5W 4R4 Canada (780) 752-0406 (780) 716-8604 (c) 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: girac127 girac...@... To: Axapta-Knowledge-Village@yahoogroups.com Sent: Thursday, September 10, 2009 1:30:25 PM Subject: [Axapta-Knowledge-Village] Re: How can I pass parameter from a form to a class? Anitha, Thank you for your reply, On my form I have a grid with the PurchID as one value. On this form I added a MenuAction to point my my class. In my class I have the query while select PurchTable where PurchTable.PurchId == 'PurchIDValueFromFo rm' this create my text file as I expect. but I need to change the PurchIDValueFromFo rm for each selected record that I create file from. What is the way to accomplish this I have tried your suggestion however it is not pulling the right data related to the selected record. Regards G --- In Axapta-Knowledge- vill...@yahoogro ups.com, Anitha S mail2eanitha@ ... wrote: I could not get the clear picture of ur query. I understood the first part of it. Try this. From your question , i understud PURCHID is in the datasource. So you can directly use it as *datasourcename. PurchID or FormControName. text()* and pass it as parameter to the class method. Else you can pass the Table as parameter. Hope it helps!!! Regards, Anitha On Thu, Sep 10, 2009 at 6:34 AM, girac127 girac127@ . wrote: Hello all, I have created a job to query and create file. I will drag that into a class. Now I need to to pass a parameter from my form (the PurchTable.PurchID field of the record that is selected) to the class and use that as my parameter in my query. How can I accomplish this? Best regards G
[Axapta-Knowledge-Village] How can I pass parameter from a form to a class?
Hello all, I have created a job to query and create file. I will drag that into a class. Now I need to to pass a parameter from my form (the PurchTable.PurchID field of the record that is selected) to the class and use that as my parameter in my query. How can I accomplish this? Best regards G
[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, 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
[Axapta-Knowledge-Village] What tables does the Clearing Financial Transactions Job delete?
Hello all, when I run the job. Clear_Financial_Tables SysDatabaseTransDelete databaseTransDelete = SysDatabaseTransDelete::construct(); It remove the financial transactions. however It also remove some project tables as my project are missing relations. I have looked to see what tables these are, but cannot notice any related proj tables. I looked at the SysDatabaseTransDelete class to determine what tables are affected but cannot understand. Can someone confirm what tables get deleted. cheers
[Axapta-Knowledge-Village] Re: Displaying Records On Form From Query
Hello all, Here is my code, Maybe I not place it right location. What I want to do is open the form and display only records matching the criteria of Open order. I am learning developing in X++ so thank you all for bearing with me on this. public void init() { Query q = new Query(); QueryBuildDataSourceqbds; QueryBuildRange qbr; ; super(); qbds = q.addDataSource(tableNum(PurchTable)); //qbds.addRange( fieldNum( PurchTable, PurchStatus) ).value(enum2str(purchstatus::Backorder)); qbds.addRange( fieldNum( PurchTable, PurchStatus) ).value(queryvalue(purchstatus: :BackOrder) ); //qbds.addRange(fieldNum(PurchTable, PurchStatus)).value(enum2str (Purchstatus: :1) ); // qbds.addRange(fieldNum(PurchTable,PurchStatus)).value('Open order'); //qbds.addRange(fieldNum(PurchTable,PurchStatus)).value(enum2str ( info(qbds.toString()); } --- In Axapta-Knowledge-Village@yahoogroups.com, sanju_kori sanju_k...@... wrote: Hi girac, Try this statement: qbds.addRange( fieldNum( PurchTable, PurchStatus) ).value(queryvalue(purchstatus: :BackOrder) ); if not then please post bout d solution u came out wid. regards, Sanjiv --- In Axapta-Knowledge-Village@yahoogroups.com, Anitha S mail2eanitha@ wrote: girac, Can u send in ur code.. then we can check wats wrong with it... Regards, Anitha On Tue, Aug 25, 2009 at 8:25 PM, giarc 127 girac127@ wrote: Hello all, When I use the suggested code I get an error saying my variable Purchstatus is not declared, I declared this, but getting an error. How does this need to be declared? regards, -- *From:* sreenath reddy shysrinath@ *To:* Axapta-Knowledge-Village@yahoogroups.com *Sent:* Tuesday, August 25, 2009 5:39:59 AM *Subject:* Re: [Axapta-Knowledge-Village] Displaying Records On Form From Query Hi, try using qbds.addRange( fieldNum( PurchTable, PurchStatus) ).value(enum2str (purchstatus: :BackOrder) ); regards, sreenath --- On *Tue, 8/25/09, girac127 girac...@yahoo. com* wrote: From: girac127 girac...@yahoo. com Subject: [Axapta-Knowledge- Village] Displaying Records On Form From Query To: Axapta-Knowledge- vill...@yahoogro ups.com Date: Tuesday, August 25, 2009, 12:07 AM Good day all. My requirement is to display only records where the PurchStatus =1 on a new PO detail form which I have in place. I have the following code in the init Datasource(Purchtab le) Method. What am I missing to have this execute? public void init() { Query q = new Query(); QueryBuildDataSourc e qbds; ; super(); qbds = q.addDataSource( tableNum( PurchTable) ); qbds.addRange( fieldNum( PurchTable, PurchStatus) ).value(1); info(qbDS.toString( )); } I have the info displaying my correct query, but I am returning results other than the value of 1
[Axapta-Knowledge-Village] Displaying Records On Form From Query
Good day all. My requirement is to display only records where the PurchStatus =1 on a new PO detail form which I have in place. I have the following code in the init Datasource(Purchtable) Method. What am I missing to have this execute? public void init() { Query q = new Query(); QueryBuildDataSourceqbds; ; super(); qbds = q.addDataSource(tableNum(PurchTable)); qbds.addRange(fieldNum(PurchTable,PurchStatus)).value(â1â); info(qbDS.toString()); } I have the info displaying my correct query, but I am returning results other than the value of â1â