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;       Dialog dialog=new Dialog("Excel Import using dialog");       dialogUploadGroup=dialog.addGroup("@SYS54759");       formBuildControl=dialog.formBuildDesign().control(dialogUploadGroup.name());    
Post a Comment

Cardinality and RelatedTableCardinality table relation property in D365 FO

 Cardinality and RelatedTableCardinality table relation property in D365 FO

Cardinality is the property which explains about nature of the relationship between two tables on the related table.

For example:

ZeroOne: You will select this, provided child Table/related table can either have no record or have only one related record (Fetch Mode is 1:1).

ExactlyOne: You will select this, provided child Table/related table can have only one related record (Fetch Mode is 1:1). 

ZeroMore: You will select this, provided child Table/related table can either have no record or more than one related record (Fetch Mode is 1:n).

OneMore: You will select this, provided child Table/related table can have more than one related record (Fetch Mode is 1:n).

Cardinality specifies how many instances of SalesLine row can be related to a single instance of SalesTable row.ZeroMore means that for every sale order, there can be zero, or more sales lines related to it. If the business requirement dictates that you need to have at least one sales line to be able to create a sales order, the Cardinality would be OneMore (1:*).


RelatedTableCardinality specifies how many instances of SalesTable row can be related to a single instance of SalesLine row. ExactlyOne means that every sales line should belong to one and only one sales order.

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

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 FreeTextInvoi
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