Posts

add contract class in to other contract class in x++ in d365F&O

    List items = new List(Types::Class);     [DataMemberAttribute("Items"),     DataCollection(Types::Class, classStr(<Name of contract class>)),     AifCollectionTypeAttribute('_items', Types::Class, classStr(<Name of contract class>)),     AifCollectionTypeAttribute('return', Types::Class, classStr(<Name of contract class>))]     public List parmitems (List _items = items )     {         items  = _items ;         return items ;     }
Post a Comment
Read more

Cancel Post packing slip from all Shipments in D365 F&O through X++

 Hi Viewers, To Cancel Post packing slip for Shipments. we first have to cancel the Packing slip, reverse the shipment, and then reopen the container. To Cancel Post packing slip:   WHSLoadTableCustPackingSlipJour loadCustJour;  CustPackingSlipJour             custJour;    WHSLoadTable        loadTable;        loadTable = whsshipmenttable::find(ShipmentID).whsLoadTable();      while select custJour          where custJour.Qty          exists join loadCustJour              where loadCustJour.WHSLoadTableLoadId       == loadTable.LoadId              &&    loadCustJour.WHSLoadTableDataAreaId   == loadTable.DataAreaId              &&    loadCustJour.CustPa...
Post a Comment
Read more

In ax D365F&O post packing slip from shipment through code x++.

 Hi viewers, To post the packing slip for the sales order from the shipment, we first have to close the containers, confirm the shipment, and then post the packing slip. these steps can be handled either through code or manually updated from the form by the user. I am sharing the code to update accordingly. To Close the container.  public void closeContainer()  {       WHSContainerTable               containerTable;      WHSCloseContainerProfile        closeContainerProfile;      WHSShipmentTable                shipmentTable;                containerTable = WHSContainerTable::findByContainerId(PackageDetailsTable.ContainerId);          closeContainerProfile = WHSCloseContainerProfile::find(containerTable.CloseContainerProfileId);         ...
Post a Comment
Read more

Call third party API from D365F&O through code x++, with Authentication key and user login

 Hi viewers, Please check the code to call third-party API from D365 F&O through code x++. For authentication sample code:   public str getKey()   {       System.Net.HttpWebRequest request;       System.IO.Stream stream;       System.Exception sysEx;       str responseBody;       container con;       request = System.Net.WebRequest::Create(" URL") as System.Net.HttpWebRequest;       request.Method = 'post';       request.ContentType = 'application/json';       str jsonstring = strFmt('%1%2%3%4%5%6%7','{','"login"',':','"info@****.com",','"password":','"******"','}');       var utf8 = System.Text.Encoding::get_UTF8();       var byteArrayPayload = utf8.GetBytes(jsonstring);       using (System.IO.Stream dataStream = request.GetRequestStream())       {        ...
Post a Comment
Read more

Cannot select a record for update when the transaction is not started on the user connection attached. You need to begin transaction on the user connection first. in d365F&O

 Hi Viewers, I have recently faced this error while working on the standard report. In standard DP class temp table has userconnection. So whlie updating I got below error. Cannot select a record for update when the transaction is not started on the user connection attached. You need to begin transaction on the user connection first . in d365F&O. To fix this use  <TmpTablebufferName>.ttsBegin();  <TmpTablebufferName>.ttscommit(); Example:         VendAccruedPurchasesTmp vendAccruedPurchasesTmp;   VendAccruedPurchasesTmp.ttsbegin();         while select  forupdate VendAccruedPurchasesTmp                 where VendAccruedPurchasesTmp.ItemId != ''                 &&                  VendAccruedPurchasesTmp.AVACIProcurementCategory == ''             /...
Post a Comment
Read more

Records to include in SSRS Report With UI Builder class

Image
 Hi Viewers, Records to include Tab will not shown in the SSRS report if the report is generated along with the UI Builder class. If you want Record to include a tab in Report. Please create a query and add it to the DP class. And enable dynamic filters to Yes in report dataset properties. Create a query. Add it to the DP class in the attribute. Restore or add to the data set in the report. change dynamic filters to Yes. Note: If you restore the dataset in the existing report. then sometimes you may get the ' the count of parameters not matched ' error while the report is deployed. In that case, create a new design and try again.
Post a Comment
Read more

Multi select lookup in UI Builder class in D365F&O through x++ code.

 Hi Viewers, Below is the code sample for Multi-select lookup in the SSRS report by UI builder class. In this example, I am using  UI builder class - ItemListUIBuilder Contact class - ItemListContract DP class - ItemListDP In the contract class add a list-type parameter, as shown below. Contract class must decorated with attributes as shown below. give the ULBuilder class name to SysOperationContractProcessingAttribute [ DataContractAttribute,     SysOperationContractProcessingAttribute(classStr(ItemListUIBuilder))] class ItemListContract {   List                        ItemIDList;   [   DataMemberAttribute,         AifCollectionTypeAttribute("Item Id", Types::String)      ]     public List parmItemIdList(List _ItemIDList = ItemIDList)     {       ItemIDList = _ItemIDList;       return ItemIDLis...
Post a Comment
Read more