Managing item purchase prices effectively is crucial for accurate cost control in Microsoft Dynamics 365 Finance & Operations (D365FO). One of the key features that impacts how item prices update is the Latest Purchase Price Parameter. When enabled, this parameter ensures that an item’s price is updated based on the most recent purchase cost recorded in a Purchase Order (PO). This means that every time a new PO is created, the item’s purchase price can change depending on the most recent cost price recorded in the system. In this blog, we will explore:The impact of enabling the Latest Purchase Price parameter.Step-by-step instructions to activate this parameter.How to track price changes using Last Price History. Impact of Enabling the Latest Purchase Price Parameter Key Effects of Enabling This Parameter:The purchase price of an item in the Item Master updates automatically based on the latest purchase price in a PO.This applies to both fixed and variable pricing models.If multiple POs are created for the same item at different prices, the purchase price will fluctuate accordingly.The updated purchase price will also reflect in the Manage Cost > Item Price section. Example Scenario: Steps to Enable the Latest Purchase Price Parameter in Released Products Step 1: Navigate to Released Products Step 2: Select the Product Step 3: Enable the Latest Purchase Price Parameter Step 4: Set Initial Price in Product Master Step 5: Create a Purchase Order (PO) Step 6: Update the Purchase Price Step 7: Confirm the Purchase Order Step 8: Post the Product Receipt (GRN) Step 9: Invoice the Purchase Order Outcome:Once invoicing is complete, navigate to the Product Master and open the product. If the Latest Purchase Price parameter is enabled, you will see that the purchase price has been updated from 50 USD to 100 USD, reflecting the latest purchase cost. Additionally, under Manage Cost > Item Price, the updated purchase price of 100 USD will be visible. How to Enable Last Price History in Dynamics 365 To track purchase price fluctuations over time, you need to enable the Last Price History feature. Steps to Enable Last Price History: Outcome:Once enabled, you can view historical purchase price changes in the Item Price section, helping businesses analyze pricing trends and make informed purchasing decisions. To conclude, enabling the Latest Purchase Price Parameter in D365FO ensures that item prices remain current based on the most recent purchase cost. This feature is beneficial for businesses managing fluctuating costs and needing accurate pricing in their procurement process. Additionally, by enabling Last Price History, organizations can track price variations over time, ensuring better cost analysis and decision-making. By following the steps outlined in this blog, you can optimize your item pricing strategy and enhance financial accuracy in Dynamics 365 Finance & Operations. We hope you found this blog useful, and if you would like to discuss anything, you can reach out to us at transform@cloudfonts.com. Need further assistance? Feel free to leave a comment or reach out for expert guidance on pricing configurations in D365FO! Thank you for reading!

Dynamics 365 Finance and Operations (D365 F&O) allows customization through extensions, enabling developers to add new fields to existing tables and forms without modifying the original Microsoft code. This approach ensures upgrade safety and maintainability. In this blog, we’ll cover: Step 1: Creating a Table Extension A table extension lets you add custom fields to an existing table (e.g., CustTable for customers). 1. Create a Table Extension In Visual Studio, right-click your project → Add → New Item. Select Dynamics 365 Items → Data Model → Table Extension. Name it (e.g., MyCustTableExtension). 2. Define the New Fields After choosing the appropriate data type and entering the required information, you can proceed to create the field. 3. Synchronize the Database After adding fields: Right-click the project → Build. Right-click the project → Dynamics 365 → Synchronize Database. Step 2: Extending a Page to Display the New Fields Now, let’s add these fields to the Customer Details page (CustTable form). 1. Create a Page Extension Right-click your project → Add → New Item. Select Application Explorer → User Interface → Forms  → Create Extension. Name it (e.g., MyCustTablePageExtension). 2. Add Fields to the Page You can drag and place where you want. 3. Build and Test Build the project (F6). Run the CustTable form (Ctrl+F5). Open a customer record → Your new fields should appear under “General Tab”. Best Practices for Extensions To conclude, with table and form extensions, you can safely customize D365 F&O without altering base Microsoft code. This ensures smoother upgrades and better maintainability. Try it out and enhance your F&O implementation today! We hope you found this blog useful, and if you would like to discuss anything, you can reach out to us at transform@cloudfonts.com.

