View source | Discuss this page | Page history | Printable version   
Toolbox
Main Page
Upload file
What links here
Recent changes
Help

PDF Books
Add page
Show collection (0 pages)
Collections help

Search

India Localization - GST

Warning.png   This document is still a work in progress. It may contain inaccuracies or errors.

Contents

Content

GST Overview

The GST (Goods and Service Tax) is a Value added Tax (VAT) proposed to be a comprehensive indirect tax levied on manufacture, sale and consumption of goods as well as services at the national level. It will replace most of the indirect taxes levied on goods and services by the Indian Central and state governments and other local authorities. The act is officially known as The Constitution (One Hundred and First Amendment) Act, 2016.


In implementing GST, there has also been a focus on having electronic returns and reconciliations to ensure better tax compliance and a faster system-driven processing. To achieve this, a special organization naming Goods and Service Tax Network (GSTN), in collaboration with Government of India, all State Government and Union Territories and other prominent Non Government Financial Institutions have been set up. GSTN is primarily focused into providing IT infrastructure and services to the Central and State Governments, taxpayers and other stakeholders for implementation of GST.

The GST is implemented from 1st July, 2017.

Objective

We are aiming at

Products which are outside the purview of GST

There are three products which are kept out of scope of GST. These products are

Old taxes (example - VAT, Exice) are applicable on these products.

Source of information

http://www.cbic.gov.in/htdocs-cbec/gst/index

Masters

Window - Organization

Tab - GSTIN

Introduction


GSTIN tab is provided in the Organization window to define the GST Unique ID. This tab will be visible only if the Organization Type is either “Legal with Accounting” or “Legal without Accounting”.

Multiple GST Unique IDs can be defined under one Legal Organization.

GSTINs defined here can be assigned to generic organizations in Organization Information tab


Organization Tab GSTIN.png


Other fields of this tab are

PAN No - : Valid PAN No of the Tax Payer who is registered in the GSTN portal.


GST Unique ID - A valid 15 digits GSTIN no of the registered organization to be entered. This is a mandatory field to be entered by user.


Tax Payer Name - Name of the organization registered under GST. Registered State - It is a drop down list containing 30 states and 7 union territories of India


Registered Mobile - Mobile no of the authorized person. This is the no which was provided to GSTN at the time of registration.


Registered Mail - Email id of the authorized person. This is the ID which was provided to GSTN at the time of registration.


GST Type - This is a drop down list consisting all four types of GST registration. Options are Casual, Non - Resident, Permanent, Temporary.


Registration Date - The date when the organization got registered under GST.


Business Vertical - The line of business the registered organization is engaged in


Cancellation Date - The date of GST registration cancellation


Valid Up to - The date till when GST registration is applicable. This field becomes visible only if GST type other than “Permanent” is selected


GSTIN User ID - The ID provided by GSTN after the registration


Gross Turnover - Turnover of previous financial year.


All fields except PAN No, GST Unique ID, Tax Payer Name, Registered State, Registration Date, GST Type and Gross Turnover are non mandatory


Warning Message - A message will appear if first two digits of GST Unique ID is not matching with the state code of registered state selected.

Organization Information

Introduction

A new field naming “GST Unique ID” is created in Organization Information tab. Here we assign the GSTIN which is created in “GSTIN” tab


Org Tab Info.png


GST Unique ID - It is a drop down list.

For an organization of type legal with accounting or legal without accounting, this field will list GSTINs of all organizations which satisfies these conditions -

For an organization of type “Generic” and “Organization”, this field will list GSTIN s of all organizations which satisfies these conditions -

Business Partner

Partner GSTIN

Introduction

GSTIN tab is provided in the Business Partner window to define the GST Unique ID. Purpose of this tab is to define GSTIN related data of a business partner.


BP GSTIN.png


Other fields of this tab are

PAN No - Valid PAN No of the business partner, registered in the GSTN portal.


GST Unique ID - A valid 15 digits GSTIN no of the business partner to be entered. This is a mandatory field to be entered by user.


Tax Payer Name - Name of the organization registered under GST.


Registered State - It is a drop down list containing 30 states and 7 union territories of India


All fields except business vertical are mandatory.


Warning Message - A message will appear if first two digits of GST Unique ID is not matching with the state code of registered state selected.

Partner Location / Address

Introduction

A new field naming “GST Unique ID” is created in Location / Address tab. Here we assign the GSTIN of BP which is created in “GSTIN” tab.


BP Tab - Location.png


GST Unique ID - It is a drop down list.

This field will list all the GSTINs which satisfies both the conditions -:

Tax Masters

This section describes on how the GST specific taxes are defined so that it becomes compatible to be worked with Openbravo.

Window - Tax Category

Introduction

In tax category window, there is no change specific to GST being made. However, we are providing a data set for tax categories and tax rates as specified by Central Board for Excise and Customs and Goods and Service Tax Network.


Tax Category.png


Openbravo is providing data set for these 5 standard tax categories -:

Window - Tax Rate

Introduction

There is no major change in Tax Rate window specific to GST. The only change is made in “Indian Tax Category” drop down list.


GST Intra 12%.png


Apart from change in "Indian Tax Category", 30 Indian States and 7 Union Territories are provided as a data set in "Tax Zone" tab.


Tax Rate - Tab Tax Zone.png

Indian Tax Category

