Re: [development-axapta] Temporary table
hi carsten.. i tried your advice, it still didnt work any other idea? btw, thx for your response.. On Fri, Feb 15, 2008 at 6:59 PM, Carsten F. Frandsen [EMAIL PROTECTED] wrote: Hi! You should use myTable.setTmpData instead of myTable.data ... Best regards Carsten F. Frandsen a-solutions From: development-axapta@yahoogroups.comdevelopment-axapta%40yahoogroups.comon behalf of Tri Budianto Sent: Fri 2/15/2008 9:57 AM To: development-axapta@yahoogroups.comdevelopment-axapta%40yahoogroups.com Subject: [development-axapta] Temporary table Hello, I have temporary table in a form. the plan is, i will fill this temporary table using storedprocedure. reading process from store procedure to a buffer is work (i've debug it) en from this buffer I move the data to temporary table. but when open the form i have message The record has been deleted by another user can someone help me.. this is my code snippet Connection conn; Statement stmt; ResultSet resultset; myTable buffer; str spParm; int i; ; conn = new Connection(); stmt = conn.createStatement(); resultset = stmt.executeQuery(strfmt(exec sp_reportsform '%1', curext())); while(resultset.next()) { buffer.SalesId = resultset.getString(1); } myTable.data(buffer); many thanks.. -- Best Regards, Tri Budianto [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] -- Best Regards, Tri Budianto [Non-text portions of this message have been removed]
[development-axapta] order by then sort
hi guys i have requirement where i have to group the records by item id, find the sum of the quantity of a particular item id group, after adding a sum i want to sort them based on the highest qty Ex: if i have items itemqty 1000 50 1000 20 100010 200060 200030 300 20 300 10 my desired result would 2000(highest qty 90),1000(80),300...like wise i have to perform what i have done is written a job like this select sum(qty) from inventtrans group by itemid; i m nt getting how to sort them later pls help - Now you can chat without downloading messenger. Click here to know how. [Non-text portions of this message have been removed]
[development-axapta] Re: axapta developer videos
hi all, in past days i asked how i can find ax developer videos and i learned if i have partner lisance, i can find some of video. But i understand that this videos whichs about advertisement and satisfying to customers. as you know i dont want it. what can i do? Regards Esin.
[development-axapta] AX 2.1 SP3 install anyone?
Anyone have the SP3 install for Ax 2.1 or where I can get it urgently? Thanks James [Non-text portions of this message have been removed]
[development-axapta] [spam] Remittance journal revert back
Hi everybody, I have posted a remittance journal , but right now I need to unposted it. How can I do this?? Thank you very much Atentamente LM Spain / Ponferrada Alfonso Collados Arroyo Programmer Analyst Telephone: +34 (987) 409 444 + Ext 24 Mobile: E-mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -- Este e-mail y sus documentos adjuntos son confidenciales. Si usted no aparece en la lista de destinatarios por favor comuníqueselo inmediatamente al remitente y no reenvíe los contenidos a otra persona, no los utilice con ningún fin, guarde o copie dicha documentación en ningún formato. Cualquier reenvío, uso o almacenamiento sin autorización está prohibido y es ilegal. - This E-mail and any attachments are confidential. If you are not the named or intended receipient, please notify the sender immediately and do not disclose the contents to any other person, use it for any purpose or store or copy the information in any medium. Any unauthorized disclosure, use or storage is prohibited and might be unlawful. [Non-text portions of this message have been removed]
Re: [development-axapta] Re: axapta developer videos
Hi Esin, You can download some useful vidoes and documents on Dynamics AX from the following site: http://www.mibuso.com/ (Go to download section, where you can find the docuements videos) Regards, Kris - Original Message From: esinbmu [EMAIL PROTECTED] To: development-axapta@yahoogroups.com Sent: Thursday, 14 February, 2008 9:35:42 PM Subject: [development-axapta] Re: axapta developer videos thanx your reply Muthu krishnan; i'll try to learn ax from help menus.And also if i find a partnership lisance, i search some videos.if not, can i find any videos without partner lisance? for your helpful message,thanx too much best regards. Esin. Download prohibited? No problem. CHAT from any browser, without download. Go to http://in.messenger.yahoo.com/webmessengerpromo.php/ [Non-text portions of this message have been removed]
[development-axapta] Re: Deleting a label
You can delete a label by going to Menu Tools - Dev tools - Label - Search Label. Find your label, select it and use the delete as if you delete a record in a table. Steeve... --- In development-axapta@yahoogroups.com, Malcolm Burtt [EMAIL PROTECTED] wrote: Hi As far as I know you can't delete the label but you can change it. Find the label then click into the grid where the label is listed and edit the text then save the record (Ctrl-S). You'll find that if you just change it to upper case it probably won't actually make the change in the label file when you save the record but if you change it to something else first (e.g. add an extra character to the end), save it and then change it to upper case (obviously removing the extra character) and save it again then it should update the label file. Regards Malcolm Burtt Touchstone People, Partnerships, Solutions From: development-axapta@yahoogroups.com [mailto:development- [EMAIL PROTECTED] On Behalf Of jquinteroz Sent: 12 February 2008 13:46 To: development-axapta@yahoogroups.com Subject: [development-axapta] Deleting a label Hi to everybody: I have the next issue: I have a label thta was written in lowercase (we use uppercase). I found the label in the find label form. I try to delete it. In the form appears like it were deleted. But, when I sign off and sign on again in Axapta, the label remains (still exists). I am in Axapta V3 SP5. Do I have another way to delete the label?. Regards. [Non-text portions of this message have been removed]
[development-axapta] www.systomatics.com
Hi www.systomatics.comhttp://www.systomatics.com is updated with a new blog, new Microsoft watch. Also infolog project appearing under projects has been modified with an upgraded version. Regards Harry [Non-text portions of this message have been removed]
[development-axapta] Example for Transfer Order Posting by X++
Dear all, Would have some example on handling the transfer order by X++? I would like to post the shipment / receive on transfer order. From Standard, I found it use a class called InventTransferMultiShip. However, I still don't know how could I do it by code... If possible, please provide me some code example to follow. Thank you very much...
[development-axapta] Label issue
Hi!: I have an issue with labels. I need to update a ald file (saved in Appl folder) in order to uopdate labels in CUS environment. I replace the corresponding ald file but Axapta don't see the news labels. How I can fix that?. Do I need to create manually each new label directly in Axapta?. Regards. Any idea will be appreciated.
[development-axapta] www.systomatics.com
Hi The site has been updated with a new blog Regards harry [Non-text portions of this message have been removed]
[development-axapta] Fiscal Periods vs. date ranges
Hi! I am new to the world of Axapta, and I am hoping that someone can enlighten me as to how Axapta handles the concept of fiscal periods. I am oVer here in the states and I have the need to report and express the financial data (LEDGERBALANCESDIMTRANS and LEDGERTRANS) in terms of fiscal periods as opposed to From and To dates. Is there a table or set of tables that contains not just the period stast and end dates (like the LEDGERPERIOD table), but also the fiscal period number (1,2,3,...,12)? Thanks in advance for your help.