Sunday, October 25, 2015

Sell-to Customer and Bill-to Customer vs Item Sales Price

Today one of our new NAV client sent us a service request saying Item Sales Price in Dynamics NAV is not working as it should be. His complain was item sales price only works with some customers and for the rest of the customers system take the item card price at the time of creating the sales order. 

What could be the reason? Could it be a bug in the system.

We did check the setups in the item sales prices (Sales Code, Item No, Start Date,  End Date, Currency Codes, VAT Bus. Posting Groups, End Date) and also the Customer Setups (Currency Code, Location) but we could not find a issue in any of the setups. 

Therefore to find the root cause we start the debugging option in the Dynamics NAV. We found that customer filter is not getting applied (different customer number is been applied) and sales price table return with a empty data-set due to that. 

Keeping that in our mind, we navigate to customer card and found that "Bill to Customer" and "Sell to Customer" numbers are different. Our client has only sent the price lists for the "Sell to Customer" and not to the "Bill to Customer" code. 

Dynamics NAV get the Sales Price depending on the "Bill-to Customer" No. and not with the "Sell-to Customer" No. 

Hope this small information will help you in future.  

Please provide your feedback with a comment.
Thank you and Regards,
Tharanga Chandrasekara

Cumulative Update 31 for Microsoft Dynamics NAV 2013 has been released

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

The cumulative update is intended mainly for solutions that are experiencing the problems described in the Knowledge Base article linked to below. However, you are advised to always keep your solution updated with the latest cumulative update. If you are in doubt about whether this cumulative update addresses your specific problem, or if you want to confirm whether any special compatibility, installation, or download issues are associated with this cumulative update, support professionals in Customer Support Services are ready to help you. For more information, see 

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
  • DE – Germany
  • DK – Denmark
  • ES – Spain
  • FI – Finland
  • FR – France
  • IS – Iceland
  • IT – Italy
  • NA – North America
  • NL – Netherlands
  • NO – Norway
  • NZ – New Zealand
  • SE – Sweden
  • UK – United Kingdom

Where to find Cumulative Update 31
You can download the cumulative update from KB 3097765 – Cumulative Update 31 for Microsoft Dynamics NAV 2013 (Build 42948).

Office 2016
The NAV team is proud to announce that with this cumulative update, Microsoft Dynamics NAV 2013 is compatible with Office 2016.

Warning
Before you install a cumulative update in a production environment, take the following precautions:
  1. Test the cumulative update in a non-production environment.
  2. Make a backup of the system or computer where the cumulative update is to be installed.
Additional Information
For a list of all cumulative updates for this version, see Released Cumulative Updates for Microsoft Dynamics NAV 2013.

For a list of all hotfixes included in cumulative updates for this version, see the following CustomerSource and PartnerSource pages:

CustomerSource:

PartnerSource:

Please provide your feedback with a comment. 
Thank you and Regards,
Tharanga Chandrasekara

Cumulative Update 24 for Microsoft Dynamics NAV 2013 R2 has been released

Cumulative Update 24 includes all application and platform hotfixes and regulatory features that have been released for Microsoft Dynamics NAV 2013 R2.

The cumulative update is intended mainly for solutions that are experiencing the problems described in the Knowledge Base article linked to below. However, you are advised to always keep your solution updated with the latest cumulative update. If you are in doubt about whether this cumulative update addresses your specific problem, or if you want to confirm whether any special compatibility, installation, or download issues are associated with this cumulative update, support professionals in Customer Support Services are ready to help you. For more information, see 

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

Where to find Cumulative Update 24
You can download the cumulative update from KB 3097766 – Cumulative Update 24 for Microsoft Dynamics NAV 2013 R2 (Build 42950).

Windows 10 and Office 2016
The NAV team is proud to announce that with this cumulative update, Microsoft Dynamics NAV 2013 R2 is compatible with Windows 10 and Office 2016.

Warning
Before you install a cumulative update in a production environment, take the following precautions:
  1. Test the cumulative update in a non-production environment.
  2. Make a backup of the system or computer where the cumulative update is to be installed.
Additional Information
For more information about cumulative updates for this version, see Announcement of update rollups for Microsoft Dynamics NAV 2013 R2.

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

For a list of all hotfixes included in cumulative updates for this version, see the following CustomerSource and PartnerSource pages:

CustomerSource:

PartnerSource

