Share This Post

NAV Updates

Microsoft Dynamics NAV GST Cumulative Update 31

This Microsoft Dynamics NAV GST Cumulative Update 31 adds all the hotfixes and regulatory features that have been released for Dynamics NAV 2016, including hotfixes and regulatory features that were released in previous cumulative updates. Cumulative updates are intended for the new and existing customers who are running Dynamics NAV 2016.

It is important to verify your environment is compatible with hotfixes or updates being installed. The hotfix or update may cause interoperability problems with customization’s and third-party products that work with the Microsoft Dynamics NAV solution.

Goods and Services Tax is an indirect tax levied on the supply of the goods and services. GST is levied at every step in the production process but is meant to be refunded to all parties in the various stages of production other than the final consumer.

Microsoft Dynamics NAV GST Cumulative Update 31 Features

The below  are included in the Microsoft Dynamics NAV GST Cumulative Update (CU) 31

  • Different GST Group and the HSN/SAC Codes in Advance Payment and Invoices
Microsoft Dynamics NAV GST Cumulative Update 31

GST Group

Note: The details published in ATA report for adjustment of adjustment scenario is not handled in this release, this will be delivered in upcoming releases.

  • Calculating GST with ARN

Installation

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

  • Microsoft Dynamics NAV 2016 IN CU 30

Note: If the customer has the customizations in any objects included in this regulatory feature, they might require your special attention.

Licensing

Following objects have been added through this update. Licensing refresh is required.

Type

No.

Name

Permissions

             Report       16418  Update the Goods and the Services Tax Registration Number                     R-MDX

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. 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 the Address, Ship-to Address and 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
Setup of Source Code 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
The 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 the UQC Type: Code 10
Return Reason GST Reporting Reason Code Type: Option

<Blank>, Interstate, Intrastate

  1. New Setup Tables:
GST Registration Number table

GST Registration Number 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 in the Microsoft Dynamics NAV GST Cumulative Update 31

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 an Outward Supplie 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 in the Microsoft Dynamics NAV GST Cumulative Update 31

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 chosen then it shall calculate on the value of 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 and Location Address

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

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

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 the Microsoft Dynamics NAV GST Cumulative Update 31

Field

Description

Type Type: Options

The option is 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 the 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 31

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

The 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

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

The user needs to mention the Effective date

GST Component % Type: Decimal

The user needs to mention the GST percentage

Include Base Type: Boolean
Formula Type: Code 250

Dropdown to GST Component table

If any component is chosen then it shall calculate on the value of component selected.

Calculation Order Type: Integer
Threshold Amount 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/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

Share This Post

Leave a Reply

avatar
  Subscribe  
Notify of
Skip to toolbar