MS Dynamics AX2012 / D365 Finance and operations

 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));         }       ...