Hi. I have following situation: I need to join VendInvoiceJour.InvoiceAccount <- VendTable.AccountNum and take VendTable.Vendgroup. In all cases (queries,or even views) Dynamics ax joins tables VendInvoiceJour.OrderAccount<- VendTable.AccountNum not VendInvoiceJour.InvoiceAccount <- VendTable.AccountNum. I`m trying to use this kind of q...
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. ...
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? ...
== 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...
hi folks, i'm struggling with an .net activeX i try to use in ms axapta 2009. using this component on my local machine where it was compiled, it's working quite fine. it can be added as activeX element on a form, the methods and events are listed in the axapta-activeX-explorer and i can interact with it without any problems. but tryin...
How can i get fieldname and value of formdatasource field, on which focus is set. The purpose of that is to take selected field id, and depending on that id - change all field values in data source. example: if i have "bla" in name field on first record, I leave focus on that field and after button press, i want to change all record name...
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 ...
hi there, i've got a form in ax 2009, showing filtered records of a table ( about 5.000.000 records total, about 1000 shown filtered ). selecting a couple of those records in the form and deleting them via form-control ( alt+f9 ) is damn slow. one record is deleted immediately, selecting about 20 takes several minutes! there is only on...
I want to have one XPO, and have the same code work on AX4 and AX5. I am looking for a precompiler directive to check the version, sort of like: #if define AX4 thisCode(...) #else thatCode(...) #endif ...
hi, i've got a sql-query, executed against non-ax-tables ( partially at least ) from x++ via odbc. the sql-query-execution-plan suggests to add an index to the referring ax-table, eg: CREATE NONCLUSTERED INDEX [] ON [ ([field1]) INCLUDE ([several fields]) i remember it wasn't a good idea to create any of those indices via management-s...
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...
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? ...
I am working with axproxies and want to avoid clicking of ok button. its pretty simple to give a command button.ok.click(), but what is happening here is, If I move to any other box when the axproxie is running, the application gets struck. I think thats because of movement in mouse pointer. Do I have a way, where I can avoid the mouse c...
Hi, I have installed the following: .Net Framework 3.5, windows installer 3.1, IIS 7.0, ASP .NET, Microsoft DynamicsAX .NET business connector, AMO, AOS and Microsoft office share point server 2007 when trying to install Enterprise Portal and Role Center on office Sharepoint server I got a warning when the installation finished. W...
Hi, there is some forms in Dynamics AX, that i need to make them available in enterprise portal. But there's major problem, that these forms extends FormRun class. Example: journalFormTrans = new WMSJournalFormTrans(element); but there is no such thing as ELEMENT in datasets. How can i use functionality of such class in datasets? ...
hi, i have issue, how to upload files through enterprise portal? There is a gridView, where i want the upload button appear, if there's no file attached already. And there should appear a hyperlink to download a file, if there's attached a file already. What's the best way to do that. What should i put in X++ and what in .NET? The po...
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...
G'day, OK, I have now rewritten this question totally: I am trying to import data into Dynamics through the use of the Business Connector (ideally, I would be importing it directly through SQL but I understand that is not a good idea - however I am open to other suggestions). This is to import invoices from a production system into Dy...
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...
hi there, we're currently executing a stored procedure ( ms sql 2008 ) from axapta ( ax 2009 ). the sp is indeed quite large and the obfuscating effect is, that the sp doesn't work, if triggered via odbc. a simple "exec sp ..." executed via ssms works fine. if we remove some of the last queries executed in the sp, the sp also works fire...