[Axapta-Knowledge-Village] Batch JOb

2008-01-04 Thread chuapatrickd
HI to all, I have setup a batch job to run at 03:30am but I was surprised the everyday it add a few minutes to the starting time so much so that after several day the starting time is already 03:39 am. Is this the actual behavior of axapta batch? is there a way to fixed the start time to

[Axapta-Knowledge-Village] Export Utility

2007-07-10 Thread chuapatrickd
Hi Danny Gaethofs, I've copied te xpo you have posted regarding the export utility. Since I can not import the xpo due to file format error. I copied the content of the file to a class which I newly created. However when compiling I've encountered an error in this line logOk =

[Axapta-Knowledge-Village] Re: tab delimiter text file

2007-07-08 Thread chuapatrickd
(\t); txtIo.outRecordDelimiter(\r\n); while select salestable { txtIo.write(salestable.SalesId,salestable.SalesName); } } } hope this helps :) Regards Kamalakannan http://casperkamal.spaces.live.com On 7/4/07, chuapatrickd [EMAIL

[Axapta-Knowledge-Village] Batch processing

2007-07-08 Thread chuapatrickd
Hi to all, I want to execute one of my class every saturday of the week. The parameter for the class is From date and End date where the from date is the start date for the week and the end date is the saturday of the week. my question is how to set the runbasebatch class to be trigger every

[Axapta-Knowledge-Village] Batch processing

2007-07-08 Thread chuapatrickd
Hi to all, I have a class that let's user enter the path to save the text file. however when the batch run as set int he recurring pattern. the path which was set by the user is not being pick-up, it is blank. how to set the path so that it will get the last save data. I'm using the

[Axapta-Knowledge-Village] Re: Batch processing

2007-07-08 Thread chuapatrickd
--- In Axapta-Knowledge-Village@yahoogroups.com, chuapatrickd [EMAIL PROTECTED] wrote: Hi to all, I've figure out already the batch recurring pattern to run every saturday. I've just chosen weekly and then checked the saturday day of the week checkbox. My question is will be how to auto runt

[Axapta-Knowledge-Village] Tab delimited text file

2007-07-04 Thread chuapatrickd
Hi to all, currently the text file appear with quotes in each field. the code is shown below myfile= new Comma7Io(c:\\exportedfile8.txt,w); myfile.outFieldDelimiter(\t); myfile.outRecordDelimiter(\r\n); what should I replace in the outFieldDelimiter parameter so that it will have no more

[Axapta-Knowledge-Village] Default paper size

2007-04-18 Thread chuapatrickd
Hi to all, I have an axapta report. I want this to be printed to a legal size paper. However My problem is that the default paper size is always Letter size. How can I command ax to make the default size to legal. Below is my code to run the ax report. Thanks, Patrick static void

[Axapta-Knowledge-Village] Runbase Report

2007-04-18 Thread chuapatrickd
Hi, I've used the runbasebatch class and now I want to add a button to the dialog window that will open a form. How does can be done? I was able to add new fields in the dialog method and also in the getFROMdialog METHOD. cAN I also add a button here, what the syntax ?? Any help will be

[Axapta-Knowledge-Village] Default paper size

2007-04-12 Thread chuapatrickd
Hi to all, I have an axapta report. I want this to be printed to a legal size paper. However My problem is that the default paper size is always Letter size. How can I command ax to make the default size to legal. Below is my code to run the ax report. Thanks, Patrick static void

[Axapta-Knowledge-Village] Re: Calling many reports from LastValueElementName()

2007-02-08 Thread chuapatrickd
Hi Lars, I've got your code. I'll test it in AX and get back to you later. Thanks, Patrick --- In Axapta-Knowledge-Village@yahoogroups.com, lars_kjaersgaard [EMAIL PROTECTED] wrote: Hi again Patrick, funny problem. What you are trying to do is not possible - to choose design at the

[Axapta-Knowledge-Village] Re: Temporary table

2007-01-31 Thread chuapatrickd
hI Gustavo, Here's the code for the population as well as the calling fetch program of the report public class GIS_BIR2550MPurchSum extends RunBaseReport //GIS_BIR2550MRPT { DialogField dlgtaxgroup; DialogGroup fromToGroup; dialogField dlgFilename;

[Axapta-Knowledge-Village] Re: Calling many reports from LastValueElementName()

2007-01-31 Thread chuapatrickd
Hi Lars, Thanks for your reply. I got your point and have tried it. It works. I have another question regarding again with the two report requirement. One is detailed and anothe is summary. You see I have a class that gather from parameter then I want to print both detailed and below the

[Axapta-Knowledge-Village] Re: Temporary Table in report

2007-01-29 Thread chuapatrickd
QueryRun(MYclass.buildquery()); to qr= new query(this.queryRun().setRecord(tempTableReport. .parmTempTable())); Thanks, Patrick --- In Axapta-Knowledge-Village@yahoogroups.com, chuapatrickd [EMAIL PROTECTED] wrote: Hi Arijit, Thanks for the reply

