India Localization - GST

Contents 1 Content 2 GST Overview 3 Masters 3.1 Window - Organization 3.1.1 Tab - GSTIN 3.1.2 Organization Information 3.2 Business Partner 3.2.1 Partner GSTIN 3.2.2 Partner Location / Address 3.3 Tax Masters 3.3.1 Window - Tax Category 3.3.2 Window - Tax Rate 3.3.3 Indian Tax Category 3.4 Country and region 3.4.1 Window - Country and Region 3.4.2 Tab - Region 3.5 GST Specific Masters 3.5.1 GST Product Code 3.5.2 Window - Product Category 3.5.3 Window - Product 3.5.4 Window - GL Item 3.6 GST Configuration 4 Transactions 4.1 Sales Invoice 4.1.1 Sales Invoice Header 4.1.2 Sales Invoice line 4.2 Purchase Invoice 4.2.1 Purchase Invoice Header 4.2.2 Purchase Invoice line 4.3 Sales Order 4.3.1 Sales Order Header 4.3.2 Sales Order line 4.4 Purchase Order 4.4.1 Purchase Order Header 4.4.2 Purchase Order line 4.5 AP Credit Memo 4.5.1 AP Credit Memo Header 4.5.2 AP Credit Memo line 4.6 AR Credit Memo 4.6.1 AR Credit Memo Header 4.6.2 AR Credit Memo Line 5 GST on Advance Tax 5.1 Tax Rate 5.2 GST G/L Journal Generation 5.3 Simple G/L Journal 6 Electronic Way Bill 6.1 Transport 6.1.1 Transport Header 6.1.2 Transport Line 6.2 Goods Shipment 6.2.1 Goods Shipment Header 6.2.2 Goods Shipment Line 6.3 Goods Receipt 6.3.1 Goods Receipt Header 6.3.2 Goods Receipt Line 6.4 Goods Movement 6.4.1 Goods Movement Header 6.4.2 Goods Movement Line 6.5 Return to Vendor Shipment 6.5.1 Return to Vendor Shipment Header 6.5.2 Return to Vendor Shipment Line 6.6 Return Material Receipt 6.6.1 Return Material Receipt Header 6.6.2 Return Material Receipt Line 6.7 Generation of E Way Bill 6.7.1 Format of E Way Bill excel file 7 Web POS Changes 7.1 POS Print Templates 7.2 Window – Organization 7.3 POS Terminal 8 Invoice Upload/Download Offline Tool 8.1 Generate GSTR Process 8.2 GST Returns 8.3 Export GST Return

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

• To provide basic GST functionality that would enable business transactions on Openbravo system to be executed in GST compatible manner.
• Provide a few standard GST related data (tax structure, state code, template chart of accounts etc) that would be required by most of the customers.
• Provide the basic integration with the GSTN network focusing on -
  • Monthly returns and annual returns through offline utility.
  • Area of business which are currently being used by existing customers (focus more on local b2b/b2c sales)
  • Openbravo retail - ensure that changes required for retail specially on WebPOS

Products which are outside the purview of GST

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

• Alcohol for human consumption
• Petroleum Products
• Electricity

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

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

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 -

• Created in “GSTIN” tab

• Organizations belong to same account tree

• First two digits of GSTINs and state code of the address mentioned here are same.

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

• Created in “GSTIN” tab

• Organizations belong to same account tree

• First two digits of GSTINs and state code of the address mentioned here are same.

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.

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.

GST Unique ID - It is a drop down list.

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

• Created in “GSTIN” tab

• First two digits of GSTINs and state code in Business Partner Address are same

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.

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

• GST - 0% - Exempt

• GST - 5% - Essential

• GST - 12% - Lower Standard Rate

• GST - 18% - Upper Standard Rate

• GST - 28% - Luxury

Window - Tax Rate

Introduction

There are two changes specific to GST. These are

• A new section naming Tax Override Condition is added in Tax Rate header.
• "Indian Tax Category" drop down list is changed.

Tax Override Condition

This section implies that when Gross Unit Price of a product is less than a certain amount, alternate tax rate will be applicable on that product. Three fields are added here. These new fields are

