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.

Financial records of a Company should show its true and fair value of its assets and liabilities. In circumstances, for value of assets to be shown correctly, they have to be depreciated as per their use. For examples, car (kms run), production machine (number of hours run). In this case, straight line or reducing balance method of depreciation is not appropriate. How to set up Consumption Depreciation in D365F&O: 2. Set up consumption units under Fixed Assets=>Setup=>Consumption depreciation=> Consumption units. 3. Set up the consumption factor, either percent or units. 4. Define the depreciation method to the specific asset. 5. Run depreciation proposal by selecting consumption depreciation proposal. This depreciation method is applicable to Manufacturing, Transportation & Logistics, Mining & Oil and Gas, Utilities & Energy, Agriculture, Printing and Publishing. This depreciation method is useful for performance-based maintenance and replacement planning. 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.

Inventory valuation is important for any manufacturing and trading business. The stakeholders would be Cost Accountants, CFOs and investors. Further, Inventory cost is the major budget element. Recently, we had a client raise the issue of cost price of inventory items not getting correctly calculated because of the following factors: Steps to be followed: 2. Go to Adjustment=>Fixed Price 3. It will show inventory transactions as per the selection criteria, with their quantity and cost price. 4. Click on Fixed Price and put the approved cost price per unit for the item variant.Click on the post button. 5. There will be a posting entry in Closing & Adjustment tab. 6. Run recalculation for the item as on the cost price date. 7. Review the Inventory Aging report or Inventory transaction report. The updated price must be reflected. 8. Recalculation can be run together after updating individual item’s cost price. 9. This must be done prior to the running inventory month close.   Conclusion : This process should be an integral part of inventory valuation. Correct inventory valuation would ensure correct cost of goods sold (COGS), gross profit (GP) and cost value of asset in Balance Sheet. 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.

Timely vendor invoice processing and vendor payments means good supplier relationships and operational efficiency. Manual processing of vendor invoice and payments involve risks of amount error, duplicate payment. Challenges:   Solution : This will allow automation for invoice processing and no scope for manual intervention for payment processing and record reconciliation. Conclusion: Apt vendor invoice management is essential in building and sustaining a company’s operational capabilities and financial balance. This translates into streamlining payment operations, avoiding expensive delays, and strengthening supplier relationships. With the rise of automation and digital solutions, managing procurement and payments has become more efficient and error-free. 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 order to operate and prosper Companies need to complete several compliances. Legal compliances are crucial as non-compliance attracts financial penalties, interest charges, and additional tax assessments. For businesses, tax compliance is crucial for maintaining a good reputation and building trust with customers, suppliers, and investors Critical Issue:   Manual data upload in GST portal for GST return filing. Generating E-Invoices and E-Way bill manually. Challenges:  Risk of errors in manual processing. Delays in data synchronization impacting compliance. Solution : Finance clear tax integration for D365 helps to manage e-way bill, e-invoicing through integration with GSP portal for GST. It automates the following : •Generate e-invoice, e-way bill. •Fetch IRN Number, QR Code & E-way bill number. •Cancel e-invoice, e-way bill. Conclusion: Ensuring tax compliance involves understanding your tax obligations, keeping accurate records, and staying informed about changes in tax laws. In addition, by enabling automation in compliances, Companies can achieve and maintain data accuracy, scalability, and enhanced reporting and real time updates. 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.

