Exported VAT files have duplicate invoice entries

I have run my last quarters VAT return. When I check the hard copies of the reports they seem correct. But when I export them as a csv and open the reports in excel some of the invoices/ credit notes have been duplicated. So the excel version does not match. Has anyone else experienced this? Is there a way of stopping this happen?

  • Hi Joanne,

     

    There is an issue we’re aware of where, when exporting reports or layouts as a CSV file, the last item line on each order or the last transaction is duplicated. On some reports the first transaction is duplicated.

     

    For full information on how to resolve this you can refer to Ask Sage article 29734.


    Regards,

    Paul
    Sage GB