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

Applies to: Dynamics NAV 2016

Summary


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 December 2018 for details.

GST overview

·         Proposed GST

o   Goods and Service Tax (GST) is an indirect tax levied on supply of goods or services or both.

o   It is a destination/consumption based tax levy which is payable in the state in which the goods and services are consumed.

o   It is levied and collected on value addition at each stage of production or distribution process (all points in supply chain).

o   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:

o  Petroleumproducts and Alcohol for human consumption are proposed to be kept out ofpurview of GST. Petroleum products will be brought into GST network at a laterstage.

o  CentralExcise duty will continue on petroleum products. States will continue to imposesales tax on sale within the state on petroleum products and alcohol for humanconsumption.

o  Tobaccoproducts will be subject to Excise duty along with GST.

Features included in this Release

The following features are included in this release:

·         GST Rate change: The provision for handling rate change is provided in system, if user create an invoice after rate change, but wish to create with previous rate without changing posting date, this feature will help user to create such invoices.

·         Item tracking in GST Adjustment Journals: The GST Adjustment Journal is enhanced with item tracking feature, provision of selecting Item tracking in GST Adjustment Journals is provided, and user can select Lot No. or Serial No. while executing GST Adjustment Journal.

·         GST TDS (released as out of band earlier, included in this CU)

·         GST TCS (released as out of band earlier, included in this CU)

·         ARN number in Location (released as out of band earlier, included in this CU)

·         Provision to upload GST Opening balances (released as out of band earlier, included in this CU)

 

Reference Information


Reference No.

281118, 278582

Product Area

Financial Management

Discovered in

Microsoft Dynamics NAV 2016 IN

Title

IN_GST_Lot No required at the time of GST Adjustment Journal_2016

IN_GST_GST Rate differs in Advance payment received and in Sales Invoice_2016

Released on

28 Nov 2018 

Important notice


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 36

Note: 

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

Objects


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

Type

No.

Name

Added/Modified

Codeunit

11

Gen. Jnl.-Check Line

Modified

Codeunit

12

Gen. Jnl.-Post Line

Modified

Codeunit

17

Gen. Jnl.-Post Reverse

Modified

Codeunit

19

Gen. Jnl.-Post Preview

Modified

Codeunit

80

Sales-Post

Modified

Codeunit

90

Purch.-Post

Modified

Codeunit

5986

Serv-Amounts Mgt.

Modified

Codeunit

16401

GST Management

Modified

Codeunit

16403

GST Application Management

Modified

Codeunit

16405

GST Input Tax Credit

Modified

Codeunit

5704

TransferOrder-Post Shipment

Modified

Codeunit

5705

TransferOrder-Post Receipt

Modified

Codeunit

6620

Copy Document Mgt.

Modified

Codeunit

99000830

Create Reserv. Entry

Modified

MenuSuite

1030

Dept - Country

Modified

Page

1

Company Information

Modified

Page

232

Apply Customer Entries

Modified

Page

233

Apply Vendor Entries

Modified

Page

255

Cash Receipt Journal

Modified

Page

256

Payment Journal

Modified

Page

344

Navigate

Modified

Page

5703

Location Card

Modified

Page

16406

GST Posting Setup

Modified

Page

16414

Detailed GST Ledger Entry Prev

Modified

Page

16419

Detailed GST Ledger Entry

Modified

Page

16434

Pay GST

Modified

Page

16569

Bank Receipt Voucher

Modified

Page

16576

Cash Payment Voucher

Modified

Page

16577

Bank Payment Voucher

Modified

Page

16579

Cash Receipt Voucher

Modified

Page

16627

Update Reference Invoice No

Modified

Page

16628

GST TDS/TCS Setup

Modified

Page

16629

GST TDS/TCS Entry

Modified

Page

16631

Update GST TDS Certificate Dtl

Modified

Page

16632

Update GST TDS Cert. Details

Modified

Page

16633

GST TDS/TCS Entry Prev

Modified

Page

39

General Journal

Modified

Page

42

Sales Order

Modified

Page

43

Sales Invoice

Modified

Page

44

Sales Credit Memo

Modified

Page

50

Purchase Order

Modified

Page

51

Purchase Invoice

Modified

Page

52

Purchase Credit Memo

Modified

Page

132

Posted Sales Invoice

Modified

Page

138

Posted Purchase Invoice

Modified

Page

140

Posted Purchase Credit Memo

Modified

Page

253

Sales Journal

Modified

Page

254

Purchase Journal

Modified

Page

5900

Service Order

Modified

Page

5933

Service Invoice

Modified

Page

5935

Service Credit Memo

Modified

Page

5972

Posted Service Credit Memo

Modified

Page

5978

Posted Service Invoice

Modified

Page

6510

Item Tracking Lines

Modified

Page

16408

GST Setup

Modified

Page

16514

Pay TCS

Modified

Page

16624

GST Adjustment Journal

Modified

Report

16401

Create Default GST Setup

Modified

Report

16418

Update GST Registration No

Modified

Table

14

Location

Modified

Table

21

Cust. Ledger Entry

Modified

Table

25

Vendor Ledger Entry

Modified

Table

36

Sales Header

Modified

Table

38

Purchase Header

Modified

Table

45

G/L Register

Modified

Table

79

Company Information

Modified

Table

81

Gen. Journal Line

Modified

Table

179

Reversal Entry

Modified

Table

5900

Service Header

Modified

Table

16406

GST Posting Setup

Modified

Table

16408

GST Setup

Modified

Table

16409

Posted Settlement Entries

Modified

Table

16412

Detailed GST Entry Buffer

Modified

Table

16419

Detailed GST Ledger Entry

Modified

Table

16422

Adv. GST Calculation Buffer

Modified

Table

16424

GST Liability Line

Modified

Table

16436

GST Payment Buffer

Modified

Table

16437

Service Transfer Header

Modified

Table

16468

GST TDS/TCS Setup

Modified

Table

16469

GST TDS/TCS Entry

Modified

Table

17

G/L Entry

Modified

Table

37

Sales Line

Modified

Table

39

Purchase Line

Modified

Table

112

Sales Invoice Header

Modified

Table

114

Sales Cr.Memo Header

Modified

Table

122

Purch. Inv. Header

Modified

Table

124

Purch. Cr. Memo Hdr.

Modified

Table

5902

Service Line

Modified

Table

5992

Service Invoice Header

Modified

Table

5994

Service Cr.Memo Header

Modified

Table

16465

GST Journal Line

Modified

 

The JavaScript code minimizer helps you optimize your scripts to enhance page loading speed.

Setup


a)      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

b)      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

 

More Information


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.