It is a drop down list. It shows various types taxes applicable in India. Here new tax types specific to GST are being added. These are SGST, CGST, IGST and Cess.


TaxRateSGST.png


Apart from this change, data set on GST tax rates are also being provided. There are four types of GST.

Country and region

Introduction


The model GST law requires to identify each Indian state and Union Territory by its state code. India has 30 states and 7 Union Territories. To implement this requirement, we have made changes in “Country and Region” window

Window - Country and Region

This change is available in system administrator role. Please select “India” as the country.


Country Region.png

Tab - Region

Here a new field naming “State Code” is added. It is a numeric field. Numbering starts from 1 to 37. This numbering is as per the list provided by “Central Board of Excise and Customs”. Openbravo has providing the state code change as a data set


Tab - Region.png

GST Specific Masters

Introduction

HSN (Harmonised System of Nomenclature) code shall be used for classifying goods under GST regime. Services will be classified as per the Services Accounting Code (SAC). As per GST rules, any registered taxpayer whose turnover (in an financial year) is Rs. 1.5 crore or above, would require to file their returns with HSN/SAC code. Taxpayers whose turnover is below Rs. 1.5 crores are not required to mention HSN Code in their invoices.

GST Product Code

This window is created to define HSN / SAC master data


GST Product Code3.png


The other fields of this windows are

Type - It is a drop down list. It consists of both HSN and SAC code, examples are


GST Product Code - This field is designated to define both HSN and SAC code. Taxpayers whose turnover is above Rs. 1.5 crores but below Rs. 5 crores shall use 2-digit code. Taxpayers whose turnover is Rs. 5 crores and above shall use 4-digit code.


Features of GST Product Code are -


Name - This field defines name of a HSN / SAC code selected in the GST Product Code field. Input needs to be provided by user.

Features of this field

Tax Category -: It is a drop down list. It lists out all the tax categories which are created in the “Tax Category ” window. Here an user defines a tax category against a HSN / SAC code.


Description - It is an user input field.

Features of this field

For providing input in GST Product Code, Name and Description, please refer any on the following links –


Exception Rate

Under GST regime, It is expected that tax rates would be uniform across 30 states and 7 union territories. Still, there are provisions in SGST law where a State Govt can decide to override a State Tax of a specific product . State can also decide to declare a product tax exempt.


“Exception Rate” section is being introduced in “GST Product Code” window to define the State specific Tax.


Features of Exception

Window - Product Category

Field - GST Product Code


Introduction

The field “GST Product Code” is newly introduced in “Product Category” window. Purpose of this is to define a HSN / SAC code against a product category.


ProductCategory3.png


Features of GST Product Code

Please select any GST Product Code except which is of type SAC code

Window - Product

Introduction

The field “GST Product Code” is newly introduced in “Product ” window. Purpose of this is to define a HSN code against a product.


Product1.png


Features of GST Product Code

Please select any GST Product Code except which is of type SAC code


Tax Category

It is a drop down list. It will be getting defaulted based on the HSN code selected in the “GST Product Code”. However an user has an option to override the default tax category if needed.

Window - GL Item

Introduction

The field “GST Product Code” is newly introduced in “G/L Item ” window. Purpose of this is to define a SAC code against a G/L item.


GLItem1.png


Features of GST Product Code

Please select a GST Product Code which is of type SAC code

GST Configuration

Introduction


A new window is created to store all GST Configuration. This window is accessible at the “System Administrator” level.


GST1 Configuration.png

Fields of this window are


B2CS Limit


GST law specifies a limit on a maximum value per transaction with an individual customer. Till this limit such transaction is treated as B2CS (small). Upon crossing the limit such transaction becomes B2CL (large). This validation is applicable only B2C (Business to Customer) transaction and not for B2B (Business to Business). At present GST law set this limit at INR 250,000 per transaction.

Here in this field we assign the limit for B2CS transaction.


HSN/SAC (2 digits)

Taxpayers whose turnover is above Rs. 1.5 crores but below Rs. 5 crores need to use 2 digit code


HSN/SAC (4 4igits)

Taxpayers whose turnover is Rs. 5 crores and above shall use 4 digit code.

Taxpayers whose turnover is below Rs. 1.5 crores are not required to mention HSN Code in their invoices.

All these three fields accept only numeric value

GSP Configuration

It is a configuration window which connects to GSTN. This window is accessible in Client Admin role.

The fields of this window are Clientid, Clientsecret and Baseurl. These fields store the information received from GSTN after the organization is registered with GST.


GSP Configuration.png

Transactions

Sales Invoice

Introduction

The monthly return for sales invoice or GSTR 1 recommends that sales invoice to be presented in a certain manner. A few fields are being added in header and line to make it GSTR 1 compatible.

Sales Invoice Header

SIHeaderR.png


A new section naming “GST” is created in header. Here we have added the fields which are required as per GSTR 1. These new fields are


Organization GSTIN -


Features of this field are



Business Partner GSTIN


Features of this field are


eCommerce GSTIN


E-Commerce Operator GSTIN to be entered by the user. At present basic GSTIN validation in this field is not in scope. It is not mandatory; therefore the field can be kept blank also.


Place of Supply


Features of this field are


Original Invoice / Original Document No

This is applicable when the “Transaction Document” is AR Credit Memo.


Original Invoice Date / Original Document Date

