Filter for Blank Values in D365 F&O OData

A simple question came up recently: which vendors in our environment have no primary address? In SQL this is a five-second job SELECT vendtable WHERE ADDRESSLOCATIONID IS NULL Through the D365 Finance & Operations OData endpoint, it turned into a small investigation. The short version: the OData $filter in F&O cannot express "this field is … Read more

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

Archive Solution Overview

Dynamics 365 Finance and operations apps support custom retention policies for securely archiving and retaining unlimited data for the long term in a cost-efficient way. How it works pre-setup Security Role System administrator in FinOps System Administrator and System Customizer in Power Platform Admin Project owner or Environment manager in Lifecycle Services Install Dynamics 365 … Read more