MS Dynamics Ax Technical Forum For Beginners

Running the SSRS Report and Saving in Local drive using X++ Code with renaming the same report next Occurrence in AX 2012 Write the below code in Controller Class  of the Report public static void main(Args _args) {     //KKSalesPackingSlipController controller = new KKSalesPackingSlipController();     //controller.parmReportName(ssrsReportStr(KKSalesPackingSlipReport, PrecisionDesign2));     ////controller.parmReportName(ssrsReportStr(KK_CustInvReport, Report));     //controller.parmArgs(_args);     //controller.startOperation();     LogisticsAddressCountryRegionId     logisticsAddressCountryRegionId;     SrsReportRunController              controller = new SrsReportRunController();     SRSPrintDestinationSettings         printSettings;     KKSalesPackingSlipContract          c...

How to calculate On Hand Inventory Per Day class KK_OnHandPerDay {            /// <summary>     /// Runs the class with the specified arguments.     /// </summary>     /// <param name = "_args">The specified arguments.</param>     public static void main(Args _args)     {                ItemId itemId;         InventTrans inventTrans;         InventDim inventDimCriteria, inventDimLoc;         InventDimParm inventDimParm;         InventSumDateDim inventSumDateDim;         TransDate start, finish;         int c;         int onHandTotal;         InventLocationId inventLocationIdLoc;         start = str2date("6/24/2019", 213);//3/12/2019    ...

How to Calculate Planned Purchase Order class SMCPlannedPOCalc {            /// <summary>     /// Runs the class with the specified arguments.     /// </summary>     /// <param name = "_args">The specified arguments.</param>     public static void main(Args _args)     {         ReqTrans reqTrans;//reftype,refdate,itemid         ItemId   _itemId = "Test-SMK1010";         TransDate _date = str2Date("10/1/2019",213);         real qty;         select sum(qty),count(RecId) from reqTrans             where reqTrans.ItemId == _itemId             && reqTrans.RefType == ReqRefType::ItemPlannedOrder             && reqTrans.ReqDate == _date;       ...

How to Calculate Purch Totals in purchase order's Totals Form class KK_PurchTotals {          /// <summary>     /// Runs the class with the specified arguments.     /// </summary>     /// <param name = "_args">The specified arguments.</param>     public static void main(Args _args)     {         PurchTotals purchTotals;         PurchTable  purchTable  = PurchTable::find('00000225');         DiscAmount  discAmount;         purchTotals = PurchTotals::newPurchTable(purchTable);         purchTotals.calc();         discAmount = purchTotals.purchTotalAmount();         setPrefix('Purchase Order');         info(strFmt('%1 - Total Value: %2', purchTable.PurchId, discAmount));     } }

Get Email for Customer / Vendor (with specific roles) static void KK_Email (Args _args) {     DirPartyLocation dirPartyLocation;     LogisticsElectronicAddress elecAddress;     LogisticsElectronicAddressRole elecAddressRole;     LogisticsLocationRole locRole;     Email   email;               while select dirPartyLocation         where dirPartyLocation.Party == 22565427693     {         while select elecAddress             where elecAddress.Location == dirPartyLocation.Location             && elecAddress.Type == LogisticsElectronicAddressMethodType::Email         {             while select elecAddressRole                 where elecAddressRole.ElectronicAddress ...

How to run  Our Design in SalesPackingSlip Standard SSRS report? To run our Design in a standard SSRS Report(SalesPackingSlip), do this in the controller class. //Class Declaration Part in the controller class     MenuItemName                    reportChina;     #define.chineseReport('SalesPackingSlipOriginal')     #define.reportDesign('SalesPackingSlip.ReportNew') //outputReport Method in controller To run the report protected void outputReport() {     if (this.parmReportChina() == #chineseReport)     {         this.parmReportName(#reportDesign);         this.parmReportContract().parmReportName(#reportDesign);         formLetterReport.parmReportRun().settingDetail().parmReportFormatName(#reportDesign);     }     super(); } //parmReportChina Method in controller To set a...