Sorry, this morning I have gone through everything again, and the
simplified example was wrong, but corrected it gives the right answer,
however although I'm sure I've done the same with the main script I can
not get the correct answer.
I need to round each article seperatly so that the Vat inc prince
remains the same.
So a 10.03 without vat always makes 12.00 with vat.
My test files works as it should :
<?php
$total = 0;
$ht = 10.03;
$vat = 19.6;
$total += sprintf("%0.2f",$ht*($vat/100+1));
print("Total = ".sprintf("%0.2f",$total));
$total += sprintf("%0.2f",$ht*($vat/100+1));
print(" - Total 2 = ".sprintf("%0.2f",$total));
?>
Result : Total : 12 - Total 2 : 24
However the file I'm working on does not :(
The script I'm working on makes use of the fpdf php project which
automaticaly creates PDF files.
Here is the extract of code :
while ( list($code_tva, $articleHT) = each( $px ) )
{
$tva = $tab_tva[$code_tva]; // is 19.6 %
$this->SetXY(15, $y); //sets the coordinates of cell to be created in
PDF file for each item )
$this->Cell( 21.5,4, sprintf("%0.2f", $articleHT),'', '','C' ); //
inserts the item
//=====================>>>>> $totalHT is TOTAL without VAT and
$articleHT is a table which contains the price of each item without tax>>>
$totalHT += $articleHT; //adds all items without vat
//=====================>>>>> $totalTTC is TOTAL with VAT >>>
$totalTTC += sprintf("%0.2f", ($articleHT * ( 1 + $tva/100 ))); // adds
the rounded (item * 1.196) (including vat)
//=====================>>>>> $totalTVA is TOTAL of VAT >>>
$tmp_tva = sprintf("%0.2f",$articleHT * $tva/100); //amount of VAT of
current item
$a_tva[ $code_tva ] = $tmp_tva;
$totalTVA += $tmp_tva; //adds current item's vat to total vat
$this->SetXY(10, $y);
$this->Cell( 5,4, $code_tva, 0,0,"C"); //prints vat option
$this->SetXY(58, $y);
$this->Cell( 21.5,4, sprintf("%0.2f",$tmp_tva),'', '' ,'C'); //prints
the current item's vat amount
$this->SetXY(79.5, $y);
$this->Cell( 21.5,4, sprintf("%0.2f",$tva) ,'', '', 'C'); //prints the
vat percentage for item
$y+=4;
}
$this->SetXY(114,266.4);
$this->Cell(15,4, sprintf("%0.2f", $totalHT), '', '', 'R' ); //prints
the total amount excluding vat
$this->SetXY(114,271.4);
$this->Cell(15,4, sprintf("%0.2f", $totalTVA), '', '', 'R' ); //prints
total amount including vat
This is how I see it :
If I have two different items ($articleHT) at 10.03 this line ($tva =
19.6 and $articleHT = 10.03) :
$totalTTC += sprintf("%0.2f", ($articleHT * ( 1 + $tva/100 )));
Should add 12.00 to $totalTTC However it seems to add 11.99588 to
$totalTTC instead ...
In my test files it does exactly this, any idea why it would not do this
in the real file ?
Thanks again :)
lists-php a écrit :
your issue is with rounding, and whether vat is applied (rounded)
per-item or on the invoice total.
your sprintf output is simply truncating and rounding on display. you
aren't storing the rounded (up) value.
increase the decimal positions to 4 or 6 and you'll see things better.
Total = 11.995880 - Total 2 = 23.991760
the vat on 10.03 is 1.96588, which when you only display 2 positions
on display rounds up to 1.97.
if you stored the rounded value ,on a per-item basis, you'd get what
you're after.
now, the question is whether vat is applied per item or on the
invoice total.
the difference becomes more obvious with say 3 items, at 10.03. on a
(rounded) per-item basis the vat total would be 5.91. on an invoice
total it would be 5.90 (rounded up from 5.89784).
- Rick
------------ Original Message ------------
Date: Saturday, March 22, 2008 10:35:12 PM +0100
From: Richard <php_list@xxxxxx>
To: PHP lists <php-general@xxxxxxxxxxxxx>
Cc:
Subject: Re: sprintf problem... (with simplified code )
Here is a simplifie version of my code :
<?php
$total = 0;
$ht = 10.03;
$vat = 19.6;
$total += $ht*($vat/100+1);
print("Total = ".sprintf("%0.2f", $total));
$total += $ht*($vat/100+1);
print(" - Total 2 = ".sprintf("%0.2f", $total));
?>
I get 12.00 and 23.99 ... what should I do to get 12.00 and 24.00 ?
Richard a écrit :
Hello, I'm trying to write a invoice script but I have encountered
a slight problem.
Each product needs to be listed without tax, and at the end of the
file I need to show the VAT. In France VAT is 19.6%
So €10.03 without vat = €12.00 with vat.
So I do this :
$totalwithoutvat = 0;
$totalwithoutvat = 0;
$totalvat =0;
while ( $itemwithoutvat) = each( $px ) )
{
$totalwithoutvat += $itemwithoutvat;
$totalwithoutvat += sprintf("%0.2f", $itemwithoutvat * ( 1 +
19.6/100 )); $totalvat += sprintf("%0.2f",$itemwithoutvat *
19.6/100); }
print ("Total Vat =".sprintf("%0.2f",$totalvat)." - Total without
vat = ".sprintf("%0.2f",$totalwithoutvat)." - Total with vat =
".sprintf("%0.2f",$totalwithvat));
But I'm not sure I am using sprintf correctly, maybe I should use
a different function because :
When I have one item at 10.03, the result is : Total Vat = 1.97 -
Total without vat = 10.03 Total with vat = 12.00
but if I have two items at 10.03 the result is : Total vat = 3.93
- Total without vat = 20.06 Total with vat = 23.99
but I need it to be : Total vat = 3.94 - Total without vat = 20.06
Total with vat = 24.00
So from what I can see, sprintf only seems to work for printing
and the actual result is kept in memory, is this correct ? if so
what function should I use instead?
Thanks in advance :)
Richard
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
---------- End Original Message ----------
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
