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 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 CU 31
- Different GST Group and HSN/SAC Codes in Advance Payment and Invoices
Note: The details published in ATA report for adjustment of adjustment scenario is not handled in this release, this will be delivered in upcoming releases. - Calculating GST with ARN
- Different GST Group and HSN/SAC Codes in Advance Payment and Invoices
Reference Information
| Reference No. | 226057, 257810 |
|---|---|
| Product Area | Financial Management |
| Discovered in | Microsoft Dynamics NAV 2016 IN |
| Title | Different GST Group and HSN/SAC Codes in Advance Payment and Invoices, Calculating GST with ARN |
| Released on | 26 Apr 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 30
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 |
|---|---|---|---|
| Report | 16418 | Update GST Registration No | R-MDX |
Objects
The following object have been added/modified through this release:
| Type | No. | Name | Added/Modified |
|---|---|---|---|
| Table | 18 | Customer | Modified |
| Table | 21 | Cust. Ledger Entry | Modified |
| Table | 23 | Vendor | Modified |
| Table | 36 | Sales Header | Modified |
| Table | 37 | Sales Line | Modified |
| Table | 38 | Purchase Header | Modified |
| Table | 81 | Gen. Journal Line | Modified |
| Table | 221 | Gen. Jnl. Allocation | Modified |
| Table | 222 | Ship-to Address | Modified |
| Table | 224 | Order Address | Modified |
| Table | 5740 | Transfer Header | Modified |
| Table | 5900 | Service Header | Modified |
| Table | 5902 | Service Line | Modified |
| Table | 13730 | Party | Modified |
| Table | 16324 | Delivery Challan Line | Modified |
| Table | 16412 | Detailed GST Entry Buffer | Modified |
| Table | 16419 | Detailed GST Ledger Entry | Modified |
| Table | 16424 | GST Liability Line | Modified |
| Report | 16410 | GSTR-1 File Format | Modified |
| Report | 16418 | Update GST Registration No | Added |
| Codeunit | 11 | Gen. Jnl.-Check Line | Modified |
| Codeunit | 12 | Gen. Jnl.-Post Line | Modified |
| Codeunit | 80 | Sales-Post | Modified |
| Codeunit | 16401 | GST Management | Modified |
| Codeunit | 16403 | GST Application Management | Modified |
| Codeunit | 16405 | GST Input Tax Credit | Modified |
| MenuSuite | 1030 | Dept - Country | Modified |
| Page | 21 | Customer Card | Modified |
| Page | 26 | Vendor Card | Modified |
| Page | 39 | General Journal | 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 | 256 | Payment Journal | Modified |
| Page | 283 | Recurring General Journal | Modified |
| Page | 300 | Ship-to Address | Modified |
| Page | 368 | Order Address | Modified |
| Page | 397 | Sales Invoice Statistics | Modified |
| Page | 402 | Sales Order Statistics | Modified |
| Page | 403 | Purchase Order Statistics | Modified |
| Page | 5740 | Transfer Order | Modified |
| Page | 5741 | Transfer Order Subform | Modified |
| Page | 13735 | Parties | Modified |
| Page | 16414 | Detailed GST Ledger Entry Prev | Modified |
| Page | 16419 | Detailed GST Ledger Entry | Modified |
| Page | 16602 | GST Distribution | Modified |
| Page | 16624 | GST Adjustment Journal | 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.