Annexure LP-3 Table A of Form VAT R1 (Haryana)

This table captures invoice wise details of goods purchased which are in course of interstate subsequent sales against form EI/EII.

To view and export Annexure LP-3 Table A

1. Go to Gateway of Tally > Display > Statutory Reports > VAT > select Form VAT R1.

2. Select Annexure Ready and press Enter.

3. Select Annexure LP-3 Table A and press Enter. The Annexure LP-3 Table A screen appears as shown below:

4. Click E: Export.

5. Press Enter to export data.

The exported data appears in the TEMPLATE-VAT-RETURN-R1-LP3A-INVOICEWISE_LIST_OF_PURCHASE_OF_GOODS-EXCEL.xls file.

Note: The Excel file should be imported into the return filing utility provided by the government.

The value of LP-3 Table A is captured in Form VAT R1- 3. 3A. (3)(i) Purchased in the course of inter-State trade.

The description of the information displayed in each field of the Excel sheet is given below:

Field Name	Description
Serial No.	Displays the serial number of the rows in the annexure.
Name and address of dealer/ person from whom goods purchased *	Displays the name and address of the dealer from whom the goods are purchased (as predefined in the party ledger or entered in the Party Details screen while recording purchase transaction).
TIN*	Displays the TIN of the dealer from whom the goods are purchased.
Sale Invoice /Delivery Note No. *	Displays the seller’s invoice number (as entered in the Party Details screen while recording purchase transaction).
Sale Invoice /Delivery Note Dated *	Displays the seller’s invoice date (as entered in the Party Details screen while recording purchase transaction).
Name of the Commodity purchased (1), (2), (3), (4)	Displays the commodity name predefined for the stock item selected in the purchase transaction. The major commodities are listed as per the list provided by the department. If commodity name provided is other than those provided by the department, Others is displayed. Maximum up to four major commodities can be selected.
Other name of commodity purchased	If commodity name provided by the department is not selected in the Name of the commodity purchased * field, then the commodity name provided in the stock masters is displayed.
Unit of measurement	Displays the unit of measurement for the stock item selected in the purchase transaction. The unit of measurement is listed as per the list provided by the department.
Quantity	Displays the quantity of goods purchased in the course of interstate trade.
Value of Goods*	Displays the net assessable value of purchases with Nature of Transaction selected as Interstate Purchase Exempt - E1 and Interstate Purchase - EII.
Whether Consequent sales transacted in the state of Haryana or Outside the state of Haryana	Displays if consequent sales is In the state or Outside the state. In the State is displayed when Haryana is selected as state in Statutory Details screen while recording a purchase transaction. Outside the State is displayed when other states are selected in Statutory Details screen while recording a purchase transaction.
Whether Consequent sales transacted as E-I Sales or E-II	Displays the type of consequent sales (as selected in the Party Details screen while recording purchase transaction).
Whether Consequent sales transacted	Displays the form against which the consequent sales is made (as selected in the Party Details screen while recording purchase transaction).
Whether goods classified as Capital Goods	This field is enabled when Capital Goods is selected as the Type of Goods in VAT Details screen while recording ledger master.