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

Document Management Setup Guide

Document Management configuration

Document management in Dynamics 365 Finance allows users to attach, store, and manage documents (files, images, URLs, notes, etc.) directly on business records such as invoices, journals, and master data. The setup is straightforward and mainly involves three areas: Activating the feature Defining document types Configuring document management parameters Activate Document Management (User-Level Setting) User … Read more

Fixed Asset Data Migration

Fixed Asset Data Migration

Description: Migrate Fixed Asset Data from Legacy system. Cut off Date = 4/1/2024 Journal cannot be posted into previous month / previous fiscal year Acquisition and Accumulated Depreciation (Fixed Asset History) should not impact current Trial Balance Details Configuration Fixed assets parameters Fixed asset posting profiles Books: Service Life Depreciation profiles: Depreciation Method Fixed Asset … Read more