To get a serial Number in a Table while Grouping in SSRS Report - D365 write this expression in the Text Box =RunningValue(CountDistinct("Tablix3"),Count,"Tablix3")
Posts
Running the SSRS Report and Saving in Local drive using X++ Code with renaming the same report next Occurrence in AX 2012
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
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
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
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)); } }
[AX2012] Get Email for Customer / Vendor (with specific roles)
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?
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...
How to create a table? In the AOT, expand the Data Dictionary node. Right-click the Tables node, and then select New Table . Right-click the table, and then click Properties . Rename the table by modifying the Name property. To specify the table as temporary, set the Temporary property to Yes. Modify additional table properties, as needed. To delete the table, right-click it, and then click Delete .