In one of my projects I use Excel a lot for reporting. I create the Excel documents with OpenXML and with the help of the Excel Buffer table. With the click of a button the user creates a beautiful Excel Workbook but when I open the workbook it is displayed in the back of Dynamics NAV client window....
If you are like me, located in a non-English speaking country and would like users to be able to use other tools then the Dynamics NAV clients to access the company data you will find that all the meta data … Continue reading →
I just finished creating a report that can export job ledger entries to Excel and build a Pivot Table for analysis of the data. Global dimensions and data from master, supplement and tables are included in the export. A similar … Continue reading →
In one of my recent projects I needed to calculate a geometric mean for a group of numbers. The Geometric mean formula is generally, if the numbers are , the geometric mean satisfies The problem appeared when I needed to … Continue reading →
When starting a new company the needed data is in most cases accessible for Microsoft Excel. Do we want the user to be able to import data from Excel into Dynamics NAV ? This object allows import into any table … Continue reading →