Author: Marco Saad

• 27.11

  AX / D365FO – The str2num function and decimal numbers

• 20.11

  SQL SERVER – Server ‘xxx’ is not configured for RPC

• 16.11

  AX / D365FO – Create an excel file and send it through e- mail using X++

• 04.11

  AX / D365FO – Use macro within a SELECT statement – examples

• 04.11

  AX / D365FO – Link between Load ID and Packing slip ID

• 01.11

  AX / D365FO – Dynamic Date ranges filters examples

• 01.11

  AX / D365FO – Custom lookup on UserInfo – Want Id for form filter but display Name

• 28.10

  AX / D365FO – Error : “Cannot create a record in Entity (DMFEntity). The record already exists.”

• 26.10

  AX / D365FO – Use a primitive data type dialog field

• 20.10

  AX / D365FO – Renaming a record primary key in X++

• 20.10

  AX / D365FO – Prevent from closing Form after pressing OK button with canClose()

• 19.10

  AX / D365FO – Get Multiple selected rows from a caller Form

• 16.10

  AX / D365FO – Send simple mail in X++

• 16.10

  AX / D365FO – Get WHS Username from WHS UserId

• 13.10

  AX / D365FO – Send System Notification to a user via Action center

• 09.10

  AX / D365FO – str2date Function

• 08.10

  Microsoft Report Builder – Set the page size

• 08.10

  SQL SERVER – Get the Month Name from a Date

• 08.10

  SQL SERVER – How to get the first and last date of the current year?

• 08.10

  SSRS Chart Does Not show all Labels on Horizontal Axis

• 03.10

  AX / D365FO – List of all Base Enums language translations

• 02.10

  AX / D365FO – Substring function in X++

• 02.10

  AX / D365FO – Get Sales Order Address in X++

• 30.09

  AX / D365FO – Remove a Group By field on a QueryBuild – X++

• 28.09

  AX / D365FO – Get Form Control from its name

• 22.09

  SQL SERVER – Prevent SSRS Slow Startup

• 21.09

  SQL SERVER – How many CPUs are used?

• 18.09

  AX / D365FO – Break vs Continue actions in X++

• 15.09

  Convert Case Utility – Convert upper case to lower case, lower case to Upper…

• 15.09

  SSRS Report Builder – Change regional setting

• 15.09

  Online comma separator – Convert Column to Comma Separated List

• 13.09

  AX / D365FO – Not Exists join in X++

• 05.09

  AX / D365FO – Check null date field

• 05.09

  AX / D365FO – Copy table buffer from tables with different structure with buf2BufByName – X++

• 04.09

  AX / D365FO – Removing white spaces in the middle of the string in X++

• 04.09

  AX / D365FO – Copy data from Regular table to Temporary table in X++

• 29.08

  AX / D365FO – Running Custom X++ Scripts in Production environment without downtime

• 24.08

  AX / D365FO – How to prevent the error ‘Division by zero’

• 23.08

  AX / D365FO – Creating Query Build Range on CreatedDateTime field

• 16.08

  AX / D365FO – How to add/subtract days and months from a datetime in X++

• 15.08

  AX / D365FO – Force a Select Query to use a specific index with Index Hint

• 10.08

  SQL SERVER – Getting the second occurrence from charindex function

• 05.08

  AX / D365FO – Remove automatic links (Dynalinks) Between Forms in X++

• 03.08

  AX / D365FO – Get TableId from TableName using SQL

• 03.08

  AX / D365FO – Get number of attachments with document using X++

• 01.08

  AX / D365FO – Filter records on form using X++

• 01.08

  AX / D365FO – Create transfer order by code X++

• 29.07

  AX / D365FO – Reserve and Remove reservation for an Item in X++

• 21.07

  AX / D365FO – Check if a utcDateTime is Null in X++

• 20.07

  AX / D365FO – Create a Form button to upload images into attachments through X++

• 20.07

  AX / D365FO – Create a Form button to upload images into attachments through X++

