RE: [Axapta-Knowledge-Village] DataStatus on inventtrans

2005-09-28 Thread Harry \(Harshawardhan Deshpande
hi Jens   what the legacy programmer told you is correct for old axapta versions.(Ax 2.5)   regards   harryJens Strandberg <[EMAIL PROTECTED]> wrote: Hmm,I have also been told by a legacy Axapta programmer, that the field order inthe select statements should follow the index order ...I would lik

Re: [Axapta-Knowledge-Village] Re: BizTalk server and Axapta

2005-09-28 Thread Daniel J. Redelinghuys
Your sollution seem impressife, what was the timeframe for develpment? On 9/28/05, loegstrup_dk <[EMAIL PROTECTED]> wrote: HiThe short answer - Yes.We have a very succesfull solution. http://www.nextinnovation.dk/Default.asp?ID=195Best RegardsLars Løgstrup Sørensen--- In Axapta-Knowledge-Villag

[Axapta-Knowledge-Village] Axapta Trade and Logistics Certification Exam V 3.0

2005-09-28 Thread saddasadda
Hi, This is Sadda Shrivastava. I am preparing for Axapta Trade and Logistics Certification Exam. If any of u guys have already given the Certification Exam,Please provide me with possile questions that are expected in the Exam. It will be extremely helpful if anyone of u can share some of the

Re: [Axapta-Knowledge-Village] Re: who can give me some document of Axapta V4.0?

2005-09-28 Thread [EMAIL PROTECTED]
Hello hwimmer, thanks you very much.i got it.thanks. Best regards, === At 2005-09-28, 19:13:27 you wrote: === >Hi Andy! > >I have put a powerpoint file about Axapta 4.0 on my blog site: >http://axaptafreak.blogspot.com >Unfortunately, you have to click 2 times to get the fil

Re: [Axapta-Knowledge-Village] Axapta 3 in Chinese?

2005-09-28 Thread Juha Alskog
Hi Jesper,   Sorry I didn't see your email with the contact adress first. Thank you for the help!   I have managed to connect with a Mr Lee at ESG-INC (recently bought by Tectura) that have a localization pack for China and a few other countries.   Thanks again, Juha  On 9/27/05, Jesper Kehlet <

RE: [Axapta-Knowledge-Village] DataStatus on inventtrans

2005-09-28 Thread Jens Strandberg
Hmm, I have also been told by a legacy Axapta programmer, that the field order in the select statements should follow the index order ... I would like to know too, if this is not correct. Thanks in advance ! /Jens -Oprindelig meddelelse- Fra: Axapta-Knowledge-Village@yahoogroups.co

[Axapta-Knowledge-Village] Re: BizTalk server and Axapta

2005-09-28 Thread loegstrup_dk
Hi The short answer - Yes. We have a very succesfull solution. http://www.nextinnovation.dk/Default.asp?ID=195 Best Regards Lars Løgstrup Sørensen --- In Axapta-Knowledge-Village@yahoogroups.com, "Daniel J. Redelinghuys" <[EMAIL PROTECTED]> wrote: > Hi all, > > Did anyone implement BizTalk t

RE : [Axapta-Knowledge-Village] InstallMessageProc

2005-09-28 Thread Steeve Gilbert
You could try overriding task() method and you'll get the taskId generated from a keypress in the Macro "Task". Regards, Steeve... -Message d'origine- De : Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] De la part de andreas_rudischhauser Envoyé : 28 septembre 200

Re: [Axapta-Knowledge-Village] Re: who can give me some document of Axapta V4.0?

2005-09-28 Thread Sajeed
hi helmut thanks for ur post message. But sadly cant download it from there. giving a message that download data transfer limit of over.. can u send it by email ?/ bye --- hwimmer <[EMAIL PROTECTED]> wrote: > Hi Andy! > > I have put a powerpoint file about Axapta 4.0 on my > blog site: >

[Axapta-Knowledge-Village] InstallMessageProc

2005-09-28 Thread andreas_rudischhauser
Hi, i am trying to catch the Keys pressed in a Form. I thought using installMessageProc could be the answer, but because there is no code and no documentation its kinda hard to test. Has anybode more informations about that method or an example to catch the Keys? I tried this in a forms init

RE: [Axapta-Knowledge-Village] DataStatus on inventtrans

2005-09-28 Thread Malcolm Burtt
ASFAIK it shouldn't make any difference which order the fields in a where clause are specified as the SQL query optimiser will sort it all out when it calculates the query plan.   Regards   Malcolm From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Giris

RE: [Axapta-Knowledge-Village] DataStatus on inventtrans

2005-09-28 Thread Girish Bhatkal
Hi James, during one of my previous implementation (2 yrs back) we had some performance issues and a Consultant from MS had visited us. he asked me to change the order of the select statements in order to improve the performance. This is because of the way the data is read. Since then i have been

RE: [Axapta-Knowledge-Village] To add or not to add an index?

2005-09-28 Thread James Flavell
Hi Barry, I would love to try also but I don't think I have time right now as this is well overdue but will try to and let everyone know if manage to Thanks James -Original Message- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Bayliss, Barry Sent

RE: [Axapta-Knowledge-Village] DataStatus on inventtrans

2005-09-28 Thread James Flavell
Thanks Grish, The part about fields being in order I was thinking about the where clauses in my select statments...whether they needed to come in the same order in my select statement as the order of the fields in the index. TO clarify, are you saying the order of the clauses in the select statem

Re: Ant: [Axapta-Knowledge-Village] Adding Fields In Grid From Two or more tables

