Demand Planner For NAV

In the fast paced ear of Customer demand planing NAV provides the same with the demand planner.Demand Planner provides functionality for manufacturers and distributors of goods, helping them to effectively and efficiently establish a well-defined process for planning customer demand.

To get more information use the link given below:

https://mbs.microsoft.com/partnersource/products/navision/demandplanner.htm?printpage=false

Price List Explanation of Microsoft Dynamics NAV

Now there are various models that exists for licensing of MS Dynamics NAV. This post will help you understand some of them.

1. For New Customers

For new customers you can go for the BRL(Business Ready Licensing) or AM(Advaced Management) Licensing module. The AM consists of all the modules and hardly anything is left that the user doesnot gets in the license(but still there are things that needs to be procured additionaly like service management[not an exhaustive list]). In case of the BRL some of them are left out like Inter Company Postings and many other things.

2. For Existing customers who are not upgrading the product.

There is only one answer to this question, MBL(Module Based Licensing), select the modules that you need in the liscence and get in touch with Micrososft for the same.

3. For Existing customers who are upgrading from the older version.

Now this is a tricky situation, you can directly jump from the MBL to BRL/AM based on the customers requirement, or you can stick to the same MBL. It all depends on the requirement and cost.

If you want to have a look at the explanation of each of the granules then you can see the Explanation sheet

Problem with Refresh of forms

A few days back, I was being asked a question. There is a problem with the refreshing of the forms in Navision, here is some narration of the situation.

When the user is working is working on two forms say Form-1 and Form-2 (as you know that you can work on multiple windows at the same time in Navision) simultaneously where the records fetched and modified in Form-1 becomes a factor of computation in another form Form-2. But we sometimes notice that the form is not properly updated and hence the user feels that there is something wrong with the system.

Well there is a quite a simple solution for this type of problems. there is a property of forms in Navision, updateonactivate, so when the user returns to the form, the system automatically updates the information in the form.

Multiple Same User Login

I have came across this requirement quite some time, the basic need to enrich the security of Navision. If one user with a specific user id has logged to Navision with a terminal, then Navision allows the same user to log in to the same database using another terminal when we are using the database authentication.

Navision does have the control on concurrency but not the above stated issue. I am looking into this and hope to resolve this.

RFID Integration with MS Dynamics NAV

This is the much awaitaed document from Microsoft. RFID Integartion with Microsoft Dynamics NAV. It contains a whitepaper and a sample file which will help in understanding the integration.

NAV SP3- HF6

MS Dynamics NAV has released the HF-6 for IN localization. Some good things in this HF, You get seperate No. Series based on the Location.

Hopefully this will be something similar to my previous post..No. Series based on the responsilbility Center.

No. Series Based On Responsibility Center

We all know what is a responsibility center, and how to make use of the same. But one feature is to have a No. series based on the responsibility center.

Well here goes the way, after you go to the link provided, you can download a fob, responsibility center. When you import the same in your database, you will notice a responsibility center field in the No. series line. You will also notice a Appl. Responsibility center field in the User Register. Now assign the user with the responsibility center and define the no. series based on the responsibility center.

Do get in touch with me if you have any quesries.

Link->http://groups.google.com/group/MSDynamics-arena/web/no-series-based-on-responsibility-center

NAV 5.1 Release

The NAV 5.1 was supposed to be rleased in the last quater of 07 but now it has been deffered.

You can check out this link for more updated information.

https://mbs.microsoft.com/partnersource/downloads/releases/releasechedulenav5.htm

Creating report Links in NAV

In Microsoft Dynamics NAV you can send a link of a form/report via e-mail. This article describes how to perform the same.

This is a customized solution and requires to modify the registry and add a function on the respective table for which you want to send the link via e-mail.

https://mbs.microsoft.com/knowledgebase/KBDisplay.aspx?WTNTZSMNWUKNTMMYYUSKWOTVUNVLMRYSLZZTSSLVLTWTUSRTUTLMOVPLOSRZLZYV

(Requires Partnersource Login)

Currency Conversion in NAV

A good reading to go ahead with to understand how NAV converts foreign currency to Local currency

https://mbs.microsoft.com/knowledgebase/KBDisplay.aspx?WTNTZSMNWUKNTMMYYUSKWOTVUNVLMRYSRZYRVSWOTXYLOMNKMUTPYKTTOUWQTYWV

(Requires Partnersource Login)