Override Condition

It is the condition when selected, a special tax rate will be applicable on a product. At present Openbravo is providing "Gross Unit Price Less Than" as override condition.

Amount

It is an user input field. User has to provide the value of a product.

Alternate Tax Rate

User has to select appropriate tax rate applicable on a product.

Please note override condition will work correctly only if all the 5 tax rates belonging to one GST rate are configured. As for example, GST on cotton dress material is 12% when price of such product is more than Rs. 1,000. GST on cotton dress material is 5 % when price of such product is less or equal to Rs. 1,000. In this scenario, GST Intra 12%, SGST 6%, CGST 6%, Cess 12% and IGST 12% are to be configured with Tax Override Condition.

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

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.

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

• SGST and CGST is applicable on intra / same state transactions

• UTGST and CGST is applicable on intra / same Union Territory transactions. Functionalities pertaining to UTGST will come into force in near future.

• IGST is applicable on inter transaction

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.

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

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

The other fields of this windows are

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

• HSN Section

• HSN Chapter

• HSN Heading

• HSN Sub - Heading

• HSN Code

• SAC Code

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 -

• It accepts only numeric values

• It does not allow alphabets, blank spaces or any special character

• HSN Section Code should be of 2 digits

• HSN Chapter Code should be of 2 digits

• HSN Heading should be of 4 digits

• HSN Sub-Heading should be of 6 digits

• HSN Code should be of 8 digits

• SAC code should be of 8 digits

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

• It supports till 255 characters

• It accepts numeric values, alphabets, blank spaces or any special character

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

• This field supports the entire text (as notified by dept) written against a HSN / SAC code

• It accepts numeric values, alphabets, blank spaces or any special character

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

• http://www.cbec.gov.in/htdocs-cbec/excise/cxt2015-16/cxt-1516-idx

• http://mca.gov.in/XBRL/pdf/ITC_HS_codes.pdf

• http://www.cbec.gov.in/resources//htdocs-servicetax/acctng-codes-services-notfn482012.pdf

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

• These state specific tax rates will be captured as overrides within the GST Product Code window.

• It will generate Tax Categories / Tax Rates/ Tax Zones as per Openbravo structure.

• It will create/update a HSN specific tax category (which is based on the base Tax Category provided in the HSN definition) as per the state specific SGST rates provided in the below exception table.

• It should also update the tax category of the specific GST Master to the new tax category.

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.

Features of GST Product Code

• It is a drop down list

• It lists out all the GST Product Codes which are created in the “GST Product Code” window.

• It does not list the GST Product Codes which are of type "HSN Section"

• It appears as “HSN / SAC code - Name of the HSN / SAC code”

• It is not mandatory. Product Category window can be saved with blank GST Product Code.

• Multiple product category can be created against one 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.

Features of GST Product Code

• It is a drop down list

• It lists out all the GST Product Codes which are created in the “GST Product Code” window.

• It does not list the GST Product Codes which are of type "HSN Section"

• It appears as “HSN / SAC code - Name of the HSN / SAC code”

• It is non mandatory. Product window can be saved with blank GST Product Code.

• Multiple product can be created against one 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.

Features of GST Product Code

• It is a drop down list

• It lists out all the GST Product Codes which are created in the “GST

• Product Code” window

• It does not list the GST Product Codes which are of type "HSN Section"

• It appears as “HSN / SAC code - Name of the HSN / SAC code”

• It is non mandatory. G/L item window can be saved with blank GST Product Code.

• Multiple G/L item can be created against one 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.

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

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

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

• It is the GST Identification number of the Sales invoice Organization.

• Once the organization is selected in header, "Organization GSTIN" gets defaulted from Information tab of "Organization" window.

• User has an option to manually override it and select another GSTIN.

• User can keep this field as blank in case if the organization of sales invoice does not have a GSTIN.

Business Partner GSTIN

Features of this field are

• It is the GST Identification number of the Business Partner.

• Once a business partner is selected, BP GSTIN gets defaulted from the "GSTIN Unique ID" field of "Location/Address" tab in "Business Partner" window.

