Posts

Showing posts from December, 2021

Enable user when data refresh done through sql

Today we have a requirement to enable the user when there is a database refresh happens. So instead of going 1 by 1 to enable we can run the below query to enable the user. UPDATE USERINFO SET ENABLE = 1 WHERE NETWORKALIAS LIKE '%pelsis.com' OR NETWORKALIAS LIKE '%in.ibm.com' OR NETWORKALIAS LIKE '%ibm.com' Using this it will enable the user in1 shots 

Email Purchase order report when confirm through email

Image
 Today we have requirment to send the purchase order report though email when confirm the purchase order :-  In Microsoft Dynamics 365 for Finance and Operation, we usually get a requirement to email invoices from some dedicated  From email address  (e.g.  invoicing@mycompany.com ). Unfortunately, emailing reports using different  From email addresses  is not enabled in D365FO out of the box. Each outgoing email with a printed report is always sent from the email of the current user, for example  tabsheer@mycompany.com . Furthermore, if we select  SMTP  as the email provider (you can select  Email provider  in  System administration > Setup > Email > Email parameters)  we will also need to configure our mail server (for example Exchange Online) to allow the account specified in  SMTP settings  in  Email parameters  to send emails in the name of any user who emails reports. Thus, when email...