Tally.ERP 9 is not exporting data to the Cst_Mst/PurOrdDt column in the Online C Form and Cst_Mst/TransDelvDate column in the Online F Form of Chhattisgarh VAT templates

Values are not posted to these columns when exporting data from Tally.ERP 9. However, you can copy the date from a different excel sheet to the excel template after exporting data from Tally.ERP 9.

Scenario

In the excel templates of the Online C Form and Online F Form of Chhattisgarh VAT, the date columns are formatted to accept values in MM/DD/YYYY, but when the month number starts with 0, for example 01 for January, the value is changed to a single digit 1. Because of this issue, the template cannot recognize the value posted in these columns, and can't be converted to xml.

To copy date from a different excel sheet to the excel template

1. Open an excel file.

2. Right-click a column header and select Format Cells from the menu displayed.

3. Select Date under Category .

4. Select MM/DD/YYYY format under Type .

5. Click Ok .

6. Go to Online F Form in Tally.ERP 9. ( Gateway of Tally > Display > Statutory Reports > VAT > Declaration Forms > Forms Requisition > Online F Form )

7. Enter the dates from the Transport Delivery Date column in the report in the formatted column of the excel sheet for all transaction that are exported to the excel template.

8. Open the excel template to which data is exported from Tally.ERP 9 and copy the dates entered in the excel sheet to Cst_Mst/TransDelvDate column. Ensure that each date is copied against the corresponding invoice.

9. Click Convert to XML . The xml file will be generated.

Similarly, you can enter dates in the Cst_Mst/PurOrdDt column of Online C Form from the report in Tally.ERP 9.