Working with Lifecycle Services (LCS) may feel a bit outdated as we prepare for its eventual phase-out, but the reality is that many businesses still rely on it daily. Recently, I encountered an issue while deploying to a new environment after a long break; it kept failing without a clear cause. After investigating, I discovered the SSL certificate was the culprit, which I’d run into before (I’ve shared that experience in a previous post). Naturally, I tried rotating the secrets from LCS, but it failed repeatedly without any error message or explanation. I was ready to raise a ticket with Microsoft when Copilot stepped in with a suggestion that helped me quickly resolve the problem. Here’s what happened and how you can fix it if you face the same issue. What to do: Go into your development VM and search for certificates. You’ll see there’s a certificate with the same name as your VM and if you observe the “Expiration Date” it is past your current date. This is the reason the certificate rotation is failing. Microsoft offers a simple script that can be used to generate another certificate to replace this. Go to “Shared Asset Library” in LCS. Scroll down to “Renew WinRM Certificate” and download it. Move the downloaded zip into your Development VM and extract it. Right click on “RenewWinRMCertificate” file and click on “Edit” to edit it in Windows ISE. Once this is completed, go back to the Certificates and refresh the page. You’ll see there’s another entry with the VM name and a different expiration date. At this point, you can delete the old certificate. After this, go to LCS and restart your development environment. That’s it! Now you can try to rotate your certificate from LCS. And now I can finally get back to my development work! LCS might be on its way out, but for now, it’s still a big part of many businesses’ workflows.Running into deployment failures because of an expired SSL certificate was a frustrating experience, but fixing it turned out to be pretty straightforward.After checking the certificates, running Microsoft’s “Renew WinRM Certificate” script, and restarting the environment, I was able to rotate the secrets without a hitch.  If you ever find yourself in the same boat, start by checking your certificates, it’s a quick step that can save you a lot of stress! If you need further assistance or have specific questions about your ERP setup, feel free to reach out for personalized guidance. We hope you found this blog useful, and if you would like to discuss anything, you can reach out to us at transform@cloudfonts.com.

Setting up a legal entity in Dynamics 365 Finance and Operations (D365 F&O) is a crucial step for organizations managing multiple business units, subsidiaries, or operations across different regions. A legal entity represents an organization that has a registered business name, legal obligations, and transactions within the system. This guide provides a step-by-step process to create a legal entity in D365 F&O, ensuring that your business is structured properly for financial reporting, transactions, and compliance. Steps to Create a Legal Entity 3. In the Navigation Pane, go to Modules > Organization administration > Organizations > Legal entities. 4. Click New to create a new legal entity. 5. Enter Basic Legal Entity Information 6. General Fast-tab 7.  Configure Address and Contact Details Under the Contact Information tab, click Add and enter: 9. In the Statutory Reporting section, enter the legal entity’s registration numbers required for compliance. 10. In the Registration Numbers section, fill in any necessary legal details based on the country’s requirements. 11. In the Bank Account Information section, add bank accounts and routing numbers. It’s best to manage these in the Cash and Bank Management module. 12. In the Foreign Trade and Logistics section, enter the shipping details for the company. 13. In the Number Sequences section, 14. In the Dashboard Image section, you can upload or change the company’s logo or dashboard image. 15. In the Tax Registration section, enter tax registration numbers required for reporting. 16. In the Tax 1099 section, enter 1099 details (only needed for US-based companies). 17. Finally, click Save to apply the changes. To conclude, creating a legal entity in Dynamics 365 Finance and Operations is a foundational step for ensuring seamless business operations, compliance, and financial tracking. By following these structured steps, businesses can effectively manage multiple legal entities within the system. If you’re new to D365 F&O or need to discuss business needs, you can reach out to us at transform@cloudfonts.com.

