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