Select Page

GST – Goods and Service Tax Implementation for NAV 2013 – Phase 3 – India

Two days back, Microsoft has released GST Updates Phase 3 for Microsoft Dynamics NAV 2013 – India

Direct download links:

NAV2013INRelease3 [14.8 MB – ZIP]


Features included in this Release

  • Settlement (based on Credit flow changes)

  • Input Service Distribution Transactions (based on Credit flow changes)

  • Input Service Distribution (Distribution part)

  • Changes in Credit Note linking with Invoice Purchase import & Credit Memo – calculation based on assessable value.

  • Same HSN in multiple groups

  • Associate enterprises vendors for Goods invoices

  • Customer Type – SEZ units & SEZ development

  • Vendor type – SEZ

  • GSTR 1 file format

  • GSTR 3B Rate Slab (GST rate per quantity)

  • Advance payment application in combination with GST & TDS / TCS

Features excluded in this Release

  • As per rules released in Jul’17, there are substantial changes in following features and will be delivered in Nov’17 release.

      • GSTR returns file formats (3, 6 & 8)

      • GST on Bank Charges

      • To calculate IGST when transferring Items from bonded warehouse

      • Credit Memo without Application

      • Cost Amount (Actual) is incorrect in the Value Entries created

      • Location Code is mandatory for advance and normal payments

      • GST Group Type = Item for Type = G/L Account in Document lines

      • Different GST Group and HSN/SAC Codes in Advance Payment and Invoices

Announcing the Preview of Development Tools for Microsoft Dynamics NAV – Recording on YouTube

Yesterday, a very good webinar on Preview of Development Tools for Microsoft Dynamics NAV has been delivered by NAV Skills and team. If you haven’t got chance to attain it then you can find full recording of this session on YouTube.

Many thanks to @LucVanVugt, @MarkBrummel, @DanielRimmelzwaan,@Waldo and @ErikHougaard for sharing such a good knowledge base.

With Dynamics 365 for Financials which shares platform capabilities with Dynamics NAV Microsoft is introducing a new development platform. This webinar introduces the concepts and shares experiences about the preview.

Looks very promising future of Microsoft AL in Visual Studio Code…

Microsoft AL | AL language code samples for developing extensions for Dynamics NAV

Last week Microsoft launched code sample HelloWorld repo for developing extensions to Dynamics NAV. This is just a overview of how we will develop in future using #VisualStudioCode. This repo contains AL language code samples for developing extensions on the Dynamics NAV platform.

Some screens from AL language code sample.




First public preview is available now and you can download it from The full version of this new Visual Studio Code development environment is available on this Christmas. Mean while you can download the sample and stay updated…

Microsoft Dynamics NAV now compatible with Microsoft SQL Server 2016

SQL Server 2016 released in June this year with many new and interesting capabilities. For further information, please take a look at the product information at this location:

Over the last few months, the Dynamics NAV team has been testing compatibility with this new version of SQL Server, and we are now proud to announce that

  • Microsoft Dynamics NAV 2016,
  • Microsoft Dynamics NAV 2015,
  • Microsoft Dynamics NAV 2013 R2, and
  • Microsoft Dynamics NAV 2013

are compatible with the SQL Server 2016 database engine. This applies to the following editions of SQL Server:

  • Express Edition
  • Standard Edition
  • Enterprise Edition

Microsoft Dynamics NAV 2017 will be compatible with SQL Server 2016 at launch.

Note: For reports, please do not install the SQL Server 2016 SSRS components, as these currently will not work with Dynamics NAV RDLC reports. For more information, see the system requirements for reports in Dynamics NAV 2016.

Microsoft Dynamics NAV 2017 Limited Beta

Microsoft Dynamics NAV 2017 Limited Beta is available for Download.

In order to install and run Microsoft Dynamics NAV 2017 Limited Beta, you must review documents bellow:

  • Microsoft Dynamics NAV 2017 – Limited Beta – Third Party Notice  – download
  • Microsoft Dynamics NAV 2017 – Use of Terms – download
  • Microsoft Dynamics NAV 2017 – What is new – download
  • Microsoft Dynamics NAV 2017 – Release notes – download

To download the Microsoft Dynamics NAV 2017 Limited Beta, please click here

GST India – Goods & Service Tax


Goods and Service Tax is being glorified as a system of taxation by which economy will take an upward swing and further it will ease the trade and industry with respect to the indirect tax system of the country. “Only one” indirect tax has to be paid by the trade and industry and all the other indirect taxes will be subsumed in GST.

What is GST?

GST is a consumption based tax levied on sale, manufacture and consumption on goods & services at a national level. This tax will be substitute for all indirect tax levied by state and central government. Exports and direct tax like income tax, corporate tax and capital gain tax will not be affected by GST. GST would apply to all goods other than crude petroleum, motor spirit, diesel, aviation turbine fuel and natural gas. It would apply to all services barring a few to be specified. With the increase of international trade in services, GST has become a global standard. The proposed tax system will take the form of “dual GST” which is concurrently levied by central and state government.

This will comprise of:

  • Central GST (CGST) which will be levied by Centre
  • State GST (SGST) Which will be levied by State
  • Integrated GST (IGST) – which will be levied by Central Government on inter-State supply of goods and services.

