Under General Ledger -> Vat Submission -> History Logs there is a dump of the raw data sent to HMRC. Clicking on these will open it in notepad which you can then save to your local PC (M:\ Drive).
There are three types of files generated in the History Log.
1. The raw calculation of the submitted data and the transactions used to calculate the submission.
This is the filename SubmittedVatData
Read this guide here to learn how to read the MTD Transaction Data
2. A dump of the period key and figures.
This is the filename Vat<period key><date>
3. A VAT Log with submission numbers and logging data.
This is the filename Vatlog<date>
If you want to generate a report over previously SubmittedVATData csv file in a Ledger Inquiry Report format you will need to grab the submission number from the Vatlog file.
At the end of the file you will see a submission flag.
Go to General Ledger -> Ledger Inquiry -> Reports -> Selection and input this submission flag number into the VAT Submission Field and then run your report.
