Re: [development-axapta] Temporary table

2008-02-27 Thread Tri Budianto
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

2008-02-27 Thread pranam mukher
  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

2008-02-27 Thread esinbmu
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?

2008-02-27 Thread James Flavell
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

2008-02-27 Thread Alfonso Collados Arroyo
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

2008-02-27 Thread Muthu krishnan
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

2008-02-27 Thread Steeve Gilbert
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

2008-02-27 Thread Harry Deshpande
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++

2008-02-27 Thread kongwilson99
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

2008-02-27 Thread jquinteroz
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

2008-02-27 Thread Harry Deshpande
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

2008-02-27 Thread Joel Dreskin
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.