Skip to main content

Posts

Showing hidden fields in the table browser

A request for the possibility of showing the contents of hidden fields in Ax tables, using the table browser, made me do a google search, to avoid reinventing the wheel. Sure enough Vilmos Kintera had adressed the problem earlier on http://daxrunbase.blogspot.dk/2010/04/non-visible-fields-in-table-browser.html. And he has done good work. :) Keep it up Vilmos. Running the customized table browser seemed to work fine in AX 2009, however I ran into issues using it in AX 2012. I tested the customized table browser on the table CustTrans, which was the table I first found to contain hidden fields and I got a run-time error. Investigating the problem I found that the reason in seemed to run fine on AX 2009 (using CustTrans table) but failed in AX 2012 on the same table, was due to a small issue that Vilmos hadn't adressed, namely Extended Data Types defined as Arrays. The .ds datasource on the SysTableBrowser form had it's active method customized to populate the new lower grid,
Yes I know it's small chance of ever winning, but if you don't play you have no chance of winning. Firebrand Training is giving you the chance to win free training for a life time, and who wouldn't want that as a price. :) Please click Firebrand Training to enter the competetion your self.

Fixed assets DAX 2012: Missing value models in lookup

Having trouble with missing value models in lookup in Fixed Assets module. Try running the class AssetRebuildTables The EDT AssetBookMergeId defines either a value model or a depreciation book. This EDT is related to a table called AssetBookMergeLookup. I experienced that this table had been "corrupted", so that one of the value models were not available in the lookup. I ran the AssetRebuildTables class from the AOT, and voila. The table was rebuilt for me.

Dynamics AX 2012 Excel Add-in document services and queries with missing relatios

While working on an assignment where I among other things had to prepare a new query for use with document services and the Excel add-in. The query consisted of three nested data sources, where two was standard tables and the third was a new table which I had added to the system. First version worked just fine. I exposed the query through document services and I could get data in Excel. The for some reason I decided to change the relations on the table I had added, for reasons that I forget. However suddenly my query was not showing up in the pick list, when I using the "Dynamics AX" / Add Data button i Excel. The reason ? I had messed up the relation from my new table to the standard table, making the relation empty. The Excel add-in reacts by simply not showing the now invalid query in the list, but it does not warn you that something is wrong. I got a clue to this, by trying to use "Add table" instead going directly for my new table. Then Excel add
Just needed to save some code I have been working on in my blog. This code is used for basically deconstructing ledger dimensions and default dimensions to be able to merge / overwrite dimension attribute values in the ledger dimension. My scenario is that during the processing of a ledger allocation, I have an "original" transaction that is being allocated. My destination transaction (the transaction that allocates the original transaction to a new ledger dimension) will inherit all the ledger dimensions of the original transaction BUT will have some of it's dimension attribute values overwritten, by a default dimension set up on the ledger allocation rule destination. Basically I deconstruct the ledger dimension of the original transaction and put all the found dimensions into a map. I the deconstruct the default dimension of the ledger allocation rule destination, and find the matching entries in my map, to replace them. When my "merged" map is comp

Mental note to self: AIF changes -> Incremental CIL build.

After using a couple of hours trying to understand why my newly created AIF-service was not doing exactly was it was supposed to do, I found the solution. My AIF service uses a new table to accept some value from an external system. When a record is introduced into this table, a new ledger journal with a ledger journal line is created, and the voucher the line gets in the journal line, is updated onto my new table. This to allow for making it possible to use customized code in an AIF service, without having to make changes to the table methods of the Generel ledger journal tables and without risking custmized code made in the Service classes being overwritten by a service wizard update of the service. I had completed and activated my service, and was testing it. Then I discovered that I had forgotten to call the code to create the ledger journal, on my new table's insert-method, therefor I got records in my table, but no ledger journal. So I quickly inserted the call to t