GST (Goods and Service Tax) for the Indian version of Microsoft Dynamics NAV 2016 CU 30

Applies To
Dynamics NAV 2016

Government is planning to introduce a new Tax called 'Goods & Service Tax (GST)' from 01-Jul-2017. Goods and Service Tax (GST) is an indirect tax levied on supply of goods or services or both. See GST White Paper Mar 2018 for details.

GST overview

Proposed GST

  • Goods and Service Tax (GST) is an indirect tax levied on supply of goods or services or both.
  • It is a destination/consumption based tax levy which is payable in the state in which the goods and services are consumed.
  • It is levied and collected on value addition at each stage of production or distribution process (all points in supply chain).
  • The supplier can avail credit on input tax credit paid on procurement of goods or services.

Components of GST

Component Levied by Applicable on
Central GST (CGST) Centre Intra-state supply of goods or services in India.
State GST (SGST) States Intra-state supply of goods or services in India
Integrated GST (IGST) Centre Inter-state supply of goods or services, Exports and Imports.

Goods outside Gamut of GST

  • Petroleum products and Alcohol for human consumption are proposed to be kept out of purview of GST. Petroleum products will be brought into GST network at a later stage.
  • Central Excise duty will continue on petroleum products. States will continue to impose sales tax on sale within the state on petroleum products and alcohol for human consumption.
  • Tobacco products will be subject to Excise duty along with GST.

Features that are included in this Release

  • The following features were released as Out of band after CU 27, these are included in CU 30

    • GST in Journals
    • Vendor supplies goods/service from multiple Locations each having separate GST Registration for documents
    • Services from Unregistered Vendor
    • Advance Payment Exempted for GST Group Type Goods modifications
    • GST to be calculated based on the State code of Place of Supply in Documents
    • IGST should be calculated for Registered Vendors only in Documents
    • Adjust GST credit for written off inventory
    • Location Code is mandatory for advance and normal payments
  • Additional features that are included in CU 30

    • GST to be calculated based on the State code of Place of Supply in Journals
    • IGST should be calculated for Registered Vendors only in Journals
    • Separate Nos. Series for posted Reverse Charge Invoices for Registered Vendors
    • Vendor supplies goods/service from multiple Locations each having separate GST Registration for Journals
    • TDS be deducted in Payment if it is not deducted in Invoice

Reference Information

Reference No. 251533, 225136
Product Area Financial Management
Discovered in Microsoft Dynamics NAV 2016 IN
Title IN_GST_TDS deducted in Payment if it is not deducted in Invoice, IN_GST_ Separate Nos. Series for posted Reverse Charge Invoices for Registered Vendors
Released on 28 Mar 2018

Important Notice to Customers

We recommend that you contact the Microsoft Dynamics Partner before you install service packs or hotfixes. It is important to verify that your environment is compatible with the service pack(s), hotfix(es), or download(s) being installed. A service pack, hotfix, or download may cause interoperability issues with customizations, and third-party products that work with the Microsoft Dynamics solutions.

Important Notice to Partners

As per the SPA, it is noncompliant for partners to redistribute tax and regulatory updates to ERP customers not enrolled in the Business Ready Enhancement Plan. Partners can verify their customer’s status in VOICE. If they are not enrolled, Partners have to get them current before they can distribute.

Installation

Before this update can be installed, the following prerequisites are required:

  • Microsoft Dynamics ® NAV 2016 IN CU 27

Note:

If a customer has customizations in any objects involved in this regulatory feature, they might require your special attention.

Licensing

Refresh your license to access the new objects that are added with this release.

Objects

The following object have been added/modified through this release:

