The new VAT audit trail report is great, thank you for adding it. It will making our partial exemption workings much easier.
Unfortunately, it has a serious coding error in it so it cannot be reconciled to the VAT100 report.
the "Tax Amount" column seems to be a calculated field based on "BC Amount" and default VAT code, and NOT the ACTUAL VAT amount that is on the system. Sometimes the actual VAT is overwritten on invoice processing for rounding differences or other reasons. Please can this be changed so that the VAT Amount is the actual VAT processed on the system, and not a calculated field.
We need to be able to rely on the integrity of this report and be able to reconcile the totals directly to the VAT100_audit_trail report and VAT return.
Less, critical but would be nice to have to make the report even more user friendly? Please could you:
1) Add a report filter to exclude all reversed transactions.
2) an additional column in the data with the VAT return Ref or "not assigned" to each transaction
3) On the generated report show in the header the report filter criteria.
Thanks!
Agreed, particularly with respect to point 4. The tax amount needs to reflect the actual VAT (not a recalculated field) and the Audit Trail Report should reconcile directly with the VAT return.