Platform Rollup Update for NAV SP3

Microsoft Dynamics NAV 4.0 Service Pack 3 (SP3) is incompatible with Windows Vista and with the 2007 Microsoft Office suites a platform rollup update is available for the same and the known issues are also discussed.

https://mbs.microsoft.com/knowledgebase/KBDisplay.aspx?WTNTZSMNWUKNTMMYLSVQUSPTNTNSMQPYLPMTZVVOMOMMVUNNMKSRNMLPQZMRX

(Requires Partnersource Login)

Costing method in Manufacturing

With a lots of costing methods available in NAV for items, there are some advantages of using the Standard Costing method. Follow the link to know more on this

https://mbs.microsoft.com/knowledgebase/KBDisplay.aspx?WTNTZSMNWUKNTMMYYUSKWOTVUNVLMRYSWUURRYLUURPLRNMSYMPXWVOSTRWPWYUR

Converting Microsoft XAL to Microsoft Dynamics NAV

Planning to convert XAL to MS Dynamics NAV? Have a look at the link, this might help you

https://mbs.microsoft.com/partnersource/documentation/whitepapers/convertingxaltonav.htm?printpage=false

(Requires Partnersource Login)

Local Critical update-VAT Reports

Local critical update for the VAT reports have been released for NAV SP2 - IN version. To download the same please follow the link

https://mbs.microsoft.com/partnersource/downloads/hotfixes/microsoftdynamicsnavisionin40sp2localcriticalupdatevatreports.htm?printpage=false

(Requires Partnersource Login)

Local Critical Update - NAV SP3

Microsoft released the Local critical update for NAV SP3-IN to fix localization features release before December. To download the same please follow the link:

https://mbs.microsoft.com/partnersource/downloads/hotfixes/nav40sp3inps21632.htm?printpage=false

(Requires Partnersource Login)

NAV SP3-Feature Pack-1

With the release of NAV SP3 Microsoft has also released the Feature pack-1 for NAV SP3. To download the same, please follow the link given below:

https://mbs.microsoft.com/partnersource/downloads/hotfixes/nav40sp3in_fp1.htm?printpage=false

(Requires Partnersource Login)

Navision SP3 on Vista

Looking out for Navision SP3 on Vista, you can checkout this link which traces the compatibility of NAV SP3 on Vista

https://mbs.microsoft.com/Cms/Templates/document/General.aspx?NRMODE=Published&NRNODEGUID={1A824679-0B9B-4BA7-BF5A-C6EB77FC43B3}&NRORIGINALURL=/partnersource/products/navision/newsevents/news/msdynav40_sp3_officevistacompatb.htm?printpage=false&NRCACHEHINT=Guest&printpage=false&wa=wsignin1.0&wa=wsignin1.0

(Requires Partnersource Login)

Navision running on SQL Server 2000 or 2005 - 64 bit

MS Dynamics NAV has released the new version 5.0, but still lost of questions on whether NAV 4.0 SP1/SP2/SP3 can run on 64 bit. Earlier while using SQL with 64 bit the login used to fail, Microsoft has released the patch for the same, hence...no issues if you are looking at a solution of NAV runnig with 64 bit SQL Servers. The update is available in the link given below:

https://mbs.microsoft.com/partnersource/downloads/hotfixes/nav40w1_xpndo64bit.htm?printpage=false

(Requires Partnersource Login)

MBS Chat Room

Well, time now to get in touch with each other..not only through the various nice forums that are available on the net but also through chat...so get in touch

http://www.microsoft.com/businesssolutions/chatroom.aspx

Maps In MS Dynamics 5.0

With the release of MS Dynamics 5.0, it has made its mark with the tight integration between the office products. It also gives a feature of integration with maps. In the Administration you can define the online map setup.

After you have difined the online maps setup, you can go to the Customer card to test the maps. You will see a button like this. Click on the same and see the maps....

Happy Navigation with Navision.....

Reservations, Tracking, and Action Messages White Paper for Microsoft Dynamics NAV 5.0

This paper provides a complete overview the reservations, tracking and actions messages functionality in MS Dynamics NAV - Manufacturing 2.60 and MS Dynamics NAV. These changes also apply to version 3.70, 4.0 and 5.0.

https://mbs.microsoft.com/partnersource/documentation/whitepapers/reservationstrackingactionmessagesnav5.htm?printpage=false

(Requires Partnersource Login)

Business Analytics for 5.0

