Share This Post

NAV Updates

Microsoft Dynamics NAV GST Cumulative Update 30

This article explains about the Microsoft Dynamics NAV GST Cumulative Update 30. Goods and Service Tax (GST) is an indirect tax levied on the supply of goods or services or both. It is the destination or consumption-based tax levy which is payable in the state in which the goods and services are consumed. GST is levied and collected on value addition at each stage of production or distribution process (all points in the supply chain).

The supplier can avail the credit on input tax credit paid on the procurement of goods or services. Registration Number under the GST is called Goods and Service Tax Payer Identification Number (GSTIN). First two digits represent the State codes. The next thirteen-digits are alphanumeric and are assigned depending on a number of registrations a legal entity has within one state. 

Microsoft Dynamics NAV GST Cumulative Update 30 Features

  1. The following features were released as Out of band after CU 27, these are included in Microsoft Dynamics NAV GST Cumulative Update 30
    • GST in Journals
    • The vendor supplies goods or the service from multiple Locations each having separate GST Registration for documents
    • Services from Unregistered Vendor
    • Advance Payment Exempted for the GST Group Type Goods modifications
    • GST to be calculated based on the State code of Place of Supply in the Documents
    • IGST should be calculated for the Registered Vendors only in Documents
    • Adjust GST credit for written off inventory
    • Location Code is mandatory for the advance and normal payments
  2. Additional features that are included in Microsoft Dynamics NAV GST Cumulative Update (CU) 30
    • GST to be calculated based on the State code of Place of Supply in the Journals
    • IGST should be calculated for the Registered Vendors only in Journals
    • Separate Nos. Series for posted Reverse Charge Invoices for the Registered Vendors
    • The vendor supplies goods or the service from multiple Locations each having separate GST Registration for Journals
    • TDS be deducted in the Payment if it is not deducted in Invoice

Installation

Before this update can be installed, the following prerequisites are required:

  • Microsoft Dynamics NAV 2016 IN CU 27

Note: If a customer has customization’s in any objects involved in this regulatory feature, they might require your special attention.

Setup

  1. New Setup Fields Added in Existing Tables
Setup field table

Setup fields

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 the 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 The 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 The GST Reporting UQC Type: Code 10
Return Reason GST Reporting Reason Code Type: Option

<Blank>, Interstate, Intrastate

  1. 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 
Microsoft Dynamics NAV GST Cumulative Update 30

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 the Outward Supplies Returns (GSTR-1) Type: Date
Due Date for the 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 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 in Microsoft Dynamics NAV GST Cumulative Update 30

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 the Address, Location Address

Reverse Charge Type: Boolean
  • GST Posting Setup table in Microsoft Dynamics NAV GST Cumulative Update 30
GST Posting Setup table

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 Set-off table in Microsoft Dynamics NAV GST Cumulative Update 30

Field

Description

GST Component Type: Code 10

Lookup to GST Component

Priority Type: Integer

The user will manually update the number

Set Off Component Type: Code 10

Lookup to GST Component

  • GST Configuration table in Microsoft Dynamics NAV GST Cumulative Update 30

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 the Dispatch / Receiving State Code field value and Customer / Vendor State Code field is same else Interstate. If anyone state code is blank then the Interstate shall be updated.

GST % Sate Code Type: Code 10

Dropdown from State table

  • GST Details table in Microsoft Dynamics NAV GST Cumulative Update 30

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

The user needs to mention the Effective date

GST Component % Type: Decimal

A 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 in Microsoft Dynamics NAV GST Cumulative Update 30

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

The user needs to mention the Effective date

GST Component % Type: Decimal

A 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 a value of the component selected.

Calculation Order Type: Integer
Threshold Amount The Type: Integer
Before Threshold %

 

Type: Decimal

The user needs to mention the GST percentage before crossing the Threshold Limit

Component Calc. Type

 

Type: Option

Options are: Blank, General, Threshold, Cess %, Cess % + Amount/Unit Factor, Cess % Or Amount or Unit Factor Whichever Higher and the 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 % The Type: Decimal
Fixed Amount Type: Decimal

Field

Description

Name Type: Code 10
Description Type: Text 80
Page ID The Type: Integer
Type The Type: Option  (‘ ‘ , ‘GST Adjustment Journal’)
Source Code Type: Code 10
Reason Code The Type: Code 10
Page Name Type: Text 80
Bal. Account Type The Type: Option (‘G/L Account’, ’Customer’, ’Vendor’, ’Bank Account’)
Bal. Account No. Type: Code 20
No. Series The 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 The Type: Text  50
Reason Code Type: Code 10
Bal. Account Type The Type: Option  (‘G/L Account’, ’Customer’, ’Vendor’, ’Bank Account’)
Bal. Account No. Type: Code 20
No. Series Type: Code 10
Posting No. Series The Type: Code 10
Template Type The Type: Option  (‘ ‘ , ‘GST Adjustment Journal’)
Location Code Type: Code 10
Source Code Type: Code 10

Share This Post

Leave a Reply

avatar
  Subscribe  
Notify of
Skip to toolbar