Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Quotation Not Showing tax Group
03-03-2016, 03:29 AM,
#2
RE: Quotation Not Showing tax Group
(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']);
Reply


Messages In This Thread
Quotation Not Showing tax Group - by daveparrish - 03-01-2016, 08:15 AM
RE: Quotation Not Showing tax Group - by daveparrish - 03-03-2016, 03:29 AM

Forum Jump:


Users browsing this thread: 1 Guest(s)