I have an issue with VAT reporting. I’ve been trying to use PowerBI to do the tax reporting as we cant get all the fields from saved search.
The reporting works apart from that the VAT is group for each transaction and put onto 1 line
By this I mean if the vendor bill is posted to multiple accounts/cost centres etc and there are 5 lines each with £20 VAT, then you just get one line on the transactions/transactionline/transactionaccountingline table with £100 VAT against the VAT account code eg its not split between each cost centre etc.
I suspect if we had Suite tax then the tax tables would be available and I’d be able to get this information., but we dont. Are my assumptions correct?
Thanks
Paul