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 Aug 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
- TDS calculation in Advance Payment
- Validation of GSTIN and PAN_2016
- GST Rounding account entries
- HSN code not mandatory for Advance Payment
- Changes in GSTR1 & 3B reports
Reference information
| Reference No. | 271872, 278713, 277710, 272835, 278464 |
|---|---|
| Product Area | Financial Management |
| Discovered in | Microsoft Dynamics NAV 2016 IN |
| Title | IN_GST_TDS on Advance Payment_2016, IN_GST_Validation of GSTIN and PAN_2016, IN_GST_Incorrect G/L entries created after applying hotfix from TFS 274475_2016, IN_GST_HSN code not mandatory for Advance Payment _2016, IN_GST_Changes in GSTR1,2 & 3B reports_2016 |
| Released on | 30 Aug 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 34
Note:
If a customer has customizations in any objects involved in this regulatory feature, they might require your special attention.
Licensing
Licensing refresh is required.
Objects
The following object have been added/modified through this release:
| Type | No. | Name | Added/Modified |
|---|---|---|---|
| Table | 14 | Location | Modified |
| Table | 18 | Customer | Modified |
| Table | 23 | Vendor | Modified |
| Table | 36 | Sales Header | Modified |
| Table | 37 | Sales Line | Modified |
| Table | 38 | Purchase Header | Modified |
| Table | 39 | Purchase Line | Modified |
| Table | 79 | Company Information | Modified |
| Table | 81 | Gen. Journal Line | Modified |
| Table | 222 | Ship-to Address | Modified |
| Table | 224 | Order Address | Modified |
| Table | 232 | Gen. Journal Batch | Modified |
| Table | 270 | Bank Account | Modified |
| Table | 291 | Shipping Agent | Modified |
| Table | 302 | Finance Charge Memo Header | Modified |
| Table | 5741 | Transfer Line | Modified |
| Table | 5900 | Service Header | Modified |
| Table | 5902 | Service Line | Modified |
| Table | 13730 | Party | Modified |
| Table | 16400 | GST Registration Nos. | Modified |
| Report | 16410 | GSTR-1 File Format | Modified |
| Codeunit | 11 | Gen. Jnl.-Check Line | Modified |
| Codeunit | 12 | Gen. Jnl.-Post Line | Modified |
| Codeunit | 80 | Sales-Post | Modified |
| Codeunit | 90 | Purch.-Post | Modified |
| Codeunit | 103 | Cust. Entry-Edit | Modified |
| Codeunit | 395 | FinChrgMemo-Issue | Modified |
| Codeunit | 5704 | TransferOrder-Post Shipment | 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 |
| Page | 39 | General Journal | Modified |
| Page | 46 | Sales Order Subform | Modified |
| Page | 47 | Sales Invoice Subform | Modified |
| Page | 50 | Purchase Order | Modified |
| Page | 51 | Purchase Invoice | Modified |
| Page | 54 | Purchase Order Subform | Modified |
| Page | 55 | Purch. Invoice Subform | Modified |
| Page | 254 | Purchase Journal | Modified |
| Page | 256 | Payment Journal | Modified |
| Page | 5745 | Posted Transfer Receipt | Modified |
| Page | 6631 | Sales Return Order Subform | Modified |
| Page | 6641 | Purchase Return Order Subform | Modified |
| Page | 16571 | Journal Voucher | Modified |
| Page | 16576 | Cash Payment Voucher | Modified |
| Page | 16577 | Bank Payment Voucher | Modified |
| Page | 16627 | Update Reference Invoice No | Modified |
Setup
- New Setup fields added in existing Tables
- 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.