When AX generates forms and grids, all the lookups are populated properly, but the ID of the lookup item is displayed in the form. The only way to see values that make sense is to click on the field--not really ideal. Is there a way to display the lookup value in the form instead of the id number behind it? I would like the "tableB" f...
Hi all I had been learning ERP applications this summer during internship. As I am a programmer about to graduate, I want to have a solid software branch that would get me through till I am sure about what to do next(till I have a nice view of the big picture). Till now, I have just learned what I was asked. That's not a good way to spe...
I've written a method to handle regex validation in AX2009. Problem is that it always returns false, no matter what the expression or input string. Returns no errors, just 'false' Mind taking a look? I'm probably missing something simple. This post has been updated to included the corrected method, without the error, so you can cut ...
Hi folks, i have a function which costs plenty of time. this function is an sql-query called via odbc - not written in x++, since the functional range is insufficient. while this operation is running, I want to show an animation on a form - defined in the aviFiles-macro. trying to realize, several problems occur: the animation doesn'...
Trying to add a color picker to a field in Dynamics AX 2009. Found an article providing some very simple steps for creating the color picker as a lookup, but I can't get it to work. When creating the extended data type, the FormHelp lookup doesn't include the function SysChooseColor, but it will accept the value if manually entered. A...
Good Day, I am creating a report in AX report writer. When I create the report, it pulls all the information fine. However, when I limit the report, by select only those records with a hrmcomptype = 'Band', the report still pulls the correct data, but the fields that I am pulling from the table that houses hrmcomptype, all disappear. I ...
Is there a way to force a container to store all values as strings? I am using str2con in order to split text strings into containers. Any time a field with numbers only comes up, it is stored as an int, which isn't a huge problem. What IS a big problem is when the string of numbers exceeds the integer size and the number becomes somet...
I'm unable to find the proper syntax for referencing the CustInvoiceTrans table of the SalesInvoice report datasource. Here's the context: I've created a new classification field on the InventItemGroup table and need to get the data from this field for each item on the invoice, and then summarize this data on the header of the invoice...
The Dynamics AX 2009 Best Practice add-in is throwing the following error on a display method override. "TwC: Validate access to return value from the display/edit method." Here is my display method. display ABC_StyleName lookupModuleName(ABC_StyleSettings _ABC_StyleSettings) { ; return ABC_Styles::find(_ABC_StyleSettings.StyleID...
I am attempting to manually populate an image icon into a window nested in a grid. In the run event, the fields don't appear to have values yet. The string control always returns an empty value. Is there a better place for this code? In .NET, I'd use a databound event. Is there an equivalent in AX? void run() { FormStringContro...
When I store a RecId in an anytype object, the number is corrupted. In my implementation, I am storing the RecId in a treeview item's data value field. Whenever I retrieve the data value, the number I saved is always greatly changed. Any suggestions? Here is an example: void fillTree() { ABC_Menus _ABC_Menus; TreeItemIdx par...
I am using Axapta 3.0 with language X++. I am making a report based on available report. The new report only shows a total row by group CG Group instead of showing all detail row as old report. Exam: Available report CG Code Amount Current 1-30days 31-60days 61-180days >180days 1.1 50 10 100 30 10 5 1.1 30 20 60 35 20 ...
Hello Mr Demas, According to your answer in the previous discuss about how to show sum data by CG Group. You said that I try to write fetch() and send() method. Actually, I don’t know how to write it based on available report. Here’s the context all field in report: CG Code Amount Current 1-30days 31-60days 61-180da...
We are in the process of merging projects from different AX Servers into source control on the same AX server. However, a few object IDs are common between projects, so Dynamics throws an error when synchronizing: e.g. "BaseEnum ABC_123 can not be imported because XYZ_546 already has ID 30001" What is the best/correct way to change ...
In Dynamics AX 2009, how do you programmatically change to a different record in a form? My form contains a treeview and a group of bound data fields. When clicking on a record in the tree (the data value for each item in the tree is the RecId of the item I'd like to edit in the form) I'd like to change the form to that record. I've b...
I would like to query the Axapta AOT to find the fields of a given table and their properties. Could you please provide some code examples? thanks in advance! ...
In my other methods (data, text, etc.) the setItem method works fine to display changes made to a tree item. However, calling setItem after changing an item's icon doesn't seem to have any effect. What is the best way to update the tree item so the new icon appears? Thanks public void modified() { FormTreeItem workingItem; ; ...
hi folks, i've got an activeX component with several events. debugging this dll in .net proofs, that the events are raised and can be breakpointed ( is this a word? ;) ) registering this dll via regasm /codebase works and i can add this activeX in ax on a form. the events are listed in the activeX-explorer in ax. but it seems, that i'v...
I'm new to microsoft dynamics AX development, and i'd like to learn basic things about it. I have a virtual machine with the '09 version installed. Is it essential getting familiarized with the language (x++) from the beginning? What should I start with (tutorials, videos, overviews, guided tours) and where do I find it? I'd like links...
What is the best way to convert a utcDateTime value to a date type so I can use the global datetime functions on it? int timeDiff; date _now = systemdateget(); ; select firstOnly myUTCDateTime from _myTable timeDiff = Global::yearDiff(_now, _myTable.myUTCDateTime); info(strfmt('%1', timeDiff); Thanks ...