[WebERP-developers] tax.php: Error in tax amount displayed in report.

[Rafael C. <raf...@gm...>]

Hi,

In tax.php (line 46) we have:

(debtortrans.ovamount+debtortrans.ovfreight)/debtortrans.rate AS netamount,
debtortrans.ovfreight/debtortrans.rate AS freightamount,
debtortranstaxes.taxamount/debtortrans.rate AS tax

***dividing by exchange rate***

but
In ConfirmDispatch_Invoice.php (line  830) we use: $SQL = "INSERT INTO
debtortranstaxes.taxamount VALUES ('" .
$TaxAmount/$_SESSION['CurrencyRate'] . "')";
In ConfirmDispatch_Invoice.php (line 1615) we use: $SQL = "INSERT INTO
gltrans.amount VALUES ('" .
round((-$TaxAmount/$_SESSION['CurrencyRate']),$_SESSION['CompanyRecord']['decimalplaces'])
. "')";
In CounterReturns.php (line  965) we use: $SQL = "INSERT INTO
debtortranstaxes.taxamount VALUES ('" . -$TaxAmount/$ExRate . "')";
In CounterReturns.php (line 1428) we use: $SQL = "INSERT INTO
gltrans.amount VALUES ('" . ($TaxAmount/$ExRate) . "')";
In CounterSales.php (line 1383) we use: $SQL = "INSERT INTO
debtortranstaxes.taxamount VALUES ('" . $TaxAmount/$ExRate . "')";
In CounterSales.php (line 1885) we use: $SQL = "INSERT INTO gltrans.amount
VALUES ('" . (-$TaxAmount/$ExRate) . "')";
In Credit_Invoice.php (line 644) we use: $SQL = "INSERT INTO
debtortranstaxes.taxamount VALUES ('" .
(-$TaxAmount/$_SESSION['CurrencyRate']) . "')";
In RecurringSalesOrdersProcess.php (line 692) we use: $SQL = "INSERT INTO
debtortranstaxes.taxamount VALUES ('" .
filter_number_format($Tax['FXAmount']/$CurrencyRate) . "')";
In SelectCreditItems.php (line 1178) we use: $SQL = "INSERT INTO
debtortranstaxes.taxamount VALUES ('" .
-$TaxAmount/$_SESSION['CurrencyRate'] . "')";
In SupplierCredit.php (line 1158) we use: $SQL = "INSERT INTO
supptranstaxes.taxamount VALUES ('" . -$TaxTotals->TaxOvAmount . "')";
In SupplierInvoice.php (1514) we use: $SQL = "INSERT INTO
supptranstaxes.taxamount VALUES ('" . $TaxTotals->TaxOvAmount . "')";

I guess it must be corrected to:

(debtortrans.ovamount+debtortrans.ovfreight)/debtortrans.rate AS netamount,
debtortrans.ovfreight/debtortrans.rate AS freightamount,
debtortranstaxes.taxamount AS tax

***NOT dividing by exchange rate***

Also, I have also doubt to what it serves the field debtortrans.ovgst. What
is the difference between tax saved in debtortrans.ovgst and
debtortranstaxes.taxamount? Is it exchange rate?

Best regards, Rafael Chacon.