[Axapta-Knowledge-Village] Re: Calling many reports from LastValueElementName()

2007-01-26 Thread chuapatrickd
Hi, can you give me sample code of the INIT method of the report that can select specific design based on parameter ? I have a requirement that there are two differen design of the report, one is detailed report and the other is just a summary report. Thanks, Patrick --- In

[Axapta-Knowledge-Village] Re: Temporary Table in report

2007-01-26 Thread chuapatrickd
QueryRun(MYclass.buildquery()); to qr= new query(this.queryRun().setRecord(tempTableReport. .parmTempTable())); Thanks, Patrick --- In Axapta-Knowledge-Village@yahoogroups.com, chuapatrickd [EMAIL PROTECTED] wrote: Hi Arijit, Thanks for the reply

[Axapta-Knowledge-Village] Re: Date to String Conversion

2007-01-26 Thread chuapatrickd
Hi Imthiyaz Ahamed, Pls look at this site about date conversion. You can use the format as explained below and maybe you an just add new function to concatenate the th or rd to make the day appear as 25th or 3rd. the logic will be similar to this: if the day more than 3 - you add th as in

[Axapta-Knowledge-Village] Temporary table

2007-01-26 Thread chuapatrickd
Hi, I've used temp table to store temporary the data before it goes to the printer. My problem is that the generation of the table takes too long aroune 20 minutes. But when I run a stored proce, it takes only less than few 5 minutes. Is Ax temp table really slow ? is there a better way of

[Axapta-Knowledge-Village] Re: Date to String Conversion

2007-01-26 Thread chuapatrickd
Hi Imthiyaz Ahamed, Pls visit this site for more info on date2str. http://www.axaptapedia.com/User_talk:Patrickchuad on your requirement I think you just create a class that will add the suffix to day of the month. The logic will be as follows: if the day is greater than 5 then add st as in

[Axapta-Knowledge-Village] Temporary Table in report

2007-01-21 Thread chuapatrickd
Hi to All, I'm trying to use a temporary table as data source for my report. However after populating it with the desired data, the report would have no data in it. What I did is to make the temp table as permanent. This time, the report did print ok with the selected customer. My problem is

[Axapta-Knowledge-Village] Re: RunbaseReport

2007-01-03 Thread chuapatrickd
fromdate should be added in Macro. I think It may help you... thanks, siva chuapatrickd [EMAIL PROTECTED] wrote: Hi All, I've a class that extened runbaseReport. I've added new parameter in the dialog and wants to maintain the last values. I've included them

[Axapta-Knowledge-Village] RunbaseReport

2007-01-02 Thread chuapatrickd
Hi All, I've a class that extened runbaseReport. I've added new parameter in the dialog and wants to maintain the last values. I've included them in the class declaration under the localmacro portion and have also increase the value of the version by 1. However, the last entered data is not

[Axapta-Knowledge-Village] Re: Getting the current database of the active application

2006-12-15 Thread chuapatrickd
(LoginConnectString: %1,str2)); } -- I hope that helps. Best regards Roland --- In Axapta-Knowledge-Village@yahoogroups.com, chuapatrickd chuapatrickd@ wrote: Hi to all, Is there a function or class in AX which gives the current database , server, user id to connect

[Axapta-Knowledge-Village] Getting the current database of the active application

2006-12-14 Thread chuapatrickd
Hi to all, Is there a function or class in AX which gives the current database , server, user id to connect to the database and the password. In particular, I want to get what is stored in the AX config. I will use this info to call the stored procedures I build in that database. THis way I

[Axapta-Knowledge-Village] Re: RunbaseReport

