GST (Goods and Service Tax) credit memos for closed invoices in the Indian version of Microsoft Dynamics NAV 2016 CU 33

Applies To
Dynamics NAV 2016

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 June 2018 for details.

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

The following are included in this release

  • Credit Memos for closed Invoices
  • Purchases from SEZ Vendors
  • GST in FA G/L Journal (Which were released as HF)
  • E-Way Bill changes (Which were released as HF)

Reference information

Reference No. 266599, 268416
Product Area Financial Management
Discovered in Microsoft Dynamics NAV 2016 IN
Title IN_GST_Credit Memos for closed Invoices_NAV 2016, IN_GST_Purchases from SEZ Vendors_NAV 2016
Released on 28 Jun 2018

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 32

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
Page 16627 Update Reference Invoice No R-MDX

Objects

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

Type No. Name Added/Modified
Table 36 Sales Header Modified
Table 4 Currency 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 110 Sales Shipment Header Modified
Table 112 Sales Invoice Header Modified
Table 113 Sales Invoice Line Modified
Table 114 Sales Cr.Memo Header Modified
Table 120 Purch. Rcpt. Header Modified
Table 122 Purch. Inv. Header Modified
Table 124 Purch. Cr. Memo Hdr. Modified
Table 5107 Sales Header Archive Modified
Table 5109 Purchase Header Archive Modified
Table 5624 FA Reclass. Journal Line Modified
Table 5740 Transfer Header Modified
Table 5744 Transfer Shipment Header Modified
Table 5746 Transfer Receipt Header Modified
Table 5900 Service Header Modified
Table 5990 Service Shipment Header Modified
Table 5992 Service Invoice Header Modified
Table 5994 Service Cr.Memo Header Modified
Table 6650 Return Shipment Header Modified
Table 6660 Return Receipt Header Modified
Table 16412 Detailed GST Entry Buffer Modified
Table 16419 Detailed GST Ledger Entry Modified
Table 16420 GST Posting Buffer Modified
Report 16419 E-Way Bill File Format Modified
Codeunit 12 Gen. Jnl.-Post Line Modified
Codeunit 80 Sales-Post Modified
Codeunit 90 Purch.-Post Modified
Codeunit 101 Cust. Entry-SetAppl.ID Modified
Codeunit 111 Vend. Entry-SetAppl.ID Modified
Codeunit 113 Vend. Entry-Edit Modified
Codeunit 5642 FA Reclass. Transfer Line Modified
Codeunit 5704 TransferOrder-Post Shipment Modified
Codeunit 5705 TransferOrder-Post Receipt Modified
Codeunit 5980 Service-Post Modified
Codeunit 5986 Serv-Amounts Mgt. Modified
Codeunit 5987 Serv-Posting Journals Mgt. Modified
Codeunit 16401 GST Management Modified
Codeunit 16403 GST Application Management Modified
Page 25 Customer Ledger Entries Modified
Page 29 Vendor Ledger Entries 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 130 Posted Sales Shipment Modified
Page 132 Posted Sales Invoice Modified
Page 134 Posted Sales Credit Memo Modified
Page 136 Posted Purchase Receipt Modified
Page 138 Posted Purchase Invoice Modified
Page 140 Posted Purchase Credit Memo Modified
Page 160 Sales Statistics Modified
Page 161 Purchase Statistics Modified
Page 232 Apply Customer Entries Modified
Page 253 Sales Journal Modified
Page 254 Purchase Journal Modified
Page 402 Sales Order Statistics Modified
Page 403 Purchase Order Statistics Modified
Page 495 Currency Card Modified
Page 5628 Fixed Asset G/L Journal Modified
Page 5636 FA Reclass. Journal Modified
Page 5740 Transfer Order Modified
Page 5743 Posted Transfer Shipment Modified
Page 5900 Service Order Modified
Page 5914 Service Order Statistics Modified
Page 5933 Service Invoice Modified
Page 5935 Service Credit Memo Modified
Page 5971 Posted Service Credit Memos Modified
Page 5972 Posted Service Credit Memo Modified
Page 5977 Posted Service Invoices Modified
Page 5978 Posted Service Invoice Modified
Page 6030 Service Statistics Modified
Page 6630 Sales Return Order Modified
Page 6640 Purchase Return Order Modified
Page 6650 Posted Return Shipment Modified
Page 16412 Detailed GST Entry Buffer Modified
Page 16419 Detailed GST Ledger Entry Modified
Page 16627 Update Reference Invoice No Added
Page 16571 Journal Voucher 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
    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

  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 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
    • 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

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.