Posts

D365: SSRS Report Development/ Customization

Image
Hi guys, Today in this blog I will be demonstrating the procedure for the SSRS Reports development and customization in D365FO. Before proceeding with the Development or customization make sure that you have created a new model for your customization since we will be using extensions approach in our customization because An extension enables you to add functionality to existing model elements and source code. Coming back to the main objective of this blog which is to Develop SSRS reports in D365. One point to keep in mind is that there is no change on How you develop query based report and RDP based report in D365FO . The only change is you have to use extensions for standard report. If you are developing brand new report based on custom tables, there is no change. So in this Blog I will discuss How to customize an existing SSRS Report in D365 using Extensions approach step by step: Step#1:  The first step is to create a new model, Below are the steps to create a new model: Navigate to
Post a Comment
Read more

GET table name for table id

  /* GET table name for table id */ SELECT NAME FROM SQLDICTIONARY WHERE TABLEID = 9669 AND FIELDID = 0
Post a Comment
Read more

D365: X++ code to add custom lookup on worker to show specific workers team workers only

/// <summary>             ///             /// </summary>             /// <param name = "_formReferenceControl"></param>             /// <returns></returns>             public Common lookupReference( FormReferenceControl _formReferenceControl)             {                 SysReferenceTableLookup      sysTableLookup = SysReferenceTableLookup ::newParameters( tablenum ( HcmWorker ), _formReferenceControl, true );                 Query                        query = new Query ();                 QueryBuildDataSource         queryBuildDataSource;                  QueryBuildRange              queryBuildRange;                 HcmPosition                  hcmPositionPareant;                 HcmPositionHierarchy         hcmPositionHierarchy;                 utcdatetime                  _validFrom = DateTimeUtil ::utcNow();                 utcdatetime                  _validTo    = _validFrom;                 H
Post a Comment
Read more

D365 Number Sequence Reference

Step: 1. Create new class and extend it to NumberSeqApplicationModule: public class NumberSeqModuleMP extends NumberSeqApplicationModule {     /// <summary>     ///    Configures all the data types that are being used by the module.     /// </summary>     /*     Detailed description of how to setup references for number sequences can     be found i method loadModule() on the 'father' class: NumberSeqApplicationModule.     */     protected void loadModule()     {         datatype.parmDatatypeId(extendedTypeNum(MPDependentId));         datatype.parmReferenceHelp(literalStr("@MPL:DependentId"));         datatype.parmWizardIsContinuous(False);         datatype.parmWizardIsManual(NoYes::No);         datatype.parmWizardIsChangeDownAllowed(NoYes::No);         datatype.parmWizardIsChangeUpAllowed(NoYes::No);         datatype.parmSortField(13);             datatype.addParameterType(NumberSeqParameterType::DataArea, true, false);         this.
Post a Comment
Read more

Dynamics ax 2012: Sample code for fetching records in tmp table using query and Insert record set

public static server void constructData(ASMARMatricsReportingTmp     _tmp,                                         TransDate                    _asOfDate,                                         TransDate                    _startDate,                                         ASMDateCriteria              _dateCriteria,                                         str2500                      _salesPool,                                          str2500                      _customerAccount,                                         str2500                      _company,                                         QueryRun                     _queryRun,                                          MenuItemNameDisplay          _menuItemName) {     UserConnection               userConn;     CustTable                    custTable;     SalesTable                   salesTable, salesTableLocal;     CustInvoiceJour              custInvoiceJourLocal;     Query               
Post a Comment
Read more