MultiSelect lookup in D365f&o

   public void MultiSelectLookup(FormStringControl _control)

        {

            Query   query = new  query();

            QueryBuildDataSource qbds;

            Container cont;

            qbds = query.addDataSource(tableNum(PRO_ZPayrollStaging));

            qbds.addSelectionField(fieldNum(PRO_ZPayrollStaging, JournalBatchnumber));

            qbds.orderMode(ordermode::GroupBy); //skip for duplicate values

            qbds.addSortField(FieldNum(PRO_ZPayrollStaging,JournalBatchnumber));

            SysLookupMultiSelectGrid::lookup(query, _control, _control, _control, cont);

        }

        /// <summary>

        ///

        /// </summary>

        public void lookup()

        {

            super();

            this.MultiSelectLookup(this);

        }

......................................

Output :

No report data table with name [Table Name] in report scheme for data provider [SSRS Report] in Dynamics 365 F&O - Error

 Hey Dynamics 365 FinOps developer, If you are working on an SSRS data provider report, you may have experienced this error.

"(X) - No report data table with name [Table Name] in report scheme for data provider xxxxxxDP"

This error takes much of developers time to debug the root cause. So why and when this error actually raises. The answer is when your SSRS report table crosses the length of characters more than 40. So, if you are facing this error make sure your report temp/regular table length cannot be more than forty.

Other Way :

1.Rename the report dataset name.(error table name)

2.After renaming , select the dp class and table.

3.Deploy the report, restart sql services, clear the cache.

Send email with report attachment in D365 F&O

  public static void sendEmail(System.IO.MemoryStream   _mstream, Filename    _fileName, str _requestID)

    {

        Map                                     templateTokens;

        str                                     emailSubject,emailBody;

        Filename                                fileName;

        SysEmailTable                           SysEmailTable;

        var messageBuilder      = new SysMailerMessageBuilder();

        templateTokens          = new Map(Types::String, Types::String);

        select SysEmailTable;

        emailSubject = "Vendor Request Report";

        templateTokens.insert("@SYS74341", emailSubject);

        templateTokens.insert("@SYS4009003", _fileName);

        emailBody =  strFmt("A vendor request has been registed with the vendor request id %1 please find the attached document for more information.",_requestID);

        emailBody = SysEmailMessage::stringExpand(emailBody, SysEmailTable::htmlEncodeParameters(templateTokens));

        emailBody = strReplace(emailBody, '\n', '<br>');

        emailBody +='<br><br>Thanks,<br>' +'Daxarch'; // for thanks

        messageBuilder.addTo("lohith.m@daxarch.in")

                                    .setSubject(emailSubject)

                                    .setBody(emailBody)

                                    .addCC("");

        messageBuilder.setFrom("lohithmudigonda.m@gmail.com" , "Thiru") ; //sendor mail must be configured in front end.

        messageBuilder.addAttachment(_mstream, _fileName);

        SysMailerFactory::sendNonInteractive(messageBuilder.getMessage());

        info(strFmt("Email sent successfully for vendor request %1",_requestID));

    }

............................

Configure the sendor mail id :

Output :

