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

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 April 2019 for details.

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 features are included in this release
    • Bank charge changes: User will be able to post bank charge invoice from bank receipt voucher where customer or vendor are included in bank charge transaction with LCY values., similarly user will be able to post bank charge credit memo from bank payment voucher where customer or vendor are included in bank charge transaction with LCY values
    • Sub-Con Changes: The quantity rejected in sub-con process are captured in sub-con receipt (posted purchase receipt line), system will capture Reject (C.E) and Reject (V.E.) against each sub-con receipt. System will also capture Applied Delivery Challan details in sub-con receipt (posted purchase receipt document)
    • TDS Changes: Transactions that are adjusted by TDS Adjustment Journal will not be considered in TDS calculation where current transaction is crossing TDS threshold amount and eligible to calculate TDS for total threshold amount.
    • Deemed Export Customer Changes: System will calculate GST Jurisdiction based on Customer state code and Location state code, hence system will calculate CGST and SGST for deemed export customer for intrastate and IGST for interstate jurisdiction. Earlier system is calculating only IGST for deemed exports customers.

Reference Information


Reference No.

302608, 303520, 305701, 306704

Product Area

Financial Management

Discovered in

Microsoft Dynamics NAV 2016 IN

Title

  • IN GST_GL entries related to Bank Charges posted through Bank receipt voucher are incorrect_NAV 2016
  • IN GST_Ability to calculate CGST/SGST for the goods sold by an Deemed Export within state_NAV 2016
  • IN GST_Amount must be Negative in Gen. Journal Line Journal Template Name : XX, Journal Batch Name : YY and Line No : 0_NAV 2016
  • IN GST_System to capture rejected material details in posted purchase receipt lines_NAV 2016

Released on

28 Mar 2019 

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 41

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

Table

16456

Posted Applied DeliveryChallan.

RIMDX

Page

16635

Posted Applied DeliveryChallan

R-MDX

Objects


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

Type

No.

Name

Added/Modified

Codeunit

12

Gen. Jnl.-Post Line

Modified

Codeunit

17

Gen. Jnl.-Post Reverse

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

5980

Service-Post

Modified

Codeunit

16360

Subcontracting Post

Modified

Codeunit

16401

GST Management

Modified

Codeunit

16403

GST Application Management

Modified

Codeunit

16508

Tax Journal Management

Modified

Page

25

Customer Ledger Entries

Modified

Page

136

Posted Purchase Receipt

Modified

Page

137

Posted Purchase Rcpt. Subform

Modified

Page

16520

Journal Bank Charges

Modified

Page

16521

Posted Jnl. Bank Charges

Modified

Page

16571

Journal Voucher

Modified

Page

16617

Posted Jnl. Bank Charges Prev.

Modified

Page

16627

Update Reference Invoice No

Modified

Page

16630

Update Reference Inv. Journals

Modified

Page

16635

Posted Applied DeliveryChallan

Added

Table

37

Sales Line

Modified

Table

38

Purchase Header

Modified

Table

39

Purchase Line

Modified

Table

81

Gen. Journal Line

Modified

Table

121

Purch. Rcpt. Line

Modified

Table

179

Reversal Entry

Modified

Table

5900

Service Header

Modified

Table

5902

Service Line

Modified

Table

13729

TDS Entry

Modified

Table

13735

Posted Jnl. Bank Charges

Modified

Table

16419

Detailed GST Ledger Entry

Modified

Table

16456

Posted Applied DeliveryChallan

Added

Table

16470

Reference Invoice No.

Modified

Table

16511

Jnl. Bank Charges

Modified

Codeunit

17

Gen. Jnl.-Post Reverse

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

5980

Service-Post

Modified

Codeunit

16360

Subcontracting Post

Modified

Codeunit

16401

GST Management

Modified

Codeunit

16403

GST Application Management

Modified

Codeunit

16508

Tax Journal Management

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

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

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 TDS Receivable Account

Type: Code 20

GST TCS Receivable Account

Type: Code 20

GST TCS Payable Account

Type: Code 20

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

 

New Setup Tables:

GST TDS/TCS Setup

 Field

Description

GST Component Code

Type: Code 10

Effective Date

Type: Date

GST TDS/TCS %

Type: Decimal

GST Jurisdiction

Option

Options are: Intrastate, Interstate

Type

Option

Options are: ,TDS,TCS

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.