Dynamics NAV

There are 35 entries for the tag Dynamics NAV
iNAV step 1

I’ve to admit that working with Visual Studio is more and more productive that working on iOS, but despite the difficulties my iNAV “free time” project has reached the first step. Actually my Dynamics NAV iPhone client permits you the access to your sales and purchase data (only readonly mode). When you launch the iPhone client, you can see this functional menu: By clicking on Customers (the same for Vendors) you have access to the Customers list from your Dynamics NAV (on te list you can immediately see Customer Name and Customer No.): ...

posted @ Friday, November 19, 2010 11:43 AM | Feedback (19)

iNAV: features?

Imagine that you've an iPhone client for NAV on your hands... what features do you like to have on your Apple device? For my iNAV project, I'm thinking to create these features (as a first stage): Access to Customers and Vendor details Access to all Sales data (orders and invoices) for a given customer Access to all Purchase data (orders and invoices) for a given vendor Possibility to save data for offline usage If you've any other ideas or requests, please share here   Technorati Tags: Apple, Dynamics NAV, iOS, iPad, iPhone

posted @ Friday, November 12, 2010 11:11 PM | Feedback (11)

Working on iNAV

As many of you already know, I’m a big fan of Apple’s mobile devices and in these last months my “free time” interest is focused on developing applications for iOS. Actually I’ve on my mind to work on an iPhone (and iPad later) application for accessing Microsoft Dynamics NAV data from an Apple mobile device (an iPhone client for NAV). I think that having a real time access from an iPhone to your corporate Dynamics NAV data could be interesting for many users. I hope to write here soon what will happen during this development. If you’re an Apple iOS user and...

posted @ Tuesday, November 09, 2010 3:08 PM | Feedback (11)

Tuning Dynamics NAV to the max: GROUP BY and DISTINCT

I know that this is not the first time that I write about this topic, but you can think at this as a “personal mission”: I want GROUP BY and DISTINCT on C/AL!! If you’re a NAV developer and you know a bit of SQL, you can understand that a big lack on C/AL is the possibility to make a GROUP BY and DISTINCT query in an “atomic manner”. Let’s see a simple example (but that comes from a real case): You’ve a table with data like these: and you need to perform these tasks: group these data by...

posted @ Thursday, June 11, 2009 3:26 PM | Feedback (7)

Microsoft Dynamics NAV 2009 SP1: .NET controls integration is here!!

Having the possibility to integrate a .NET control into the NAV client is a feature that many NAV developer are asking always more. I’ve written in the past lots of posts about this and I’ve always signalled to the NAV Team that this is also one of the main requests that I receive from NAV customers. What’s the “state of the art” about this topic? After the official release of the NAV Statement of Direction document, now we can make our customers more happy: with NAV 2009 SP1 you’ll have the possibility to integrate a .NET control directly into...

posted @ Monday, June 08, 2009 9:10 AM | Feedback (0)

Dynamics NAV bug on protecting Addon’s objects

If you’re a NAV ISV and you have developed an addon for Dynamics NAV, you’re quite sure that your rights on code are protected and your customer can’t open your objects or modify them (due to the object ID protection). Unfortunately, this is not true… there’s a trick that permits to everyone to read the code of a protected object despite the license protection level. You can also edit and modify the addon objects and create your own. Obviously I can’t describe how to unprotect an object here, but I’ve signalled this problem to Microsoft because I think...

posted @ Monday, May 18, 2009 11:41 AM | Feedback (0)

Using Dynamics NAV 4.x client on Vista x64

Yesterday we had a strange issue on using the Dynamics NAV 4.02 client on a Vista x64 operating system. After applying the trick on sqlsrv32.dll, the error was this: Surprise... the MDAC error is appeared again... seems that the dll was not hacked... After a bit of research, I've discovered that on Vista x64 there are two folders: c:\windows\system32 contains sqlsrv32.dll (64 bit) c:\windows\sysWOW64 contains sqlsrv32.dll (32 bit) In order to run NAV 4.x on Vista x64 you've to modify the sqlsrv32.dll on the sysWOW64 folder by applying it the trick. Remember that this is unsupported by...

posted @ Friday, April 24, 2009 3:10 PM | Feedback (1)

Dynamics NAV 2009: what customers thinks about it.

