Share via


Microsoft Dynamics NAV 2016 GST (Goods and Service Tax) Cess and Amount Rounding - India

Download

​IN9.0 GST Cess and Amount Rounding.exe [PDF 11.5 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.

On this Page:

Overview

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

  • Credit should not be available for CESS on GST for both Registered and Unregistered Vendors

  • GST Amount Rounding

Reference Information

Reference No. 228826, 223999
Product Area Financial Management
Discovered in Microsoft Dynamics NAV 2016
Title [IN] GST - Credit should not be available for CESS - NAV 2016; [IN] GST - GST Amount Rounding - NAV 2016
Released on 05 Dec 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 CU 24

  • IN9.0_TFS225680 GST - Goods and Service Tax

  • IN9.0_TFS223871 GST – Bank Charges

  • IN9.0_TFS223875 GST – Bonded Warehouse

  • IN9.0_TFS233358 GST – Return File Formats

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.

Licensing

Type No. Name Permissions

Objects

The following object have been added / modified through this release:

Objects

Type No. Name Added/Modified
Table 39 Purchase Line Modified
Table 81 Gen. Journal Line Modified
Table 98 General Ledger Setup Modified
Table 5902 Service Line Modified
Table 16405 GST Component Modified
Table 16408 GST Setup Modified
Table 16412 Detailed GST Entry Buffer Modified
Table 16419 Detailed GST Ledger Entry Modified
Table 16421 GST Calculation Buffer Modified
Table 16422 Adv. GST Calculation Buffer Modified
Table 16423 GST Application Buffer Modified
Report 16410 GSTR-1 File Format Modified
Codeunit 12 Gen. Jnl.-Post Line Modified
Codeunit 13 Gen. Jnl.-Post Batch Modified
Codeunit 80 Sales-Post Modified
Codeunit 90 Purch.-Post 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 5988 Serv-Documents Mgt. Modified
Codeunit 6620 Copy Document Mgt. Modified
Codeunit 16401 GST Management Modified
Codeunit 16403 GST Application Management Modified
Codeunit 16406 Service Transfer Post Modified
Page 118 General Ledger Setup Modified
Page 160 Sales Statistics Modified
Page 161 Purchase Statistics Modified
Page 232 Apply Customer Entries Modified
Page 233 Apply Vendor Entries Modified
Page 402 Sales Order Statistics Modified
Page 403 Purchase Order Statistics Modified
Page 5914 Service Order Statistics Modified
Page 6030 Service Statistics Modified
Page 16405 GST Component Modified
Page 16408 GST Setup Modified
Page 16412 Detailed GST Entry Buffer 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
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
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… ,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

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