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

Si applica a: 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.