Dynamics NAVAX

Way back I had created an exchange rate provider using Yahoo! Finance services. So, today I thought I would share this code that has been sitting with me for a long time. I have created a Codeplex project to start the sharing. I want to also encourage others to start sharing if they have developed their own exchange rate provider using other services. I am more than happy to add anyone who wants to contribute as a developer or I can upload it for them (and mention their name on the main page). I think we can all benefit from these being freely available or if Microsoft can include it in their product eventually as standards. Visit: Exchange rate provider on Codeplex Download the Yahoo! Finance exchange provider class xpo, import it into your environment, compile + CIL compile, restart your client and start using it. Once you have done the right thing. It should be available for configuring. Then, you should be able to run it. More information to get you started: To learn on ho...

There are a number of ways of importing ledger journals but with most you will realise it is quite slow with a lot of lines (100 plus lines). I have put a couple of tips to boost the performance. Remember these are bulk creation of journals and not posting issues. That is a whole other topic. Tip 1. Obvious but often forgotten. Remember that journal name setup – you have a number of options to generate the voucher number. If you leave it to generate when it balances – then this will kill your performance. Tip 2. On the insert method you will there is tax calculations which are deleted and recalculated every time you insert. If you can avoid calling this method and call it only for the last line per unique journal number, voucher number, and invoice. I won’t go into detail on how to code it. option 1: You can add a parameter and check that. option 2: Or you can write your code so the tax is not set – do your insert. Then set the tax groups after. But remember you will have to...

This is a question I hear quite often. When you import products how do you release the product to your multiple companies. Do you have to import it? The answer is quite simple but well hidden. No – you don’t have to import to the other companies. There is a field in the staging table called ReleaseProductCompany. If you pass the company name with a separator. Then on insert or update it will release it to those companies. The separator can be found on the Source data formats. Finally here is a screenshot of the code that releases the product into the companies.

This post I will show how easy it is to use managed hosted controls (wcf). We will look at incorporating a text control with a spell checker enabled. We will work backwards, final result looks like this. Now lets go though it. Right click on your form and add a managed host. Select PresentationFramework and then the Textbox control. On the init method, enable the spell check. xpo can be downloaded from here for an example. http://goo.gl/fS2Stq

Last post I cover how the Microsoft project add-in worked. This post I will look into how it looks from a technical perspective. First thing we had to do was deploy the service, this is because the add-in uses a specific service called ProjWBSService. I created an AOT project (*ProjWBS*) to show what the components make up the service. You will notice it is a document service. What is interesting how ever is how the updates are done. The query contains a view ProjWBSActivityView. Then the update, insert, delete methods are overridden to perform a custom update. The the file is reused and file path is stamp on the Hierarchy table. So, when you try to click on the button it either creates or just opens the one it is pointing to. That is it for now.

Today I will cover on how the Microsoft project add-in works in AX 2012 R2 CU7. Setup the service To setup the service first time, go to the AOT and publish the Service group. Right click and Deploy Service Group Setup parameters Go the Project parameters fill in the Microsoft Project integration field group. In this example I will use Archived directory. Other option is SharePoint. Specify a folder – I would use a network shared path rather than your local drive. Setup the project Create a project but make sure to specify the calendar. Launch Microsoft project add-in On the Project list page, you will see a button to open in in Microsoft project. You will also see a new column called Microsoft Project – this indicates if it is linked to a Microsoft project file. When you open it in Microsoft project, you will see the Dynamics AX add-in. If you click on Add resources – you will get this dialog pop up. The Publish has a few options: Publish – It updates the linked ...

Just today, I tried setting up TFS online. This is a good blog to get started. http://blogs.msdn.com/b/axinthefield/archive/2014/02/24/efficient-dynamics-ax-application-lifecycle-management-approaches-with-team-foundation-server-in-the-cloud.aspx First, sign up with www.visualstudio.com Setup a new project. As per the blog article mentioned above. Install this. Visual Studio version Team Explorer version Required software Visual Studio 2010 Team Explorer 2010 Requires SP1 and Compat GDR . Important: Make sure to restart your AOS. Go to AX and set up your version control parameters. If you are logged in already via browser or the pop up dialog in AX, it won’t prompt for a log in. Otherwise, it will pop up with a dialog to log in.   Troubleshoot: Error 1: TF400813: Resource not available for anonymous access. Client authentication required Resolution: Install SP1 as recommended above.   Error 2: TF30064: You are not authorized to access the server. R...