Microsoft Dynamics 365 FO

A technical blog dedicated to Microsoft Dynamics AX and Dynamics 365 Finance & Operations, sharing practical solutions from real-time project experience. It includes X++ code examples, common issue resolutions, debugging approaches and troubleshooting tips to help developers handle day-to-day challenges effectively.

Search This Blog

Home
About Us
Contact Us

Showing posts with the label Computed column in Data entity

View all

Posts

How to Add a Computed Column in a Data Entity in D365 FO using x++

on February 23, 2026

Get link
Facebook
X
Pinterest
Email
Other Apps

Posts

Create ledger journals in D365FO using X++

While working on Dynamics 365 Finance & Operations, there are many situations where we need to create ledger journals through X++ code instead of entering them manually from the UI. This usually comes up when data is coming from an external system, a staging table, or when we want to automate accounting entries. In this post, I’m sharing a simple approach I used to create ledger journals and journal lines programmatically using X++. High-Level Approach The process is straightforward: Create the journal header Initialize LedgerJournalEngine Create journal lines Set account, dimensions, debit/credit Insert the records Step 1: Create Journal Header // Header creation ledgerJournalTable.JournalNum = NumberSeq::newGetNum(LedgerParameters::numRefJournalNum()).num(); ledgerJournalTable.initFromLedgerJournalName(ledgerJournalTrans_Buffer.JournalName); ledgerJournalTable.insert(); ledgerJournalEngine = LedgerJournalEngine::construct(ledgerJournalTable.JournalType); ledg...

Useful DateTimeUtil Methods in D365 FO X++ (Dynamics AX / Dynamics 365 Finance & Operations)

Working with date and time is a very common requirement when developing solutions in Dynamics AX and Dynamics 365 Finance & Operations. Whether it’s handling batch jobs, logging execution time, applying business rules based on dates or converting values across time zones, date-time handling needs to be done carefully. In X++ DateTimeUtil plays a key role in managing all date and time–related operations. It provides several built-in methods to convert dates, handle UTCDateTime values and work with user or system time zones in a reliable way. During my development work, I have frequently used the following DateTimeUtil methods. I have collected them here as a quick reference that can help developers understand and use date-time operations more effectively in Dynamics AX / D365 FO. Below is a list of commonly used DateTimeUtil methods with examples that you can use in your day-to-day X++ development. // Get Past date time DateTimeUtil::addDays(DateTimeUtil::utcNow(), -1); // Convert D...

How to Add a Computed Column in a Data Entity in D365 FO using x++

In Dynamics 365 Finance and Operations, data entities often require fields that aren't directly mapped to a physical database table. These are known as unmapped fields, and they come in two flavors: Virtual Fields and Computed Columns While both serve unique purposes, computed columns are generally preferred for read operations because they are calculated at the SQL Server level, whereas virtual fields are calculated row-by-row in X++ In this post, we will walk through the steps to create a computed column using X++ 1. Create an Unmapped Field • Open your Data Entity in the Visual Studio designer. • Right-click the Fields node and select New > String Unmapped Field (or the data type appropriate for your needs) 2. Configure the Properties In the Properties pane for your new field, set the following: • Is Computed Field: Set this to Yes. • DataEntityView Method: Enter the name of the X++ method you are about to create 3. Write the Method You must now create a static method...

Labels

AX 2012
AX Development
Batch
call runbasebatch using x++
Call sysOperation using x++
cancel sales line
Chain of Command
Computed column in Data entity
Computed column in View
Context class

Convert Date to DateTime in x++
Convert DateTime to Date in x++
CostCenter
Create form in D365 F&O
CrossCompany
current user using x++
Custom report to print management
Custom Services
Customization
D365 Developer Tips
D365 Development
D365 F&O
D365 FO
D365FO
D365FO Development
Data Contract
Data Entities
Data entity error
DateTimeUtil
Default Dimension
Dynamics 365
Dynamics 365 F&O
Dynamics 365 Finance & Operations
Dynamics 365 Finance and Operations
Exist Join X++
Export Model
F&O
Financial Dimensions
Form extension class
Form Lookup
General Ledger
Hide parameters in report dialog in D365 FO
Import Model
Inner Join X++
Joins in Dynamics AX
JSON API
Ledger Dimension
Ledger Journal
LedgerDimensionValueSet
Lookup
Methods to table
Print Management
Query Ranges
Sales Order
Select Statement X++
SysOperation
SysOperation Framework
SysOperationDisplayOrderAttribute
SysQueryRangeUtil
table extension class D365 FO
Web Services
X++
X++ Code Example
X++ Development
X++ Join
X++ new features
X++ Programming
X++ Query

Show more Show less