Sage 200 UKI Ideas Portal

VAT Calculating on Lines different to the header due to rounding differences where there are numerous lines

When an invoice has for example 70 lines each lines has net and vat which is printed on the invoice. The header then calculates the VAT on the Net value not the individual lines. Due to rounding this can causes discrepancies. Is there a possibility of being able to calculate the VAT as sum of the lines? As you can imagine when printing the invoice the individual lines and the invoice total do not correctly add up. The net is always the same but the VAT and Gross is different. Maybe a button could be added to recalculate? To rectify this we have to correct the transaction in the Sales Ledger once posted across and we then have to in the background update the SOPOrderReturn table and the SOPInvoiceCredit table. The customer in question has monthly invoices which are large so each month we have to correct them for them.

  • Guest
  • Jun 5 2020
  • Idea Accepted - Gauging Support