e-CST C - Form Requisition (Goa)

The C-Form Requisition report can be generated from Form 1V report for sales recorded with the following nature of transactions:

● Interstate Purchase - Against Form C

● Interstate Purchase - E1

● Interstate Purchase - E2

● Interstate Purchase Exempt - E1

● Interstate Purchase Exempt - With Form C

To export the data to C Form requisition template

1. Copy the excel template to the Tally.ERP 9 installed folder.

2. Go to Gateway of Tally > Display > Statutory Reports > VAT > Form 1V.

3. Select Annexure Ready and press Enter.

4. Select C - Form Requisition and press Enter.

5. Click E: Export button to display the Export Report screen. Ensure the excel template SF_COMPLETE C FORM.xls is available in the Export Location.

Note: Based on the Form 1V report period, the From and To dates are displayed here. These dates can be changed from e-CST Annexures report, if required.

6. Press Enter to export data.

The data gets exported to the template.

Description of data captured in each column of the excel template is tabulated below:

Column Name	Description
TIN	Displays the TIN entered in Company VAT Details screen of Statutory & Taxation features.
SELLER_NAME	Displays the name of the party entered in the party ledger or in the Party Details screen of the invoice.
SELLER_ADDRESS	Displays the address of the party entered in the party ledger or in the Party Details screen of the invoice.
SELLER_STATE	Displays the State predefined in the party ledger or entered in the Party Details screen of the invoice.
SELLER_TIN	Displays the party's VAT TIN entered in the party ledger or in the Party Details screen of the invoice.
SF_TYPE	Displays the alphabet 'C'.
INVOICE_NO	Displays the Supplier Invoice No. entered in the purchase invoice.
INVOICE_DATE	Displays the supplier invoice Date entered in the purchase invoice.
COMMODITY_DESC	Displays the Commodity name predefined for the stock item selected in the invoice. In VAT Details screen of stock item, enter the Commodity name.
MAIN_COMMODITY	Displays the Main Commodity name predefined for the stock item selected in the invoice. In VAT Details screen of stock item, enter the Main Commodity name.
INVOICE_VALUE	Displays the assessable value of the invoice. This includes the additional expenses entered in the invoice by selecting the ledger enabled for apportionment. In the expense or income ledger, the option: ● Include in assessable value calculation for is set to VAT ● Method of Calculation is set to Based on Quantity or Base on Value.
PURCHASE_ORDER_NO	Displays the Purchase Order No. entered in the Statutory Details screen of purchase invoice.
PURCHASE_ORDER_DATE	Displays the purchase order Date entered in the Statutory Details screen of purchase invoice.
PURPOSE_CODE	Displays the Purpose of purchase selected in the Statutory Details screen of purchase invoice.

Last updated for Release 5.5.3