Please provide your feedback with a comment.
Thank you and Regards,
Tharanga Chandrasekara

Cumulative Update 12 for Microsoft Dynamics NAV 2015 has been released

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

The cumulative update is intended mainly for solutions that are experiencing the problems described in the Knowledge Base article linked to below. However, you are advised to always keep your solution updated with the latest cumulative update. If you are in doubt about whether this cumulative update addresses your specific problem, or if you want to confirm whether any special compatibility, installation, or download issues are associated with this cumulative update, support professionals in Customer Support Services are ready to help you. For more information, see 

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 this cumulative update from a cumulative update earlier than Cumulative Update 9 (build 41779). For more information, see Converting a Database in Help for Microsoft Dynamics NAV.

Note: To enable customized translation of profiles, a number of actions are now available on the Profile List page. You can export and import resource files to enable translation for one or more profiles. The steps to install and uninstall language modules have also been modified. For more information, see How to: Install Language Modules, How to: Uninstall Language Modules, and How to: Export, Edit, and Import Translated Profile Strings in Help for Microsoft Dynamics NAV.

Where to find Cumulative Update 12
You can download the cumulative update from KB 3097767 – Cumulative Update 12 for Microsoft Dynamics NAV 2015 (Build 42951).

Windows 10 and Office 2016
The NAV team is proud to announce that with this cumulative update, Microsoft Dynamics NAV 2015 is compatible with Windows 10 and Office 2016.

Warning
Before you install a cumulative update in a production environment, take the following precautions:
  1. Test the cumulative update in a non-production environment.
  2. Make a backup of the system or computer where the cumulative update is to be installed.
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.

Please provide your feedback with a comment.
Thank you and Regards,
Tharanga Chandrasekara

Saturday, October 24, 2015

Microsoft Dynamics NAV Universal App (Dynamics NAV v2.0)

Last week Microsoft has released Universal App 2.0 to all the users. Following is the statement they have published. 

Maybe you’re already familiar with Dynamics NAV on your tablet. Well, things just got even more flexible. You can now experience the power and simplicity of the Microsoft Dynamics NAV Universal App on your preferred iOS, Android or Windows device – be it phone, phablet, tablet, laptop, or desktop – it’s all up to you. Switch to your favorite device on the go, during meetings, in the office, at home on the couch using the same app, accessing your Dynamics NAV business data from everywhere.

NOTE: We have lowered the app’s minimum requirement on Windows devices to 1GB.
For Customers
Download and install Dynamics NAV from the Windows Store, App Store, or Google Play. You sign in using your usual credentials and the app connects to your Dynamics NAV 2016 server, on premise or in the cloud. If you already have Dynamics NAV v.1.1 installed, this will automatically be updated to v2.0 (unless you specifically selected not to update automatically).

Navigate your business data using a fast and fluid interface which leverages design concepts from modern Windows and Office 365, whilst remaining distinctly Dynamics NAV. Do more on the go with capabilities such as send to Excel or Office 365, up-to-date charts and KPIs, emailing of sales quotes and invoices, and shoot and attach pictures with your camera.

Your executives, sales field, service technicians, warehouse workers and many more can now get access to the data they need from the device they prefer. Microsoft Dynamics NAV 2016 comes ready for small businesses with the Small Business role. For midsized businesses seeking custom solutions for various roles, talk to your Partner.

For Partners
Almost all content within the app consists of application pages coming from your Microsoft Dynamics NAV 2016 server, and they are rendered using our Tablet or Phone client, designed exclusively for touch.

This makes development for tablets and phones similar to development for any other Microsoft Dynamics NAV client! Create new pages or customize existing pages in the Microsoft Dynamics NAV Development Environment on your workstation, and it is ready for iOS, Android, and Windows. Test your role-tailored solution directly on your workstation using the Tablet or Phone client running in the browser. You don’t even need to go out and purchase a bunch of tablets of different sizes, versions and platforms.

Since the Tablet and Phone clients are based on Web client technology, you get to reuse your investments in application objects, business logic, and modern client add-ins, and you administer, license, secure, and maintain it in precisely the same way.

Compatibility
If you have Microsoft Dynamics NAV app v1.1, you cannot connect to Microsoft Dynamics NAV 2016 until you have updated to Microsoft Dynamics NAV Universal App to v2.0.
If you have Microsoft Dynamics NAV app v2.0 on the tablet, you can connect to both Microsoft Dynamics NAV 2015 and Microsoft Dynamics NAV 2016.

