推荐订阅源

It is better we install office 2010 add-ins for AX 2012. When i try to install it through Office 2007 SP2 but failed.

1, AX2012 clients reinstall

After the clients of AX2012 was uninstalled, i tried to reinstall it but failed and reported a error:

Setup encountered an unhandled exception and could not be completed. For details see the previous messages in the log

Then checked the log, It said "Object reference not set to an instance of an object" as below.

2012-04-06 10:51:32Z  Message: Object reference not set to an instance of an object.

2012-04-06 10:51:32Z  FullText: System.NullReferenceException: Object reference not set to an instance of an object.
2012-04-06 10:51:32Z    at Microsoft.Dynamics.Setup.Components.ClientUI.GetCurrentClientConfigurationPath()
2012-04-06 10:51:32Z    at Microsoft.Dynamics.Setup.Components.ClientUI.GetClientAosServerAndPortFromRegistry()
2012-04-06 10:51:32Z    at Microsoft.Dynamics.Setup.S220ClientAosServerEntry.IsPageApplicable()
2012-04-06 10:51:32Z    at Microsoft.Dynamics.Setup.MainForm.FindNextPage(PageID oldPageID)
2012-04-06 10:51:32Z    at Microsoft.Dynamics.Setup.MainForm.mainFormButtonNext_Click(Object sender, EventArgs e)
2012-04-06 10:51:32Z    at System.Windows.Forms.Control.OnClick(EventArgs e)
2012-04-06 10:51:32Z    at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
2012-04-06 10:51:32Z    at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
2012-04-06 10:51:32Z    at System.Windows.Forms.Control.WndProc(Message& m)
2012-04-06 10:51:32Z    at System.Windows.Forms.ButtonBase.WndProc(Message& m)
2012-04-06 10:51:32Z    at System.Windows.Forms.Button.WndProc(Message& m)
2012-04-06 10:51:32Z    at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
2012-04-06 10:51:32Z    at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

It seems that the client can't find AOS instance but not sure. I tried many times and the issue still existed.

Then i try to install an AOS instance with the client (client, addins, remote), the process can be completed. At the end, the client was installed and it can access original AOS.

2, In Office 2010, office add-ins can be installed for AX2012 successfully.

Then open Excel2010, it has a tab named Dynamics AX on the head of Excel 2010.

Connection button: show which company and AOS information you log on; if you can't connect to the server, please check regedit:

HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Office\Excel\Addins\Microsoft.Dynamics.AX.Framework.OfficeAddin.Excel->Manifest's data change to  

file:///C:/Program Files (x86)\Microsoft Dynamics AX\60\OfficeAddins\Microsoft.Dynamics.AX.Framework.OfficeAddin.Excel.vsto|vstolocal

Add data/Add table button, you can select AX2012 tables to Excel. If you select one table, it will drag a default group field Excel.

  You can drag others tables which it has a flag similar as * to the right area.

Refresh Current button to display the table data in Excel from AX2012.