[development-axapta] Re: return sqlstatement to user

Thanks it works fine ... is it possible to put the data into an array ? I think it would be easier for mee because otherwise ill have to have some very defined SQL statements. I get a form of list ( Because i selected 2 rows in the database ) and as far as i can se it's not possible to

[development-axapta] Knowledge Management/Archiving

Hi All, We are currently investigating archiving solutions for axapta (since our current Axapta DB is about 55Gb and it's growing at around 5Gb a month), including the very strong possibility of implementing our own archiving procedure. I have been doing a bit of googling, and the following

AW: [development-axapta] Re: return sqlstatement to user

Hi, Try: str column1; str column2; ... while(ResultSet.next()) { column1 = getString(1); column2 = getString(2); ... your code... } /Otto Thanks it works fine ... is it possible to put the data into an array ? I think it would be easier for mee because otherwise ill have to have

Re: AW: [development-axapta] Re: return sqlstatement to user

I can do that but then ill get the hole column not just the value in 1,1 ( a ) l 1 l 2 l - 1 l a l b l -- 2 l c l d l if i do what you told me the output would look something like this: a b b d I want to get all the data in the rows

[development-axapta] ordered status not changed

Hi All, Today I saw a very peculiar thing. When I looked for the OnHand for a particular Item I found that it has 250 Qty with receipt status Ordered. But when I checked this PO it had this status as delivered. Also when I checked for the transactions for this Item and for the selected

AW: [development-axapta] ordered status not changed

Hi I have exactly the same problem at a customer's site. I also couldn't find out what has happened and where this second line is coming from. So if you find any solutions please tell me too Greets Michael -Ursprüngliche Nachricht- Von: Girish Bhatkal [mailto:[EMAIL PROTECTED]

AW: [development-axapta] Knowledge Management/Archiving

Hi Matt Well I think you should forget about using the Axapta Knowledge Management Module for your archiving problem. This Module has nothing to do with archiving processes for big databases. In Ver. 2.5 there was some functionality called archiving where you could create an archive of

AW: [development-axapta] COM Error

I think this is a bug in Axapta COM. We have reported this error to MBS without solution. Now we use COM+ without this error. Denis -Ursprüngliche Nachricht- Von: Alfonso Collados Arroyo [mailto:[EMAIL PROTECTED] Gesendet: Montag, 8. November 2004 10:57 An: 'Development-Axapta

R: [development-axapta] COM Error

I’m new to com+ applications.. Can you explain me how to set up it? Thanks in advance. Alessandro Ghidini Ing. Alessandro Kibuz SRL Galleria Ludovico Mortara, 2 - 46100 - Mantova Telefono: +39 0376 220605 Fax: +39 0376 367439 Email: mailto:[EMAIL PROTECTED] [EMAIL PROTECTED]

RE: [development-axapta] Knowledge Management/Archiving

Thanks Michael, I believe this is quite a common gripe with the current version of Axapta (at least MS have indicated that they are aware of it). We had already planned to do our own archiving system. The thought is as daunting as all hell, but at current growth rates we have to do something,

AW: [development-axapta] COM Error

If you register the COM with the configuration utility you must only use Register COM+. Now the COM is registered in the component services (control panel/administrative tools). Here you can change any properties for the COM+ object. Denis -Ursprüngliche Nachricht- Von: Alessandro

Re: RE : [development-axapta] error catching when inserting in SQLServer

Hi Steeve, What you are doing is correct. I don't have an EmployeeTable so I have used the CustTable. Create a job and try this. Here is my code: CustTable custTable; ; try { custTable.initValue(); custTable.AccountNum = 0; custTable.Name = Tom Hoebers; custTable.Address = THO;

[development-axapta] Re: Insert, Update, Delete Watch

Hi Morris, The only practical option you really have is to override the ValidateDelete and ValidateWrite methods in each individual form's datasources. A more generic approach is to do that on the tables. Off course the Axapta kernel dev team could implement that in the base class, but

[development-axapta] Re: Upgrade from SP1 to SP3 directly/ key areas to check after applying the SP

Hi Roberto, Axapta service packs are cummulative. You do not need to install SP go directly to SP3. Regards, -- Luis Mourão [EMAIL PROTECTED] --- In [EMAIL PROTECTED], roberto pineda [EMAIL PROTECTED] wrote: I am using Axapta 3.0 SP1. I am planning to upgrade to SP3. What is best, to

[development-axapta] Re: Having / like relational operators

Hi Pepe, For example: ResultSet res = stmt.executeQuery('SELECT NAME FROM CUSTTABLE WHERE (NAME LIKE \'Name_%\')'); If you have more then one like then or them together. Alternatively you can use a query and add whatever ranges you need to it. Regards, -- Luis Mourão [EMAIL PROTECTED]

Re: RE : [development-axapta] error catching when inserting in SQLServer

Also remember that you have to put the try catch outside your outermost ttsbegin/commit. A throw will always go outside of that, as far as I know. Eks: CustTable custTable; ; will NOT work: ttsbegin; try { custTable.initValue(); custTable.AccountNum = 0; custTable.Name =

RE: [development-axapta] Round Off error.

Just guessing, Maybe a round off to only two decimals through the decround() function does the trick. :-J Systemdeveloper Jacob Hjelmer Thy Data Center Development A/S Søvej 13b DK-3460 Birkerød Denmark Phone : +45 96 170 470 Fax : +45 45 824 544 URL :

[development-axapta] What is best way to add Multiple Trans to a report?

Everybody, I want to print MarkupTrans: Desc and Amount on the SalesInvoice after the item detail lines have all been printed. There may be multiple markup transactions each invoice. What is the best way to accomplish this? Should I use a method or a data source, etc. Thanks, Bob Bob

[development-axapta] Dokumenthandling AX 2.5 / SP3

Hello, i have an issue with document handling on Axapta 2.5 / SP3 2 departments want to store data useing documenthandling, HR and Finance HR shall no be able to see docs of Finance and Finance not on HR. With in Axapta there is no prob, but as docs are stored on fileserver (and DB), they

[development-axapta] CustInvoiceTrans.lineNum versus SalesLine.lineNum

Dear all, I am trying to print some additional information on the invoice line. The information is not stored in the table CustInvoiceTrans but remains in the table SalesLine, at least for now. I created a display method that looks up the value. Example: The method contains the

RE: [development-axapta] CustInvoiceTrans.lineNum versus SalesLine.lineNum

I believe InventTransId in SalesLine and CustInvoiceTrans should be used to find the related line. Regards Palle Mølgaard Systemate A/S From: Danny Gaethofs [mailto:[EMAIL PROTECTED] Sent: 16. november 2004 14:47 To: [EMAIL PROTECTED] Subject:

AW: [development-axapta] CustInvoiceTrans.lineNum versus SalesLin e.lineNum

Hi Danny, use the field InventTransId . You can have partial invoices or one invoice per customer for several sales orders and if someone prints the linenum on the invoice it would be funny... /Otto -Ursprüngliche Nachricht- Von: Danny Gaethofs [mailto:[EMAIL PROTECTED]

RE : [development-axapta] CustInvoiceTrans.lineNum versus SalesLine.lineNum

The best way to retrieve the good SalesLine from a CustInvoiceTrans is to use InventTransId field. InventTransId is unique (per company) in SalesLine. select salesLine where salesLine.InventTransId == custInvoiceTrans.InventTransId; Steeve... -Message d'origine- De : Danny

Re: AW: [development-axapta] CustInvoiceTrans.lineNum versus SalesLin e.lineNum

Steve, Palle, Otto, Thanks a lot for your help. This is indeed working and I understand the reasoning. As such partial shipments happens a lot. regards, Danny --- [EMAIL PROTECTED] wrote: Hi Danny, use the field InventTransId . You can have partial invoices or one invoice per customer

AW: [development-axapta] CustInvoiceTrans.lineNum versus SalesLine.lineNum

Please note that anyone can delete a sales order. So you don't have any infos to print. Better way is to store your info in CustInvoiceTrans. Denis -Ursprüngliche Nachricht- Von: Danny Gaethofs [mailto:[EMAIL PROTECTED] Gesendet: Dienstag, 16. November 2004 14:47 An: [EMAIL

Re: [development-axapta] Re: Upgrade from SP1 to SP3 directly/ key areas to check after applying the SP

Hi... A lot of thanks Luis!! --- luisxbmo [EMAIL PROTECTED] escribió: Hi Roberto, Axapta service packs are cummulative. You do not need to install SP go directly to SP3. Regards, -- Luis Mourão [EMAIL PROTECTED] --- In [EMAIL PROTECTED], roberto pineda [EMAIL

R: [development-axapta] COM Error

Thanks.. Using Com+ i resolved the r6025 error problem! Now I’ve this kind of problem.. I’ve got only one com connector license. If I use the following code: ax.Logon(login, , , config); ax.Logoff(); Marshal.ReleaseComObject(ax); ax = new AxaptaClass();

[development-axapta] RE: [Axapta-Knowledge-Village] LATEST UPDATEAxapta Std functionality for Approving Invoices

Hi , I am really thankful who suggested and helped me. As of now, My requirement is The client has many POs in almost in all days will have around 300 PO lines for each PO. He doesn't want to auto approve all the POs. And also he doesn't want to compare the Physical amount ( goods received )

[development-axapta] PageFooter only in the last page

Hi, I need to show a page footer only in the last page of a report. How can I do this? Regards, Alfonso [Non-text portions of this message have been removed] Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go

Re: AW: [development-axapta] CustInvoiceTrans.lineNum versus SalesLine.lineNum

Denis, I realize that but for now some people wanted to have it this way. In time I will add the code to the methods on the table CustInvoiceTrans and CustInvoiceJour. Thanks anyway for the reminder. regards, Danny --- Unger, Denis [EMAIL PROTECTED] wrote: Please note that anyone can

RE : [development-axapta] PageFooter only in the last page

Have you tried using an Epilog section? Steeve... -Message d'origine- De : Alfonso Collados Arroyo [mailto:[EMAIL PROTECTED] Envoyé : 16 novembre 2004 11:34 À : 'Development-Axapta ([EMAIL PROTECTED]) Objet : [development-axapta] PageFooter only in the last page Hi, I need to

SV: AW: [development-axapta] CustInvoiceTrans.lineNum versus SalesLine.lineNum

Denis The linenumber cannot be used because you can invoice the lines in random order, and furthermore you can delete the line after the invoice and create another line with the same linenumber afterwards. You can use the CustInvoiceTrans.InventTransId that is equal the the

[development-axapta] Please Urgent AxaptaSP2 to AxaptaSP3

Hi! I need to upgrade my actual version of Axapta (Service Pack 2) with the new version (Service Pack 3), all of this in my Development Server. My problem is that, when I tried to upgrade with SP3, all the modifications I have done were lost, and that is obviously unaccepted. I require

RE: [development-axapta] COM Error

Bad news The COM client .logoff method has not done anything Axapta 2.1 SP3 (the first time I started using the COM client). Anyone know how to stop the COM+ service? S _ From: Alessandro Ghidini [mailto:[EMAIL PROTECTED] Sent: Tuesday, 16 November 2004 11:36 PM To:

Re: R: [development-axapta] COM Error

Hi Alessandro, please have a look at Axapta Developer's Guide and read section IMPORTANT LIMITATIONS under IAxapta2 interface, Logon. Business Connector makes something like a primary logon to Axapta for the calling process when axcom.dll is loaded. This primary logon can not be canceled by

RV: RE : [development-axapta] PageFooter only in the last page

Yes , I 've tried usin an Epilog section, but it doesn`t work. I have a lot of Page footer and I want a number of them appears only in the last page. Regards _ De: Steeve Gilbert [mailto:[EMAIL PROTECTED] Enviado el: martes, 16 de noviembre de 2004 19:10 Para: [EMAIL PROTECTED]