Type No. Name Added/Modified
Table 14 Location Modified
Table 17 G/L Entry Modified
Table 21 Cust. Ledger Entry Modified
Table 23 Vendor Modified
Table 25 Vendor Ledger Entry Modified
Table 36 Sales Header Modified
Table 37 Sales Line Modified
Table 38 Purchase Header Modified
Table 39 Purchase Line Modified
Table 49 Invoice Post. Buffer Modified
Table 80 Gen. Journal Template Modified
Table 81 Gen. Journal Line Modified
Table 83 Item Journal Line Modified
Table 110 Sales Shipment Header Modified
Table 112 Sales Invoice Header Modified
Table 114 Sales Cr.Memo Header Modified
Table 120 Purch. Rcpt. Header Modified
Table 121 Purch. Rcpt. Line Modified
Table 122 Purch. Inv. Header Modified
Table 123 Purch. Inv. Line Modified
Table 124 Purch. Cr. Memo Hdr. Modified
Table 125 Purch. Cr. Memo Line Modified
Table 179 Reversal Entry Modified
Table 221 Gen. Jnl. Allocation Modified
Table 224 Order Address Modified
Table 232 Gen. Journal Batch Modified
Table 242 Source Code Setup Modified
Table 312 Purchases & Payables Setup Modified
Table 5107 Sales Header Archive Modified
Table 5109 Purchase Header Archive Modified
Table 5110 Purchase Line Archive Modified
Table 5900 Service Header Modified
Table 5902 Service Line Modified
Table 5990 Service Shipment Header Modified
Table 5992 Service Invoice Header Modified
Table 5994 Service Cr.Memo Header Modified
Table 6650 Return Shipment Header Modified
Table 6651 Return Shipment Line Modified
Table 6660 Return Receipt Header Modified
Table 13730 Party Modified
Table 16324 Delivery Challan Line Modified
Table 16412 Detailed GST Entry Buffer Modified
Table 16418 GST Ledger Entry Modified
Table 16419 Detailed GST Ledger Entry Modified
Table 16422 Adv. GST Calculation Buffer Modified
Table 16457 Posted GST Liability Adj. Modified
Table 16458 GST Liability Buffer Modified
Table 16459 GST Liability Adjustment Modified
Table 16462 GST Tracking Entry Modified
Table 16463 GST Journal Template Modified
Table 16464 GST Journal Batch Modified
Table 16465 GST Journal Line Modified
Table 16466 GST Adjustment Buffer Modified
Table 16467 Jnl. Alloc. GST Calc. Buffer Modified
Report 16410 GSTR-1 File Format Modified
Report 16416 Update Reg.No. Posted Doc. Modified
Report 16417 GST Tracking Entries Modified
Codeunit 11 Gen. Jnl.-Check Line Modified
Codeunit 12 Gen. Jnl.-Post Line Modified
Codeunit 13 Gen. Jnl.-Post Batch Modified
Codeunit 17 Gen. Jnl.-Post Reverse Modified
Codeunit 22 Item Jnl.-Post Line Modified
Codeunit 74 Purch.-Get Receipt Modified
Codeunit 80 Sales-Post Modified
Codeunit 90 Purch.-Post Modified
Codeunit 101 Cust. Entry-SetAppl.ID Modified
Codeunit 103 Cust. Entry-Edit Modified
Codeunit 111 Vend. Entry-SetAppl.ID Modified
Codeunit 113 Vend. Entry-Edit Modified
Codeunit 227 VendEntry-Apply Posted Entries Modified
Codeunit 230 GenJnlManagement Modified
Codeunit 5705 TransferOrder-Post Receipt Modified
Codeunit 5986 Serv-Amounts Mgt. Modified
Codeunit 5987 Serv-Posting Journals Mgt. Modified
Codeunit 16401 GST Management Modified
Codeunit 16403 GST Application Management Modified
Codeunit 16405 GST Input Tax Credit Modified
Codeunit 16508 Tax Journal Management Modified
MenuSuite 1030 Dept - Country Modified
Page 26 Vendor Card Modified
Page 39 General Journal Modified
Page 41 Sales Quote Modified
Page 42 Sales Order Modified
Page 43 Sales Invoice Modified
Page 44 Sales Credit Memo Modified
Page 49 Purchase Quote Modified
Page 50 Purchase Order Modified
Page 51 Purchase Invoice Modified
Page 52 Purchase Credit Memo Modified
Page 54 Purchase Order Subform Modified
Page 55 Purch. Invoice Subform Modified
Page 138 Posted Purchase Invoice Modified
Page 140 Posted Purchase Credit Memo Modified
Page 160 Sales Statistics Modified
Page 161 Purchase Statistics Modified
Page 232 Apply Customer Entries Modified
Page 233 Apply Vendor Entries Modified
Page 253 Sales Journal Modified
Page 254 Purchase Journal Modified
Page 256 Payment Journal Modified
Page 279 Source Code Setup Modified
Page 283 Recurring General Journal Modified
Page 284 Allocations Modified
Page 344 Navigate Modified
Page 368 Order Address Modified
Page 397 Sales Invoice Statistics Modified
Page 400 Purchase Invoice Statistics Modified
Page 402 Sales Order Statistics Modified
Page 403 Purchase Order Statistics Modified
Page 460 Purchases & Payables Setup Modified
Page 5703 Location Card Modified
Page 5900 Service Order Modified
Page 5933 Service Invoice Modified
Page 5935 Service Credit Memo Modified
Page 6630 Sales Return Order Modified
Page 6640 Purchase Return Order Modified
Page 13735 Parties Modified
Page 16396 GST Credit Adjustment Modified
Page 16414 Detailed GST Ledger Entry Prev Modified
Page 16419 Detailed GST Ledger Entry Modified
Page 16569 Bank Receipt Voucher Modified
Page 16570 Contra Voucher Modified
Page 16571 Journal Voucher Modified
Page 16576 Cash Payment Voucher Modified
Page 16577 Bank Payment Voucher Modified
Page 16579 Cash Receipt Voucher Modified
Page 16618 GST Liability Adjustment Modified
Page 16619 GST Liability Adj. Journal Modified
Page 16620 Posted GST Liability Adj. Modified
Page 16621 GST Journal Templates Modified
Page 16622 GST Journal Batches Modified
Page 16623 GST Journal Template List Modified
Page 16624 GST Adjustment Journal Modified
Page 16625 GST Adjustment Detail Modified
Page 16626 GST Tracking Entry Modified

