I am currently busy designing and writing an upgraded payroll system for Dynamics NAV 2009. The solution is based on an older version that has been on the market for over ten years. The new design should be intuitive to use and be capable to handle all types of payroll calculation.
Image being able to send your staff an Excel document and get it returned with data for your General Journal. Data from outside sources are usually available in Excel. By using this batch, you can import that data into NAV General Journal.
Clicking on the “Create Template” button will start Excel with a document template.
On each cell in the header line there is an comment that helps with the data format.
Here is a zip file with the source code needed.
The Job Queue granule (3,810) in version 5.0 and later can be used to automate tasks by starting Nav Application Server with the parameter JOBQUEUE. Everyting that Job Queue starts is started with a record in the table Job Queue Entry. However, there are built in batches, like report 795, Adjust Cost – Item Entries, that Job Queue can start with some help. Here is a Report that I use to start built in batches from Job Queue.
Here is a zip file with the code needed.
This is a presentation where I use the Skyrr BI Solution as a basis of an OLAP Cube. The presentation is in my native language, Icelandic.
The following is my slides from my lecture at Skyrr Conference in my native language.
Skyrr Conference was held at the Hilton Hotel in Reykjavik last Friday. I was a speaker and my topic was a small Dynamics NAV solution that I wrote to create views in SQL for tables in order to simplify access to the database. The views include field names in native language and both Boolean and Option fields are displayed as text fields with the current option caption as the value. More on that solution later along with my slides from the lecture.