[WebERP-developers] Fxprice, Fxnet and Display total variance

[ExsonQu <hex...@gm...>]

*Dear all,*

          We found a  problem that the sum of invoice of line total is not
absolutely equal with the Display total amount of Invoice when foreign
exchange rate is not 1 for foreign currency. 

            The variance come from the transaction price recovered by
stockmoves.price * exchange rate. The price has been got via div by exchange
rate before. 
            The affected lines around 266-267:
           	((1 - stockmoves.discountpercent) * stockmoves.price * " .
$ExchRate . " * stockmoves.qty) AS fxnet,
								(stockmoves.price * " . $ExchRate . ") AS fxprice,
             Total amount are from debtortrans which on line around 1073:
              $DisplayTotal =
locale_number_format($myrow['ovfreight']+$myrow['ovgst']+$myrow['ovamount'],$myrow['decimalplaces']);

            The solution maybe to retrieve price from sales orders directly.
But there is risk for this. Since we have no features to prevent from sales
orders deleting after goods delivered. And there maybe other potential
problem for this. 
             Any comments are highly appreciated for this.

            Thanks and best regards!

            Exson

                 




--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Fxprice-Fxnet-and-Display-total-variance-tp4657671.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.