Setup

  1. New Setup fields added in existing Tables
Table Field Description
Company Information GST Registration No. Type: Code 15
General Ledger Setup GST Rounding Precision Type: Decimal
GST Rounding Type Type: Option
Options are Nearest, Up, Down
Purch. A/C for Job Work Liab. Type: Code 20
IGST Payable A/c in Import Type: Code 20
GST Recon. Tolarance Type: Decimal
GST Credit Adj. Jnl Nos. Type: Code 10
GST Distribution Nos. Type: Code 10
GST Settlement Nos. Type: Code 10
GST Inv. Rounding Precision Type: Decimal
GST Inv. Rounding Type Type: Option
GST Inv. Rounding Account Type: Code 20
State State Code for GST Reg. No. Type: Code 2
Structure Details Type Type: Option
Inc. GST in TDS Base Type: Boolean
GST Dependence Type Type: Option
Options are – , Bill-to Address, Ship-to Address, Location Address
Sales & Receivable Setup Posted Inv. Nos. (Exempt) Type: Code 10
Posted Cr. Memo Nos. (Exempt) Type: Code 10
Posted Inv. No. (Export) Type: Code 10
Posted Cr. Memo No. (Export) Type: Code 10
Posted Inv. No. (Supp) Type: Code 10
Posted Cr. Memo No. (Supp) Type: Code 10
Posted Inv. No. (Debit Note) Type: Code 10
Posted Inv. No. (Non-GST) Type: Code 10
Posted Cr. Memo No. (Non-GST) Type: Code 10
Purchase & Payable Setup Posted Purch. Inv. For Unreg. Vendor Type: Code 10
Posted Purch. Cr. Memo (Unreg.) Type: Code 10
Posted Purch. Inv. Nos. (Unreg. Supplementary) Type: Code 10
Posted Purch. Inv. Nos. (Unreg. Debit Note) Type: Code 10
RCM Exemp. for Un-Reg. Ven. Start Date Date
RCM Exemp. for Un-Reg. Ven. End Date Date
Cr. & Libty Adj. Journal No. Type: Code 10
Purch. Inv. Nos. (Reg) Type: Code 10
Purch. Inv. Nos. (Reg Supp) Type: Code 10
Pur. Inv. Nos.(Reg Deb.Note) Type: Code 10
Purch. Cr. Memo Nos. (Reg) Type: Code 10
Location Setup GST Liability Invoice Type: Code 10
GST Input Service Distributor Type: Boolean
Purch. Inv. Nos. (Unreg) Type: Code 10
Purch. Cr. Memo Nos. (Unreg) Type: Code 10
Purch. Inv. Nos. (Unreg Supp) Type: Code 10
Pur. Inv. Nos.(Unreg Deb.Note) Type: Code 10
GST Transfer Shipment No. Type: Code 10
Posted Dist. Invoice Nos. Type: Code 10
Posted Dist. Cr. Memo Nos. Type: Code 10
Purch. Inv. Nos. (Reg) Type: Code 10
Purch. Inv. Nos. (Reg Supp) Type: Code 10
Pur. Inv. Nos.(Reg Deb.Note) Type: Code 10
Purch. Cr. Memo Nos. (Reg) Type: Code 10
Source Code Setup GST Liability - Job Work Type: Code 10
GST Receipt - Job Work Type: Code 10
Service Transfer Shipment Type: Code 10
Service Transfer Receipt Type: Code 10
GST Credit Adjustment Journal Type: Code 10
GST Settlement Type: Code 10
GST Distribution Type: Code 10
GST Adjustment Journal Type: Code 10
Unit of Measure GST Reporting UQC Type: Code 10
Return Reason GST Reporting Reason Code Type: Option
<Blank>, Interstate, Intrastate

 

  1. New Setup Tables:
  • GST Registration No. table
