The VAT Transaction Report lists the data captured in the ‘Reference_Field’ of expense claim /bank or cash payments.
Reference field is only a short reference_id, but the clear detail of the transaction is entered in the item description field.
And many a time a expense claim will hold multiple entries ( line items) with and without VAT. But the “Vat Transaction Report” lists only the Reference_Field and the total of all VAT Transactions.
The Correct Report is to display like :
Date 1 | Reference 1 | Description line item 1 | VAT_No# 1 | Amount 1 | VAT Amount 1
Date 1 | Reference 1 | Description line item 2 | VAT_No# 2| Amount 2 | VAT Amount 2
Date 1 | Reference 1 | Description line item 3 | VAT_No# 3| Amount 3| VAT Amount 3