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

Passing Financial Dimension combination values in ax 2012

I need to pass Ledger Dimension value for General Journal (Table:LedgerJournalTable) form to LedgerJournalTransDaily(Table:LedgerJournalTrns) form along with combination values. EX: In General Journal form I am creating a new journal with the…
Hari.V94
  • 23
  • 1
  • 6
2
votes
1 answer

Convert byte array to pdf

I am generating a .pdf file in an asp.net/c# enviroment. Then I convert the file to byte[] and send it to Dynamics AX. Is there a way to convert the byte[] back to .pdf and save it as DocuRef.
Bullface
  • 39
  • 1
  • 9
2
votes
2 answers

Data from Multiple Data Sources in One Column in Grid

I've been thrown quite the scenario today. Essentially, I have one table (ProjTransPosting) that houses records, and that table relates to a number of similarly structured tables (ProjCostTrans, ProjRevenueTrans, etc). They relate by TransId, but…
codemann8
  • 372
  • 7
  • 29
2
votes
2 answers

Select Statement Vs Find in Ax

while writing code we can either use select statement or select field list or find method on table for fetching the records. I wonder which of the statement helps in better performance
2
votes
2 answers

DynamicsAX - Get SQL Statement by tablename

I'd like to create a class in AX2012 which I can call from Ax2012 Business Connector that allows me to generate the SQL statement for a specified table. The method I implemented at the class is: client server public static str getTableStatement(str…
kamahl
  • 931
  • 1
  • 8
  • 20
2
votes
1 answer

Add a Relation foreign key in AX2012

I have to create 2 new tables: EmployerTypeTable and ListDocTable ------------------- ------------------ -EmployerTypeTable- - ListDocTable - …
Ahmed
  • 259
  • 2
  • 9
  • 26
2
votes
1 answer

Outer joins with where condition x++

I am trying to write a query that retrieves an item based on ItemId or item barcode. This is using x++, Dynamics AX 2012 R2 select firstOnly * from inventTable where (inventTable.ItemId == _upc || inventItemBarcode.itemBarCode == _upc) outer join…
Danielg
  • 2,669
  • 1
  • 22
  • 17
2
votes
2 answers

Dynamics AX 2012 R3: Penny Difference on invoice voucher

I have create an invoice with invoice amount = 96.63 Purchase order: create with one line with amount = 72.24 (with TAX 20%) Header charges on Purchase order = 5.96 (with TAX 20%) In the invoice register when I select the purchase order and put the…
Danish
  • 21
  • 1
  • 3
2
votes
3 answers

Avoiding inserting duplicate data into table in MS Dynamics AX

I have a custom table that I'm inserting data into. I do not want duplicate data to end up there, so I created a unique index consisting of 20ish fields that I wish to be unique. As expected, when I run my job to insert data it of course fails and…
codemann8
  • 372
  • 7
  • 29
2
votes
2 answers

Exploding BOM through recursive CTE

I'm trying to explode the BOM through recursive CTE, but I'm still getting the anchor rows only. However, I'm trying to use this SQL code: With BOMTree_CTE AS ( --Anchor Select B.BOMID ,B.ITEMID…
2
votes
1 answer

How to open a form with the selected record?

Let's say I want to open the vendor form in job/code. I coded a very simple select statement that I later want to use to open the vendor form for that specific vendor. How can I achieve this? VendTable vend; MenuFunction menuFunction; Args args =…
Tassisto
  • 9,877
  • 28
  • 100
  • 157
2
votes
2 answers

Call webservice with NTLM authorization

We need to call a webservice in PHP using NTLM authorization, if I understand it correctly we need to use something like NTLMSoapClient, but I do not know how to call it excactly. This is the WSDL
PhDJ
  • 173
  • 1
  • 4
  • 15
2
votes
2 answers

Print Sales Quotation report to PDF AX 2009

I am currently on AX 2009 SP1 Rollup 7. I am attempting to create a PDF when my method is ran sending a quotation Id from the CustQuotationJour table to the SalesQuotation report. The method works OK, but the report is sent to the Print Preview…
AX_Dev
  • 69
  • 1
  • 4
  • 11
2
votes
1 answer

How can you scan an image with X++

Does anyone know how to scan an image with X++?
Johan Bresler
  • 6,450
  • 11
  • 56
  • 77
2
votes
2 answers

Decompress a GZip Stream in Dynamics AX X++

I'm attempting to deflate a .NET GZIPStream in X++ but I'm running into a bug. The .NET code to create the string is pretty simple: private string CompressString() { string stringToCompress = "Some data here"; string result…
Spankachu
  • 167
  • 2
  • 11
1 2
3
15 16