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

RelationshipType in D365 FO

 RelationshipType in D365 FO


In  AOT > Data Dictionary > Tables > Table > Relations, you can set the value of the RelationshipTypeproperty of the new relation.

The following table describes the elements of the RelationshipType property.

Element name

Description

Automatic inference

NotSpecified

Often the default value for the RelationshipTypeproperty.

When the RelationshipType property has the valueNotSpecified, the system infers an appropriate value. The system infers the value in the following sequence:

1.               Specialization

2.              Link

3.              Composition

4.              Aggregation

5.              Association

For example, if the criteria for both Composition andAggregation are met, the system infers Composition. This is true because Composition occurs earlier in the list.

Specialization

Applies only to table inheritance, to relationships between base and derived tables.

The system sets the RelationshipType property toSpecialization whenever table inheritance is involved.

Link

Is a non-relational relationship. Link requires that the Validate property be set to No.

This type of relationship supports navigation between forms that list many records from a table and forms that provide detail fields for one record from the table.

Link is meant only to support the migration of extended data type (EDT) link relations for upgrade to Microsoft Dynamics AX 2012 from earlier versions of the product. Migration tools create this type relationship, but you must not.

Composition

Is a stronger type of Aggregation. A table must not have more than one Composition relation. For example, a building is composed of rooms, and a given room cannot exist in more than one building.

If the criteria for Composition are met, but you manually assign the value of Aggregation or Association, the system leaves the value as Aggregation or Association.

Aggregation

Is appropriate when the child table is considered to be subordinate to the entity of the parent table.

The system infers Aggregation when either of the following is true:

·                 The parent table has a delete action node that is defined to use this relation node.

·                 Any of the foreign key fields for this relation in the child table have their Mandatory property set toYes.

If the criteria for Aggregation are met, but you manually assign the value of Association, the system leaves the value as Association.

Association

The concept of a standard foreign key.

You must set the RelationshipType property toAssociation if the system does not set the value of property to anything, and both Aggregation andComposition are inappropriate.

 

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