Few months after the Dynamics NAV 2009 release, what customers thinks about it? NAV 2009 is not only a new release of the Microsoft's ERP, but it's an entire revolution on all the architecture (server side and client side). I've collected a number of feedbacks from customers (mainly technical customers) and these are the results (for your pleasure ): 1) Why NAV is your ERP choice? Customers loves the possibility to customize every part of the NAV system and (really interesting) NAV is considered to have a short go-live time (it depends on the Partner you choose...

posted @ Thursday, March 05, 2009 5:16 PM | Feedback (0)

Dynamics NAV Database optimization: table partitioning

Large Dynamics NAV databases (lots of Gigabytes of physical space on disk) needs optimization and tuning at a level that can't be done via the standard NAV interface: you've to work directly on SQL Server. The first level of optimization starts when your database borns I think. You've to carefully design the physical structure of the DB and always split it on different data files, normally located on different disks. The second step on optimization regards index defragmentation and tuning (I've written in the past something about it). But what about when you have really large tables to query? NAV...

posted @ Friday, February 06, 2009 2:24 PM | Feedback (5)

Dynamics NAV queries tuning: little ideas for the NAV Team

Lots of my daily work with Dynamics NAV is tuning existing systems or architecturing the right and most efficient way of performing certain complex queries. Tuning a query on a NAV database is extremely important, expecially if the database is big and with lots of concurrent users. On my blog I've written in the past how you can tune up your Dynamics NAV database (SQL Server) or how you can introduce tricks in order to perform complex works in a more efficient and performant way. Now the subject of this post is totally for the NAV Dev Team in Microsoft......

posted @ Wednesday, January 07, 2009 2:37 PM | Feedback (10)

Windows Azure: Cloud Computing is here...

The most interesting news that comes fro the PDC is certainlty the announce of the Windows Azure platform.  Azure will be the start of a new era for the Microsoft's applicatons world. It will be a complete "cloud computing" platform available directly from the Internet. It will permit you to have a distributed infrastructure where you can host applications and (really interesting...) it will be completely integrated with the Visual Studio tools (it will be available a specific SDK for building applications for Azure). The Azure platform embraces different services and technologies: and, directly over the operating system...

posted @ Tuesday, October 28, 2008 9:33 AM | Feedback (0)

Consuming a Dynamics NAV Web Service from Excel 2007

Today we was on Microsoft to see a little "pre-sales" preview of the upcoming Microsoft Dynamics NAV 2009. The new release of the Microsoft's ERP is really exciting and one of the coolest feature of the new 3-tier platform is the native support for web services. One of the demo we saw today shows an interesting scenario that will be available with the new NAV release: you can import NAV data into Microsoft Excel, modify them directly on Excel (with all the validation and NAV logic available) and then return the data to NAV. But how to do this with...

posted @ Thursday, October 23, 2008 9:40 PM | Feedback (6)

SQL Server 2008 Report Builder: start to learn it!

