Sunday, June 28, 2015

Expected Cost Posting in Microsoft Dynamics NAV

Expected cost posting to GL is a beautiful functionality available in the Microsoft Dynamics NAV, But it seems many people have not understand this functionality well enough. 
Expected cost is an estimation that you would have before you get the final invoice from your vendor. This functionality allows you to have a interim accrual for the purchase before you get the actual invoice to your hand to update the G/L with the actual cost. 

How default functionality works without expected cost posting : 

Microsoft Dynamics NAV will only update the inventory at the time of receiving the purchase order and will NOT post any entries to G/L accounts. 
While updating the inventory, Dynamics NAV will post entries to Value Entry table. 

As an example if the item cost is USD 100 then value entry would like below :

Without expected cost posting - After Receiving Order (Value Entry)
Posting Date
Cost Amount (Expected)
Cost Amount (Actual)
Cost Posted to G/L
Expected Cost Posted to G/L
Cost per Unit
1/28/2016
100.00
0
0
0
100

If you navigate to the receipt document and check the related entries, you will find there are no G/L entries attached to the document. 

Once you post the Purchase Invoice with the actual cost (Cost changes to USD 120), Dynamics NAV will post entries to the G/L and Value Entry with the related cost.
Following are the entries posted to Value Entry: 
Without expected cost posting - After Invoicing (Value Entry)
Posting Date
Cost Amount (Expected)
Cost Amount (Actual)
Cost Posted to G/L
Expected Cost Posted to G/L
Cost per Unit
1/28/2016
-100.00
120.00
120.00
0
120.00

Following are the entries posted to G/L Entry:
Without expected cost posting - After Invoicing (G/L Entry)
Posting Date
G/L Account No.
Account Name
Amount
1/28/2016
2130
Inventory Account
120.00
1/28/2016
7291
Direct Cost Applied Account
-120.00

How Expected Cost Posting works

With the Expected Cost Posting set to Yes in the Inventory Setup, Microsoft Dynamics NAV will post entries to G/L at the time of receiving the order. Where earlier case it only update the inventory of the system.  
Following are the entries posted to Value Entry: (Expected cost is USD 100)
With expected cost posting - After Receiving Order (Value Entry)
Posting Date
Cost Amount (Expected)
Cost Amount (Actual)
Cost Posted to G/L
Expected Cost Posted to G/L
Cost per Unit
1/28/2016
100.00
0
0
100.00
100.00

Following are the entries posted to G/L Entry:
With expected cost posting - After Receiving Order (G/L Entry)
Posting Date
G/L Account No.
Account Name
Amount
1/28/2016
2131
Inventory Account (Interim)
100.00
1/28/2016
5530
Inventory Accrual Account (Interim)
-100.00

At the time of posting the purchase invoice, Microsoft Dynamics NAV will reverse the expected cost posted entries from the G/L and post the new entries to G/L with the actual cost. 

Following are the entries posted to Value Entry: (Cost changes to USD 120)
With expected cost posting - After Invoicing (Value Entry)
Posting Date
Cost Amount (Expected)
Cost Amount (Actual)
Cost Posted to G/L
Expected Cost Posted to G/L
Cost per Unit
1/28/2016
-100.00
120.00
120.00
-100.00
120.00


With expected cost posting - After Invoicing (G/L Entry)
Posting Date
G/L Account No.
Account Name
Amount
1/28/2016
2131
Inventory Account (Interim)
-100.00
1/28/2016
5530
Inventory Accrual Account (Interim)
100.00
1/28/2016
2130
Inventory Account
120.00
1/28/2016
7291
Direct Cost Applied Account
-120.00


To achieve above scenario you need to select the Automatic Cost Posting check box and the Expected Cost Posting to G/L check box in the Inventory Setup window.

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

Monday, June 22, 2015

How to check Microsoft Dynamics NAV build : Service Tier

If you want to check the build of RTC and Development environment please refer below articles. 
To check the service build, open the Microsoft Dynamics NAV 2015 Administration and Select the instance. 

In the right side view you can see the service build. 

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

How to check Microsoft Dynamics NAV build : Development Environment

If you have different build for the development environment, client environment and service tier you might get into some problems, mainly when you try to save and compile tables.
I have already posted a post on how to check the build of RTC client and Service Tier.

Follow below steps to check the build of the Microsoft Dynamics Environment,
Method 01
01. Open Development Environment. 
02. Go to Help menu
03. Click on the "About Microsoft Dynamics NAV Development Environment"
04. In the second line of the screen you can see the Development environment build. 

Method 02
01. Open the exe location ( Default Location : C:\Program Files (x86)\Microsoft Dynamics NAV\80\RoleTailored Client) 

02. Go to properties of the .exe file
03. Go to Details tab of the properties and check the File version :


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

How to check Microsoft Dynamics NAV build : RoleTailored Client

It is always good to have same builds in the every tier of Microsoft Dynamics NAV. Next question comes in is how to check the build,
If you want to check the build of Service Tier and Development environment please refer below articles.
You can view the RTC build using two methods, 

Method 01.
01. Open RTC client 
02. Help -> About Microsoft Dynamics NAV

