Tech Tipp for Consultants: Speed up reports

Tech Tipp for Consultants: Speed up reports

Your users complain that performance is really bad when the first report is created in the morning?

  • Ask the administrators whether the “Warmup SSRS Reports” batch job is scheduled to run every morning (before the first user typically logs in). You can also check yourself for that batch job, if you have access to System Administration > Inquiries > Batch Jobs > Batch Jobs. Look for an entry similar to the following – it will probably be scheduled to run once a day, early in the morning. Read more

EMEA Convergence 2015 and “AX7” – my personal summary

Here’s what I tell AX colleagues about EMEA Convergence 2015 or better: What I tell them about “AX7” – I leave out the happy hour 😉

User Experience

  • The new HTML5 client has a very clean, modern look. All the colorful action pane icons that were new in (AX2009 and) AX2012 are gone again.
  • We see a “responsive design”: When you resize the window (manually, or use it on a device with a different scale), the control are reorganized nicely.
  • All in all, the rendering / building of the forms seems to be a lot “calmer” than before. No flickering, no superfluous repaints.
  • Dynalink / “follow-me” functionality is still available: From a list of records (former list page), you can still open a second (third etc.) related form whose content follows the record selection on the main list.
  • Dialogs that open from a form, will “slide in” from the right side and cover a bit of the main form: This would be, f.ex. the dimension / offset dimension form on a general ledger journal, the dialog for posting a journal etc.
  • One AX HTML client session can only have one main window! If you need, for example,  the list of relevant purchase orders, the planned purchase orders and the invent table and stock on hand, you’ll open three AX sessions. Important to note: Microsoft is going to limit the number of sessions a user can open!

Read more

What’s the content of the DAT Company in AX2012

Someone asked me today what the DAT Company in AX2012 is needed for.

If you Google, you’ll read that it contains “Setup data”, but I think that’s not really true. What could that Setup data be?

  • Company dependant functional setup, like CustGroup, SalesParameters, is stored in that specific company, so that can’t be it.
  • Company independant setup, like SystemParameters, NumberSequenceTable, EcoResAttributeType, is stored without a “dataAreaId” column, so that cannot be it.

No, I think this has to be phrased differently: Read more

When (before) starting to develop in AX2012

AX2012 has been around for some time now, but there are still many installations running on previous versions. Switching to AX2012 is not terribly hard, but it has some surprises for you. Therefore, I thought I’d start a collection of things you should be aware of and consider when (before) starting your first AX2012 implementation, that are not mentioned in the whitepapers and training materiel I’ve seen so far.

Read more

Currency Value Fields: “AmountCur”

Currency Value Fields: “AmountCur”

If an AX table field directly uses the Extended Data Type (EDT) AmountCur or an EDT that derives from AmountCur, the field’s property sheet shows several additional entries, when compared to other fields of type real.

I couldn’t find any documentation on this in the Internet or the AX2012 development book, so I thought I’d try and find out from AX where these properties are used and what they are used for.

Read more

Dynamics AX SSRS Reports: Page total and carry over

Dynamics AX SSRS Reports: Page total and carry over

An AX consultant told me that their developer colleagues say that it’s not possible in an AX2012 SSRS printout to

  • create a page total in the page footer
  • and carry over that total to the top of the subsequent page.

I thought I’d accept the challenge and give it a try … This post will Show one possible solution, using the collection letter as an example. Maybe it can help somebody else, too.

Read more

Dynamics AX 2012: DIXF Import of Ledger Journals

The Import / Export Framework of Dynamics AX 2012 is an extremely powerful tool. But sometimes you still need to look very closely to figure out why something goes wrong … and how to fix it.

Recently, two colleagues of mine both told me that you cannot import financial dimensions into a ledger journal for bank accounts, customer accounts etc. (basically all account types but ledger). Since I had tried out just that, I started investigating – and the solution is very straightforward.

Read more