(03-01-2016, 08:15 AM)daveparrish Wrote: Hi All
When I created a quotation the tax only shows the Authoritie not all in the tax group.
I looked at PDFQuotationPortrait.php code not sure what is causing this.
version 4.12.3
Any help would be appreciated.
Here is the code that I have tried to change with no luck anyone have any ideas.
$sql3 = "SELECT taxgrouptaxes.taxauthid
FROM taxgrouptaxes INNER JOIN custbranch
ON taxgrouptaxes.taxgroupid=custbranch.taxgroupid
WHERE custbranch.branchcode='" .$Branch ."'";
$result3=DB_query($sql3, $ErrMsg);
while ($myrow3=DB_fetch_array($result3)){
$TaxAuth = $myrow3['taxauthid'];
}
$sql4 = "SELECT * FROM taxauthrates
WHERE dispatchtaxprovince='" .$TaxProv ."'
AND taxcatid='" .$TaxCat ."'
AND taxauthority='" .$TaxAuth ."'";
$result4=DB_query($sql4, $ErrMsg);
while ($myrow4=DB_fetch_array($result4)){
$TaxClass = 100 * $myrow4['taxrate'];
}
$DisplayTaxClass = $TaxClass . '%';
$TaxAmount = (($SubTot/100)*(100+$TaxClass))-$SubTot;
$DisplayTaxAmount = locale_number_format($TaxAmount,$myrow['currdecimalplaces']);