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

Summary

In the proposed system of new GST 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 (only GST RET-1) or quarterly basis. Annexure of Supplies (GST ANX-1) and Annexure of Inward Supplies (GST ANX-2) will be filed as part of these returns.

All the outward supplies and inward supplies liable to tax on a reverse charge basis, including imports and inward supply of goods from SEZ, will be detailed in GST ANX-1. GST ANX-2 will contain 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 and Form GSTR-6.

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

On the basis of details uploaded in GST ANX-1 and the actions taken in GST ANX-2, by the taxpayer, the relevant fields of their Form GST RET-1 will be auto-drafted. Taxpayers can now view its details, enter details in the relevant column, save it and download it in pdf format.

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

This document explains how to set up and work with AX2012 R3 to generate CSV file through the new offline tool

The solution to support the GSTR offline tool reporting is based on electronic reporting functionality. This functionality provides a flexible approach for setting up and supporting reporting processes.

This article contains the following parts:

• Import the configuration.

• Generation of ANX-1

• Generation of Purchase Register

 Steps for setups

These tasks will prepare Finance to reporting ANX-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.

• Taxable Document.version.64

• Taxable Document (India). version.64.117

• Tax (India GST). version.64.117.222

Configuration with SEZ/DE/Export order.

• Taxable Document (India). version.64.119

• Tax (India GST). version.64.119.226

Import and set up Electronic reporting (ER) configurations.

To prepare Finance for GSTR Return reporting, you must import the following or higher versions of ER configurations in sequence provided below:

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

Note: After all the ER configurations from the preceding table are imported, user need to do mapping of Report configuration in the Tax setup

Overview

Important transactions for ANX-1

Important transactions for Purchase Register

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

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

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

See below generated Purchase register

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

7. Click ok

See below the generated CSV file:
 

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.