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
IN9.0_TFS233358 GST - Return Formats [8.30 MB - EXE]
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.
Overview
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
- GSTR 1 and GSTR 2 file formats
Reference Information
| Reference no. | 233358 |
|---|---|
| Product Area | Financial Mangement |
| Discovered in | Microsoft Dynamics NAV 2016 |
| Title | [IN] GST - GSTR 2 Return file formats - NAV 2016 |
| Released on | 22 Nov 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 PartnerSource Business Center. 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 24
IN9.0_TFS225680 GST - Goods and Service Tax
IN9.0_TFS223871 GST – Bank Charges
IN9.0_TFS223875 GST – Bonded Warehouse
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 | 16414 | GSTR-2 File Format | R-MDX |
| Report | 16415 | Update Det. GST Entry GSTR2 | R-MDX |
Objects
List of objects
| Type | No. | Name | Added/Modified |
|---|---|---|---|
| Table | 36 | Sales Header | Modified |
| Table | 110 | Sales Shipment Header | Modified |
| Table | 112 | Sales Invoice Header | Modified |
| Table | 114 | Sales Cr.Memo Header | Modified |
| Table | 5107 | Sales Header Archive | Modified |
| Table | 6660 | Return Receipt Header | Modified |
| Report | 5703 | Transfer Order | Modified |
| Report | 5704 | Transfer Shipment | Modified |
| Report | 5705 | Transfer Receipt | Modified |
| Report | 16409 | GSTR-3B | Modified |
| Report | 16410 | GSTR-1 File Format | Modified |
| Report | 16413 | Update Det.GST Entry GSTR1 | Modified |
| Report | 16414 | GSTR-2 File Format | Added |
| Report | 16415 | Update Det. GST Entry GSTR2 | Added |
| Codeunit | 5705 | TransferOrder-Post Receipt | Modified |
| Codeunit | 16401 | GST Management | Modified |
| MenuSuite | 1030 | Dept - Country | Modified |
| Page | 42 | Sales Order | Modified |
| Page | 43 | Sales Invoice | Modified |
| Page | 44 | Sales Credit Memo | Modified |
| Page | 256 | Payment Journal | Modified |
| Page | 6630 | Sales Return Order | 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 | |
| GST Credit Adj. Jnl Nos. | Type: Code 10 | |
| GST Distribution Nos. | Type: Code 10 | |
| GST Settlement Nos. | Type: Code 10 | |
| 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 | |
| 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 | |
| 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 | |
| Unit of Measure | GST Reporting UQC | Type: Code 10 |
| Return Reason | GST Reporting Reason Code | Type: Option <Blank>, Interstate, Intrastate |
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: Option… <Blank>,CGST,SGST / UTGST,IGST,CESS |
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 |
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 |
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