Summary
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 December 2018 for details.
GST overview
· Proposed GST
o Goods and Service Tax (GST) is an indirect tax levied on supply of goods or services or both.
o It is a destination/consumption based tax levy which is payable in the state in which the goods and services are consumed.
o It is levied and collected on value addition at each stage of production or distribution process (all points in supply chain).
o 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:
o 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.
o 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.
o Tobacco products will be subject to Excise duty along with GST.
Features included in this Release
The following features are included in this release:
· GST Rate change: The provision for handling rate change is provided in system, if user create an invoice after rate change, but wish to create with previous rate without changing posting date, this feature will help user to create such invoices.
· Item tracking in GST Adjustment Journals: The GST Adjustment Journal is enhanced with item tracking feature, provision of selecting Item tracking in GST Adjustment Journals is provided, and user can select Lot No. or Serial No. while executing GST Adjustment Journal.
· GST TDS (released as out of band earlier, included in this CU)
· GST TCS (released as out of band earlier, included in this CU)
· ARN number in Location (released as out of band earlier, included in this CU)
· Provision to upload GST Opening balances (released as out of band earlier, included in this CU)
Reference Information
| Reference No. | 281118, 278582 |
|---|---|
| Product Area | Financial Management |
| Discovered in | Microsoft Dynamics NAV 2016 IN |
| Title | IN_GST_Lot No required at the time of GST Adjustment Journal_2016 IN_GST_GST Rate differs in Advance payment received and in Sales Invoice_2016 |
| Released on | 28 Nov 2018 |
Important notice
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 36
Note:
If a customer has customizations in any objects involved in this regulatory feature, they might require your special attention.
Objects
The following object have been added / modified through this release:
| Type | No. | Name | Added/Modified |
|---|---|---|---|
| Codeunit | 11 | Gen. Jnl.-Check Line | Modified |
| Codeunit | 12 | Gen. Jnl.-Post Line | Modified |
| Codeunit | 17 | Gen. Jnl.-Post Reverse | Modified |
| Codeunit | 19 | Gen. Jnl.-Post Preview | Modified |
| Codeunit | 80 | Sales-Post | Modified |
| Codeunit | 90 | Purch.-Post | Modified |
| Codeunit | 5986 | Serv-Amounts Mgt. | Modified |
| Codeunit | 16401 | GST Management | Modified |
| Codeunit | 16403 | GST Application Management | Modified |
| Codeunit | 16405 | GST Input Tax Credit | Modified |
| Codeunit | 5704 | TransferOrder-Post Shipment | Modified |
| Codeunit | 5705 | TransferOrder-Post Receipt | Modified |
| Codeunit | 6620 | Copy Document Mgt. | Modified |
| Codeunit | 99000830 | Create Reserv. Entry | Modified |
| MenuSuite | 1030 | Dept - Country | Modified |
| Page | 1 | Company Information | Modified |
| Page | 232 | Apply Customer Entries | Modified |
| Page | 233 | Apply Vendor Entries | Modified |
| Page | 255 | Cash Receipt Journal | Modified |
| Page | 256 | Payment Journal | Modified |
| Page | 344 | Navigate | Modified |
| Page | 5703 | Location Card | Modified |
| Page | 16406 | GST Posting Setup | Modified |
| Page | 16414 | Detailed GST Ledger Entry Prev | Modified |
| Page | 16419 | Detailed GST Ledger Entry | Modified |
| Page | 16434 | Pay GST | Modified |
| Page | 16569 | Bank Receipt Voucher | Modified |
| Page | 16576 | Cash Payment Voucher | Modified |
| Page | 16577 | Bank Payment Voucher | Modified |
| Page | 16579 | Cash Receipt Voucher | Modified |
| Page | 16627 | Update Reference Invoice No | Modified |
| Page | 16628 | GST TDS/TCS Setup | Modified |
| Page | 16629 | GST TDS/TCS Entry | Modified |
| Page | 16631 | Update GST TDS Certificate Dtl | Modified |
| Page | 16632 | Update GST TDS Cert. Details | Modified |
| Page | 16633 | GST TDS/TCS Entry Prev | Modified |
| Page | 39 | General Journal | Modified |
| Page | 42 | Sales Order | Modified |
| Page | 43 | Sales Invoice | Modified |
| Page | 44 | Sales Credit Memo | Modified |
| Page | 50 | Purchase Order | Modified |
| Page | 51 | Purchase Invoice | Modified |
| Page | 52 | Purchase Credit Memo | Modified |
| Page | 132 | Posted Sales Invoice | Modified |
| Page | 138 | Posted Purchase Invoice | Modified |
| Page | 140 | Posted Purchase Credit Memo | Modified |
| Page | 253 | Sales Journal | Modified |
| Page | 254 | Purchase Journal | Modified |
| Page | 5900 | Service Order | Modified |
| Page | 5933 | Service Invoice | Modified |
| Page | 5935 | Service Credit Memo | Modified |
| Page | 5972 | Posted Service Credit Memo | Modified |
| Page | 5978 | Posted Service Invoice | Modified |
| Page | 6510 | Item Tracking Lines | Modified |
| Page | 16408 | GST Setup | Modified |
| Page | 16514 | Pay TCS | Modified |
| Page | 16624 | GST Adjustment Journal | Modified |
| Report | 16401 | Create Default GST Setup | Modified |
| Report | 16418 | Update GST Registration No | Modified |
| Table | 14 | Location | Modified |
| Table | 21 | Cust. Ledger Entry | Modified |
| Table | 25 | Vendor Ledger Entry | Modified |
| Table | 36 | Sales Header | Modified |
| Table | 38 | Purchase Header | Modified |
| Table | 45 | G/L Register | Modified |
| Table | 79 | Company Information | Modified |
| Table | 81 | Gen. Journal Line | Modified |
| Table | 179 | Reversal Entry | Modified |
| Table | 5900 | Service Header | Modified |
| Table | 16406 | GST Posting Setup | Modified |
| Table | 16408 | GST Setup | Modified |
| Table | 16409 | Posted Settlement Entries | Modified |
| Table | 16412 | Detailed GST Entry Buffer | Modified |
| Table | 16419 | Detailed GST Ledger Entry | Modified |
| Table | 16422 | Adv. GST Calculation Buffer | Modified |
| Table | 16424 | GST Liability Line | Modified |
| Table | 16436 | GST Payment Buffer | Modified |
| Table | 16437 | Service Transfer Header | Modified |
| Table | 16468 | GST TDS/TCS Setup | Modified |
| Table | 16469 | GST TDS/TCS Entry | Modified |
| Table | 17 | G/L Entry | Modified |
| Table | 37 | Sales Line | Modified |
| Table | 39 | Purchase Line | Modified |
| Table | 112 | Sales Invoice Header | Modified |
| Table | 114 | Sales Cr.Memo Header | Modified |
| Table | 122 | Purch. Inv. Header | Modified |
| Table | 124 | Purch. Cr. Memo Hdr. | Modified |
| Table | 5902 | Service Line | Modified |
| Table | 5992 | Service Invoice Header | Modified |
| Table | 5994 | Service Cr.Memo Header | Modified |
| Table | 16465 | GST Journal Line | Modified |
The JavaScript code minimizer helps you optimize your scripts to enhance page loading speed.
Setup
a)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. Tolerance | 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 |
· 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 TDS Receivable Account | Type: Code 20 |
| GST TCS Receivable Account | Type: Code 20 |
| GST TCS Payable Account | Type: Code 20 |
· 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 |
b)New Setup Tables:
· GST TDS/TCS Setup
| Field | Description |
|---|---|
| GST Component Code | Type: Code 10 |
| Effective Date | Type: Date |
| GST TDS/TCS % | Type: Decimal |
| GST Jurisdiction | Option Options are: Intrastate, Interstate |
| Type | Option Options are: ,TDS,TCS |
More Information
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.