Skip to main content

Posts

Showing posts from March, 2022

An error occurred during report data sets execution D365 For finance and operations

  Hi all, small tip. I faced this issue, when I extend the custom report in D365 for finance and operations. During development on onebox     Solution was simple, restart IIS services Restart Reporting Services. Happy Daxing.
Post a Comment
Read more

List of Vendor Invoices against Payment General Entry

  Between posted Vendor Payment Journal and Settled Invoice only relation is Voucher number in ledger Journal Trans and VendSettlement Table. So My friends my code snippet is here,         VendTrans               vendTrans;         VendSettlement          VendSettlement;   while select * from VendSettlement                 join  * from vendTrans                 where VendTrans.DataAreaId == VendSettlement.TransCompany                 && VendTrans.RecId  == VendSettlement.TransRecId     ...
Post a Comment
Read more

Image stored in Dynamics Ax 2012 tables

In dynamics Ax 2012, You can read image from physical path and stored in database as follow BinData binData = new BinData(); str extention, path, nameOfFile; container imageContainer; str imageFilePathName; imageFilePathName=”C:\\abc\\ali.jpg”; // if ( WinAPI::fileExists(imageFilePathName)) { binData.loadFile(imageFilePathName); imageContainer = binData.getData(); table.Person = _Party.RecId; table.Image = imageContainer; table.insert(); } This code runs both for server side and client side. At server side execution table use winserverapi::FileExists  
Post a Comment
Read more

D365 : ENABLE AND DISABLE IN LIST PAGE

 here i have added 4 button in salesQuotationlistpage. now i need to enable/disable button according status. so i have Extensionof  of class SalesQuotationListPageInteraction and modify setButtonEnabled method by Chain of Command //list page button enable and diable in listpage interation class [ExtensionOf(classStr(SalesQuotationListPageInteraction))] final class SQTableinimathod_Extension {     protected void setButtonEnabled()     {                SalesQuotationTable SalesQuotationTable;         CustQuotationJour   CustQuotationJour;         CustQuotationConfirmJour  CustQuotationConfirmJour;               next setButtonEnabled();         SalesQuotationTable SalesQuotationTable1 = this.listPage().activeRecord(queryDataSourceStr(SalesQuotationListPage, SalesQuotationTable));         selec...
Post a Comment
Read more

D365 : SEND EMAIL

 class SRSendEmail_D365 {            public static void main(Args _args)     {           SysMailerMessageBuilder messageBuilder = new SysMailerMessageBuilder();         Email   toEmail;         Email   fromEmail;                   try         {             FromEmail = "fromemail@xyzcompany.com";             toEmail   = "oemail@xyzcompany.com";             messageBuilder.setBody("Hello from D365", false);             messageBuilder.setSubject("Email Test from D365");             messageBuilder.addTo(toEmail);             // Note: not calling setFrom() defaults to the current user for SMTP client, whereas ...
Post a Comment
Read more

D365 : Upload Via Excell Code

/// <summary> ///            Modification : Added NoYes dialog box and export template feature for Changing PO /// </summary> /// <remarks> ///         Class for updating Department in PO. /// </remarks> using System.IO; using OfficeOpenXml; class LT_Supp_UploadDepPO {     public static void main(Args args)     {         LT_Supp_UploadDepPO updateCoverRes = new LT_Supp_UploadDepPO();         DialogButton diagBut;         ;         diagBut = Box::yesNoCancel('Do you wish to upload ->"Yes" or Export template ->"No" or Abort->"Cancel"', DialogButton::Yes, 'Click');                  if(diagBut == DialogButton::Yes)         {             updateCoverRes.run();           ...
Post a Comment
Read more