Stack Overflow
Stack Overflow

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
0
votes
1 answer

Dynamics Ax How to Add Filter to Grid

I have a form/grid that contain 2 different datasource I added StringEdit To form StringEdit's EDT is a field From datasource1 I want to add filter to Datasource2 records according to Stringedit there is relations between tables select…
yalcinpkr
  • 15
  • 4
0
votes
1 answer

Use cacheAddMethod for methods of datasource AX2012

There is a form have two display methods. So form load is so slowly. I searched and found this way; public void init() { super(); MyTable_DS.cacheAddMethod(tableMethodStr(MyTable, dispCreditBalance)); } but my display methods not in table…
Mumble
  • 141
  • 1
  • 8
0
votes
1 answer

Saving data to different tables from a single form in Dynamics AX

How can we allow a Dynamics AX form to allow saving data on the grid to two independent tables: When I click on +New it always adds the row to the first grid. We are looking for a way to add row independently for each grid on this form.
Sourav Kumar
  • 11
  • 1
  • 3
0
votes
1 answer

choose record which have max value of createdDateTime ax2012

I'm writing a select statement, I want to choose record which createdDateTime value is nearest. For example I want to choose second line, because it has max value. How can i add this condition in my select statement?
Mumble
  • 141
  • 1
  • 8
0
votes
1 answer

How to Join a data source using a `Like` `LEFT`

I first created a SQL query and now I'm converting it into an AOT query in AX 2012 R3. I have everything else working except for one thing. I have a join in my SQL that is: JOIN dbo.INVENTJOURNALTABLE AS INV3 ON INV.INVENTBATCHID LIKE…
Mike
  • 1,853
  • 3
  • 45
  • 75
0
votes
1 answer

Infolog in Visual Studio

I am working on Dynamics AX 2012 r3, and I am debugging a batch job using Visual Studio 2013. In the Dynamics AX debugger, I can see the infolog messages in the infolog panel. Is there a similar panel or way to view infolog messages when debugging…
2ps
  • 15,099
  • 2
  • 27
  • 47
0
votes
1 answer

SQL WHERE clause perfromance issue AX2012R3

I am trying to optimize a query. Note that I am using Microsoft Dynamics AX and traced this query to SQL. The query except for the index hints is being generated by Dynamics and I am wondering if I have to rewrite the whole statement in AX or if I…
Jeffrey Saelen
  • 23
  • 7
0
votes
1 answer

How to get data from AOT of MS Dynamic AX by Excel

I can get data by function of MS Excel on table of database of Microsoft SQL Server However I do not know how to get data from AOT of Dynamic Ax 2012-R3 the same by Excel Here is the AOT of MS Dynamic Ax It's really hard to us.I'm looking for…
ELIP
  • 311
  • 6
  • 19
0
votes
0 answers

Any easy way to check usage of published services?

In a given AX 2012 R3 production running system, is there an easy way to analyse usage of ax services from external systems? AX store access logs in some place? A similar information that you can get for example analizing IIS logs. Like who calls,…
Eduard
  • 664
  • 2
  • 14
  • 26
0
votes
2 answers

How to fetch data from Archive database

i'm working with Dynamics ax 2012 and I've archived data with IDMF Is there any way to show both of live data and archived data in Ax Grids , best regards
masoud
  • 456
  • 3
  • 12
0
votes
2 answers

Reading user's information in Active Directory from Dynamics AX using specific domain controller

We have a few domain controllers that can be used to read AD users information. When domain name "mydomain.co.uk" is being used as AD domain, any of those few domain controllers are being picked to serve the purpose. However, if changes in AD…
Donatas
  • 317
  • 1
  • 5
  • 18
0
votes
1 answer

Automatically printing SSRS report on both sides of page in AX 2012

I am automatically printing an SSRS report after users perform an action and it works great. However, I would like it to print 2 sided. Is this possible? I can't find anything online or in the documentation of the SRSPrintDestinationSettings…
joel
  • 156
  • 6
0
votes
1 answer

Copy notes functionality in ax2012 r3

I want to replicate/extent the "Copy notes" functionality from Sales Order to Purchase Order (to copy vendor notes to a purchase order). But I didn't find the code for standard functionality (I want to start debug from "Copy notes" checkbox…
viuser
  • 7
  • 1
0
votes
1 answer

Migrate reporting services to new server (just services not database)

I have a database cluster of 2 nodes (eg IPs. 110, 120). I have evicted 110 node and now only 120 is active. Reporting services are hosted on 110. Now I have installed reporting services on 120 as well. I want to change the Reporting service URL in…
Mohammad Yusuf
  • 16,554
  • 10
  • 50
  • 78
0
votes
1 answer

DMF and Advanced accounting structure

I have 10 dimensions in standard accounting structure and 7 dimensions defined in advanced rule. Importing journals through DMF in excel throws error for 17 dimensions but works with 10 dimensions. What's the right way to resolve this?
Mohammad Yusuf
  • 16,554
  • 10
  • 50
  • 78
1 2 3
…
15 16