• User has an option to manually override it and select another GSTIN.

• User can keep this field as blank in case if the BP selected in sales invoice header does not have a GSTIN.

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

• It gets defaulted from BP address.

• User has an option to manually override it and select another address. User can even keep this field blank.

• At present, POS does not have any impact in deciding tax rate in the line.

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

• Regular

• Deemed Export

• SEZ Export with Payament

• SEZ Export without Payament

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

• B2CL

• Export with Payment EXP)

• Export without Payment (EXP)

• B2CS

• Export without Payment(CDNUR)

• Export with payment (CDNR)

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.

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

• Product or G/L item selected

• State code of both sales invoice organization and business partner.

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

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 -

• It is the GST Identification number of the purchase invoice Organization.

• Once the organization is selected in header, "Organization GSTIN" gets defaulted from Information tab of "Organization" window.

• User has an option to manually override it and select another GSTIN.

• User can keep this field as blank in case if the organization of purchase invoice does not have a GSTIN.

Business Partner GSTIN

Features of this field are -

• It is the GST Identification number of the Business Partner.

• Once a business partner is selected, BP GSTIN gets defaulted from the "GSTIN Unique ID" field of "Location/Address" tab in "Business Partner" window.

• User has an option to manually override it and select another GSTIN.

• User can keep this field as blank in case if the BP selected in purchase invoice header does not have a GSTIN.

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

• It gets defaulted from organization address.

• User has an option to manually override it and select another address.

• User can even keep this field blank.

• At present, POS does not have any impact in deciding tax rate in the line.

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

• Regular

• Import of goods

• Import of service

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

• B2BUR

• Import of goods

• Import of service

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.

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

• Product or G/L item selected

• State code of both sales invoice organization and business partner.

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

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

• It is the GST Identification number of the Sales Order Organization.

• Once the organization is selected in header, "Organization GSTIN" gets defaulted from Information tab of "Organization" window.

• User has an option to manually override it and select another GSTIN.

• User can keep this field as blank in case if the organization of sales order does not have a GSTIN.

Business Partner GSTIN

Features of this field are

• It is the GST Identification number of the Business Partner.

• Once a business partner is selected, BP GSTIN gets defaulted from the "GSTIN Unique ID" field of "Location/Address" tab in "Business Partner" window.

• User has an option to manually override it and select another GSTIN.

• User can keep this field as blank in case if the BP selected in sales order header does not have a GSTIN.

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

• It gets defaulted from BP address.

• User has an option to manually override it and select another address. User can even keep this field blank.

• At present, POS does not have any impact in deciding tax rate in the line.

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

• Regular

• Deemed Export

• SEZ Export with Payament

• SEZ Export without Payament

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

• B2CL

• Export with Payment EXP)

• Export without Payment (EXP)

• B2CS

• Export without Payment(CDNUR)

• Export with payment (CDNR)

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

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

• Product selected

• State code of both sales order organization and business partner.

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

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

• It is the GST Identification number of the Purchase Order Organization.

• Once the organization is selected in header, "Organization GSTIN" gets defaulted from "Information" tab of "Organization" window.

• User has an option to manually override it and select another GSTIN.

• User can keep this field as blank in case if the organization of purchase order does not have a GSTIN.

Business Partner GSTIN

Features of this field are

• It is the GST Identification number of the Business Partner.

• Once a business partner is selected, BP GSTIN gets defaulted from the "GSTIN Unique ID" field of "Location/Address" tab in "Business Partner" window.

• User has an option to manually override it and select another GSTIN.

• User can keep this field as blank in case if the BP selected in purchase order header does not have a GSTIN.

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

• It gets defaulted from Organization address.

• User has an option to manually override it and select another address. User can even keep this field blank.

• At present, POS does not have any impact in deciding tax rate in the line.

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.

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

• Product selected

• State code of both purchase order organization and business partner.

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 -

Organization GSTIN

Features of this field are

• It is the GST Identification number of the Organization selected in AP Credit Memo.

• Once the organization is selected in header, "Organization GSTIN" gets defaulted from " Information" tab of "Organization" window.

• User has an option to manually override it and select another GSTIN.