2006-12-05 Thread chuapatrickd
-Knowledge-Village@yahoogroups.com [mailto:Axapta- [EMAIL PROTECTED] On Behalf Of chuapatrickd Sent: 05 December 2006 06:36 To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Re: RunbaseReport --- In Axapta-Knowledge-Village@yahoogroups.commailto:Axapta- Knowledge

[Axapta-Knowledge-Village] RunbaseReport

2006-12-04 Thread chuapatrickd
Hi to all, I'm encountering an error when running my class which extend the runbaseReport base class. The error message Iv'e got is Error executing code: Wrong argument types in variable assignement the method shown is: \classes\RunbaseReport\MakeReportRun

[Axapta-Knowledge-Village] RunbaseReport

2006-12-04 Thread chuapatrickd
Hi to all, I'm encountering an error when running my class which extend the runbaseReport base class. The error message Iv'e got is Error executing code: Wrong argument types in variable assignement the method shown is: \classes\RunbaseReport\MakeReportRun

[Axapta-Knowledge-Village] Re: Date difference

2006-12-04 Thread chuapatrickd
: int daysCount; ; daysCount =(this.endDate - this.startDate) /365; return ((this.endDate - this.startDate) -(daysCount *365))/30; return type of this method is *integer* Regards Nitesh On 11/24/06, chuapatrickd chuapatrickd@ yahoo.com wrote: Hi, Is there a functin in AX

[Axapta-Knowledge-Village] Re: Calling many reports from LastValueElementName()

2006-12-04 Thread chuapatrickd
Hi Preston, I have the same problem, want to call two report based on paramter. Can you give me example of a report in Axapta that has the INIT method set to two design based on the parameter ? THanks, Patrick --- In Axapta-Knowledge-Village@yahoogroups.com, Preston A. Larimer [EMAIL

[Axapta-Knowledge-Village] Re: RunbaseReport

2006-12-04 Thread chuapatrickd
, Agus On 12/5/06, chuapatrickd [EMAIL PROTECTED] wrote: Hi to all, I'm encountering an error when running my class which extend the runbaseReport base class. The error message Iv'e got is Error executing code: Wrong argument types in variable assignement the method shown

[Axapta-Knowledge-Village] Date difference

2006-11-23 Thread chuapatrickd
Hi, Is there a functin in AX where it will compute for date difference. Ex. Date1 = '01-01-2006', Date2= '06-20-2006' Datediff in months should be 6. Any help will be greatly appreciated. Thanks, Patrick

[Axapta-Knowledge-Village] Re: Date difference

2006-11-23 Thread chuapatrickd
-Village@yahoogroups.com, chuapatrickd [EMAIL PROTECTED] wrote: Hi, Is there a functin in AX where it will compute for date difference. Ex. Date1 = '01-01-2006', Date2= '06-20-2006' Datediff in months should be 6. Any help will be greatly appreciated. Thanks, Patrick

[Axapta-Knowledge-Village] Re: LineNum

2006-07-20 Thread chuapatrickd
in Ax 2.5 Regards harry From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of chuapatrickd Sent: 20 July 2006 10:38 To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Re

[Axapta-Knowledge-Village] reservation

2006-06-02 Thread chuapatrickd
I've added a field and want this fields to check if it is false then the auto-reservation routine must not be done even though the sales order line reservation fields is set to automatic. can this be done, what class to modify ? pls help. Thanks, Patrick Sharing the knowledge on

[Axapta-Knowledge-Village] Re: Filtering record in form

2006-05-16 Thread chuapatrickd
Peritus AS -Original Message- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of chuapatrickd Sent: 15. mai 2006 13:59 To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Filtering record in form Hi to all, I want

[Axapta-Knowledge-Village] Stored Procedure

2006-05-09 Thread chuapatrickd
Hi to all, I want to call an sql stored procedure in SQL database FILE_SERVER1, the name of the stored procedure is consolidate_invoice, is it possible to call this from within x++ code ? If it is, can anyone give me sample code ? It is advisable to do this? or is there any other

[Axapta-Knowledge-Village] Re: Stored Procedure

2006-05-09 Thread chuapatrickd
it let me know and I can send you the direct link. Thanks, Brandon -Original Message- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:Axapta- [EMAIL PROTECTED] On Behalf Of chuapatrickd Sent: Tuesday, May 09, 2006 8:32 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject

[Axapta-Knowledge-Village] Re: Helpdoc in Axapta

2005-09-05 Thread chuapatrickd
would be to create it in application documentation regards harry chuapatrickd [EMAIL PROTECTED] wrote: hi, How to create own help book in helpdoc of axpta? 1. Under node helptoc of application dev doc 2. under node helpdoc 3. create a new help in the helpdocumentation what's

[Axapta-Knowledge-Village] Re: Helpdoc in Axapta

2005-09-05 Thread chuapatrickd
would be to create it in application documentation regards harry chuapatrickd [EMAIL PROTECTED] wrote: hi, How to create own help book in helpdoc of axpta? 1. Under node helptoc of application dev doc 2. under node helpdoc 3. create a new help in the helpdocumentation what's

[Axapta-Knowledge-Village] Re: help doc

2005-09-05 Thread chuapatrickd
Hi Harry, Yes. I see it in AOT under node Application Documentation. Thanks, Patrick --- In Axapta-Knowledge-Village@yahoogroups.com, Harry \(Harshawardhan Deshpande [EMAIL PROTECTED] wrote: hi Patrick did u check out the AOT? regards harry chuapatrickd [EMAIL PROTECTED

[Axapta-Knowledge-Village] Re: Working on Programming Exam....

2005-09-05 Thread chuapatrickd
. Varden Morris Senior Developer WellPoint Systems Inc. Suite 2000, 500 - 4th Ave SW Calgary, Alberta, Canada T2P 2V6 (403) 444-5848 direct (403) 444-3900 main www.wellpoint.ca chuapatrickd [EMAIL PROTECTED] wrote: --- In Axapta-Knowledge-Village@yahoogroups.com, Varden

[Axapta-Knowledge-Village] Re: correct answer

2005-09-05 Thread chuapatrickd
[EMAIL PROTECTED] wrote: hi Patrick why would anyone use settmpdata on a temporary table? regards harry chuapatrickd [EMAIL PROTECTED] wrote: Hi to All, Any one who know the answer for this question ? When using temporary table what does settempdata(common) do? 1. Set