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 SysQueryRangeUtil

View all

Posts

How to Filter a D365 F&O Data Entity by Date Range

on August 17, 2026

+

0

Get link
Facebook
X
Pinterest
Email
Other Apps

Visits

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 get current user information using x++ in D365 F&O | AX 2012

When building business logic in Microsoft Dynamics AX or Dynamics 365 for Finance and Operations, it’s often important to know who the current logged-in user is. This blog post shows a simple X++ example to fetch the current user ID and user account type at runtime. curUserId() This built-in function returns the User ID of the person currently logged into the application. class getCurrentUserInfo { /// <summary> /// this method used to get current user detail /// </summary> /// <param name = "_args">The specified arguments.</param> public static void main(Args _args) { info(strfmt("Current User - %1",curUserId())); info(strfmt("User Account Type - %1",xUserInfo::find(false,curUserId()).accountType)); } } Output will look ...

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

Powered by Blogger