• User can keep this field as blank in case if the organization of AP Credit Memo does not have a GSTIN.

Business Partner GSTIN

Features of this field are

• It is the GST Identification number of the Business Partner.

• Once a business partner is selected, BP GSTIN gets defaulted from the "GSTIN Unique ID" field of "Location/Address" tab in "Business Partner" window.

• User has an option to manually override it and select another GSTIN.

• User can keep this field as blank in case if the BP selected in AP Credit Memo header does not have a GSTIN.

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

• Regular

• Import of goods

• Import of service

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

• B2BUR

• Import of goods

• Import of service

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 -

• It gets defaulted from organization address.

• User has an option to manually override it and select another address.

• User can even keep this field blank.

• At present, POS does not have any impact in deciding tax rate in the line.

Original Invoice / Original Document No

Features of this field are -

• It is a drop down list.

• It shows the list of Original Purchase Invoice against which the credit note is being issued.

• It lists out only those PI s which are completed or booked

• It does not show invoices which are draft / void

• It lists out invoices which have the same organization as what is selected in "Organization" field

• It does not show invoices which have organization different than what is selected in "Organization" field

• This list shows invoices which have the same BP what is selected in "Business Partner" field

• It does not show invoices which do not have same BP as what is selected in "Business Partner" field

• It lists out show invoices which have same BP GSTIN as what is selected in "Partner GSTIN" field

• It does not show invoices which have BP GSTIN different from what is selected in " Partner GSTIN" field

• It is mandatory

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

• It is a drop down list

• It shows the list of "AP Credit Memo" having same BP GSTIN as what is selected in the header.

• It is read only after completion

Original Credit / Debit Date

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

Features of this field are

• It shows the date of Original Debit Note / Credit note

• It is read only

Reason

Features of this field are

• It is a drop down list.

• It shows the reason on why the AP Credit Memo is being raised

• It is non editable. It takes value from "Return to Vendor" window

Reverse Tax check box

By defaulted, it is not checked.

Import check box

By default, it is not checked

AP Credit Memo line

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

• Product or G/L item selected

• State code of both sales invoice organization and business partner.

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

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

• It is the GST Identification number of the Organization selected in AR Credit Memo.

• Once the organization is selected in header, "Organization GSTIN" gets defaulted from "Information" tab of "Organization" window.

• User has an option to manually override it and select another GSTIN.

• User can keep this field as blank in case if the organization of AR Credit Memo does not have a GSTIN.

Business Partner GSTIN

Features of this field are

• It is the GST Identification number of the Business Partner.

• Once a business partner is selected, BP GSTIN gets defaulted from the "GSTIN Unique ID" field of "Location/Address" tab in "Business Partner" window.

• User has an option to manually override it and select another GSTIN.

• User can keep this field as blank in case if the BP selected in AR Credit Memo header does not have a GSTIN.

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 -

• It gets defaulted from BP address.

• User has an option to manually override it and select another address.

• User can even keep this field blank.

• At present, POS does not have any impact in deciding tax rate in the line.

Original Invoice / Original Document No

Features of this field are -

• It is a dropdown list.

• It shows the list of Original Sales Invoice against which the credit note is being issued.

• It lists out only those SI s which are completed or booked

• It does not show invoices which are draft / void

• It lists out invoices which have the same organization as what is selected in "Organization" field

• It does not show invoices which have organization different than what is selected in "Organization" field

• This list shows invoices which have the same BP what is selected in "Business Partner" field

• It does not show invoices which do not have same BP as what is selected in "Business Partner" field

• It lists out show invoices which have same BP GSTIN as what is selected in "Partner GSTIN" field

• It does not show invoices which have BP GSTIN different from what is selected in " Partner GSTIN" field

• It is mandatory

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

• It is a drop down list

• It shows the list of "AR Credit Memo" having same BP GSTIN as what is selected in the header.

• It is read only after completion

Original Credit / Debit Date

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

Features of this field are

• It shows the date of Original Debit Note / Credit note

• It is read only

Reason

Features of this field are

• It is a drop down list.

• It shows the reason on why the AR Credit Memo is being raised

