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
Need more, need help now?
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals
Add a VAT Summary to my invoice template in Sage Line 50
-
- User
- Posts: 3
- Joined: 19 Mar 2013, 11:33
- Sage Version: V11 UK/Europe/Africa
- brucedenney
- Site Admin
- Posts: 4631
- Joined: 28 Feb 2006, 09:56
- Sage Version: v28 UK/Europe/Africa
Re: Add a VAT Summary to my invoice template in Sage Line 50
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.
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.
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.
-
- User
- Posts: 3
- Joined: 19 Mar 2013, 11:33
- Sage Version: V11 UK/Europe/Africa
Re: Add a VAT Summary to my invoice template in Sage Line 50
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
I am using Line 50 version 11.
Kind Regards,
Jamie
- brucedenney
- Site Admin
- Posts: 4631
- Joined: 28 Feb 2006, 09:56
- Sage Version: v28 UK/Europe/Africa
Re: Add a VAT Summary to my invoice template in Sage Line 50
Here is the layout.
Login to access the files attached to this post.
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.
-
- User
- Posts: 3
- Joined: 19 Mar 2013, 11:33
- Sage Version: V11 UK/Europe/Africa
Re: Add a VAT Summary to my invoice template in Sage Line 50
Thank you very much for your invaluable help. The solution worked perfectly.
Kind Regards,
Jamie
Kind Regards,
Jamie
Who is online
Users browsing this forum: No registered users and 7 guests