Topic: UK VAT returns
Just been setting up FrontAccounting and must say am very impressed with what I have seen so far.
Have one problem though. I know the topic of UK VAT has been discussed before and in fact because we file on an accrual basis I think we can get round this without too much difficulty.
However, we export most of our products many to VAT registered companies in the EU. For these we have to file a separate Sales List which just lists the VAT number and total sales value for each customer during a three month period.
I can't see a way of achieving this simply without going into the black hole (for me) of SQL. We can nearly get there by creating an EC tax group and a dimension. Then, by doing a GL transaction query we get individual sales lists. The only problem is that it lists each invoice line rather than just the total for each customer and in addition I can't find any way of including the shipping charge. Adding a column with the VAT number shouldn't be a problem (I hope) but any help on how to achieve what we want would be a help.
Great product though.