This is applicable when the “Transaction Document” is AR Credit Memo.


Reverse Tax check box

By default, it is not checked.


GST Invoice Type

It is drop down list. It will show the list of invoice type depending on the type of business partner selected in sales invoice header.

When B2B (business partner who is having a valid GSTIN) business partner is selected in sales invoice header, GST invoice type will show these types of invoice

User has to select most appropriate type based on where the sales invoice is getting delivered.

When B2C (business partner who does not have a valid GSTIN) business partner is selected in sales invoice header, GST invoice type will show these types of invoices

User has to select most appropriate type based on where the sales invoice is getting delivered.

Selection of GST Invoice Type is mandatory. Else it will show an error message while saving the invoice header.


Export check box

By default, it is not checked

Sales Invoice line

A new section naming “GST” is created in line. Here we have added a field which is required as per GSTR 1.


SILine.png


GST Product Code


It gets defaulted when a product or G/L item is selected. A GST Product Code should be associated with that product or G/L item in “Product” window or “G/L Item” window. User has an option to manually override it and keep it blank.


Tax

It gets defaulted depending on

Purchase Invoice

Introduction


The monthly return for purchase invoice or GSTR 2 recommends that purchase invoice to be presented in a certain manner. A few fields are being added in header and line to make it GSTR 2 compatible.


Transaction Document Type - AP Invoice

Purchase Invoice Header

PI Rev.png


A new section naming “GST” is created in header. Here we have added the fields which are required as per GSTR 2. These new fields are


Organization GSTIN -

Features of this field are -


Business Partner GSTIN


Features of this field are -



eCommerce GSTIN

E-Commerce Operator GSTIN to be entered by the user. At present basic GSTIN validation in this field is not in scope. It is not mandatory; therefore the field can be kept blank also.


Place of Supply


Features of this field are


GST Invoice Type

It is drop down list. It will show the list of invoice type depending on the type of business partner selected in purchase invoice header.

When B2B (business partner who is having a valid GSTIN) business partner is selected in sales invoice header, GST invoice type will show these types of invoice

User has to select most appropriate type based on from where the purchase invoice is getting delivered.

When business partner who does not have a valid GSTIN is selected in purchase invoice header, GST invoice type will show these types of invoices

User has to select most appropriate type based on from where the purchase invoice is getting delivered.

Selection of GST Invoice Type is mandatory. Else it will show an error message while saving the invoice header.


Original Invoice / Original Document No


This is applicable when the “Transaction Document” is AP Credit Memo.


Original Invoice Date / Original Document Date


This is applicable when the “Transaction Document” is AP Credit Memo.


Reverse Tax check box


By default, it is not checked.


Import check box


By default, it is not checked

Purchase Invoice line

Two new sections naming “GST” and "Input Tax Credit" are created in line. Here we have added fields which are required as per GSTR 2.


PILine9.png


GST Product Code


It gets defaulted when a product or G/L item is selected. A GST Product Code should be associated with that product or G/L item in “Product” window or “G/L Item” window. User has an option to manually override it and keep it blank.


Tax

It gets defaulted depending on

Input Tax Credit

This section shows the tax amount which can be availed by an user as input tax. Few fields are added in this section. These new fields are

Eligibility

It is a drop down list. It shows the different types of input tax credit which can be availed by the organization. User has to select the most appropriate type depending on the purchase invoice type.

Select “Credit Input” for a purchase invoice which is not used for purchasing capital assets.

Select “No Input” where input tax credit is not allowed on such invoices.

Select “Capital Input” for a purchase invoice used for purchasing capital assets.

Select "Service Input" for a purchase invoice used for purchasing service.


IGST Available

Enter the IGST amount. This is applicable for “inter” purchase. This amount can be less or equal to the IGST tax amount calculated in the purchase invoice line.

SGST Available

Enter the SGST amount. This is applicable for “intra” purchase. This amount can be less or equal to the SGST tax amount calculated in the purchase invoice line.

CGST Available

Enter the CGST amount. This is applicable for “intra” purchase. This amount can be less or equal to the CGST tax amount calculated in the purchase invoice line.

Cess Available

Enter the Cess amount if cess is levied on the product or service.

IGST Available, SGST Available and CGST Available are mandatory when "Eligibility" types are Credit Input / Capital Input / Service Input.

Sales Order

The sales invoices which are created from Sales Order should have the GST related fields. To make such sales invoices GST compatible, GST Related fields being included Sales Order Header and Lines.

Sales Order Header

SO Header Rev1.png


A new section naming “GST” is created in the header. Here we have added the fields which are required as per GSTR 1. These new fields are


Organization GSTIN -


Features of this field are



Business Partner GSTIN


Features of this field are


eCommerce GSTIN


E-Commerce Operator GSTIN to be entered by the user. At present basic GSTIN validation in this field is not in scope. It is not mandatory, therefore the field can be kept blank also.


Place of Supply

Features of this field are


Reverse Tax check box

By default, it is not checked.

GST Invoice Type

It is drop down list. It will show the list of invoice type depending on the type of business partner selected in sales invoice header.

When B2B (business partner who is having a valid GSTIN) business partner is selected in sales invoice header, GST invoice type will show these types of invoice

User has to select most appropriate type based on where the sales invoice is getting delivered.

When B2C (business partner who does not have a valid GSTIN) business partner is selected in sales invoice header, GST invoice type will show these types of invoices