• It is non editable. It takes value from "Return from Customer" window

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

• Regular

• Deemed Export

• SEZ Export with Payament

• SEZ Export without Payament

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

• B2CL

• Export with Payment EXP)

• Export without Payment (EXP)

• B2CS

• Export without Payment(CDNUR)

• Export with payment (CDNR)

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.

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

• Product or G/L item selected

• State code of both sales invoice organization and business partner.

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".

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.

• It will identify all advance payments against an order in that period and which have funds that have not been transferred to invoices within the same period.

• The process will identify the proportion of order amount that is being retained as advance on the payment. Further it will calculate the tax amount as the same percentage of the order amount.

• The tax entries will be generated as Journal Entries in "Simple G/L Journal" window.

• The advance entry will credit the tax debit account and debit the advance tax credit account that are configured at the tax rate window.

• Generate GSTR 1 process will also generate entries for advance tax and advance tax utilization based on these ledger entries.

This new window is placed at

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

Fields of this windows are

Return Type

Select GSTR 1 at this drop down

Organization

Features of this field are

• It is a drop down list.

• It shows only those organizations which are of type "Legal with Accounting"

• This organization filter does not show any other organization which is not of type "Legal with Accounting"

GST Unique ID

Features of this field are

• It is a drop down list.

• It lists all the GSTINs defined for the Legal Organization which is selected in the Organization field.

• It does not show any GSTIN which is not defined for the legal organization selected in the organization field.

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.

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.

Transport Header

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

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

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.

• Bill of Entry
• Bill of Supply
• Credit Note
• Delivery Challan
• Others
• Tax Invoice

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

• Supply
• Import
• Export
• Job Work
• For Own Use
• Job Work Returns
• Sales Return
• Others
• SKD / CKD,
• Line Sales
• Recipient No Known
• Exhibition or Fairs.

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

• Road
• Rail
• Air
• Ship

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

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

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.

• Bill of Entry
• Bill of Supply
• Credit Note
• Delivery Challan
• Others
• Tax Invoice

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

• Supply
• Import
• Export
• Job Work
• For Own Use
• Job Work Returns
• Sales Return
• Others
• SKD / CKD
• Line Sales
• Recipient No Known
• Exhibition or Fairs.

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

• Road
• Rail
• Air
• Ship

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

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 or purchase order against which this Goods Receipt is created.

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

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.

• Bill of Entry
• Bill of Supply
• Credit Note
• Delivery Challan,
• Others
• Tax Invoice

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

• Supply
• Import
• Export
• Job Work
• For Own Use
• Job Work Returns
• Sales Return
• Others
• SKD / CKD
• Line Sales
• Recipient No Known
• Exhibition or Fairs.

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

• Road
• Rail
• Air
• Ship

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

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

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.

• Bill of Entry
• Bill of Supply
• Credit Note
• Delivery Challan
• Others
• Tax Invoice

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

• Supply
• Import
• Export
• Job Work
• For Own Use
• Job Work Returns
• Sales Return
• Others
• SKD / CKD
• Line Sales
• Recipient No Known
• Exhibition or Fairs

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

• Road
• Rail
• Air
• Ship

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

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

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.

• Bill of Entry
• Bill of Supply
• Credit Note
• Delivery Challan
• Others
• Tax Invoice

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

• Supply
• Import
• Export
• Job Work
• For Own Use
• Job Work Returns
• Sales Return
• Others
• SKD / CKD
• Line Sales
• Recipient No Known
• Exhibition or Fairs

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

• Road
• Rail
• Air
• Ship

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

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

• Goods Shipment
• Goods Receipt
• Goods Movement
• Return to Vendor Shipment and
• Return Material Receipt

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/.

Format of E Way Bill excel file

The excel file have several fields. These are described below.

GSTIN / Transporter ID

It is the GSTIN of the organization which is applying for E Way Bill. This GSTIN is picked up from “GSTIN Unique ID” in “Information” tab of Organization window.

Legal Name

This is the legal name of the organization which is applying for E Way Bill. This name is coming from “Organization” field in Goods Shipment /Goods Receipt/Goods Movement/Return to vendor Shipment /Return Material Receipt window.

