How to Set Up Journal Names
A practical guide to the key Journal name settings in D365 Finance: journal type, voucher numbering, posting layer, detail level, sales tax, approval and access controls, and bank summarization for payment journals.
ExcelAddIn
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
Document Management Setup Guide
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
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