User has to select most appropriate type based on where the sales invoice is getting delivered.

Selection of GST Invoice Type is mandatory. Else it will show an error message while saving the Sales order header.

Sales Order line

SO Line.png


A new section naming “GST” is created in line. Here we have added a field which is required as per GSTR 1.


GST Product Code


It gets defaulted when a product is selected. A GST Product Code should be associated with that product in “Product” window. User has an option to manually override it and keep it blank.


Tax


It gets defaulted depending on

Purchase Order

The purchase invoices which are created from Purchase Order should have the GST related fields. To make such purchase invoices GST compatible, GST Related fields are included Purchase Order Header and Lines.

Purchase Order Header

PO Header.png


A new section naming “GST” is created in header. Here we have added the fields which are required as per GSTR 2. These new fields are -


Organization GSTIN -


Features of this field are


Business Partner GSTIN


Features of this field are


eCommerce GSTIN


E-Commerce Operator GSTIN to be entered by the user. At present basic GSTIN validation in this field is not in scope. It is not mandatory, therefore the field can be kept blank also.


Place of Supply

Features of this field are


Reverse Tax check box

By default, it is not checked.

Purchase Order line

A new section naming “GST” is created in line. Here we have added a field which is required as per GSTR 2.


POLine5.png


GST Product Code


It gets defaulted when a product is selected. A GST Product Code should be associated with that product in “Product” window. User has an option to manually override it and keep it blank.


Tax


It gets defaulted depending on

AP Credit Memo

Introduction


The monthly return for purchase invoice or GSTR 2 recommends that debit memo (which is raised against a purchase invoice) to be presented in a certain manner. A few fields are being added in header and line to make it GSTR 2 compatible.

AP Credit Memo Header

These changes will be applicable when "AP Credit Memo" is selected as Transaction Document Type.

A new section naming “GST” is created in header. Here we have added the fields which are required as per GSTR 2. These new fields are -


APC HeaderR2.png


Organization GSTIN


Features of this field are


Business Partner GSTIN


Features of this field are


eCommerce GSTIN

E-Commerce Operator GSTIN to be entered by the user. At present basic GSTIN validation in this field is not in scope. It is not mandatory, therefore the field can be kept blank also.


GST Invoice Type

It is drop down list. It will show the list of invoice type depending on the type of business partner selected in purchase invoice header.

When B2B (business partner who is having a valid GSTIN) business partner is selected in sales invoice header, GST invoice type will show these types of invoice

User has to select most appropriate type based on from where the purchase invoice is getting delivered.

When business partner who does not have a valid GSTIN is selected in purchase invoice header, GST invoice type will show these types of invoices

User has to select most appropriate type based on from where the purchase invoice is getting delivered.

Selection of GST Invoice Type is mandatory. Else it will show an error message while saving the invoice header.


Place of Supply


Features of this field are -


Original Invoice / Original Document No


Features of this field are -


Original Invoice Date / Original Document Date

It shows the date of Original Invoice selected. It is a read only field.


Original Credit / Debit Note

This is applicable on amendment of previously created AP Credit Memo.

Features of this field are


Original Credit / Debit Date


This is applicable on amendment of previously created AR Credit Memo.

Features of this field are


Reason

Features of this field are


Reverse Tax check box

By defaulted, it is not checked.


Import check box

By default, it is not checked

AP Credit Memo line

APCLine5.png


A new section naming “GST” is created in line. Here we have added a field which is required as per GSTR 2.


GST Product Code


It gets defaulted when a product or G/L item is selected. A GST Product Code should be associated with that product or G/L item in “Product” window or “G/L Item” window. User has an option to manually override it and keep it blank.


Tax

It gets defaulted depending on

Input Tax Credit

This section shows the tax amount which can be availed by an user as input tax. Few fields are added in this section. These new fields are

Eligibility

It is a drop down list. It shows the different types of input tax credit which can be availed by the organization. User has to select the most appropriate type depending on the purchase invoice type.

Select “Credit Input” for a purchase invoice which is not used for purchasing capital assets.

Select “No Input” where input tax credit is not allowed on such invoices.

Select “Capital Input” for a purchase invoice used for purchasing capital assets.

Select "Service Input" for a purchase invoice used for purchasing service.


IGST Available

Enter the IGST amount. This is applicable for “inter” purchase. This amount can be less or equal to the IGST tax amount calculated in the purchase invoice line.

SGST Available

Enter the SGST amount. This is applicable for “intra” purchase. This amount can be less or equal to the SGST tax amount calculated in the purchase invoice line.

CGST Available

Enter the CGST amount. This is applicable for “intra” purchase. This amount can be less or equal to the CGST tax amount calculated in the purchase invoice line.

Cess Available

Enter the Cess amount if cess is levied on the product or service.

IGST Available, SGST Available and CGST Available are mandatory when "Eligibility" types are Credit Input / Capital Input / Service Input.

AR Credit Memo

Introduction

The monthly return for sales invoice or GSTR 1 recommends that debit memo (which is raised against a sales invoice) to be presented in a certain manner. A few fields are being added in header and line to make it GSTR 1 compatible.

AR Credit Memo Header

ARC Header3.png


These changes are applicable when "AR Credit Memo" is selected as Transaction Document Type.

A new section naming “GST” is created in header. Here we have added the fields which are required as per GSTR 1. These new fields are


