SageForum for UK versions of Sage 50- Help and support.

Hi all,

Does anyone know how to add a VAT summary to a Sage Line 50 invoice template:

Tax Code / Tax Rate / Value

Any help would be greatly appreciated.

Many Thanks,


Jamie

You need to add additional invoice number footer sections for the vat summaries one for each vat code you need to report on.

The printing of each section is conditional on there being a value for that VAT code.

There are a bunch of variables that Sage uses to maintain the VAT summary.

Each of these if for a different VAT code

INVOICE.NET_AMOUNT_1 INVOICE.TAX_RATE_1 INVOICE.TAX_AMOUNT_1

The field represent Net amount, Tax %ge and Tax Amount There is nothing for Tax code If you had 2 tax codes with the same rate, I am not sure what it would do.

You should have a standard layout that does this "A4 Inv\Crd Unit Price, With Discount (Tax Breakdown)", have a look in the demo company if you don't have it in your main company.

what version of sage 50 are you on ? I could post an example.

Many thanks for your quick and helpful response. I will give it a go tomorrow and let you know how I get on.

I am using Line 50 version 11.

Kind Regards,

Jamie

Here is the layout.

Thank you very much for your invaluable help. The solution worked perfectly.

Kind Regards,

Jamie