Address

It is the address of the Organization who is applying for E Way Bill. It is picked up from 1st and 2nd line of Location / Address of Organization mentioned in Goods Shipment, Goods Receipt, Return Material Receipt and Return to Vendor Shipment header. In case of Goods Movements, it is picked up from 1st and 2nd line of Location / Address of organization of "Storage Bin" located in line.

Place

It is picked up from 4th line of Location / Address of Organization mentioned in Goods Shipment, Goods Receipt, Return Material Receipt and Return to Vendor Shipment header. In case of Goods Movements, it is picked up from 4th line of Location / Address of organization of "Storage Bin" located in line.

State

It is the state of the organization who is applying for e way bill. It is picked up from 6th line of Location / Address of organization mentioned in Goods Shipment, Goods Receipt, Return Material Receipt and Return to Vendor Shipment header. In case of Goods Movements, it is picked up from 6th line of Location / Address of organization of "Storage Bin" located in line.

Pin Code

It is picked up from 3rd line of Location / Address of organization mentioned in Goods Shipment, Goods Receipt, Return Material Receipt and Return to Vendor Shipment header. In case of Goods Movements, it is picked up from 3rd line of Location / Address of organization of "Storage Bin" located in line.

Supply Type

This will be Inward if the E Way Bill is generated from "Goods Receipt", Goods Movement and Return Material Receipt window. Supply type will be Outward if E Way Bill is generated from Goods Shipment and Return to Vendor Shipment window.

Sub Type

This will be picked up from the "Sub Type" selected in "E-Way Bill" section of Goods Receipt, Goods Shipment, Goods Movement, Return to Vendor Shipment and Return Material Receipt window.

Doc Type

This will be picked up from the "Doc Type" selected in "E-Way Bill" section of Goods Receipt, Goods Shipment, Goods Movement, Return to Vendor Shipment and Return Material Receipt window.

Doc No

This will be picked up from the "Document No" situated in header of Goods Receipt, Goods Shipment, Goods Movements, Return to Vendor Shipment and Return Material Receipt window.

Doc Date

This will be picked up from the "Movement Date" situated in header of Goods Receipt, Goods Shipment, Goods Movements, Return to Vendor Shipment and Return Material Receipt window.

From_OtherPartyName

It is the name of the Organization which is applying for E Way Bill.This will be picked up from "Organization" field situated in header of Goods Receipt, Goods Shipment, Return to Vendor Shipment and Return Material Receipt window. In case of Goods Movements, From_OtherPartyName is the Organization name of "storage Bin" located in line.

From_GSTIN

It is the GST number of the organization which is applying for E Way Bill. In case of Goods Receipt, Goods Shipment, Return Material Receipt and Return to Vendor Shipment window, this will be picked up from “GSTIN Unique ID” in “Information” tab of Organization window. In case of Goods Movements, From_GSTIN is the Organization GSTIN of "storage Bin" located in line.

From_Address1

It is the address from where the goods are being shipped. It is picked up from 1st line of Location / Address of Warehouse mentioned in Goods Receipt, Goods Shipment, Return Material Receipt and Return to Vendor Shipment window header. In case of Goods Movements, it is picked up from 1st line of Location / Address of Business Partner associated in Organization of "Storage Bin" located in line.

From_Address2

It is picked up from 2nd line of Location / Address of Warehouse mentioned in Goods Receipt, Goods Shipment, Return Material Receipt and Return to Vendor Shipment window header. In case of Goods Movements, it is picked up from 2nd line of Location / Address of Business Partner associated in Organization of "Storage Bin" located in line.

From_Place

It is picked up from 4th line of Location / Address of Warehouse mentioned in Goods Receipt, Goods Shipment, Return Material Receipt and Return to Vendor Shipment window header. In case of Goods Movements, it is picked up from 4th line of Location / Address of Business Partner associated in Organization of "Storage Bin" located in line.

From_Pin Code