Organization GSTIN


Features of this field are


Business Partner GSTIN


Features of this field are


eCommerce GSTIN


E-Commerce Operator GSTIN to be entered by the user. At present basic GSTIN validation in this field is not in scope. It is not mandatory, therefore the field can be kept blank also.


Place of Supply


Features of this field are -


Original Invoice / Original Document No


Features of this field are -


Original Invoice Date / Original Document Date

It shows the date of Original Invoice selected. It is a read only field.


Original Credit / Debit Note

This is applicable on amendment of previously created AR Credit Memo.


Features of this field are


Original Credit / Debit Date

This is applicable on amendment of previously created AR Credit Memo.

Features of this field are


Reason

Features of this field are


Reverse Tax check box

By defaulted, it is not checked.


GST Invoice Type

It is drop down list. It will show the list of invoice type depending on the type of business partner selected in AR Credit Memo header.

When B2B (business partner who is having a valid GSTIN) business partner is selected in sales invoice header, GST invoice type will show these types of invoice

User has to select most appropriate type based on where the sales invoice is getting delivered.

When B2C (business partner who does not have a valid GSTIN) business partner is selected in sales invoice header, GST invoice type will show these types of invoices

User has to select most appropriate type based on where the AR Credit memo is getting delivered.

Selection of GST Invoice Type is mandatory. Else it will show an error message while saving the invoice header.



Export check box

By default, it is not checked

AR Credit Memo Line

A new section naming “GST” is created in line. Here we have added a field which is required as per GSTR 1.


ARCLine8.png


GST Product Code

It gets defaulted when a product or G/L item is selected. A GST Product Code should be associated with that product or G/L item in “Product” window or “G/L Item” window. User has an option to manually override it and keep it blank.


Tax

It gets defaulted depending on

GST on Advance Tax

Introduction

The GST law provides for payment of GST at the time of receipt of advance towards supply of goods or services. Advance can be received against a sales order or without. Here in Openbravo, we have implemented "GST on Advance" functionality only if the advance is received against a sales order. The tax so paid can be offset against tax liabilities on an invoice against the same order at the time of invoice generation. Advances paid and advances offset will have to be reported in the monthly sales return - GSTR-1.

There are few changes made in Openbravo to make it GST Advance Tax compatible.

Tax Rate

A new field naming "GST Advance Tax " is created under accounting tab in Tax Rate. This new field captures additional information that relates to "Advance Tax Credit".


TaxRateAdv1.png

GST G/L Journal Generation

It is a scheduled process which generates advance tax for a specific financial period and tax entity i.e. GSTIN. Upon completion this process will do the followings.


This new window is placed at


GSTGLJournal1.png


Or type "GST G/L Journal Generation" in the quick launch.


GSTGLJournal2.png

Fields of this windows are

GSTGLJournal.png


Return Type

Select GSTR 1 at this drop down


Organization

Features of this field are


GST Unique ID

Features of this field are

Tax Period

It lists all the months equal or later than July 2017. User needs to select a month for which he / she intends to generate GSTR 1.


Generate GSTR

Click on this button to create records in "Simple G/L Journal" window.

Simple G/L Journal

Completion of "GST G/L Journal Generation" will create lines in Simple G/L Journal. Complete the record and post it.

SimpleGLJournal2.png

Electronic Way Bill

E-way bill is an electronic document generated in the GST portal evidencing movement of goods. From 1st June 2018, e-way bill operations are compulsory for both inter transaction and intra-state (within the state) movement of goods. The file generated from OB can be submitted to "e - Way Bill System", https://ewaybillgst.gov.in/.

We have made changes in "Goods Shipment", "Goods Receipt", "Goods Movements", "Return to Vendor Shipment" and "Return Material Receipt" windows to make it GST compatible. E way Bill excel file can be generated from each of these windows. Apart from these, a new window naming "Transport" is also created.

Transport

This is a new window created to capture transporter details. It is located at

Or type "Transport" at Quick Launch.

QuickLaunch.png


Transport Header

TransportHeader2.png


Fields of transport header are

Trans Name

User need to provide transporter's name here. It is not a mandatory field.

PAN

User need to provide PAN (Permanent Account No) here. This field follows basic structure validation of PAN. It is a mandatory field.

Trans ID

This field captures "Transporter's GSTIN". User need to provide data in this field. This field follows basic structure validation of GSTIN. It is a mandatory field.

Registered State

It is a drop down list containing 30 states and 7 union territories of India. User has to select the most appropriate state from the list. It is a mandatory field.

Warning Message - A message will appear if first two digits of GST Unique ID is not matching with the state code of registered state selected.

Transport Line

TransportLine.png

Fields of "Transport Line's" are

Vehicle No

User has to provide number of the vehicle (which is being used to carry goods ) in this field.

Vehicle Type

User has to provide the type of the (which is being used to carry goods) in this field. Vehicle type can be either regular or ODC (Over Dimensional Cargo)

Goods Shipment

Goods Shipment Header

A new section naming " E-Way Bill" is created in Goods Shipment header. This section is visible only if a GST organization is selected at the "Organization" field. This section contains the fields related to E Way Bill. These fields are

GoodsShipment1.png

Bill No

Here an user need to provide "E Way Bill No" which is generated from "e - Way Bill System", https://ewaybillgst.gov.in/.

