Skip to main content

What are the Inbuilt Methods or Functions Available in Ax 2012

Following  Inbuilt Methods or Functions Available in Ax 2012.

SrNo
Method/Functions
SrNo
Method/Functions
1
abs
51
enumStr
2
acos
52
evalBuf
3
any2date
53
exp
4
any2enum
54
exp10
5
any2guid
55
extendedTypeNum
6
any2int
56
extendedTypeStr
7
any2int64
57
fieldId2name
8
any2real
58
fieldId2pname
9
any2str
59
fieldName2id
10
asin
60
fieldNum
11
atan
61
fieldPName
12
attributeStr
62
fieldStr
13
beep
63
formattedStr2num
14
char2num
64
formControlStr
15
classIdGet
65
formStr
16
classNum
66
frac
17
classStr
67
funcName
18
conDel
68
fv
19
configurationKeyNum
69
getcurrentpartition
20
configurationKeyStr
70
getcurrentpartitionrecid
21
conFind
71
getPrefix
22
conIns
72
guid2str
23
conLen
73
identifierStr
24
conNull
74
idg
25
conPeek
75
indexId2name
26
conPoke
76
indexName2id
27
corrFlagGet
77
indexNum
28
corrFlagSet
78
indexStr
29
cos
79
int2str
30
cosh
80
int642str
31
cTerm
81
intvMax
32
curext
82
intvName
33
curUserId
83
intvNo
34
datasetStr
84
intvNorm
35
date2num
85
licenseCodeNum
36
date2str
86
licenseCodeStr
37
datetime2str
87
literalStr
38
dayName
88
log10
39
dayOfMth
89
logn
40
dayOfWk
90
match
41
dayOfYr
91
max
42
ddb
92
maxDate
43
decRound
93
maxInt
44
dg
94
menuitemActionStr
45
dimOf
95
menuitemDisplayStr
46
endmth
96
menuitemOutputStr
47
enum2str
97
menuStr
48
enumCnt
98
methodStr
49
enumLiteralStr
99
min
50
enumNum
100
minInt

SrNo
Method/Functions
SrNo
Method/Functions
SrNo
Method/Functions
101
mkDate
151
strDel
211
webSiteTempStr
102
mthName
152
strFind
212
webStaticFileStr
103
mthOfYr
153
strFmt
213
webUrlItemStr
104
newGuid
154
strIns
214
webWebpartStr
105
nextMth
155
strKeep
215
wkOfYr
106
nextQtr
156
strLen
216
workFlowApprovalStr
107
nextYr
157
strLine
217
workFlowCategoryStr
108
num2char
158
strLTrim
218
workFlowTaskStr
109
num2date
159
strLwr
219
workFlowTypeStr
110
num2str
160
strNFind
220
year
111
perspectiveNum
161
strPoke


112
perspectiveStr
162
strPrompt


113
pmt
163
strRem


114
power
164
strRep


115
prevMth
165
strRTrim


116
prevQtr
166
strScan


117
prevYr
167
strUpr


118
prmisDefault
168
subStr


119
pt
169
syd


120
pv
170
systemDateGet


121
queryDataSourceStr
171
systemDateSet


122
queryStr
172
tableCollectionStr


123
rate
173
tableFieldgroupStr


124
refPrintAll
174
tableId2name


125
reportStr
175
tableId2pname


126
resourceStr
176
tableMethodStr


127
round
177
tableName2id


128
runAs
178
tableNum


129
runBuf
179
tablePName


130
securityKeyNum
180
tableStaticMethodStr


131
securityKeyStr
181
tableStr


132
sessionId
182
tan


133
setPrefix
183
tanh


134
sin
184
term


135
sinh
185
time2str


136
sleep
186
timeNow


137
sln
187
today


138
ssrsReportStr
188
trunc


139
staticMethodStr
189
typeOf


140
str2Date
190
uint2str


141
str2datetime
191
varStr


142
str2enum
192
webActionItemStr


