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 Sales - Against Form C

     Interstate Sales - E1

     Interstate Sales - E2

     Interstate Purchase Exempt - E1

 

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.

MAIN_COMMODITY

Displays the Main Commodity name predefined for the stock item selected in the invoice.

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.

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 Code selected in the Statutory Details screen of purchase invoice.