Distance

Here user has to provide distance of transportation. This field will accept only numeric value.

Doc Type

It is a drop down box. It will show the following document types of supply.

User has to select the most appropriate doc type.

Sub Type

It is a drop down box. It will show following sub types of supply.

These sub types are

User has to select the most appropriate sub type.

Transport Mode

It is a drop down box. It list out the mode of transport. These are

User has to select the appropriate transport mode.

Vehicle No

It is a drop down list. It shows the list of vehicle numbers which are created in the "Transport" window. User has to select the correct vehicle no.

Trans DocNo

I this field, user has to provide "Transporter Document No".

Trans Date

Here, user has to provide date of transport.

Goods Shipment Line

GoodsSL9.png

Assessable Value

This is the new field which is added in goods shipment line. It captures the assessable value of the product which is being shipped out. Value of this field comes from the corresponding sales invoice or sales order against which this Goods Shipment is created.

Goods Receipt

Goods Receipt Header

A new section naming " E-Way Bill" is created in Goods Receipt header. This section is visible only if a GST organization is selected at the "Organization" field. This section contains the fields related to E Way Bill. These new fields are


GoodsReceiptH.png


Bill No

Here an user need to provide "E Way Bill No" which is generated from "e - Way Bill System", https://ewaybillgst.gov.in/.

Distance

Here user has to provide distance of transportation. This field will accept only numeric value.

Doc Type

It is a drop down box. It will show the following document types of supply.

User has to select the most appropriate doc type.

Sub Type

It is a drop down box. It will show following sub types of supply.

These sub types are

User has to select the most appropriate sub type.

Transport Mode

It is a drop down box. It list out the mode of transport. These are

User has to select the appropriate transport mode.

Vehicle No

It is a drop down list. It shows the list of vehicle numbers which are created in the "Transport" window. User has to select the correct vehicle no.

Trans DocNo

In this field, user has to provide "Transporter's Document No".

Trans Date

Here, user has to provide date of transport.

Goods Receipt Line

GoodsReceiptL.png

Assessable Value

It is the new field which is added in goods receipt line. It captures the assessable value of the product which is being shipped in. Value of this field comes from the corresponding purchase invoice against which this Goods Receipt is created.

PO side is pending

Goods Movement

Goods Movement Header

A new section naming " E-Way Bill" is created in Goods Movement header. This section is visible only if a GST organization is selected at the "Organization" field. This section contains the fields related to E Way Bill. These fields are

GoodsMovementH.png

Bill No

Here an user needs to provide "E Way Bill No" which is generated from "e - Way Bill System", https://ewaybillgst.gov.in/.

Distance

Here user has to provide distance of transportation. This field will accept only numeric value.

Doc Type

It is a drop down box. It will show the following document types of supply.

User has to select the most appropriate doc type.

Sub Type

It is a drop down box. It will show following sub types of supply.

These sub types are

User has to select the most appropriate sub type.

Transport Mode

It is a drop down box. It list out the mode of transport. These are

User has to select the appropriate transport mode.

Vehicle No

It is a drop down list. It shows the list of vehicle numbers which are created in the "Transport" window. User has to select the correct vehicle no.

Trans DocNo

I this field, user has to provide "Transporter Document No".

Trans Date

Here, user has to provide date of transport.

Organization

Please select highest level organization of the organization structure. If highest organization is selected, all the storage bins created under its child organizations will be listed in Storage Bin and New Storage Bin drop down situated at line level

Goods Movement Line

GoodsMovementL.png

Two new fields are added in Goods Movement Line. These two new fields are

Assessable Value

This is the new field which is added in Goods Movement Line. It is an user input field. Here, user has to provide the assessable value of a product which is being moved from one warehouse to another.

Tax

It gets defaulted based on the product and address of storage bin and new storage bin

Return to Vendor Shipment

Return to Vendor Shipment Header

A new section naming " E-Way Bill" is created in Return to Vendor Shipment Header. This section is visible only if a GST organization is selected at the "Organization" field. This section contains the fields related to E Way Bill. These fields are


ReturnVendorH.png


Bill No

Here an user needs to provide "E Way Bill No" which is generated from "e - Way Bill System", https://ewaybillgst.gov.in/.

Distance

Here user has to provide distance of transportation. This field will accept only numeric value.

Doc Type

It is a drop down box. It will show the following document types of supply.

User has to select the most appropriate doc type.

Sub Type

It is a drop down box. It will show following sub types of supply.

These sub types are

User has to select the most appropriate sub type.

Transport Mode

It is a drop down box. It list out the mode of transport. These are

User has to select the appropriate transport mode.

Vehicle No

It is a drop down list. It shows the list of vehicle numbers which are created in the "Transport" window. User has to select the correct vehicle no.

Trans DocNo

I this field, user has to provide "Transporter Document No".

Trans Date

Here, user has to provide date of transport.

Organization

Please select highest level organization of the organization structure. If highest organization is selected, all the storage bins created under its child organizations will be listed in Storage Bin and New Storage Bin drop down situated at line level

Return to Vendor Shipment Line

ReturnVendorL.png

Assessable Value

It is a new field which is added in Return to Vendor Shipment line. It is the value of the goods returned to vendor.

How this value is getting calculated is pending

Return Material Receipt

Return Material Receipt Header

