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