MS Dynamics NAV on VSAT

Recently I have been engaged in an assignment where I had to access MS Dynamics NAV through VSAT. Till date I have seen implementations with Dial-up connection,Broadband, or leased line but this was the first of its kind. To have some more knowledge about the vsat you can follow the following link
http://en.wikipedia.org/wiki/Very_small_aperture_terminal
During the testing phase of this connectivity, I also tried to connect to the server directly with the client without using Citrix, the results were horrible. Please don't even try to perform the same for testing purpose also.

Secondly, We used citrix to connect to the NAV from the various remote locations. The Microsoft Dynamics NAV 4.0 SP3 was used with SQL Server 2005 to have the database server. Another server was configured which is used as the citrix server which is being acessed from the various remote ocations to login to MS Dynamics NAV. What I specifically want to discuss out here in this post is, the latency time taken to connect to the database compared to the other media such as dial-up, broad band etc with the VSAT.

Generally the connection is quite slow with 512kbps of line, opening up the login screen and entering into the database requires 10-15 secs of time, while navigation between the panes may differ from 5 to 7 secs. What I observed during this entire testing process is the posting of the various documents that are present in the NAV. The time taken to create the documents may differ from user to used based on the aquintence of the system, but the posting routines to my surprise takes the same time as you do the same in the client server architecture.

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)

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)

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.

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/

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)