dynamics-ax-2009

Creating Tables and Retrieving Query results with Dynamics AX 2009 business connector

I'm writing a C# command line tool to fetch data from AX and to add data (create new tables) to AX. Fetching data from an AX table is easy and documented here: http://msdn.microsoft.com/en-us/library/cc197126.aspx Adding data to an existing table is also easy: http://msdn.microsoft.com/en-us/library/aa868997.aspx But I cannot figure o...

Dynamics AX 2009 Visual Studio Template Files

Where online can I download the Visual Studio template files for Microsoft Dynamics AX 2009? ...

Dynamics AX 2009 - Modify insert into smmActivities from ProjTableWizard?

I am an AX newbie, and I need to make a modification to the ProjTableWizard form code and have not been able to locate where I need to make the change. Essentially what I need to do is modify the part of the Wizard process when creating a sub-project. I need to figure out how a line is inserted into the smmActivities table, so that I can...

Field types in Dynamics Ax

Is it possible to store binary information in a Dynamics field? For example, I'd like to store an MS Word document inside the Dynamics database. ...

How do I create my own custom Roles for Reporting against SSAS and associate it with a role in Dynamics AX?

Dynamics AX comes with 25 predefined roles in the Default Analysis Database. How do I create my own and associate this new Role with a Role within Dynamics AX? I know the create Role wizard in SQL Server Management Studio, but I don't know how to tie my customer userprofile to Roles in my Analysis Database. ...

In Dynamics AX, using the Business Connector, how do you call kernel functions?

I would like to know how to call kernel functions from AX using C# (.Net Business Connector). Specifically, can you call methods like fieldName2Id, tableName2Id and curUserId? ...

Cannot select a record in User Information (UserInfo). User ID: , . Dynamics Ax 2009

== UPDATED :) ========= ! SEEMS LIKE ANOTHER 2100 LIMIT ! PLEASE HELP ! Here's some update of what we've found : I've written a simple job : server static void testEs(Args _args) { UserInfo t; ; select t; } When I run it as admin, there's no problem. When I remove my admin privilege and run it again, I still got that...

Dynamics AX 2009 .NET Business connector

HI, I want to know how to create a new item record using a template in Dynamics AX 2009 .NET Business connector. I know how to do this using Dynamics AX 2009. Is there a static method that i can call? I also want to show the new item information to the user before saving it. Is this possible? Please help Thanks ...

Dynamics AX Enterprise Portal Expense Management Screen Manipulation

I'm trying to maninpulate the Expense Management page. See the screenshot below. Click on the down arrows will expand that section to see data regarding the entry. What I want to have is by default when the screen loads to have all the expanded sections open by default. I have tried to mess with with Javascript/jQuery to accomplish t...

TFS Build for Dynamics AX?

I have never used TFS build. My application is an Microsoft ERP - Dynamics AX. I need to create a TFS build action that compile and import my code into a Dynamics AX environment. Is this possible? If so, can you point to some code or tutorials showing how to accomplish this in TFS' build system? ...

Cannot find a defined variable

I'm really new to Dynamix AX 2009. I was browsing the demo image from Microsoft to better understand how the application works. I checked a random method called updateRFIDTagging() in the form SalesQuotationTable Now this last block of code really confuse me: salesQuotationLine_ds.object(fieldnum(SalesQuotationLine, ItemTagging)).skip...

Complex datasource issue in Dynamics AX

I have a grid that displays lines from a table. Now, I have these two requirements: Show only the lines that contains values in the "hour" fields. The "hour" field is an array type. Show the lines from a project and its subproject My problem is this: to meet requirement #1, I need to use a select statement in my datasource since I ca...

Is there a way to "embed" a form in another form

I have a form and I want to embed it in another form. I want to keep both form, but I would prefer to avoid duplicating the first form. Is there a way to "attach" a form to a tab page for example? ...

AX report: off by one error with joined datasources

We want to build a report in Microsoft Dynamics AX 2009 to show all employees that worked on a production order. Into the datasources for this report we drag-n-dropped the ProdTable (pt) which is inner joined by ProdID and DataAreaID to the ProdJournalRoute (pjr) which is inner joined by EmplID and DataAreaID to the EmplTable (et) where...

Dynamics Ax 2009, New Vendor Approval Workflow

We are trying to add an Approval Workflow for new Vendors created in Dynamics Ax. But I have no clue how to go about implementing this. I managed to create a workflow using this Workflow for Dummies Wizard But it seems that it only starts after the Vendor record is created, and we need it to prevent the record from being used before...