It is picked up from 3rd line of Location / Address of Warehouse mentioned in Goods Receipt, Goods Shipment, Return Material Receipt and Return to Vendor Shipment window header. In case of Goods Movements, it is picked up from 3rd line of Location / Address of Business Partner associated in Organization of "Storage Bin" located in line.

From_State

It is picked up from 6th line of Location / Address of Warehouse mentioned in Goods Receipt, Goods Shipment, Return Material Receipt and Return to Vendor Shipment window header. In case of Goods Movements, it is picked up from 6th line of Location / Address of Business Partner associated in Organization of "Storage Bin" located in line.

Dispatch State

It is the state from where the material is being dispatched. It is picked up from 6th line of Location / Address of Warehouse mentioned in Goods Receipt, Goods Shipment, Return Material Receipt and Return to Vendor Shipment window header. In case of Goods Movements, it is picked up from 6th line of Location / Address of Business Partner associated in Organization of "Storage Bin" located in line.

To_OtherPartyName

It is the name of the business partner to whom material is being dispatched. It is picked up from business partner field located in Goods Shipment, Goods Receipt, Return Material Receipt and Return to Vendor Shipment header. In goods movement window, it is the organization of the new storage bin mentioned in line.

To_GSTIN

It is the GST number of the business partner to whom material is being dispatched. It is picked up from the "GST Unique ID" located in "GSTIN" tab of business partner selected in Goods Receipt, Goods Shipment, Return Material Receipt and Return to Vendor Shipment window. In case of Goods Movements, To_GSTIN is the Organization GSTIN of "New storage Bin" located in line.

To_Address1

It is the address where the goods are being shipped. It is picked up from 1st line of Location / Address of business partner mentioned in Goods Shipment, Goods Receipt, Return Material Receipt and Return to Vendor Shipment header. In case of Goods Movements, it is picked up from 1st line of Location / Address of organization of "New Storage Bin" located in line.

To_Address2

It is picked up from 2nd line of Location / Address of business partner mentioned in Goods Shipment, Goods Receipt, Return Material Receipt and Return to Vendor Shipment header. In case of Goods Movements, it is picked up from 2nd line of Location / Address of organization of "New Storage Bin" located in line.

To_Place

It is the name of the city where the the goods are being transported. It is picked up from 4th line of Location / Address of business partner mentioned in Goods Shipment, Goods Receipt, Return Material Receipt and Return to Vendor Shipment header. In case of Goods Movements, it is picked up from 4th line of Location / Address of organization of "New Storage Bin" located in line.

To_Pin Code

It is the pin code of the place where the goods are being transported. It is picked up from 3rd line of Location / Address of business partner mentioned in Goods Shipment, Goods Receipt, Return Material Receipt and Return to Vendor Shipment header. In case of Goods Movements, it is picked up from 3rd line of Location / Address of organization of "New Storage Bin" located in line.

To_State

It is the name of the state where the goods are being transported. It is picked up from 6th line of Location / Address of business partner mentioned in Goods Shipment, Goods Receipt, Return Material Receipt and Return to Vendor Shipment header. In case of Goods Movements, it is picked up from 6th line of Location / Address of organization of "New Storage Bin" located in line.

Ship To State

It is same as To_State. It is picked up from 6th line of Location / Address of business partner mentioned in Goods Shipment, Goods Receipt, Return Material Receipt and Return to Vendor Shipment header. In case of Goods Movements, it is picked up from 6th line of Location / Address of organization of "New Storage Bin" located in line.

Product

It is the name of the product which is being transported. It is picked up from Product drop down list in Goods Shipment, Goods Receipt, Goods Movements, Return to Vendor Shipment and Return Material Receipt line.

Description

It is the description of the product which is being transported. It is picked up from Description text field in Goods Shipment, Goods Receipt, Goods Movements, Return to Vendor Shipment and Return Material Receipt line.

HSN

It is the HSN code of the product which is being transported. It is picked up from GST Product Code field in Product window.

Unit

It is the unit of the product which is being transported. It is picked up from Unit field in product window.

Qty

It is the quantity of the product which is being transported. It is picked up from Movement Quantity field in Goods Shipment, Goods Receipt, Goods Movements, Return to Vendor Shipment and Return Material Receipt line.

