RE: [Axapta-Knowledge-Village] USER Level Password Changes
You can define in user group setting permission Tools Option Regards P Saravanakumar 09894999281 -Original Message- From: SACHIN KESARWANI [mailto:[EMAIL PROTECTED] Sent: Monday, November 27, 2006 12:46 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] USER Level Password Changes Dear Group , In Axapta 3.0 if some user has own login userId and password . If he wants change the Password of user (self) but he has not writes of Admin or administrator . Can he will change his password through his user login Id and details . If its possible so how do i change as its our Clients Requirements . Give me Solutions Sachin Kesarwani Assoiciate Consultant (Axapta) Axapta-Knowledge- mailto:Axapta-Knowledge-Village%40yahoogroups.com [EMAIL PROTECTED] wrote: Axapta Knowledge Village Messages In This Digest (6 Messages) 1. Re: Dynamics AX 3.0 and FRx 6.7 From: Nancy L Hall 2a. Re: Disable a field on the form From: Varden Morris 2b. Re: Disable a field on the form From: Arijit Basu 3. XML Document parse which is on web From: Ramazan GÝRGÝN 4. Re: Editing the inventory dimensions after posting a transaction From: Nihar Saraiya 5. Re: AOS Stops Immediately After Starting From: abdollah mostafa View All Topics | Create New Topic Messages 1. Re: Dynamics AX 3.0 and FRx 6.7 Posted by: Nancy L Hall nlhall77477@ mailto:nlhall77477%40yahoo.com yahoo.com nlhall77477 Sat Nov 25, 2006 7:42 am (PST) Yes, you do need a separate odbc connection for FRx and AX. --- Tarek Saleh [EMAIL PROTECTED] mailto:tarekegy4%40yahoo.com com wrote: Hi i m also new in Frx but i think you should make a spechial ODBC for FRX rather than useng the same one that connect for AXDB Just check it out Regards Tarek - Original Message From: axapta_soporte axapta_soporte@ mailto:axapta_soporte%40yahoo.com.mx yahoo.com.mx To: Axapta-Knowledge- mailto:Axapta-Knowledge-Village%40yahoogroups.com [EMAIL PROTECTED] Sent: Thursday, November 23, 2006 8:43:34 PM Subject: [Axapta-Knowledge-Village] Dynamics AX 3.0 and FRx 6.7 Hi everyone, I am new with FRx and I want to use it with Dynamics AX 3.0. I install the FRx 6.7 version from the partner source and I have checked the installation manual but I still don't know how to use the FRx module with the Dynamics Ax 3.0 database. When I try to dimension wizard for FRx I get the next error: An error has occurred when connecting to the data base This happens in the step 1 of the wizard, I enter the my Dynamics data base name here. I have installed the entire FRx component from the installation wizard. If someone can help me or tell where to find some documentation about this topic, I will appreciate it a lot. Thanks in advance Alex! __ Do you Yahoo!? Everyone is raving about the all-new Yahoo! Mail beta. http://new.mail. http://new.mail.yahoo.com yahoo.com [Non-text portions of this message have been removed] __ Yahoo! Music Unlimited Access over 1 million songs. http://music. http://music.yahoo.com/unlimited yahoo.com/unlimited Back to top Reply to sender | Reply to group | Reply via web post Messages in this topic (4) 2a. Re: Disable a field on the form Posted by: Varden Morris [EMAIL PROTECTED] mailto:vardenm%40yahoo.com com vardenm Sat Nov 25, 2006 9:22 am (PST) Change the allowEdit property of the field on the form data source node to No. This will disable the field everywhere it's being used on the form. To disable the field on all user interface in the application you should set the AllowEdit property of the field on the TABLE to No. V G learnaxapta@ mailto:learnaxapta%40gmail.com gmail.com wrote: Hi I want to disable a field on the form which is in auto group. Thanks in advance for help Regards [Non-text portions of this message have been removed] Varden Morris 85 Saddleland Close N.E. Calgary, Alberta T3J 5J5 Canada (403) 366-8434 (H) (403) 615-1604 (C) [EMAIL PROTECTED] mailto:vardenm%40yahoo.com com - Cheap Talk? Check out Yahoo! Messenger's low PC-to-Phone call rates. [Non-text portions of this message have been removed] Back to top Reply to sender | Reply to group | Reply via web post Messages in this topic (3) 2b. Re: Disable a field on the form Posted by: Arijit Basu arijit.basu@ mailto:arijit.basu%40gmail.com gmail.com jijo_24 Sat Nov 25, 2006 8:50 pm (PST) You can also try this FormStringControl XYZ; XYZ= element.design().control(Control::ControlName); XYX.visible(false); Cheers On 11/25/06, Varden Morris [EMAIL PROTECTED] mailto:vardenm%40yahoo.com com wrote: Change the allowEdit property of the field on the form data source node to No. This will disable the field everywhere it's being used on the form. To disable the field on all user interface
RE: [Axapta-Knowledge-Village] Import to General Jouranl?
Dear Kareem You may use ledgerjournaltrans table for importing the journal lines. Regards P Saravanakumar 09894999281 -Original Message- From: Kareem [mailto:[EMAIL PROTECTED] Sent: Thursday, November 30, 2006 11:21 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Import to General Jouranl? Hey How can I import data from excel sheets to GL journal head and General journal lines?I already have journals created in Axapta, but i want to add new ones? what fields needed to be in excel? what are the tables needed? and how to do the import procedure? thanks [Non-text portions of this message have been removed]
[Axapta-Knowledge-Village] Settlement Issue
Dear Friends At the time of customer settlement we found the following Red Mark Symbol in customer open transaction settlement Screen. That Marked Item was generated from General Ledger Journal. Any one of you faced this problem, please advice how to resolve this issues. Regards P Saravanakumar 09894999281 [Non-text portions of this message have been removed]
RE: [Axapta-Knowledge-Village] Settlement Issue
Dear Yogesh But there is no unposted journals available. Regards P Saravanakumar 09894999281 -Original Message- From: yogesh kasat [mailto:[EMAIL PROTECTED] Sent: Friday, December 15, 2006 6:36 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: Re: [Axapta-Knowledge-Village] Settlement Issue Hi Saravanakumar, Reason for this red mark is: This invoice is marked for settlement in some other journal line and that journal is not posted. Regards, Yogesh Kasat --- p.saravanakumar p.saravanakumar@ mailto:p.saravanakumar%40tvssons.com tvssons.com wrote: Dear Friends At the time of customer settlement we found the following Red Mark Symbol in customer open transaction settlement Screen. That Marked Item was generated from General Ledger Journal. Any one of you faced this problem, please advice how to resolve this issues. Regards P Saravanakumar 09894999281 [Non-text portions of this message have been removed] __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail. http://mail.yahoo.com yahoo.com [Non-text portions of this message have been removed]
RE: [Axapta-Knowledge-Village] Settlement Issue
Thanks Dear It is working fine. Regards P Saravanakumar 09894999281 -Original Message- From: yogesh kasat [mailto:[EMAIL PROTECTED] Sent: Monday, December 18, 2006 12:33 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] Settlement Issue Hi Saravana, Please check records in SpecTrans table, you will find record for settlement of this transaction in SpecTrans Table. Field RefTableId will have value of tableid of CustTransOpen Table and RefRecId will have value of RecId of this perticular record in CustTransOpen Table. If you find this record, delete the same. hope this works, Regards, Yogesh Kasat --- p.saravanakumar p.saravanakumar@ mailto:p.saravanakumar%40tvssons.com tvssons.com wrote: Dear Yogesh But there is no unposted journals available. Regards P Saravanakumar 09894999281 -Original Message- From: yogesh kasat [mailto:[EMAIL PROTECTED] mailto:yrkasat2k%40yahoo.com com] Sent: Friday, December 15, 2006 6:36 PM To: Axapta-Knowledge- mailto:Axapta-Knowledge-Village%40yahoogroups.com [EMAIL PROTECTED] Subject: Re: [Axapta-Knowledge-Village] Settlement Issue Hi Saravanakumar, Reason for this red mark is: This invoice is marked for settlement in some other journal line and that journal is not posted. Regards, Yogesh Kasat --- p.saravanakumar p.saravanakumar@ mailto:p.saravanakumar%40tvssons.com tvssons.com wrote: Dear Friends At the time of customer settlement we found the following Red Mark Symbol in customer open transaction settlement Screen. That Marked Item was generated from General Ledger Journal. Any one of you faced this problem, please advice how to resolve this issues. Regards P Saravanakumar 09894999281 [Non-text portions of this message have been removed] __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail. http://mail. http://mail.yahoo.com yahoo.com yahoo.com [Non-text portions of this message have been removed] __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail. http://mail.yahoo.com yahoo.com [Non-text portions of this message have been removed]
[Axapta-Knowledge-Village] Axapta Outstanding Data
Dear Experts My End users wants to Age Wise Outstanding Data (ie. Backend Data) for given a date. I any body having a Sql query for this purpose please send me. Regards P Saravanakumar 09894999281 [Non-text portions of this message have been removed]
RE: YNT: [Axapta-Knowledge-Village] Settlement Issue
Thanks Dear Regards P Saravanakumar 09894999281 -Original Message- From: Karina Normann Jakobsen [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 19, 2006 5:16 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: YNT: [Axapta-Knowledge-Village] Settlement Issue There is also a feature in the application to find this. From customer table select function/open transaction editing. Place cursor on the transaction in question and press inquiries/specification - here you can see, which other transaction this one is marked against. [cid:image001.jpg@01C7236B.A980ECA0] Karina Normann Jakobsen Program Manager Microsoft Dynamics AX Microsoft Corporation From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Billur Kardas Sent: 15. december 2006 10:52 To: Axapta-Knowledge-Village@yahoogroups.com; Axapta-Knowledge-Village@yahoogroups.com Subject: YNT: [Axapta-Knowledge-Village] Settlement Issue As far as i understand that open transation has been marked by an other transaction or if not a forecasted transaction like sales order. You can trace it by having that transactions recid(custtrans) and searching it on custtransopen refrecid. Then by having that open transactions recid you can find the transaction on spectrans refid. The table num gives you the table which that table is attached. And the attached transactions specrecid's are equal. -Özgün Ýleti- Kimden: Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village %40yahoogroups.com bu kiþinin yerine p.saravanakumar Gönderilmiþ: Cum 15.12.2006 09:37 Kime: Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village %40yahoogroups.com Bilgi: Konu: [Axapta-Knowledge-Village] Settlement Issue Dear Friends At the time of customer settlement we found the following Red Mark Symbol in customer open transaction settlement Screen. That Marked Item was generated from General Ledger Journal. Any one of you faced this problem, please advice how to resolve this issues. Regards P Saravanakumar 09894999281 [Non-text portions of this message have been removed] __ Bu e-mail'in tüm icerigi gönderenin kisisel tasarrufu ile olusturulmus ve gönderilmistir. Oyak Teknoloji Bilisim ve Kart Hizmetleri A.S. bu e-mail icerigi hakkinda sorumluluk kabul etmez. This e-mail has been sent by the sender under his/her own individual discreation. Oyak Teknoloji Bilisim ve Kart Hizmetleri A.S. accepts no responsibility. [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Visit www.axapta-knowledge-village.tk Yahoo! Groups Links
[Axapta-Knowledge-Village] Form
Hi Friends Does any body tell me how to open the Particular URL While clicking the button from Axapta forms. Why I'm asking this question, I'm developed some Process outside axapta in web applications. Regards P Saravanakumar 09894999281 [Non-text portions of this message have been removed]
RE: [Axapta-Knowledge-Village] Encrypting password
Dear Can you tell me how encrypt the user's password using asp.net Suggestion is most welcome. Regards P Saravanakumar -Original Message- From: Brandon George [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 31, 2007 11:42 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] Encrypting password To talk about this further, such a thing is not needed, as the User Accounts are only aliases, as Active Directory manages the users, and therefore AD manages the passwords, etc. To conclude there is no need to perform this anymore, because you have to log into DAX 4.0 with a AD Domain Account. -Brandon From: Axapta-Knowledge- mailto:Axapta-Knowledge-Village%40yahoogroups.com [EMAIL PROTECTED] [mailto:Axapta-Knowledge- mailto:Axapta-Knowledge-Village%40yahoogroups.com [EMAIL PROTECTED] On Behalf Of Andrae, Tobias Sent: Wednesday, January 31, 2007 12:46 PM To: Axapta-Knowledge- mailto:Axapta-Knowledge-Village%40yahoogroups.com [EMAIL PROTECTED] Subject: AW: [Axapta-Knowledge-Village] Encrypting password Show me a place to enter the password for AX 4 . Tobias Von: Axapta-Knowledge- mailto:Axapta-Knowledge-Village%40yahoogroups.com [EMAIL PROTECTED] mailto:Axapta-Knowledge-Village%40yahoogroups.com [mailto:Axapta-Knowledge- mailto:Axapta-Knowledge-Village%40yahoogroups.com [EMAIL PROTECTED] mailto:Axapta-Knowledge-Village%40yahoogroups.com ] Im Auftrag von Akash Gesendet: Mittwoch, 31. Januar 2007 18:37 An: Axapta-Knowledge- mailto:Axapta-Knowledge-Village%40yahoogroups.com [EMAIL PROTECTED] mailto:Axapta-Knowledge-Village%40yahoogroups.com Betreff: [Axapta-Knowledge-Village] Encrypting password Hi All, In Axapta 3.0 , we have build password method of Dictionary system class to encrypt the password entered. But in 4.0 , it has been removed. Here is what the help says in Axapta 3.0 - Dictionary.buildPassword Run on: Called Description Builds an encrypted version of the given password - Is there any way we can achieve this in Dynamics Ax40? Thanks in Advancs Akash __ Do you Yahoo!? Everyone is raving about the all-new Yahoo! Mail beta. http://new.mail. http://new.mail.yahoo.com yahoo.com http://new.mail. http://new.mail.yahoo.com yahoo.com [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
RE: [Axapta-Knowledge-Village] Modifying lookups forms
Dear Friends Any body have SQL Query for using custtrans, custtransopen and custsettlement table for taking age wise customer outstanding data from the database directly. If yes please send it me, my customers wants the data urgently. Regards P Saravanakumar 09894999281 [Non-text portions of this message have been removed]
[Axapta-Knowledge-Village] FW: [oracle_champions] Fwd: Fw: Simple to find Lost Mobile
Dear Friends FYI Regards P Saravanakumar 09894999281 -Original Message- From: Kumar [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 21, 2007 3:38 PM To: Prameela (10th); Bhemisetty Madhu; Bujji Baava(AKP); [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; 'Kishore - Satyam[EMAIL PROTECTED],'Kishore - Satyam; Adari Eswar(TCS); Ashok Bharat; Bharani Lavanya; chandra sekhar; D.Suneel; Hemanth Srinivas; Jagadeesh(Inter); Mammu; Mujahutullah(Bujji); Mujahutullah(Bujji); Murali Krishna; Naramsetti Satish Kumar; Rajesh(Nagesh-Satyam); Ram Mohan Reddy; Ramesh (Annayya); Ramya (Sai); Santosh(ORACLE); Srinivas (Arnold); Srinu (EEE); Surendhra (Pappu); Surendhra (Pappu); Surendra Reddy; Suresh (Sevam); Jagadeesh; [EMAIL PROTECTED] Subject: [oracle_champions] Fwd: Fw: Simple to find Lost Mobile -- Forwarded message -- From: usha devi [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] com Date: Feb 21, 2007 10:14 AM Subject: Fwd: Fw: Simple to find Lost Mobile To: ad.krishnaveni@ mailto:[EMAIL PROTECTED] gmail.com, [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] co.in, [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] co.in, akunuri_evelyn@ mailto:[EMAIL PROTECTED] yahoo.com, [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] ibm.com, babusovereign@ mailto:[EMAIL PROTECTED] gmail.com , bharath10041982@ mailto:[EMAIL PROTECTED] gmail.com, bhargavi_katragadda mailto:[EMAIL PROTECTED] [EMAIL PROTECTED], bindu_gh414@ mailto:[EMAIL PROTECTED] yahoo.co.in , [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] com, chmadhubabu2002@ mailto:[EMAIL PROTECTED] yahoo.co.in, [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] com, deepu_yanam@ mailto:[EMAIL PROTECTED] yahoo.com, devi_mudunuru@ mailto:[EMAIL PROTECTED] yahoo.com, divakar.iitkgp@ mailto:[EMAIL PROTECTED] gmail.com, divyalakshmi_ mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] , [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] com, [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] com, [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] com, ganga_satishkumar@ mailto:[EMAIL PROTECTED] yahoo.co.in, [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] com, gunturu.kameswari@ mailto:[EMAIL PROTECTED] gmail.com, hara.basana@ mailto:[EMAIL PROTECTED] gmail.com , hima_bindu09@ mailto:[EMAIL PROTECTED] yahoo.com, itsmeshravanthi@ mailto:[EMAIL PROTECTED] yahoo.co.in, jeshurun_hastings@ mailto:[EMAIL PROTECTED] yahoo.co.in , kavitha_534@ mailto:[EMAIL PROTECTED] yahoo.com, kiran_kumar63@ mailto:[EMAIL PROTECTED] yahoo.com, kona.suresh@ mailto:[EMAIL PROTECTED] gmail.com, kriskishore123@ mailto:[EMAIL PROTECTED] gmail.com, kumarsarisa@ mailto:[EMAIL PROTECTED] gmail.com, [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] com, [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] com, [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] com, madu_prasanna@ mailto:[EMAIL PROTECTED] yahoo.com, manasakedari@ mailto:[EMAIL PROTECTED] rediffmail.com, missamma_bindu@ mailto:[EMAIL PROTECTED] yahoo.co.in , movvarajabhushan@ mailto:[EMAIL PROTECTED] gmail.com, [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] cm, [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] com, [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] com, [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] com, nalamotusirisha@ mailto:[EMAIL PROTECTED] yahoo.co.in, namithakp21@ mailto:[EMAIL PROTECTED] yahoo.co.in , nandini_potnuru@ mailto:[EMAIL PROTECTED] yahoo.com, [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] com, [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] com, naveena_kranthi@ mailto:[EMAIL PROTECTED] yahoo.co.in, [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] com, [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] co.in, padmajaadabala@ mailto:[EMAIL PROTECTED] gmail.com , ppvsgpal_2k5@ mailto:[EMAIL PROTECTED] yahoo.co.in, praveena_y2k4u@ mailto:[EMAIL PROTECTED] yahoo.com, princessahi@ mailto:[EMAIL PROTECTED] gmail.com, rambabu.gpl@ mailto:[EMAIL PROTECTED] gmail.com, rambabu_gpl@ mailto:[EMAIL PROTECTED] yahoo.co.in, ravisundar_kolli@ mailto:[EMAIL PROTECTED] rediffmail.com, [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] com , varma.girish@ mailto:[EMAIL PROTECTED] gmail.com, vempatiramana@ mailto:[EMAIL PROTECTED] gmail.com, abhilash kunjappan [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] com , aruna priya arunapriyadarshini@ mailto:[EMAIL PROTECTED] yahoo.com, kalyani kalyani [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] com, Kausik Susarla kausik.susarla@ mailto:[EMAIL PROTECTED] gmail.com, Kumar Kalyani [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] com, Natra Srinivas natrasrinivas@ mailto:[EMAIL PROTECTED] gmail.com, phani bhushan kandalaphani@ mailto:[EMAIL PROTECTED] gmail.com, sandeep. neeli sandeep.neeli@ mailto:[EMAIL PROTECTED] gmail.com, soujanya jami soujanya_jami_ mailto:[EMAIL PROTECTED] [EMAIL PROTECTED], srinivas ravva ravva.s.rao@ mailto:[EMAIL PROTECTED] gmail.com, Vempati Srinivasu vempati.srinivasu@ mailto:[EMAIL PROTECTED] gmail.com , vudath sravanthi [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] co.in -- Forwarded message -- From: Soujanya Jami [EMAIL
RE: AW: [Axapta-Knowledge-Village] COMPANY NAME ID 3 chars???
Thru AOT You can change it Regards P Saravanakumar Co-Its 09894999281 -Original Message- From: sherin francis [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 21, 2007 3:36 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: Re: AW: [Axapta-Knowledge-Village] COMPANY NAME ID 3 chars??? Hi Tobias, Thanks for the reply... but just wondering... u had mentioned that an increase in this field would increase the whole database, how would this increase be possible? Would it be through SQL Server directly? since, i haven't found any way of increasing this field directly through the AOT... Rgds, Susy Andrae, Tobias tobias.andrae@ mailto:tobias.andrae%40stz-loerrach.de stz-loerrach.de wrote: Hi Susy, the company ID (== DataAAreaID) is an system type and thus it cannot be changed. In addition, always keep in mind, that this field is part of *all* tables and any increasing would increase the whole database... hth Tobias Von: Axapta-Knowledge- mailto:Axapta-Knowledge-Village%40yahoogroups.com [EMAIL PROTECTED] im Auftrag von dyna_ax Gesendet: Mi 21.02.2007 05:39 An: Axapta-Knowledge- mailto:Axapta-Knowledge-Village%40yahoogroups.com [EMAIL PROTECTED] Betreff: [Axapta-Knowledge-Village] COMPANY NAME ID 3 chars??? Hi Group, Is it possible to have the company name id more than 3 characters? If so, any insight on how it is to be done would be helpful... Thanks, Susy [Non-text portions of this message have been removed] - Don't be flakey. Get Yahoo! Mail for Mobile and always stay connected to friends. [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
RE: [Axapta-Knowledge-Village] AssetBook and AssetTrans
Dear Kareem It is useful for you. select DATAAREAID,ASSETGROUP, assetid, NAME, TECHINFO1, TECHINFO2, TECHINFO3, sum(assetval) assetval, sum(netbookvalue) netbookvalue from ( sELECT A.DATAAREAID, A.ASSETID, E.NAME, A.ASSETGROUP, E.TECHINFO1, E.TECHINFO2, E.TECHINFO3, SUM(b.AMOUNTMST) ASSETVAL, 0 NetBookValue FROM Axatvstst.AssetBook A, Axatvstst.AssetTrans B, AXATVSTST.AssetDepreciationProfile C, AXATVSTST.ASSETBOOKTABLE D, AXATVSTST.ASSETTABLE E Where A.DATAAREAID = B.DATAAREAID AND A.ASSETID=B.ASSETID AND A.ASSETGROUP=D.BOOKID AND D.DEPRECIATIONPROFILE=C.PROFILE AND A.DATAAREAID=E.DATAAREAID AND A.ASSETID=E.ASSETID AND B.TRANSTYPE IN (1,2) AND B.TRANSDATE TO_DATE('01/04/2006','DD/MM/') GROUP BY A.DATAAREAID, A.ASSETID, E.NAME, A.ASSETGROUP, E.TECHINFO1, E.TECHINFO2, E.TECHINFO3 union sELECT A.DATAAREAID, A.ASSETID, E.NAME, A.ASSETGROUP, E.TECHINFO1, E.TECHINFO2, E.TECHINFO3, SUM(0) ASSETVAL, SUM(b.AMOUNTMST) NetBookValue FROM Axatvstst.AssetBook A, Axatvstst.AssetTrans B, AXATVSTST.AssetDepreciationProfile C, AXATVSTST.ASSETBOOKTABLE D, AXATVSTST.ASSETTABLE E Where A.DATAAREAID = B.DATAAREAID AND A.ASSETID=B.ASSETID AND A.ASSETGROUP=D.BOOKID AND D.DEPRECIATIONPROFILE=C.PROFILE AND A.DATAAREAID=E.DATAAREAID AND A.ASSETID=E.ASSETID AND B.TRANSDATE TO_DATE('01/04/2006','DD/MM/') GROUP BY A.DATAAREAID, A.ASSETID, E.NAME, A.ASSETGROUP, E.TECHINFO1, E.TECHINFO2, E.TECHINFO3 ) WHERE ASSETGROUP BETWEEN '033' AND '033' group by DATAAREAID, ASSETGROUP,assetid, NAME, TECHINFO1, TECHINFO2, TECHINFO3 Regards P Saravanakumar Co-Its 09894999281 -Original Message- From: Kareem [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 28, 2007 12:07 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] AssetBook and AssetTrans Hi, I want to know more about these two tables: AssetBook and AssetTrans. I know that AssetTrans contains all the transactions of fix assets, but how is it related to AssetBook? I noted that not all transactions that exist in TransTable are in the assetBook table? so what data actually is stored in the AssetBook?and when this table is updated? thanks, [Non-text portions of this message have been removed]
RE: [Axapta-Knowledge-Village] Re: AssetBook and AssetTrans
It is working the backend Regards P Saravanakumar 09894999281 -Original Message- From: Kareem [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 28, 2007 1:01 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Re: AssetBook and AssetTrans What is this for? --- In Axapta-Knowledge- mailto:Axapta-Knowledge-Village%40yahoogroups.com [EMAIL PROTECTED], p.saravanakumar [EMAIL PROTECTED] wrote: Dear Kareem It is useful for you. select DATAAREAID,ASSETGROUP, assetid, NAME, TECHINFO1, TECHINFO2, TECHINFO3, sum(assetval) assetval, sum(netbookvalue) netbookvalue from ( sELECT A.DATAAREAID, A.ASSETID, E.NAME, A.ASSETGROUP, E.TECHINFO1, E.TECHINFO2, E.TECHINFO3, SUM(b.AMOUNTMST) ASSETVAL, 0 NetBookValue FROM Axatvstst.AssetBook A, Axatvstst.AssetTrans B, AXATVSTST.AssetDepreciationProfile C, AXATVSTST.ASSETBOOKTABLE D, AXATVSTST.ASSETTABLE E Where A.DATAAREAID = B.DATAAREAID AND A.ASSETID=B.ASSETID AND A.ASSETGROUP=D.BOOKID AND D.DEPRECIATIONPROFILE=C.PROFILE AND A.DATAAREAID=E.DATAAREAID AND A.ASSETID=E.ASSETID AND B.TRANSTYPE IN (1,2) AND B.TRANSDATE TO_DATE('01/04/2006','DD/MM/') GROUP BY A.DATAAREAID, A.ASSETID, E.NAME, A.ASSETGROUP, E.TECHINFO1, E.TECHINFO2, E.TECHINFO3 union sELECT A.DATAAREAID, A.ASSETID, E.NAME, A.ASSETGROUP, E.TECHINFO1, E.TECHINFO2, E.TECHINFO3, SUM(0) ASSETVAL, SUM(b.AMOUNTMST) NetBookValue FROM Axatvstst.AssetBook A, Axatvstst.AssetTrans B, AXATVSTST.AssetDepreciationProfile C, AXATVSTST.ASSETBOOKTABLE D, AXATVSTST.ASSETTABLE E Where A.DATAAREAID = B.DATAAREAID AND A.ASSETID=B.ASSETID AND A.ASSETGROUP=D.BOOKID AND D.DEPRECIATIONPROFILE=C.PROFILE AND A.DATAAREAID=E.DATAAREAID AND A.ASSETID=E.ASSETID AND B.TRANSDATE TO_DATE('01/04/2006','DD/MM/') GROUP BY A.DATAAREAID, A.ASSETID, E.NAME, A.ASSETGROUP, E.TECHINFO1, E.TECHINFO2, E.TECHINFO3 ) WHERE ASSETGROUP BETWEEN '033' AND '033' group by DATAAREAID, ASSETGROUP,assetid, NAME, TECHINFO1, TECHINFO2, TECHINFO3 Regards P Saravanakumar Co-Its 09894999281 -Original Message- From: Kareem [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 28, 2007 12:07 PM To: Axapta-Knowledge- mailto:Axapta-Knowledge-Village%40yahoogroups.com [EMAIL PROTECTED] Subject: [Axapta-Knowledge-Village] AssetBook and AssetTrans Hi, I want to know more about these two tables: AssetBook and AssetTrans. I know that AssetTrans contains all the transactions of fix assets, but how is it related to AssetBook? I noted that not all transactions that exist in TransTable are in the assetBook table? so what data actually is stored in the AssetBook?and when this table is updated? thanks, [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
[Axapta-Knowledge-Village] SQL Query for AXAPTA BACKEND DATABASE
Hi Friends Does anybody having a SQL Query for taking reports directly from Backend Database in Axapta? Or where I get it from? Regards P Saravanakumar Co-Its 09894999281 [Non-text portions of this message have been removed]
RE: [Axapta-Knowledge-Village] SQL Query for AXAPTA BACKEND DATABASE
Dear Srinivas We are using Oracle Database Regards P Saravanakumar 09894999281 -Original Message- From: Ajit Srivastava [mailto:[EMAIL PROTECTED] Sent: Friday, May 18, 2007 4:55 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: Re: [Axapta-Knowledge-Village] SQL Query for AXAPTA BACKEND DATABASE Hello srinivas, U hav to do by Sql Server 2005 reporting services.. Regards Ajit Srivastava @ +91441034Technical Consultant NSL - A Tata Group Company New Delhi -110 058 Tel. +91(11) 25544 703 / 4704 Telefax +91(11) 25544705 Websites: www.tata.com/nelito/index.htm www.nelito.com - Original Message From: p.saravanakumar p.saravanakumar@ mailto:p.saravanakumar%40tvssons.com tvssons.com To: Axapta-Knowledge- mailto:Axapta-Knowledge-Village%40yahoogroups.com [EMAIL PROTECTED] Sent: Friday, 18 May, 2007 1:06:36 PM Subject: [Axapta-Knowledge-Village] SQL Query for AXAPTA BACKEND DATABASE Hi Friends Does anybody having a SQL Query for taking reports directly from Backend Database in Axapta? Or where I get it from? Regards P Saravanakumar Co-Its 09894999281 [Non-text portions of this message have been removed] __ Yahoo! India Answers: Share what you know. Learn something new http://in.answers. http://in.answers.yahoo.com/ yahoo.com/ [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
RE: [Axapta-Knowledge-Village] SQL Query for AXAPTA BACKEND DATABASE
Dear Pankaj Yes, Now we are taking this way, but my question is some of the data could not match with original Axapta figures. So I required the sample queries from internet. Where I can get? Regards P Saravanakumar Co-Its 09894999281 -Original Message- From: Pankaj Kant [mailto:[EMAIL PROTECTED] Sent: Monday, May 21, 2007 5:15 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] SQL Query for AXAPTA BACKEND DATABASE Dear Sarvana U need to connect to Axapta Database using SQL-Net Connect Client and run your query for generating the report Best regards Pankaj From: Axapta-Knowledge- mailto:Axapta-Knowledge-Village%40yahoogroups.com [EMAIL PROTECTED] [mailto:Axapta-Knowledge- mailto:Axapta-Knowledge-Village%40yahoogroups.com [EMAIL PROTECTED] On Behalf Of p.saravanakumar Sent: Monday, May 21, 2007 4:26 PM To: Axapta-Knowledge- mailto:Axapta-Knowledge-Village%40yahoogroups.com [EMAIL PROTECTED] Subject: RE: [Axapta-Knowledge-Village] SQL Query for AXAPTA BACKEND DATABASE Dear Srinivas We are using Oracle Database Regards P Saravanakumar 09894999281 -Original Message- From: Ajit Srivastava [mailto:contact2ajit2006@ mailto:contact2ajit2006%40yahoo.co.in yahoo.co.in mailto:contact2ajit2006%40yahoo.co.in ] Sent: Friday, May 18, 2007 4:55 PM To: Axapta-Knowledge- mailto:Axapta-Knowledge-Village%40yahoogroups.com [EMAIL PROTECTED] mailto:Axapta-Knowledge-Village%40yahoogroups.com Subject: Re: [Axapta-Knowledge-Village] SQL Query for AXAPTA BACKEND DATABASE Hello srinivas, U hav to do by Sql Server 2005 reporting services.. Regards Ajit Srivastava @ +91441034Technical Consultant NSL - A Tata Group Company New Delhi -110 058 Tel. +91(11) 25544 703 / 4704 Telefax +91(11) 25544705 Websites: www.tata.com/nelito/index.htm www.nelito.com - Original Message From: p.saravanakumar p.saravanakumar@ mailto:p.saravanakumar%40tvssons.com tvssons.com To: Axapta-Knowledge- mailto:Axapta-Knowledge-Village%40yahoogroups.com [EMAIL PROTECTED] mailto:Village%40yahoogroups.com .com mailto:Village%40yahoogroups.com Sent: Friday, 18 May, 2007 1:06:36 PM Subject: [Axapta-Knowledge-Village] SQL Query for AXAPTA BACKEND DATABASE Hi Friends Does anybody having a SQL Query for taking reports directly from Backend Database in Axapta? Or where I get it from? Regards P Saravanakumar Co-Its 09894999281 [Non-text portions of this message have been removed] __ Yahoo! India Answers: Share what you know. Learn something new http://in.answers. http://in.answers. http://in.answers.yahoo.com/ yahoo.com/ http://in.answers. http://in.answers.yahoo.com/ yahoo.com/ yahoo.com/ [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] The information contained in this communication is intended solely for the use of the individual or entity to whom it is addressed and others authorized to receive it. It may contain confidential or legally privileged information. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. If you have received this communication in error, please notify us immediately by responding to this email and then delete it from your system This email may have been intercepted, partially destroyed, arrive late, incomplete or contain viruses and no liability is accepted by LG Life Sciences India Pvt. Ltd. (LGLSI) as a result. Opinions, conclusions and other information in this message represent the opinion of the sender and do not necessarily represent or reflect the views and opinions of LGLSI. [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]