Share via

Microsoft Dynamics NAV 2016 Changes required in Reverse Charge transactions for Unregistered Vendors as per new rule - India

Download

IN9.0 TFS232757 RCM for Unregistered Vendors.exe [Zip 10.8 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

  • Reverse Charge transactions for Unregistered Vendors

Reference Information

Reference No. 232757
Product Area Financial Management
Discovered in Microsoft Dynamics NAV 2016
Title IN -Changes required in Reverse Charge transactions for Unregistered Vendors as per new rule - 2016
Released on 15 Dec 2017

Important Notice

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

  • IN9.0_TFS223999 GST – Cess Credit and GST Amount Rounding

Note:

If a customer has customizations in any objects involved in this regulatory feature, they might require your special

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:

Type No. Name Added/Modified
Table 25 Vendor Ledger Entry Modified
Table 38 Purchase Header Modified
Table 39 Purchase Line Modified
Table 81 Gen. Journal Line Modified
Table 120 Purch. Rcpt. Header Modified
Table 122 Purch. Inv. Header Modified
Table 124 Purch. Cr. Memo Hdr. Modified
Table 312 Purchases & Payables Setup Modified
Table 5109 Purchase Header Archive Modified
Table 6650 Return Shipment Header Modified
Table 16419 Detailed GST Ledger Entry Modified
Table 16423 GST Application Buffer Modified
Codeunit 12 Gen. Jnl.-Post Line Modified
Codeunit 80 Sales-Post Modified
Codeunit 90 Purch.-Post Modified
Codeunit 402 Purchase Header Apply Modified
Codeunit 5986 Serv-Amounts 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
Page 118 General Ledger Setup Modified
Page 402 Sales Order Statistics Modified
Page 403 Purchase Order Statistics Modified
Page 460 Purchases & Payables Setup Modified
Page 16414 Detailed GST Ledger Entry Prev Modified
Page 16419 Detailed GST Ledger Entry 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
​ RCM Exemp. for Un-Reg. Ven. Start Date Date
​ RCM Exemp. for Un-Reg. Ven. End Date Date
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
Non-Availment Type: Boolean
  • GST Group table

Field

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