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
1
vote
1 answer
Controlling records with the same field value AX 2012
I have a table which name PaymentLines and i want to control dueDate field of records which have same InvoiceId value. If there is a different dueDate value, info -> Records with the same InvoiceId value cannot have different dueDate values
How can…
Mumble
- 141
- 1
- 8
1
vote
1 answer
Go to different main table from same field AX 2012
I have a InvoiceAccount field in table. And another field in this table is PackingSlipAXType. If PackingSlipAXType is Sales, InvoiceAccount field value is customer account. If type is PurchReturn, InvoiceAccount field value is vendor account.
When…
Mumble
- 141
- 1
- 8
1
vote
2 answers
let just one selection in query addRange AX2012
i wrote a query as follows and i want to block multiple selection for accountnum in query.
Is there any way for to do this in code ?
Query = new Query();
qbdsVendTransOpen = Query.addDataSource(tableNum(VendTransOpen));
qbdsVendTrans =…
Mumble
- 141
- 1
- 8
1
vote
4 answers
KB-Hotfix installation error in Microsoft Dynamics AX 2012
I am trying to install some KBs on AX but an error is occurring.
I checked the user's privileges and everything is OK
Log:
=== Setup logging started: 06/05/2020 17:56:03 === Running file:…
8biT
- 135
- 1
- 8
1
vote
1 answer
Mark checkbox in all companies AX2012
I added a checkbox in PurchParameters table which name is setExchRateVal and I want to mark true this field in my all companies without sql operations.
How can i do this in AX with job?
I tried this but it's not done,
PurchParameters…
Mumble
- 141
- 1
- 8
1
vote
1 answer
Dynamics AX String Operations on E-mail format
I have a str like this;
"B S ; J T ; A M "
and i want to return to this format;
"b.s@msoft.com, j.t@msoft.com, a.m@msoft.com"
how i can do this?
str mail, a, mnew;
int b, c;
List strlist = new…
Mumble
- 141
- 1
- 8
1
vote
1 answer
X++ assign Enum Value to a table column
I am trying to pull the Enum chosen from a dialog and assign the label to a table's column.
For example: Dialog opens and allows you to choose from:
Surface
OutOfSpec
Other
These are 0,1,2 respectively.
The user chooses OutOfSpec (the label for…
Mike
- 1,853
- 3
- 45
- 75
1
vote
0 answers
Cannot select a record in Global address book addresses by NON SysAdm user
Opening a Home/Common/Global address book Global address book form I get this error
Cannot create a record in Global address book (DirPartyTable). Party
ID: ******, ***. The record already exists.
With my user (is not sysADM) I'm NOT able to…
ulisses
- 1,549
- 3
- 37
- 85
1
vote
0 answers
How to sync table from AOT of MS Dynamic AX to Microsoft SQL Server 2014 Express
I set up Microsoft SQL Server 2014 Express on my Computer And I want to sync (copy) data from some table inside AOT of Microsoft Dynamic AX 2012 -R3. Do you have any idea to connect them and copy data ?
ELIP
- 311
- 6
- 19
1
vote
0 answers
In which Table errors and warnings are stored in AX 2012 r3
I want to know the tables where the Standard errors and warnings are stored in Microsoft Dynamics Ax 2012 R3.
Chandan Choudhary
- 31
- 1
- 7
1
vote
1 answer
Derived table in AOT data dictionary table not reflecting in SQL Server database table
Reading upon this documentation about AOT tables:
"Tables store business data. Each table in the AOT has a corresponding table in the underlying Microsoft SQL Server…
rickyProgrammer
- 1,177
- 4
- 27
- 63
1
vote
1 answer
AX 2012 Group by with common table
How to group by a common table with a specific field?
I'm getting a syntax error on (dt.fieldname2Id('BatchNo'))
Here's my code:
Common common;
SysDictTable dt;
dt = SysDictTable::newName('Table1');
common = …
Mohammad Yusuf
- 16,554
- 10
- 50
- 78
1
vote
1 answer
Probleme controlling financial dimensions in purchase requisition line detail
I am trying to have some control over the financial dimension fields in the purchase requisition line detail, I need to auto get the CostCenter value depending on the Fixed Asset selected, I have the relation stored on the fixed asset value models…
YOUSFI Mohamed Walid
- 570
- 4
- 14
1
vote
1 answer
Update table using only variables
I have a table EmpTable like so:
If I want to update the salary of John I can do it like so:
static void UpdateSal(Args _args)
{
EmpTable EmpTable;
real sal=110000;
int RowId = 1;
ttsBegin;
select forUpdate EmpTable where…
Mohammad Yusuf
- 16,554
- 10
- 50
- 78
1
vote
2 answers
Integrate Microsoft AX dynamics 2012 r3 in web app
I develop an ERP software using PHP. Now I want to integrate Microsoft AX dynamics 2012 r3 in my app as per client need. Since I am a PHP developer I am confused on how to get started. On exploring, I came to know that the best way to integrate it…
Mohammed Abdul kadhir
- 141
- 1
- 5
- 15