Certain Companies are required to follow reducing balance method of depreciation. The reducing balance depreciation method applies a fixed percentage rate of depreciation to the asset’s net book value (the asset’s value after previous depreciation) each accounting period. This results in higher depreciation expenses during the earlier years of the asset’s useful life and gradually lower charges in later years. Within D365 F&O, this method is easy to configure through the fixed assets module, enabling organizations to automate depreciation schedules, comply with accounting standards, and maintain accurate financial records. Setting up the Reducing Balance method involves defining depreciation profiles, setting appropriate percentage rates, and aligning the method with an organization’s accounting policies. This approach supports better financial management by providing a realistic representation of asset values, aiding in decision-making processes related to asset replacement, disposal, and reporting. In D365F&O, for reducing balance method, below steps needs to be followed: 2. Select depreciation year – Calendar or fiscal. 3.Assign depreciation method to specific asset and run depreciation proposal. To conclude, this depreciation method matches higher early asset usage with higher early expenses and for fast-obsoleting assets. Industries applicable – Technology, Automotive, Retail, Aviation.The reducing balance depreciation method in D365 F&O offers a practical and flexible approach for organizations to manage asset depreciation more accurately. By applying a consistent percentage rate to the declining book value of an asset, this method aligns well with assets that lose their value more rapidly in the earlier years of use. Microsoft Dynamics 365 Finance and Operations simplifies the implementation of this method through its comprehensive fixed assets module, allowing businesses to automate calculations, ensure compliance with accounting standards, and produce reliable financial reports. We hope you found this blog useful, and if you would like to discuss anything, you can reach out to us at transform@cloudfonts.com.

In the Part 1 of this blog series, we covered the Basics of Batch and Serial Numbers wherein we covered What are they, why they are important, and how to configure them. In this part we will cover how these tracking features are used in day-to-day transactions. For a better and easy understanding, I will cover the Purchase and Sales Transactions of Items that are Serial and Batch tracked. Firstly, create a Purchase Order and Select the Item which is Batch or Serially tracked. Here I have selected the Product which is Tracked by both Batch and Serial Number. Below is the screenshot for the Purchase Order that I have created you can see that the Purchase order is currently in the Approved stage: Now let’s process the Purchase Order. For that first Confirm the Purchase Order. Then after confirmation Register the Item with a Specific Batch Number. To do that click on the Update Line option present on the Purchase Order Line. Then Click on Registration under the Process Tab. Here you can see the Order status along with the Batch and Serial Numbers. As you can see, the system has automatically generated unique serial numbers for each quantity—since I’ve taken 5 quantities, the system has generated 5 different serial numbers. This happens because the Serial number control parameter is enabled on the Tracking dimension, which enforces the system to assign a unique serial number to each individual unit. Next click on Add Registration Line then click on Confirm Registration this will confirm the registration of the Items to that of the Batch Number and Serial Numbers. This simply means that this Batch Number or Serial number belongs to this product. And this quantity of Products was received with that Batch/Serial. As you click on that you can see that the Receipt Status will be changed to Registered. Now go back and Post the Product receipt. Then post the Invoice and the Purchase Process is done. The below screenshot shows the On Hand list report after Invoicing. 2. Sales Scenario: Create a New Sales Order and select the Item that has Serial/Batch number Tracking enabled. In my case I will take the same item that I have Procured which is D0111. Now for the Sales Process add the Sales Order line then Confirm the Sales Order. As you can see, we have not yet selected the Batch number and Serial number for the item to be sold. Since these tracking dimensions are not specified, the system currently does not know which specific serial-numbered item needs to be sold. So, to do that we will go to the Line Details tab. In that we can see the Batch and Serial Number options. The next step is to Select the Batch and Serial number which needs to be sold. As per my example I’m selecting the 000450 Serial Number from the Batch 250423-000038. After this Post the Packing slip and Invoice the Sales Order. This completes the blog series. Hope this helps. In this blog, we walked through how batch and serial numbers are used in the purchase and sales processes in D365 F&O. From registering items with unique identifiers during purchase to selecting the correct batch/serial during sales, these tracking features ensure complete traceability, accuracy, and compliance. Implementing them effectively helps streamline operations, reduce errors, and improve customer confidence. Hope this blog series helped you understand the end-to-end usage of batch and serial numbers in D365 F&O! Thanks for reading!!! We hope you found this blog useful, and if you would like to discuss anything, you can reach out to us at transform@cloudfonts.com.

