Customer and Vendor Netting feature
A practical guide to customer and vendor balance netting in Dynamics 365 Finance: journal and account setup, netting agreements, manual and automatic netting, reversal, history, and intercompany netting.
AccountsReceivable
How Commission Works in Dynamics 365 Finance
Commission is used to calculate and distribute commission from a sales order to members of a commission sales group Set up Customers Customer groups for commission Sales groups Items Commission Item Group Calculation Sales groups Sales Representative Commission Calculation Commission Posting How the process works In daily use, the process is straightforward: Create the sales … Read more
Key Lessons Learned from Testing Collections Process Automation
The previous post I discussed is how to set up Collection Automation process. After spending some time testing the collections process automation setup, I ran into a few behaviors that weren’t obvious from the documentation. These notes are specific to when collection letters are configured at the customer level. 1. The number of collection letter levels … Read more
How Collection Letters Work in Dynamics 365 Finance
What Is a Collection Letter? A collection letter is a system-generated notification sent to a customer when one or more invoices have not been paid by their due date. The letter reminds the customer of: The amount owed The invoice(s) in question How overdue the payment is What makes D365’s approach powerful is the concept … Read more
Reason Codes in Dynamics 365 Finance & Operations
Reason codes help standardize why a transaction happened (write-off, adjustment, return, cancellation, etc.) and optionally provide a default comment users can keep or overwrite. Financial Reasons A hub for all Financial Reasons under Organization administration. When you set up a reason code (and its description), make sure you select the appropriate module(s). After a module … Read more
Use Github Copilot to understand what a parameter Does
A couple of weeks ago, I wrote a blog called “How GitHub Copilot Can Help a Functional Consultant in D365”, where I shared how AI can assist functional consultants in daily work, even without deep development experience. Today, I want to share another real example – how AI helped me understand a Accounts Receivable parameter … Read more
Modern Bank Reconciliation feature
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
Business performance analytics (BPA) Installation and Role Assignment
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
Account Structure cannot be deleted
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