• 15.07

  AX / D365FO – Remove reservations and markings from a sales order

• 26.06

  AX / D365FO – Get serial reservations from a sales order, sales line or sales parm line – X++

• 25.06

  AX / D365FO – Filter a form date field showing only today’s records

• 25.06

  AX / D365FO – Find latest Posted Sales Order Confirmation in X++

• 23.06

  AX / D365FO – Converting from Database time zone to User time zone

• 23.06

  AX / D365FO – How to send an email (email template, placeholders and email processing table)

• 23.06

  AX / D365FO – SysOperation framework Official documentation

• 22.06

  AX / D365FO – Force Batch Processing in SysOperationFramework class

• 17.06

  AX / D365FO – Clear SysExtension cache

• 12.06

  AX / D365FO – Get Customer name and Vendor name in X++

• 12.06

  AX / D365FO – Extracting date from CreatedDateTime

• 12.06

  AX / D365FO – Currency Amount conversion

• 12.06

  AX / D365FO – Convert Transaction currency Amount to company ledger currency

• 09.06

  AX / D365FO – Warehouse Mobile App – Add a combobox

• 04.06

  AX / D365FO – Get enum label value by Table field id

• 04.06

  AX / D365FO – Retrieve enum id from table field id

• 04.06

  AX / D365FO – Get all fields name, type, mandatory and label of any AOT table or view

• 04.06

  AX / D365FO – Get Table field value by field id

• 02.06

  SQL SERVER – Create a SQL Server Linked Server to Azure SQL Database

• 30.05

  SQL SERVER – Convert a given date from UTC to your time zone and daylight savings time

• 29.05

  AX / D365FO – Get Form COntrol label text

• 27.05

  AX / D365FO – Set up Data Entities Export recurring jobs

• 23.05

  SQL SERVER – Copy more than 65535 characters from result grid Column

• 22.05

  AX / D365FO – Change the text colour of a Form field using X++

• 22.05

  AX / D365FO – How to change font size of control labels in D365 forms

• 19.05

  AX / D365FO – Get FieldId from Field Name (String)

• 19.05

  AX / D365FO – Get tableId from Table Name (String)

• 19.05

  AX / D365FO – Adding ConfigId in SALESLINE using X++

• 17.05

  SQL Server – How to identify blocking session

• 15.05

  AX / D365FO – Insert a Yes/No Message box on a Form Click Button event

• 15.05

  AX / D365FO – How To Call A Form From Another Form

• 09.05

  AX / D365FO – Using “Not Like” in X++ select statements

• 08.05

  AX / D365FO – Create Sales order and Purchase order using X++

• 08.05

  AX / D365FO – Convert String to Real (str2num)

• 08.05

  AX / D365FO – Check if a FormControl is of type “String”, “Date” or “numeric”

• 07.05

  AX / D365FO – How To Call A Form Using X++

• 01.05

  AX / D365FO – Show “NoYes” Enum field as Combobox instead of Checkbox

• 01.05

  AX / D365FO – How to add empty ranges in query

• 30.04

  AX / D365FO : Error : Natural key was not found for a custom table during entity creation

• 30.04

  AX / D365FO – Avoid entering values that are not included in a lookup

• 28.04

  AX / D365FO – CHeck If a form String control text (FormStringCOntrol) has been modified

• 27.04

  AX / D365FO – GroupBy on Lookup problem

• 27.04

  Visual Studio 2019 Debugger Crashing When Attempting to Debug X++ Code

• 24.04

  Azure Devops – Avoid changing status of Work items after checkin

• 24.04

  Visual Studio – Enable vertical scroll bar

• 12.04

  AX/ D365FO – Delivery Schedule in Sales Line: What is the relation among splitted lines?

• 12.04

  AX / D365FO – Change User options for a list of users

• 10.04

  AX / D365FO – How To : Package creation failed. Netmodule File Missing Error in 10.0.31.

• 08.04

  AX / D365FO – Set Maximum number of local records for each grid