Event handlers in Dynamics 365 Finance and Operations (D365 F&O) allow developers to extend standard functionality without overlying customization. They help in: In this blog, we’ll explore: Types of Form Event Handlers in D365 F&O Triggered by UI interactions (form opens, button clicks, etc.) Event Type When It Fires Common Use Cases OnActivated When form loads Initial validation, default field values OnClosing Closed form Run custom logic on action OnInitialized Create new record Real-time validation OnPostRun Process completion Adding new process in flow To create event handler Step 1: Solution Explorer -> Add new class Give it proper name, so any other developer can recognized it ( Example : CustTableForm_EventHandler ) Use case: Automatically update particular field when user open particular customer details. Step 2: Get event code snippet. AOT-> Forms -> View Designer -> Events -> Copy event handler Paste all code to newly created classs. Additionally, there are separate events for methods also you can use that events to perform certain operation before that method or after that method get called. You can add your custom logic inside your event handler code snippet. In below example if current record has customer no. is equal to specific no. then it will validate particular field and update the form. Pro Tips To conclude, event handlers are powerful tools for customizing D365 F&O while maintaining upgradeability. By: You can build robust solutions that align with business needs. We hope you found this blog useful, and if you would like to discuss anything, you can reach out to us at transform@cloudfonts.com.

Indian Companies are required to maintain fixed asset records as per Companies Act and Income Tax Act, governed by Companies Act, 2013, and the Income Tax Act, 1961, respectively. While the Companies Act focuses on providing a true and fair view of an organization’s financial position for stakeholders, the Income Tax Act is concerned with determining taxable income and ensuring fair tax collection. This blog will explore the methodologies, and practical considerations for managing fixed asset depreciation under the Companies Act and the Income Tax Act, helping organizations to be compliant. This is possible by following the below steps: This functionality helps companies to maintain proper records, traceability and retrieval of records for compliance. Organizations must carefully maintain separate records and calculations to meet the distinct requirements of both laws. Aligning accounting practices with these regulatory frameworks not only helps in minimizing compliance risks but also optimizes financial planning and tax efficiency. Regular reviews and updates in line with legislative changes are critical to sustaining accurate asset management and reporting. We hope you found this blog useful, and if you would like to discuss anything, you can reach out to us at transform@cloudfonts.com.

