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!
Our school is extremely frustrated by the noticeable lack of progress on feature requests within this portal. Many highly requested enhancements have remained unaddressed for years, despite ongoing demand from users. This prolonged lack of development has led to growing dissatisfaction and concerns about whether customer feedback is being adequately considered in the product roadmap.
If other users share these concerns and would be interested in establishing an independent forum to discuss common issues, priorities, and collective engagement with the provider, please feel free to contact me directly at d.moss@hamptonschool.org.uk.
The "VAT Audit Trail Report " seems to have been amended now and renamed to "VAT (TAX) Detail Report" (saves when exported as: "isams_gl_audit_trail_partialreclaim"). It now makes even less sense than before - outside VAT scope transactions appear on the report that you explicitly ask to exclude. This report is confusing and not fit for purpose and should be deleted asap.
I tried the new custom report that has been added in response to this IDEA called "Sales and Purchases Tax Detail Combined (with Analysis/GL)". Seems like I was a bit premature in my thanks on 24 March! This one is almost what is needed, but it still has a serious error in it. There is no total for the transaction VAT column, and when you do total it, the VAT doesn't agree to the VAT100_audit_trail report.
I have emailed helpdesk to try to get it fixed.
Looks like almost a whole year after I raised this serious error, the offending report has finally been removed from AIQ and replaced with one that agrees to the VAT return. Better late than never! Thanks for taking time to understand the issue and resolving.
I have now sent a video illustrating this error via iSAMS helpdesk, as no one in the various support teams that I have dealt with in almost one whole YEAR, seems to understand or believe there is a problem. This idea is not a feature request - it is to correct an error on one of the AIQ reports.
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.