Hi - I'd be interested to hear about this too, as I cannot see a way to comply with MTD (UK government tax reporting automation legislation) - as in not touching the records once the invoice details have been captured - that will account for a single invoice for supplies at different VAT rates. Either you configure the system to capture all VAT on one line, or else the total invoice VAT is distributed pro-rata across all the lines in the invoice, whether or not it's applicable. This would also cause real issues for anyone trying to integrate with any ERP with tax validation functionality - including any version of SAP! - because the tax code is checked against the tax value as % of net value, and throw up an exception when outside tolerances.
Neither way captures the expense with a tax code and amount attached, which by the way would also allow for accurate net cost v budget reporting directly out of Concur, which is a big SAP Concur Invoice selling point.
The only way around this I can see is to choose single line VAT, exclude this somehow from the GL extract, but instead use the tax codes to calculate the VAT on each invoice line. Bonkers! And I suspect non-compliant for MTD, as you're manipulating the values. And there are bound to be penny rounding issues.
Any ideas or opinions?