A new section naming " E-Way Bill" is created in Return Material Receipt Header. This section is visible only if a GST organization is selected at the "Organization" field. This section contains the fields related to E Way Bill. These fields are


ReturnMatReCH.png


Bill No

Here an user needs to provide "E Way Bill No" which is generated from "e - Way Bill System", https://ewaybillgst.gov.in/.

Distance

Here user has to provide distance of transportation. This field will accept only numeric value.

Doc Type

It is a drop down box. It will show the following document types of supply.

User has to select the most appropriate doc type.

Sub Type

It is a drop down box. It will show following sub types of supply.

These sub types are

User has to select the most appropriate sub type.

Transport Mode

It is a drop down box. It list out the mode of transport. These are

User has to select the appropriate transport mode.

Vehicle No

It is a drop down list. It shows the list of vehicle numbers which are created in the "Transport" window. User has to select the correct vehicle no.

Trans DocNo

In this field, user has to provide "Transporter Document No".

Trans Date

Here, user has to provide date of transport.

Return Material Receipt Line

ReturnMatL.png


Assessable Value

It is a new field which is added in Return Material Receipt line. It captures the assessable value of the product which is being returned by customer. Value of this field comes from the corresponding "Return from Customer" against which this Return Material Receipt is created. Also, an user can change the assessable value if required.

Generation of E Way Bill

E Way bill can be generated from these windows

EWayBillGenerate.png

Click on "Generate E-Way Bill" button to create E-Way Bill in .xlxs file. Upon completion, it will prompt the message Excel Report Generated!! Click here to download here. Save the .xlxs file accordingly. This excel file is compatible with GST requirements and can directly be uploaded in "e - Way Bill System", https://ewaybillgst.gov.in/.

Web POS Changes

Introduction

We have made a few changes to make the POS Receipt print GST compatible.

Two new POS print receipt templates are created in POS Print Templates Window. This is in System Admin. These two new print receipt templates are

POS Print Templates

Role – System Admin, window – POS Print Templates


POS Print Templates1.png


GST Print Receipt Template


GST Print Receipt Template1.png


GST Closed Receipt Template


GST Closed Receipt Template1.png

Window – Organization

Tab – Print Ticket Template

Please select “GST Print Receipt Template”

Tab – Closed Receipt Template

Please select “Closed Receipt Template” and save the record.


Organization1.png

POS Terminal

Please create a receipt in terminal. The printed receipt will show these details


POS Terminal.png

Invoice Upload/Download Offline Tool

Introduction

Businesses that generate a large number of invoices in a tax period may find it difficult to upload invoices one-by-one. More over, it may become a time-consuming activity with a cost implication. Therefore, to ease the uploading of invoices in bulk, Goods and Service Tax Network (GSTN) provides an Invoice Upload/Download Offline Tool for Returns. Here a taxpayer can add up to 19,000 line items in the offline mode and upload them to the GST Portal in one attempt. In case a taxpayer has more invoice data, they can use the Invoice Upload/Download Offline Tool multiple times to upload the same.


This tool can be downloaded from -

https://www.gst.gov.in/download/returns

For validations and system requirements, please refer Invoice Upload Offline Tool User Manual_V1.0and the sample .xlsx file provided by GSTN.

Now create sales invoices or AR credit memos as usual and complete the records.

Generate GSTR Process

This is new process. It is placed at


GSTR12.png


Or type Generate GSTR in Quick Launch.


Quick Launch5.png


Upon completion, it creates records in GST Return window.

Fields of this window are


Generate -GSTR.png

Return Type

Select GSTR 1 at this drop down


Organization

Features of this field are


GST Unique ID

Features of this field are


Tax Period

It lists all the months equal or later than July 2017. User needs to select a month for which he / she intends to generate GSTR 1.


Generate GSTR

Click on this button to create records in GST Return window

GST Returns

This is a new window. Completion of the process Generate GSTR creates records in this window. It contains all the records as mentioned in GSTR 1 return.

It is placed at

GSTReturns.png


New fields are added at the header.


GSTReturns5.png

Organization GSTIN

It shows the GSTIN no of the organization.

Document No

It is the return number.

Return Type

It shows if the "Return" is of type "GSTR 1" or "GSTR 2".

Tax Period

It is the tax period of the return

GSTIN Name

It shows the name of the organization whose monthly return is generated.

Apart from the new fields at the header level, several other new tabs are added at the line level to make it GSTR 1 compatible. These tabs are

Tab "B2B"

It records invoices with Taxable supplies made to other registered taxpayers

Tab "B2BA"

It records amended invoices with Taxable supplies made to other registered taxpayers

Tab "B2CL"

It records invoices for Taxable outward supplies to consumers (unregistered persons) when

i. The place of supply is outside the state where the supplier is registered and

ii. The total invoice value is more that Rs 2,50,000

Tab "B2CLA"

It records amended invoices with taxable outward supplies to consumers (unregistered persons) when

i. The place of supply is outside the state where the supplier is registered and

ii. The total invoice value is more that Rs 2,50,000

Tab "B2CS"

It records invoices with supplies made to consumers and unregistered persons of the following nature

i. Intra-State: any value

ii. Inter-State: Invoice value Rs 250,000 or less

Tab "B2CSA"

It records amended invoices with supplies made to consumers and unregistered persons of the following nature

i. Intra-State: any value

ii. Inter-State: Invoice value Rs 250,000 or less

