Using the step-by-step recipe , and basing on our first example , I have build another example One-Page for the following requirements: Customer Spending by Period: Display the total amount for each period (type, i.e. day, week, month, quarter, year, accounting period) what each of our customers has in order. In this case the design of our matrix would be: matrix cells displaying the total amount horizontal dimension being the periods vertical dimension being our customers …

Using the step-by-step recipe I have build an example One-Page matrix based on the following requirements: Customer/Item Spending: Display the total amount for each item what each of our customers has in order. Basically this line already reveals the design of our matrix: Display the total amount ... -> matrix cells for each item what ... -> horizontal dimension each of our customers has in order -> vertical dimension To be able to build the matrix I need to do some preparation…

Last week I conducted a NAV Development update to the development team of a Dutch NAV partner. One of the topics we touched was the One-Page Matrix introduced in NAV 2009 SP1. The What's New in Microsoft Dynamics NAV 2009 Service Pack 1 - Installation and Development manual contains a lab that lets you build a One-Page matrix, but the end result is not complete and the overview ( what am I doing exactly? ) is a bit missing. Therefor I decided to try my best and make up some kind of step-by-step…

Some useful resources to study and use when naming objects in NAV, whether it be tables, fields, variables or whatever other object: Microsoft Dynamics® NAV 2009 Developer and IT Pro Documentation : Naming Conventions discusses the naming of: Tables objects Form and Page objects Report objects Table fields Form buttons and menu items Codeunit objects Variables User-defined functions Form controls Microsoft Dynamics® NAV 2009 C-SIDE Introduction : Chapter 2…

With joy I want to share with you the news that I am awarded 2012 Microsoft® MVP. Thankful as, though not changing my live, it sure brought me 'things' I wouldn't have come across otherwise.