D365 F&O send email through x++ code

 

1- We need first to check  System Administration >> Setup >> Email parameters 

2- Create below Method to use in your Class  

SendMail::SendMail("New approve required" 

                , strFmt("New  approval required  %1" , _TransID )

                , strFmt("Body  %1" , strBody), curUserId());

class SendMail

{

public static void SendMail(str strsenderName , str subject, str strbody, UserId userId )//= "sheriffayed")

    {

        SysOutgoingEmailTable outgoingEmailTable;

        SysEmailItemId nextEmailItemId;

        Map map;

        str SenderName, SenderEmail, To , Body;

    ;

        SenderName = strsenderName;

    SenderEmail = "admin@xxx.com";

    To = SysUserInfo::find(userId).Email;

    Subject = subject;

    Body = strbody ; // "<B>Test Body of the email</B>";

    nextEmailItemId = EventInbox::nextEventId();

    outgoingEmailTable.EmailItemId = nextEmailItemId;

    outgoingEmailTable.IsSystemEmail = NoYes::No;

    outgoingEmailTable.Sender = SenderEmail;

    outgoingEmailTable.SenderName = SenderName;

    outgoingEmailTable.Recipient = To;

    outgoingEmailTable.Subject = SysEmailMessage::stringExpand(Subject, map);

    outgoingEmailTable.Priority = eMailPriority::Normal ;

    outgoingEmailTable.WithRetries = false;

    outgoingEmailTable.RetryNum = 0;

    outgoingEmailTable.UserId = userId;

    outgoingEmailTable.Status = SysEmailStatus::Unsent;

    outgoingEmailTable.Message = Body;

    outgoingEmailTable.LatestStatusChangeDateTime = DateTimeUtil::getSystemDateTime();

    outgoingEmailTable.insert();

     }

    }

D365 Running an SSRS report from the selected record X++

 

All the steps are mentioned in the article: Create SSRS report .

After completing all the steps of the article , you would have the following elements in your project:

• RDP Class
• Controller Class
• Contract Class
• Temporary tables
• Report
• Output menu item
• Form extension

After that, you have to override a function of controller class. Just copy and paste the following function in the controller class:

protected void prePromptModifyContract()
{
     PurchaseOrderContract contract = this.parmReportContract().parmRdpContract() as PurchaseOrderContract;
     if(this.parmArgs().dataset() == tableNum(PurchTable))
     {
          PurchTable purchTable = this.parmArgs().record() as PurchTable;
          contract.parmPurchId(purchTable.PurchId);     
     }
}

I have already mentioned the properties of the Output Menu Item and the form’s Menu Item Button in Create SSRS report . But, because it is too much important, so I am mentioning them again below:

Set the properties of output menu item as follows:

• Object: PurchaseOrderController
• Object Type: Class
• Subscriber access level: Unset
• Needs Record: Yes

Create an extension of form in which you want to show the output menu item. In this scenario, you should add the button where the Main Data Source table is PurchTable. As, we are fetching the record from the form using the prePromptModifyContract() function.

We have created the Purchase Order Report with the Purchase Order Number (PurchId) as the parameter. So, we should use the PurchTable form.

So, create extension of the form by right-clicking the PurchTable in AOT->User Interface->Forms. Then click the Create extension. In the project, an extension of the PurchTable form would be created. In the form, create Menu Item Button and set the properties as follows:

• Data Source: PurchTable
• Needs Record: Yes
• Menu Item Name: Name of OutputMenuItem
• Menu Item Type: Output

Note: Needs Record and Data Source properties are only required if you are running an SSRS report from the selected record of a form. Otherwise, it’s not mandatory.

Also, see the article about how to Create SSRS report and how to Customize SSRS report using extension and D365 Running an SSRS report from the selected record.

D365FO Customize SSRS report using extension X++

• Create SSRS report in D365FO

 In this tutorial, will show you how to customize & extend data set and design of Free Text Invoice report. Let’s start.

I have to add two fields in the table and to show these fields in Free Text Invoice report. If you have come across the Free Text Invoice report. You may have noticed that it uses contract class, controller class, DP class and print management class to generate the report.

What you have to do to customize SSRS report using extension in D365FO is to create the extension of table, implement the events to insert the data into the extended fields, customize the design, extend the controller class and subscribe to the delegate of print management document type class to re-route the print management to execute your new design.

I have done the following steps:

• Create extension of FreeTextInvoiceTmp table and add the field i.e. TotalAmounInWords
• Create a class named FreeTextInvoiceController_Events to implement the event handler methods
• Copy the post handler event method of processReport() of FreeTextInvoiceDP class and paste in the class created in previous step.
  • NOTE: You can also use the OnInserting event of table instead of processReport() of DP class.
