Easy way to add VAT on a report

Kisu

I'd like to add a VAT % and the VAT price for my total price on a report, what would be the easiest way to add it?

Report would be like in Sales - Quote report (204)

total...
vat...
total incl vat...

Do I haveto add the sales line dataitem or is it possible to just add record variable to get the VAT amount? :-k

Malajlo

Try to implement this in your code. You should already have all the vars

{ 90  ;TextBox      ;15540;0    ;2520 ;423  ;FontSize=9;
                                                         FontBold=Yes;
                                                         SourceExpr=Amount;
                                                         AutoFormatType=1;
                                                         AutoFormatExpr="Sales Invoice Line".GetCurrencyCode }
            { 92  ;TextBox      ;15540;423  ;2520 ;423  ;FontSize=9;
                                                         SourceExpr="Amount Including VAT" - Amount;
                                                         AutoFormatType=1;
                                                         AutoFormatExpr="Sales Invoice Line".GetCurrencyCode }
            { 94  ;TextBox      ;15540;846  ;2520 ;423  ;FontSize=9;
                                                         FontBold=Yes;
                                                         SourceExpr="Amount Including VAT";
                                                         AutoFormatType=1;
                                                         AutoFormatExpr="Sales Invoice Line".GetCurrencyCode }
            { 79  ;TextBox      ;11130;423  ;4200 ;423  ;FontSize=9;
                                                         SourceExpr=VATAmountLine.VATAmountText }
            { 80  ;TextBox      ;11130;0    ;4200 ;423  ;FontSize=9;
                                                         FontBold=Yes;
                                                         SourceExpr=TotalExclVATText }
            { 81  ;TextBox      ;11130;846  ;4200 ;423  ;FontSize=9;
                                                         FontBold=Yes;
                                                         SourceExpr=TotalInclVATText }

and text style of section...

Sales Invoice Line, Footer(11)

	[TotalExclVATText]			[Amount]
	[VATAmountLine.VATAmountText]	["Amount Including VAT" - Amount]
	[TotalInclVATText]			["Amount Including VAT"]

Kisu

Okay, thanks will try it