Field Description
State Code Type: Code 10
Code Type: Code 15
Description Type: Text 30
GST Input Service Distributor Type: Boolean
  • GST Accounting Period table
Field Description
Starting Date Type: Date
Ending Date Type: Date
Year Closed Type: Boolean
  • GST Accounting Sub-Period table
Field Description
Accounting Period Starting Date Type: Date
Starting Date Type: Date
Name Type: Text 10
New Financial Year Type: Boolean
Due Date for Outward Supplies Returns (GSTR-1) Type: Date
Due Date for Inward Supplies Returns (GSTR-2) Type: Date
Due Date for Monthly returns (GSTR-3) Type: Date
Due Date for Input Service Distributor Type: Date
Due Date for TDS Type: Date
GST Payment Due Date Type: Date
Date Locked Type: Boolean
Closed Type: Boolean

 

 

  • GST Component table
Field Description
Code Type: Code 10
Description Type: Text 50
GST Jurisdiction Type: Option
Options are Intrastate, Interstate
Include Base Type: Boolean
Formula Type: Code 250
Dropdown to Component table
If any component is selected then it shall calculate on the value of the component selected.
Calculation Order Type: Integer
Report View Type: Option… <Blank>,CGST,SGST / UTGST,IGST,CESS
Non-Availment Type: Boolean
  • GST Group table
Field Description
Code Type: Code 10
Description Type: Text 250
GST Group Type Type: Option
Options are Goods, Service
GST Place Of Supply Type: Option
Options are (Blank) ,Bill-to Address, Ship-to Address, Location Address
Reverse Charge Type: Boolean
  • GST Posting Setup table
Field Description
State Code Type: Code 10
Dropdown from State table
GST Component Code Type: Code 10
Dropdown from GST Component table
Receivables Account Type: Code 20
Dropdown to G/L Account table
Payable Type: Code 20
Dropdown to G/L Account table
Receivables Account (Interim) Type: Code 20
Dropdown to G/L Account table
Payables Account (Interim) Type: Code 20
Dropdown to G/L Account table
Expenses Account Type: Code 20
Dropdown to G/L Account table
Refund Account Type: Code 20
Dropdown to G/L Account table
Receivable Distribution (Interim) Account Type: Code 20
Dropdown to G/L Account table
Receivable Distribution Account Type: Code 20
Dropdown to G/L Account table
GST Credit Mismatch Account Type: Code 20
Dropdown to G/L Account table
  • GST Claim Setoff table
Field Description
GST Component Type: Code 10
Lookup to GST Component
Priority Type: Integer
User will manually update the number
Set Off Component Type: Code 10
Lookup to GST Component
  • GST Configuration table
Field Description
Type Type: Options
Option are Vendor, Customer
Dispatch / Receiving State Code Type: Code 10
Dropdown from State table
Customer / Vendor State Code Type: Code 10
Dropdown from State table
GST Jurisdiction Type: Option
Options are Intrastate, Interstate This field shall be auto updated, Intrastate shall be updated if Dispatch / Receiving State Code field value and Customer / Vendor State Code field is same else Interstate. If any one state code is blank then Interstate shall be updated.
GST % Sate Code Type: Code 10
Dropdown from State table
  • GST Details table
Field Description
GST % State Code Type: Code 10
Dropdown from State table
GST Group Code Type: Code 20
Dropdown from GST Group table
GST Component Code Type: Code 10
Dropdown from GST Component table
Effective Date Type: Date
User needs to mention the Effective date
GST Component % Type: Decimal
User needs to mention the GST percentage
Include Base Type: Boolean
Formula Type: Code 250
Dropdown to GST Component table
GST Jurisdiction Type: Option
Options are: Intrastate, Interstate
Calculation Order Type: Integer
  • GST Recon. mapping
Field Description
GST Component Code Type: Code 10
Dropdown from GST Component
GST Reconciliation field No. Type: Integer
GST Reconciliation field Name Type: Text 30
ISD ledger field No. Type: Integer
ISD ledger field Name Type: Text 30
  • GST Component Distribution
