Posts

Showing posts with the label Axapta

Increase Your Storage in Azure Dev VM to fix disk size issue while D365 F&O DB restore.

Image
Hi All, When attempting to transfer a Microsoft Dynamics 365 Finance and Operations (D365 F&O) Tier 2 or higher environment database to your development machine, you may encounter a common hurdle: insufficient disk space within your development Virtual Machine (VM) due to the significant growth in the size of D365 F&O databases over time. Typically, the bacpac file downloaded from Lifecycle Services (LCS) is highly compressed. This blog post outlines a step-by-step guide to effectively address this scenario and manage your disk space during the restoration of a Dynamics 365 F&O database from a Tier 2 or higher environment. Scenario: Imagine you've imported the bacpac file into your database, and as time progresses, you find yourself running low on disk space, requiring additional room to complete the database restoration. Solution: Follow these steps to expand the available space on your drive by swapping it from another drive where memory is free: Step 1: Begin by ope...
Post a Comment
Read more

Move Database from Dynamics 365 F&O Tier 2 to Dev Environment

Hello everyone, Today, I'm sharing a concise guide on transferring data from your Microsoft Dynamics 365 F&O Tier 2 environment to your development machine. This blog will focus on the steps for importing a bacpac file that you've prepared on your Lifecycle Services (LCS) platform. To Restore a .bacpac File in Your Microsoft Dynamics 365 F&O Dev VM: Step 1: Download the bacpac file from LCS to your Dev environment. Step 2: If this is your first time importing a bacpac file into your VM, download the "Windows .NET 6" zip file and extract it to the C:\Temp folder. You can find it here: Download Link Step 3: Locate the Sqlpackage.exe file within the extracted folder. Step 4: Open a Command Prompt in Administrator mode and navigate to the folder containing Sqlpackage.exe. Step 5: Execute the following command to import the bacpac file: SqlPackage.exe /Action:Import /TargetServerName:"localhost" /TargetDatabaseName:"Testbackup" /TargetTrustServ...
Post a Comment
Read more

Create Custom Services in D365 F&O and Test using Postman Part-2

Image
 Hello Friends, Welcome back to the final part i.e. Part 2 of the series. For those who have missed the first part please refer to the below link https://vikasaxaptandd365fno.blogspot.com/2022/12/create-cusotm-services-in-d365-f-and.html So let's start with the Testing !!! To test any Services/Data entity for D365 we are required to generate the Access Token. An access token is used the authenticate the user from Azure Active Directory. To make the authentication happen(i.e. Generate Access Token), we need to create a new App registration in the Azure portal. Follow the below steps to Create App Registration, add the same in D365 F&O and Connect using Postman.  1) Log in to Azure Portal https://portal.azure.com/#home 2) Search for App Registration 3) Create New App Registrations. 4) Provide some logical name for the App registration, Select "Supported Account Type" as required. Enter the URI and Click on the Register button. 5) New app will be registered...
Post a Comment
Read more

Copy Data from Excel to D365 Finance and Operation without Excel Addins/DIXF

Image
 Hello Friends, Welcome back to my new Blog. Here I will discuss the feature where you can copy the data from Excel to D365 F&O without any excel add-ins. Yes, you heard correctly without any Excel Add-in, OData, or Data management framework. This is possible because of the new feature provided by Microsoft, "New Grid Control." Before this feature was introduced, Whenever users entered any line in the Grid, they had to wait until the system loaded all its related information in the line. So, for example, when you add a new line to the Inventory counting journal line, As soon as you select the Item number, all the related information gets loaded in the grid line like name, cost, price, etc. However, until all the corresponding data is loaded, users are not allowed to move to another/new line. This process was quite time-consuming. With this feature, users can type ahead of the system and the user can keep adding new lines without waiting for the system to load all re...
Post a Comment
Read more

Mathematical Operations in D365 Finance and Operation.

Image
Hello All, Welcome back to my new blog on Dynamics 365 Finance and Operation. Here we will discuss how to perform Mathematical operations in Dynamics 365 on the Numerical (Amount & Number) column. To increase the productivity of the end users and do the calculation quickly without using any additional app or calculator, Microsoft Dynamics 365 F&O provide an option where user can start typing =3*3 in any numerical field and press the  " Tab"  key to move out of the field, the system will evaluate the expression and save a value of  9  for the field. In the below example, Enter =3*3 in the unit price column and press Tab . Once you press the tab to move out of the field, you can see the “ Magic ” J Below is the list of operations that can be performed, for example. Kindly Note: 1)      To make the system recognize a value as an expression, start the value with an equal sign ( = ).  2)      The for...
3 comments
Read more

SSRS Report error "The parameter panel layout for this report contains more parameters than total cells available D365" Finance and Operation

Image
 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 ...
9 comments
Read more

Microsoft Dynamics 365 F&O Finance Functional Interview questions

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...
3 comments
Read more

Popular posts from this blog

SSRS Report error "The parameter panel layout for this report contains more parameters than total cells available D365" Finance and Operation

Image
 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 ...
Read more

Simplifying the Connection of Your Dev VM to Tier 2 Environment in D365D

Image
 Hi All, Welcome to my latest blog post where I'll be discussing common challenges developers face when connecting their Dev VM to the Tier 2 Environment in D365. Typically, manually replacing specific tags in the web.config file can be a tedious and error-prone process. However, I have created a utility that automates this task, simplifying the process of connecting your Dev VM to the Tier 2 Environment. To get started, simply download the utility from the link provided in your Dev VM and follow the steps below. Click here to download the file Step-by-Step Instructions: Step 1: Generate database credentials from LCS, please don't hesitate to contact me through comments if you feel any difficulty to generate Database credentials. I'll be happy to address your concerns and may even create a separate blog post on the topic. It should be like the one below. Step 2: Download the utility executable file to your Development VM and double-click it to execute. Step 3: On the comman...
Read more

Increase Your Storage in Azure Dev VM to fix disk size issue while D365 F&O DB restore.

Image
Hi All, When attempting to transfer a Microsoft Dynamics 365 Finance and Operations (D365 F&O) Tier 2 or higher environment database to your development machine, you may encounter a common hurdle: insufficient disk space within your development Virtual Machine (VM) due to the significant growth in the size of D365 F&O databases over time. Typically, the bacpac file downloaded from Lifecycle Services (LCS) is highly compressed. This blog post outlines a step-by-step guide to effectively address this scenario and manage your disk space during the restoration of a Dynamics 365 F&O database from a Tier 2 or higher environment. Scenario: Imagine you've imported the bacpac file into your database, and as time progresses, you find yourself running low on disk space, requiring additional room to complete the database restoration. Solution: Follow these steps to expand the available space on your drive by swapping it from another drive where memory is free: Step 1: Begin by ope...
Read more