Microsoft has finally released the final version of its Microsoft SQL Server 2008 Report Builder 2.0 RTM, the tool that every NAV developer will use every day more in the near future. Microsoft SQL Server 2008 Report Builder 2.0 provides an intuitive report authoring environment for business and power users. It supports the full capabilities of SQL Server 2008 Reporting Services and it permits to easily create reports (RDL format) based on SQL Server databases. With few clicks you can build interesting graphs also (I've created in a minute a graph with a KPI of the Sales Order in my...

posted @ Monday, October 20, 2008 3:46 PM | Feedback (5)

Extending Dynamics NAV with Windows Workflow

Frequently I'm involved on speaking where we present products like Dynamics NAV, Dynamics CRM, Sharepoint and all the new .NET 3.5 platform in general. One of the common aspects that I like to put in evidence is that all these products (except NAV) supports natively one of the coolest aspects of the new .NET platform: Windows Workflow (it's not a mistery that I'm a Windows Workflow lover and I like to show that with Windows Workflow you can build modular business processes). One of the common question that often I receive is: can we extend Dynamics NAV with Windows...

posted @ Saturday, October 18, 2008 11:02 PM | Feedback (1)

Microsoft Dynamics NAV: using ADO and SQL Stored Procedures to tune up your queries

I've discovered today that we in EID are not the ones that are using the ADO trick to tune up certain queries on Dynamics NAV. There are cases where queries executed via C/AL can be more complex and less performant that queries directly performed via T-SQL. My personal case where I love to use this trick is for example if you have to do a SELECT DISTINCT query via C/AL: via NAV code, you have to use two at least two record variable and marks. Why not run a simple SELECT DISTINCT via T-SQL and reads the data from...

posted @ Monday, August 25, 2008 8:42 PM | Feedback (1)

SQL Server 2008 is out: is my platform supported?

With the official release of SQL Server 2008, this is the "hottest" question that customers are asking to us. If I'll plan to move under the new database engine, is my business ready for this new platform? This is the answer for the products that we support: Microsoft Office Sharepoint Server 2007 (MOSS) and Windows Sharepoint Services 3.0 (WSS) support SQL Server 2008 with their Service Pack 1 version (MOSS 207 SP1 and WSS 3.0 SP1). SP1 is also a requirement for installing MOSS 2007 and WSS 3.0 on Windows Server 2008. Microsoft Dynamics CRM 4.0 runs with...

posted @ Friday, August 22, 2008 1:47 PM | Feedback (0)

NAV 2009: how to run a NAV object as a web service

One of the biggest improvements in the future NAV 2009 three-tier platform will be the possibility to run a NAV object (a table or a codeunit for example) as an XML web service. The final result is that you will have a platform ready to be extended and integrated with external systems. The biggest news is that now you can invoke the NAV logic also from the external world... this is fantastic and extremely powerful for every type of integration. Directly from the NAV Developer Team, a brief explanation: In NAV 2009, run form 810 "Web Services". Select either a...

posted @ Sunday, August 10, 2008 1:29 PM | Feedback (0)

Microsoft Dynamics Mobile 1.1 released

Today Microsoft has officially released the 1.1 version of Microsoft Dynamics Mobile on PartnerSource. This new release will support: Microsoft Dynamics NAV 4.0 SP3 Microsoft Dynamics NAV 5.0 SP1 Microsoft Dynamics AX 4.0 SP1 Microsoft Dynamics AX 4.0 SP2 Directly from the Product Team's blog: "We are releasing in 2 packages, one for the Microsoft Dynamics Mobile - Mobile Development Tools, containing the Server and Framework Components and one for Microsoft Dynamics Mobile - Mobile Sales. You should note that the Server components and Mobile Sales integration objects are already included as part of...

posted @ Saturday, April 05, 2008 4:00 PM | Feedback (0)

Microsoft Dynamics and Classic Integration Tour: 2nd step

Today we'll have the second step of our "Dynamics TempoZero Tour" and the site is Busto Arsizio (VA). We'll show a nice demo of integration between Dynamics NAV, MOSS and Business Intelligence (a complete real world scenario of a manufacturing company) and we'll talk more in depth about the technology under the cover (BDC, Windows Workflow, Web Services, the future NAV Service Layer etc.). We've also added a section for Dynamics CRM 4.0. I hope to see some of you this morning... Here's a screenshot of our demo scenario: NAV data published on a MOSS Dashboard. Technorati...

posted @ Thursday, February 21, 2008 11:26 AM | Feedback (3)

Dynamics Tempo Zero Tour tomorrow

I wrote some days ago about the big tour that we're launching in a strict collabouration with Microsoft. We will be in lots of city all around Italy to show how you can tune up your business with the integration of Microsoft Dynamics product family and the Microsoft collabouration platform (Sharepoint/MOSS, Unified Communication, Microsoft Office, Windows Mobile). Tomorrow the first step: I will be in Oleggio Castello (NO) and I'll show you a nice and complete integration scenario between NAV, MOSS and Business Intelligence (based on our Navlab platform). After my demo, some colleagues will show you something about Dynamics...

posted @ Wednesday, February 06, 2008 3:46 PM | Feedback (0)

Microsoft Dynamics + Classic Tour: we wait for you...

Are you interested on discovering the power of the entire Microsoft Dynamics suite combined with the Microsoft Classic products? Do you want to see Dynamics NAV and Dynamics CRM in action with Sharepoint in a great scenario of collabouration and integration? This is the event for you... Microsoft and Navlab together (our group) will be in 20 city (only in Italy unfortunately) and we'll show you a complete scenario of integration between Dynamics NAV, Dynamics CRM, Sharepoint Portal Server, Infopath and Microsoft Office PerformancePoint Server 2007 (for BI integration). Believe me... it will be an interesting event. If you...

posted @ Wednesday, January 30, 2008 10:12 PM | Feedback (2)

"Programming Microsoft Dynamics NAV": a brief review

About one month ago I was pleased to be contacted by Packt Publishing in order to give a review of their last book about Microsoft Dynamics NAV. The book is "Programming Microsoft Dynamics NAV" by David Studebaker and this is one of the few books that talks about developing with Dynamics NAV. This is a 460 page book (11 chapters) that covers the needs of developers that are starting to approach the NAV development to developers that are experts on NAV development but want to know more. It starts to introduce the Application Design concepts inside NAV, then...

posted @ Wednesday, December 26, 2007 9:16 PM | Feedback (2)

OBA and Microsoft Dynamics

In these days we're really busy to work with Microsoft on a future tour where we'll show the power of the integrations between Microsoft Dynamics and what is called the "Microsoft classic" world. One of the key point of this future tour is in my opinion what is called OBA, alias Office Business Applications. In order to undertand the potential of OBA, start with this picture: OBAs connect Line of Business (LOB) systems with the people that use them through the familiar user interface of Microsoft Office. OBAs enable businesses to extend the Microsoft Office clients and servers...

posted @ Thursday, December 06, 2007 4:00 PM | Feedback (2)

Microsoft Dynamics 6.0 Architecture

Microsoft Dynamics NAV 6.0 will be the first big revolution of the NAV platform because it will improve not only the functionalities but also the system architecture. This is a little schema (directly from Convergence) that shows the new architecture: Web Service and Sharepoint Services will be an hot topic for the new NAV era. I will continue to say to my customers that the new Three-Tier architecture is not a MUST, but it's a CHOICE. Customers that don't want to upgrade can continue to stay with the old client. You can choose to Stay on the classic...

posted @ Wednesday, November 28, 2007 4:35 PM | Feedback (0)

Microsoft Dynamics Mobile for NAV

Mobility is one of the most requested features on nowadays business and having the possibility to work with your ERP data also when you're on travel by using a mobile device is surely an hot topic for many customers (I can see that there's a lot of curiosity and a growing interest around mobile features). Internally here in EID we've developed during the years some custom mobile soutions that works with NAV data, but obviously the actual NAV platform creates some limits on this field (NAV actually is not natively web service enabled for example). But fortunately the future seems...

