Thursday 30 April 2015

OFFICE 365 INTEGRATION IN NAV 2015 – Excel/SharePoint


If you have signed up for Office 365, Microsoft Dynamics NAV can use this service to open and save documents. For example, when you export a report to Excel and save it on Office 365, Microsoft Dynamics NAV can use Excel Online that your Office 365 account uses to open the document.

Before you can use Office 365 and SharePoint Online with Microsoft Dynamics NAV, you must configure the service in Microsoft Dynamics NAV.

If you want to use the same folder to store temporary files for all users, you must specify a shared user account. Otherwise, each user's temporary files are stored in their personal document repository on the SharePoint site.


  1.  Open “Online Document Storage Configuration” from below path                                                                                                                                                      
  2. Fill the Location to your SharePoint site: Specifies the unified resource indicator (URI) for your site on SharePoint Online, such as https://Cronus.sharepoint.com                                                                                
  3. Fill the Folder field which specifies the folder in the document repository for this document service that you want documents to be stored in.                                      
  4. This field is required. If you have not already created a subfolder in your document repository, you must create one now, and then specify it in the Folder field.                                                                                                                            
  5. The Document Repository field includes the top-level folder in the document repository that your document service provides. The Folder field specifies a subfolder so that you can keep business documents and drafts separate from pictures and other shared documents. For example, if the Document Repository field is set to Documents, the Folder field can be set to Business Documents.                                                                                                                                         
  6. When a user exports data to Excel, for example, Microsoft Dynamics NAV saves the temporary file at the location that is specified in the Document Repository and Folder fields, such as https://Cronus.sharepoint.com/Documents/Business Documents.                                                                                                                
  7. Fill Document Repository field: Specifies the name of the document library, such as Documents.                                                                                                   
  8. Fill User Name field: Specifies the account that Microsoft Dynamics NAV Server must use to log on to the document service.                                              We recommend that you specify a different user name than the administrative account. This helps reduce the risk of users accessing administrative settings, for example. For example, if your user name as an administrator is CronusAdministrator@Cronus.onmicrosoft.com, then the user name for Microsoft Dynamics NAV Server can be nav@Cronus.onmicrosoft.com or any of the regular user names that you have created.                                                            
  9. On the Actions tab, in the General group, choose Set Password.                           In the window that appears, specify and confirm the password for the account    that you specified in the User Name field. Choose the OK button.                  When you have set up the service, you can test whether that configuration is valid.                                                                                                                           
  10. On the Actions tab, in the General group, choose Test Connection.                       A message displays the result of the test.                                                                    




UPDATE/NOTE;
In latest version of NAV navigate to CRONUS International Ltd./Departments/Administration/IT Administration/Services

And select Sharepoint Connection Setup to add above setup.


Friday 17 April 2015

Discover opportunities for your trading with Trade Online Starter


As an entrepreneur, you are constantly looking for opportunities in the market. You are looking for opportunities to increase margins and strengthen your position in the chain. That requires purchase and sales processes efficiently and professionally run. A good start to successful entrepreneurship is automation of basic processes in one central system. Trade Online Starter provides this for a very attractive monthly fee. To show how you can understand and control with this software, GAC offers a free webinar. Write us today.


Keep track
With Trade-line starter, you have functionality that you keep track of everything that takes place in your company. The software via invoices, adjust purchasing and sales quotes, you can process incoming orders, perform account management, and share information with customers and suppliers. The interior of Trade Online Starter gives structure to all your basic processes. You also get a real-time overview screen where you can see what is important to your organization. 

Stay ahead of the competition for
Trade Online Starter is seamlessly integrated with Microsoft Office 365. This controls at once your calendar, mail, and access to Word, Excel, PowerPoint, and Outlook. Because it is a cloud solution, you always have access to the latest version. Combining Trade Online Starter Office 365 provides comprehensive analysis and reporting capabilities. With one press of a button you can see which regions are in your most loyal customers, which have the potential to expand, and other practical information. Discover, recognize, and redeem opportunities in the market and keep your competition that crucial step.

Work on your future in the cloud
Trade Online Starter runs entirely in the cloud on servers Microsoft Azure. That is the cloud platform for companies working on their future. Software in the cloud, you are always automatically providing the latest available version. In addition, you can easily add or remove users per month. Also extends your Trade Online Starter subscription simply with additional functionality. Maintenance is included in the monthly price. Trade Online Starter is available anytime and anywhere. You work where and when you want. If you are not in the office? Then you are on your smartphone or tablet still view things like incoming orders.

Quick Start
Trade Online Starter includes a pre-designed database. GAC provides accessible documentation. We also offer you access to our developed e-learning programs. With a few simple steps you can already started. Do you need more support? Then use Trade Online Consultancy packs.


Discover and experience Trade Online Starter
Discover the features Trade Online Starter offers your organization and experience a professional cloud-based environment. For 89 euros per user per month you get Trade Online Starter includes hosting, maintenance, and automatic updates. Want to know more? Then write us completely free of charge for one of our webinars.