Assessable Value

It is the assessable value of the product which is being transported. It is picked up from Assessable Value field in Goods Shipment, Goods Receipt, Goods Movements, Return to Vendor Shipment and Return Material Receipt line.

Tax Rate (S+C+I+Cess)

It is rate of the tax applicable on the product which is being transported.

CGST Amount

It is the CGST amount applicable on the product which is being transported. It calculated as (Assessable Value * CGST Rate)/100.

SGST Amount

It is the SGST amount applicable on the product which is being transported. It calculated as (Assessable Value * SGST Rate)/100.

IGST Amount

It is the IGST amount applicable on the product which is being transported. It calculated as (Assessable Value * IGST Rate)/100.

CESS Amount

It is the Cess amount applicable on the product which is being transported.

Total Invoice Value

It is sum of assessable value of all products and applicable taxes.

Trans Mode

It is the mode of transport by which product is being transported. It is picked up from Transport Mode drop down list of E-Way Bill section located in Goods Shipment, Goods Receipt, Goods Movements, Return to Vendor Shipment and Return Material Receipt header.

Distance (KM)

It is the transport distance. It is picked up from Distance field of E-Way Bill section located in Goods Shipment, Goods Receipt, Goods Movements, Return to Vendor Shipment and Return Material Receipt header.

Trans Name

It is the name of the transporter who is transporting the goods. It is picked up from "Trans Name" situated in header of Transport window. It is selected depending on the vehicle no selected in Transport drop down situated in E-way Bill section of Goods Shipment, Goods Receipt, Goods Movements, Return to Vendor Shipment and Return Material Receipt header.

Trans ID

It is the GST number of the transporter who is transporting the goods. It is picked up from "Trans ID" situated in header of Transport window. It is selected depending on the vehicle no selected in Transport drop down situated in E-way Bill section of Goods Shipment, Goods Receipt, Goods Movements, Return to Vendor Shipment and Return Material Receipt header.

Trans Date

It is the date when the goods are being transported. It is picked up from Trans Date field of E-Way Bill section located in Goods Shipment, Goods Receipt, Goods Movements, Return to Vendor Shipment and Return Material Receipt header.

Vehicle No

It is the number of the vehicle by which the goods are being transported. It is picked up from Transport field of E-Way Bill section located in Goods Shipment, Goods Receipt, Goods Movements, Return to Vendor Shipment and Return Material Receipt header.

Vehicle Type

It is the type of the vehicle through which goods is being transported. It is picked up from "Vehicle Type" situated in Transport window line. It is selected depending on the vehicle no selected in Transport drop down situated in E-way Bill section of Goods Shipment, Goods Receipt, Goods Movements, Return to Vendor Shipment and Return Material Receipt header.

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

• GST Clossed Receipt Template and

• GST Print Receipt Template

POS Print Templates

Role – System Admin, window – POS Print Templates

GST Print Receipt Template

GST Closed Receipt Template

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.

POS Terminal

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

• Organization GSTIN
• HSN / SAC code
• Breakup between CGST, SGST and UTGST as applicable

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

Or type Generate GSTR in Quick Launch.

Upon completion, it creates records in GST Return window.

Fields of this window are

Return Type

Select GSTR 1 at this drop down

Organization

Features of this field are

• It is a drop down list

• It shows only those organizations which are of type "Legal with Accounting"

• This organization filter does not show any other organization which is not of type "Legal with Accounting"

GST Unique ID

Features of this field are

• It is a drop down list.

• It lists all the GSTINs defined for the Legal Organization which is selected in the Organization field.

• It does not show any GSTIN which is not defined for the legal organization selected in the organization field.

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

New fields are added at the header.

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

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.

Organization

Features of this field are

• It is a drop down list

• It shows only those organizations which are of type "Legal with Accounting"

• This organization filter does not show any other organization which is not of type "Legal with Accounting"

GST Unique ID

Features of this field are

• It is a drop down list.

• It lists all the GSTINs defined for the Legal Organization which is selected in the Organization field.

• It does not show any GSTIN which is not defined for the legal organization selected in the organization field.

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.