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

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

The following are included in this release

  • TDS calculation in Advance Payment
  • Validation of GSTIN and PAN_2016
  • GST Rounding account entries
  • HSN code not mandatory for Advance Payment
  • Changes in GSTR1 & 3B reports

Reference information


Reference No.

271872, 278713, 277710, 272835, 278464

Product Area

Financial Management

Discovered in

Microsoft Dynamics NAV 2016 IN

Title

IN_GST_TDS on Advance Payment_2016,  IN_GST_Validation of GSTIN and PAN_2016, IN_GST_Incorrect G/L entries created after applying hotfix from TFS 274475_2016, IN_GST_HSN code not mandatory for Advance Payment _2016, IN_GST_Changes in GSTR1,2 & 3B reports_2016

Released on

30 Aug 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 34

Note:

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

Licensing


Licensing refresh is required.

Objects


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

Type

No.

Name

Added/Modified

Table

14

Location

Modified

Table

18

Customer

Modified

Table

23

Vendor

Modified

Table

36

Sales Header

Modified

Table

37

Sales Line

Modified

Table

38

Purchase Header

Modified

Table

39

Purchase Line

Modified

Table

79

Company Information

Modified

Table

81

Gen. Journal Line

Modified

Table

222

Ship-to Address

Modified

Table

224

Order Address

Modified

Table

232

Gen. Journal Batch

Modified

Table

270

Bank Account

Modified

Table

291

Shipping Agent

Modified

Table

302

Finance Charge Memo Header

Modified

Table

5741

Transfer Line

Modified

Table

5900

Service Header

Modified

Table

5902

Service Line

Modified

Table

13730

Party

Modified

Table

16400

GST Registration Nos.

Modified

Report

16410

GSTR-1 File Format

Modified

Codeunit

11

Gen. Jnl.-Check Line

Modified

Codeunit

12

Gen. Jnl.-Post Line

Modified

Codeunit

80

Sales-Post

Modified

Codeunit

90

Purch.-Post

Modified

Codeunit

103

Cust. Entry-Edit

Modified

Codeunit

395

FinChrgMemo-Issue

Modified

Codeunit

5704

TransferOrder-Post Shipment

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

Page

39

General Journal

Modified

Page

46

Sales Order Subform

Modified

Page

47

Sales Invoice Subform

Modified

Page

50

Purchase Order

Modified

Page

51

Purchase Invoice

Modified

Page

54

Purchase Order Subform

Modified

Page

55

Purch. Invoice Subform

Modified

Page

254

Purchase Journal

Modified

Page

256

Payment Journal

Modified

Page

5745

Posted Transfer Receipt

Modified

Page

6631

Sales Return Order Subform

Modified

Page

6641

Purchase Return Order Subform

Modified

Page

16571

Journal Voucher

Modified

Page

16576

Cash Payment Voucher

Modified

Page

16577

Bank Payment Voucher

Modified

Page

16627

Update Reference Invoice No

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.
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.