Overview of the Platform RollUp Updates

To get hold of the overview of platform rollup updates that are available for Microsoft Business Solutions - Navision 3.7 through Microsoft Dynamics NAV 5.0 you can follow this link

https://mbs.microsoft.com/knowledgebase/KBDisplay.aspx?scid=kb;en-us;940807

Printing In Custom Paper Size

This is one of the aspect that many of us actually look for during the implementation- printing Navision reports on cutom paper sizes.

The answer to the same is simple, in the report designer donot put any papersize leave the same as blank. Run the report and previow the same. Now select the print option and set the paper size in which you want to print the report from the printer dialog box or you can use the paper sixe option.

Hope this will solve your problem.

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

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.

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)

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

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)

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

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.

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)