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