Thursday, 16 April 2015

Block Postings



This might be ‘the oldest trick in the book’ but it is still a frequently asked question and therefor I thought it was worth a small blog post.

The question is how do you block/prevent users from posting something in Microsoft Dynamics NAV?

This is actually quite easy. Dynamics NAV has a feature that allows you to limit the dates you can post on by setting a start and ending date, so all you need to do is to set the start date to be after the end date and nothing can be posted. It is that easy!:-)

The dates are set in the General Ledger Setup table using the allowed posting from and allowed posting to fields. Something like below will block posting in Dynamics NAV (since 3/1/15 is after 2/28/15).

General-Ledger-Setup-Dynamics-NAV

Now when you try to post something you will get an error message like below.

Posting-Error-Dynamics-NAV

Also note that you have the same two fields in the user setup table. If users are setup in this table (and they should not be allowed to post) then you need to either have those fields set the same way or be blank on each of the user (if they are blank Dynamics NAV will use the setup in the General Ledger Setup table).

User-Setup-Dynamics-NAV

Preventing posting in a company this way is very useful in some cases. It could for example be that you are implementing Dynamics NAV and prior to go-live you want users to work on master data and orders but not post anything, this will allow this.
 

Thanks  olof simren( http://www.olofsimren.com/) for sharing this information.

Regards,
Sathish.C


Cumulative Update 6 for Microsoft Dynamics NAV 2015 has been released


Cumulative Update 6 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 6 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 6
You can download the cumulative update from KB 3052226 – Cumulative Update 6 for Microsoft Dynamics NAV 2015 (Build 40459). 

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.


Thanks & Regards,
Sathish C

Cumulative Update 25 for Microsoft Dynamics NAV 2013 has been released



Cumulative Update 25 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 25
You can download the cumulative update from KB 3051268 - Cumulative Update 25 for Microsoft Dynamics NAV 2013 (Build 40468).

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

Thanks & Regards,
Sathish C

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


Cumulative Update 18 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 18

You can download the cumulative update from KB 3052269 – Cumulative Update 18 for Microsoft Dynamics NAV 2013 R2 (Build 40452).
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

Regards,
Sathish

Wednesday, 28 January 2015

Keeping Leading Zeros while exporting to excel

While exporting the data to excel in NAV 2009, i faced a different problem.

I have a value for "Vendor Bank Acc. No." = 00027928.

But while exporting to excel the leading zero's will automatically deleted and displayed as 27928.(Its default excel functionality).

And the workaround for above problem is : put a ' before your field so Excel treats it as text.

EnterCell(Row, Column, '''' + "Vendor Bank Acc. No.", FALSE, FALSE, FALSE); 


add the '''' + before the field (4 single quotes).

Wednesday, 17 December 2014

Visual Studio Error

This morning I faced a problem while opening layout of the report from development environment, it shows the below error:


---------------------------
Microsoft Visual Studio
---------------------------
No exports were found that match the constraint:
    ContractName    Microsoft.VisualStudio.Utilities.IContentTypeRegistryService
    RequiredTypeIdentity    Microsoft.VisualStudio.Utilities.IContentTypeRegistryService
---------------------------
OK  
---------------------------


Solution:

 
I solved this problem by clearing Visual Studio Component Model Cache.

Just delete or rename this folder:

%AppData%\..\Local\Microsoft\VisualStudio\11.0\ComponentModelCache
 
or

%AppData%\..\Local\Microsoft\VPDExpress\11.0\ComponentModelCache 
  For Visual Studio 2013, change the version number:

%AppData%\..\Local\Microsoft\VisualStudio\12.0\ComponentModelCache 
  Restart Visual Studio.

Hope this will help

UPDATE

Possible Location to Refer- C:\Users\uXXX12\AppData\Local\Microsoft\VisualStudio\11.0