This white paper provides an overview of Business Analytics for MS Dynamics NAV 5.0. Follow the link to download the same.

https://mbs.microsoft.com/partnersource/documentation/whitepapers/businessanalyticsnav5.htm?printpage=false

(Requires Partnersource Login)

Creating XML Style Sheets for Data Export In Microsoft Dynamics NAV 5.0

This whitepaper defines the various ways of Creating XML style sheets for MS Dynamics NAV 5.0. Just follow the link:

https://mbs.microsoft.com/partnersource/documentation/whitepapers/msdynav50_xmlstylesheetsfordataexport_wp.htm?printpage=false

(Requires Partnersource Login)

Multi-Site and International Organizations Business White Paper for Microsoft Dynamics NAV

This whitepaper describes various common integration scenarios that depicts how Microsoft Dynamics NAV can help multi-site and international organizations deploy business management solutions that successfully integrates companies.

https://mbs.microsoft.com/partnersource/documentation/whitepapers/multisiteandinternationalorganizationsnav.htm?printpage=false

(Requires Partnersource Login)

NAV 4.0 system requirements

If you wish to know the various hardware requirements for Microsoft Dynamics NAV 4.0 then follow the link to know

https://mbs.microsoft.com/partnersource/products/navision/documentation/systemrequirements/sysreq400.htm

Note: (Requires Partnersource Login)

Inconsistency In G/L

This error is one of the most complex error that Navision can genereate and ofcoursely my favourite error. In this topic you will find what cused the error to be generated, what are the possible ways to look at it, and the remedy of the inconsistency error.

What is the Inconsistency In G/L error?

Normally you will encounter this kind of error in NAV 3.7 db, the latest version of 4.0 are however more equipped to handle the error well. This error occurs wile posting, irresoective of the location of posting, it has to pass through the codeunit 12 (Gen. Jnl.-Post Line). In this codeunit you will find a function called FinishCodeunit, here in this codeunit you will see a code

GLEntry.CONSISTENT( (BalanceCheckAmount = 0) AND (BalanceCheckAmount2 = 0) AND (BalanceCheckAddCurrAmount = 0) AND (BalanceCheckAddCurrAmount2 = 0));

All the entris that gets posted to the various ledgers do need to pass this check, before they can be named as posted data. If the function returns a false value then you can see an error message on your screen stating the data that you are going to post is going to make the G/L inconsistent, in other words Navision is a double entry system and the entries have to be balanced so if the dr. amt of one side is 100 the cr. amount should also be 100, if it is 99 then the G/L in inconsistent.

What if GLEntry.CONSISTENT() is commented and Forcefully made true?

You should actually never comment the GLEntry.CONSISTENT() function on the main database on the client's server. You might look at it as good solution for overcomming the consistency error and forcefully making the G/L consistency function to return true value, but after you have commented this function, none of the transactions that enter the system and make their way towards the posted documents and GL entris are going to be consistent. The finalshowdown will be most of the accounts will remain unreconciled as the balancing entries are going to be incorrect, the company receives a wrong balance sheet from the system and not to mention..the financial data is inconsistent and a Note from the auditors about the same.

What causes the error to generate?

This error is mainly generated due to the follwoing reasons:
-Trying to post single sided entry
-Rounding off Incorrect
-Some erronous customization in the posting routines
-Use of commit statement in the middle of the posting
-Due configuration issue

What To Do?

There are various ways through which you can find out what is causing the error:

-Check your configuartion for rounding off and structures
-Check your customications(if any)
-Place message boxes and have a watch at the amount field

Hopefully this will give you enough clues for handling this error. If you are still not able to solve it, rsaie a support request in Microsoft for the same.

Note: Before doing all these do ensure that it is a local database

The New MS Dynamics 5.0

Ms Dynamics 5.0 has been released with a lost of new feature in it. One of the most new feature in NAV 5.0 is the tight integration between the office components. Each and every document can be taken out in MS Word and Excel. Some of the pics will show how it looks and feels in MS Word and Excel

In MS Word

In MS Excel

What's Inside

A codeunit manages, this entire function of how to transfer these documents to word and excel, it uses the stylesheets that can be defined in NAV 5.0. The codeunit 1 Application management in 5.0 comes with added function for using this functionality.

SQL indexes rebuilt For Navision/MS Dynamics NAV

