Skip to main content

Posts

Single mode Exist DB

  KILL 51 GO SET DEADLOCK_PRIORITY HIGH GO ALTER DATABASE AxDB SET MULTI_USER WITH ROLLBACK IMMEDIATE GO
Recent posts

Seconds to Timezone HRs

        Seconds secondsElapsed = 37980;         info(time2str(secondsElapsed, TimeSeparator::Auto, TimeFormat::Auto));         info(time2StrHM(secondsElapsed));         info(time2StrHMLeadingZero(secondsElapsed));         info(time2StrHMS(secondsElapsed));

Find Userinfo from HCM WOrker

 hcmWorker                     where hcmWorker.PersonnelNumber == absenceRequestHeader.PersonnelNumber                 join dirPersonUser                     where dirPersonUser.PersonParty == hcmWorker.Person                join UserInfo                     where  UserInfo.id == dirPersonUser.User

Send email with report attachment using x++

 Hello Devs! Sending auto email functionality is one of the most common functionality that client asks for. Similarly, I have documented this blog to help people to achieve this functionality.  Pre Requisites for this approach: 1)  SMTP setting must be configured based on server.  Core Logic : public void sendEmailwithAttachment(SalesTable _salesTable)     {         Microsoft.Dynamics.AX.Framework.Reporting.Shared.ReportingService.ParameterValue[]                    parameterValueArray;         SysOperationQueryDataContractInfo       sysOperationQueryDataContractInfo;         SrsReportRunController                  reportRunController;         SRSReportExecutionInfo                  reportExecutionInfo;         SRSPrintDestinationSettings             printDestinationSettings;         SRSReportRunService                     srsReportRunService;         SRSProxy                                srsProxy;         Object                                  dataContractInfoObject;         Map   

Copy Line Functionality in D365 F&O AX 2012

Next Button Functionality on a form in D365 F&O Ax 2012