If you have Microsoft Dynamics NAV v2.0 on the phone, you can only connect to Microsoft Dynamics NAV 2016.
Get the app today
    


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.

Please provide your feedback with a comment. 
Thank you and Regards,
Tharanga Chandrasekara

This is Microsoft Power BI

Power BI transforms your data into rich visuals that you can organize any way you want, freeing you to focus on what matters most to you. Stay in the know and spot trends as they happen with powerful self-service features that help you push your business forward.



See the full picture in one pane
Power BI gathers all your on-premises and cloud information in one central location that you can access whenever and wherever you want. You can also use pre-packaged content packs and built-in connectors to quickly import your data from solutions such as Marketo, Salesforce, Google Analytics, and many more.

Bring details to life
Power BI makes you a master storyteller with stunning visualizations and interactive dashboards that offer a consolidated live view of your business. For the analyst at heart, Power BI Desktop provides a free-form canvas for drag-and-drop data exploration as well as an extensive library of interactive visualizations, simple report creation, and fast publishing to the Power BI service.

Transform data into decisions
Data should empower, not overwhelm. With Power BI, you can easily interact with your data, using simple drag-and-drop gestures to discover trends and natural language queries to get lightning-fast answers.

Share a world of insight
Power BI lets you share dashboards and reports with whoever you want, wherever you go. Always be in the know with the Power BI app for Windows, iOS, and Android. Alerts will inform you about any changes in your data so you can work with your team to take immediate action.


Power BI comes in different forms, 
- Power BI
- Power BI Desktop
- Power BI Mobile

I will get back with more informative articles on this awesome Power BI. If you are interested please visit to Power BI website to find more details. I am pretty sure your company management would be thrilled to see the dashboards that Power BI can provide. 

Please provide your feedback with a comment. 
Thank you and Regards,
Tharanga Chandrasekara

Virtual and Hidden Tables in Dynamics NAV 2016

As in every version Dynamics NAV has its own virtual and hidden tables. There are 8 new additional virtual tables been added to 2016 version. 
Following are the newly added tables to Dynamics NAV and below that you can get all the virtual tables available in Dynamics NAV.

New Tables added to 2016
Table No.
Table Name
2000000136
Table Metadata
2000000137
CodeUnit Metadata
2000000138
Page Metadata
2000000139
Report Metadata
2000000140
Event Subscription
2000000141
Table Relations Metadata
2000000164
Time Zone
2000000167
Aggregate Permission Set

All the Virtual Tables in Dynamics NAV 2016
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
AllObj
2000000039
Printer
2000000040
License Information
2000000041
Field
2000000042
OLE Control
2000000043
License Permission
2000000044
Permission Range
2000000045
Windows Language
2000000046
Automation Server
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
2000000136
Table Metadata
2000000137
CodeUnit Metadata
2000000138
Page Metadata
2000000139
Report Metadata
2000000140
Event Subscription
2000000141
Table Relations Metadata
2000000164
Time Zone
2000000167
Aggregate Permission Set

To open up the hidden and virtual tables you need to create pages using table ID.

Please provide your feedback with a comment. 
Thank you and Regards,
Tharanga Chandrasekara

Thursday, October 15, 2015

Issue in 2016 C/AL Editor : F5 and Symbol Menu

Have any of you encounters a small bug in the Symbol Menu of Dynamics NAV 2016 C/AL editor?  

One of my colleague did! 

Open new Dynamics NAV C/AL editor and design a codeunit. Press F5 or go to Symbol Menu and then try to select a variable from the Symbol menu, normally it used to paste the value in the editor. But with the new editor it does nothing! 

I think this is a small bug in the new release and hope Microsoft will resolve this in the coming release! 


Please provide your feedback with a comment. 
Thank you and Regards,
Tharanga Chandrasekara

Saturday, October 10, 2015

Deferred Revenue & Deferred Expense in Dynamics NAV 2015 and Below Versions

Is there a way to handle deferred revenue and deferred expense using Dynamics NAV without using any customization? 

Before answering to the question, First of all let's look at what are the definitions of deferred revenue and deferred expenses: 

DEFINITION of 'Deferred Revenue'

