Monday, January 27, 2014

Editing a Cheque SSRS report

Changing Cheque_US design

I recently worked on a project where I had to change the design of the standard US check.

Changing the design was relatively simple.  Run Visual Studio, find the Cheque_US in the SSRS Reports group, right click it and hit edit.  I was able to make all of my changes fairly easily.

The problem that I ran into was that if I wanted to see my changes I had to deploy the report, go to a Payment Journal, add a line in that payment journal and then finally generate a payment.  That was a lot of work to simply see how my changes affected the design.

A friend of mine helped me find a much simpler solution.  Go to Cash and bank management -> Common -> Bank Accounts and select the Set up tab.  In the Layout section, select Check and you will see the Check layout form.

There is a button at the top called 'Print Test' which will allow you to quickly see any changes you have made.  Just be sure to change the 'Check form' option to the U.S. format.

Wednesday, January 15, 2014

Form Datasource Active Record

If you have a form with DataSource MyDatasource, you can access the 'current' or active record in that datasource by simply typing MyDatasource.  .  You can then access all the fields in that record.  This came in very handy in a project I was working on.  

Tuesday, January 14, 2014

Book Recommendation

Microsoft Dynamics AX 2012 Cookbook

This is a GREAT book for beginners.  Step by step instructions along with with excellent "recipes" on how everything works.  The "recipe" is really what makes the difference for me.  A lot of books don't bother to explain each step.


Monday, January 13, 2014

What is a table buffer?

This probably seems like a very simple topic, however, that is what we are about here!  I was thinking about this yesterday and wondered what a table buffer REALLY is!  

CustTable custTable;

Declaring a table buffer is relatively simple and straightforward.  We can also populate that table buffer with all the records in CustTable by doing the following:

select custTable;

We now have all the CustTable records in our custTable buffer.  It is important to note that until you perform this step, custTable has NOTHING in it.  You must select records into the buffer to be able to work with them.  
Once selected, you could have more than 1 record, however, only 1 of the records will be the 'active' record in the buffer.  That means when you go to retrieve and/or set information in the record, it will be from the 'active' record.

activeRecordAccount = custTable.AccountNum;
custTable.Account = 123456;

It's important to make sure you have working with the record you want before you change it.

In summary, what is a table buffer?  I'm not sure I have an exact definition of what it is, however, a co-worker gave me the following definition:

"A class that points to a selection of records with up to one 'active' record at a time."

I think this summarizes it pretty well!  Feel free to comment or criticize!



My name is Brad and I have been programming for about 4 years.  I started working with Dynamics AX a little over 6 months ago.

I have decided to start this blog based on the lack of information out there for beginners in this industry.  I hope to be able to pass along some of my experiences, tips, tricks, and any other useful information. Hopefully this can help those who find themselves in the same position as I found myself not too long ago!