UpdatePropagation page Property in NAV2015

Microsoft has introduced a new property UpdatePropagation  in page level in   Nav2015. This property makes it possible to update a parent page from a subpage automatically without using the page Refresh button.

 From sub page request main page to do update instead. The parent page first updates itself and then the subpage

 The UpdatePropagation property is available on part controls and has two options those are Subpage and Both.

If UpdatePropagation is set to Subpage, an update action will update the subpage only.

If UpdatePropagation is set to Both, an update action will update both the main page and the subpage. This is useful if a value on the subpage changes, and you want a main page total to be refreshed automatically. Also, it works on all NAV Clients, doesn’t matter is this Windows, Web or Tablet client.

We can use the UpdatePropagation property to update a main page total, when the amount on the subpage lines is updated. To do that, add a CurrPage.UPDATE(); call, for example, in the OnValidate trigger on the subpage to have the UpdatePropagationproperty take effect.

NAV2015 Compilation Error-Unable to process changes because Service Instance has not created

The below error has  occurred  while compile or save the objects in NAV2015

 To resolve this error,we need to Create a service  or change the database name to the existing service

    and restart the service.

Check the server ports,server name,server instance name has populated or not as shown below 

Open Navision C\SIDE client Tools --> Options then these values.

                   

 

NAV2015 Error-Unable to process changes because current user cannot be authenticated

The below error has  occurred  while compile the objects in NAV2015

To resolve this error,we need to run either the below query in SQL Server

USE [Database Name]
GO
delete from [dbo].[User]
delete from [dbo].[Access Control]
delete from [dbo].[User Property]
delete from [dbo].[Page Data Personalization]
delete from [dbo].[User Default Style Sheet]
delete from [dbo].[User Metadata]
delete from [dbo].[User Personalization]

or provide the required permission to user.

How to restrict multiple logins for the same user ID

Some time we login multiple times with same user ID,but if we want to restrict this,please follow the below

In NAV 2013 and Later , Active Sessions (Table ID - 2000000110) gives 

 all the active session into the database.

For Restricting multiple Login we can use Codeunit 40 - LogInManagement.

So let's see how we can achieve this -

1. Design Codeunit 40, Navigate to Function CompanyOpen().

2. Append Below Lines as below -

the standard code looks like below
---------------------------------------------------
IF GUIALLOWED THEN
  LogInStart;
---------------------------------------------------

After
---------------------------------------------------
//Add code here BEGIN
ActiveSession.SETRANGE("User ID",USERID);
ActiveSession.SETRANGE("Client Type",ActiveSession."Client Type"::"Windows Client");
IF ActiveSession.COUNT > 1 THEN
  ERROR('You are Already Logined');
//Add code here END

IF GUIALLOWED THEN
  LogInStart;
---------------------------------------------------

The Client Type have following Options -
Windows Client,SharePoint Client,Web Service,Client Service,NAS,Background,Management Client,Web Client,Unknown

Above Code will Stop Windows Client to use multiple session with same User ID.

How it executes:

I will get the below error message while runnning RTC client second time which my first RTC client is already opened.

Introducing GAC Trade Online Solution for NAV 2015 Customers

The most complete wholesale software in the cloud

Trade Online will bring your wholesale organization to the cloud. You'll instantly have the right functionalities with our Trade Online Solution. Simple, clear and fast, based on Microsoft Dynamics NAV 2015 and Office 365. Try it directly yourself and discover the benefits of Trade Online for your organization.

What's in Trade Online?

Trade Online Basic

Trade Online Advanced

Trade Online Multi Site International

You can go through below link to know more about the product here

http://www.gac.nl/online-groothandelsoftware/product-tour.aspx

Entirely in the cloud

Always and everywhere

Trade Online works with you completely in the cloud. That means you do not need a server at your office with the necessary management costs. Updates occur automatically and you always have access to your data. And, you can get started for a fixed monthly fee.

•         Access your data
•         works on any device
•         no maintenance costs to servers
•        always work with the latest versions
•         full integration with office
•         you pay for what you use

For more details: 

http://www.gac.nl/online-groothandelsoftware/product-tour/software-in-de-cloud.aspx

Trade Online grows with you

A major advantage of Trade Online is the scalability. As your organization grows, simply switch on with more users or new functionality. You can use less of users to feet? Simply switch back. 

(Online) support

Telephone support desk, Online chat support, FAQs, Webinars & Online and offline training.

GAC Business Solutions has its own telephone service desk for direct support questions. You can also find answers to questions through service portal or post your questions. You also have access to an extensive FAQ database and online chat support. To know more about software, GAC provides on- and offline training courses at very competitive rates. 

Safe & fast

Working safely in the cloud

Trade Online works completely in the cloud, you do not have to worry about servers, backups or maintenance of your enterprise hardware. Trade Online is hosted in Azure, Microsoft's cloud environment. It meets the highest safety standards so that your data is protected against all possible scenarios. 

Mobile working

All devices available

Trade Online is fully optimized for mobile & tablet. Whether it is for desktop, laptop, tablet or phone; Trade Online is available on all devices. This means you are always and everywhere be able to access your data.

The most complete wholesale software

Trade Online is the most complete wholesale software in the cloud. Trade has all the functionality you need as a wholesaler to run your business smart and effective. It contains purchasing, sales, inventory management, financial administration, Marketing & CRM, Service, RMA handling and more modules. Moreover, the software grows with you; updates are automatically incorporated into your software. 

Prices and conditions

Fixed amount per month, adaptable to your situation

Your Trade-line solution is available for a fixed monthly fee. You are free to modify the number of users per month. So you know immediately where you stand, and no surprises to stand afterwards. 

More about Prices here

http://www.gac.nl/online-groothandelsoftware/prijzen.aspx

Try Online Trade Free for 30 Days!

Experience the convenience of Trade Online now 30 day trial!

Bring your wholesale to the cloud and start enjoying the benefits of working online with a complete solution for trading companies based on Microsoft Dynamics NAV. Request your free trial environment. 

Ask the 30 day trial version here

http://www.gac.nl/online-groothandelsoftware/tradeplus-online-aanvraagformulier-basis.aspx

Thank you  Mohana for sharing this information.

Error : Microsoft Dynamics NAV,The following SQL error was unexpected.

When we try to login with a user who does not have dbo-rights,we will get the following error

Error : Microsoft Dynamics NAV
---------------------------

The following SQL error was unexpected.
The SELECT permission was denied on the object 'User Property', database 'Cronus TEST', schema 'dbo'.

---------------------------
OK
---------------------------


Solution :

We can resolve the issue to run the following though sql management studio (replace tblYourTableName with your table name) 

grant select on dbo.tblYourTableName to public

How to Repeat Table Header on Each Page in NAV 2013 & NAV2013R2 Reports

After NAV2013 that the table header doesn't repeat when there is a next page.
Even the table properties Boolean Repeat Header Rows on New Page doesn't help.

So let's see how we can repeat header in New Page.

I will be doing it for NAV2013R2, and using Report Builder. The Steps Remain Same for NAV2013 also.

The following setting are required to repeat the header in New Page

1. Open the Layout of Report in

2. In the Column Group Pane Select Advanced Mode
3. Once in advanced mode you will see static Rows for Each Header Line

4. For Each Header Row that you want to repeat on New Page, select the corresponding Static Row and set these properties.

- Set KeepWithGroup to AFTER
- set RepeatOnNewPage to TRUE.


 When you click on a static Row, the corresponding row is selected in the table.

If you want to repeat all four lines in New Page, Repeat the steps for For all Header Rows.

Save the Report and Run in Role Tailored Client.