Thursday 16 April 2015

Login failed error while upgrading from NAV2009 to NAV2015


Error Message:
---------------------------
Microsoft Dynamics NAV Development Environment
---------------------------
The following SQL Server error or errors occurred:
18456,"28000",[Microsoft][SQL Server Native Client 10.0][SQL Server]Login failed for user 'GAC\MPA'.
4060,"42000",[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot open database "GAC-COPY-PRODUCTION-Test" requested by the login. The login failed.
---------------------------
OK  
---------------------------



Problem Statement:
System returns this error message when you try to open the NAV2009 database with NAV2013 client in upgrade process and you can’t open the database in NAV2009 anymore, can’t fix the error and can’t continue further with upgrade process.

Solution:
Restore the NAV2009 backup again and remove all tables which have property “LinkedObject“ Yes before converting the database to NAV2013.


Monday 13 April 2015

NAV TechDays 2015


Mark your calendar: NAV TechDays 2015   - 19 & 20 November - Antwerp (Belgium)

Pre-conference day: 18 November





The day before the NAV TechDays conference, on Wednesday 18 November, you have the opportunity to attend some workshops. 

Workshop #1: Power BI for Dynamics NAV (Steven Renders)
In this workshop Steven will introduce you to the world of Power BI for Dynamics NAV. Learn how you can create stunning dashboards in Excel 2013 or the Power BI Designer, so you can find answers to your most important questions using natural language and make decisions based on the right data anytime, anywhere, on any device.

Workshop #2: Working with Powershell and Microsoft Dynamics NAV (Eric Wauters)
During this workshop, I will make you familiar with PowerShell, and what NAV has to offer within PowerShell. We’ll use the existing commandlets, enhance them, look into the existing PowerShell scripts, learn from them and also enhance them. All with practical and useful examples which we will create during the workshop.

Workshop #3: Document Reporting in NAV 2015 (Claus Lundstrøm)
Join this class to master the teachings behind how to easily create Document reports in RDLC in NAV 2015. After this class you will also have a clear understanding how Grouping is done RDLC reports. We will also have a look at how End Customers can do Document Reports in Word.

Workshop #4: Troubleshooting Essentials for SQL Server and Dynamics NAV (Jörg Stryk)
The first part of the workshop will focus on resolving so called “Expensive Queries”. You will learn about the importance of “Keys” and “Indexes”, how to detect problems related to them and how to implement appropriate solutions. According to this, you will get an introduction of several useful tools, like “SQL Profiler”, “SQL Trace”, TSQL/DMV etc. and some pretty cool 3rd party tools.
The second part of the workshop will explain the concept of locking mechanisms in SQL Server and how to deal with it in NAV. You’ll learn how to detect blocks and deadlocks, using on-board features and 3rd party tools. Finally you’ll get some inspirations about how to resolve and prevent blocking problems.


These workshops will take place in the selected conference hotel, and will be charged separately (lunch & coffee breaks included).

Friday 10 April 2015

Cumulative Update 6 for Microsoft Dynamics NAV 2015 has been released


Cumulative Update 6 includes all application and platform hotfixes and regulatory features that have been released for Microsoft Dynamics NAV 2015. 

The cumulative update includes hotfixes that apply to all countries and hotfixes specific to the following local versions:
  •   AU - Australia
  •   AT - Austria
  •   BE - Belgium
  •   CH – Switzerland
  •   CZ – Czech Republic
  •   DE - Germany
  •   DK - Denmark
  •   ES - Spain
  •   FI  - Finland
  •   FR - France
  •   IS - Iceland
  •   IT - Italy
  •   NA - North America
  •   NL - Netherlands
  •   NO - Norway
  •   NZ - New Zealand
  •   RU – Russia
  •   SE - Sweden
  •   UK - United Kingdom
Note: You must convert the database if you are upgrading to Cumulative Update 6 from a cumulative update earlier than Cumulative Update 4 (build 39663). For more information, see Converting a Database in Help for Microsoft Dynamics NAV. 

Where to find Cumulative Update 6
You can download the cumulative update from KB 3052226  – Cumulative Update 6 for Microsoft Dynamics NAV 2015 (Build 40459). 

Additional Information
For information about how to install the cumulative update, see How to Install a Microsoft Dynamics NAV 2015 Cumulative Update

For information about how to work around a recent process change, see How to Get Back the 'Hotfix Directories' from NAV 2015 Cumulative Update 1.


For a list of all cumulative updates for this version, see Released Cumulative Updates for Microsoft Dynamics NAV 2015.  

Announcing Dynamics C5 for tablets


Dynamics C5 for tablets is now available for download from the App Store, Google play, or Windows Store.
Note: Microsoft Dynamics NAV 2015 CU1 must be installed if you are using Microsoft Azure Active Directory as the authentication mechanism.

Get the app today    





Google Play is a trademark of Google Inc. Apple and the Apple logo are trademarks of Apple Inc., registered in the U.S. and other countries. App Store is a service mark of Apple Inc.