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

Benötigen Sie weitere Hilfe?

Möchten Sie weitere Optionen?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.