Sometimes you have to change parameter of Extended data type which are also used by AIF. For example number of decimal digits etc. When you change this settings just in Dynamics AX AOT and save it, still you will have old values in generated XSD, that...

In AX 2009 it may happen that you delete a company but data related to this company remain in the database. You can use this script to delete this data: /* * Code Sample Disclaimer: * Microsoft provides programming examples for illustration only,...

We have seen issues where the AX application files gets locked by others then the AOS process. This will cause the production  to stop, until the lock is removed. A typical application which causes the error is the Antivirus Software. Excluding the...

On a database that is upgraded from AX 4.0 to AX 2009 running on SQL 2008 you may get following error while using database log: The target table 'SYSDATABASELOG' of the DML statement cannot have any enabled triggers if the statement contains an OUTPUT...

Sometimes you need to move your existing Demand Planner database to another server. If you do this just using backup/restore, you will run into the issue while synchronizing the Demand Planner. The error you get is: Could not find ‘server name’ in sys...

If you use this code, you will get an error on the line 29. The error message is following: Cannot edit a record in Table1 (Table1). An update conflict occurred due to another user process deleting the record or changing one or more fields in the record...

When you are calling Win API function (or function from a native DLL) on x64 you get this error: An exception occurred when calling Function in Library name DLL library This happens only if the code calling the DLL function is running on server. The reason...

You can get this error message while renaming object that is checked out from TFS. Unable to import Trying to import Table MFATable_test1 with ID 50003 ID already held by Table MFATable1 To rename the object you need to follow these steps: Right click...

RTM version (5.0.593.0) of .NET Business Connect fails with following exception while creating instance of XmlDocument class in X++ code. System.Runtime.InteropServices.SEHException: External component has thrown an exception. at AxCore_CallStatic(Char...

You might need to print Word document directly from X++. Here’s a short sample how to do this: { str document = "C:\\test.doc"; COM wordApplication; COM wordDocuments; COM wordDoc; ; // Create instance of Word application wordApplication...

You may see similar error while posting ledger journal: Posting - Journal Journal: 000004_061 Voucher: 8004_062 Cannot select a record in (). The SQL database has issued an error. The journal is not posted and the update is canceled. SQL error description...

Sometimes you need to import addresses into AX 2009 and enable RecID compression. This import might result in an error: Update of RecID-key xxxxxxxx failed for the register DirPartyAddressRelationshipMapping . To solve this you need to follow these...

You may want to load an image from base64 coded string. Then there is a code sample how to achieve it. First is needed to put an "Window" controll on the form with name ex. "imageWindow" and then modify "run()" method of Form. String then could be loaded...

I was facing an issue that no mails were arrived while sending invoices in PDF from a batch. Sending e-mails from a client worked fine. The reason is in enabled SMTP relaying on customer's mail server and in \Classes\RunbaseReportStd\serverSendMail method...

You might need to execute an external process in a batch and you’re thinking about using WinApi::shellExecute() method. Unfortunately the whole WinApi class is set to run on client. Also the method WinApi::shellExecute() is marked as client method. That...

There is one interesing feature available in help file. You could link AX Form directly from help file. There is an example in standard AX 2009 installation. Open form Accounts receivable / Setup / Customer groups . Press F1 Open file will be opened as...

You may face a blocking issue on SQL Server each time you do any change in AOT. And you’re using database log. This is the problem. While using database log an insert trigger on SysDatabaseLog table is always dropped and recreated what is causing blocking...

In batch job is not posible to call WinAPI functions WINAPI::FindFirstFile(..) and WINAPI::FindNextFile(...) . This is limited only for code running on client. Sometimes is necesary have similar function for code running on server (or in batches). There...

Sometimes you need to use direct SQL code in your methods. The easiest way is to use Connection class. However you might run into the error “ Request for the permission of type 'SqlStatementExecutePermission' failed. ” This is because you’re using the...

While calling external web service from AX you might experience following error: Object 'CLRObject' could not be created This is because web services must be called from code running on server. That why you need to set the class’s RunOn property to Server...

For simple and fast testing of COM Connector you could use following VBS Script. Just copy code and paste it into file named <NAME>.vbs Dim oCom Dim sVers Dim sBuild Dim result Set oCom = CreateObject("AxaptaComConnector.Axapta3") oCom.Logon...

When you're upgrading your existing AX 3.0 SP6 environment to AX 2009 you may run into following error: Object Server 01: The database reported (session 5 (Admin)): [Microsoft][SQL Native Client][SQL Server]The specified schema name "DOMAIN\COMPUTERNAME...

There are very often discussions about the Ax upgrade regarding supported upgrade paths. The easiest upgrade will be always from Ax 3.0 SP6, but it is technically possible to go from AX 3.0 (any SP) to AX 2009, however: If the LOS layer (cost accounting...

Symptoms: All clients lose connection to the AOS Server. If the Axapta AOS or client process crashes for any reason, it is recommended to create a crash dump, of the failing process. Here are the steps to do so: Download the Microsoft debugging tools...

AX databases are by default created with the same collation as your SQL Server has. But time to time you might need the database to have different collation. Maybe you think you can just execute ALTER DATABASE statement to change database's collation...