How to Stop/Prevent Negative Inventory

I have seen these kind of requests a lot from developers/end-users in NAV forums.

In earlier versions we have to customize NAV to achieve this but NAV2013R2 brings this feature as standard.

We can set up that outbound posting that brings inventory below zero is blocked. This can be set up per item or for all items. 

This setup is in the Inventory Setup, we can put a check mark in Prevent Negative Inventory field which specifies if you can post transactions that will bring inventory levels below zero.

The selection that you make in this field indicates the value in the Prevent Negative Inventory field on individual item cards. The values will either be Default (Yes) or Default (No), which you can change.

I know have setup this for all Items i.e., in Inventory Setup and when I try to post an Item which has in sufficient Inventory then I got below error.

Microsoft Dynamics NAV

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

You have insufficient quantity of Item 1000 on inventory.

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

OK

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

NAV MVP's @ NAV TechDays 2013‏

Find the group picture taken at NAV TechDays 2013, from all Dynamics NAV MVP’s that could make it.

From left to right: Mark Brummel, Alain Krikilion, Eric Wauters, Kamil Sacek, Luc Van Dyck, David Singleton (with Aussie hat), Michael Nielsen (Director of Development for Dynamics NAV at Microsoft), Jörg Stryk, Vjekoslav Babic, Luc van Vugt (uppermost), Mohana Krishna Yadav, Andrey Panko, Arend-Jan Kauffmann, Gunnar Gestsson.

About NAV2013R2

Last Edited on: 22-10-2013
-------------------------------------------------------------------------------------------
To Create a New Company:

Go to CRONUS International Ltd./Departments/Administration/IT Administration/General/Companies in RTC

Click New and Enter the Company name.
We can also use Copy function in Action to Copy the Company.

In NAV2013R2 we have to create companies from RTC only and not form Dev Environment.

We can also create form powershell command "New-NAVCompany"
------------------------------------------------------------------------------------------
we need to restore database in NAV2013R2 using Powershell Cmdlets like
New-NAVDatabase -FilePath <DatabaseBAKfile> -DatabaseName <MyNavDatabase> -DatabaseInstance <DatabaseInstance> DatabaseServer <DatabaseServer> ServiceAccount <ServiceAccount>

<DatabaseBAKfile> so we need a SQL Backup file (BAk) for this.

If you have an earlier version, such as Microsoft Dynamics NAV 5.0 or Microsoft Dynamics NAV 4.0, you must first upgrade that version to Microsoft Dynamics NAV 2013.
-----------------------------------------------------------------------------------------
To design report layouts, Microsoft Visual Studio 2012 Professional, Premium, or Ultimate, or Microsoft SQL Server Report Builder for Microsoft SQL Server 2012, Microsoft SQL Server Report Builder for Microsoft SQL Server 2012 SP1, or Microsoft SQL Server 2008 R2 Report Builder 3.0 is required.

If you just want to do some changes and you didnt have VS2012 then you can set Use Report Builder to yes under
Tools-->Options in Development Environment and rdlc layout will be opened in SQL2012 Report Builder 3.0 which is installed by default with NAV2013R2.
-------------------------------------------------------------------------------------------

Backup of Database:
we can take backup of database in NAV2013R2 using Powershell Cmdlets like
Backup-SqlDatabase -Database "Demo Database NAV (7-1)" -ServerInstance VPS16239\NAVDEMO -BackupAction Database

The above command will create backup files in
C:\Program Files\Microsoft SQL Server\MSSQL11.NAVDEMO\MSSQL\Backup
--------------------------------------------------------------------------------------------
If you install NAV 2013 R2 next to existing NAV 2013 RTM build then NAV2013R2 Administrator Console will work.
But, when you want to open the Dynamics NAV Administration Console for NAV 2013 wont work:
Solution: Repair NAV2013 version after installing NAV2013R2.
---------------------------------------------------------------------------------------------

Once you open NAV2013 Database with NAV2013R2 Development Environment for Client Upgrade, We need to manually Compile all objects.
---------------------------------------------------------------------------------------------

Microsoft Dynamics NAV 2013 R2: Download Page

Microsoft Dynamics NAV 2013 is a landmark release, building on a strong product foundation to deliver new levels of customer and partner value through faster, more efficient implementations, compelling new and enhanced application functionality, and unparalleled levels of customer choice on how to deploy and access the solution.

The Microsoft Dynamics NAV 2013 R2 reflects Microsoft’s long-term commitment to the NAV partner community and adds significant new value for our small and midsized customers in the following areas:

