Filter for Blank Values in D365 F&O OData

Filtering Blank Values in D365 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 Process

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

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

Collection Letter Process

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 Code in Dyn365FinOps

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

Clean Up Routines

Cleanup Routine

In Dynamics 365 Finance and Dynamics 365 Supply Chain Management, cleanup routines are available in various modules. This article provides an overview of the routines that are currently available. It is important to note that these cleanup routines should be only executed after detailed analysis and confirmation from the business this data is no longer … Read more

Why I Switched to Obsidian

I had been taking notes in OneNote for years, but since 5 years ago I switched to Obsidian, and it completely changed how I manage my knowledge. Here is why it beats the traditional giants. 1. Universal Format (it is a TEXT file) This is the biggest game-changer. Word or OneNote: format is .docx or … Read more