Friday, 28 August 2015

How to change welcome/login screen in Web client


When we try to open web client then we get below login screen by default



If we want to change the login screen then we have to modify Header.png file in below path
C:\inetpub\wwwroot\DynamicsNAV80\WebClient\Resources\Images

I would like to set below image in login screen





Now I have to replace the Header.png file in above path with same name as Header.png

Now try to login to Web Client again.

Saturday, 18 July 2015

Dynamics NAV 'Corfu' Limited Beta Agreement


‘NAV Corfu’ was announced officially as: Dynamics NAV 2016.
This Program is for the review and usage of new features in Microsoft Dynamics NAV ‘Corfu’.
Microsoft will make early technical readiness content and CTPs (Community Technical Previews) available for participant use.

If you are interested then submit the nomination form here





Monday, 8 June 2015

Invalid object name '$ndo$usrproperty'

Error: The following error may come while deleting company or table

---------------------------
Microsoft Dynamics NAV Classic
---------------------------
The following SQL Server error or errors occurred:

208,"42S02",[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name '$ndo$usrproperty'.
16945,"42000",[Microsoft][ODBC SQL Server Driver][SQL Server]The cursor was not declared.

SQL:
SELECT [sid] FROM [$ndo$usrproperty]---------------------------
OK   
---------------------------

Problem Statement: $ndo$usrproperty table is not available in database.

Solution: Open SQL Server Management Studio
Run below query

CREATE TABLE [dbo].[$ndo$usrproperty](
   [sid] [varbinary](85) NOT NULL,
   [artoken] [varchar](128) NOT NULL,
PRIMARY KEY CLUSTERED
(
   [sid] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]

) ON [PRIMARY]

Tuesday, 19 May 2015

Current setup of users is in violation with the license on Microsoft Dynamics NAV Database Server


Message: We may receive below message while logging into Microsoft Dynamics NAV RTC.

Microsoft Dynamics NAV - Trade Online
---------------------------

Current setup of users is in violation with the license on Microsoft Dynamics NAV Database Server. The current license allows 5 Full users, 0 Limited users, 0 Full Devices, 0 Limited Devices, and 0 ISV Devices.
---------------------------
OK
---------------------------



Problem Statement:
When No. of users added in NAV server is more than current licenses allowed in NAV license then we will receive above message while logging into RTC.


Solution:

Make sure that the No. of users in NAV is less or equal to allowed license count in NAV License.

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.