Rename object in TFS

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 the object in AOT and select Rename (without checking out the…


AX 2009 .NET Business Connector fails while creating instance of XmlDocument

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* , Char* , tagVARIANT* , Int32 , tagVARIANT* ) at Microsoft.Dynamics.BusinessConnectorNet.Axapta.CallStaticClassMethod(String className, String methodName, Object[] paramList) at Microsoft.Dynamics.BusinessConnectorNet.Axapta.CallStaticClassMethod(String className, String methodName) at BusinessLogic.DocumentationManager.GetXml() in D:\Development\AX\BC.NET Sample…


HOWTO: Print Word document from X++

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 = new COM(“Word.Application”); // Get documents property wordDocuments = wordApplication.Documents(); // Open document wordDoc = wordDocuments.Open(document); // Activate the…


Error ‘Invalid object name #ax_tmp_’

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: [Microsoft][SQL Native Client][SQL Server]Invalid object name ‘#ax_tmp_dmo3_52_0’. This error is caused by collecting…


Importing addresses with RecID compression enabled

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 steps: Restore the database Disable RecID unique index on the table affected by this issue Synchronize Import data…