Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Download
White Paper GST NAV 2016-IN [PDF - 2.02 MB]
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.
This is the second and the final part of GST (Goods and Service Tax) feature. Any new rules that will be announced in the future will be delivered as hotfixes.
GST overview:
a. 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.
b. 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. |
c. 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
- Input Service Distribution
Exempted Goods and Service
Normal Payment and its Application to Invoice
Service Transfers
Sub-Contracting
GST Compensation Cess
Reference Information
| Reference No. | 208252 |
|---|---|
| Product Area | Financial Management |
| Discovered in | Microsoft Dynamics NAV 2016 |
| Title | GST Phase 2 |
| Released on | 05 May 2017 |
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
Microsoft Dynamics ® NAV 2016 IN CU1
Microsoft Dynamics ® NAV 2016 IN CU2
Microsoft Dynamics ® NAV 2016 IN CU17
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 Data | 16437 | Service Transfer Header | RIMD- |
| Table Data | 16438 | Service Transfer Line | RIMD- |
| Table Data | 16439 | Service Transfer Shpt. Header | RIMD- |
| Table Data | 16440 | Service Transfer Shpt. Line | RIMD- |
| Table Data | 16441 | Service Transfer Rcpt. Header | RIMD- |
| Table Data | 16442 | Service Transfer Rcpt. Line | RIMD- |
| Table Data | 16443 | GST Component Distribution | RIMD- |
| Table Data | 16444 | GST Distribution Header | RIMD- |
| Table Data | 16445 | GST Distribution Buffer | RIMD- |
| Table Data | 16446 | Dist. Component Amount | RIMD- |
| Table Data | 16447 | Location Distribution | RIMD- |
| Table Data | 16448 | Component Distribution | RIMD- |
| Table Data | 16449 | Posted GST Distribution | RIMD- |
| Table Data | 16450 | ISD Ledger | RIMD- |
| Table Descriptions | 16437 | Service Transfer Header | R-MDX |
| Table Descriptions | 16438 | Service Transfer Line | R-MDX |
| Table Descriptions | 16439 | Service Transfer Shpt. Header | R-MDX |
| Table Descriptions | 16440 | Service Transfer Shpt. Line | R-MDX |
| Table Descriptions | 16441 | Service Transfer Rcpt. Header | R-MDX |
| Table Descriptions | 16442 | Service Transfer Rcpt. Line | R-MDX |
| Table Descriptions | 16443 | GST Component Distribution | R-MDX |
| Table Descriptions | 16444 | GST Distribution Header | R-MDX |
| Table Descriptions | 16445 | GST Distribution Buffer | R-MDX |
| Table Descriptions | 16446 | Dist. Component Amount | R-MDX |
| Table Descriptions | 16447 | Location Distribution | R-MDX |
| Table Descriptions | 16448 | Component Distribution | R-MDX |
| Table Descriptions | 16449 | Posted GST Distribution | R-MDX |
| Table Descriptions | 16450 | ISD Ledger | R-MDX |
| Report | 16404 | Service Transfer Shipment | R-MDX |
| Report | 16405 | GST Recon. Match Periodic Data | R-MDX |
| Code Unit | 16406 | Service Transfer Post | R-MDX |
| Page | 16400 | GST Registration Nos. | R-MDX |
| Page | 16385 | Service Transfer Order | R-MDX |
| Page | 16386 | Service Transfer Ship Subform | R-MDX |
| Page | 16387 | Service Transfer List | R-MDX |
| Page | 16388 | Service Transfer Lines | R-MDX |
| Page | 16389 | Service Transfer Rcpt. Subform | R-MDX |
| Page | 16390 | Posted Serv. Transfer Shipment | R-MDX |
| Page | 16391 | Posted ServTrans Shpt. Subform | R-MDX |
| Page | 16392 | Posted Serv. Transfer Reciept | R-MDX |
| Page | 16393 | Posted ServTrans Rcpt. Subform | R-MDX |
| Page | 16394 | Posted Serv. Trans. Shipments | R-MDX |
| Page | 16395 | Posted Serv. Trans. Receipts | R-MDX |
| Page | 16600 | GST Component Dist. List | R-MDX |
| Page | 16601 | GST Component Dist. Card | R-MDX |
| Page | 16602 | GST Distribution | R-MDX |
| Page | 16603 | GST Distribution Buffer Lines | R-MDX |
| Page | 16604 | GST Distribution List | R-MDX |
| Page | 16605 | Dist. Component Amount | R-MDX |
| Page | 16606 | Location Distribution List | R-MDX |
| Page | 16607 | Component Distribution List | R-MDX |
| Page | 16608 | Posted GST Distribution List | R-MDX |
| Page | 16609 | ISD Ledger | R-MDX |
| Page | 16610 | ISD Ledger Field Mapping | R-MDX |
| Page | 16611 | GST Distribution Reversal | R-MDX |
| Page | 16612 | GST Distribution Reversal List | R-MDX |
The following object have been added / modified through this release:
| Type | No. | Name | Added/Modified |
|---|---|---|---|
| Code unit | 11 | Gen. Jnl.-Check Line | Modified |
| Code unit | 12 | Gen. Jnl.-Post Line | Modified |
| Code unit | 80 | Sales-Post | Modified |
| Code unit | 90 | Purch.-Post | Modified |
| Code unit | 101 | Cust. Entry-SetAppl.ID | Modified |
| Code unit | 103 | Cust. Entry-Edit | Modified |
| Code unit | 111 | Vend. Entry-SetAppl.ID | Modified |
| Code unit | 113 | Vend. Entry-Edit | Modified |
| Code unit | 365 | Format Address | Modified |
| Code unit | 396 | NoSeriesManagement | Modified |
| Code unit | 1002 | Job Create-Invoice | Modified |
| Code unit | 5704 | TransferOrder-Post Shipment | Modified |
| Code unit | 5705 | TransferOrder-Post Receipt | Modified |
| Code unit | 5805 | Item Charge Assgnt. (Purch.) | Modified |
| Code unit | 5807 | Item Charge Assgnt. (Sales) | Modified |
| Code unit | 5980 | Service-Post | Modified |
| Code unit | 5986 | Serv-Amounts Mgt. | Modified |
| Code unit | 5987 | Serv-Posting Journals Mgt. | Modified |
| Code unit | 5988 | Serv-Documents Mgt. | Modified |
| Code unit | 6620 | Copy Document Mgt. | Modified |
| Code unit | 16360 | Subcontracting Post | Modified |
| Code unit | 16401 | GST Management | Modified |
| Code unit | 16403 | GST Application Management | Modified |
| Code unit | 16405 | GST Input Tax Credit | Modified |
| Code unit | 16406 | Service Transfer Post | Added |
| Menu suite | 1030 | Dept - Country | Modified |
| Page | 17 | G/L Account Card | Modified |
| Page | 30 | Item Card | Modified |
| Page | 46 | Sales Order Subform | Modified |
| Page | 47 | Sales Invoice Subform | Modified |
| Page | 50 | Purchase Order | Modified |
| Page | 51 | Purchase Invoice | Modified |
| Page | 52 | Purchase Credit Memo | Modified |
| Page | 76 | Resource Card | Modified |
| Page | 95 | Sales Quote Subform | Modified |
| Page | 96 | Sales Cr. Memo Subform | Modified |
| Page | 118 | General Ledger Setup | Modified |
| Page | 132 | Posted Sales Invoice | Modified |
| Page | 279 | Source Code Setup | Modified |
| Page | 344 | Navigate | Modified |
| Page | 460 | Purchases & Payables Setup | Modified |
| Page | 461 | Inventory Setup | Modified |
| Page | 508 | Blanket Sales Order Subform | Modified |
| Page | 509 | Blanket Purchase Order | Modified |
| Page | 5600 | Fixed Asset Card | Modified |
| Page | 5703 | Location Card | Modified |
| Page | 5800 | Item Charges | Modified |
| Page | 5905 | Service Lines | Modified |
| Page | 5910 | Service Costs | Modified |
| Page | 5934 | Service Invoice Subform | Modified |
| Page | 5936 | Service Credit Memo Subform | Modified |
| Page | 5966 | Service Quote Lines | Modified |
| Page | 6630 | Sales Return Order | Modified |
| Page | 6631 | Sales Return Order Subform | Modified |
| Page | 6640 | Purchase Return Order | Modified |
| Page | 6641 | Purchase Return Order Subform | Modified |
| Page | 16323 | Subcontracting Order | Modified |
| Page | 16326 | Delivery Challan Subform | Modified |
| Page | 16327 | Delivery Challan List | Modified |
| Page | 16385 | Service Transfer Order | Added |
| Page | 16386 | Service Transfer Ship Subform | Added |
| Page | 16387 | Service Transfer List | Added |
| Page | 16388 | Service Transfer Lines | Added |
| Page | 16389 | Service Transfer Rcpt. Subform | Added |
| Page | 16390 | Posted Serv. Transfer Shipment | Added |
| Page | 16391 | Posted ServTrans Shpt. Subform | Added |
| Page | 16392 | Posted Serv. Transfer Reciept | Added |
| Page | 16393 | Posted ServTrans Rcpt. Subform | Added |
| Page | 16394 | Posted Serv. Trans. Shipments | Added |
| Page | 16395 | Posted Serv. Trans. Receipts | Added |
| Page | 16400 | GST Registration Nos. | Modified |
| Page | 16401 | GST Accounting Period | Modified |
| Page | 16406 | GST Posting Setup | Modified |
| Page | 16419 | Detailed GST Ledger Entry | Modified |
| Page | 16420 | Create GST Liability | Modified |
| Page | 16421 | GST Liability Line | Modified |
| Page | 16426 | GST Component Mapping Recon. | Modified |
| Page | 16427 | GST Reconciliation Lines | Modified |
| Page | 16428 | Periodic GSTR-2A Data | Modified |
| Page | 16430 | GST Reconciliation | Modified |
| Page | 16433 | GST Credit Adjustment Journal | Modified |
| Page | 16434 | Pay GST | Modified |
| Page | 16435 | GST Payment | Modified |
| Page | 16600 | GST Component Dist. List | Added |
| Page | 16601 | GST Component Dist. Card | Added |
| Page | 16602 | GST Distribution | Added |
| Page | 16603 | GST Distribution Buffer Lines | Added |
| Page | 16604 | GST Distribution List | Added |
| Page | 16605 | Dist. Component Amount | Added |
| Page | 16606 | Location Distribution List | Added |
| Page | 16607 | Component Distribution List | Added |
| Page | 16608 | Posted GST Distribution List | Added |
| Page | 16609 | ISD Ledger | Added |
| Page | 16610 | ISD Ledger Field Mapping | Added |
| Page | 16611 | GST Distribution Reversal | Added |
| Page | 16612 | GST Distribution Reversal List | Added |
| Report | 202 | Sales Document - Test | Modified |
| Report | 204 | Sales - Quote | Modified |
| Report | 205 | Order Confirmation | Modified |
| Report | 206 | Sales - Invoice | Modified |
| Report | 207 | Sales - Credit Memo | Modified |
| Report | 210 | Blanket Sales Order | Modified |
| Report | 402 | Purchase Document - Test | Modified |
| Report | 405 | Order | Modified |
| Report | 406 | Purchase - Invoice | Modified |
| Report | 407 | Purchase - Credit Memo | Modified |
| Report | 5900 | Service Order | Modified |
| Report | 5902 | Service Quote | Modified |
| Report | 5911 | Service - Invoice | Modified |
| Report | 5915 | Service Document - Test | Modified |
| Report | 6641 | Return Order | Modified |
| Report | 16402 | GSTR-1 | Modified |
| Report | 16403 | GSTR-2 | Modified |
| Report | 16404 | Service Transfer Shipment | Added |
| Report | 16405 | GST Recon. Match Periodic Data | Added |
| Table | 14 | Location | Modified |
| Table | 15 | G/L Account | Modified |
| Table | 18 | Customer | Modified |
| Table | 21 | Cust. Ledger Entry | Modified |
| Table | 25 | Vendor Ledger Entry | Modified |
| Table | 27 | Item | 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 | 98 | General Ledger Setup | Modified |
| Table | 111 | Sales Shipment Line | Modified |
| Table | 113 | Sales Invoice Line | Modified |
| Table | 115 | Sales Cr.Memo Line | Modified |
| Table | 120 | Purch. Rcpt. Header | Modified |
| Table | 122 | Purch. Inv. Header | Modified |
| Table | 124 | Purch. Cr. Memo Hdr. | Modified |
| Table | 156 | Resource | Modified |
| Table | 222 | Ship-to Address | Modified |
| Table | 242 | Source Code Setup | Modified |
| Table | 312 | Purchases & Payables Setup | Modified |
| Table | 313 | Inventory Setup | Modified |
| Table | 5108 | Sales Line Archive | Modified |
| Table | 5600 | Fixed Asset | Modified |
| Table | 5741 | Transfer Line | Modified |
| Table | 5800 | Item Charge | Modified |
| Table | 5805 | Item Charge Assignment (Purch) | Modified |
| Table | 5809 | Item Charge Assignment (Sales) | Modified |
| Table | 5900 | Service Header | Modified |
| Table | 5902 | Service Line | Modified |
| Table | 5905 | Service Cost | Modified |
| Table | 5991 | Service Shipment Line | Modified |
| Table | 5993 | Service Invoice Line | Modified |
| Table | 5995 | Service Cr.Memo Line | Modified |
| Table | 6650 | Return Shipment Header | Modified |
| Table | 6661 | Return Receipt Line | Modified |
| Table | 16324 | Delivery Challan Line | Modified |
| Table | 16400 | GST Registration Nos. | Modified |
| Table | 16401 | GST Accounting Period | Modified |
| Table | 16406 | GST Posting Setup | Modified |
| Table | 16412 | Detailed GST Entry Buffer | Modified |
| Table | 16413 | Sub. Comp. Rcpt. Header | Modified |
| Table | 16418 | GST Ledger Entry | Modified |
| Table | 16419 | Detailed GST Ledger Entry | Modified |
| Table | 16421 | GST Calculation Buffer | Modified |
| Table | 16423 | GST Application Buffer | Modified |
| Table | 16424 | GST Liability Line | Modified |
| Table | 16429 | GST Recon. Mapping | Modified |
| Table | 16430 | GST Reconcilation Lines | Modified |
| Table | 16431 | Periodic GSTR-2A Data | Modified |
| Table | 16432 | Posted GST Reconciliation | Modified |
| Table | 16433 | GST Reconcilation | Modified |
| Table | 16434 | GST Credit Adjustment Journal | Modified |
| Table | 16436 | GST Payment Buffer | Modified |
| Table | 16437 | Service Transfer Header | Added |
| Table | 16438 | Service Transfer Line | Added |
| Table | 16439 | Service Transfer Shpt. Header | Added |
| Table | 16440 | Service Transfer Shpt. Line | Added |
| Table | 16441 | Service Transfer Rcpt. Header | Added |
| Table | 16442 | Service Transfer Rcpt. Line | Added |
| Table | 16443 | GST Component Distribution | Added |
| Table | 16444 | GST Distribution Header | Added |
| Table | 16445 | GST Distribution Buffer | Added |
| Table | 16446 | Dist. Component Amount | Added |
| Table | 16447 | Location Distribution | Added |
| Table | 16448 | Component Distribution | Added |
| Table | 16449 | Posted GST Distribution | Added |
| Table | 16450 | ISD Ledger | Added |
| XMLPort | 16401 | Periodic GSTR-2A Data | 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 | |
| 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 |
2. 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: Integer |
- 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 |
- 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 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 |
Support Information
For technical support questions, contact your partner or direct your questions to the Support for Business hub: https://serviceshub.microsoft.com/supportforbusiness/create