Questions tagged [dynamics-ax-2012-r3]

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.

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 &&…
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.
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…
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…
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 …
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…
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…
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
1
2
3
15 16