New GSTR Offline Tool (ANX-1 and Purchase Register) for India in Dynamics AX2012R3

Applies to: Dynamics AX 2012 R3

Summary


In the proposed system of newGST Return filing, a normal taxpayer would have to file FORM GST RET-1 (Normal)or FORM GST RET-2 (Sahaj) or FORM GST RET-3 (Sugam), on either monthly (onlyGST RET-1) or quarterly basis. Annexure of Supplies (GST ANX-1) and Annexure ofInward Supplies (GST ANX-2) will be filed as part of these returns.

All the outward supplies andinward supplies liable to tax on a reverse charge basis, including imports andinward supply of goods from SEZ, will be detailed in GST ANX-1. GST ANX-2 willcontain details of inward supplies auto-populated mainly from the suppliers’GST ANX-1. It will also contain details of auto-populated from Form GSTR-5 andForm GSTR-6.

The taxpayer will be required totake action on details of inward supplies contained in Form GST ANX-2, byaccepting or rejecting the entries. The taxpayer can also keep the documentspending by marking the documents accordingly.

On the basis of details uploadedin GST ANX-1 and the actions taken in GST ANX-2, by the taxpayer, the relevantfields of their Form GST RET-1 will be auto-drafted. Taxpayers can now view itsdetails, enter details in the relevant column, save it and download it in pdfformat.

GSTN has released a trialversion of the New Returns Offline Tool of Form GST ANX-1, Form GST ANX-2 (withMatching Tool built in it) and a template for Purchase Register, which can beused to import data of purchase register for matching with ANX-2.

  

This document explains how to set upand work with AX2012 R3 to generate CSV file through the new offlinetool

The solution to support the GSTRoffline tool reporting is based on electronic reporting functionality. Thisfunctionality provides a flexible approach for setting up and supportingreporting processes.

 

This article contains the followingparts:

 

  • Import the configuration.
  • Generation of ANX-1
  • Generation of Purchase Register

 

 Steps for setups

These tasks will prepare Finance to reportingANX-1:

  • Import and set up Electronic reporting (ER) configurations.
  • Mapping of reporting configuration in Tax setup
  • Provide report data for report generation.
    • ANX-1
    • Generate ANX-1 (10 CSV) files
  • Provide report data for report generation.
    • Purchase Register
    • Generate Purchase Register excel file.

 

Import tax configuration.

  • TaxableDocument.version.64
  • TaxableDocument (India). version.64.117
  • Tax (IndiaGST). version.64.117.222

 

Configurationwith SEZ/DE/Export order.

  • TaxableDocument (India). version.64.119
  • Tax (IndiaGST). version.64.119.226

 

Import and set upElectronic reporting (ER) configurations.

To prepare Finance for GSTR Return reporting, you must import thefollowing or higher versions of ER configurations in sequence providedbelow:

image.png

Import the latest versions of these configurations. The versiondescription usually includes the changes that were introduced in theconfiguration version.

Note: Afterall the ER configurations from the preceding table are imported, user need todo mapping of Report configuration in the Tax setup

image.png


Overview


Importanttransactions for ANX-1

 

Name

Report

File Format

Description

Fields covered

B2C CSV

ANX-1

CSV

Supplies made to consumers and un-registered persons (Net of debit notes, credit notes)

Place of supply, Differential % of Tax Rate, Taxable value, Supply Covered Under Sec 7 of IGST Act, Rate, Integrated tax, central tax, State Tax, Cess 

B2B CSV

ANX-1

CSV

Supplies made to registered persons (other than those attracting reverse charge) (including edit of rejected documents)

GSTIN/UIN of Recipient, Trade/Legal  Name, Document Type (Debit note/credit note/Invoice) ,document number, document date, document value, place of supply, Differential % of tax rate, Supply covered under section 7 of IGST Act, HSN, rate, Taxable value , Integrated tax, central tax ,State Tax/UT, Cess 

EXP

ANX-1

CSV

Exports with payment of tax and Without payment of tax

Not supported with current Tax configuration version 82.143.xxx or earlier version.

SEZ

ANX-1

CSV

Supplies to SEZ units/developers with payment of tax and without payment of tax (including edit of rejected documents)

