How to Import Records from Excel Using X++ Code in D365FO

  How to Import Records from Excel Using X++ Code in D365FO   Include the below namespace in X++ code it will requires to import Excel. Using System.IO; Using OfficeOpenXml; Using OfficeOpenXml.ExcelPackage; Using OfficeOpenXml.ExcelRange;   In addition to the basic reference, include (Directory and DirectoryUpgrade Packages) X++ Code: Using System.IO; Using OfficeOpenXml; Using OfficeOpenXml.ExcelPackage; Using OfficeOpenXml.ExcelRange; class ReadExcel {   public static void main(Args _args)    {     Int id;     Str Name;      System.IO.Stream stream;       ExcelSpreadsheetName sheet;              FileUploadBuild fileUpload,fileUploadBuild;       DialogGroup dialogUploadGroup;       FormBuildControl formBuildControl;   ...
Post a Comment

Customize SSRS report using extension in D365FO


Customize SSRS report using extension in D365FO:



We 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.


Comments

Post a Comment

Popular posts from this blog

D365 FO: REFRESH CALLER FORM DATA SOURCE FROM A CLASS X++

 D365 FO: REFRESH CALLER FORM DATA SOURCE FROM A CLASS X++ class DemoRefresh { static void main(Args args) { Table                                      table; FormDataSource                 formDataSource ; ;   table = args.record();   if (table.RecId) { formDataSource = args.record().dataSource();   ttsbegin; table.selectForUpdate(true); table.field1 = “ABC”; table.doUpdate();   formDataSource.executeQuery();   formDataSource.refresh();   ttscommit; info(table updated'); } }   }
Read more

Passing Args from one Form to another Form in dynamics AX

Args in dynamics AX is one can easy way to pass arguments from one Form to another Form. Here, how to pass Arguments from Form to Form.   So when I select one record in grid Form A, that record will be passed to Form B Form B will filter the record and will show. Step 1: Make one TestTable which has three fields named (ID, name). Step 2: Make FormA with datasource as TestTable and drag the datasource fields into the design Grid. Step 3: Drag one button and override the click method and write the following code. void clicked() { Args args; FormRun formRun; ; super(); args = new args(formstr(FormB)); // sending record to FormB using Args args.record(TestTable); formrun = classfactory.formrunclass(args); formrun.init(); formrun.run(); formrun.wait(); formrun.detach(); } step 4: Make FormB with datasource as same table for which you take for Form A i.e., TestTable step 5: write the following code in to the init method of FormB. public void init() {...
Read more

CREATE AND POSTING PURCHASE ORDER THROUGH X++ DYNAMICS AX

CREATE AND POSTING PURCHASE ORDER X++ : static void PurchOrderCreate(Args _args)   { NumberSeq numberSeq; PurchTable purchTable; PurchLine purchLine; ttsBegin; numberSeq = NumberSeq::newGetNum(PurchParameters::numRefPurchId()); numberSeq.used(); purchTable.PurchId = numberSeq.num(); purchTable.initValue(); purchTable.initFromVendTable(VendTable::find('1001')); if (!purchTable.validateWrite()) { throw Exception::Error; } purchTable.insert(); purchLine.PurchId = purchTable.PurchId; purchLine.ItemId = “ItemId; purchLine.createLine(true, true, true, true, true, true); ttsCommit; info(strFmt( "Purchase order '%1' has been created", purchTable.PurchId)); } .............................................. static void PurchaseOrderPost(Args _args) { PurchFormLetter purchFormLetter; PurchTable purchTable; purchTable = PurchTable::find('purchid'); purchFormLetter = PurchFormLetter::construct(DocumentStatus::PurchaseOrder); p...
Read more