Dynamics NAV

Showing posts with label NAV2015. Show all posts
Showing posts with label NAV2015. Show all posts

Friday, 7 September 2018

Compilation of assembly 'C:\ProgramData\Microsoft\Microsoft Dynamics NAV\110\Server\MicrosoftDynamicsNavServer$DynamicsNAV110\assembly\Page30_48344.dll' failed. This can be caused by differences between binaries in your installation or your database

When we merge the OnAfterGetCurrRecord function from NAV2009 to  NAV2013 or Later versions page object then we will get this error because NAV2013 onwards OnAfterGetCurrRecord trigger is exist in the pages.

Compilation of assembly 'C:\ProgramData\Microsoft\Microsoft Dynamics NAV\110\Server\MicrosoftDynamicsNavServer$DynamicsNAV110\assembly\Page30_48344.dll' failed. This
can be caused by differences between binaries in your installation or your database

Resolution : Move the custom code from OnAfterGetCurrRecord  to OnAfterGetCurrRecord  trigger and Delete the merged function from the page object.
 

Wednesday, 22 April 2015

The value of Decimal parameter is outside of the permitted range. The current value is: 1,944,000,000,000,000. The permitted range is: from -999,999,999,999,999.99

We will get the below error while run the step2 process for upgrade from NAV2009 R2  to NAV2015

The value of Decimal parameter  is outside of the permitted range. The current value is: 1,944,000,000,000,000. The permitted range is: from -999,999,999,999,999.99.

The above error will occur due to UpdateProdOrderRoutingLine function in the codeunit 104051. this function is Updating Expected Capacity Need in the Prod. Order Routing Line with Expected Capacity Need with the Time factor of the unit of Measure code which returns the value outside of the decimal range.


Wednesday, 15 April 2015

An error occurred when opening the report designer. A supported version of Visual Studio could not be found

We will get the below error when visual studio does not exist in our system,But we have report Builder 


An error occurred when opening the report designer. A supported version of Visual Studio could not be found.

How to enable Report Builder : 

steps as below

1. Navigate to Tools - Options.

2. Set Property Use Report Builder as YES.

    


Now open the layout of any report, it will open with Report Builder as shown below.



I

Monday, 30 March 2015

Cumulative Update 5 for Microsoft Dynamics NAV 2015 has been released


Cumulative Update 5 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 5 from a cumulative update earlier than Cumulative Update 4 (build 39663). For more information, see Converting a Database in Help for Microsoft Dynamics NAV. 
You can download the cumulative update from KB 3039824  – Cumulative Update 5 for Microsoft Dynamics NAV 2015 (Build 40262). 

Friday, 27 March 2015

Upgrading Reports from NAV2013,NAV2013R2 to NAV2015

If you want to use reports from earlier versions of Microsoft Dynamics NAV, you must upgrade the reports before you can run or modify them. The report formats that were supported in Microsoft Dynamics NAV 2013 were client report definition (RDLC) 2008. In Microsoft Dynamics NAV 2013 R2, the report formats are replaced with client report definition (RDLC) 2010.
Typically, upgrading reports is part of upgrading the Microsoft Dynamics NAV application. However, you can also import reports from .txt files or .fob files.

Importing RDLC 2008 Reports
If you import reports that have RDLC 2008 format from Microsoft Dynamics NAV 2013, then you must upgrade the reports to Microsoft Dynamics NAV 2013 R2.
Upgrading reports is part of the Upgrading the Application Code section of the upgrade process. Follow steps 1 through 5d in the Identifying Customized Objects topic to begin the upgrade process. Then export the relevant report objects, and import them into Microsoft Dynamics NAV 2013 R2.
The following illustration shows the upgrade process for the reports.


When you import the report, Microsoft Dynamics NAV automatically upgrades it to RDLC 2010. SQL Server Report Builder first validates that the reports have the correct RDLC 2008 format and then upgrades them to RDLC 2010 format.
In Object Designer, when the upgrade is complete, the Modified flag is set to Yes. All other properties for the report are not changed.
After the upgrade, you can open the layout in Visual Studio. For more information, see How to: Integrate Report Dataset Designer and Visual Studio Report Designer. You must compile the imported report before you can run it.
Importing RDLC 2010 Reports
You can import reports that have RDLC 2010 format to Microsoft Dynamics NAV 2013 R2. Upgrading the reports is an automated process. SQL Server Report Builder first validates that the reports have the correct RDLC 2010 format and then imports them.
In Object Designer, no properties for the report are changed.

