Microsoft Dynamics AX 2012 R3 is an Enterprise Resource Planning (ERP) application. Use this tag for questions relating to this final update to the 2012 version, being replaced by Microsoft Dynamics AX 7. Do not use this tag regarding earlier versions or other ERP applications.
Questions tagged [dynamics-ax-2012-r3]
229 questions
2
votes
2 answers
Declare array of strings
I was trying to declare an array of strings like so:
str ar1[2] = ['One','Two'];
Getting a syntax error. How can I initialize and assign an array like above?

Mohammad Yusuf
- 16,554
- 10
- 50
- 78
2
votes
0 answers
POST XML file in AX2012 using HttpWebRequest
I need to call an API which accepts a POST request taking as parameter a single XML file. I've tried calling the resource via Postman (with form-data content type) and seems to work correctly. When trying to implement this in AX I get an error 500…

nikdzl
- 21
- 4
2
votes
1 answer
How to create Query using IN?
I need to collect data and add it to temporary table in AX 2012 R3 using X++.
This is the Query on SQL
select store, receiptid, itemid, str(qty,16,0) as Qty, str(price,16,0) as Price, str(DISCAMOUNT,16,0) DiscAmount, str(taxamount,16,0)…

julius
- 75
- 11
2
votes
1 answer
How to upload client file to server?
I need to create form to upload file from client side to server in AX 2012 R3 using X++.
Can some one give me link / example regarding this issue?
I try to search and find that I can use class SysFileStoreManager, but still confused how to use it.

julius
- 75
- 11
2
votes
1 answer
Procedure performance. SQL Server, Dynamics AX 2012 R3 CU10
We runnning this code from our ERP application Dynamics AX 2012 R3 CU10, which is part of the upgrade process from AX 4.
ttsbegin;
while select forupdate salesLine
where salesLine.RemainSalesFinancial != 0
&&…

Jack Casas
- 914
- 18
- 37
2
votes
1 answer
What are the allowed Modes in Dynamics AX TextIO Class?
The MSDN Page at https://msdn.microsoft.com/en-us/library/textio.new.aspx
just states "Specify one the following: " but the following list is missing.

MetalSnake
- 277
- 3
- 14
2
votes
1 answer
More detailed error from runbuf function in Dynamics AX
I try to build some kind of X++ script executor and therefore play around with the runbuf function.
It works as long as the X++ code I pass in is valid, but when I pass invalid code then it just throws an error that it is not able to compile the…

NoaHammer
- 322
- 2
- 9
2
votes
1 answer
I want to Split string Using Computed column in views AX2012
I am using Computed columns in views. I have a string stored in one column of a table. I want to split that string using Computed Columns.
eg.
ColumnA = 0001^93.2
Resullt:
ColumnB = 0001
ColumnC = 93.2
Thanks

shabib raza
- 73
- 1
- 5
2
votes
1 answer
What database does Commerce Runtime make use of?
I have a storemanager dashboard which makes use of Microsoft Dynamics AX database. To avoid writing a lot of code, I plan on using CRT (commerce runtime) which would give me some form of abstraction and also saves my time writing a lot of code by…

codemania23
- 913
- 11
- 19
2
votes
2 answers
Change width of a lookup column
I've created a lookup with two columns, first one containing and integer which works just fine but the second one has a long name and this is where the problem arises. Users should horizontally scroll in order to check the entire string and even in…

Olaru Mircea
- 2,570
- 26
- 49
2
votes
1 answer
The best place to add some logic after form init and executeQuery
I got an answer on one of my questions here on SO regarding where to place some code after the form initialization.
Event Method Sequences when a Form is Opened
As far as I see, init and run are executing on thread 1 while executeQuery goes on…

Olaru Mircea
- 2,570
- 26
- 49
2
votes
3 answers
Strings paddings and alignments
I have tried today to save a file using TextIo. Just 3 lines:
Radio Station;MagicFM
Test;This is jost for testing purpose.
TV;TV_Brand
All good but then i read it.
I am not able to align the the things.
Maybe something like:
Radio Station …

Olaru Mircea
- 2,570
- 26
- 49
2
votes
2 answers
Only foreign key constraints are allowed on this table AX 2012
I have created three fields in a table: Country, State and City.
I have given EDT as LogisticsAddressCountryRegionId for Country, LogisticsAddressStateId for State. The relations are
MyTable.Country = LogisticsAddressCountry.CountryRegionId.
I am…

Raas
- 261
- 8
- 25
1
vote
0 answers
Xamarin.Forms consume AX2012 R3 Webservice error
I just started working on xamarin not long ago.
Now I met a problem on Xamarin consuming AX2012 Webservice.
I’m in a project that need an android device connect with AX2012 R3 Inbound port.
I made a very simple webservice like below and tested…

CFSR
- 11
- 1
1
vote
1 answer
Count of group by statement AX2012 R3
I want to count group by statement values and write control.
There is a table which have 3 fields; ItemId, TaxGroup and TaxItemGroup. Same itemId must have same taxgroup and taxItemGroup values. If lines which have same ItemId have different tax…

Mumble
- 141
- 1
- 8