Leasing refers to a contractual arrangement where one party (the lessee) pays the other party (the lessor) for the use of an asset, such as property, vehicles, or equipment, for a specified period. Lease accounting is the process by which companies record the financial impacts of their leasing activities. It has become increasingly important due to new accounting standards that require most leases to be recognized on the balance sheet, enhancing transparency and providing a clearer picture of a company’s financial obligations. Microsoft Dynamics 365 Finance can help companies (CFOs, Finance & accounts team) to set up, operate and manage multiple lease accounting. The work around goes as listed below : 2. i. Create Lease Books: Asset Leasing =>Setup=> Lease Books ii. Define Interest as Expense Type iii. Define Lease rate of interest as Index rate type. iv. Define General Ledger mapping, number sequences and journal types in Asset leasing parameters. 3. Create New Lease in Lease Summary by giving unique Lease ID and update details in Open Books : Lease start date, Vendor Details, Lease Term 4. Run each schedule to ensure that journal entries are made for the chosen period and schedules are generated for the lease period. 5. For any modification in lease terms, termination or revaluation use the Maintain function. 6. Using the Inquiries and Reports – all lease related reports can be used to review and monitor the financial impact of leases. This way the entire lease accounting can be automated whether asset leasing is part or core business of the company. It takes care of the increasing number of leases with comfort and avoids risk of errors and miscalculations. We hope you found this article useful, and if you would like to discuss anything, you can reach out to us at transform@cloudfronts.com

Introduction In today’s business environment, Companies must adhere to various financial reporting standards. These standards are essential for fostering investor confidence, ensuring regulatory compliance, and supporting international expansion. Depending on their operational scope, some organizations are required to comply with multiple reporting frameworks, often necessitating the maintenance of multiple books of accounts. Companies need to comply with Financial Reporting Standards – IFRS, UK GAAP, US GAAP, Ind AS, Local GAAP due to reasons like: Compliance with the reporting standards is mandatory for some companies while others may follow them as best practice. There can be scenarios where a company must maintain multiple books of accounts to comply with multiple reporting standards. Example: Company listed on multiple stock exchanges like Infosys, ICICI Bank, TCS (India and US stock Exchange) must prepare financial reports as per Ind AS and as per IFRS. Microsoft Dynamics 365 Finance has the capabilities to meet the financial reporting requirements. How D365 Finance supports Financial Reporting Standards: Thereby, a company can utilize D365 Finance to maintain separate books for Financial Reporting. Conclusion Compliance with various financial reporting standards is not just a regulatory necessity but also a best practice that can enhance investor confidence and facilitate global operations. Microsoft Dynamics 365 Finance simplifies this process by enabling organizations to maintain multiple charts of accounts, set up parallel posting layers, and customize financial reports to meet different regulatory standards. By leveraging the comprehensive capabilities of D365 Finance, businesses can efficiently manage their financial reporting requirements, ensuring compliance across multiple jurisdictions and fostering transparency in their financial operations. We hope you found this article useful, and if you would like to discuss anything, you can reach out to us at transform@cloudfronts.com

How to do Inventory closing and Recalculation? In D365 Finance & Operations, inventory closing, and recalculation are essential process and recommended to be part of the month close standard operating practices. In case these practices are not followed, companies may face issues like inventory miscalculations, inconsistent inventory values in defined dimensions. Go to Inventory Management>Periodic Tasks>Closing and Adjustment. Then from the Action tabs click on Close Procedure dropdown, in that click on Close Inventory. After clicking on the Close Inventory a dialogue box will open in that select the Closing Period Code. Then under the Post-Closing you can see the Run Recalculation after Closing parameter, enable this and then click OK for Inventory Closing. Enabling this parameter will Run the Recalculation right after the Inventory Closing. After clicking OK the system will run the Closing and Recalculation Batch Job. This is how the Inventory Closing procedure takes places in D365 Finance and Operations. What happens by Inventory month close and Inventory Recalculation: – Inventory Month Close: The system generates inventory closing journals and settlement entries for the closed transactions resulting into adjustments to update inventory accounts like inventory value and cost of goods sold. It blocks the inactive dimensions from being considered into any of the valuation process. – Inventory Recalculation: The system does an inventory revaluation to adjust inventory values based on the latest costs, market values and inventory valuation method selected (FIFO, LIFO, Weighted Average, Standard Cost). By including inventory month close and revaluation as part of the month end SOPs, companies can achieve efficient inventory management. Conclusion: Inventory closing and recalculation in D365 Finance & Operations are critical processes for maintaining accurate inventory values and ensuring smooth month-end procedures. By performing these tasks regularly, businesses can prevent discrepancies, update inventory accounts effectively, and reflect true inventory costs based on the chosen valuation method. We hope you found this article useful, and if you would like to discuss anything, you can reach out to us at transform@cloudfronts.com

