AX HELPDESK

Different type of Joins and Link Type Car Table CarId ModelYear CarBrand Model Mileage ModelYear CarId CA101 2008 Mahindra Scorpio 15 2008 CA101 CA102 2009 Suzuki 800 12 2009 CA102 CA103 2007 Hundai i20 5 2007 CA103 CA104 2007 Toyato Inova 3 2007 CA104 CA105 2009 BMW   5 2009 CA105 CA106 2010 Benz AZ12 10 2010 CA106   Rental Table RentalId CustAccount CarId FromDate ToDate ToDate FromDate RE101 1104 CA101 10/12/2010 10/29/2010 10/29/2010 ...

How to Calculate the total number of weeks,weekends or count of    Sundays  in a given date interval ..   static void calcDays(Args _args) {     FromDate    fromDate    = today();     ToDate      toDate      = mkdate(31,01,2011);     WeekDays    weekDay = WeekDays::Sunday; // the day we search after     int         days;     int         cntSpecDay;     int         leadIn;     int         leadOut;     ;     days = fromDate - toDate; // days difference     //Calculate the No.Of weeks in given Date Intervals     leadIn = any2int(fromDate - toDate) /7;     cntSpecDay = days / 7; // how many sundays in complete weeks     if (dayOfWk(fromDate) <= weekDay)     {   ...

EDT Relations migration tool in 2012:   As you all know we cannot create relations under EDT in AX 2012, all relations will be created in Table level. The EDT relations created in AX 2009 will be still active but Microsoft recommends to move all EDT relations to Table level.   The EDT relation migration tool helps you move relations from EDT nodes to table nodes. The EDT relation migration tool is found on the client menu, under Tools > Code upgrade > EDT relation migration tool . Kindly refer the link for more details - http://msdn.microsoft.com/en-us/library/gg989788.aspx   Hope it helps..............

Create the class with below methods public class OnhandQty extends RunBaseBatch {      SysMailer   mailer;      boolean check;      SysEmailParameters parameters;     #define.CurrentVersion(1)     #localmacro.CurrentList     //onhandQty    // methodVariable2     #endmacro } public static void main(Args args) {     OnhandQty onhandQty;     ;     onhandQty = new OnhandQty();     onhandQty.run(); } void run() {     this.WriteCSV();     if(check == true)     {         this.EmailCheck();     } } // This method is used to bring the data and Save it into CSV file void WriteCSV() {     Commaio file;    ...