Many taxes has been subsumed under GST which are as under

Central Indirect Taxes &


Central Excise Duty
Additional Excise Duties
Excise Duty levied under the

Medicinal Preparations (Excise

Duties) Act, 1955

Service Tax
Additional Customs Duty (CVD)
Special Additional Duty of


Central Surcharge and Cess
State Indirect Taxes &


VAT / Sales Tax
Entertainment tax (other than

the tax levied by local bodies)

Central Sales Tax
Octroi and Entry Tax
Purchase Tax
Luxury Tax
Taxes on Lottery
Betting and Gambling
State Cesses and Surcharges


Who will pocket taxes?

  • For Intra State Transactions: In case of Intra State transactions, Seller collects both CGST & SGST from the buyer and CGST needs to be deposited with Central Govt. and SGST with State Govt.
  • For Inter State Transactions: Integrated Goods and Service Tax (IGST) shall be levied on Inter State transactions of goods and services which are based on destination principle. Tax gets transferred to Importing state. More over it is proposed to levy an additional tax on supply of goods, not exceeding one percent, in the course of inter-state trade or commerce, to be collected by the Central Govt. for a period of two years, and assign to the States where the supply originates. Valuation of stock transfers to be determined. Exports and Supplies to SEZ units will be zero rated.

Setoff of IGST, CGST & SGST will be as follows in the below mentioned chronological order only.

Credit of To be Adjusted with

What impact GST will have on pricing of products as compared to current scenario?

Let us take an EXAMPLE to understand this clearly.


In the above example, you can note that the tax paid on sale within state can be claim against tax paid on sale outside state in GST system, which is not in present tax system.

The credit of CGST cannot be taken against SGST and credit of SGST cannot be taken against CGST but both credits can be taken against IGST.


  • NSDL has been appointed to incubate the GST Portal and develop its functionality. NSDL has created a pilot portal known as “GST Pilot Portal”
  • Here, every tax payer will be issued a 15 digit common identification number which will be called as “Goods & Service Tax Identification Number” (GSTIN) a PAN based number.
  • Online application form for dealers will be available to provide their details and upload documents.
  • Registration includes basic steps like register themselves on the Enrolment page, and then Login using the given “User ID” and “password”, filling the application form by uploading the requisite documents related to excise, Service Tax, IEC, CIN, Professional Tax number, Shops & Establishment Number and any other state specific registration numbers, contact numbers, postal address & E-mail address of business entity, bank account details including MICR code, place of business, details of goods & services, scanned signed photographs.

Like, every coin has two sides, even this concept of GST has its own positives and negatives, we leave on the reader to decide for them the impact of GST whether on micro or macro level.

Positive Aspects

  1. The main reason to implement GST is to abolish the cascading effect on tax. A product on which excise duty is paid can also be liable for VAT. Suppose a product A is manufactured in a factory. As soon as it releases from factory, excise duty has to be paid to central government. When that product A is sold in same state then VAT has to be paid to state government. Also no credit on excise duty paid can be taken against output VAT. This is termed as cascading effect since double tax is levied on same product.
  2. The GST is being introduced to create a common market across states, not only to avoid enfeebled effect of indirect tax but also to improve tax compliance.
  3. GST will lead a more transparent and neutral manner to raise revenue.
  4. Price reduction as credit of input tax is available against output tax.
  5. Simplified and cost saving system as procedural cost reduces due to uniform accounting for all types of taxes. Only three accounts; CGST, SGST, IGST have to be maintained.
  6. GST is structured to simplify the current indirect system. It is a long term strategy leading to a higher output, more employment opportunities, and economic boom.
  7. GST is beneficial for both economy and corporations. The reduced tax burden on companies will reduce production cost making exporters more competitive.

Negative Aspects

  1. GST is being referred as a single taxation system but in reality it is a dual tax in which state and centre both collects separate tax on a single transaction of sale and service.
  2. At present the main Indirect tax system of central Government is central excise. All the goods and commodities are not covered by the central excise and further there is an exemption limit of Rs. 1.50 Crores in the central excise and further traders are not liable to pay central excise. The central excise is payable up to the stage of Manufacturing but now GST is payable up to the stage of sale.
  3. Majority of dealers are not covered with the central excise but are only paying VAT in the state. Now all the Vat dealers will be required to pay “Central Goods and service tax”.
  4. The calculation of RNR (Revenue Neutral Rate) is very difficult and further Govt. wants to enhance its revenue hence rate of Tax will be a problem. As per the News reports the proposed rate for State GST is 12% and Central GST is 14% Plus Govt. wants to impose 1% CST at the initial stage of GST on the interstate sale of Goods and services. So the normal rate of overall tax will be 26%. This rate is very high comparing to the fact that small and medium Industries are at present not covered by the central excise and most of the Goods such as agricultural products are out of the preview of the Central Excise.
  5. Improvement in the Manufacturing and distribution of Goods and service, increase in exports, various reforms, check on corruption, less Government control are some of the factors which are responsible for the economic growth of the country. A tax system can make a revolution in the economy of the country is “rarest of the rare” thing.