Uninstall Business performance analytics (BPA)

Please see my previous blog for How to Install BPA Considering with Custom Report Custom report in Default Location restored after BAP App reinstalled msdyn_bpaconfig solution holds custom reports Manual refer to Custom report migration How to Uninstall Code Script Power Platform Admin Center > Environment > Developer Tool > Console // Get the current … Read more

Year-end Close in Dynamics 365 Finance

what is YEC Year-end close process involves closing the financial books for a fiscal year, ensuring all transactions are posted and summarized, and preparing the system for the new fiscal period. Configuration Main Account – Main Account Type and Openning Account Fiscal Calendars and Periods: Establish the fiscal year and its accounting periods in the … Read more

Modern Bank Reconciliation feature

bank reconciliation worksheet

What Is Modern Bank Reconciliation? Introduced in 10.0.39 (preview) and generally available in 10.0.41. Advanced Bank Reconciliation enhancement. Feature Highlights Enhanced bank reconciliation matching rules: Worksheet Enhancement: Generate customer/vendor payment journals Settle invoices without leaving the page Cancel payment journals Side-by-side bank lines and ledger lines modern look Setup & Activation Enable the feature: Go … Read more

Installation and Role Assignment

Business Performance Analytics flowchart

Overview Business performance analytics is a powerful solution designed to transform organizational data into actionable, real-time insights—all in one place Prerequisite Before installing Business Performance Analytics (BPA), ensure the following prerequisites are met: You have a Power Platform admin or Dynamics 365 admin role. Your environment is running Dynamics 365 Finance version 10.0.38 or higher. … Read more

How GitHub Copilot Can Help a Functional Consultant in D365

Today, I encountered an issue reported by one of my clients. They use bridging transactions in the Customer payment journal, and also make use of the Deposit slip functionality. However, after a recent upgrade to version .43, we noticed that the checkbox "Use a deposit slip" can no longer be selected when the Method of … Read more

ISO20022 and Electronic Reporting

ISO20022 format details

🤔ISO20022 ISO 20022 is a multi part International Standard prepared by ISO Technical Committee TC68 Financial Services. ISO20022 and Electronic Reporting configuration Message Message Set Type Direction Electronic Reporting Configuration Description CAMT.053 format Cash Management BankToCustomerStatement Inbound Camt.053 Format Bank Account Statement for Reconciliation CAMT.054 format Cash Management BankToCustomerDebitCreditNotification Inbound ISO20022 Camt.054 format Settlement Return … Read more

Asset Leasing Overview

AssetLeasing flowchart

Asset Leasing posting Accounting Standard Lease Transition Lease Classification Debit Credit US GAAP Operating Initial Recognition ROU Asset Lease Liability US GAAP Operating Interest Expense Lease Expense Lease Liability US GAAP Operating Lease Payment Lease Liability Payment Clearing US GAAP Operating Depreciation Lease Expense Depreciation US GAAP Finance Initial Recognition ROU Asset Lease Liability US … Read more

Account Structure cannot be deleted

Account Structure Error message

Symptoms: Account structure Manufacturing B/S cannot be deleted because it is in use by the general journal in ledger USMF. You must first update the general journal. Account Structure cannot be deleted because there are unposted source documents in ledger USMF Query for Source Document declare @dimensionhierarchy nvarchar (20); declare @dataareaid nvarchar (4); declare @partition … Read more

Process Over and Under delivery

Over or Under Delivery process

Related Setup Landed cost parameters Movement If the over under quantity for a delivery is within the defined tolerance, a movement journal will automatically be processed. Transfer When an under delivery is processed, the short-receipt quantity will be transferred to an under-delivery warehouse Warehouses Under Delivery Warehouse Over Delivery Purchase order with Order Qty = … Read more