Not supported with current Tax configuration version 82.143.xxx or earlier version.

DE

ANX-1

CSV

Deemed Exports

Not supported with current Tax configuration version 82.143.xxx or earlier version.

RV

ANX-1

CSV

Inward supplies attracting reverse charge (to be reported by recipient, GSTIN wise, net of debit/credit notes and advances paid, if any)

GSTIN/PAN of Supplier, Trade/Legal  Name, place of supply, Differential % of tax rate, Supply covered under section 7 of IGST Act, Supply Type (inter-state/Intra-state) , HSN code, rate, Taxable value , Integrated tax, central tax ,State Tax/UT, Cess 

IMPS

ANX-1

CSV

Import of services (net of credit/debit notes and advances paid, if any)

place of supply, HSN code, rate, Taxable value, Integrated tax, central tax, State Tax/UT, Cess 

IMPG

ANX-1

CSV

Import of services (net of credit/debit notes and advances paid, if any)

place of supply, HSN code, rate, Taxable value, Integrated tax, central tax, State Tax/UT, Cess 

IMPGSEZ

ANX-1

CSV

Import of goods from SEZ units on a Bill of Entry

Not supported with current Tax configuration version 82.143.xxx or earlier version.

ECOM

ANX-1

CSV

Details of the supplies made through e-commerce operators liable to collect TCS under section 52

GSTIN of E-com, Trade/Legal Name, Value of supplies, value of supplies returned, Net value of supplies, Integrated tax, central tax, State Tax/UT, Cess

 

Importanttransactions for Purchase Register

 

Name

Report

File Format

Description

Fields covered

Purchase

Register

PR

XLSX

This cover inward supplies from following sources: B2B, DE, SEZWP, SEZWOP

GSTIN of supplier, Trade/Legal name ,Type of inward supplies, Document type, Document number, document date, Taxable value, Total tax, Integrated tax, Central tax, State/UT tax, Cess

 

 


Setup


Process to Generate data in .CSV file

(a) Deploy the below mentioned files from LCS.

Place all this files in one folder and deploy it like shown below.
  • GSTReturnsGovt.version.19
  • GST ANX-1 Govt. offline tool. version.19.22
  • GSTR1GovtCSV.version.19.10
  • Purchase Register.version.19.7
 
image.png

(b) Loading of Report Configuration files in 2012 R3

  •  Select the Report configuration files and place in Folder
  •  Go to General Ledger>>Set up >>Sales tax>>India>>Load configurations>>select the Report configuration files folder>> click on ok.
 
image.png

 

image.png

(c) Mapping of Report configuration in the Tax setup.
  • Go to General Ledger>>Set up >>Sales tax>>India>>Tax set up >>Configurations>>click Report configuration tab.
• Mark Select checkbox.
• Select the value in Report data provider field.
• Click Close.
 

(d) Generate ANX-1 report and Purchase Register.
(a) Purchase Register Report Data
  • Go to General Ledger>>Reports>>India>>GER export to GSTR CSV
  • Define from date
  • Define to date
  • Select GSTIN Registration number
  • Select Configuration” Purchase Register”
  • Define file name, to save the report with name.  
  • Click ok.
 
image.png


See below generated Purchase register
 
image.png



(b)    ANX-1 report Report Data.
1. Go to General Ledger>>Reports >>India>>GER export to GSTR CSV.
2. Define from Date.
3. Define to Date
4. Select GSTIN Registration number
5. Select configuration “GST ANX -1 Govt. offline tool”
6. Define file name, to save the report with name.
 
image.png

7. Click ok
    See below the generated CSV file:
 
image.png

More information


You can contact technical support for Microsoft Dynamics by phone using these links for country specific phone numbers. To do this, visit one of the following Microsoft websites:

Partners

https://mbs.microsoft.com/partnersource/resources/support/supportinformation/Global+Support+Contacts

Customers

https://mbs.microsoft.com/customersource/northamerica/help/help/contactus

In special cases, charges that are ordinarily incurred for support calls may be canceled if a Technical Support Professional for Microsoft Dynamics and related products determines that a specific update will resolve your problem. The usual support costs will apply to any additional support questions and issues that do not qualify for the specific update in question.

Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained here in is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use for other considerations.