Discussing new and innovative ways to integrate WPF and .Net into Dynamics AX<o:p></o:p>
· You cannot include table-methods into queries and as a result you need to write and implement a custom service to get hold of this information directly in Excel.
1.) You don’t need a development licence on the machine running the script.
2.) No additional objects or contracts need to be added, deloyed or compiled in the AOT.
3.) Table-method data can be returned as part of the data download. Queries cannot accommodate this.
The advantage of WCF services is type-safety, error handling, authentication and lots of flexibility. I wouldn't give it up without much better reasons.
Agreed, and I'm not giving it up, however, in some production environments you don't have a lot of flexibility to change things once they go live. I've worked for banks that code-freeze their production environment for 3 months at a time. You would not be able to implement a WCF service in this scenario, but you would be able to use my solution to get round the problem.
Other Microsoft Sites
I'm a Customer
I'm a Partner
Follow Microsoft Dynamics