Field Description
GST Component Code Code 10
GST Components shall be selected from drop down
Distribution Component Code Code 10
GST Components shall be selected from drop down
Intrastate Distribution Boolean
Intrastate Distribution Boolean
  • GST Setup
Field Description
GST State Code Type: Code 10
Dropdown from State table
GST Group Code Type: Code 20
Dropdown from GST Group table
GST Component Code Type: Code 10
Dropdown from GST Component table
Effective Date Type: Date
User needs to mention the Effective date
GST Component % Type: Decimal
User needs to mention the GST percentage
Include Base Type: Boolean
Formula Type: Code 250
Dropdown to GST Component table
If any component is selected then it shall calculate on the value of the component selected.
Calculation Order Type: Integer
Threshold Amount Type: Integer
Before Threshold % Type: Decimal
User needs to mention the GST percentage before crossing Threshold Limit
Component Calc. Type Type: Option
Options are: Blank, General, Threshold, Cess %, Cess % + Amount/Unit Factor, Cess % Or Amount/Unit Factor Whichever Higher and Amount/Unit Factor
Cess Amount Per Unit Factor Type: Decimal
Cess UOM Type: Code 250
Dropdown to Units of Measure table
Cess Factor Quantity Type: Decimal
Non-Availment Type: Boolean
  • GST Component Distribution
Field Description
GST Component Code Code 10
GST Components shall be selected from drop down
Distribution Component Code Code 10
GST Components shall be selected from drop down
Intrastate Distribution Boolean
  • Bank Charge Deemed Value Setup
Field Description
Bank Charge Code Type: Dropdown
To provide dropdown to Bank Charges Master
Mandatory Field
Lower limit Type: Decimal
Upper limit Type: Decimal
Mandatory Field
Formula Type: Option
Deemed%/Fixed/Comparative/Fixed+Deemed %/Fixed+Comparative
Min. Deemed Value Type: Decimal
Max Deemed Value Type: Decimal
Deemed % Type: Decimal
Fixed Amount Type: Decimal
  • GST Journal Template
Field Description
Name Type: Code 10
Description Type: Text 80
Page ID Type: Integer
Type Type: Option (‘ ‘ , ‘GST Adjustment Journal’)
Source Code Type: Code 10
Reason Code Type: Code 10
Page Name Type: Text 80
Bal. Account Type Type: Option (‘G/L Account’, ’Customer’, ’Vendor’, ’Bank Account’)
Bal. Account No. Type: Code 20
No. Series Type: Code 10
Posting No. Series Type: Code 10
  • GST Journal Batch
Field Description
Journal Template Name Type: Code 10
Name Type: Code 10
Description Type: Text 50
Reason Code Type: Code 10
Bal. Account Type Type: Option (‘G/L Account’, ’Customer’, ’Vendor’, ’Bank Account’)
Bal. Account No. Type: Code 20
No. Series Type: Code 10
Posting No. Series Type: Code 10
Template Type Type: Option (‘ ‘ , ‘GST Adjustment Journal’)
Location Code Type: Code 10
Source Code Type: Code 10

Support Information

If you are experiencing issues downloading the install file or documentation, please contact ITMBSSUP@microsoft.com.

For technical support questions, contact your partner or, if enrolled in a support plan directly with Microsoft, you can enter a new support request to Microsoft Dynamics® Technical Support from Customer Source or Partner Source under Support >> New Support Request.

You can also contact Microsoft Dynamics® Technical Support by phone using these links for country specific phone numbers.

Linguistic Quality Feedback

Thank you for taking the time to give us your feedback. It will be used to evaluate the linguistic quality of the translated Dynamics NAV user interface and make improvements if needed.

Please use this feedback link to provide your feedback to the below questions.

Q1: Which language and version of the product are you working on?

Q2: What is your role in your organization / company?

Q3: Is the used terminology correct for your market/locale?

Q4: Please include any other feedback you may have on the linguistic quality of the product.

Privacy Statement: Microsoft is committed to protecting your privacy, while delivering software that brings you the performance, power, and convenience you desire in your personal computing. This privacy statement explains the data collection and use practices. It does not apply to other online or offline Microsoft sites, products, or services.

If you choose to provide feedback about the linguistic quality of this regulatory feature, then your email address and any additional information that you choose to provide will be included. We will only use your feedback data to help improve the linguistic quality. Microsoft will not contact you to further investigate your feedback or to ask you for more information. Your email address will be removed from our systems after 90 days.