MS Dynamics AX2012 / D365 Finance and operations

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 

 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...

 The point to be Remembered:-  Stop all the Ax services and iis. 1) Download and install DAC from the below link  Download and run the DacFramework.msi installer for Windows. https://docs.microsoft.com/en-us/sql/tools/sqlpackage/sqlpackage-download?view=sql-server-ver15 Open a new Command Prompt window, and run sqlpackage.exe sqlpackage is installed to the C:\Program Files\Microsoft SQL Server\150\DAC\bin folder 2) Run the command in the Admin mode  cd C:\Program Files\Microsoft SQL Server\150\DAC\bin 3) Once it gets the command run the below command to start the DB refresh SqlPackage.exe /a:import /sf:C:\DBBackUp\PELSISPREPRODbackup.bacpac /tsn:localhost /tdn:PRDUT2 /p:CommandTimeout=1200 4) Then take the Bak file to import it again in a fast way. where, tsn (target server name) – The name of the SQL Server to import into. tdn (target database name) – The name of the database to import into. The database should not already exist. sf (source file) – The path and name...

 Today we have a requirement to show the running total in the new color, for example, debit-credit will show in the 3rd coloum and as per the grouping also .. =RunningValue(iif(Fields!AmountCur.Value > 0, Fields!AmountCur.Value, 0) + iif(Fields!AmountCur.Value < 0, Fields!AmountCur.Value, 0), Sum , "Grouping1_0") Grouping1_0 -- grouping name in SSRS report 

 Today we have a requirement to make a new design and make some customization in the Vendor Account statement report in Account payable. 1) Create Controller class with extension "VendAccountStatementIntController". 2) Create Dp class extension. 3) Create menu item extension "VendAccountStatementInt.xxxCommon" 4)  Add fileds in  Temp table "CustVendAccountStatementIntTmp.xxxCommon". ===================================================================== 1) Create Controller class with extension "VendAccountStatementIntController". :-  class RSVendAccountStatementIntControllerExt extends VendAccountStatementIntController {     public void execute(Args _args)     {                  if (BrazilParameters::isEnabled())         {             this.parmReportName(ssrsReportStr(VendAccountStatementInt, ReportBR));         }       ...

  About import The process of database import is needed when a new developer starts to work on a project and requires configured data for performing testing scenarios. In our projects we use preconfigured user data to improve our development and testing performance. We store a Tier 1 environment database backup (.bak) and use it when a new developer comes to work with a project. As Microsoft releases platform updates, we need, somehow, to use old backups from environments of older versions, for data import on Tier 1 developer environments. Keep in mind, that this article considers only Tier 1 environments. This instruction can be used to import and work with databases for different projects. Import database To import database a developer needs to have the database backup. Importatnt! For this operation you need to use Tier 1 database backup (.bak). 1.  Download database backup. The database backup can be found in Asset Library of LCS (LifeCycle Services) project, as it is show...