Note : You cannot import reports from versions earlier than Microsoft Dynamics NAV 2013 into Microsoft Dynamics NAV 2013 R2. If you want to import a Microsoft Dynamics NAV 2009 report, you must first upgrade the report to Microsoft Dynamics NAV 2013, and then import it into Microsoft Dynamics NAV 2013 R2


Thursday, 26 February 2015

Error : while validating RDL content: Value cannot be null

Once you upgrade databse to  NAV2015,we need to create a service for the databse otherwise some times we may get the below error

Microsoft Dyanamics NAV

----------------------------

Error while validating RDL content:

Value cannot be null.

Parameter name: path1

----------------------------

To resolve this issue,we need to create a service name and check the service name effected to our database through file --> database information-> service name

Tuesday, 17 February 2015

Test and fix dimensions before upgrading to NAV 2013



Please go through this link  from Gunnar's Blog

Virtual Tables in to NAV 2015

Virtual Tables in  to NAV 2015



Table No.
Table Name
2000000001
Object
2000000007
Date
2000000009
Session
2000000020
Drive
2000000022
File
2000000024
Monitor
2000000026
Integer
2000000028
Table Information
2000000029
System Object
2000000038
AIIObj
2000000039
Printer
2000000040
License Information
2000000041
Field
2000000042
OLE Control
2000000043
License Permission
2000000044
Permission Range
2000000045
Windows Language
2000000046
Automation Servers
2000000047
Server
2000000048
Database
2000000049
Code Coverage
2000000055
SID - Account ID
2000000058
AllObjWithCaption
2000000063
Key
2000000070
Error List
2000000101
Debugger Call Stack
2000000102
Debugger Variable
2000000103
Debugger Watch Value
2000000135
Table Synch. Setup

Thursday, 12 February 2015

NAV 2015 - Cumulative update 4 Released

Microsoft Dynamics NAV 2015 Cumulative Update 4 has been released .Please find the link below


Build No. - 39663
Release Date - February, 2015
Local Version are AU, AT, BE, CH, CZ, DE, DK, ES, FI, FR, IS, IT, NA, NL, NO, NZ, RU, SE, UK.

Download

Thanks

Thursday, 15 January 2015

What's New in Microsoft Dynamics Reports in NAV 2015

In previous versions of Microsoft Dynamics NAV, you could only design the layout of reports by using Visual Studio

Report Designer or Microsoft SQL Server Report Builder. With Microsoft Dynamics NAV 2015, you can design
report layouts by using Microsoft Word 2013. Word report layouts are built on Word custom XML parts that 
dynamically map a report dataset into a report at runtime.

Customizing and Managing Report Layouts from the Microsoft Dynamics NAV Clients

You can customize Word and RDLC report layouts from the Microsoft Dynamics NAV Windows client and Microsoft 
Dynamics NAV Web client by using Word 2013 and SQL Server Report Builder, respectively. This enables users can
make variations of layouts, and then use the variations when viewing and printing reports as needed.

There are the  following new report functions have been added in Microsoft Dynamics NAV 2015 to support new report 
layout implementation.

SAVEASXML:                  Saves a report as an .xml file on the computer that is running Microsoft Dynamics NAV Server.
WORDXMLPART:            Returns the report data structure as structured XML that is compatible with Word Custom XML parts.
WORDLAYOUT:               Gets the Word report layout that is used on a report and returns it as a data stream.
RDLCLAYOUT:                Gets the RDLC layout that is used on a report and returns it as a data stream.
HASCUSTOMLAYOUT:    A function in codeunit 1 that determines whether a report has an active custom Word layout or RDLC layout at run time.
MERGEDOCUMENT:        A function in codeunit 1 that loads the custom Word layout that is active on report and renders it in the targeted format, such as Word, PDF.
REPORTGETCUSTOMRDLC : A function in codeunit 1 that loads the proper custom RDLC layout for a report at run time and uses the layout to render the report.


We can design the Layout in Word































Output will be shown below


How to Identify Client Type from C/AL Code

The following Microsoft Dynamics NAV clients interact with the Microsoft Dynamics NAV database through Microsoft Dynamics NAV Server:

  • Microsoft Dynamics NAV Windows client
  • Microsoft Dynamics NAV Web client 