During the implementation of MS Dynmics NAV with the SQL server option, for the better performance of the system, the indexes needs to be rebuilt for the MS Dynamics NAV(Formerly known as Navision) tables. You can use the following SQL Transaction rebuild indexes:

SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
CREATE UNIQUE CLUSTERED INDEX "CompanyName$TableName$0" ON
"DatabaseName"."dbo"."CompanyName$TableName" ("Field1InPrimaryKey”,”
Field2InPrimaryKey”,…) WITH DROP_EXISTING
CREATE UNIQUE NONCLUSTERED INDEX "$SecondaryKey1" ON "DatabaseName "."dbo"."
CompanyName$TableName" ("Field1InSecondaryKey1","Field2InSecondaryKey1",…) WITH
DROP_EXISTING
CREATE UNIQUE NONCLUSTERED INDEX "$SecondaryKey2" ON "DatabaseName "."dbo"."
CompanyName$TableName" ("Field1InSecondaryKey2","Field2InSecondaryKey2",…) WITH
DROP_EXISTING
…
IF @@TRANCOUNT > 0
COMMIT TRAN

You must schedule the rebuilt of indexes for a table based on:

- Whether or not records can be deleted or modified in the table.
- Whether or not records are inserted sequentially in the index.
- The number of indexes (keys) in the table.
- The number of records in the table.

This will help you in rebuilding the indexes and provide you a better peformnace of NAV with the SQL server option.

IN Localization update for NAV 4.0 SP3 – Feature Pack -01

This Feature pack includes 13 India localization issues related to various tax areas.
Feature Pack includes following localization features :

-Voucher Interface

-Multi Location Taxes

-Service Tax as Excise Credit

-Service Tax on Advance Payment

-Gate Entry
-Additional Duty of Customs in lieu of VAT
-Excise Reports
-Excise Claim Setup and Excise Duty Settlement
-Supplementary Invoice
-Service Tax on G/L Account
-Day Books
-VAT Opening
-SHE Cess -Excise &Service tax

You can download the same from

https://mbs.microsoft.com/partnersource/downloads/hotfixes/nav40sp3in_fp1.htm?printpage=false

(This requires Partnersource Login)

Local Critical Update For MS Dynamics - Nav 4.0 SP3 IN

This release of critical updtes addresses:

This hot fix to add all localization features released up till December 2006, in version IN 4.0
SP3. The following features have been added:

1 Tax collection at Source
2. Statement of TDS
3.Direct Debit in PLA
4.Depreciation as per Indian tax laws
5.VAT on capital goods
6.VAT setoff and Refund
7.Excise on Trading Goods.
8.ER-5 and ER-6 Return
9.Fringe Benefit Tax
10.VAT report for Delhi & Maharashtra
11. Critical update for 15 corrections in application (vide bug 19363)

you can download the same from:

https://mbs.microsoft.com/partnersource/downloads/hotfixes/nav40sp3inps21632.htm?printpage=false

(Requires partnersource login)

Create Word and PDF docs in NAV/Navision

This seems to be one of the very general requirement of client during the implementation and we try to do it by writing several lines of codes, but eventually it becomes simple if the clinet has some handy softwares.

Prining in PDF

You need to have a pdf file writer for this purpose, adobe elements can give you the flexibility to print the report in a PDF format. After the report has been generated you can go to File -> Print and in the print dialog box you can select the Adobe PDF option. See pic below













Clicking on the print, prints the report directly to PDF

Reports In MS Word

After you have printed the reports in PDF word you can use Adobe professional edition to convert the same into a descent word document. To perform the same operation, you can open the pdf file and then Save as document in .DOC format. See the pic given below:

You can download the softwares from:

http://www.adobe.com/downloads/

Shrink LOG file in SQL for Navision/NAV

Sometimes the biggest hurdle with MS Dynamics NAV with SQL implementation is maintaining the transaction log. It goes bigger and bigger, the users starts feeling the system is going slow and a headache for the system administrators.

The way forward is simple:-SHRINK THE LOG FILE

Follow the steps given below to shrink the same.

1. Open the enterprise manager and connect to the db
2. Open the query analyser and issue the following commands in the SQL editor/Query analyser

DUMP TRAN [dbname] with NO_LOG;

where [dbname] is the database name

3. Execute the query, this execution would show the query successfully executed

4. Right click on the database now and select Shrink. Shrink the log file now to your desired size.

Note: If you simply try to Shrink the log file without issuing the command then the application is unable to shrink the log file and you will still face the issues.