Code to download the SSRS report to pdf in D365F&O X++

  public static void main(Args _args)

    {

        Filename                        fileName = "VendorRequest.pdf";

        SrsReportRunController          controller = new SrsReportRunController();

        SRSReportExecutionInfo          executionInfo = new SRSReportExecutionInfo();

        PRO_VendRequestContract         contract = new  PRO_VendRequestContract();

        Map                             reportParametersMap;

        SRSProxy                        srsProxy;

        System.IO.MemoryStream          mstream;

        SRSPrintDestinationSettings     settings;

        System.Byte[]                   reportBytes = new System.Byte[0]();

        SRSReportRunService             srsReportRunService = new SrsReportRunService();

        Microsoft.Dynamics.AX.Framework.Reporting.Shared.ReportingService.ParameterValue[]  parameterValueArray;

//normal code for calling report.

        PRO_VendRequestController   pRO_VendRequestController = pRO_VendRequestController::construct();

        pRO_VendRequestController.parmReportName(ssrsReportStr(PRO_VendRequest, Report));

        pRO_VendRequestController.parmArgs(_args);

        pRO_VendRequestController.parmShowDialog(false);

        pRO_VendRequestController.startOperation();

        //set controller parameters

        controller.parmReportName(ssrsReportStr(PRO_VendRequest, Report));//

        controller.parmShowDialog(false);

        controller.parmLoadFromSysLastValue(false);

        controller.parmReportContract().parmRdpContract(contract);

        // Provide printer settings

        settings = controller.parmReportContract().parmPrintSettings();

        settings.printMediumType(SRSPrintMediumType::File);

        settings.fileName(fileName);

        settings.fileFormat(SRSReportFileFormat::PDF);

        // Below is a part of code responsible for rendering the report

        controller.parmReportContract().parmReportServerConfig(SRSConfiguration::getDefaultServerConfiguration());

        controller.parmReportContract().parmReportExecutionInfo(executionInfo);

        //set proxy and service values

        srsReportRunService.getReportDataContract(controller.parmreportcontract().parmReportName());

        srsReportRunService.preRunReport(controller.parmreportcontract());

        reportParametersMap = srsReportRunService.createParamMapFromContract(controller.parmReportContract());

        parameterValueArray = SrsReportRunUtil::getParameterValueArray(reportParametersMap);

        srsProxy            = SRSProxy::constructWithConfiguration(controller.parmReportContract().parmReportServerConfig());

        // Actual rendering to byte array

        reportBytes = srsproxy.renderReportToByteArray(controller.parmreportcontract().parmreportpath(),

                                          parameterValueArray,

                                          settings.fileFormat(),

                                          settings.deviceinfo());

        //conver the byte array to memory stream

        mstream         = new System.IO.MemoryStream(reportBytes);

        File::SendFileToUser(mstream, fileName);

    }

Generate Ledger dimension for MainAccount in D365F&O X++

     public static void main(Args _args)

    {

        MainAccount mainaccount;

        LedgerDimensionDefaultAccount   lda;

        

        mainaccount = MainAccount::findByMainAccountId("110110");

        lda = LedgerDefaultAccountHelper::getDefaultAccountFromMainAccountRecId(mainaccount.RecId);

        Info(strFmt("%1",lda));

    }

......................................

Other Way :

  public static void main(Args _args)

    {

        DimensionDynamicAccount     offsetLedgerDim;

        Array                       acctDimAttrArray  = new Array(Types::String);

        acctDimAttrArray.value(1,"MainAccount");

        Array                       acctDimArray     = new Array(Types::String);

        acctDimArray.value(1,'112010');

        DefaultDimensionIntegrationValues DefaultDimensionIntegrationValues   = DimensionResolver::getEntityDisplayValue

            (acctDimAttrArray, acctDimArray, extendedTypeStr(DimensionDynamicAccount), LedgerJournalACType::Ledger);

        DimensionDynamicAccountResolver DimensionDynamicAccountResolver     = DimensionDynamicAccountResolver::newResolver

                (DefaultDimensionIntegrationValues, LedgerJournalACType::Ledger, curExt());

        offsetLedgerDim = DimensionDynamicAccountResolver.resolve();

        info(strFmt("%1",offsetLedgerDim));

    }

After runinng the job a recid will be generated.

if you are getting an error like : No active format for data entities has been set up. Set up an active format for each dimension format type. then do the following step.

in my code i've given a value for main account only, so i have added main account in dimension configuration.

Reference:

https://community.dynamics.com/blogs/post/?postid=ad1c7df5-fff2-43c1-9791-7ad80e545eec

For error resolving :

http://www.dynamicsaxhelp.com/Resolved/No-active-format-for-data-entities-has-been-set-up/46

1. \nts
2. Dimensions
3. Financial dimension configuration for integrating applications