03. In the third line you can see the build of the RTC client of Microsoft Dynamics NAV. 


Method 02
01. Open the exe location ( Default Location : C:\Program Files (x86)\Microsoft Dynamics NAV\80\RoleTailored Client) 
02. Go to properties of the .exe file
03. Go to Details tab of the properties and check the File version :

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

Thursday, June 18, 2015

How to save request page value for next run

Default reports of Microsoft Dynamics NAV will save the request page values and allow the user to modify them in the next run of the report. However when a developer develop a new report it will not save the last run value of the request page. I saw few threads in the Dynamics NAV community forum regarding this. 

This is how you modify the report to save the request page values. 

+ Open the report in the developer environment and go to Request page.
   View -> Request Page


+ Go to the properties of the request page. 
In order to do that Click on the last line of the Request Page and click on the properties icon in the toolbar or press Shift +F4.

+ Set the Save Value Property to YES. 

+ Compile and Save the report. 

Thats it you are ready to go and hope this would help you and your clients in future. 

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

Friday, June 12, 2015

Best Practices Tips and Tricks for Upgrading to Dynamics NAV 2013 R2 or Dynamics NAV 2015

If you are planing to upgrade your current Microsoft Dynamics NAV version to Microsoft Dynamics NAV 2013 R2 or to NAV 2015, refer the article posted by Microsoft Dynamics NAV team. It will provide you best practices, tips and tricks for the upgrade. 

 When you follow a guide and best practices you can always avoid mistakes that can be happen and also save lot of your valuable time. 

Click here to view the blog post from Microsoft Dynamics NAV team. 

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

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

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

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 20

You can download the cumulative update from KB 3069271 – Cumulative Update 20 for Microsoft Dynamics NAV 2013 R2 (Build 41371).

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:
Overview of Released Application Hotfixes for Microsoft Dynamics NAV 2013 R2
Overview of Released Platform Hotfixes for Microsoft Dynamics NAV 2013 R2

PartnerSource
Overview of Released Application Hotfixes for Microsoft Dynamics NAV 2013 R2
Overview of Released Platform Hotfixes for Microsoft Dynamics NAV 2013 R2

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

Cumulative Update 8 for Microsoft Dynamics NAV 2015 has been released

Cumulative Update 8 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 this cumulative update 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 8

You can download the cumulative update from KB 3069272 – Cumulative Update 8 for Microsoft Dynamics NAV 2015 (Build 41370).

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 Chandrasekar

Cumulative Update 27 for Microsoft Dynamics NAV 2013 has been released

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

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 27

You can download the cumulative update from KB 3069230 - Cumulative Update 27 for Microsoft Dynamics NAV 2013 (Build 41354).

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:
Overview of Released Application Hotfixes for Microsoft Dynamics NAV 2013
Overview of Released Platform Hotfixes for Microsoft Dynamics NAV 2013

PartnerSource:
Overview of Released Application Hotfixes for Microsoft Dynamics NAV 2013
Overview of Released Platform Hotfixes for Microsoft Dynamics NAV 2013

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

Thursday, June 4, 2015

How to freeze your computer using Microsoft Dynamics NAV

Total credit for this should goes to one of my team members, 

You need to write a very small code to achieve this. 
warning : Once you execute below code, you might have to manually restart the computer, so think twice before executing.

 MyRec.RESET;   
  IF MyRec.FINDFIRST THEN REPEAT   

  UNTIL FALSE;  
Seacret of this remains in the last line of the code. 
In compilers view last line will look like below


 UNTIL (IF Value = TRUE);  

That means loop will get executed as long as condition output value is false, and as the condition gets true, compiler will jump out of the loop and execute the rest of the code. 

If we provide a condition which will never going to get true, then this will turn into a infinite loop and will result in using all the resource available in the computer. 

This is a very small fact and just wanted to share, since it is bit interesting. 

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

Tuesday, June 2, 2015

Reset Auto Increment field in Microsoft Dynamics NAV Tables

How to change the current value of an auto increment field? Is it possible without dropping the table? Yes it is possible.
In order to do that you have to use SQL command called DBCC CHECKIDENT

Following is the syntax of the DBCC CHECKIDENT command.



DBCC CHECKIDENT ( <table_name> [ , { NORESEED | { RESEED [, <new_reseed_value> ] } } ] )[ WITH NO_INFOMSGS ]
table_nameIs the name of the table for which to check the current identity value. The table specified must contain an identity column. Table names must comply with the rules foridentifiers.NORESEEDSpecifies that the current identity value should not be changed.RESEEDSpecifies that the current identity value should be changed.new_reseed_valueIs the new value to use as the current value of the identity column.WITH NO_INFOMSGSSuppresses all informational messages.
To set the IDENTITY column of a table to start from 1, use the following statement :
Use [Database NAV] 
GO
DBCC CHECKIDENT ([Table Name], RESEED,0);
GO

By executing the above code you will reset the auto increment number to 0, therefore next number will be 1. That means the number you setting + 1.

You need to have following permission, in order to execute the above code :  

Caller must own the table OR member of sysadmin, db_owner or db_ddladmin fixed database role groups. 



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