Tab "CDNR"

It records Credit / Debit Notes / Refund vouchers issued to the registered taxpayers during a tax period.

1. Note/ Refund Voucher date - Date in DD-MMM-YYYY or DD/MMM/YYYYE format

2. Document Type - "D" if the note is Debit note, "C" if note is credit note or "R" for refund voucher.

3. Reason For Issuing document - Select the applicable reason for issue of the document.

Applicable Reasons are

A. 01-Sales Return, B. 02-Post Sale Discount C. 03-Deficiency in services D. 04-Correction in Invoice E. 05-Change in POS F. 06-Finalization of Provisional assessment G. 07-Others

4. Place of Supply - Place of supply based of original document.

5. Pre GST - If the credit / debit note is related to pre-GST supplies.

Tab "CDNRA"

It records amended Credit / Debit Notes / Refund vouchers issued to the registered taxpayers during a tax period.

Tab "CDNUR"

It records Credit / Debit Notes / Refund vouchers issued to the unregistered persons against interstate supply valuing > Rs 250,000.

1. GST Invoice Type - This is the document type through which supply to Unregistered Taxpayers (UR) has been made.

Allowed Invoice types are

a. B2CL - For invoices with taxable outward supplies to consumers (unregistered persons) where

i. The place of supply is outside the state where the supplier is registered and

ii. The total invoice value is more that Rs 2,50,000

b. EXPWP - For invoices with taxable outward supplies where

i. The place of supply is outside India

ii. Invoice value > Rs. 250,000

iii. Export with payment of GST

c. EXPWOP - For invoices with taxable outward supplies where

i. The place of supply is outside India

ii. Invoice value > Rs. 250,000

iii. Export without payment of GST

Tab "EXP"

It records supplies of goods or services or both to SEZ/SEZ Developer or deemed exports

1. Export Type - WPAY if the Export is with payment of GST. WOPAY if the Export is without payment of GST.

2. Port Code - Enter the six digit code of port through which goods were exported. Please refer the list of port codes available in GST common portal. This is not required in case of export of services. It should be in "AAAAA1" format. No special character is allowed.

3. Shipping Bill Number - Enter the unique reference number of shipping bill. This information if not available at the timing of submitting the return the same may be left blank and provided later.

4. Shipping Bill Date - Enter the date of shipping bill. This information if not available at the timing of submitting the return, the same may be left blank and provided later. This is not required in case of export of services.

Shipping Bill date can not earlier than Invoice Date.

Tab "EXPA"

It records amended supplies of goods or services or both to SEZ/SEZ Developer or deemed exports

Tab "Advance Received"

It records tax liability arising on account of advance payment

Tab "Tax Paid"

It records amended tax liability arising on account of advance receipt.

Tab Nil Rated

It records details of Nil Rated, Exempted and Non GST Supplies made during the tax period

Tab "HSN Summary"

It records HSN wise summary of goods /services supplied during the tax period.

1. HSN - It is HSN / SAC Code of supplied goods or Services. Only number is allowed. The rule of mentioning HSN code is as follows -

i. Up to 1,50,00,000 annual turnover - Nil digit ii. More than rupees 1,50,00,000 and up to rupees 5,00,00,000 annual turnover - 2 digit iii. More than rupees 5,00,00,000 annual turnover - 4 digit.

2. Description- Enter the description of the supplied goods or Services. Description becomes a mandatory field if HSN code is not provided above.

3. UOM - It is applicable Unit of Measurement.

4. Total Quantity - Enter the total quantity of the supplied goods or Services.

5. Total Value - It is invoice value of the goods or services

6. Taxable Value - Total taxable value of the supplied goods or services

7. IGST Amount - It is total Integrated tax amount payable.

8. CGST Amount - Total Central tax amount payable.

9. SGST Amount - Total State tax amount payable.

10. Cess Amount - It is total Cess amount payable.

Tab "Doc Issue"

It records summary of documents issued during the tax period.

Nature of Document - Document type used for outward supply.

From Serial No - 1st document no used for outward supply in the tax period

To Serial No - Last document no used for outward supply in the tax period

Total Number - Total number of the document issued

Cancelled - No of the cancelled documents

Export GST Return

It is a new process. It is placed at


Export Path1.png


This window generates an excel file which is compatible with GST requirements. This file can be directly uploaded in https://www.gst.gov.in to file GSTR 1 return for a specific tax period.

This excel file will have all the sections naming b2b, b2ba, b2cl,b2cla, b2cs, b2csa, cdnr, cdnra, cdnur, cdnura, exp, expa, at, ata, atadj, atadja, exemp, hsn and doc issue.


Export GST Return6.png

Organization

Features of this field are


GST Unique ID

Features of this field are


Tax Period

It lists all the months equal or later than July 2017. User needs to select a month for which he / she intends to generate GSTR 1.


Return Type

Select GSTR 1 at this drop down


GSTR Section

It is defaulted to "All" sections.


Export GST Returns

Click on this button to create .xlxs file. Upon completion, it will prompt this message. Save the .xlxs file accordingly. This file contains all the sections as specified in the sample file provided by GST organization.


ExportedFile2.png

Retrieved from "http://wiki.openbravo.com/wiki/India_Localization_-_GST"

This page has been accessed 4,452 times. This page was last modified on 23 October 2018, at 07:09. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.