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

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 included in this Release

The following are included in CU 31
- Different GST Group and HSN/SAC Codes in Advance Payment and Invoices
  
  Note: The details published in ATA report for adjustment of adjustment scenario is not handled in this release, this will be delivered in upcoming releases.
- Calculating GST with ARN

Reference Information

Reference No.	226057, 257810
Product Area	Financial Management
Discovered in	Microsoft Dynamics NAV 2016 IN
Title	Different GST Group and HSN/SAC Codes in Advance Payment and Invoices, Calculating GST with ARN
Released on	26 Apr 2018

Important Notice to Customers

We recommend that you contact your Microsoft Dynamics Partner before installing 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 your Microsoft Dynamics solutions.

Important Notice to Partners

As per the SPA, it is non-compliant 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're not enrolled, Partners will need 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 30

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

Licensing

The following objects have been added through this update. Licensing refresh is required.

Type	No.	Name	Permissions
Report	16418	Update GST Registration No	R-MDX

Objects

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

Type	No.	Name	Added/Modified
Table	18	Customer	Modified
Table	21	Cust. Ledger Entry	Modified
Table	23	Vendor	Modified
Table	36	Sales Header	Modified
Table	37	Sales Line	Modified
Table	38	Purchase Header	Modified
Table	81	Gen. Journal Line	Modified
Table	221	Gen. Jnl. Allocation	Modified
Table	222	Ship-to Address	Modified
Table	224	Order Address	Modified
Table	5740	Transfer Header	Modified
Table	5900	Service Header	Modified
Table	5902	Service Line	Modified
Table	13730	Party	Modified
Table	16324	Delivery Challan Line	Modified
Table	16412	Detailed GST Entry Buffer	Modified
Table	16419	Detailed GST Ledger Entry	Modified
Table	16424	GST Liability Line	Modified
Report	16410	GSTR-1 File Format	Modified
Report	16418	Update GST Registration No	Added
Codeunit	11	Gen. Jnl.-Check Line	Modified
Codeunit	12	Gen. Jnl.-Post Line	Modified
Codeunit	80	Sales-Post	Modified
Codeunit	16401	GST Management	Modified
Codeunit	16403	GST Application Management	Modified
Codeunit	16405	GST Input Tax Credit	Modified
MenuSuite	1030	Dept - Country	Modified
Page	21	Customer Card	Modified
Page	26	Vendor Card	Modified
Page	39	General Journal	Modified
Page	160	Sales Statistics	Modified
Page	161	Purchase Statistics	Modified
Page	232	Apply Customer Entries	Modified
Page	253	Sales Journal	Modified
Page	254	Purchase Journal	Modified
Page	256	Payment Journal	Modified
Page	283	Recurring General Journal	Modified
Page	300	Ship-to Address	Modified
Page	368	Order Address	Modified
Page	397	Sales Invoice Statistics	Modified
Page	402	Sales Order Statistics	Modified
Page	403	Purchase Order Statistics	Modified
Page	5740	Transfer Order	Modified
Page	5741	Transfer Order Subform	Modified
Page	13735	Parties	Modified
Page	16414	Detailed GST Ledger Entry Prev	Modified
Page	16419	Detailed GST Ledger Entry	Modified
Page	16602	GST Distribution	Modified
Page	16624	GST Adjustment Journal	Modified

Setup

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

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.

Partners - Global Support Contacts (requires Partner Source login)
Customers - Global Support Contacts (requires Customer Source login)

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.