RE: [Axapta-Knowledge-Village] Any Idea abou this?
or put the spaces there yourselve -Oorspronkelijk bericht-Van: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED]Namens DIEGO MARIANO GAGLIANOVerzonden: woensdag 31 augustus 2005 11:03Aan: Axapta-Knowledge-Village@yahoogroups.comOnderwerp: RE: [Axapta-Knowledge-Village] Any Idea abou this? Hi Hennie When you change the Right to Left aligment, you lost all existing Account. When Axapta have a Rightaligment add blank space front at the Account Number (AccountNum: ' 1125'). Axapta put blank space to complete the size of the field. Now with left aligment Axapta looking for (AccountNum:'1125'). If you see for the above examples you never findold accounts. My suggestion is change back to right aligment, previouse delete the account that you generated with the left aligment. Hennie Potgieter [EMAIL PROTECTED] wrote: Hi, I changed the alignment of this EDT once (by accident). It caused quite a bit of chaos since Axapta could not find any of its GL accounts and as a result posted all transactions to the "System Error Account" account. Hennie -Original Message-From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of ANIL OZAYSent: Wednesday, 31 August 2005 08:59 AMTo: Axapta-Knowledge-Village@yahoogroups.comSubject: RE: [Axapta-Knowledge-Village] Any Idea abou this? Hi Subbu, Yes, you can check EDT, or anybody has changed it from 'Adjust Global Types' on "Administration/Setup/System/Adjust Global Types". Regards, Anil Ozay From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Harry (Harshawardhan DeshpandeSent: Wednesday, August 31, 2005 9:26 AMTo: Axapta-Knowledge-Village@yahoogroups.comSubject: Re: [Axapta-Knowledge-Village] Any Idea abou this? hi subbu check the property on the extended data type regards harry "Subrahmanyam, Mamidi" [EMAIL PROTECTED] wrote: Hi, I am wondering if you guys know of this. Why is the field 'AccountNum' is right aligned and why not 'Left aligned'?. Does what factor judge alignment property?. Because this has significant effect in 'select' statements if I use AccountNum as Index. Any help is highly appreciated, Thanks Regards, subbu Start your day with Yahoo! - make it your home page Start your day with Yahoo! - make it your home page Bu e-posta ve muhtemel eklerinde verilen bilgiler kisiye ozel ve gizlidir. Anadolu Bilisim Hizmetleri A.S. bu mesajin icerigi ve ekleri ile ilgili hicbir hukuki sorumluluk kabul etmez. Yetkili alicilardan degilseniz, bu mesajin herhangi bir sekilde ifsa edilmesi, kullanilmasi, kopyalanmasi, yayilmasi veya mesajda yer alan hususlarla ilgili olarak herhangi bir islem yapilmasi kesinlikle yasaktir. Bu durumda hemen mesajin gondericisini bilgilendiriniz ve mesaji sisteminizden siliniz. Elektronik mesajlar uzerinde yapilmis herhangi bir degisiklik veya sonuclari uzerinde Anadolu Bilisim Hizmetleri A.S.'nin sorumlulugu yoktur. Ayrica, e-posta mesajlarindaki hata ve/veya eksiklikten, virus icermesinden ve bilgisayar sistemin ize verebilecegi herhangi bir zarardan Sirket olarak sorumluluk kabul etmeyecegimizi de bildiririz.This e-mail and any information included within any attached document are private and confidential and intended solely for the addressee. Anadolu Bilisim Hizmetleri A.S. does not accept any legal responsibility for the contents of this message and any attached documents. If you are not the intended addressee, it is forbidden to disclose, use, copy, or forward any information within the message or engage in any activity regarding the contents of this message. In such case please notify the sender and delete the message from your system immediately. Anadolu Bilisim Hizmetleri A.S. also denounces any legal responsibility for any amendments made on the electronic message and the outcome of these amendments, as well as any error and/or defect, virus content and any damage that may be given to your system. Sharing the knowledge on Axapta.
RE: [Axapta-Knowledge-Village] Any Idea abou this?
Hi Subbu, Yes, you can check EDT, or anybody has changed it from Adjust Global Types on Administration/Setup/System/Adjust Global Types. Regards, Anil Ozay From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Harry (Harshawardhan Deshpande Sent: Wednesday, August 31, 2005 9:26 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: Re: [Axapta-Knowledge-Village] Any Idea abou this? hi subbu check the property on the extended data type regards harry Subrahmanyam, Mamidi [EMAIL PROTECTED] wrote: Hi, I am wondering if you guys know of this. Why is the field 'AccountNum' is right aligned and why not 'Left aligned'?. Does what factor judge alignment property?. Because this has significant effect in 'select' statements if I use AccountNum as Index. Any help is highly appreciated, Thanks Regards, subbu Start your day with Yahoo! - make it your home page Start your day with Yahoo! - make it your home page Bu e-posta ve muhtemel eklerinde verilen bilgiler kisiye ozel ve gizlidir. Anadolu Bilisim Hizmetleri A.S. bu mesajin icerigi ve ekleri ile ilgili hicbir hukuki sorumluluk kabul etmez. Yetkili alicilardan degilseniz, bu mesajin herhangi bir sekilde ifsa edilmesi, kullanilmasi, kopyalanmasi, yayilmasi veya mesajda yer alan hususlarla ilgili olarak herhangi bir islem yapilmasi kesinlikle yasaktir. Bu durumda hemen mesajin gondericisini bilgilendiriniz ve mesaji sisteminizden siliniz. Elektronik mesajlar uzerinde yapilmis herhangi bir degisiklik veya sonuclari uzerinde Anadolu Bilisim Hizmetleri A.S.'nin sorumlulugu yoktur. Ayrica, e-posta mesajlarindaki hata ve/veya eksiklikten, virus icermesinden ve bilgisayar sisteminize verebilecegi herhangi bir zarardan Sirket olarak sorumluluk kabul etmeyecegimizi de bildiririz. This e-mail and any information included within any attached document are private and confidential and intended solely for the addressee. Anadolu Bilisim Hizmetleri A.S. does not accept any legal responsibility for the contents of this message and any attached documents. If you are not the intended addressee, it is forbidden to disclose, use, copy, or forward any information within the message or engage in any activity regarding the contents of this message. In such case please notify the sender and delete the message from your system immediately. Anadolu Bilisim Hizmetleri A.S. also denounces any legal responsibility for any amendments made on the electronic message and the outcome of these amendments, as well as any error and/or defect, virus content and any damage that may be given to your system. Sharing the knowledge on Axapta. SPONSORED LINKS Axapta Business finance course Business finance online course Business finance class Business finance schools Business finances YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" on the web. To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
RE: [Axapta-Knowledge-Village] Any Idea abou this?
Title: Message Hi, I changed the alignment of this EDT once (by accident). It caused quite a bit of chaos since Axapta could not find any of its GL accounts and as a result posted all transactions to the "System Error Account" account. Hennie -Original Message-From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of ANIL OZAYSent: Wednesday, 31 August 2005 08:59 AMTo: Axapta-Knowledge-Village@yahoogroups.comSubject: RE: [Axapta-Knowledge-Village] Any Idea abou this? Hi Subbu, Yes, you can check EDT, or anybody has changed it from Adjust Global Types on Administration/Setup/System/Adjust Global Types. Regards, Anil Ozay From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Harry (Harshawardhan DeshpandeSent: Wednesday, August 31, 2005 9:26 AMTo: Axapta-Knowledge-Village@yahoogroups.comSubject: Re: [Axapta-Knowledge-Village] Any Idea abou this? hi subbu check the property on the extended data type regards harry "Subrahmanyam, Mamidi" [EMAIL PROTECTED] wrote: Hi, I am wondering if you guys know of this. Why is the field 'AccountNum' is right aligned and why not 'Left aligned'?. Does what factor judge alignment property?. Because this has significant effect in 'select' statements if I use AccountNum as Index. Any help is highly appreciated, Thanks Regards, subbu Start your day with Yahoo! - make it your home page Start your day with Yahoo! - make it your home page Bu e-posta ve muhtemel eklerinde verilen bilgiler kisiye ozel ve gizlidir. Anadolu Bilisim Hizmetleri A.S. bu mesajin icerigi ve ekleri ile ilgili hicbir hukuki sorumluluk kabul etmez. Yetkili alicilardan degilseniz, bu mesajin herhangi bir sekilde ifsa edilmesi, kullanilmasi, kopyalanmasi, yayilmasi veya mesajda yer alan hususlarla ilgili olarak herhangi bir islem yapilmasi kesinlikle yasaktir. Bu durumda hemen mesajin gondericisini bilgilendiriniz ve mesaji sisteminizden siliniz. Elektronik mesajlar uzerinde yapilmis herhangi bir degisiklik veya sonuclari uzerinde Anadolu Bilisim Hizmetleri A.S.'nin sorumlulugu yoktur. Ayrica, e-posta mesajlarindaki hata ve/veya eksiklikten, virus icermesinden ve bilgisayar sisteminize verebilecegi herhangi bir zarardan Sirket olarak sorumluluk kabul etmeyecegimizi de bildiririz.This e-mail and any information included within any attached document are private and confidential and intended solely for the addressee. Anadolu Bilisim Hizmetleri A.S. does not accept any legal responsibility for the contents of this message and any attached documents. If you are not the intended addressee, it is forbidden to disclose, use, copy, or forward any information within the message or engage in any activity regarding the contents of this message. In such case please notify the sender and delete the message from your system immediately. Anadolu Bilisim Hizmetleri A.S. also denounces any legal responsibility for any amendments made on the electronic message and the outcome of these amendments, as well as any error and/or defect, virus content and any damage that may be given to your system. Sharing the knowledge on Axapta. YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" on the web. To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
RE: [Axapta-Knowledge-Village] Any Idea abou this?
Title: Message Yes, you are right :) It must changed from Adjust Global Types screen. But in this screen, this message show : You may adjust data types in Microsoft Axapta to meet your specific requirements. This must, however, be done before entering data. From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Hennie Potgieter Sent: Wednesday, August 31, 2005 11:33 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] Any Idea abou this? Hi, I changed the alignment of this EDT once (by accident). It caused quite a bit of chaos since Axapta could not find any of its GL accounts and as a result posted all transactions to the System Error Account account. Hennie -Original Message- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of ANIL OZAY Sent: Wednesday, 31 August 2005 08:59 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] Any Idea abou this? Hi Subbu, Yes, you can check EDT, or anybody has changed it from Adjust Global Types on Administration/Setup/System/Adjust Global Types. Regards, Anil Ozay From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Harry (Harshawardhan Deshpande Sent: Wednesday, August 31, 2005 9:26 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: Re: [Axapta-Knowledge-Village] Any Idea abou this? hi subbu check the property on the extended data type regards harry Subrahmanyam, Mamidi [EMAIL PROTECTED] wrote: Hi, I am wondering if you guys know of this. Why is the field 'AccountNum' is right aligned and why not 'Left aligned'?. Does what factor judge alignment property?. Because this has significant effect in 'select' statements if I use AccountNum as Index. Any help is highly appreciated, Thanks Regards, subbu Start your day with Yahoo! - make it your home page Start your day with Yahoo! - make it your home page Bu e-posta ve muhtemel eklerinde verilen bilgiler kisiye ozel ve gizlidir. Anadolu Bilisim Hizmetleri A.S. bu mesajin icerigi ve ekleri ile ilgili hicbir hukuki sorumluluk kabul etmez. Yetkili alicilardan degilseniz, bu mesajin herhangi bir sekilde ifsa edilmesi, kullanilmasi, kopyalanmasi, yayilmasi veya mesajda yer alan hususlarla ilgili olarak herhangi bir islem yapilmasi kesinlikle yasaktir. Bu durumda hemen mesajin gondericisini bilgilendiriniz ve mesaji sisteminizden siliniz. Elektronik mesajlar uzerinde yapilmis herhangi bir degisiklik veya sonuclari uzerinde Anadolu Bilisim Hizmetleri A.S.'nin sorumlulugu yoktur. Ayrica, e-posta mesajlarindaki hata ve/veya eksiklikten, virus icermesinden ve bilgisayar sisteminize verebilecegi herhangi bir zarardan Sirket olarak sorumluluk kabul etmeyecegimizi de bildiririz. This e-mail and any information included within any attached document are private and confidential and intended solely for the addressee. Anadolu Bilisim Hizmetleri A.S. does not accept any legal responsibility for the contents of this message and any attached documents. If you are not the intended addressee, it is forbidden to disclose, use, copy, or forward any information within the message or engage in any activity regarding the contents of this message. In such case please notify the sender and delete the message from your system immediately. Anadolu Bilisim Hizmetleri A.S. also denounces any legal responsibility for any amendments made on the electronic message and the outcome of these amendments, as well as any error and/or defect, virus content and any damage that may be given to your system. Bu e-posta ve muhtemel eklerinde verilen bilgiler kisiye ozel ve gizlidir. Anadolu Bilisim Hizmetleri A.S. bu mesajin icerigi ve ekleri ile ilgili hicbir hukuki sorumluluk kabul etmez. Yetkili alicilardan degilseniz, bu mesajin herhangi bir sekilde ifsa edilmesi, kullanilmasi, kopyalanmasi, yayilmasi veya mesajda yer alan hususlarla ilgili olarak herhangi bir islem yapilmasi kesinlikle yasaktir. Bu durumda hemen mesajin gondericisini bilgilendiriniz ve mesaji sisteminizden siliniz. Elektronik mesajlar uzerinde yapilmis herhangi bir degisiklik veya sonuclari uzerinde Anadolu Bilisim Hizmetleri A.S.'nin sorumlulugu yoktur. Ayrica, e-posta mesajlarindaki hata ve/veya eksiklikten, virus icermesinden ve bilgisayar sisteminize verebilecegi herhangi bir zarardan Sirket olarak sorumluluk kabul etmeyecegimizi de bildiririz. This e-mail and any information included within any attached document are private and confidential and intended solely for the addressee. Anadolu Bilisim Hizmetleri A.S. does not accept any legal responsibility for the contents of this message and any attached documents. If you are not the intended addressee, it is forbidden to disclose, use, copy
RE: [Axapta-Knowledge-Village] Any Idea abou this?
Den 31. august 2005 11:27 skrev Hennie Potgieter: I know now how it works but it still doesnt make much sense to me why it is right aligned and why Axapta prefixes the data with blanks. Sorting. Right aligned: 1 2 10 11 12 Left aligned 1 10 11 12 2 Makes sense now ;-) Hilsen Søren Yahoo! Groups Sponsor ~-- Put more honey in your pocket. (money matters made easy). http://us.click.yahoo.com/r7D80C/dlQLAA/cosFAA/kGEolB/TM ~- Sharing the knowledge on Axapta. Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
RE: [Axapta-Knowledge-Village] Any Idea abou this?
Hi Hennie Axapta have this setting standard, I think becausemanycompanies used this aligment, but you can change when Axapta is installed. Why Axapta use blank space at front when is right aligment, I don't know. Best regards, Diego M. Gagliano Please fill free to contact me if you have any question. I look forward to hear about you. Start your day with Yahoo! - make it your home page Sharing the knowledge on Axapta. SPONSORED LINKS Axapta Business finance course Business finance online course Business finance class Business finance schools Business finances YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" on the web. To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
RE: [Axapta-Knowledge-Village] Any Idea abou this?
Hi Subbu You used a normal Axapta select or SQL statement? If you used axapta declare the variable type as and resolve the problem If you used SQL statement when you create a select command add the command Ltrim Example: SELECT ACCOUNTNUM, VOUCHERFROM dbo.LEDGERTRANSWHERE (LTRIM(VOUCHER) = 'VA0001') Best regards, Diego M. Gagliano Please fill free to contact me if you have any question. I look forward to hear about you. Start your day with Yahoo! - make it your home page Sharing the knowledge on Axapta. SPONSORED LINKS Axapta Business finance course Business finance online course Business finance class Business finance schools Business finances YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" on the web. To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
RE: [Axapta-Knowledge-Village] Any Idea abou this?
Hi, I am working in my DEV environment just for the sake of learning. I think we can not use strltrim() in X++ 'select where' statement. So i I tried to introduce spaces to get the correct count on LedgerTable using AccountNum as index. But already there are trasactions posted on these LedgerAccounts. Hence, we can not modify them at this point of time. You are right. I could be able to use LTRIM in SQL and get the records count. Actually I am looking for any info , like 'why Microsoft made Account is Right Aligned' and 'ItemID is left aligned'. Appreciate any info. Thanks, subbu DIEGO MARIANO GAGLIANO [EMAIL PROTECTED] wrote: Hi Subbu You used a normal Axapta select or SQL statement? If you used axapta declare the variable type as and resolve the problem If you used SQL statement when you create a select command add the command Ltrim Example: SELECT ACCOUNTNUM, VOUCHERFROM dbo.LEDGERTRANSWHERE (LTRIM(VOUCHER) = 'VA0001') Best regards, Diego M. Gagliano Please fill free to contact me if you have any question. I look forward to hear about you. Start your day with Yahoo! - make it your home page Start your day with Yahoo! - make it your home page Sharing the knowledge on Axapta. SPONSORED LINKS Axapta Business finance course Business finance online course Business finance class Business finance schools Business finances YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" on the web. To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
RE: [Axapta-Knowledge-Village] Any Idea abou this?
hi the technical reason why item id is left aligned is because that is the property of the extended data type. There is no technical reason why the edt itseelf is left aligned, this is a functional requirement. I think the left alignment and right alignment is decided upon what looks nice. regards harry"Subrahmanyam, Mamidi" [EMAIL PROTECTED] wrote: Hi Guys, I am sorry. I think I didn;t put my question in correct way. what is the technical reason behind setting lfet alignment or right alignment?. Fpr example: Why is 'ItemId' left aligned? and LedgerNum is 'right' aligned?. ( Because, if its right ligned, I need to put spaces or use ' strltrim' in order to get the correct select statement currectly work.) Any idea? Thanks Regards, subbu DIEGO MARIANO GAGLIANO [EMAIL PROTECTED] wrote: Hi Hennie Axapta have this setting standard, I think becausemanycompanies used this aligment, but you can change when Axapta is installed. Why Axapta use blank space at front when is right aligment, I don't know. Best regards, Diego M. Gagliano Please fill free to contact me if you have any question. I look forward to hear about you. Start your day with Yahoo! - make it your home page __Do You Yahoo!?Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com Start your day with Yahoo! - make it your home page Sharing the knowledge on Axapta. YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" on the web. To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
RE: [Axapta-Knowledge-Village] Any Idea abou this?
Hi All, It depends on the contents of the string. If it is some thing related to a number like salesId, Quotation ID etc.. it all right aligned If it is text string like ItemId it is left aligned. I think it is for sorting to work correctly. We had issues with number string field not sorting correctly with left aligned it was like this 1000 2 300 4 55 JJT --- Harry (Harshawardhan Deshpande [EMAIL PROTECTED] wrote: hi the technical reason why item id is left aligned is because that is the property of the extended data type. There is no technical reason why the edt itseelf is left aligned, this is a functional requirement. I think the left alignment and right alignment is decided upon what looks nice. regards harry Subrahmanyam, Mamidi [EMAIL PROTECTED] wrote: Hi Guys, I am sorry. I think I didn;t put my question in correct way. what is the technical reason behind setting lfet alignment or right alignment?. Fpr example: Why is 'ItemId' left aligned? and LedgerNum is 'right' aligned?. ( Because, if its right ligned, I need to put spaces or use ' strltrim' in order to get the correct select statement currectly work. ) Any idea? Thanks Regards, subbu DIEGO MARIANO GAGLIANO [EMAIL PROTECTED] wrote: Hi Hennie Axapta have this setting standard, I think because many companies used this aligment, but you can change when Axapta is installed. Why Axapta use blank space at front when is right aligment, I don't know. Best regards, Diego M. Gagliano Please fill free to contact me if you have any question. I look forward to hear about you. - Start your day with Yahoo! - make it your home page __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com Sharing the knowledge on Axapta. - YAHOO! GROUPS LINKS Visit your group Axapta-Knowledge-Village on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. - - Start your day with Yahoo! - make it your home page Start your day with Yahoo! - make it your home page http://www.yahoo.com/r/hs Yahoo! Groups Sponsor ~-- Put more honey in your pocket. (money matters made easy). http://us.click.yahoo.com/r7D80C/dlQLAA/cosFAA/kGEolB/TM ~- Sharing the knowledge on Axapta. Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
[Axapta-Knowledge-Village] Any Idea abou this?
Hi, I am wondering if you guys know of this. Why is the field 'AccountNum' is right aligned and why not 'Left aligned'?. Does what factor judge alignment property?. Because this has significant effect in 'select' statements if I use AccountNum as Index. Any help is highly appreciated, Thanks Regards, subbu Start your day with Yahoo! - make it your home page Sharing the knowledge on Axapta. YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" on the web. To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.