When creating a sales invoice in version 4.0 (GB version) I am encountering the problem that the VAT % for the whole invoice seems to be taken from the first invoice line and the VAT posting groups for subsequent lines are ignored. Is this a known problem in version 4.0? e.g. Invoice for customer with vat bus. posting group 17.5 line 1 g/l account 7511 (vat. prod. posting group 17.5) amt £100 line 2 g/l account 7512 (vat. prod. posting group OS) amt £100 where posting group OS has 0% VAT The total amt of invoice is £200, VAT is £35.00 (should be £17.50) If I swap the lines around, e.g. line 1 g/l account 7512 (vat. prod. posting group OS) amt £100 line 2 g/l account 7511 (vat. prod. posting group 17.5) amt £100 then the total amt of invoice is £200, VAT is £0.00 (still should be £17.50) Any ideas? Thanks.
All sorted now. The VAT Identifier field on the VAT Posting Setup table was blank. By entering a value which represents the different levels of tax the system is calculating VAT as required.