• Great interoperability with Office 365 breaks down the walls between business data and how people get work done. Microsoft Dynamics NAV can now be deployed as an application to on-premises and cloud-based SharePoint sites, with single sign on and a consistent look and feel across the Microsoft Dynamics NAV Web client and Office 365. Deeper data integration capabilities will enable customers to extend Microsoft Dynamics NAV business processes with SharePoint workflows and Web parts, and take full advantage of Microsoft Excel and the Excel Web App.
• Enhanced cash management capabilities will help customers better manage risk and drive business growth with features such as automatic and manual payment processing, bank reconciliation tools, and support for SEPA direct debit and credit transfer.
• Powerful usability enhancements across both the Web and Windows clients make Microsoft Dynamics NAV even simpler to use and faster to deploy. A restyled user experience aligned with Office 365 makes it even easier for people to access, view and edit business data and processes.
• Continued commitment to deploying Microsoft Dynamics NAV on Windows Azure Infrastructure Services (available in Microsoft Dynamics NAV 2013 Feature Pack 1 release).

You can find the download page here

Microsoft Dynamics NAV 2013 R2 download links
Download	Microsoft Dynamics NAV 2013 R2
AU-Australia	Download
AT-Austria	Download
BE-Belgium	Download
CA-Canada	Download
DK-Denmark	Download
FI-Finland	Download
FR-France	Download
DE-Germany	Download
IS - Iceland	Download
IN-India	Download
IT-Italy	Download
MX-Mexico	Download
NL-Netherlands	Download
NZ-New Zealand	Download
NO-Norway	Download
ES-Spain	Download
SE-Sweden	Download
CH-Switzerland	Download
GB-Great Britain	Download
US-United States	Download
W1	Download

MVP Award - 2013

Just now got an email informing that my MVP Status is renewed, so here starts the 3rd year as MVP.

Today, 977 exemplary community leaders around the world were notified that they have received the MVP Award! These individuals were chosen because they have demonstrated their deep commitment to helping others make the most of their technology, voluntarily sharing their passion and real-world knowledge of Microsoft products with the community.

While there are more than 100 million social and technical community members, only a small portion are selected to be recognized as MVPs. Each year, around 4,000 MVPs are honored. They are nominated by Microsoft, other community individuals, or in some cases themselves. Candidates are rigorously evaluated for their technical expertise, community leadership, and voluntary community contributions for the previous year. They come from more than 90 countries, speak over 40 different languages, and are awarded in more than 90 Microsoft technologies. Together, they answer more than 10 million questions a year!

MVPs are recognized each quarter for this annual award, which continues to grow and evolve to reflect the development of Microsoft technologies.

Congratulations to the new MVPs, and welcome back to renewed MVPs. We are very excited to recognize your amazing accomplishments!

Style Sheet Tool for Microsoft Dynamics NAV2013

The Style Sheet Tool for Microsoft Dynamics NAV2013 is available in Mibuso Downloads Section.
http://mibuso.com/dlinfo.asp?FileID=1543

The Style Sheet Tool for Microsoft Dynamics NAV2013 enhances the Style Sheet feature in Microsoft Dynamics NAV 2013 by allowing you to easily and without programming knowledge create and modify style sheets in Microsoft Office Word.

Changes to Style Sheet tool for NAV 2013.

1.Multi-multiline support is added, so it is now possible to add several multiline records to the style sheet. Note though that records can not be indented, but added sequentially.

2.Setup page is modified to add Open/Save/Send options.

3.In NAV 2009, codeunit 50000 was released for automatic integration of the Style Sheet functionality with pages. Pages were then exported in xml format and modified by running codeunit 50000, to add style sheet actions.

This no longer works for NAV2013, as export /import of objects in xml format is no longer an option. Hence, adding Style Sheet Action (button) to each page must be done manually.

Follow the example below when adding the style sheet action to a page:

i. Add the action to the action designer (under appropriate group) with following properties:

Expanded Type SubType Name Caption
0 Action <Action680> Style Sheets

ii. OnAction trigger should contain following line:

StyleSheetDataMgt.LoadStylesheetDataRTC(GETPOSITION,CURRENTKEY,PAGE::"");

where StyleSheetDataMgt is a variable of type codeunit, 682 (Style Sheet Data Management). 

Fixed No. of Lines in NAV 2013 RTC Reports

The Objectives of this video are:

 1.      Review a typical NAV 2013 reports preview.

 2.      Modify the report to show fixed No. of lines

 3.      Run the report to review the changes.

Please note that I have used Report 205 = Order Confirmation report in this demo.

The functions created in Visual Studio are

public Shared DocumentNo as Object
public Shared FixedLenth as integer
public Shared prevOutputNo as integer

Public Function SetDocLength(NewData as boolean,Group as object,Outputno as integer )
  If (NOT NewData) AND (prevOutputNo = OutputNo) AND (DocumentNo = Group) Then
      FixedLenth = FixedLenth + 1
  ELSE
      FixedLenth = 0
  End If
 DocumentNo = Group
 prevOutputNo = OutputNo
End Function

Public Function GetDocLength( ) As Integer
  Return FixedLenth
End Function

Expression Added in Invisible text box is

=Code.SetDocLength((Iif(Fields!Type_SalesLine.Value = " ", true, false)),Fields!No_SalesHeader.Value,Fields!OutputNo.Value)


You can also watch video at

Post by Mohana - Dynamics NAV.