posted @ Tuesday, November 20, 2007 3:51 PM | Feedback (0)

A bit of NAV 6.0 into the 5.0 SP1

Today the Dynamics NAV Team has officially announced something more details about the decision to move the delivery date of the next NAV release. The big work that the Dynamics NAV Team is doing around the future 6.0 release is resumable as follow: We have moved the product from a two-tier architecture to a three-tier architecture dramatically increasing the integration opportunities for customers. We have added support for web services across the board and enabled all of our ISV and partner solutions to also be web serviced enabled. The win for customers is the ability to leverage...

posted @ Sunday, October 21, 2007 11:36 PM | Feedback (2)

Announcing Microsoft Dynamics NAV 6.0

The rumours are true: with an announce on PartnerSource, Microsoft has officially delayed the released date of the new NAV architecture. The main parts of the announce are these: The new release date for Microsoft Dynamics NAV 5.1 has been changed to Q4 CY2008. We also plan to deliver a Technical Preview to our entire partner community in H1 CY2008 to allow more time for preparation for Microsoft Dynamics NAV 5.1. Microsoft Dynamics NAV 5.1 will be much more than just an extension to Microsoft Dynamics NAV 5.0. It is based on a new breakthrough technology platform...

posted @ Thursday, October 18, 2007 11:00 PM | Feedback (1)

Microsoft Dynamics products convergence

When some years ago Microsoft has launched the new Dynamics vision (do you remember the famous "Wave 1" and "Wave 2"?), one of the common question that customers asks to Partners is: when we'll have a convergence of the actual Dynamics products? Is this convergence a reality? Obviously, there's not a clear answer at the moment (some strategies are under NDA) but what is sure is that a first step of convergence is already begun. The future Dynamics products will have a common set of features and an improved interoperability, they all will share a RoleTailored user experience, integration...

