X++ Function Categories and their Functions

Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012

This topic lists every X++ built-in function by category.

Descriptions of Categories

The following table lists only the categories of X++ functions. Each category is described. These categories help people to understand the many functions, but the categories do not represent any formal construct in Microsoft Dynamics AX.

Category

Description

Business

Functions that input financial data and calculate formulas.

Compiler Verified

(also named Intrinsic)

Functions that have their input value verified by the compiler. If the input value is not found to match any existing object in the Application Object Tree (AOT), the compiler issues an error.

The inputs to these functions must be literals, because the compiler cannot determine the value that a variable contains at run time.

Container

Functions that operate on the container data type of X++.

Convert

Functions that translate data of one type into data of another type.

Date

Functions that operate on the date data type.

Enum

Functions that operate on enum objects.

Math

Functions that perform mathematical calculations.

Miscellaneous

Functions that do not belong to any specific category.

Reflection

Functions that access the metadata about objects and return other metadata about them.

Session

Functions that change or report on the context of the current user connection.

String

Functions that operate on the str data type.

Categorization of X++ Functions

The following table lists the X++ functions that belong in each previous category.

Category

X++ function

Business

  • cTerm

  • ddb

  • dg

  • fv

  • idg

  • intvMax

  • intvName

  • intvNo

  • intvNorm

  • pmt

  • pt

  • pv

  • rate

  • sln

  • syd

  • term

Compiler Verified

(also named Intrinsic)

  • attributeStr

  • classNum

  • classStr

  • configurationKeyNum

  • configurationKeyStr

  • datasetStr

  • enumNum

  • enumStr

  • evalBuf

  • extendedTypeNum

  • extendedTypeStr

  • fieldNum

  • fieldPName

  • fieldStr

  • formControlStr

  • formStr

  • identifierstr

  • indexNum

  • indexStr

  • licenseCodeNum

  • licenseCodeStr

  • literalStr

  • menuItemActionStr

  • menuItemDisplayStr

  • menuItemOutputStr

  • menuStr

  • methodStr

  • perspectiveNum

  • perspectiveStr

  • queryDataSourceStr

  • queryStr

  • reportStr

  • resourceStr

  • runBuf

  • securityKeyNum

  • securityKeyStr

  • ssrsReportStr

  • staticMethodStr

  • tableCollectionStr

  • tableFieldGroupStr

  • tableMethodStr

  • tableNum

  • tablePName

  • tableStaticMethodStr

  • tableStr

  • varStr

  • webActionItemStr

  • webDisplayContentItemStr

  • webFormStr

  • webletItemStr

  • webMenuStr

  • webOutputContentItemStr

  • webPageDefStr

  • webReportStr

  • webSiteDefStr

  • webSiteTempStr

  • webStaticFileStr

  • webUrlItemStr

  • webWebpartStr

  • workflowApprovalStr

  • workflowCategoryStr

  • workflowTaskStr

  • workflowTemplateStr

Container

  • conDel

  • conFind

  • conIns

  • conLen

  • conNull

  • conPeek

  • conPoke

Convert

  • any2Enum

  • any2Date

  • any2Guid

  • any2Int

  • any2Int64

  • any2Real

  • any2Str

  • char2Num

  • Date2Num

  • Date2Str

  • Datetime2Str

  • formattedStr2Num

  • guid2Str

  • int2Str

  • int642Str

  • num2Char

  • num2Date

  • num2Str

  • str2Enum

  • str2Date

  • str2Datetime

  • str2Guid

  • str2Int

  • str2Int64

  • str2Num

  • str2Time

  • time2Str

  • uint2Str

Date

  • dayName

  • dayOfMth

  • dayOfWk

  • dayOfYr

  • endMth

  • maxDate

  • mkDate

  • mthName

  • mthOfYr

  • nextMth

  • nextQtr

  • nextYr

  • prevMth

  • prevQtr

  • prevYr

  • timeNow

  • today

  • wkOfYr

  • year

Enum

  • enum2Str

  • enumCnt

Math

  • abs

  • acos

  • asin

  • atan

  • corrFlagGet

  • corrFlagSet

  • cos

  • cosh

  • decRound

  • exp

  • exp10

  • frac

  • log10

  • logN

  • power

  • round

  • sin

  • sinh

  • tan

  • tanh

  • trunc

Miscellaneous

  • beep

  • classIdGet

  • dimOf

  • getPrefix

  • max

  • maxInt

  • min

  • minInt

  • newGuid

  • setPrefix

  • sleep

  • systemDateget

  • systemDateset

Reflection

  • fieldId2Name

  • fieldId2PName

  • fieldName2Id

  • indexId2Name

  • indexName2Id

  • refPrintAll

  • tableId2Name

  • tableId2PName

  • tableName2Id

  • typeOf

Session

  • curExt

  • curUserId

  • getCurrentPartition

  • getCurrentPartitionRecId

  • SessionId

  • funcName

  • prmIsDefault

  • runAs

String

  • match

  • strAlpha

  • strCmp

  • strColSeq

  • strDel

  • strFind

  • strFmt

  • strIns

  • strKeep

  • strLen

  • strLine

  • strLTrim

  • strLwr

  • strNFind

  • strPoke

  • strPrompt

  • strRem

  • strRep

  • strRTrim

  • strScan

  • strUpr

  • subStr

See also

X++ Functions

Functions

Intrinsic Functions

Announcements: New book: "Inside Microsoft Dynamics AX 2012 R3" now available. Get your copy at the MS Press Store.