Because all Auditors ask the same question during their audit ("can you show me a VAT reconciliation report?") I started to develop such a report.
The idea is to match each VAT related G/L entry with the correspoding VAT entry and to show for each G/L account all used VAT codes (VAT product posting group) and the total amounts for Gross, Base and VAT.
So far I was quite successfull but I have one problem on the sales VAT. As soon there is a line discount, Navision creates a G/L entry for the gross income and another one for the discount. But there is only one VAT entry for the balance of the two entries. So the gross income is marked as VAT related, but the discount isn't. On my report I select only gross income and there is a difference between calculated and posted VAT.
Does anybody has an idea about how this could be solved? This problem occured in 3.70 CH and I am going to test if it has been solved in later versions.