• Write the following logic to insert the data into the
  TotalAmounInWords field we have created:

class FreeTextInvoiceController_Events
{
    [PostHandlerFor(classStr(FreeTextInvoiceDP), methodStr(FreeTextInvoiceDP, processReport))]
    public static void FreeTextInvoiceDP_Post_processReport(XppPrePostArgs args)
    {
        FreeTextInvoiceDP dpInstance = args.getThis() as FreeTextInvoiceDP;
        FreeTextInvoiceHeaderFooterTmp freeTextInvoiceHeaderFooterTmp = dpInstance.getFreeTextInvoiceHeaderFooterTmp();
        FreeTextInvoiceTmp freeTextInvoiceTmp = dpInstance.getFreeTextInvoiceTmp();
        ttsbegin;
        while select forUpdate freeTextInvoiceTmp
        {
            freeTextInvoiceTmp.TotalAmounInWords = numeralsToTxt(freeTextInvoiceTmp.InvoiceAmount);
            freeTextInvoiceTmp.update();
        }
        ttscommit;
    }
}

• Find out the FreeTextInvoice report in the AOT,
• Right-click the report and click Duplicate in project.
• Customize the design and add TotalAmountInWords field as per your requirements
• Create another class named FreeTextInvoiceControllerExt which extends the FreeTextInvoiceController class. Override the main() method. Give the new report and it’s design name in it.
• Add the following logic in FreeTextInvoiceControllerExt class:

class FreeTextInvoiceControllerExt extends FreeTextInvoiceController
{
    public static FreeTextInvoiceControllerExt construct()
    {
        return new FreeTextInvoiceControllerExt();
    }

    public static void main(Args _args)
    {
        SrsReportRunController formLetterController = FreeTextInvoiceControllerExt::construct();
        FreeTextInvoiceControllerExt controller = formLetterController;
        controller.parmReportName(ssrsReportStr(FreeTextInvoiceCopy, Report));
        controller.parmArgs(_args);
        controller.startOperation();
    }
}

• Create another class named PrintMgtDocTypeHandlersExt
• Add a method in it which subscribes to the event delegate of PrintMgmtDocType class to re-route the report from the default to this customized report
• Add the following logic in PrintMgtDocTypeHandlersExt class:

class PrintMgtDocTypeHandlersExt
{
    [SubscribesTo(classstr(PrintMgmtDocType), delegatestr(PrintMgmtDocType, getDefaultReportFormatDelegate))]
    public static void getDefaultReportFormatDelegate(PrintMgmtDocumentType _docType, EventHandlerResult _result)
    {
        switch (_docType)
        {
            case PrintMgmtDocumentType::SalesFreeTextInvoice:
                _result.result(ssrsReportStr(FreeTextInvoiceCopy, Report));
                break;
        }
    }
}

• Create extension of the following menu items which executes report:
  • FreeTextInvoiceCopy
  • FreeTextInvoiceOriginal
• Change the controller class name in the Object property of the extended menu items to the FreeTextInvoiceControllerExt class created above
• Save, build and synchronize and deploy the project/reports.

In this way, we can customize SSRS report using extension in D365FO

Also, see the article about how to Create SSRS report and how to Customize SSRS report using extension and D365 Running an SSRS report from the selected record.

AX365 Dev machine import restore a DB .bacpac file from the UAT - D365 F&O

 Download the  Get sqlpackage .NET Core for Windows

extract the folder and run command prompt as an administrator and run the below command

 

SqlPackage.exe /a:import /sf:D:\DB\UATbackup.bacpac /tsn:localhost /tdn:AxDB /p:CommandTimeout=1200 /TargetTrustServerCertificate:True

Reference from https://heshamelgabarty.blogspot.com/

 

D365 / AX 2012 Price and amount not printed in Purchase Order Confirmation

 

When printing the confirmed purchase order , the  unit price and amount does not show up in the report.

This happen with some POs not all

The normal confirmation contain price and amount details like below

 I checked the AP parameters , Form notes ,Form setup but could not find anything . by  checking the report logic now find the solution below 

Go to the Vendors Form, Purchase Order tab for the applicable Vendor. Check that the Purchase order prices/amount box is ticked.

This solution did not display the prices for the previous version of the PO confirmation

To solve previous version of the PO confirmation one more trick to sort out the back log issue or previously printed purchase orders ( which will not show the prices any way  even after revising vendor master purchase order default as mentioned ) .

- go to SQL table (VENDPURCHORDERJOUR) select the field AMOUNTPURCHASEORDER

set the value to "1".

For AX 2012

SQL Statement 

UPDATE   VENDPURCHORDERJOUR

SET           AMOUNTPURCHASEORDER = 1

WHERE     (AMOUNTPURCHASEORDER = 0)

For D365