Hope this topic proves helpful to you.

Navision 4.0 Tools CD

You can follow the lnik to download the Tools CD of NAV 4.0. It has the capability of

Translation Tools: Microsoft Dynamics NAV Localization Workbench for translating the Microsoft Dynamics NAV application.

Implementation Tools: C/AL Guide, GUI Check Tool, GUI Guide and Performance

Troubleshooting Guide and User Rights Setup Tools.

Online Help Tools: Tools for converting from WinHelp to HTML Help. Tools for WinHelp format and HTML format.

Documentation Tools: Acrobat Reader, screen capture tools and templates for manuals and training.

Upgrade Tools: Compare and Renumber Tools and Navision Developer’s Toolkit.

Link:https://mbs.microsoft.com/partnersource/products/navision/downloads/releases/mbsnavisiontoolscd40.htm?printpage=false

(Requires partnersource Login)

Migration from SQL Server 2000 to SQL Server 2005

As such there are no whitepapers available on the net. For upgrading to SQL server 2005 you can however do the following

1. Take a backup of NAV db

2.Uninstall the SQL server 2000 and the DB server of NAV(if they are on the same machine)

3. Install the SQL Server 20054. Ensure the services are running properly

4. Install the NAV db server

6. Restore the backup6. Synchronize with SQL server 2005

I believe this will suffice the migration from SQL server 2000 to 2005 for MS Dynamics NAV

you can also see some article in this link

https://mbs.microsoft.com/customersource/productsservices/products/articles/111005_tnt.htm?printpage=false

NDT Toolkits

Here you will find the set of all the toolkits from microsoft.

https://mbs.microsoft.com/partnersource/downloads/releases/ndtall.htm?printpage=false

(Requires partnersource login)

Hardening Guide for Navision 4.0

You can directly download the Hardening guide of NAV 4.0 Just follow the link

https://mbs.microsoft.com/partnersource/products/navision/downloads/releases/nav40hardening.htm?printpage=false



(This requires partnersource login)

Two Versions of Navision On Same Computer

If you want to run two versions of NAV on the same computer, there are various ways to achive the same.

1. If Older version in installed

If the older version is installed and you want to install a new version of NAV, then the installer asks you whether you want to upgrade the existing version or you want to make a fresh installation. If a fresh installation is selected then do make sure that the new installation is happening on the drive where the old version of NAV is not installed.

2. Copying the Cleint Folder

You can simply copy the client folder of any of the version on the desired location of computer and accees the fin/finsql (exe file) based on your requirement.

MS Dynamics NAV on Terminal services

Microsoft Navision Architecture

· Navision Technology Framework
· 2-Tier Architecture
· Terminal Services Environment
· N-Tier Architecture

Navision Architecture –2-Tier

· Microsoft Navision is a two-tier solution application.
· It consists of a Database Management System (DBMS) that resides on the server and a Graphical User Interface (GUI) that resides on the client.
· You can also configure the client to be a stand-alone installation, which means that the client functions as a server and a single client in one.


Navision Architecture –N-Tier

· The Navision Application Server (NAS) is a middle-tier server that supports an n-tier architecture, which executes business logic without user intervention.
· Microsoft Navision Application Server allows you to communicate with external services.
· Microsoft Navision Application Server acts as a client towards a database server and can act as a server for other services.
· Microsoft Navision Application Server can communicate with both Microsoft Navision Database Server and the SQL Server Option in the same way as a Microsoft Navision client.



Processor and Memory Subsystems

· Does it matter?

Yes it does matter, the lower the RAM the lower the processing speed, you can find more information in this section later.

· Single or Multiple Processors?

NAV supports both single and multiple processor but obviously a Multiple server does add to the processing power compared to the single processor.

· How much RAM should I use or buy?

On the server NAV recommends 2GB of RAM, the client computers can be <128Mb.

The bigger question-Bandwith?

Its like a road with busses some join in in the middle, so <64Kbps is what can be recommended. This also hold true for your VPN implementation for the ERP (NAV) package

RAID

You can go ahead with RAID 1+0, if you want more information on the levels of RAID then you can follow the link

http://www.acnc.com/raid.html

MS NAV 5.1W1 release

Time to see a new version of MS NAV 5.0. You can directly download the same from partnersource, follow the link

https://mbs.microsoft.com/partnersource/downloads/releases/microsoftdynamicsnav50.htm?printpage=false