If we have to differentiate development for Windows Client and Web Client then how to identify the client from 
c/AL code?

We have 2 functions available in Codeunit 419 - File Management called IsWindowsClient and IsWebClient.



Wednesday, 14 January 2015

How to send Documents as Email in NAV2015

 We have an option for sending attachments as email is available from Microsoft Dynamics NAV2015. 
We can see in sales invoices, sales credit memos, sales orders, sales quotes, reminders, and finance charge memos, as well as some posted documents. 

The option is available in the ribbon and called Email or Post and email depending on the context. 
It displays a dialog that lets you attach the document together with a short message and send this as email directly from Microsoft Dynamics NAV. 

In Microsoft Dynamics NAV Windows client you can decide to modify the email more in your default mail program. 
The default email sender address is based on the settings in the SMTP Mail Setup window. 
If SMTP is not configured or Outlook is not available, the .pdf file will open instead.

How to Deployment Report Layouts in a Multitenant in NAV2015

In a multitenant Microsoft Dynamics NAV deployment, the built-in report layouts are stored in the application database because they are part of the report objects. Therefore, built-in report layouts are available to all tenants.  You cannot modify a built-in report layout from the Microsoft Dynamics NAV client but you use them as a starting point for building your own custom report layouts. Custom report layouts are stored in the business data database; therefore they are specific to the tenant. This enables you to create separate report layouts for each tenant.    



      A report can only have one built-in RDLC report layout and one built-in Word report layout. By default, the built-in RDLC report layout is used when the report is run in the Microsoft Dynamics NAV client unless there is only a built-in Word report layout, in which case, the built-in Word report layout is used.


                 






users can also create custom report layouts that are based on the built-in report layouts. This enables users to have several different layouts for the same report which they can switch among. Custom report layouts are managed from page 9650 Report Layouts in the Microsoft Dynamics NAV client. Unlike built-in report layouts, which are part of the report object, custom report layouts are stored in table 9650 Report Layouts of the database.
Custom layouts are report layouts that you design to change the appearance of a report. You typically create a custom layout based on a built-in layout, but you can create them from scratch or from a copy of an existing custom layout. Custom layouts enable you to have multiple layouts for the same report, which you switch among as needed. For example, you can have different layouts for each Microsoft Dynamics NAV company, or you can have different layouts for the same company for specific occasions or events, like a special campaign or holiday season.
You can create custom Layouts as shown below

              

Once we select the Boolean Insert Word Layout,Insert RDLC Layout,it will create the layouts.
As shown below



Now change the layout that is used on a report as shown below

1.      In the Search box, enter Report Layout Selection, and then choose the related link.
The Report Layout Selection window lists all the reports that are available for the company that is specified in the Company field at the top of the window.
The Selected Layout field specifies the layout that is currently used on the report.
2.      Set the Company field at the top of the window to the company that includes the report.
3.      To change the layout that is used by a report, in the row for the report in the list, set the Selected Layout field to required options among RDLC (built-in), Word (built-in) and Custom  
       




Now custom layout will run whenever the report executes in the test company.

Monday, 12 January 2015

C/AL Coding Guidelines -NAV2015

Microsoft has Published C/AL Coding Guidelines that they use at Microsoft Development Center at Copenhagen

Please find them in below link.

https://community.dynamics.com/nav/w/designpatterns/156.cal-coding-guidelines.aspx

Friday, 9 January 2015

New Cumulative Updates 1 and 2 for NAV2015

Cumulative Updates 1 and 2 for Microsoft Dynamics NAV 2015 has bee released already
CU1 resolves a lot of small problems in the platform area. Also, this CU has application improvements in almost all functional area.
You can find and download  Cumulative Update1 here. This CU1 is named as Build 38457 
CU2 includes all application (Administration, Finance, Inventory, Manufacturing, Marketing, Purchase, Sales, Service and Warehouse) and platform hotfixes and regulatory features that have been for Microsoft Dynamics NAV 2015. It has a lot hotfixes for following localisations: Germany, Denmark, Spanish, Finland, France, Italy, North America, Netherlands, Norway, Russia, Sweden, United Kingdom,
You can download Cumulative Update 2 for Microsoft Dynamics NAV 2015 from here.   This CU2 is named as Build 38798.

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.


Thursday, 8 January 2015

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.

Friday, 2 January 2015

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

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: 


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

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

Thank you  Mohana for sharing this information.