Introduction Accurate reporting and analysis require the consolidation of balances from various entities in complex financial environments. For this reason, Microsoft Dynamics 365 Finance and Operation provides strong tools that let businesses expedite their financial consolidation procedures. This blog will show you how to properly handle currency translation, set up elimination rules, and create a new entity for consolidation. You can make sure that your consolidated financial statements give a true and accurate picture of the financial health of your company by being aware of these procedures. To consolidate the balances of multiple entities, a new entity is created where the balances of the selected entities are consolidated and eliminated as per the requirement. In the Organization administration module>Organizations>Legal entities select Use for financial consolidation process and use for elimination process. Another part of set up is to create Elimination Rule:Create Elimination Journal by using the below screen: To run the consolidation process, navigate from the Main Menu to Consolidation -> Consolidate Online. The consolidation window opens, where the user can select the options as explained below: Go to the Legal Entities tab. Inside the legal entities, the user can select the entities to consolidate and the percentage of balances to be consolidated. Go to the Elimination tab. In the proposal options, keep the option as Proposal only. This will run the elimination of balances, but it will not post the amounts. The amounts will be posted to the ledger separately by the user. Add the elimination rule in the line. The elimination rule will eliminate balances based on 2 methods: Select the GL posting date for the date on which the elimination of the balances will be posted. Ideally this date will be the last date of the fiscal period. Go to the currency translation tab. The system will display the selected legal entities along with their base currency. At the bottom, select the exchange rate type. The exchange rate type will automatically convert the base currency of all entities to the base currency of the consolidation entity. In the above example, the exchange rate will convert INR and BRL to SGD. Note – This will work if the exchange rates are defined first. Lastly, click on OK. The system will run the consolidation process as a batch job and will provide the results in the trial balance after a few minutes. To verify the balances, open the trial balance for the fiscal period used in the consolidation. The TB will display the consolidated amounts of all entities in SGD only. For updating opening balances: General Journals to be used for updating opening balances For currency exchanges rates: Separate currency exchange rate type consolidation to used. In doing the currency translation, distinction should be made for monetary items and non-monetary items in the Balance Sheet. Normally, the latter should be part of Other Comprehensive Income (OCI). In the consolidation process, we can map different currency rate to different accounts through this screen. for Equity Method where only profit or loss has to be accounted in the consolidated entity, Journal entry has to be passed. Conclusion Maintaining financial accuracy and transparency in Finance and Operations requires successfully consolidating balances and establishing elimination rules. You can handle currency translation, properly apply elimination rules, and efficiently oversee the consolidation process by following the steps outlined in this blog. This strategy strengthens overall financial management within your company as well as the accuracy of your financial reports. We hope you found this article useful, and if you would like to discuss anything, you can reach out to us at transform@cloudfronts.com

Client Requirement: Financial Reporting Year Change from Jan-Dec to Apr-March The last financial year is January2021 to December2022. Client has the requirement to change the year to April to March. The transition year needs to be from January 2023 to March 2024. In Microsoft D365 F&O, fiscal calendar can be of 15months, however, ledger calendar cannot be more than 12 months. Solution: 1.  Ledger calendar can be shorter than 12 months. 2. We need to do two-year end close process: a. For January 2023 to December2023 – 12 months b. For January 2024 to March 2024 – 3 months 3. Client can have regular financial year from April 2024 to March 2025 onwards. We hope you found this article useful, and if you would like to discuss anything, you can reach out to us at transform@cloudfronts.com