India Localization - GST
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
- 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 –
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.