Advance payments or unearned revenue, recorded on the recipient's balance sheet as a liability, until the services have been rendered or products have been delivered. Deferred revenue is a liability because it refers to revenue that has not yet been earned, but represents products or services that are owed to the customer. As the product or service is delivered over time, it is recognized as revenue on the income statement.

(Link)

DEFINITION of 'Deferred Expense'

deferred expense is a cost that has already been incurred, but which has not yet been consumed. The cost is recorded as an asset until such time as the underlying goods or services are consumed; at that point, the cost is charged to expense. A deferred expense is reported on the balance sheet as an asset until it expires. As it is expiring, it will be moving from the balance sheet to the income statement where it will be reported as an expense. The entries involving deferred expenses are called adjusting entries.
---------------------------------------
Is there a default straightforward way to do handle this in Dynamics NAV? If this question was asked few weeks back my answer would have been NO. However with the latest version of Dynamics NAV 2016 this can be achieved using a separate module available. 

This blog post is not about 2016 version and it is about the previous versions and how you can handle the deferred revenue and expenses using a workaround. 

Last week me and few of my colleagues had a small discussion about this because we recently got a requirement on 
"How to recognize revenue at the time of cash receipt"

What we thought was use below setup: 

At the time of invoicing:
Dr – Customer Control Account via Customer Posting Group
Cr – Deferred Revenue Account

At the time of Cash Receipt:
Dr – Bank Account via Bank Account Posting Group
Cr – Customer Control Account via Customer posting Group

Manual Entry:
Dr - Deferred Revenue
Cr – Revenue Account


About the manual entry you can do a small modification where system post the adjustment entries at the time of applying the payment to invoice. This will be a minor modification and you can do it with a help of a NAV developer. 

This is just a workaround and if you have any other suggestions please be kind enough to post them as comments. 

Please provide your feedback with a comment. 
Thank you and Regards,
Tharanga Chandrasekara

Microsoft Dynamics NAV 2016 - New Exciting Features - Part 05

This is the fifth post of the Microsoft Dynamics NAV 2016 - New Exciting Features article series.
  • To read the first article click here
  • To read the second article click here
  • To read the third article click here
  • To read the fourth article click here
1. Try-Catch in C/AL
Now Dynamics NAV 2016 have the Try-Catch function, that return true if no error happens, and false if an error happens inside them. However it says
Changes to the database that are made with a try function are not rolled back.
Therefore I still do not want to use try-catch! I will write a separate article about the Try-Catch functionality and why I do not like to use it in my coding. 

2.Deferral Functionality
Microsoft Dynamics NAV 2016 offers the ability to automatically defer revenues and expenses over a predefined schedule, enabling companies to easily recognize revenues and expenses in periods other than the period in which the transaction is posted.
There are many blogs available regarding Deferral functionality. Check Dynamics NAV community for more info. 


3. Workflow
This one of my favorite feature available in Dynamics NAV. Nw you can trigger events as you required and have your own workflows.You might have to write your coding to change the module as you want but still it is worth! As Waldo mentioned in his blog, Workflow should be treated as a framework instead of a complete solution. 

Please provide your feedback with a comment. 

Thank you and Regards,
Tharanga Chandrasekara

Microsoft Dynamics NAV 2016 - New Exciting Features - Part 04

This is the fourth  post of the Microsoft Dynamics NAV 2016 - New Exciting Features article series.
  • To read the first article click here
  • To read the second article click here
  • To read the third article click here

01. Power BI


Power BI is now can be integrated with Dynamics NAV. With this package, users can start using and exploring their own data using PowerBI. The dashboard gives users KPIs and charts on their sales and finance data. 

PowerBI now have a separate service for Microsoft Dynamics NAV to integrate its data with PowerBI. 
With the use of new service from Power BI, users will be able to have real time data analyzing functionality.

02. CRM Integration
With the new version CRM integration is smooth and easy.

Not like last adapter for the CRM.  With the CRM integration Microsoft has added a new table type as CRM. 
All the codes are moved inside to NAV and it is just a matter of modify them using C/AL editor. 

03. Get Exchange Rates
Now exchange rates can be integrated with a external services. I am pretty sure you will already have a extended module to cater this requirement. Now it is available with out of the box! Way to go Microsoft! 

There are many other new features and lets meet in my next blog on new features of 2016! 



Please provide your feedback with a comment. 
Thank you and Regards,
Tharanga Chandrasekara