Mr. Developer

 Excel Import through code in D365fo X++ using System.IO; using OfficeOpenXml; using OfficeOpenXml.ExcelPackage; using OfficeOpenXml.ExcelRange; class CBLImportCartonsData {     str myFileType;              public static void main(Args _args) {          }     public str setFileType(str _FileType) {     myFileType = _FileType;              return myFileType; }     public Void Execute(FormControl sender) {     this.uploadFile(sender); }     public  void uploadFile(FormControl sender) {     System.IO.Stream stream;     ExcelSpreadsheetName        sheeet;     FileUploadBuild             fileUpload;     DialogGroup                 dlgUploadGroup;     FileUploadBuild    ...

 How to stop Workflow from submitting on certain conditions class AccptQtyWFValidation {         // /// <summary>     /////     ///// </summary>     ///// <param name="args"></param>     [PostHandlerFor(classStr(SLD_InventQualityOrderTable_Extension), methodStr(SLD_InventQualityOrderTable_Extension, canSubmitToWorkflow))]     public static void SLD_InventQualityOrderTable_Extension_Post_canSubmitToWorkflow(XppPrePostArgs args)     {         boolean     ret;         InventQualityOrderTable  table;         ret     = args.getReturnValue();         table   = args.getThis();         if(table.IsAcceptedQty == 0 && table.AcceptedQuantity == 0)         {             ret = ret && c...

 Advance XDS Security role in d365fo x++ 1. Create Temp Table:     Create temp table and add required fields and xds() method            XDS Method:      public class TblXDSCaseCategoryCEPTmp extends common {          public RefreshFrequency xds()     {         CaseCategoryHierarchyDetail     caseCategoryHierarchyDetail;                      Unchecked(Uncheck::XDS)             {                 while select                       caseCategoryHierarchyDetail                      where caseCategoryHierarchyDetail.CaseCategory == 'CEP'                 {         ...

How to Find Duplicate Records in SQL We want to find entries where the  OrderID  and  ProductID  columns are identical. This type of duplicate likely means there is a bug in the ordering system, since each order will process each product in that order only once in the cart. If multiple quantities of that product are ordered, the  Quantity  value would simply be increased; separate (duplicate) rows should not be created. A glitch of this type may impact business operations negatively if the orders are being fulfilled, packaged, and shipped automatically. To find duplicates in multiple column values, we can use the following query. It’s very similar to the one for a single column: SELECT   OrderID, ProductID,  COUNT (*) FROM   OrderDetails GROUP   BY   OrderID, ProductID HAVING   COUNT (*) > 1

SSRS Reports Expressions in D365fo x++  Get Company name =Microsoft.Dynamics.Framework.Reports.DataMethodUtility. GetFullCompanyNameForUser(Parameters!AX_CompanyName.Value,Parameters!AX_UserContext.Value)  Hide Colum on report On condition IIf(Sum(Fields!Returnable.Value, "Header") = 0,True, False)  Hide Tablix on report On condition: =IIF(Parameters!POInvoiceTmp_InvoicedUnInvoiced.Value = "Invoiced" , True, False) Rows Color expression: =iif(RowNumber(Nothing) Mod 2, "#ffffff", "#f0f0f0") Show All selected values of lookup : Expression:  =join(Parameters!GDWiseIssuanceTmp_ClassType.Value, ",")

 Controller Class for RDP Report in D365fo X++ Public class ClsRptPymntVchrController extends SrsReportRunController {              public static ClsRptPymntVchrController construct()     {         return new ClsRptPymntVchrController();     }     public static void main(Args _args)     {              LedgerJournalTrans              ledgerJournalTrans;         SRSPrintDestinationSettings     settings;                  ClsRptPymntVchrController _Controller = ClsRptPymntVchrController::construct();         _Controller.parmReportName(ssrsReportStr(CblRptPymntVchrReport, Report1));         ClsRptPymntVchrContract _Contract = _Controller.parmReportContract().parmRdpContract() as ClsRptPymntVchrContract ; ...

 Form's DataSource Activated EventHandler in x++ /// <summary>     ///     /// </summary>     /// <param name="sender"></param>     /// <param name="e"></param>     [FormDataSourceEventHandler(formDataSourceStr(CBLCartonsInfo, CBLCartonsHeader), FormDataSourceEventType::Activated)]     public static void CBLCartonsHeader_OnActivated(FormDataSource sender, FormDataSourceEventArgs e)     {         FormDataSource              cblCartonsheader_ds     = sender.formRun().dataSource(formDataSourceStr(CBLCartonsInfo, CBLCartonsHeader));         CBLCartonsHeader            cblCartonsheader        = cblCartonsheader_ds.cursor();                  FormDataSource            ...