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
'e-CST C - Form Requisition (Goa)' has been shared with
