Uploading sales invoices that contain multiple VAT codes

SOLVED

Hi,

We currently use an excel template to upload our sales invoices. However, a single invoice will often contain a mix of zero rated and standard rated VAT, which means we are uploading these as 2 lines, so that the net sales figure is appearing correctly in our VAT return for zero rated VAT and standard rated VAT. The side effect of this is that the one invoice is then appearing as 2 lines on the statements we are issuing to our customers. Is there a way to make the invoice only appear once on the customer statement?

Many thanks.