posted @ Thursday, August 02, 2007 4:35 PM | Feedback (0)

How will I use Web Services in Dynamics NAV 5.1?

One of the powerful feature of the future Dynamics NAV 5.1 version is surely the new web service layer: Dynamics NAV will finally permit us to expose tables and business logic to other external applications, so a new world of possible application scenarios wil be opened to the NAV users. But one of the common questions I receive is: should I become a web service expert in order to use these new features? Although understanding the core concepts of .NET web services is always the best way to approach the new NAV service layer, Dynamics NAV will offer a simple...

posted @ Saturday, July 14, 2007 2:59 PM | Feedback (0)

News from the Microsoft Dynamics NAV world...

I've received an interesting set of official and unofficial news from friends involved in the Microsoft World Partner Conference that I like to share with all my readers. In a casual order, here is the list: If you're interested on Dynamics NAV as a possible ERP solution but you've small requirements in terms of users and functionalities, Microsoft has announced a new product called "Microsoft Dynamics Entrepeneur Solution", totally based on Microsoft Dynamics NAV standard and able to satisfy the needs of up to 5 users. The main feature of this new version is that it will be really...

posted @ Tuesday, July 10, 2007 11:16 PM | Feedback (0)

Dynamics NAV: how to rollback from a database upgrade?

With Microsoft Dynamics NAV, if you try to open a database created with a version older than the current client version (from example a 4.0 SP2 database opened with a 4.0 SP3 client), the system prompts you with a message that says something like "The database must be converted to the new version. Are you sure?". If you press the YES button, the db is automatically converted to the new version. But what can you do if you want to rollback this upgrade? There's not an official way for doing this, but if you're running a SQL Server database you...

posted @ Sunday, July 01, 2007 3:27 PM | Feedback (0)

Microsoft Dynamics NAV on a SOA environment

Service Oriented Architecture (SOA) are a cool concept on nowadays Enterprise Architecture world. In a real modern scenario, implementing a SOA environment means having a solution that involves sharing data and processes across multiple systems, that permits you to expose your business processes as services that can be consumed by other applications (external or internal) mixed together or composed into larger and modular business processes (workflows) How can you obtain a SOA architecture with Microsoft Dynamics NAV? In my opinion, Microsoft Dynamics NAV will have a "2 phase" SOA approach. Actually, you can expose Microsoft Dynamics...

posted @ Friday, June 15, 2007 3:32 PM | Feedback (1)

Microsoft Dynamics vs SAP again...

I've received today a copy of a survey conducted by Keystone Strategy llc about the impact of Microsoft Dynamics and SAP on the enterprise. Users of Microsoft Dynamics NAV, Microsoft Dynamics GP, SAP All-in-One, and SAP R/3 at approximately 100 companies (randomly selected) were asked about their experiences with Microsoft and SAP applications across different categories of business productivity. I'm not a fan of these types of surveys but I want to post here the results... maybe they can help someone to make the right choice for his business... 1) Usability measures the user’s perception of how easy the...

posted @ Monday, May 21, 2007 10:44 PM | Feedback (7)

Session problem with NAV and .NET connections

I've written many and many .NET applications that interacts with Dynamics NAV (expecially .NET Web Services) but (as usual) misterious problems are always under the hood... I have a custom .NET Web Service used for interaction between Dynamics NAV and a Pocket PC application. This service has always worked good but today, on a customer's site (Dynamics NAV 4.02 was used), here's the problem: after a data transfer, it's impossible for new users to login with Dynamics NAV due to an error in the Session table in NAV. The error says something like "Difference of two datetime columns caused...

posted @ Monday, May 14, 2007 1:31 PM | Feedback (0)

Dynamics NAV, SQL Server and Vista

Windows Vista is too fascinating and many customers are starting to play with this new OS. Vista has a powerful upgrade installation that permits you to update your Windows XP machine without too many troubles, and this is one of the key aspects of its increasing adoption. However, it's not always so easy and simple with the new Vista world... I've many customers that have installed Vista on their machines and, when they start wor king with Microsoft Dynamics NAV, the problem started. I've written in the past that Microsoft Dynamics NAV 4.0x is not officially supported with Vista...

posted @ Sunday, March 25, 2007 9:08 AM | Feedback (1)