Stack Overflow
Stack Overflow

Questions tagged [ax]

Microsoft Dynamics AX is one of Microsoft’s Enterprise Resource Planning software products. It is part of the Microsoft Dynamics family. The early versions (from 1.0 to 3.0) were called Axapta, while the later versions (from 3.0 SP6 to AX 2012) are called Dynamics AX.

Microsoft Dynamics AX is one of Microsoft’s Enterprise Resource Planning software products. It is part of the Microsoft Dynamics family.

The early versions (from 1.0 to 3.0) were called Axapta, while the later versions (from 3.0 SP6 to AX 2012) are called Dynamics AX.

Axapta was initially released in March 1998 in the Danish and U.S. markets. Today it is available and supported in forty-five languages in most of the world.

MorphX is the IDE where development and modification is done. It resided (until Dynamics AX 2012) in the same client application that a normal day-to-day user would access, thus allowing development to take place on any instance of the client.

X++ is the development language used in Dynamics AX. It belongs to the curly brackets and dot-operator class of programming languages (like C# or Java). It is an object-oriented, class-based, single dispatch language. X++ supports garbage collection and SQL queries is integrated in the language.

See also: "Microsoft Dynamics AX" article on Wikipedia

230 questions
1
vote
3 answers

How to interpret results from the sp_spaceused command with regards to indexes

If I need to review indexes of more than 2000 tables, where do I start given the information from the sp_spaceused command? I’m investigating Indexes on tables, but am not quite sure what to make of the results for the IndexSize when I exec the…
Celeste
  • 106
  • 1
  • 13
1
vote
3 answers

avoid rounding in SalesPrice

When setting trade agreament price to 12.8888, the unit price used in Sales Line is 12.8900. what should I do to avoid this rounding?
dyax
  • 11
  • 1
1
vote
1 answer

Axapta - how to update instead of insert

I'm trying to catch an insert on a table and do update instead in some specific cases. How do i go about that? I'm trying to put this in insert method in CustTable table, but i'm not sure where to put the code. Any ideas? Thanx, Ivan
Ivan Z.
  • 23
  • 1
  • 5
1
vote
3 answers

AX report: off by one error with joined datasources

We want to build a report in Microsoft Dynamics AX 2009 to show all employees that worked on a production order. Into the datasources for this report we drag-n-dropped the ProdTable (pt) which is inner joined by ProdID and DataAreaID to…
Christian Severin
  • 1,793
  • 19
  • 38
1
vote
2 answers

Complex datasource issue in Dynamics AX

I have a grid that displays lines from a table. Now, I have these two requirements: Show only the lines that contains values in the "hour" fields. The "hour" field is an array type. Show the lines from a project and its subproject My problem is…
Thierry Roy
  • 8,452
  • 10
  • 60
  • 84
1
vote
1 answer

Retrieving the data from the fields of a table in AX 2012?

i would like to know this thing.. "if we have modified the values in the tables for ten times or something can we retrieve the values which i have inserted for the first time 2nd time and so on ..can anyone help me on this ?
phani varma
  • 11
  • 1
1
vote
1 answer

Connecting to different networks to access database information

Any suggestions would help. The issue is, I have ETL applications that need to access database information located on a different network. So one C# application needs to query a database located on a different server. Now I know the options are to…
Sirus
  • 11
  • 1
1
vote
2 answers

Is there a way to arrange the columns in the grid when the Sales order list page is loaded?

I'm stuck with an issue in the sales order Grid in Dynamics AX 2012 R2. Somehow after adding new columns to the grid via personalization, the newly added columns always shifts to the left side after closing/opening the sales order list page. Is…
michiboi
  • 65
  • 1
  • 8
1
vote
1 answer

How to synchronize database in AX using powershell script?

I'm creating a script for AX deployment from one instance to another (stage to test instance). I would want to synchronize the database using just a powershell command. Does anyone know how to synchronize the database using just a powershell command…
michiboi
  • 65
  • 1
  • 8
1
vote
1 answer

Dynamics AX 2012 RegConfig does not work

I'm currently developping a failover service for an environment using Dynamics AX and 2 mirrored SQL servers, and I have some issues getting AX to work the way I expect it to. I have developped a service which does the following : - try to connect…
Thomas KiTe Trentin
  • 600
  • 1
  • 5
  • 19
1
vote
1 answer

How does sorting work in AX 2012? particularly when using addsortfield()?

I was doing a simple sort on a table column that contains names of customer's using addsortfield() in a service class. And the result was correct but a bit strange, in the list after names starting with A** there were names starting with a special…
user1064950
  • 43
  • 5
1
vote
2 answers

check Product procurement category hierarchy

I m working with dynamics ax 2012 and i m looking for a fonction that verifie if a product is exist in the procurement category hierarchy This listepage Product Information Management -> Common -> Products -> Released Product show list of product…
Ahmed
  • 259
  • 2
  • 9
  • 26
1
vote
1 answer

Count with distinct Axapta

I want to get this query working in axapta Select Count(Distinct CUSTACCOUNT), YEARMONTH From ALT_CUSTOMERSALES As AC Where INVOICEDATE >= DateAdd(Day, -90, GetDate()) Group By YEARMONTH Where ALT_CUSTOMERSALES is a view that relates SalesTable…
Daniel Tróchez
  • 23
  • 1
  • 4
1
vote
1 answer

Axapta form input fields

Is it possible to prevent axapta from remembering entered values in a form input field so that when the user has entered one value, they do not get a highlighted proposal for what they could enter?
user3660338
  • 296
  • 5
  • 23
1
vote
2 answers

Ax2012 - get the value of accountNum in the selected row in a grid

In the form cutslistepage , i want to get the value of accountNum of the selected row in grid and passe it to another form i have try that : int64 recordsCount; recordsCount = CustTable_ds.recordsMarked().lastIndex(); // CustTable =…
Ahmed
  • 259
  • 2
  • 9
  • 26
1 2 3
…
15 16