[Axapta-Knowledge-Village] Sending reports as attachment by batch process - Urgent
Dear All, I am using Ax 2009 Sp1 with windows 2008 r2 64 bit machine.I can send report as attachment,but when i try to send reports as attachment by using batch process i am getting following error message.I have configured SMTP information as well as batch related information. Error message: COM object of class 'CDO .Message' could not be created. Ensure that the object has been properly registered on computer computername Thanks for your reply Thanks, Sakthivel
[Axapta-Knowledge-Village] New objects moving to vap layer automatically
We are using Ax 3.0 with oracle 9i database and project has gone live just few months back. We are having 3 environment (development, testing and production) and all the development has done in VAR layer. Recently we are facing the problem in development application where development work is saved into VAP layer even though we are working on VAR (its already set in the Axapta configuration utility). When we try to delete this VAP development then system is throwing error and not allow to delete the object. I have read in the axapta help file where the range has been mentioned for the VAR layer development (30001-3). I have created one table in this application and its created with the id no (31728) and subsequently the next no is assigned to the object Map. When i tried to create any Form, Report and view then system saved these objects into VAP layer. We have to release some new functionality therefore the same would require the development and currently our development application is down due to this issue.
Re: [Axapta-Knowledge-Village] Query regarding company and user rights
Hi, Go to Administration - Setup - Domains 1) Create Domains for each company .(For this,Open Domain form, create Domain D1 in Domain tab and link the company C1 in company accounts tab . similarly you have to do for D2 - C2, D3 - C3) 2) Now you have to create User groups, like UG1, UG2,UG3. Assign the user like, UG1 - U1, UG2 - U2, UG3 - U3. [In feature, you can add the additional user to these groups] 3) Select the UG1 record and click permission button in user groups form. it will open other form, Provide access to D1,D2,D3 4) Select the UG2 record and click permission button in user groups form. it will open other form, Provide access to D2 5) Select the UG3 record and click permission button in user groups form. it will open other form, Provide access to D2,D3 Hope this will help you. Thanks, Vijaykarthik K On Fri, Apr 23, 2010 at 6:58 PM, Sahin Sivaslioglu sivaslioglusa...@yahoo.com wrote: Hi, Did you try record level security? Regards, --- On *Thu, 4/22/10, ROHIT JOSHI azurear...@yahoo.co.in* wrote: From: ROHIT JOSHI azurear...@yahoo.co.in Subject: [Axapta-Knowledge-Village] Query regarding company and user rights To: Axapta-Knowledge-Village@yahoogroups.com, axapta knowledge village Axapta-Knowledge-Village@yahoogroups.com Date: Thursday, April 22, 2010, 8:32 PM Hi all, i have a query, my company is having multiple company in Microsoft Dynamics AX, and we have to give fe company rights to few user and few other company rights to remaining user; for e.g: we have three company c1, c2, c3. and 3 users u1, u2, u3. how can i give rights in following way, *u1 - rights for c1, c2, c3.* * * *u2 rights for just c1.* * * *and * *u3 rights for c2, c3.* and i want, even at the bottom right of the AX 2009 screen where select company account is there, there also it should show only relevant company eg: for *u2 its should show only company c1, * and no athore company to select for. -- With Regards Rohit Joshi 00 968 92321969 (@ OMAN)
[Axapta-Knowledge-Village] DAX - Project Module Item Requirement Workflow
Hi All, one of my client require Item requirement workflow in the Project module. As per the client business process, the client has many projects in different sites and in every project there will be a Requester and Project manager. these two users are mandatory for every project, and they will vary [Users inside the project]from one project to other project depend on the business flow. In AX if we customize new Template for Project Item Requirement Workflow, and we can assign the users based on (a) role based (b) Hierarchy Based (c)User based, But we do not have on Project based. But in this client case, from every project the Requestor will raise a request of item requirement from the particular project and the concern Project manager should approve that based on some [limit]amount consideration of the item requirement per line and total amount. if the define limit of the item requirement per line amount and total amount crosses then Project Director should approve. NOTE: Project Director will be same for all projects and manages from the Head office. so if we customize the new Template for Project item Requirement workflow, how can we assign and send notifications to concern project manager, if the requester of that project submits the item requirement. once requester submits it should trigger notification to concern project manager only, do we have this functionality in DAX standard. or do we need customize in Workflow configuration form assignment tab Please suggest me in this case. Regards, Kumar.
Re: [Axapta-Knowledge-Village] Hi
don't right much code in control...it is not at all best way in the point of microsoft. \kik From: Anitha S mail2eani...@gmail.com To: Axapta-Knowledge-Village@yahoogroups.com Sent: Tuesday, 22 September, 2009 2:44:05 AM Subject: Re: [Axapta-Knowledge-Village] Hi Hi, So ur requirement is for the current record, u r generating an item code on a button click event . if my understanding is correct, u can write your logic of updating the Itemid in the button click event itself. Regards, Anitha. On Tue, Sep 22, 2009 at 1:28 PM, rameshp papineni ramesh_p2384@ yahoo.co. in wrote: Hi i am not modifying any existing item number,i want replace the item number with my newly created item code in the inventtable form. Regards Ramesh From: Anitha S mail2eanitha@ gmail.com To: Axapta-Knowledge- vill...@yahoogro ups.com Sent: Tuesday, 22 September, 2009 12:29:59 PM Subject: Re: [Axapta-Knowledge- Village] Hi Hi, I could not get your requirement. Are u updating the ItemCode for an already exisiting item ?? Regards, Anitha On Tue, Sep 22, 2009 at 11:25 AM, ramesh_p2384 ramesh_p2384@ yahoo.co. in wrote: Hi All i have a problem in Form level. I.e i have developed a one form - name is InventMaster, that form should be open from InventTable Form using with (Ctr+N) or click new. upto this part i have done, whenever my form is open from InventTable form ,there i can select all my fields after when i click ok button one Itemcode is generated. So finally i want that itemcode should be inserted at Inventtable form level. for this problem where i have to write code in form level. Regards Ramesh From cricket scores to your friends. Try the Yahoo! India Homepage! From cricket scores to your friends. Try the Yahoo! India Homepage! http://in.yahoo.com/trynew
Re: [Axapta-Knowledge-Village] Company Account ID Change
Hi Friend, It is not possible to chage the Company Id to 6 -charecter. Becase company comes from system data type. It is relating to kernel. Cheers, Kik... kishore.0...@gmail.com From: AX Consultant consultan...@gmail.com To: Axapta-Knowledge-Village@yahoogroups.com Sent: Tuesday, 30 June, 2009 2:16:10 PM Subject: [Axapta-Knowledge-Village] Company Account ID Change Dear All, I have a special request from client side that is to change Company Accounts ID. The available limit of the field is 4 Character Maximum and currently the ID is . Now Clients want to change the ID from to 6 Character. I tried, but unable to change it. Is it possible to change Company Accounts ID while already some transaction has been posted? Is there any possibility to increase the length of Company Accounts ID, if possible how the references of this change will be propagated? Thanks, Yahoo! recommends that you upgrade to the new and safer Internet Explorer 8. http://downloads.yahoo.com/in/internetexplorer/
Re: [Axapta-Knowledge-Village] Initialization Problem
Hi Friend, It seems to be problem with some usergroups.I have faced these types of errors in past. Try to Identifying the which groups that caused the problem . But Beawre that. Killing AX services from task manager is not suggested way.. In test mission its ok. But in production side it casues loss of data Cheers, kik.. From: S Hasan bukhari shasan_bukh...@yahoo.com To: Axapta-Knowledge-Village@yahoogroups.com Sent: Thursday, 25 June, 2009 2:32:56 PM Subject: Re: [Axapta-Knowledge-Village] Initialization Problem Dear Mudassar, Please check if there is any customization in your AOT. Because this message comes when there is some customization. --- On Thu, 6/25/09, Mudassar popololo_y2k@ yahoo.com wrote: From: Mudassar popololo_y2k@ yahoo.com Subject: [Axapta-Knowledge- Village] Initialization Problem To: Axapta Axapta-Knowledge- vill...@yahoogro ups.com Date: Thursday, June 25, 2009, 12:30 AM Dear All, I have just restored the Database in SQL of my current company. now AX is given me error on startup %2 %1 not initialized . and this msg is continuously prompting. i had to End Task AX in task manager. any help! Regards. Yahoo! recommends that you upgrade to the new and safer Internet Explorer 8. http://downloads.yahoo.com/in/internetexplorer/
Re: [Axapta-Knowledge-Village] Reg:Ax 2009 India Demo Data
Hi Buddy, You can find In MS partner source... BR, kik. From: suneel babu suneel...@hotmail.com To: Development development-axa...@yahoogroups.com; Axapta Knowledge village axapta-knowledge-village@yahoogroups.com; Arjit babu Ax arijit.b...@gmail.com; amit bhatt AX amit_bha...@yahoo.com Sent: Wednesday, 24 June, 2009 12:25:51 PM Subject: [Axapta-Knowledge-Village] Reg:Ax 2009 India Demo Data Dear All., Any one have the Demo Data for Ax 2009 Indian Localization. I want ti know it is released or not? Regards., Suneel... Get easy photo sharing with Windows Live™ Photos. Drag n’ drop Looking for local information? Find it on Yahoo! Local http://in.local.yahoo.com/
Re: [Axapta-Knowledge-Village] (unknown)
AX 3.0 better place to search and MSDN BR, kik From: Pooja . dyna.a...@yahoo.com To: development-axapta development-axa...@yahoogroups.com; groups dynamicsg...@yahoogroups.com; groups microsoft_dynamics_axa...@yahoogroups.com; groups secretsofdynamicssoftwar...@yahoogroups.com; groups Axapta-Knowledge-Village@yahoogroups.com; groups msdynamicsaxfo...@yahoogroups.com; groups dynamics...@yahoogroups.com; groups dynamic...@yahoogroups.com Sent: Wednesday, 17 June, 2009 1:43:24 PM Subject: [Axapta-Knowledge-Village] (unknown) Hi Guys, Im new to Ax,How to write the Lookup on the field with some lsit Pooja Looking for local information? Find it on Yahoo! Local http://in.local.yahoo.com/
Re: [Axapta-Knowledge-Village] Re: number Sequence group for sales order
Hi Buddy, Check which config key is ristricting the Groupbutton... Then try to turn on the config key Then you can see the button in enable mode... Also check is there any validations in form level.. I hope this help to resolve your issue Cheers. kik From: nahidansar nahidan...@yahoo..co.in To: Axapta-Knowledge-Village@yahoogroups.com Sent: Wednesday, 17 June, 2009 7:08:44 PM Subject: [Axapta-Knowledge-Village] Re: number Sequence group for sales order Hi, Thanks for your reply ...But its not getting enabled. --- In Axapta-Knowledge- vill...@yahoogro ups.com, Anitha S mail2eanitha@ ... wrote: Hi. Go to Tables -NumberSequenceRef erence and enable the field *GroupEnabled* for SalesOrder number seq. On Mon, Jun 15, 2009 at 4:25 PM, nahidansar nahidansar@ ... wrote: Hi, In the Accounts receivable Parameters windowI see the Groups button enable for packing slip and few more rows... How can I enable the Groups button for sales order option... P.s: Although I am able to generate sales orders numbers based on number sequece group logic, I still dont see the groups button enabled on the Prameters window. Thnaks in advance. Yahoo! recommends that you upgrade to the new and safer Internet Explorer 8. http://downloads.yahoo.com/in/internetexplorer/
Re: [Axapta-Knowledge-Village] Print Option Tab.
HI Dear, Check wich securiy ker or configuration key is ristricting the button.. Then u can easyly enable the button.. Cheers, kik From: Khalil Rehman khalilrehm...@hotmail.com To: Knowlege Village axapta-knowledge-village@yahoogroups.com; Development AX development...@yahoogroups.com Sent: Tuesday, 16 June, 2009 5:03:32 PM Subject: [Axapta-Knowledge-Village] Print Option Tab. Dear All, in some Report Dailog Windows under Select - Print Option Tab is not shown. is it possible how to show this. to print Grand Totals etc. KHALIL UR REHMAN check out the rest of the Windows Live™. More than mail–Windows Live™ goes way beyond your inbox. More than messages Yahoo! recommends that you upgrade to the new and safer Internet Explorer 8. http://downloads.yahoo.com/in/internetexplorer/
Re: SV: [Axapta-Knowledge-Village] Company Account ID Change
yes AX limited company ID for 4 charecter it is not possible to change... you can find 5 charecter in AX 2009... BR, kik From: Søren Ager s...@armstrongit.dk To: Axapta-Knowledge-Village@yahoogroups.com Sent: Wednesday, 1 July, 2009 2:58:06 PM Subject: SV: [Axapta-Knowledge-Village] Company Account ID Change Den 30. juni 2009 23:48 skrev Axapta-Knowledge- vill...@yahoogro ups.com: but i am surprised to know if this minor change can not be handled easily. Why - with 4 characters and using letters and numbers you can create 1679616 companies - I doubt you hitting that limit ;-) Søren See the Web#39;s breaking stories, chosen by people like you. Check out Yahoo! Buzz. http://in.buzz.yahoo.com/
Re: [Axapta-Knowledge-Village] changing default inventory unit strange error
HI Buddy, Plz check in InventTrans whuch are records having blank If it is blank delete thosse records,... I hope this will helps you to resolve u r issue. Cheers, kik From: Abdullah Al-Nunu aaln...@netways.com.sa To: Axapta-Knowledge-Village@yahoogroups.com Axapta-Knowledge-Village@yahoogroups.com Sent: Tuesday, 16 June, 2009 8:20:04 PM Subject: [Axapta-Knowledge-Village] changing default inventory unit strange error Dears, I’ve got this strange error while creating a new item “The inventory unit for item cannot be changed because transactions exist. If the transactions cannot be deleted you will need to use a new item number with a new inventory unit.” I got the error when I tried to change the default Inventory unit . The item that I was trying to create is still not saved in the system Impossible to have an exist transactions for unsaved item. Anybody has any idea for this strange behavior ?? Regards Abdullah Al Nunu ERP Consultant _ _ Jeddah - Saudi Arabia Mobile:00966- 50-7402504 Email: aaln...@netways. com.sa Website: www.netways.com. sa Love Cricket? Check out live scores, photos, video highlights and more. Click here http://cricket.yahoo.com
Re: [Axapta-Knowledge-Village] OutLook
There is no much diffrence from AX 4.0 to AX 2009... you can find better data in MSDN and partner source... BR, kik. From: Pooja . dyna.a...@yahoo.com To: development-axapta development-axa...@yahoogroups.com; groups dynamicsg...@yahoogroups.com; groups microsoft_dynamics_axa...@yahoogroups.com; groups secretsofdynamicssoftwar...@yahoogroups.com; groups Axapta-Knowledge-Village@yahoogroups.com; groups msdynamicsaxfo...@yahoogroups.com; groups dynamics...@yahoogroups.com; groups dynamic...@yahoogroups.com Sent: Tuesday, 16 June, 2009 9:39:05 AM Subject: [Axapta-Knowledge-Village] OutLook Do you know How to Integrate OutLook with Ax 2009 Love Cricket? Check out live scores, photos, video highlights and more. Click here http://cricket.yahoo.com
Re: [Axapta-Knowledge-Village] Fw: Cannot start AOS (AX4-SP2)
you can check whether the data base form version of SQL server... I think you are restoring data from lower version to heigher version. u r event log showing some other thinks check sql is running base N/W authentication or Local account... Cheers, kik... From: Belal Marzouk belal_marz...@yahoo.com To: Axapta-Knowledge-Village@yahoogroups.com Sent: Tuesday, 16 June, 2009 9:10:39 AM Subject: [Axapta-Knowledge-Village] Fw: Cannot start AOS (AX4-SP2) --- On Mon, 6/15/09, Belal Marzouk belal_marzouk@ yahoo.com wrote: From: Belal Marzouk belal_marzouk@ yahoo.com Subject: Cannot start AOS (AX4-SP2) To: Axapta-Knowledge- vill...@yahoogro ups.com Date: Monday, June 15, 2009, 7:37 PM Hello, I instaled Dynamics AX4.0 SP1 then installed SP2. The Database name is Dynamics and AOS instance name is MB. Then I detached the created database by the installer Dynamics and attached the customer database which has the same name Dynamics. After that I get the following error when trying to start Dynamics Service. /-- Windows could not start the Dynamics Server$01-MB on Local Computer. For more information, review the System Evenet Log. If this is a non-Microsoft service, contact the service vendor, and refer to service-specific error code 100. --/ When I detach the customer database Dynamics and reattach the initially created database the service starts normally. I have Windows 2003 R3 Enterprise SP2 installed for both AOS and Database server and Sql Server 2005 SP3 For more information I am copying Errors in Application Event Log below - --- Event Type: Error Event Source: Dynamics Server 01 Event Category: None Event ID: 163 Time: 04:08:09 pm User: N/A Computer: MB Description: Object Server 01: SQL diagnostics: [Microsoft][ ODBC SQL Server Driver][SQL Server]Cannot open database Dynamics requested by the login. The login failed.. Connect information was: Userid = [], Database = [Dynamics], Server = [10.0.0.71], DSN = [], Other = [] For more information, see Help and Support Center at http://go.microsoft .com/fwlink/ events.asp.. - --- Then I uninstalled AOS and installed it again with SP2. The errors reported in Application Event Log changed as the following - --- Event Type: Information Event Source: Dynamics Server 01 Event Category: None Event ID: 110 Time: 05:59:23 pm User: N/A Computer: MB Description: Object Server 01: Server main session is being destroyed. For more information, see Help and Support Center at http://go.microsoft .com/fwlink/ events.asp. - --- Event Type: Error Event Source: Dynamics Server 01 Event Category: None Event ID: 110 Time: 05:59:23 pm User: N/A Computer: MB Description: Object Server 01: Dialog issued for client-less session 1: The program is unable to load and execute the class 'SqlDatabaseInit' , which is essential in order to identify the database vendor, and load the appropriate SQL system variables. This can be caused by insufficient access rights to the SQL Database, a missing or corrupted application file, or syntax error(s) within the class itself. For more information, see Help and Support Center at http://go.microsoft .com/fwlink/ events.asp. - --- Event Type: Error Event Source: Dynamics Server 01 Event Category: None Event ID: 110 Time: 05:59:23 pm User: N/A Computer: MB Description: Object Server 01: Dialog issued for client-less session 1: [Microsoft][ ODBC SQL Server Driver][SQL Server]There is already an object named 'SQLSYSTEMVARIABLES ' in the database. [CREATE TABLE DBO.SQLSYSTEMVARI ABLES( PARM NVARCHAR(30) NOT NULL, VALUE NVARCHAR(254) NULL, IPARM INT NULL, IVALUE INT NULL)] For more information, see Help and Support Center at http://go.microsoft .com/fwlink/ events.asp. - --- Event Type: Error Event Source: Dynamics Server 01 Event Category: None Event ID: 110 Time: 05:59:23 pm User: N/A Computer: MB Description: Object Server 01: Dialog issued for client-less session 1: Cannot execute the required database operation. The SQL database has issued an error. For more information, see Help and Support Center at http://go.microsoft .com/fwlink/ events.asp. - --- Event Type: Error Event Source: Dynamics Server 01 Event Category: None Event ID: 163 Time: 05:59:23 pm User: N/A Computer: MB Description: Object Server 01: SQL diagnostics: [Main Microsoft Dynamics Application Object Server Session]Unable to report problem. Attempted to open message 287. For more information, see Help and Support Center at http://go.microsoft .com/fwlink/ events.asp. - --- Event Type: Error Event Source: Dynamics Server 01 Event Category: None Event ID: 117 Time: 05:59:23 pm User: N/A Computer: MB Description: Object Server 01: The database reported (session 1 (-AOS-)):
Re: [Axapta-Knowledge-Village] number Sequence group for sales order
Check config... to the pertucular button... I hope it will resolves ur problem.. BR, kik From: nahidansar nahidan...@yahoo.co.in To: Axapta-Knowledge-Village@yahoogroups.com Sent: Monday, 15 June, 2009 4:25:15 PM Subject: [Axapta-Knowledge-Village] number Sequence group for sales order Hi, In the Accounts receivable Parameters windowI see the Groups button enable for packing slip and few more rows... How can I enable the Groups button for sales order option... P.s: Although I am able to generate sales orders numbers based on number sequece group logic, I still dont see the groups button enabled on the Prameters window. Thnaks in advance. Yahoo! recommends that you upgrade to the new and safer Internet Explorer 8. http://downloads.yahoo.com/in/internetexplorer/
Re: [Axapta-Knowledge-Village] Customer Vendor to BRL
you can find best articles in partner sourche how to syc.emp,ven,cust, to BR in AX 2009... BR, kik From: axma...@ymail.com axma...@ymail.com To: Axapta-Knowledge-Village@yahoogroups.com Sent: Wednesday, 10 June, 2009 11:37:15 AM Subject: [Axapta-Knowledge-Village] Customer Vendor to BRL Dear Friends, What is the functionality for syncronize Customer or Vendor or Employee to Business relation in Ax-2009. This option is available in earlier versions. But i want to know in Ax-2009. Please Guide me. Regards. Kumar S Looking for local information? Find it on Yahoo! Local http://in.local.yahoo.com/
Re: [Axapta-Knowledge-Village] Dynamics AX Openings..
Could you please give me the details of the job's roles and responsibilites? Thanks, Vijay On Fri, Mar 27, 2009 at 12:40 PM, stshind stsh...@yahoo.com wrote: Hi, We have an urgent requirement for Dynamics AX Professionals (Technical and Functional) for Gulf. Very competitive package. One Month Paid Vacation with Air Tickets to Country of origin, Tax Free Salary, Health Care, etc. Please send your CVs with following information: Current CTC: Expected CTC: Passport Status: Notice Period: Thanks,
Re: [Axapta-Knowledge-Village] Re: Clr object is not initialized...
convert that dll into strong name,and add that dll into windows assembly folder,then add that dll into reference folder.Then follow the next step as you mentioned. Thanks, Sakthivel --- On Fri, 3/6/09, anamika_singh.2001 anamika_singh.2...@yahoo.com wrote: From: anamika_singh.2001 anamika_singh.2...@yahoo.com Subject: [Axapta-Knowledge-Village] Re: Clr object is not initialized... To: Axapta-Knowledge-Village@yahoogroups.com Date: Friday, March 6, 2009, 4:22 AM Hi, I tried to call this dll and its function by assert the permissions first, using the interOpPermission. And while using InteropKind as DLLInterop, it throws error: Message (09:44:25) Request for the permission of type 'InteropPermission' failed. (S)\Classes\ InteropPermissio n\demand (S)\Classes\ CLRInterop\ getObjectForAnyT ype (S)\Classes\ CurrencyConvert\ run - line 16 (S)\Classes\ CurrencyConvert\ main - line 8 And while using InteropKind as CLRInterop, it throws error: InteropKind as DLLInterop, it throws error: Clr object is not initialized. Object 'CLRObject' could not be created. Can you know why this problem happens? and What would be the possible solution for this scenario? Thanks... --- In Axapta-Knowledge- vill...@yahoogro ups.com, Sumit Loya loya.sumit@ wrote: Hi, You will have to assert the permissions first using the InterOpPermission class and InteropKind as DLLInterop. Otherwise the class will not be initialized. Regards, Sumit On Thu, Mar 5, 2009 at 3:05 PM, anamika_singh. 2001 anamika_singh. 2...@... wrote: Hi, How to resolve the following error? Clr object is not initialized. Object 'CLRObject' could not be created. My scenario: I created a dll and added this dll to AX client's bin directory, then Iadded this dll to AOT references. I tried to call this dll and its functions in class it throws an above described error. Can you know why this problem happens? and What would be the possible solution for this scenario? Thanks...
Re: [Axapta-Knowledge-Village] Calling Info() in .net business connector
Hi, i tried but i couldn't able to get it.Could u send me sample code to display welcome message in axapta through .net business connector it will be very helpful for me to proceed further. Thanks, Sakthivel --- On Mon, 2/23/09, Sakthivel K sakaxa...@yahoo.com wrote: From: Sakthivel K sakaxa...@yahoo.com Subject: Re: [Axapta-Knowledge-Village] Calling Info() in .net business connector To: Axapta-Knowledge-Village@yahoogroups.com Date: Monday, February 23, 2009, 12:59 PM Hi, thanks.I will try ur logic if any issues i let you know. Thanks, Sakthivel --- On Sat, 2/21/09, MaryAnn Hand maryann.hand@ gmail.com wrote: From: MaryAnn Hand maryann.hand@ gmail.com Subject: Re: [Axapta-Knowledge- Village] Calling Info() in .net business connector To: Axapta-Knowledge- vill...@yahoogro ups.com Date: Saturday, February 21, 2009, 11:30 AM I do not know for sure what is the problem - maybe there is no message in that session to retrieve. I can tell you that I have had the most success with .net business connector when I do my own coding on the X++ side and call my own class methods from .net. Then it is also easy for me to actually debug my code - both in .net AND in X++. I suggest that you try the following. 1) Create a new class in AX and add the method getLastMessage in the xinfo.text example (pasted below). 2) Then create your class in .NET rather than the info class. 3) Call your getLastMessage method from your .NET code. To debug you must check the checkboxes both to debug on server in server configuration and to debug Business Connector in client configuration. Make sure that in Tools Options on Development tab that the Debug Mode is set to When Breakpoint (which will get set automatically if you put a breakpoint in your getLastMessage method). Open the debugger from Tools Developer Tools. Then begin debugging in .NET and when you call the getLastMessage method, you will be able to pace through the code in the AX debugger. Then hopefully you can see the message you are looking for. Here is the code pasted from AX help: public str getLastMessage( ) { int currentLine = infolog.line( ); str messageText = ''; ; if (currentLine infoLogStartLine) { // Message text only available if something new // was added to the infolog messageText = strltrim(strrtrim (this.trimLeadingTa bs(infolog. text(currentLine ; } return messageText; } On Sat, Feb 21, 2009 at 3:05 AM, Sakthivel K sakaxa...@yahoo. com wrote: Hi, i tried to call info() in .net business connector,but i couldn't able to do.Below is my .net code.when i am trying to call this .net method in my class i could not able to see info window.If any error in this code please correct it. public string showMsgNewStr( ) { Axapta ax; string infoLogText = ; try { // Login to Microsoft Dynamics Ax. ax = new Axapta(); ax.Logon( null, null, null, null); object infolog = ax.GetObject( InfoLog ); AxaptaObject infoClass = ax.CreateAxaptaObje ct(Info ); infoLogText = ( String)infoClass. Call(text ,1)+Hi; } catch (Exception e) { Console.WriteLine( An error occurred in object creation or Axapta logon: {0}, e.Message); } return infoLogText; } Thanks, Sakthivel
Re: [Axapta-Knowledge-Village] Calling Info() in .net business connector
Hi, thanks.I will try ur logic if any issues i let you know. Thanks, Sakthivel --- On Sat, 2/21/09, MaryAnn Hand maryann.h...@gmail.com wrote: From: MaryAnn Hand maryann.h...@gmail.com Subject: Re: [Axapta-Knowledge-Village] Calling Info() in .net business connector To: Axapta-Knowledge-Village@yahoogroups.com Date: Saturday, February 21, 2009, 11:30 AM I do not know for sure what is the problem - maybe there is no message in that session to retrieve. I can tell you that I have had the most success with .net business connector when I do my own coding on the X++ side and call my own class methods from .net. Then it is also easy for me to actually debug my code - both in .net AND in X++. I suggest that you try the following. 1) Create a new class in AX and add the method getLastMessage in the xinfo.text example (pasted below). 2) Then create your class in .NET rather than the info class. 3) Call your getLastMessage method from your .NET code. To debug you must check the checkboxes both to debug on server in server configuration and to debug Business Connector in client configuration. Make sure that in Tools Options on Development tab that the Debug Mode is set to When Breakpoint (which will get set automatically if you put a breakpoint in your getLastMessage method). Open the debugger from Tools Developer Tools. Then begin debugging in .NET and when you call the getLastMessage method, you will be able to pace through the code in the AX debugger. Then hopefully you can see the message you are looking for. Here is the code pasted from AX help: public str getLastMessage( ) { int currentLine = infolog.line( ); str messageText = ''; ; if (currentLine infoLogStartLine) { // Message text only available if something new // was added to the infolog messageText = strltrim(strrtrim (this.trimLeadingTa bs(infolog. text(currentLine ; } return messageText; } On Sat, Feb 21, 2009 at 3:05 AM, Sakthivel K sakaxa...@yahoo. com wrote: Hi, i tried to call info() in .net business connector,but i couldn't able to do.Below is my .net code.when i am trying to call this .net method in my class i could not able to see info window.If any error in this code please correct it. public string showMsgNewStr( ) { Axapta ax; string infoLogText = ; try { // Login to Microsoft Dynamics Ax. ax = new Axapta(); ax.Logon( null, null, null, null); object infolog = ax.GetObject( InfoLog ); AxaptaObject infoClass = ax.CreateAxaptaObje ct(Info ); infoLogText = ( String)infoClass. Call(text ,1)+Hi; } catch (Exception e) { Console.WriteLine( An error occurred in object creation or Axapta logon: {0}, e.Message); } return infoLogText; } Thanks, Sakthivel
[Axapta-Knowledge-Village] Calling Info() in .net business connector
Hi, i tried to call info() in .net business connector,but i couldn't able to do.Below is my .net code.when i am trying to call this .net method in my class i could not able to see info window.If any error in this code please correct it. public string showMsgNewStr() { Axapta ax; string infoLogText = ; try { // Login to Microsoft Dynamics Ax. ax = new Axapta(); ax.Logon(null, null, null, null); object infolog = ax.GetObject(InfoLog); AxaptaObject infoClass = ax.CreateAxaptaObject(Info); infoLogText = (String)infoClass.Call(text,1)+Hi; } catch (Exception e) { Console.WriteLine(An error occurred in object creation or Axapta logon: {0}, e.Message); } return infoLogText; } Thanks, Sakthivel
[Axapta-Knowledge-Village] Passing Table objects in .Net Business connector
Hi, I am using Ax 2009,I want to pass table object into .net business connector.I can easily pass str,int variable and i could not able to pass table/class objects. Below is my coding. If it is str,int datatype i can directly pass str,int value in below method. In .Net side it is not giving error,but in Axapta side when i try to call this method i am getting err message saying that Argument 1 is not compatible with required data type. AX Code: EAMItemRequirements --is table. public InventTransRefId creatingPlannedPO(EAMItemRequirements _eamItemRequirements) { AXEAM01.AXEAM01 dllJr; str refIdval; ; dllJr = new AXEAM01.AXEAM01(); refIdval = dllJr.creatingplannedPO(_eamItemRequirements); return refIdval ; } ..Net code: public string creatingplannedPO(AxaptaRecord eamItemRequirements) { Axapta ax; Int32 sno, p; Int64 m = 0; object oL; string s = , frmInventLocId, toInventLocId, s1, s2, s3, refId = ; try { // Login to Microsoft Dynamics AX. ax = new Axapta(); ax.Logon(null, null, null, null); eamItemRequirements = ax.CreateAxaptaRecord(EAMItemRequirements); AxaptaRecord tReqPO = ax.CreateAxaptaRecord(ReqPO); .. } catch (Exception e) { Console.WriteLine(An error occurred in object creation or Axapta logon: {0}, e.Message); } return refId; } Thanks, Sakthivel
Re: [Axapta-Knowledge-Village] Passing Table objects in .Net Business connector
Hi MaryAnn, Thank you.In Ax side i am getting error in this line. refIdval = dllJr.creatingplann edPO(_eamItemReq uirements) ; And EAMItemRequirements is exist in AOT.Time being i just getting table field values in AX side and i am passing that values into .Net side.But that is not bestpractice to do. Thanks, Sakthivel --- On Wed, 2/18/09, MaryAnn Hand maryann.h...@gmail.com wrote: From: MaryAnn Hand maryann.h...@gmail.com Subject: Re: [Axapta-Knowledge-Village] Passing Table objects in .Net Business connector To: Axapta-Knowledge-Village@yahoogroups.com Date: Wednesday, February 18, 2009, 11:18 AM You can debug to be sure you know exactly which line of code issues the error in AX. The Development IV course has a chapter about using the .NET business connector and I would guess that the help has the same content. Here is a bit of information that might be helpful: 1) To debug both your .NET code as well as the AX code, modify server configuration to allow debugging on the server. Also modify the client configuration to allow debugging in the business connector. Set a breakpoint in AX code somewhere or go to the user Options and make sure that that the Debug Mode parameter is set to When Breakpoint (Which gets set automatically as soon as you set a breakpoint anywhere). Open the AX client and launch the debugger. 2) When you call CreateAxaptaRecord the string that you pass must be the name of an EXISTING Ax table. I do not think you can use that method, despite its name, to actually create a table in AX. The call that passes in ReqPO should not cause an error - but the call that passes in EAMItemRequirement s might be a problem if that table does not already exist in your environment. 3) I prefer to write most of the code in X++ in AX classes to do whatever work I need to do via .NET. I pass values as int and str to the class and let AX manipulate the tables via the class. So I use the AxaptaObject when I need to modify data in AX. I only use AxaptaRecord to retrieve information from AX into .NET I hope that helps. On Wed, Feb 18, 2009 at 3:54 AM, Sakthivel K sakaxa...@yahoo. com wrote: Hi, I am using Ax 2009,I want to pass table object into .net business connector.I can easily pass str,int variable and i could not able to pass table/class objects. Below is my coding. If it is str,int datatype i can directly pass str,int value in below method. In .Net side it is not giving error,but in Axapta side when i try to call this method i am getting err message saying that Argument 1 is not compatible with required data type. AX Code: EAMItemRequirements --is table. public InventTransRefId creatingPlannedPO( EAMItemRequireme nts _eamItemRequirement s) { AXEAM01.AXEAM01 dllJr; str refIdval; ; dllJr = new AXEAM01.AXEAM01( ); refIdval = dllJr.creatingplann edPO(_eamItemReq uirements) ; return refIdval ; } .Net code: public string creatingplannedPO( AxaptaRecord eamItemRequirements ) { Axapta ax; Int32 sno, p; Int64 m = 0; object oL; string s = , frmInventLocId, toInventLocId, s1, s2, s3, refId = ; try { // Login to Microsoft Dynamics AX. ax = new Axapta(); ax.Logon(null, null, null, null); eamItemRequirements = ax.CreateAxaptaReco rd(EAMItemRequi rements) ; AxaptaRecord tReqPO = ax.CreateAxaptaReco rd(ReqPO ); . . .. . . } catch (Exception e) { Console.WriteLine( An error occurred in object creation or Axapta logon: {0}, e.Message); } return refId; } Thanks, Sakthivel
[Axapta-Knowledge-Village] Tree control with Checkbox
Hi, i have a tree control with checkbox,once i select/deselect checkbox the corresponding node in that tree should be selected/deselected.How can we trigger checkbox event in tree control. Thanks, Sakthivel
Re: [Axapta-Knowledge-Village] Webservice error in workflow
Hi Manoj, AOS name exists in basic--batchjob- -view task and my URL also valid one. But the same Webservice failed error exists. Thanks, Sakthivel --- On Sat, 1/3/09, manoj manoharan manoj19842...@yahoo.co.in wrote: From: manoj manoharan manoj19842...@yahoo.co.in Subject: Re: [Axapta-Knowledge-Village] Webservice error in workflow To: Axapta-Knowledge-Village@yahoogroups.com Date: Saturday, January 3, 2009, 1:02 PM Shaktivel, Kindly check do you have AOS instance name in basic--batchjob- -view task .. Is your Workflow URL is valid? Now again run the Administration -- workflow admin wizard thanks Manoj --- On Sat, 3/1/09, Sakthivel K sakaxa...@yahoo. com wrote: From: Sakthivel K sakaxa...@yahoo. com Subject: Re: [Axapta-Knowledge- Village] Webservice error in workflow To: Axapta-Knowledge- vill...@yahoogro ups.com Date: Saturday, 3 January, 2009, 5:23 PM Hi Manoj, Thank you.I have 4 AOS,previously i was connecting to 3 rd AOS. I have uninstalled all workflow related components and reinstalled again,now i am connecting Workflow to 1 st AOS.But i am facing same problem. When i run Tuttorial_workflowp rocessor i am getting following error message. SysWorkflowmessageQ ueueManager- run SysWorkflowEventDis patcher-- -onAcknowledgewo rkflowActivation SysWorkflowEventDis patcher-- -raiseworkflowAc tivationEvent clrObject static method invocation error. Exception has been thrown by the target of an invocation. The following error list i have taken from EventViewer. Exception thrown in SysworkflowEventDis patcher-- -onAcknowledgewo rkflowActivation SysWorkflowEventDis patcher-- -raiseworkflowAc tivationEvent: Webservice failed workflow id:26_201 {0} cannot be null or empty. parameter name:workflowruntim eurl Thanks, Sakthivel --- On Fri, 1/2/09, manoj manoharan manoj19842001@ yahoo.co. in wrote: From: manoj manoharan manoj19842001@ yahoo.co. in Subject: Re: [Axapta-Knowledge- Village] Webservice error in workflow To: Axapta-Knowledge- vill...@yahoogro ups.com Date: Friday, January 2, 2009, 2:31 PM Hi , The port number in your URL is not a problem as long as it is valid URL( Click validate URL button) and check. Now How many AOS instances are running in your machine? If more than one , then there will be a problem . WF website will connect to first AOS instance which is installed in ur machine thru business connector. So you have to run ur WF in which the first AOS instance is refering. thanks Manoj --- On Wed, 31/12/08, Sakthivel K sakaxa...@yahoo. com wrote: From: Sakthivel K sakaxa...@yahoo. com Subject: [Axapta-Knowledge- Village] Webservice error in workflow To: Axapta-Knowledge- vill...@yahoogro ups.com Date: Wednesday, 31 December, 2008, 10:32 AM Hi, i have configured workflow in our module and created required elements needed for workflow.When i am submitting for workflow i am getting alert message saying that Webservice failed:workflow id # . In IIS Manager workflow components are placed in default website,but the default website and share point website shares the same port number 80.so i have changed the share point website port number to 81 and in workflow runtime URL i have given default website url.will it be a problem?or do we need to create new website same as default website? I have tried that too,but i am getting the same error message. Thanks, Sakthivel Add more friends to your messenger and enjoy! Invite them now. Add more friends to your messenger and enjoy! Invite them now.
Re: [Axapta-Knowledge-Village] Webservice error in workflow
Hi Manoj, Thank you.I have 4 AOS,previously i was connecting to 3 rd AOS. I have uninstalled all workflow related components and reinstalled again,now i am connecting Workflow to 1 st AOS.But i am facing same problem. When i run Tuttorial_workflowprocessor i am getting following error message. SysWorkflowmessageQueueManager-run SysWorkflowEventDispatcher---onAcknowledgeworkflowActivation SysWorkflowEventDispatcher---raiseworkflowActivationEvent clrObject static method invocation error. Exception has been thrown by the target of an invocation. The following error list i have taken from EventViewer. Exception thrown in SysworkflowEventDispatcher---onAcknowledgeworkflowActivation SysWorkflowEventDispatcher---raiseworkflowActivationEvent: Webservice failed workflow id:26_201 {0} cannot be null or empty. parameter name:workflowruntimeurl Thanks, Sakthivel --- On Fri, 1/2/09, manoj manoharan manoj19842...@yahoo.co.in wrote: From: manoj manoharan manoj19842...@yahoo.co.in Subject: Re: [Axapta-Knowledge-Village] Webservice error in workflow To: Axapta-Knowledge-Village@yahoogroups.com Date: Friday, January 2, 2009, 2:31 PM Hi , The port number in your URL is not a problem as long as it is valid URL( Click validate URL button) and check. Now How many AOS instances are running in your machine? If more than one , then there will be a problem . WF website will connect to first AOS instance which is installed in ur machine thru business connector. So you have to run ur WF in which the first AOS instance is refering. thanks Manoj --- On Wed, 31/12/08, Sakthivel K sakaxa...@yahoo. com wrote: From: Sakthivel K sakaxa...@yahoo. com Subject: [Axapta-Knowledge- Village] Webservice error in workflow To: Axapta-Knowledge- vill...@yahoogro ups.com Date: Wednesday, 31 December, 2008, 10:32 AM Hi, i have configured workflow in our module and created required elements needed for workflow.When i am submitting for workflow i am getting alert message saying that Webservice failed:workflow id # . In IIS Manager workflow components are placed in default website,but the default website and share point website shares the same port number 80.so i have changed the share point website port number to 81 and in workflow runtime URL i have given default website url.will it be a problem?or do we need to create new website same as default website? I have tried that too,but i am getting the same error message. Thanks, Sakthivel Add more friends to your messenger and enjoy! Invite them now.
Re: [Axapta-Knowledge-Village] Webservice error in workflow
Hi Bhaskar, Thanks.I have already done that steps too,but still i am getting error,my doubt is the error is because of default website in IIS that shares same port number with sharepoint site.Eventhough i have changed the portnumber for sharepoint site i could not able to proceed further. Thanks, Sakthivel --- On Wed, 12/31/08, bhasker vooradi bhaske...@yahoo.co.in wrote: From: bhasker vooradi bhaske...@yahoo.co.in Subject: Re: [Axapta-Knowledge-Village] Webservice error in workflow To: Axapta-Knowledge-Village@yahoogroups.com Date: Wednesday, December 31, 2008, 12:12 PM Hi, Check the below setups: Set the NumberSequence in BasicSetupSettingsforWorkflow form and run the wizard in AdministrationSetupWorkflowinfrastruct ureaconfiugratio nwizard Regards Bhaskar. From: Sakthivel K sakaxa...@yahoo. com To: Axapta-Knowledge- vill...@yahoogro ups.com Sent: Wednesday, 31 December, 2008 10:32:16 AM Subject: [Axapta-Knowledge- Village] Webservice error in workflow Hi, i have configured workflow in our module and created required elements needed for workflow.When i am submitting for workflow i am getting alert message saying that Webservice failed:workflow id # . In IIS Manager workflow components are placed in default website,but the default website and share point website shares the same port number 80.so i have changed the share point website port number to 81 and in workflow runtime URL i have given default website url.will it be a problem?or do we need to create new website same as default website? I have tried that too,but i am getting the same error message. Thanks, Sakthivel Add more friends to your messenger and enjoy! Invite them now.
[Axapta-Knowledge-Village] Webservice error in workflow
Hi, i have configured workflow in our module and created required elements needed for workflow.When i am submitting for workflow i am getting alert message saying that Webservice failed:workflow id # . In IIS Manager workflow components are placed in default website,but the default website and share point website shares the same port number 80.so i have changed the share point website port number to 81 and in workflow runtime URL i have given default website url.will it be a problem?or do we need to create new website same as default website? I have tried that too,but i am getting the same error message. Thanks, Sakthivel
[Axapta-Knowledge-Village] Diffrent error.
Hi Domain, I have one issue regarding Business connector and EP . Problem : We are currently developing a new eCommerce solution for Pronorm AS using ASP.NET 2.0 on IIS. During development sometimes the Kernel-Class xClassFactory reports missing a method globalCache. The only workaround I found to avoid this message when it appears, is to restart IIS-server. We have so far not proved a pattern for how and when this error occurs. FYI: We are using a patched version of the Ax Client and Business Connector (because DDE did not work in the standard SP2). This client version is not stable, and have a tendency to crash. Its crashes almost every time you try to exit the Ax Client. Details : AX 4.0 SP2(4.0.2503.116) It would be appreciated if any body provide the solution. I had followed lots of ways and I had searched in all sites. But I didn't found any details regarding this issue. Advanced thanks to all. Thanks and Regards, Kishore. [EMAIL PROTECTED] Add more friends to your messenger and enjoy! Go to http://messenger.yahoo.com/invite/
[Axapta-Knowledge-Village] How to create new label using Batch job
Hi, Can any one help me, how to create a new label by using Batch Process(RunBaseBatch). Thanks, Vijay karthik.K
[Axapta-Knowledge-Village] how to create a new Base enum in AOT through code
Hi I want to create a new base enum in AOT via x++ code. plz help me. Thanks in advance. Regards, Vijaykarthik.K
[Axapta-Knowledge-Village] Table Buffer Size is exceeded
nbsp; Hi, nbsp;nbsp;nbsp;nbsp; I am trying to add new fields in Purchtable,while adding new fieldsnbsp;i am getting one error nbsp; The total internal size of the records in your joined select statement is 20148 bytes,but microsoft dynamics by default performance tunednbsp; not to exceed 15360 bytes. Alternatively you have to specify a Buffer size value of 20Kb or higher in SQL Tabpage in Microsoft dynamics configurartion utility.The default value is 24 Kb. nbsp; So i changed the buffer size to 20Kb in Server Configurartion Utility--gt;Database Tuning--gt; Maximum Buffer size field. nbsp; After that i am getting same error for another table also. nbsp; Thanks, nbsp; Sakthivel nbsp; nbsp; nbsp;
[Axapta-Knowledge-Village] nedd help for LineNum field in PO / SO
Hi, I want to know that, why the LineNum field is maked real datatype in Purchase Line (PO)/ salesLine (SO). bcz i have some question regarding this, 1) Is their anywhere they are using the lineNumber as 1.1000,1.2000, etc. 2) Is that possible to acheive the line number like this? if yes, have we do any setting? If possible anyone explain the business scenario for the LineNum. Thanks in advance. Thanks, Vijaykarthik.K
Re: [Axapta-Knowledge-Village] PO in AX 3.0
--- kristanto surjadi [EMAIL PROTECTED] wrote: Just add a code in the form setting the PurchLine_ds.allowedit(false) when the active PurchTable is already a Purchase Order. [EMAIL PROTECTED] wrote: Dear, Is it possible that after approving the PO by changing it from Request to Purchase Order that the PO lines can't be changed. Right now, when the PO admin approve the PO by changing it to Purchase Order, the user can still go and change the PO lines without requesting another approval from the admin. Please adivse. Thanks and Regards, Fahad Neco_si_prej.doc Description: 2232631164-Neco_si_prej.doc
[Axapta-Knowledge-Village] Cost price Issue
Hi, need clarification,if u click Inventory Mgmt -- Items --'On Hand' button it will open 'On hand ' form. In that form 'On hand' tabpage go to onhand group there we can see 'Cost price'.This cost price is calcultaed by display methods. Now my questions i have to bring this 'Cost price' into my following form. Inventory Mgmt --Bill of material --'Lines' Menubutton.If u click 'Lines' it will open 'BOMConsistsOf' in that i have to bring above calculated cost price into Overview tabpage. I have used the same display method which was used in 'InventOnhandItem' form but its not working. Give me a solution. Thanks, Sakthivel - Never miss a thing. Make Yahoo your homepage.
Re: [Axapta-Knowledge-Village] How to change the currency format to Indian currency
hi sreekanth, indian Currency format is currently not available in Axapta. but we can acheive by using GlobalClass. plz look int o the method numeralsToTxt_EN in Global class. Similerly u can create a new method numeralsToTxt_IN and change it according to the indian currency. hope it helps u. Thanks, Vijay karthik.K On 12/3/07, sreekanth_buyya [EMAIL PROTECTED] wrote: Hai friends, This is sreekanth iam facing the problem with currency, in the purchase order form in the Net Amount field when we have the amount as 23,45,678=00 in Axapta it is displaying in Millons format,i.e 2,345,678=00 how to change the format in to indian currency i.e in to lacks,Thousands and Hunderds.if any knows reply. with regards , sreekanth. [Non-text portions of this message have been removed]
Re: [Axapta-Knowledge-Village] Ax Report
Hi, Call the report design dynamically in fetch() of the report Look in to this report: CustInvoiceVolume - Fetch(). Call the report design dynamically in init() of the report Look in to this report : BankStatement11- init() Regards, Vijaykarthik.K On 11/19/07, dj3mb3 [EMAIL PROTECTED] wrote: Hi, I have ti switch dinamically the Design Name diuring the fecth of a report, ... for many reason, I can't do that in the SetDesign method of the Report. Someone can help me to do that? Thanks dj3mb3 [Non-text portions of this message have been removed]
Re: [Axapta-Knowledge-Village] Manualy overiding credit control of sales order
Hi, Uncheck the Mantatory credit limit in AR- Customers - General(tab)-credit (group). Regards, Vijaykarthik.K On 11/17/07, riyazhp [EMAIL PROTECTED] wrote: if a customer's balance is more than his credit limit, is there a way to allow the sales order to be processed without increasing the credit limit or posting payments to brig down his balance. [Non-text portions of this message have been removed]
Re: [Axapta-Knowledge-Village] Failed to establizh a connection
Hi Rogger, It seems your Ax service is not started, go to Administrative Tool\services and Start the Ax service and then login. hidreas [EMAIL PROTECTED] wrote: Hi guys I have Axapta 4.0 and I can´t login to Axapta The error is Failed to establixh connection Some boy can help me please Rogger - Why delete messages? Unlimited storage is just a click away. [Non-text portions of this message have been removed]
Re: [Axapta-Knowledge-Village] lookup in salescreateorder form
Hi kartik, To add a field in customer account lookup go to the CustTable\Fieldgroups\Autolookup add the required fields that you want to show in custaccount lookup. in your case add the all exisisting fields along with your field i.e current custaccount lookup is showing 5 fields add these 5 fields along with your field and save the table. now the lookup will show the fields that you have added in the lookup field group of custTable. Regards, Ram kartik1_0072 [EMAIL PROTECTED] wrote: hi, all i want to add field in customer account lookup but i don't know how the original lookup is created. guide for adding field in lookup details that i know: rum method of sales create order void run() { salesTable_ds.create(); element.modifyForm(); super(); //see the following line SalesTable_ds.lookUpCustAccount(); if (!salesTableType) { element.close(); throw Exception::error; } } method written in datasource of salescreateorder form void lookUpCustAccount() { if (salesTableType) { if (salesCreateOrderForm.lookupCustAccount()) { //plz tell me where these methods r written or any other meaning of the following line SalesTable_custAccount.setFocus(); SalesTable_custAccount.lookUp(); } } } - Get the freedom to save as many mails as you wish. Click here to know how. [Non-text portions of this message have been removed]
[Axapta-Knowledge-Village] How to post a Purchase order through code
Hi All, My requirement is to create a PO and Posting through code from a dialog, i wrote the code to create a PO in the dialog.run( ) method after this i need to post the same PO with in the same method. Can any body plz tell me which class and method i have to use to do this. Thanks in advance Thanks, Ramu - Why delete messages? Unlimited storage is just a click away. [Non-text portions of this message have been removed]
Re: [Axapta-Knowledge-Village] Checking of Field Names and Field Types
Hi Ricardo, The below job explained, How we get the field details base type of fields. i had taken ' EmplTable', and check the field name 'Status'. static void FindTableColumn(Args _args) { SysDictTablesysDictTable; SysDictFieldsysDictField; int j; str tablename,fldName; Types type; ; tablename= 'EmplTable'; sysDictTable = new SysDictTable(tablename2id(tablename)); for(j=1; j=sysDictTable.fieldCnt(); j++) { fldName = sysDictTable.fieldName(sysDictTable.fieldCnt2Id(j)); if(fldName == 'status') { sysDictField = new SysDictField(tablename2id(tablename), sysDictTable.fieldCnt2Id(j)); type = sysDictField.baseType(); print 'Type: ',type; print 'Fieldname : ',fldName; pause; } } } hope it will help u. Thanks Regards, VijayKarthik.K mob:+91 9963005830 On 9/10/07, ricardodegouveia [EMAIL PROTECTED] wrote: Hi i'm trying to find out how in the emplTable or any table which fields are in the table, in other words i want to check if in code eg. field name = Race is a field in the EmplTable? as well how do you check the base type of the field like Race is it a string or enum and so on in code? Thanking you in Advance, Ricardo [Non-text portions of this message have been removed]
[Axapta-Knowledge-Village] Re: Trade and Logistics Exam
Hi Raj, Would you be able to email me the exam topics (T L) to [EMAIL PROTECTED] Thanks Nag --- In Axapta-Knowledge-Village@yahoogroups.com, Raj J [EMAIL PROTECTED] wrote: Hi Brandon , I have cleared T L Exam last week. Well, Training Manuals which you have are sufficient. You need to have practise on Inv/Purchase/Sales modules.. Please focus on the Exam Topics provided thru partner source website. Best Regards, Raj. Brandon George [EMAIL PROTECTED] wrote: Hello All! I was going for my MBSCM for Install And Admin, after getting my MBSCP for Programming, and thought to myself that 4.0 is about to come out, so I might as well wait. One of things I have still thought about getting certified in though is Trade and Logistics. It is what I have the most experience in when referring to a functional stand point. Anyway I have the training manuals for TLI, TLII, and BOM. I also have the what the exam covers. I was wanting to know though if anyone has taken here, and if they could give me some advice on it? Any pointers on what to really focus on? Any advice, etc. If I can prepare, and try and take it either end of week this week or two weeks from now, then I figure why not, and stop there. I wanted to get everyone's thoughts though on how hard it was, and really any advice at all that you can give me on the exam. Thanks, Brandon Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools - 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. - *** Wish Good, Think Good Speak Good, Do Good *** - Yahoo! Mail Bring photos to life! New PhotoMail makes sharing a breeze. [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. 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] printing invoice
Hi, I have trouble in printing Invoice. Can we send the invoice second time to the printer with any code in Axapta ? Is there any way to define that option ... __ Start your day with Yahoo! - Make it your home page! http://www.yahoo.com/r/hs Yahoo! Groups Sponsor ~-- Get fast access to your favorite Yahoo! Groups. Make Yahoo! your home page http://us.click.yahoo.com/dpRU5A/wUILAA/yQLSAA/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] printing invoice
I know it but my problem is about serial printing. Is there any code about multiple printing --- Bonk, David [EMAIL PROTECTED] wrote: You can re-print an invoice by going to the sales order - Inquiry (header) - invoice - Show- Original. That will re-print the invoice. David -Original Message- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of hakan köse Sent: Wednesday, November 23, 2005 2:55 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] printing invoice Hi, I have trouble in printing Invoice. Can we send the invoice second time to the printer with any code in Axapta ? Is there any way to define that option ... __ Start your day with Yahoo! - Make it your home page! http://www.yahoo.com/r/hs Sharing the knowledge on Axapta. Yahoo! Groups Links __ Start your day with Yahoo! - Make it your home page! http://www.yahoo.com/r/hs Yahoo! Groups Sponsor ~-- Get fast access to your favorite Yahoo! Groups. Make Yahoo! your home page http://us.click.yahoo.com/dpRU5A/wUILAA/yQLSAA/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] Re: HRM - Urgent
To enter the absence registration you have to do the following : Either this - Individual absence entries : - Assign an Absence Setup for the employee for whom you want to enter absence journal. [This is done in the Employee form under the Employment tab page] - Login as the employee who is in charge of the assigned Absence Setup. [logins are assigned to the employees in the Employee-General tab page] - create absence journals from Periodic - Mass Creation - Login as the employee to whom you want to enter the absence and then make the entries. It will work. Or this - Multi absence entries : - use the Multi-registration option to enter absence to the employees. Only employees with Absence Setup defined ( as explained above) are available. Regards, Suresh. From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of jaidev004 Sent: Thursday, August 04, 2005 4:30 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Re: HRM - Urgent -- ashi i am facing the same problem as urs when i click on registrations under absend its saying no open absence journals for a particular employee JN Any solution thanks jai - In Axapta-Knowledge-Village@yahoogroups.com, Ashi [EMAIL PROTECTED] wrote: Hi all, Can anybody tell me the complete cycle of how absence are registered for a particular employee or a group of employees. Also how can absence be approved. Thanks in advance Ashi __ 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.
RE: [Axapta-Knowledge-Village] Re: SQL script to do record count
Hi, If you just need the list of tables and the number of records in it, I think all u have to do is get the values of the column TABLE_NAME from the table USER_TABLES. Based on this info all you have to do is a COUNT(*) for those tables. You will end up with the returned value of record counts for those tables. I currently dont have Oracle installed, else I could have send the script. Regards, Suresh. From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of cdlmalherbe01 Sent: Thursday, August 04, 2005 5:04 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Re: SQL script to do record count Hi James, The following is crude and inefficient, but does the job. create table ##TableRecordCount (TableName varchar(256) not null, RecordCount bigint not null) declare @TableName varchar(256) declare @SqlString nvarchar(4000) declare Tables cursor read_only for select [name] from sysobjects where [xtype] in ('U') open Tables fetch next from Tables into @TableName while @@fetch_status -1 begin if @@fetch_status -2 begin set @SqlString = 'insert into ##TableRecordCount select ' + + ltrim(rtrim(@TableName)) + + ',count(*) from ' + @TableName exec sp_executesql @SqlString end fetch next from Tables into @TableName end select * from ##TableRecordCount close Tables deallocate Tables drop table ##TableRecordCount Hope it helps! Christoph --- In Axapta-Knowledge-Village@yahoogroups.com, James Flavell [EMAIL PROTECTED] wrote: Hi Does anyone have a SQL script that I can run against a Axapta DB to get a simple output of table name and record count for the table? I need to do a check of record counts from a SQL 7 to SQL 2000 upgrade to be sure everything is in order after the upgrade. Thank you very much James 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] SP4 Help
Harry, It does appear Regards. From: Axapta-Knowledge-Village@yahoogroups.com [mailto:Axapta-Knowledge-Village@yahoogroups.com] On Behalf Of Harry (Harshawardhan Deshpande Sent: Wednesday, June 22, 2005 10:01 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] SP4 Help hi I am not sure what is wrong on my machine but... if someone has installed SP4, can you click on help - about MBS-Axapta and tell me whether SP4 appears on the screen? regards harry Yahoo! Sports Rekindle the Rivalries. Sign up for Fantasy Football Sharing the knowledge on Axapta. 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 the Yahoo! Terms of Service.
[Axapta-Knowledge-Village] HR organization
Hi everyone, Can anyone tell me a brief description about the Head count in HR , what for is it used ? __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com Yahoo! Groups Sponsor ~-- In low income neighborhoods, 84% do not own computers. At Network for Good, help bridge the Digital Divide! http://us.click.yahoo.com/EpW3eD/3MnJAA/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] Re: HR organization
Thanks for information george, but i wonder if we can report head count statistics.Are daily, weekly and monthly reports available in the system. Can the system define automaticly the values. I will be preciated if you enlighten me about this subject ... --- George Chernev [EMAIL PROTECTED] wrote: Head count can be used to put limits or budgets for human resources per each unit in the organisation structure. You choose the unit on the left hand side of the screen and then select Head count button. Axapta gives you the opportunity for two budgets/limits - based on the number of employees (full-time postions field) and cost of HR (amount field). You must also indicate the date of the budget/limit, i.e. you can change the limit at some date in the future. The Head count functionality is usually used in reports. --- In Axapta-Knowledge-Village@yahoogroups.com, hakan köse [EMAIL PROTECTED] wrote: Hi everyone, Can anyone tell me a brief description about the Head count in HR , what for is it used ? __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com Yahoo! Groups Sponsor ~-- Has someone you know been affected by illness or disease? Network for Good is THE place to support health awareness efforts! http://us.click.yahoo.com/Rcy2bD/UOnJAA/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] Re: HR organization
Thanks for information george, but i wonder if we can report head count statistics.Are daily, weekly and monthly reports available in the system. Can the system define automaticly the values. I will be preciated if you enlighten me about this subject ... --- George Chernev [EMAIL PROTECTED] wrote: Head count can be used to put limits or budgets for human resources per each unit in the organisation structure. You choose the unit on the left hand side of the screen and then select Head count button. Axapta gives you the opportunity for two budgets/limits - based on the number of employees (full-time postions field) and cost of HR (amount field). You must also indicate the date of the budget/limit, i.e. you can change the limit at some date in the future. The Head count functionality is usually used in reports. --- In Axapta-Knowledge-Village@yahoogroups.com, hakan köse [EMAIL PROTECTED] wrote: Hi everyone, Can anyone tell me a brief description about the Head count in HR , what for is it used ? __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com __ Discover Yahoo! Have fun online with music videos, cool games, IM and more. Check it out! http://discover.yahoo.com/online.html Yahoo! Groups Sponsor ~-- In low income neighborhoods, 84% do not own computers. At Network for Good, help bridge the Digital Divide! http://us.click.yahoo.com/EpW3eD/3MnJAA/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] Re: HR organization
Thanks for information george, but i wonder if we can report head count statistics.Are daily, weekly and monthly reports available in the system. Can the system define automaticly the values. I will be preciated if you enlighten me about this subject ... --- George Chernev [EMAIL PROTECTED] wrote: Head count can be used to put limits or budgets for human resources per each unit in the organisation structure. You choose the unit on the left hand side of the screen and then select Head count button. Axapta gives you the opportunity for two budgets/limits - based on the number of employees (full-time postions field) and cost of HR (amount field). You must also indicate the date of the budget/limit, i.e. you can change the limit at some date in the future. The Head count functionality is usually used in reports. --- In Axapta-Knowledge-Village@yahoogroups.com, hakan köse [EMAIL PROTECTED] wrote: Hi everyone, Can anyone tell me a brief description about the Head count in HR , what for is it used ? __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com __ Discover Yahoo! Have fun online with music videos, cool games, IM and more. Check it out! http://discover.yahoo.com/online.html Yahoo! Groups Sponsor ~-- In low income neighborhoods, 84% do not own computers. At Network for Good, help bridge the Digital Divide! http://us.click.yahoo.com/EpW3eD/3MnJAA/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: RE : [Axapta-Knowledge-Village] Connecting to Other database from Axapta using X++
Hi Steeve, Thanks for the response. I was also able to achieve the same result using, as you have mentioned, ODBCConnection. I just had to set the server / username / password and voila, I was in!!! J Regards. From: Axapta-Knowledge-Village@yahoogroups.com [mailto:Axapta-Knowledge-Village@yahoogroups.com] On Behalf Of Steeve Gilbert Sent: Tuesday, May 24, 2005 7:40 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE : [Axapta-Knowledge-Village] Connecting to Other database from Axapta using X++ I've tested similar scenario on our Dev server. I use MS SQL as my DB. In the Enterprise Manager, go to Security folder of your Axapta DB server and in the Linked Servers nodes add your Scala server. With the use of ODBCConnection or UserConnection you can now do : select * from scaladb.dbo.someTable Hope it helps. Steeve... -Message d'origine- De: Axapta-Knowledge-Village@yahoogroups.com [mailto:Axapta-Knowledge-Village@yahoogroups.com] De la part de Suresh Kumar K. Envoyé: 24 mai 2005 08:10 À: Axapta-Knowledge-Village@yahoogroups.com Objet: [Axapta-Knowledge-Village] Connecting to Other database from Axapta using X++ Hi All, I have a scenario where I need to fetch data from different server / database and fetch a set of record from tables and insert those records into the tables of Axapta database which is different from the server / database where we are fetching data from. I have explained the scenario below for more clarification There are 2 server 1. Scala and its database is called ScalaDB 2. Axapta and its database is called AXDB. I have connected AXDB database using Axapta. Now my requirement is such that I need to connect for Scala server and ScalaDB database and fetch data from respective table of that database and insert the fetched data into AXDB database of Axapta server using X++. Taking into consideration that there is a mapping being already done between tables and fields of to different database. Regards, Jay. Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. 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 the Yahoo! Terms of Service.
[Axapta-Knowledge-Village] Connecting to Other database from Axapta using X++
Hi All, I have a scenario where I need to fetch data from different server / database and fetch a set of record from tables and insert those records into the tables of Axapta database which is different from the server / database where we are fetching data from. I have explained the scenario below for more clarification There are 2 server 1. Scala and its database is called ScalaDB 2. Axapta and its database is called AXDB. I have connected AXDB database using Axapta. Now my requirement is such that I need to connect for Scala server and ScalaDB database and fetch data from respective table of that database and insert the fetched data into AXDB database of Axapta server using X++. Taking into consideration that there is a mapping being already done between tables and fields of to different database. Regards, Jay. 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 the Yahoo! Terms of Service.
[Axapta-Knowledge-Village] Axapta ASP
Hi, Does anyone have any document for implementing Axapta ASP (Application Service Provider) module? Regards, Suresh. 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 the Yahoo! Terms of Service.
RE: [Axapta-Knowledge-Village] External Item - Sales Order
This customer number could be seen only in picking list with that way. You should still type the axapta number when you create a sales order .. --- Rick Hardy [EMAIL PROTECTED] wrote: Francisco, Thanks for the response, but when I do this and I go to the sales order form and try to enter the external item number on a sales order to that particular customer I get the message that the item does not exist in the item table? Rick _ From: Francisco Orozco [mailto:[EMAIL PROTECTED] Sent: Monday, March 28, 2005 3:31 PM To: Administrator Cc: Rick Hardy Subject: Re: [Axapta-Knowledge-Village] External Item - Sales Order Of course, go to Accounts Receivable, SetUp, Forms, Form Setup, Item Number =set it to BOTH, then go to the customer form, select the customer, then go to SetUp Button, then click on External Item Description. and enter as many ITEMS codes and descrptions for this particular customer., it should do it. Kind Regards Francisco Orozco - Original Message - From: rickhardy22 To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] External Item - Sales Order Date: Mon, 28 Mar 2005 19:51:48 - I was hoping somebody could help me out with external item numbers. We have customers that would like to use their own part numbers for ordering - which seems like a great fit for customer external item numbers. Is it possible to use the external item number on the sales order lines for ordering purposes? Thanks for you help... Rick Sharing the knowledge on Axapta. -- ___ Sign-up for Ads Free at Mail.com http://www.mail.com/?sr=signup http://mail01.mail.com/scripts/payment/adtracking.cgi?bannercode=adsfre ejump01 Sharing the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT click here http://us.ard.yahoo.com/SIG=129i12l9f/M=298184.6018725.7038619.3001176/ D=groups/S=1705001380:HM/EXP=1112131683/A=2593423/R=0/SIG=11el9gslf/*htt p:/www.netflix.com/Default?mqso=60190075 http://us.adserver.yahoo.com/l?M=298184.6018725.7038619.3001176/D=group s/S=:HM/A=2593423/rand=570584611 _ 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] mailto:[EMAIL PROTECTED] ubscribe * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service http://docs.yahoo.com/info/terms/ . __ Do you Yahoo!? Yahoo! Small Business - Try our new resources site! http://smallbusiness.yahoo.com/resources/ Yahoo! Groups Sponsor ~-- What would our lives be like without music, dance, and theater? Donate or volunteer in the arts today at Network for Good! http://us.click.yahoo.com/Tcy2bD/SOnJAA/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/