I am likely being a bit dumb here, but am prepared to risk it.
I have looked at custom reports and read some of the help info thereto, but am no wiser. Here is what I want to do:
I need to do 2 different VAT reports.
1 showing output VAT including Invoice number, date, vat amount, total and the description (top one not the item one). So far so good. But I need the amounts to be in the currency of the transaction.
2 the same thing for input vat
So far I have been copying and pasting bits and pieces to excel then weeding and rearranging columns. It is time consuming and not elegant at all. Maybe there is a better way?