[WebERP-developers] Is the write off variance correctly defined in suppliers invoice?

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

*Dear all,*

              Thank you for your long time efforts to webERP.
              
              When I studied the suppliers invoice scripts, I found that the
WriteOffVariance is based on Current Quantity On Hand (The supplier's
*invoice input date*):
      
              ($EnteredGRN->This_QuantityInv - $TotalQuantityOnHand) *
(($EnteredGRN->ChgPrice /  $_SESSION['SuppTrans']->ExRate) -
$EnteredGRN->StdCostUnit);
               The TotalQuantityOnHand is from following sql:
              	$sql ="SELECT SUM(quantity) FROM locstock WHERE stockid='" .
$EnteredGRN->ItemCode . "'";
              But the Period GL posted is up to the *invoice date* input by
users. 
              I think it make sense if suppliers' *invoice date* and *input
date* within the same period. 
             But does it still make sense if the *input date* and *invoice
date *are not within the same period? Need we change it to the historical
(invoice date) QOH? 
             
             Any comments are highly appreciated!

             Thanks and best regards!

             Exson

             

              



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Is-the-write-off-variance-correctly-defined-in-suppliers-invoice-tp4658329.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.