SV: [Axapta-Knowledge-Village] how do i get the database server names, database names

Try this: static void ListSQLServers(Args _args) { COM com = new COM(SQLDMO.Application); COM servers = com.ListAvailableSQLServers(); int i; ; for (i=1;i=servers.count();i++) info(servers.item(i)); } regards Thomas Fra:

SV: SV: [Axapta-Knowledge-Village] how do i get the database server names, database names

the databases names under the selected server and also its corresponding userid and password. urgent. regs, Hema. S Thomas Jensen [EMAIL PROTECTED] To: Axapta-Knowledge-Village@yahoogroups.com Sent by: cc: [EMAIL PROTECTED] Subject: SV: [Axapta-Knowledge-Village] how do i get the database

SV: [Axapta-Knowledge-Village] FW: Intercompany Elimination Entries in Axapta Consolidation

Hi Asrar I don't know what's best practice in this area, so this is just a suggestion for a simple solution. If you use separate ledger accounts for intercompany entries you can use a consolidation account in the ledger table to eliminate automatically when you consolidate. As far as I

SV: [Axapta-Knowledge-Village] invoice posting

Hi Gopal The second parameter in the purchFormletter.update method isn't used at all in the method. One way to solve this is to save the parameter in a class variable and later use it in the createParmTable method to initialize the PurchParmTable.Num field. Regards Thomas -Oprindelig

SV: [Axapta-Knowledge-Village] packing slip number error

Hi Gopal As you know the second parameter of the purchFormLetter.update method isn't used at all. No matter if you pass a packingslipId to the update method it isn't used and the packingslip is posted without a packingslipId. The second time you run your code the same day you will get this

SV: [Axapta-Knowledge-Village] tight integration on external software

Hi Tom You should be able to instantiate and call the COM connector from TSQL using the sp_OACreate stored procedure. I haven't tried it myself so I haven't got any experience on this. Regards Thomas -Oprindelig meddelelse- Fra: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL

SV: [Axapta-Knowledge-Village] Document Handling - Create Excel worksheet via COM

Hi Jack You have to make your own DocuAction class to transfer the multiple saleslines to Excel. Take a look at the smmDocuActionCOM_Word_Quotation class which adds the quotation lines to a table in a word document. Regards Thomas -Oprindelig meddelelse- Fra:

SV: [Axapta-Knowledge-Village] XML Soap Ingtegration

Hi Shahzad I have implemented my own demo a long time ago using the XMLPortal and XMLSinkInterface from Microsoft InfoPath. What you should do is to set up the handler in the XMLDispatchEditor form. I.e. map the namespace of the root element in your XML document to the class implementing the

SV: [Axapta-Knowledge-Village] Tuning MSSQL for Axapta

Hi Andrew According to SQL Books online you have to use AWE to use more than 4GB. Check books online for details on how to enable AWE. Regards Thomas -Oprindelig meddelelse- Fra: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] På vegne af Andrew Staples Sendt: 16.

[Axapta-Knowledge-Village] Axapta FormFrame = none

When an Axapta form is using the design property Frame=None (or border) is opening another form, it looses focus when the called form is closed, and I haven't been able to find a way to set focus on a specific control on the form. Does anybody have a solution for that, or is that just a

[Axapta-Knowledge-Village] User menues

Does anybody know which rights a user should have to be able to delete items from his user menues. I have users who are able to do anything in their user menus but delete items they have added by mistake. If I add them to the admin user group they can, but obviously I would like only

SV: [Axapta-Knowledge-Village] Adding a new inventory dimension to Axapta

Title: Message Hi James It is possible to add a new inventory dimension, if you dont want to reuse an existing field. You can easily identify the places you possibly need to make adjustments by searching for #InventDimDevelop throughout the application. Obviously also you should

SV: [Axapta-Knowledge-Village] Inventory management - Physical Value by Item Group Report

Hi! Check if purchase of service items have been posted on the general ledger account. That's the most common error I have seen, and the reconciliation report doesn't identify this kind of errors. Regards Thomas -Oprindelig meddelelse- Fra: Axapta-Knowledge-Village@yahoogroups.com

Re: [Axapta-Knowledge-Village] StingEdit in Form

Thanks it works Varden Morris [EMAIL PROTECTED] wrote: You can do this in two ways. (1) Change the AutoDeclaration property of the stringEdit control to yes then set the value of the control as follows: komp1.text('It Works'); (2)Delcare a variable to point to the control in the

Re: [Axapta-Knowledge-Village] Re: initialize

Thanks for your answer ill try it. PS The product builder is a product configurator that's included in Axapta Varden Morris [EMAIL PROTECTED] wrote: I do not know exactly what is product builder. Is it a third party software? if you do the following: [class]public class AB{int x;int

Re: [Axapta-Knowledge-Village] Re: initialize

I can now run the code as a job and it returns values :-) ) And i can call the initAB without the product builder throws errors and i can'treturn values as you said in the message. Can you spare the time to help me with that also ? Thomas Jensen [EMAIL PROTECTED] wrote: Thanks for your answer

Re: [Axapta-Knowledge-Village] Re: initialize

It strange the product builder didn't throw any errors, but when i closed axapta and opened it again and tried to call A.initAB(2,2) again the same error about initializing came but it runs fine from the "jobs"Thomas Jensen [EMAIL PROTECTED] wrote: I can now run the cod