[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

Re: [Axapta-Knowledge-Village] Unreserve and reserve by code

2007-01-26 Thread Akash
Hi, I am able to find a perticular transaction from my transfer journal i need to un reserve and succeeded in unreserving the quantity. Here is the code i used for un reserving : - InventMovement =

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

2007-01-26 Thread chuapatrickd
Hi Arijit, I've already downloaded the sample code for the temporary table in report. The sample work great. However my concern is how to apply it to my own scenario. I have a report that populate the temp table from a buildquery method of the class that is extended from runbasereport. I can

[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] Help me out!

2007-01-26 Thread pankaj_dbc
In one of my reports I need to sort one of my field in ascending order, I have already used the group by clause in my select query so it is not allowing me to use the order by clause along with that. Can anybody suggest me anyway to do it.

Re: [Axapta-Knowledge-Village] Jobs disappear from batch list

2007-01-26 Thread kristanto surjadi
What do you mean with disappear? Have you try to inquiry the Batch List form using different status? At the top left of Basic - Inquiry - Batch List form you have a show status combo box, have you try to inquiry the form with Ended status. The status of a job that successfully executed

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

2007-01-26 Thread lars_kjaersgaard
Hi Patrick, If you plan to initialize your report from menu/menuitems, then you should configure two almost identical menuitems, one with a parameter configured and one without parameter or a different parameter. These parameters are automatically send as Args-object parameters to the

[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

RE: [Axapta-Knowledge-Village] Help me out!

2007-01-26 Thread Brandon George
I have never tried this before, but you might be able to build a query from a query. So for example: Query1 = Order By DataSet Query2 = Built from Query 1, Group by the DataSet I also thought you could Order and Group By within X++ SQL Statements... thanks, J. Brandon George Senior

RE: [Axapta-Knowledge-Village] Help me out!

2007-01-26 Thread Subrahmanyam,Mamidi
hi pankaj_dbc, please post your code so that you will be helped -subbu Brandon George [EMAIL PROTECTED] wrote: I have never tried this before, but you might be able to build a query from a query. So for example: Query1 = Order By DataSet Query2 = Built from Query 1,

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

2007-01-26 Thread Luis Martinez
An example... some functions. transdate KikeDate = systemdateget(); ; info(strfmt(%1 %2th, %3,mthname(mthOfyr(KikeDate)), dayofmth(KikeDate), year(KikeDate))); Saludos. On 1/25/07, Imthiyaz Ahamed [EMAIL PROTECTED] wrote: Hi Siva, Thanks for your Reply. It is vey useful for me, But My

[Axapta-Knowledge-Village] How to update InventTrans After Inventory Closing Process AX3.0?????

2007-01-26 Thread tavocol2002
Hi to everybody. I have a big problem to update InventTrans when the periods have been closed with InventoryClosing. This is the example, i'm running a new development call it Monetary Correction, this development search and select on InventTrans all transactions with ValueOpen == Yes. This