143
str2guid
193
webDisplayContentItemStr


144
str2int
194
webFormStr


145
str2int64
195
webletItemStr


146
str2num
196
webMenuStr


147
str2time
197
webOutputContentItemStr


148
strAlpha
198
webPagedefStr


149
strCmp
199
webReportStr


150
strColSeq
200
webSiteDefStr




Popular posts from this blog

Code to get customer Primary Address in Ax 2012

Below Code to get customer Primary Address in Ax 2012. CustTable custTable_P; DirPartyTable dirPartyTable_P; DirPartyLocation dirPartyLocation_P; DirPartyLocationRole dirPartyLocationRole_P; LogisticsLocation logisticsLocation_P; LogisticsLocationRole logisticsLocationRole_P; LogisticsPostalAddress logisticsPostalAddress_P; LogisticsPostalAddress primaryAddress_P; while select custTable_P where custTable_P.AccountNum =='ED_01029' join dirPartyTable_P where dirPartyTable_P.RecId == custTable_P.Party join dirPartyLocation_P where dirPartyLocation_P.Party == custTable_P.Party && dirPartyLocation_P.IsPrimary==NoYes::Yes join dirPartyLocationRole_P where dirPartyLocationRole_P.PartyLocation == dirPartyLocation_P.RecId join logisticsLocationRole_P where logisticsLocationRole_P.RecId == dirPartyLocationRole...

Table lists which can have large number of records in Ax 2012

If you are facing database or application performance issue then you can check these tables that may have large number of records. ECORESPRODUCTVARIANTDIMENSIONVALUE INVENTBATCH ECORESPRODUCTMASTERDIMENSIONVALUE ECORESPRODUCTMASTERDIMENSIONVALUE ECORESPRODUCT ECORESPRODUCTTRANSLATION ECORESPRODUCT ECORESPRODUCTVARIANTDIMENSIONVALUE INVENTDIMCOMBINATION ECORESRELEASESESSIONPRODUCT ECORESRELEASEPRODUCTLEGALENTITY INVENTSUMLOGTTS INVENTCOSTLISTPARM GENERALJOURNALACCOUNTENTRY GENERALJOURNALACCOUNTENTRYZAKAT_SA SMMTRANSLOG LEDGERENTRYJOURNALIZING DIMENSIONFOCUSBALANCE MARKUPTRANS INVENTTRANSPOSTING INVENTREPORTDIMHISTORY SALESPARMLINE SOURCEDOCUMENTLINE INVENTTRANS TRANSACTIONLOG INVENTTRANSORIGIN INVENTSETTLEMENT SALESPARMSUBTABLE SALESPARMTABLE SOURCEDOCUMENTHEADER SALESPARMUPDATE SQLSYNCINFO GENERALJOURNALENTRY SUBLEDGERVOUCHERGENERALJOURNALENTRY CUSTSETTLEMENT SMMACTIVITYPARENTLINKTABLE INVENTSUMDATETRANS LEDGERTRANSSTATEMENTTMP DIMENSIONFOCUSLE...

Code to get Invoice settlement data for customer in ax 2012

This is simple Code to get Invoice settlement amount data for customer payment in ax 2012. This data is after posting of data. select sum(SettleAmountCur) from custSettlement where custSettlement.TransRecId == custtrans.RecId If you want get settlement amount before posting than you can refer spectrans table.The table SpecTrans contains all the transactions marked for settlement for payment journal. while select spectrans join custtransopen join custtrans where spectrans.SpecCompany == ledgerjournaltrans.DataAreaId && spectrans.SpecTableId == ledgerjournaltrans.TableId && spectrans.SpecRecId == ledgerjournaltrans.RecId && spectrans.RefCompany == custtranssopen.DataAreaId && spectrans.RefTableId == custtranssopen.TableId && spectrans.RefRecId == custtranssopen.RecId && custtransopen.RefRecId == custtrans.RecId && custtransopen.AccountNum == custtrans.AccountNum { info...