Is there an injection safe way to call via the axpata business connector string salesId = someObject.Text; IAxaptaRecord salesLine = ax.CreateRecord("SalesLine"); salesLine.ExecuteStmt("select * from %1 where %1.SalesId == '" + salesId + "'"); If someObject.Text is set to the following, i am then vulnerable to x++ code injection: "S...
Corrected Tax has coding support in the LedgerJournalEngine but this functionality is not available for invoicing update via the Purchase Order Screens. The scenario is as follows: On the invoicing screen of the Purchase Orders I want to add a field for corrected tax per invoice line. Corrected Tax must override the default tax calcu...
Is it possible to install AX 4.0 SP2 on SQL Server 2008 and Windows Server 2008 ...
We are trying to interpret the data stored in Axapata's TIMEZONESRULESDATA table. Particularly, we'd like to figure out how it stores DST begin/end times. So far, my guess is: TZENUM: foreign key referencing TIMEZONESLIST (time zone name and identifier) YEAR: 0 if rule is valid indefinitely or a year where the timezone rule is in effect...
I need to switch off certain some batch jobs when DAX has been restarted. How can I accomplish this? Note from Author: This is most likely a X++ programming question and not configurable. ...
Want to create web sites with data on Dynamics AX. We want not to pay for Enterpise Portal or SHarepoint an do our own web app on top of AX. ...
I have form with VendTable grid for example, which has CustAccount field. I want to place button, click on which will open CustTable form where all customers are visible. If I just put CustTable menuitem, then clicking on it will open CustTable form, but in this form only one record is displayed - one that has the same AccountNum as in...
Currently only the Table Id can be used which is meaningless as it is a number. A little bit of code example would really be great. ...
Using this code I can not create a connection using IIS 7 with Windows Authentication. try { Axapta axapta = new Axapta(); axapta.Logon("", "", "", ""); //Or this> axapta.Logon("COMPANY", "NL-nl", "OBJECTSERVER", ""); System.Diagnostics.Debug.WriteLine("yep"); a...
hi there, if you create a new dataset, mandatory fields which are not set yet are marked with a wiggly red line. it seems, that only string-values ( or several fields, but at least no integers ) are marked this way. if integer-references are used ( 1-based ), the regarding fields are filled with 0 per default which causes the red lin...
In Microsoft Dynamics AX, how do I get a list of methods on a table from C#? ...
I have been trying: to load an image into a window control with a datamethod that loads the file into a bitmap, returning a bitmap. This makes Axapta Crash. When doing the same but returning an image does not do anything. using the "active" method on the data source has some success if I set the "imagename" to the filename and the auto...
So, I've started with programming Microsoft Dynamics AX 2009, created a little own sample app in my dev-System, and now I want to install this on my test-system, which is running on some other comp. My problem: I got no idea how to create an installer, or even how to install my AX extension by hand. No clue at all. So, how would I inst...
I've created a custom lookup form in Axapta 3.0 in which a user can select an OprId from a ProdRoute datasource. Before displaying the lookup the ProdId is set and may not be altered by the user. The user may only select an OprId from the ProdRoute of the production order with the valid ProdId. According to documentation, one can prevent...
Hi, A client is having some trouble printing a standard report in Axapta 3.0 SP3. The report finishes gathering data, and everything is fine. But when the program is trying to print it to screen it starts an endless loop. Down in the bottom left on the status bar it says "Page 1, Section: xxxxx" where xxxxx counts from 1 to 65536 and st...
Using a 'clicked' override on a button, I'd like to modify values in an Axapta form. I'm able to get data from the form field using: str strOld = Form_FieldName.valueStr(); I'm able to prepend text to the field using: Form_FieldName.pasteText(strNew); I can't seem to find a .clear method or .value= method. I'd like to replace...
I would like to query the AOT to see if a table name exists using X++. Can anyone point me in the right direction or provide some sample code for doing that? If table exists with the name (str tableName) provided, return true; else, return false. Thanks ...
In most cases, validation methods I've overridden execute twice each time the parent field is changed. Everything still works, but the InfoLog displays double messages every time. Is there any way to prevent this? Thanks public boolean validate() { boolean ret; int exlowValue; int lowValue; int highValue; int exhi...
I managed to find an old Axapta version to practice some programming and learn Axapta a little. The problem is I can't get it started. I had installed SP1-2-3 and started it, it is supposed to create the database. Well it creates some tables then I get a syntax error from SQL Server. I am told even SP1 was enough for SQL 2005. The error ...
I've found several posts and articles around the net talking about validating form fields in dialogs, but none of the examples I've found seem to work properly. Can someone post a complete, concise example of x++ code that generates a dialog containing a single text field, performs simple validation (if text = "abc") on it, and either c...