Posts

Monthwise number sequence in SO and PO

Image
Refreshing the number sequencing for sales order each month so that sales order creation month can be identified based on the number. Initial setup: /// This batch will update the numbersequence format ‘yr/Month/######’ for salesorder number. /// class Monthwisenumberseq extends RunBaseBatch { } // new method protected boolean canGoBatchJournal() {      return true; } // new method public void run() {      NumberSequenceReference     numberseqref;      NumberSequenceTable            numberSeqTable;      container                                   segments;      str      ...
Post a Comment
Read more

Drill Down Reports in AX 2012

Image
Drill Down Reports: Here we are going to do Drill down reports in ssrs - AX 2012 1.Create new query in AOT Named as Custtransaction. 2.Add CustTrans as datasource. 3.Set Dynamic  = yes in field property. 4.Open Visual studio 2010 5.Create new report > In property change the name to CustTrans 6.Add new dataset with below properties  Datasource = Dynamics AX  Datasource Type = Query            In query property select the query (CustList) 7.Create Precision Design. 8.Select Table in report tools. 9.Select Voucher,Transdate,Invoiceid,Amount currency Now we need to group the data based on the account number. Follow the below steps:  Adding Group    Select the row which we want to hide and show > Right click > Row visibility.    Select hide button to hide the row details.   Now we can expand and we can see the Customer details.  ...
Post a Comment
Read more

Adding "Code commented by your name,Date" comments in existing method using x++

Image
\Classes\EditorScripts Add new below method. void SajuComment(Editor e) {           e.insertLines('//New code added by Saju K'+ ' on ' + 'Begin:' + ' ' + date2str(today                   (),123,2,1,3,1,4 ) +  ''   +' at ' + time2str(timeNow(), 1, 1) + '\n'); } Go to customizing object methods -> Right Click -> Scripts -> Add and enjoy.
Post a Comment
Read more

Convert Date time to Date in AX2012 SSRS

1.Go to field properties. 2.General > Value > Click on expression(fx ) > =Format(Fields!TransDate.Value, "dd/MM/yyyy" )
1 comment
Read more