Create Runnable class and use below Code 

   VendPurchOrderJour _VendPurchOrderJour;

 

            ttsbegin;

            update_recordset _VendPurchOrderJour

                setting  

                AmountPurchaseOrder = NoYes::Yes

                where _VendPurchOrderJour.AmountPurchaseOrder == NoYes::No;

            ttscommit;

AX 2012 QRCode is not generated in SSRS Report

 

 

AX 2012 QRCode is not generated in SSRS Report

 

Exception of type ‘Microsoft.Dynamics.Ax.Services.XppBridgeException’ was thrown.

I made SSRS Report with DP Class. 

I need to generate QR Code in this SSRS Report. 

Container QRCode;

 QRCode = new EFDocQRCode_BR().generateQRCode(“QrText”);

It was working fine But at some point, the error occurred. 

 

In Event viewer  the error occurred like this. 

 

An error has occurred during report processing. (rsProcessingAborted)

 

An error has occurred during report processing. (rsProcessingAborted)

 

Microsoft.Reporting.WinForms.ReportServerException

   at Microsoft.Reporting.WinForms.SoapReportExecutionService.ServerUrlRequest(AbortState abortState, String url, Stream outputStream, String& mimeType, String& fileNameExtension)

   at Microsoft.Reporting.WinForms.SoapReportExecutionService.Render(AbortState abortState, String reportPath, String executionId, String historyId, String format, XmlNodeList deviceInfo, NameValueCollection urlAccessParameters, Stream reportStream, String& mimeType, String& fileNameExtension)

   at Microsoft.Reporting.WinForms.ServerReport.InternalRender(Boolean isAbortable, String format, String deviceInfo, NameValueCollection urlAccessParameters, Stream reportStream, String& mimeType, String& fileNameExtension)

   at Microsoft.Reporting.WinForms.AsyncMainStreamRenderingOperation.RenderServerReport(ServerReport report)

   at Microsoft.Reporting.WinForms.AsyncRenderingOperation.PerformOperation()

   at Microsoft.Reporting.WinForms.ReportViewer.AsyncReportOperationWrapper.PerformOperation()

   at Microsoft.Reporting.WinForms.ProcessingThread.ProcessThreadMain(Object arg)

 

Query execution failed for dataset 'SalesInvoiceDS'. (rsErrorExecutingCommand)

Microsoft.Reporting.WinForms.ReportServerException

An exception occurred in the query metadata execution. The exception is Exception of type 'Microsoft.Dynamics.Ax.Services.XppBridgeException' was thrown..

Microsoft.Reporting.WinForms.ReportServerException

Exception of type 'Microsoft.Dynamics.Ax.Services.XppBridgeException' was thrown.

Microsoft.Reporting.WinForms.ReportServerException

Exception of type 'Microsoft.Dynamics.Ax.Services.XppBridgeException' was thrown.

Microsoft.Reporting.WinForms.ReportServerException

 

 

So I debugged.  And error happen there

 

Solution

After Investigation for long time

qrCodeReturn will return path of temp file, but error cause here. Try to delete AppData\Local\Temp, but It's didn't work.

SO I checked This folder for AOS service user and the folder was Read Only, we don’t know why the folder permission changed, but once we unchecked read only for folder and delete all old temp files it worked fine.

 

D365 F&O GET TABLE IDS

PURPOSE:

The purpose of this post is to demonstrate how we can get the table ids out of the development or production environment of Dynamics 365 for Finance and Operations.

 

In AX 2012, we used to find table ids from the properties window for a selected table in AOT, however this option is not available anymore in Dynamics 365 for Finance and Operations for production environments at least. However there is still a way to get table ids fortunately using the SysTableBrowser form. The SQL table SysTableIdView can be queried directly from SQL if it is a development environment or can be viewed from SysTableBrowser form if it is a production environment using the following URL:

https://base-url.sandbox.ax.dynamics.com/?cmp=USMF&mi=SysTableBrowser&tableName=SysTableIdView 

D365 F&O : DISPLAY METHOD ON TABLE EXTENSION

 On Dynamics 365 for Operations we don’t have the option to create methods on table extension, so we should use the extension class to do that. The example below will show how to create a display method on the table extension class and use on a form extension.

First create your table extension class and your display method following the example below:

1 2 3 4 5 6 7 8 9

public static class MyCustTable_Extension { //This attribute will cache your display method.     [SysClientCacheDataMethodAttribute(true)]     public static display Name myDisplayName(CustTable _this)     { //Do here your display method as usual.         return _this.nameAlias() + "myDisplayName";     }   }

To use your display method on the form, create your new field on the form extension and use the property as below:

To cache your display method on the form set on the field the property “Cache Data Method” = yes if you don’t want to use the Attribute above.

Ref