2005-09-28 Thread DIEGO MARIANO GAGLIANO
Hi Mukesh   1) Create a Display method on the InvetTable.     display str LicenseNo()     {     Return NewTable::Find(this.ItemId).LicenseNo;    }     I assuming that you have a find method on your newtable.   2) On the form add the string field on the grid     Datasource = InventTable  

Re: [Axapta-Knowledge-Village] Adding Fields In Grid From Two or more tables

2005-09-28 Thread Daniel J. Redelinghuys
If you must use a grid, use a temp table On 9/28/05, Mukesh mutreja <[EMAIL PROTECTED]> wrote: Hi All,    I m new in Axapta. i m facing a problem regarding adding datain grid from two tables. Is it Possible? I want to add a field LicenceNo. in the InventTable form. This Licence no field is s

RE: [Axapta-Knowledge-Village] Inventory Closing

2005-09-28 Thread Sergey Siroklin
Cancelled is meaning what recalculation or closing has been canceled. -Original Message- From: Axapta-Knowledge-Village@yahoogroups.com on behalf of Ali KESKIN Sent: Wed 9/28/2005 17:19 To: Axapta-Knowledge-Village@yahoogroups.com Cc: Su

[Axapta-Knowledge-Village] Inventory Closing

2005-09-28 Thread Ali KESKIN
Hi guys, I had very strange case and I want to know how it could be done. Has anybody have any opinion? CASE:  When I look at InventoryClosing I saw 6 inventory closings;  1 is active, other 5 are not active and 3 of them are signed as CANCELLED. ??? As I know 3 cancelled means 3 passi

Ant: [Axapta-Knowledge-Village] Adding Fields In Grid From Two or more tables

2005-09-28 Thread Hans-Walter Bous
Hi Mukesh, you can make a display method on inventtable and put this into the grid. JohnMukesh mutreja <[EMAIL PROTECTED]> schrieb: Hi All,    I m new in Axapta. i m facing a problem regarding adding datain grid from two tables. Is it Possible? I want to add a fieldLicenceNo. in the InventTa

Re: [Axapta-Knowledge-Village] Adding Fields In Grid From Two or more tables

2005-09-28 Thread Girish Bhatkal
if you include both the tables in the datasource and have a innerjoin it should work. There are many forms like salesTable (salesLine & inventDim fields are displayed in the grid). The best to understand is see the tutorial form tutorial_Form_Join in the AOT. this should explain exactly what you a

[Axapta-Knowledge-Village] Adding Fields In Grid From Two or more tables

2005-09-28 Thread Mukesh mutreja
Hi All, I m new in Axapta. i m facing a problem regarding adding data in grid from two tables. Is it Possible? I want to add a field LicenceNo. in the InventTable form. This Licence no field is stored in another table. I want to add this field in Grid based upon Item Id field which is comm

RE: [Axapta-Knowledge-Village] SalesFormLetter.insertJournal()

2005-09-28 Thread Brandon George
And the real problem then came into play because we removed the throw statement at this point, in order for our custom code to work. We did this because we wanted to "catch and report" Invoice exceptions, and Intercompany Exceptions. So this is not a bug, but rather works fine when you kee

[Axapta-Knowledge-Village] Re: who can give me some document of Axapta V4.0?

2005-09-28 Thread hwimmer
Hi Andy! I have put a powerpoint file about Axapta 4.0 on my blog site: http://axaptafreak.blogspot.com Unfortunately, you have to click 2 times to get the file, couldn't convince GeoCities to open the file directly from the blog?!? Best regards Helmut http://axaptafreak.blogspot.com --- In Ax

Re: [Axapta-Knowledge-Village] DataStatus on inventtrans

2005-09-28 Thread Girish Bhatkal
i belive the fields in the index should be in proper order. In case (in table inventTrans) you are using the Index StatusItemIdx then you need to include in your select statement first statusReceipt, then StatusIssue, then ItemId and then DateStatus. If you dont want to use any of these in

RE: [Axapta-Knowledge-Village] To add or not to add an index?

2005-09-28 Thread djf
thanks harry, I will see what can be done (it is existing code that I dont want to change too much but I guess turning of TMP property is not going to cause problems) Sorry not being a programmer I have no idea what record insert list iscan point me in the right direction. Thanks for all

RE: [Axapta-Knowledge-Village] To add or not to add an index?

2005-09-28 Thread Harry \(Harshawardhan Deshpande
hi   yes, a normal table, thats what I meant.   I think you should add an index as well but not sure.   You should however use record insert list, this will certainly speed up the performance.   regards   harryJames Flavell <[EMAIL PROTECTED]> wrote: sorry forgot,   and add index as well?   w

[Axapta-Knowledge-Village] BizTalk server and Axapta

2005-09-28 Thread Daniel J. Redelinghuys
Hi all,   Did anyone implement BizTalk to work with Axapta? I want to use (investigate implementing) BizTalk to interface Axapta (ver3 SP3 going for ver4). I will receive a lot of bank recons and different invoice formats from different client (bank) systems, expl Oracle in EFT formats. I want

[Axapta-Knowledge-Village] who can give me some document of Axapta V4.0?

2005-09-28 Thread [EMAIL PROTECTED]
dear all, who can give me some document of Axapta V4.0? thanks. Andy Peng. Best regards, qhpeng [EMAIL PROTECTED] 2005-09-28 Yahoo! Groups Sponsor ~--> Get fast access to your favorite Yahoo! Groups. Make Yahoo! your home page http://us.

RE: [Axapta-Knowledge-Village] To add or not to add an index?

2005-09-28 Thread Bayliss, Barry
James, One possible way to determine the best solution is to run a test script and time the process. You might try the combinations 1. Temporary table with unique index 2. Permanent table with unique index 3. Temporary table with an index and in code check for duplicates