VAT monthly reporting

Summary

I am looking for a solution to show on the report canceled tax lines in different periods

Content

Currently, in our custom reports, we use ZX_Lines table, for displaying the vat amounts. But we have a problem with the canceled tax lines.

For each line we have only one record with 0 amount, in cases where the invoice line was already reported it's a problem, i expect to see on the current reporting period the amount being reduced and in the original period, i expect to see the record stay the same.

I would like to know if there any other tables that store vat records the way i can use them in the reports.