Windows Server 2008 Compatibility with NAV

Microsoft Dyanmics NAV is compatibile with Windows Server 2008. People who are using Business Gateway and Comerce gateway need to update the solution with article
KB Article 56161.

Super Roles In SQL Server 2005 WITH MS Dynamics NAV SP3

The Super role of Microsft Dyanmics NAV contains all the permissions for the objects and system related activities in Microsft Dyanmics NAV. But when the same super role is being alloted to a user is SQL Server 2005 then you will notice the following scenarios:
Case -1:
The database is being restored and users are defined in the SQL Server 2005, and the same users are defined in the database logins in MS Dynamics NAV and the security is synchronized. Lets take two users user A and User B where user A is the dbo owner/sysadmin in SQL Server 2005 and in Navision the role assigned to the both the user A & B is SUPER. After the roles are assigned and the security is synchornized you wioll noticve that both the user/s A and B are able to acess all the object in NAV SP3(includes customized objects). Well till now you will feel that the super role in MS Dynamics NAV SP3 proprietory database is same as that of the NAV database in SP3.

Case-2:
Create a new object (table in which the client license permits to access the table say the obhect id is 50,000). Now import the object into the NAV Dtabase in SQL Server 2005. Now login to the system using the User A. You will notice that the user is able to access the table 50000. After you have verfied with the permission to the table of 50000 with the User-A, login using the user -B. Go tO the Object designer and try to run the object. The system will say that you donot have permission to the Object 50000.

Now you can see that both the users have been assigned the SUPER role but one of the user which not the dbo owner in SQL Server 2005 will not be able to have the acess. In SQL Server 2005 with NAV SP3 everytime you import a object ensure you run a Security Synchronize, as even the SUPER role (which is not the dbo owner/sysadmin in SQL SERVER 2005)will not be able to gain access to the objects.

Reversal Entry Posting Date

Most of the customers do complain about the same, here is the situation. The customer passes several journals in a month and at the end of the month its month closing which the management reviews and internal audfit of the same is carried ofut. Take for example the organization passes 5000 journals in the month of January and for which the accounts have been finalized. In the month of March it come to notice that out of 5000 entries 2000 entries are wrong and needs to be reversed. Microsoft Dynamics NAV 4.0 SP3 provides the provision to reverse the journal entries, but when this functionality is used it reverses the entries exactly on the date in which the entries were being posted implies that date of posting=date of reversal.

This raises a question at the time of internal/external audit as the accounts have been finalized for that month and eventually the entries are being reversed on a seperate date, having a misleading information in the system. If the question asked when the entry was reversed, we will not have an answer to the same.

To cater to this situation I have done a simple modification, in NAV SP3. This allows the user the user to reverse the entries, but the posting date of the reversed entries are based on the workdate as set in the application.

You can download the file from the following link.
http://groups.google.com/group/MSDynamics-arena/files

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

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)

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)