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 June 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
-
Credit Memos for closed Invoices
-
Purchases from SEZ Vendors
-
GST in FA G/L Journal (Which were released as HF)
-
E-Way Bill changes (Which were released as HF)
Reference information
|
Reference No. |
266599, 268416 |
|
Product Area |
Financial Management |
|
Discovered in |
Microsoft Dynamics NAV 2016 IN |
|
Title |
IN_GST_Credit Memos for closed Invoices_NAV 2016, IN_GST_Purchases from SEZ Vendors_NAV 2016 |
|
Released on |
28 Jun 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 32
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 |
|
Page |
16627 |
Update Reference Invoice No |
R-MDX |
|
|
|
|
|
Objects
The following object have been added/modified through this release:
|
Type |
No. |
Name |
Added/Modified |
|
Table |
36 |
Sales Header |
Modified |
|
Table |
4 |
Currency |
Modified |
|
Table |
36 |
Sales Header |
Modified |
|
Table |
37 |
Sales Line |
Modified |
|
Table |
38 |
Purchase Header |
Modified |
|
Table |
39 |
Purchase Line |
Modified |
|
Table |
81 |
Gen. Journal Line |
Modified |
|
Table |
110 |
Sales Shipment Header |
Modified |
|
Table |
112 |
Sales Invoice Header |
Modified |
|
Table |
113 |
Sales Invoice Line |
Modified |
|
Table |
114 |
Sales Cr.Memo Header |
Modified |
|
Table |
120 |
Purch. Rcpt. Header |
Modified |
|
Table |
122 |
Purch. Inv. Header |
Modified |
|
Table |
124 |
Purch. Cr. Memo Hdr. |
Modified |
|
Table |
5107 |
Sales Header Archive |
Modified |
|
Table |
5109 |
Purchase Header Archive |
Modified |
|
Table |
5624 |
FA Reclass. Journal Line |
Modified |
|
Table |
5740 |
Transfer Header |
Modified |
|
Table |
5744 |
Transfer Shipment Header |
Modified |
|
Table |
5746 |
Transfer Receipt Header |
Modified |
|
Table |
5900 |
Service Header |
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 |
6660 |
Return Receipt Header |
Modified |
|
Table |
16412 |
Detailed GST Entry Buffer |
Modified |
|
Table |
16419 |
Detailed GST Ledger Entry |
Modified |
|
Table |
16420 |
GST Posting Buffer |
Modified |
|
Report |
16419 |
E-Way Bill File Format |
Modified |
|
Codeunit |
12 |
Gen. Jnl.-Post Line |
Modified |
|
Codeunit |
80 |
Sales-Post |
Modified |
|
Codeunit |
90 |
Purch.-Post |
Modified |
|
Codeunit |
101 |
Cust. Entry-SetAppl.ID |
Modified |
|
Codeunit |
111 |
Vend. Entry-SetAppl.ID |
Modified |
|
Codeunit |
113 |
Vend. Entry-Edit |
Modified |
|
Codeunit |
5642 |
FA Reclass. Transfer Line |
Modified |
|
Codeunit |
5704 |
TransferOrder-Post Shipment |
Modified |
|
Codeunit |
5705 |
TransferOrder-Post Receipt |
Modified |
|
Codeunit |
5980 |
Service-Post |
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 |
25 |
Customer Ledger Entries |
Modified |
|
Page |
29 |
Vendor Ledger Entries |
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 |
130 |
Posted Sales Shipment |
Modified |
|
Page |
132 |
Posted Sales Invoice |
Modified |
|
Page |
134 |
Posted Sales Credit Memo |
Modified |
|
Page |
136 |
Posted Purchase Receipt |
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 |
253 |
Sales Journal |
Modified |
|
Page |
254 |
Purchase Journal |
Modified |
|
Page |
402 |
Sales Order Statistics |
Modified |
|
Page |
403 |
Purchase Order Statistics |
Modified |
|
Page |
495 |
Currency Card |
Modified |
|
Page |
5628 |
Fixed Asset G/L Journal |
Modified |
|
Page |
5636 |
FA Reclass. Journal |
Modified |
|
Page |
5740 |
Transfer Order |
Modified |
|
Page |
5743 |
Posted Transfer Shipment |
Modified |
|
Page |
5900 |
Service Order |
Modified |
|
Page |
5914 |
Service Order Statistics |
Modified |
|
Page |
5933 |
Service Invoice |
Modified |
|
Page |
5935 |
Service Credit Memo |
Modified |
|
Page |
5971 |
Posted Service Credit Memos |
Modified |
|
Page |
5972 |
Posted Service Credit Memo |
Modified |
|
Page |
5977 |
Posted Service Invoices |
Modified |
|
Page |
5978 |
Posted Service Invoice |
Modified |
|
Page |
6030 |
Service Statistics |
Modified |
|
Page |
6630 |
Sales Return Order |
Modified |
|
Page |
6640 |
Purchase Return Order |
Modified |
|
Page |
6650 |
Posted Return Shipment |
Modified |
|
Page |
16412 |
Detailed GST Entry Buffer |
Modified |
|
Page |
16419 |
Detailed GST Ledger Entry |
Modified |
|
Page |
16627 |
Update Reference Invoice No |
Added |
|
Page |
16571 |
Journal Voucher |
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.
