Posts

Showing posts from January, 2024

How to pass Arguments/records in RDP Report through form, how to open report from the Form using controller class (X++) in D365 Finance and operation.

Image
  In this article, I will guide you on how to pass arguments or records from a form to a report as parameters. I have developed a report that prints the purchase order for a specific purchase ID (with either ‘Received’ or ‘Invoiced’ purchase status), which I pass through the form. Let’s begin by creating a simple Finance and Operations project in Visual Studio. We will add all the elements required to develop the report. The following elements are necessary: Temp table (with required fields, fields which mapped in Dp class) Contract class Data Provider Class Report (Add the DP class to the Dataset of the Report, and create the report design according to your requirements) For the  PurchTable  Form, create a Form Extension of the  PurchTable  Form and add a button group and button in the Action pane. DP Class: [SrsReportParameterAttribute(classStr(PurchTable_Contract))] class PurchTable_DP extends SRSReportDataProviderBase { PurchReceiptTmp prt; //Seri...

Restore UAT DB in Teir 1 Using DFO Tool

Here's how you can restore the UAT DB in Tier 1 using the DFO tool script: Open Windows PowerShell ISE. Run the below command: Please note instal DFO tool in the tier 1 enrvioment first :-  https://github.com/d365collaborative/d365fo.tools/blob/development/docs/Enable-D365User.md ========================================================================= Write-Host "Get bacpac" $currentDate = Get-Date -Format yyyyMMdd $downloadPath = "J:\MSSQL_BACKUP\MockGL{0}.bacpac" -f $currentDate $newDBName = "AxDB_{0}" -f $currentDate   Invoke-D365AzCopyTransfer -SourceUri " https://d365opsastey7emzowmgccv.blob.core.windows.net/81943951-e06d-4a0a-8780-6d12458ef954-c4a28672/0qRPInM8fa2QNEE7z0aNj9?skoid=9ef30196-cd78-4a47-955e-89a3947f0a23&sktid=975f013f-7f24-47e8-a7d3-abc4752bf346&skt=2024-01-17T12%3A35%3A23Z&ske=2024-01-20T13%3A35%3A23Z&sks=b&skv=2023-11-03&sv=2023-11-03&st=2024-01-17T12%3A35%3A23Z&se=2024-01-20T13%3A35%3A2...