Microsoft Dynamics 365 Finance & Operations (D365 F&O) is a powerful enterprise solution that helps businesses streamline their operations. However, troubleshooting issues in D365 F&O can be challenging if the root cause isn’t visible on a form. One of the most effective ways to diagnose problems is by connecting to the UAT (Sandbox) database and querying tables directly. This blog will walk you through: How to retrieve SQL connection details from LCS (Lifecycle Services) How to enable firewall access to allow a secure connection How to connect to the D365 UAT database using SQL Server Management Studio (SSMS) Why Connect to the UAT Database? Diagnose Issues: Querying the database allows you to inspect data and troubleshoot errors that aren’t visible in the front-end UI. Microsoft-Managed Environments: In sandbox/UAT environments, remote desktop access is restricted, making database queries essential for analysis. Test Before Deployment: Ensures that all configurations and data changes work as expected before going live. Step 1: Retrieve SQL Connection Details from LCS To connect to a D365 F&O UAT database, you must obtain SQL connection details from Lifecycle Services (LCS). Follow these steps: Go to Lifecycle Services (LCS): Select Your Project: Find the UAT Environment: Request Database Access: Find Database Connection Info: Step 2: Enable Firewall Access for Your IP Address By default, the D365 UAT database is secured behind a firewall. You must add a rule to allow access from your machine. Go to the LCS “Full Details” page for your UAT environment. Select: Maintain > Enable Access. Add a Firewall Rule: Note: The firewall rule expires after 8 hours, so you may need to re-add it later. Step 3: Connect to the UAT Database Using SQL Server Management Studio (SSMS) The best tool for connecting to the database is Microsoft SQL Server Management Studio (SSMS). Launch SSMS and Open the Connection Dialog Enter Connection Details from LCS Set Database Name in Connection Properties Click ‘Connect’ to Establish the Connection Key Takeaway Direct Access to Data: Enables in-depth troubleshooting by querying database tables directly. Secure and Controlled Access: LCS-managed firewall rules ensure data security. Easy Setup: The process takes only a few minutes to complete. By following these steps, you can quickly and efficiently connect to your D365 F&O UAT database and retrieve critical data for testing and issue resolution. We hope you found this blog useful, and if you would like to discuss anything, you can reach out to us at transform@cloudfonts.com. Need help troubleshooting your D365 environment? Let us know in the comments!

In Dynamics 365 Finance and Operations (D365 F&O), managing the lifecycle of purchase orders (POs) is important for maintaining accurate procurement, inventory, and financial records. Over time, companies may accumulate old or obsolete purchase orders that are no longer valid — whether due to supplier changes, business needs evolving, or operational delays. Cancelling these POs helps keep the system clean, improves reporting accuracy, and prevents unnecessary financial commitments. Purchase orders can have the following status & stages: Stage Status Confirmed Invoiced Rejected Received Draft Open order Approved Cancelled In review   Finalized   From Finance & Accounts point of view, Open PO means commitments to order and contingent financial liabilities. Rationale behind cancelling of old Pos: Cancelling old or unordered POs ensures that your records are up to date and reflective of actual business needs, which is important for financial planning, reporting, and auditing. Companies can streamline their procurement processes by maintaining only those Purchase Orders which are active and required as per current business needs. This was an issue faced by one of our Client in Oil and Gas industries which was resolved by using the below method. Stage Status Finalized Invoiced   Received Closing of Purchase orders: Purchase Orders can be closed only if all the items contained in the Purchase order are invoiced and the delivery is completed. Cancelling of Purchase orders: Purchase orders having In principle, in the above cases, PO is no longer required, and requirements are not fulfilled though the particular PO. Hence, it is justified to cancel the PO and not close it. Stage Status Confirmed Open order Rejected   Draft   Approved   In review   Click on Cancel quantity. In case of approved & draft purchase orders. Deactivate the workflow and continue the same process. We can delete the purchase orders which are in draft, however, then it would not be traceable in the system and the number sequences would be disrupted. By following the above process, Companies can maintain only active Purchase Orders, thereby, showing the actual committed value of an organization. Effectively cancelling old purchase orders in D365 F&O is crucial for maintaining clean procurement records, improving reporting accuracy, and ensuring better control over open financial commitments. By following systematic cancellation processes and adhering to best practices, organizations can avoid confusion, prevent overstatement of liabilities, and streamline operational workflows. Regularly reviewing and closing obsolete purchase orders not only enhances system performance but also supports better decision-making for purchasing, budgeting, and inventory management. A disciplined approach to managing old POs ultimately leads to greater efficiency, improved compliance, and stronger financial governance within D365 F&O. We hope you found this blog useful, and if you would like to discuss anything, you can reach out to us at transform@cloudfonts.com.