Features of Dynamics D365 Finance and Operation and Axapta

 Hi Friends, Today, we will discuss the resolution for one of the report deployment issues i.e. "The parameter panel layout for this report contains more parameters than total cells available D365"  To fix this issue, please follow the below steps. Step 1: Open notepad with the Administrator account. Step 2: Open the RDL file located within the Module folder in the K drive Step 3: Seach for the "ReportParametersLayout" tag and remove the entire tag. Step 3: Save the File. Open Visual Studio and deploy the report. You can also run the below command in Power Shell(Run power shell as admin) to deploy the report. (Replace with your model name which is in italic) "K:\AosService\PackagesLocalDirectory\Plugins\AxReportVmRoleStartupTask\DeployAllReportsToSSRS.ps1 -Module your_model_name  -PackageInstallLocation “K:\AosService\PackagesLocalDirectory”" Please do comment and let me know if you were facing the same challenge and if this solution worked for you.  Keep ...

Hello Friends, I am Vikas Vaish and I am back with a new topic of discussion i.e. Computed column in the data entity for D365 for Finance and Operation. Scenario:       1) We have to add any system-generated fields to our data entities like "Created By", "Created Date Time", "RecId" etc.       2) We need to create a computed field that displays data from some other table that is not part of the Data Source in our current Data entity. We can achieve the above requirement by creating computed columns and writing simple SQL statements (Without x++ code). The SQL statement can be simple or complex as per our business requirements. We can even write SQL Case, Subqueries in our SQL statement. So let have a look at how we can proceed. Solution Scenario 1: For this example let create one Data entity for the Customers (CustTable) Here we can see CustTable as the main table for the Data entity. So when the system compiles this data entity, It creates a belo...

Greetings, In today's blog post, we will explore some useful tricks for working with Microsoft Excel add-ins. Specifically, we will cover how to create, modify, update, and delete data across multiple legal entities within Microsoft Dynamics 365 Finance and Operations. Scenario: Suppose you need to perform multiple create, delete, and update operations across different legal entities on a specific form. This can be a time-consuming and laborious task if done manually. Fortunately, there is an alternative solution using MS Excel add-ins, which we will demonstrate in this post. Prerequisites: This technique applies to forms that have a corresponding data entity. Microsoft Excel 2016 or a higher version must be installed on your system. Microsoft Dynamics Excel add-ins must be properly configured within Microsoft Excel. Example: To illustrate this process, we will use the Fixed Asset Group form. However, this functionality is not limited to this form alone and can be used in any entit...

Hello Friends, I am Vikas Vaish the Microsoft dynamics D365 F&O Techno-Functional consultant. Below are the few questions that I have faced while interviewing for Microsoft Dynamics 365 F&O Finance Functional consultant. I have tried to give answers based on my experience which mostly worked for me  😉 . Feel free to share your thoughts through the comment section. Even I am learning and let do it together. 1)      What is COA? The chart of accounts is a structured list of a legal entity's general ledger accounts. The list is used to prepare financial reports for authorities and owners. The accounts are first grouped into types of accounts and then further aggregated into larger categories. At the most general level, the accounts are grouped as revenues and costs (operating accounts), and assets and liabilities (balance accounts). COA can be shared and used by any legal entity in an organization. COA that is used by a legal entity is defined on the Ledge...